maytsuTop 5 LUNC transfer destinations by USD amount since 2022-01-01 copy
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
›
⌄
-- forked from Kaka / Top 5 LUNC transfer destinations by USD amount since 2022-01-01 @ https://flipsidecrypto.xyz/Kaka/q/top-5-lunc-transfer-destinations-by-number-of-transfer-since-2022-01-01-6IxYAL
--terra19scdgmvhj5rl7f66n06z5pescf0gmeysw6pjrz
select event_to,
case when event_to = 'terra1ncjg4a59x2pgvqy9qjyqprlj8lrwshm0wleht5' then 'Binance Wallet'
when event_to = 'terra13s4gwzxv6dycfctvddfuy6r3zm7d6zklynzzj5' then 'OKX Wallet'
when event_to = 'terra1t28h4fg8gjpggvq985d2zz569qj8hpxnsxcx93' then 'UpBit Exchange'
when event_to = 'terra14l46jrdgdhaw4cejukx50ndp0hss95ekt2kfmw' then 'Kucoin Deposits'
when event_to = 'terra1luagdjcr9c9yvp3ak4d7chjm5gldcmgln5rku5' then 'FTX Wallet'
when event_to = 'terra13yxhrk08qvdf5zdc9ss5mwsg5sf7zva9xrgwgc' then 'Terra Asset Bridge-ETH'
when event_to = 'terra18vnrzlzm2c4xfsx382pj2xndqtt00rvhu24sqe' then 'Binance - Main/Withdraw'
else address_name end as address_name_,
count (distinct tx_id) as total_tx,
sum (event_amount) as total_amount,
sum (event_amount_usd) as total_amount_usd,
row_number() over (order by total_amount_usd desc) as row_number
from terra.classic.ez_transfers A left join terra.classic.dim_labels B on A.event_to = B.address
where tx_status = 'SUCCEEDED'
and event_currency = 'LUNA'
and block_timestamp >= '2022-05-01'
and event_amount > 0
group by 1,2
order by 6 ASC
limit 5
Run a query to Download Data