eslamis-darkatto and from 9
Updated 2022-09-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with from_axl as(select COUNT(DISTINCT TX_ID ) as number_of_swaps,sum(FROM_AMOUNT*price/1e6) as volume
from osmosis.core.fact_swaps , osmosis.core.dim_labels a join osmosis.core.dim_prices b on a.label = b.SYMBOL
where FROM_CURRENCY = 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E' and POOL_IDS[0]=812
)
,
to_axl as(SELECT COUNT(DISTINCT TX_ID ) as number_of_swaps,sum(TO_AMOUNT*price/1e6) as volume
from osmosis.core.fact_swaps , osmosis.core.dim_labels a join osmosis.core.dim_prices b on a.label = b.SYMBOL
where TO_CURRENCY = 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E' and POOL_IDS[0]=812
)
select *,'from_axl_to_other_tokens' as event
from from_axl
UNION
select *,'to_axl_from_other_tokens' as event
from to_axl
Run a query to Download Data