Afonso_Diazby symbol and event
Updated 2024-12-24
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
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', '0xe04d21d999faedf1e72ade6629e20a11a1ed14fa', '0x782e2b85fda9a8224c17b191fc5de1e085a962b2', '0x8034ab88c3512246bf7894f57c834dddbd1de01f', '0xbb4a26a053b217bb28766a4ed4b062c3b4de58ce', '0x5b1fb849f1f76217246b8aaac053b5c7b15b7dc3', '0x70727228db8c7491bf0ad42c180dbf8d95b257e2')
group by 1, 2
union all
select
hour::date as date,
'0x000734cf9e469bad78c8ec1b0deed83d0a03c1f8' as token_address,
avg(price) as token_price_usd
from
ethereum.price.ez_prices_hourly
where
token_address = '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599'
group by 1, 2
union all
select
hour::date as date,
'0xe04d21d999faedf1e72ade6629e20a11a1ed14fa' as token_address,
avg(price) as token_price_usd
from
ethereum.price.ez_prices_hourly
where
token_address = '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599'
group by 1, 2
QueryRunArchived: QueryRun has been archived