marquAXL Launch - 24h AXL actions
    Updated 2022-12-07
    with

    pool_axl as (

    select

    block_timestamp,
    amount / pow(10,6) as axl,
    case
    when action = 'pool_joined' then 'Deposit'
    else 'Withdraw'
    end as label_action

    from osmosis.core.fact_liquidity_provider_actions
    where pool_id = 812
    and action in ('pool_joined','pool_exited')
    and currency = 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E' -- AXL
    and block_timestamp >= current_timestamp() - interval '24 hours'
    and tx_status = 'SUCCEEDED'
    )

    select *
    from pool_axl
    Run a query to Download Data