roketo14
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/e88b3287-edaa-4f50-bc21-72ce303e61dc
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 from_currency = address
group by 1
order by 2 DESC
limit 20