articoloquintotigris trade
Updated 2022-11-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
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