nitsArb vs BSC
Updated 2022-07-04Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with a as
(SELECT date(block_timestamp) as day, sum(amount_usd) as total_transfer_usd, sum(total_transfer_usd) over (order by day) as cumulative_amt_usd , 'arbitrum' as type from arbitrum.core.ez_eth_transfers
where date(block_timestamp) >= CURRENT_DATE-7 and date(block_timestamp) != CURRENT_DATE
GROUP by 1 ),
b as
(SELECT date(block_timestamp) as day, sum(amount_usd) as total_transfer_usd, sum(total_transfer_usd) over (order by day) as cumulative_amt_usd, 'bsc' as type from bsc.core.ez_bnb_transfers
where date(block_timestamp) >= CURRENT_DATE-7 and date(block_timestamp) != CURRENT_DATE
GROUP by 1 )
SELECT * from b
UNION ALL
SELECT * FROM a
limit 100
Run a query to Download Data