Sbhn_NPtotal axl stats
    Updated 2024-07-20
    with price as (
    select date_trunc('day',recorded_at) as date,
    avg (price) as AXLPrice
    from osmosis.price.dim_prices
    where symbol = 'AXL'
    group by 1)

    select count (distinct tx_id) as txs,
    count (distinct trader) as Users,
    sum (to_amount/pow(10,to_decimal)) as AXL_Amount,
    sum ((to_amount*axlprice)/pow(10,to_decimal)) as USD_Amount
    from osmosis.defi.fact_swaps a
    join price b on a.block_timestamp::date = b.date
    where TX_SUCCEEDED
    and to_currency = 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'

    QueryRunArchived: QueryRun has been archived