TelemennoyerUntitled Query
Updated 2022-10-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
LABEL,
count(tx_id) as "swap count",
count(distinct trader) as "count of users",
sum(FROM_AMOUNT/1e6) as volume
from osmosis.core.fact_swaps,osmosis.core.dim_labels a join osmosis.core.dim_prices b on a.PROJECT_NAME = b.SYMBOL
where FROM_CURRENCY= 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'
and TO_CURRENCY = address
and pool_ids[0]=812
group by 1
order by 4 desc
limit 10
Run a query to Download Data