BaseeUSD Price
Updated 2025-02-01
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
›
⌄
WITH contract_info AS (
SELECT * FROM (
VALUES
-- HIGH MC
('0xcfa3ef56d303ae4faaba0592388f19d7c3399fb4', ' eUSD', 'Electronic' )
) AS t (contract_address, token_name, twitter)
)
SELECT
hour::date as date,
c.contract_address AS token_address,
avg(p.price) as price
FROM contract_info c
JOIN base.price.ez_prices_hourly p
ON LOWER(c.contract_address) = p.token_address
where hour::date > '2023-01-01'
group by 1,2
QueryRunArchived: QueryRun has been archived