NavidCopy of Copy of Untitled Query
Updated 2022-07-31
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 mints as (
select
block_timestamp,
to_address,
case when symbol is null then 'Unknown' else symbol end as symbol,
amount,
amount_usd
from
polygon.udm_events
where
event_type = 'erc20_transfer' and
origin_address = '0x0000000000000000000000000000000000000000' and
from_address = '0x0000000000000000000000000000000000000000' and
block_timestamp > CURRENT_DATE - 30 and
symbol = 'WETH' and
amount > 0 and event_id is not null
), transfers as (
select
ue.block_timestamp,
ue.from_address,
ue.symbol,
ue.amount,
ue.amount_usd,
mints.symbol as minted_symbol,
case when ue.to_label is null then 'Unknown' else ue.to_label end as to_label
from
polygon.udm_events ue join mints on ue.from_address = mints.to_address and ue.symbol=mints.symbol
where
ue.block_timestamp >= mints.block_timestamp
), res as (
select
minted_symbol,
to_label,
amount_usd,
lead(to_label, 1) over (partition by from_address order by block_timestamp asc) as lead_to_label
from transfers
Run a query to Download Data