mlhWhat do wallets do when they first come to Osmosis?
    Updated 2023-01-04
    SELECT date_trunc('month', min_time) as month,
    action_type,
    count(*)
    FROM (SELECT min_time,
    'swap' as action_type
    FROM osmosis.core.fact_swaps
    LEFT OUTER JOIN (SELECT tx_from,
    min(BLOCK_TIMESTAMP) as min_time
    FROM osmosis.core.fact_transactions
    GROUP by 1
    )ON trader = tx_from
    AND min_time = BLOCK_TIMESTAMP
    WHERE NOT tx_from is NULL

    UNION

    SELECT min_time,
    'staking' as action_type
    FROM osmosis.core.fact_staking
    LEFT OUTER JOIN (SELECT tx_from,
    min(BLOCK_TIMESTAMP) as min_time
    FROM osmosis.core.fact_transactions
    GROUP by 1
    )ON TX_CALLER_ADDRESS = tx_from
    AND min_time = BLOCK_TIMESTAMP
    WHERE NOT tx_from is NULL

    UNION

    SELECT min_time,
    'liquidity provider actions' as action_type
    FROM osmosis.core.fact_liquidity_provider_actions
    LEFT OUTER JOIN (SELECT tx_from,
    min(BLOCK_TIMESTAMP) as min_time
    FROM osmosis.core.fact_transactions
    GROUP by 1
    Run a query to Download Data