Afonso_DiazTop pairs
Updated 2025-04-29
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with
stablecoins as (
select
'0x900101d06a7426441ae63e9ab3b9b0f63be145f1' as token_address
union all
select
'0xa4151b2b3e269645181dccf2d426ce75fcbdeca9' as token_address
),
pricet as (
select
hour::date as date,
token_address,
avg(price) as token_price_usd
from
core.price.ez_prices_hourly
where
token_address not in ('0x000734cf9e469bad78c8ec1b0deed83d0a03c1f8', lower('0x5832f53d147b3d6Cd4578B9CBD62425C7ea9d0Bd'), '0x40375c92d9faf44d2f9db9bd9ba41a3317a2404f', '0xeab3ac417c4d6df6b143346a46fee1b847b50296', '0xe04d21d999faedf1e72ade6629e20a11a1ed14fa', '0x782e2b85fda9a8224c17b191fc5de1e085a962b2', '0x8034ab88c3512246bf7894f57c834dddbd1de01f', '0xbb4a26a053b217bb28766a4ed4b062c3b4de58ce', '0x5b1fb849f1f76217246b8aaac053b5c7b15b7dc3', '0x70727228db8c7491bf0ad42c180dbf8d95b257e2')
group by 1, 2
union all
select
hour::date as date,
'0x40375c92d9faf44d2f9db9bd9ba41a3317a2404f' as token_address,
avg(price) as token_price_usd
from
crosschain.price.ez_prices_hourly
where
token_address is null
and symbol = 'CORE'
and blockchain = 'core'
group by 1, 2
QueryRunArchived: QueryRun has been archived