articoloquintotigris trade
    Updated 2022-11-07
    select date, volume, sum(volume) over (order by date asc) as "CUMULATIVE VOLUME" from(
    select distinct(date) as date, sum(volume) as volume from(
    select distinct(date) as date, sum(volume) as volume from(
    select date_trunc(day, block_timestamp) as date, sum(raw_amount/10e18)*1000 as volume from polygon.core.fact_token_transfers
    where to_address = '0x5df98aa475d8815df7cd4fc4549b5c150e8505be'
    and origin_to_address in ('0xcde587e333327fbf887548b3eaf111fb50d38388', '0xb173fde7b7d419514d8b3f8e854e978ea93b1c50', '0x591a4e2adba199bdb08f28d00a1756f4c245bdf7')
    group by 1
    UNION
    select date_trunc(day, block_timestamp) as date, sum(raw_amount/10e18)*2000 as volume from polygon.core.fact_token_transfers
    where to_address = '0x5df98aa475d8815df7cd4fc4549b5c150e8505be'
    and origin_to_address in ('0xb7260e90181cb2df86e61d614c44b30721cc6531', '0x38889a19893ed9129a2f017a3f60ecbed6dbe5aa', '0x2381e421ee2a89ea627f971e8fdfa4ffa81c2cdd', '0x59146c7b9f6ac39fdaf332345f6793489ee66c8a', '0x6041d9aa002969e50e95135c35f20ade73867628')
    group by 1)
    group by 1
    UNION
    select date_trunc(day, block_timestamp) as date, sum(raw_amount/10e18)*1000 as volume from arbitrum.core.fact_token_transfers
    where to_address = '0x303c470c0e0342a1ccdd70b0a17a14b599ff1474'
    and origin_to_address in ('0x0cc23bf1761c85e010d257f02fd638d4e4221579', '0xdde031307c185ab3fa1b51874f4ee57841b20292', '0x9c370d807cdb4e12a8558d9a5167f7d4b003c583')
    group by 1)
    group by 1)
    order by 1 asc
    Run a query to Download Data