Afonso_DiazGeneral
Updated 2024-06-25
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 prices as (
select
hour::date as date,
iff(token_address = 'wrap.near', 'near', token_address) as token_address,
avg(price) as price_usd
from near.price.ez_prices_hourly
where token_address in (
'blackdragon.tkn.near',
'token.lonkingnearbackto2024.near',
'ftv2.nekotoken.near',
'wrap.near'
)
group by 1, 2
union all
select
block_timestamp::date as date,
token_in_contract,
1 / avg(amount_in) as price_usd
from near.defi.ez_dex_swaps
where
token_in_contract = 'nearnvidia.near'
and token_out_contract in ('usdt.tether-token.near', '17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1')
group by 1, 2
union all
select
block_timestamp::date as date,
token_in_contract,
near_price_usd / avg(amount_in) as price_usd
from near.defi.ez_dex_swaps
join (
select
hour::date as day,
QueryRunArchived: QueryRun has been archived