nitsArb vs BSC
    Updated 2022-07-04
    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