theericstonechain or pizza
    Updated 2023-12-06
    -- this is a dumb query on purpose

    with types as (select
    distinct token_address,
    case when provider = 'coingecko' then '🧱⛓' else '🍕' end as type
    from crosschain.price.fact_hourly_token_prices prices
    where prices.hour > current_date - 2)

    SELECT
    type,
    count(1) as number
    from types
    group by type;
    QueryRunArchived: QueryRun has been archived