MLDZMN2024-01-12 02:56 AM
    Updated 2024-01-11
    select

    *

    from external.defillama.dim_pools
    where chain = 'NEAR'
    and PROTOCOL = 'ref-finance'


    -- select distinct s.Pool_id,
    -- symbol,
    -- count(distinct tx_hash)
    -- from near.defi.ez_dex_swaps s
    -- left join pools p on s.Pool_id=p.Pool_id
    -- where PLATFORM ilike '%ref-finance%'
    -- group by 1,2
    -- order by 3 desc
    QueryRunArchived: QueryRun has been archived