rahoToken Price Backfill
Updated 2024-06-02
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
SELECT
DATE_TRUNC('day', hour) AS day,
name,
symbol,
token_address,
CASE
WHEN token_address IN(
'0xa6b280b42cb0b7c4a4f789ec6ccc3a7609a1bc39',
'0x078540eecc8b6d89949c9c7d5e8e91eab64f6696'
) THEN 18
ELSE decimals
END AS decimals,
AVG(price) AS avg_price
FROM
crosschain.price.ez_prices_hourly
WHERE
token_address IN(
'0xa6b280b42cb0b7c4a4f789ec6ccc3a7609a1bc39',
-- ENJOY
'0x15ac90165f8b45a80534228bdcb124a011f62fee',
-- MOEW
'0x835e336782a1d04db6eb44c44024650d18a138c2',
-- $BAGEL
'0x078540eecc8b6d89949c9c7d5e8e91eab64f6696',
-- IMAGINE
'0xb025ee78b54b5348bd638fe4a6d77ec2f813f4f9',
-- OpUNION
'0x4229c271c19ca5f319fb67b4bc8a40761a6d6299',
-- NEGED
'0xa6b280b42cb0b7c4a4f789ec6ccc3a7609a1bc39',
-- ENJOY
'0x119685fe98f37524e59a3e91f7108d6a693818f3',
-- DEATHOS
-- '0x4200000000000000000000000000000000000006', -- WETH on Zora
'0xd00646c997ac0475208f43d1fe06e17047e2eaa9',
-- BLU