LittlerDataMars protocol liquidity transactions copy
    Updated 2023-03-03
    -- forked from d9328f60-654f-4eae-a53b-eadcb3a3ee35

    select
    date_trunc('day',block_timestamp) date
    ,count(tx_id) liquidity_transactions
    ,action
    from osmosis.mars.ez_liquidity_provider_actions actions
    -- left join osmosis.core.dim_tokens tokens on actions.currency = tokens.address
    where block_timestamp < '2023-03-03'
    group by 1, 3


    Run a query to Download Data