brian-terraDupe Testing
Updated 2021-07-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
/*with prices as (
select
symbol
,HOUR
,round(price,4) as price
,ROW_NUMBER() OVER (PARTITION BY symbol, hour ORDER BY symbol) AS dup
from ethereum.token_prices_hourly
where symbol in ('ETH','AAVE','UNI','SUSHI','COMP','YFI','LINK','MKR','SNX','WBTC','DPI','DEFI++')
and hour > '2021-01-01'
order by 1,2)
select distinct symbol from prices
where dup > 1*/
select * from ethereum.token_prices_hourly where hour = '2021-05-30T19:00:00Z' and symbol = 'UNI'
Run a query to Download Data