scottincryptoPolygon Bridging POS Bridge Top Coins
Updated 2021-09-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select
-- block_timestamp
-- , block_id
-- , tx_id
-- , to_address as wallet_address
-- , contract_address
iff(symbol in ('USDC','USDT','WETH','WBTC'), symbol, 'other') as symbol
-- , amount
, sum(amount_usd) as amount_usd
-- , 'mint' as tx_type
-- , to_address
-- , iff(to_address_name is null, 'empty', to_address_name) as to_address_name
-- , iff(to_label is null, 'empty', to_label) as to_label
from polygon.udm_events
where event_type = 'erc20_transfer'
and origin_address = '0x0000000000000000000000000000000000000000'
and from_address = '0x0000000000000000000000000000000000000000'
and event_id is not null
and block_timestamp > getdate() - interval'1 month'
and amount > 0
group by 1
order by 2 desc
Run a query to Download Data