lagandispenserwallets-profit
Updated 2022-07-17
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 lst_nft as (
select
address
-- LABEL_SUBTYPE
from polygon.core.dim_labels
where LABEL_TYPE='nft'
and (label_subtype = 'token_contract' or label_subtype = 'general_contract')
)
, lst_buyer as (
select
TO_ADDRESS as user
,sum( AMOUNT_USD) as amount_in_usd
from flipside_prod_db.polygon.udm_events u
join lst_nft on lst_nft.address = u.CONTRACT_ADDRESS
where EVENT_NAME='transfer'
and AMOUNT_USD>0
and TO_ADDRESS not in ('0x0000000000000000000000000000000000000000' ,'0x00000000000b69ec332f49b7c4d2b101f93c3bed'
,'0x00000000000b69ec332f49b7c4d2b101f93c3bed','0x00000000000b186ebef1ac9a27c7eb16687ac2a9'
,'0x000000000000000000000000000000000000dead','0x0000000000000000000000000000000000000001')
-- where tx_hash in (select tx_hash from lst_tx)
group by 1
order by 1
)
, lst_seller as (
select
From_ADDRESS as user
,sum( AMOUNT_USD) as amount_in_usd
from flipside_prod_db.polygon.udm_events u
join lst_nft on lst_nft.address = u.CONTRACT_ADDRESS
where EVENT_NAME='transfer'
and AMOUNT_USD>0
and From_ADDRESS not in ('0x0000000000000000000000000000000000000000' ,'0x00000000000b69ec332f49b7c4d2b101f93c3bed'
,'0x00000000000b69ec332f49b7c4d2b101f93c3bed','0x00000000000b186ebef1ac9a27c7eb16687ac2a9'
,'0x000000000000000000000000000000000000dead','0x0000000000000000000000000000000000000001')
-- where tx_hash in (select tx_hash from lst_tx)
Run a query to Download Data