theericstonechain or pizza
Updated 2023-12-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
-- 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