freemartianSwap Count
    Updated 2022-11-17


    select
    block_timestamp::date as day,
    from_currency,
    to_currency,
    project_name,
    count(distinct tx_id) as swap_count
    from osmosis.core.fact_swaps s inner join osmosis.core.dim_labels l on l.address = s.to_currency or l.address = s.from_currency
    where block_timestamp > CURRENT_DATE - 60
    and tx_status = 'SUCCEEDED'
    group by 1, 2, 3, 4
    having swap_count > 50

    Run a query to Download Data