nilofrom axl
Updated 2022-09-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
date_trunc('hour',block_timestamp) as daily,
sum(TO_AMOUNT /1e6) as Volume_to_AXL,
count(distinct TX_ID) as TXN,
count(distinct TRADER) as Users,
LABEL as Type,
sum (Volume_to_AXL) over (partition by Type order by daily ) as cum_Volume,
sum (TXN) over (partition by Type order by daily ) as cum_TXN,
sum (Users) over (partition by Type order by daily ) as cum_Users
from osmosis.core.dim_labels join osmosis.core.fact_swaps
where FROM_CURRENCY = address and TO_CURRENCY = 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'
group by daily,LABEL
Run a query to Download Data