ZSaedUntitled Query
Updated 2023-01-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
›
⌄
with arb as (select
sum(AMOUNT) as total ,
sum(AMOUNT_USD) as total_usd,
BLOCK_TIMESTAMP::date as day
from arbitrum.core.ez_eth_transfers
where BLOCK_TIMESTAMP::date > '2022-12-01'
GROUP by day
)
, op as (select
sum(AMOUNT) as total ,
sum(AMOUNT_USD) as total_usd,
BLOCK_TIMESTAMP::date as day
from optimism.core.ez_eth_transfers
where BLOCK_TIMESTAMP::date > '2022-12-01'
GROUP by day
)
, total as (select a.total+b.total as optotal , a.day from arb a JOIN op b on a.day = b.day )
, eth as (select
sum(AMOUNT) as total ,
sum(AMOUNT_USD) as total_usd,
BLOCK_TIMESTAMP::date as day
from ethereum.core.ez_eth_transfers
where BLOCK_TIMESTAMP::date > '2022-12-01'
GROUP by day
)
select a.*, b.total from total a JOIN eth b on a.day = b.day
Run a query to Download Data