Sandeshlido usage
Updated 2022-09-22
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
›
⌄
select
distinct tf.origin_to_address,
dl.address_name,
dl.label_type,
concat(dl.label_type,'-',dl.project_name) as project,
sum(tf.raw_amount/1e18) as amt
from polygon.core.fact_token_transfers tf
inner join polygon.core.dim_labels dl
on tf.origin_to_address = dl.address
where tf.contract_address=lower('0x3A58a54C066FdC0f2D55FC9C89F0415C92eBf3C4')
and origin_to_address!='0x0000000000000000000000000000000000000000'
group by
tf.origin_to_address,
dl.address_name,
dl.label_type,
project
order by amt desc
-- maticx
-- where tf.contract_address=lower('0x7ed6390f38d554B8518eF30B925b46972E768AF8')
-- csmatic
-- where tf.contract_address=lower('0x03A97594aA5ecE130E2E956fc0cEd2fea8ED8989')
-- and tf.contract_address != tf.origin_from_address
Run a query to Download Data