nitsHot Pools
    Updated 2022-07-10
    select value, count(DISTINCT tx_id) as total_txs,

    case when value = 1 then 'ATOM/OSMO'
    when value = 678 then 'USDC/OSMO'
    when value = 560 then 'USTC/OSMO'
    when value = 561 then 'LUNC/OSMO'
    when value = 722 then 'EVMOS/OSMO'
    when value = 497 then 'JUNO/OSMO'
    when value = 608 then 'LUM/OSMO'
    when value = 565 then 'LUNC/ATOM'
    when value = 5 then 'DVPN/OSMO'
    when value = 498 then 'ATOM/JUNO' end as contract_name
    from osmosis.core.fact_swaps, table(flatten(input => pool_ids))
    where date(block_timestamp) >= '2022-05-01'
    GROUP by 1
    order by 2 desc
    limit 10
    Run a query to Download Data