mmdrezamost volume bridged
Updated 2022-06-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH tokens_value AS (SELECT sum(amount_usd) AS token_value,date_trunc('day',block_timestamp) AS date
FROM ethereum.core.ez_token_transfers
WHERE (
origin_to_address = lower('0x3e4a3a4796d16c0cd582c382691998f7c06420b6')
OR origin_to_address = lower('0x3666f603cc164936c1b87e207f36beba4ac5f18a')
OR origin_to_address = lower('0x3d4cc8A61c7528fd86c55cfe061a78dcba48edd1')
OR origin_to_address = lower('0x22B1cbb8d98a01a3b71d034bb899775a76eb1cc2')
)AND block_timestamp >= CURRENT_DATE-180
GROUP BY date
ORDER BY token_value ),
eth_value AS (SELECT sum(amount_usd)AS eth_value,date_trunc('day',block_timestamp) AS date2
FROM ethereum.core.ez_eth_transfers
WHERE origin_to_address = '0xb8901acb165ed027e32754e0ffe830802919727f' AND block_timestamp >= CURRENT_DATE-180
GROUP by date2
ORDER BY eth_value )
SELECT (token_value+eth_value) AS most_value_usd,date
FROM eth_value FULL JOIN tokens_value
WHERE date=date2
GROUP BY most_value_usd,date
ORDER BY date asc
Run a query to Download Data