roketo16
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
--credit : https://app.flipsidecrypto.com/velocity/queries/6ffe7ad6-7fe7-4740-87b2-e23974fdbe83
with mintable as (
select tx_from,
min (block_timestamp) as mindate
from osmosis.core.fact_transactions
group by 1)
select project_name,
count (*) as Countt
from osmosis.core.fact_swaps t1 join mintable t2 on t1.trader = t2.tx_from and t1.block_timestamp = t2.mindate
join osmosis.core.dim_tokens on to_currency = address
group by 1
order by 2 DESC
limit 20
Run a query to Download Data