BaseDAI 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
›
⌄
WITH contract_info AS (
SELECT * FROM (
VALUES
-- HIGH MC
('0x50c5725949a6f0c72e6c4a641f24049a917db0cb', ' DAI' , 'MakerDAO')
) 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