mattkstewVolume calc 2
Updated 2022-12-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with tab1 as (
select
RECEIVER as Tab1_sender,
currency,
min(block_timestamp) as First_Transfer_Date
from osmosis.core.fact_transfers
where transfer_type like 'IBC_TRANSFER_IN'
and RECEIVER is not null
group by 1,2 )
select
tab1_sender,
count(*)
from tab1
group by 1
order by 2 DESC
limit 100
Run a query to Download Data