nilofrom axl
    Updated 2022-09-29
    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