flipside

    Hot Contracts on Osmosis
    snowmanHot Contracts on Osmosis
    Updated 2022-07-13
    WITH tab1 AS(
    SELECT
    DISTINCT pool_ids[0],
    min(date_trunc('DAY', block_timestamp)) AS date1
    FROM osmosis.core.fact_swaps
    WHERE block_timestamp > '2022-05-01'
    GROUP BY 1 ) SELECT COUNT(*) FROM tab1
    -- Hot Contracts on Osmosis
    Run a query to Download Data