hessTotal Numbers
Updated 9 days ago
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 price as ( select hour::date as date,
lower('0x63E37028c1740303e8456962E6ddf98359FE0BDc') as token_address,
avg(price) as avg_price
from sei.price.ez_prices_hourly
where symbol = 'WSEI'
and hour::date = current_date
group by 1
UNION
select hour::date as date,
lower('0x49561C4a905f7acCdaCAec5e3C17113d5f1C5a3b') as token_address,
avg(price) as avg_price
from sei.price.ez_prices_hourly
where symbol = 'ISEI'
and hour::date = current_date
group by 1
UNION
select hour::date as date,
lower('0xD43E6Bf43654A7B4985f87C77686f7900D59F1eD') as token_address,
avg(price) as avg_price
from sei.price.ez_prices_hourly
where token_address = '0x3894085ef7ff0f0aedf52e2a2704928d1ec074f1'
and hour::date = current_date
group by 1
UNION
select hour::date as date,
lower('0x1e3BcEb9AD3dc3f80820d29039C1A46e28d3A573') as token_address,
avg(price) as avg_price
from sei.price.ez_prices_hourly
where token_address = '0xb75d0b03c06a926e488e2659df1a861f860bd3d1'
and hour::date = current_date
group by 1
UNION
select hour::date as date,
lower('0x821A366145dd54c11Dab879abABc8907A084216C') as token_address,
avg(price) as avg_price
from sei.price.ez_prices_hourly