MrftiTop 100 USDC net outflow addresses
Updated 2022-10-07
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 out_tbl AS
(
select
sum(amount) as sent_volume,
tx_to as sender_address
from
solana.core.fact_transfers
where date_trunc(day, block_timestamp) >= '2022-08-26'
and mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
group by sender_address
order by sent_volume desc
),
in_tbl AS
(
select
sum(amount) as received_volume,
tx_from as receiver_address
from
solana.core.fact_transfers
where date_trunc(day, block_timestamp) >= '2022-08-26'
and mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
group by receiver_address
order by received_volume desc
)
SELECT receiver_address,
sent_volume - received_volume as net_out_volume
from out_tbl join in_tbl on receiver_address=sender_address
group by receiver_address, net_out_volume
order by net_out_volume DESC
limit 100
Run a query to Download Data