ArioDaily $POPCAT Price
Updated 2025-01-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
with POPCAT as (
SELECT
date_trunc(day, hour) AS date,
avg(price) AS POPCAT_Price
FROM solana.price.ez_prices_hourly
WHERE
token_address = '7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr'
group by 1
),
SOL as (
select
date_trunc(day,hour) as date,
avg(price) as SOL_Price
from solana.price.ez_prices_hourly
where token_address = 'So11111111111111111111111111111111111111112'
group by 1
)
select
*,
POPCAT_Price/SOL_Price as POPCAT_Price_in_SOL
from POPCAT join SOL using(date)
QueryRunArchived: QueryRun has been archived