Updated 2022-06-28
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
29
30
31
32
33
34
35
36
›
⌄
----- with help farsi community
with t1 as (
select date(block_timestamp) as date , contract_address ,tx_hash , event_inputs:value as amount
from polygon.core.fact_event_logs
where ORIGIN_TO_ADDRESS = lower('0x059d306a25c4ce8d7437d25743a8b94520536bd5')
and event_name = 'Transfer' and ORIGIN_FUNCTION_SIGNATURE ='0x72ada4c5'),
t2 as ( select date(block_timestamp) as date , contract_address , tx_hash , event_inputs:value as amount
from polygon.core.fact_event_logs
where ORIGIN_TO_ADDRESS = '0x059d306a25c4ce8d7437d25743a8b94520536bd5'
and ORIGIN_FUNCTION_SIGNATURE = '0xded700a6'
and event_name = 'Transfer'
),
t3 as (
select '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' as token ,
6 as float,
'USDC' as symbol
from polygon.core.dim_labels
UNION
select '0xc2132d05d31c914a87c6611c10748aeb04b58e8f' as token ,
6 as float,
'USDT' as symbol
from polygon.core.dim_labels
UNION
select '0x172370d5cd63279efa6d502dab29171933a610af' as token ,
18 as float ,
'CRV' as symbol
from polygon.core.dim_labels
UNION
select '0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6' as token ,
18 as float ,
'BTC' as symbol
from polygon.core.dim_labels
UNION
Run a query to Download Data