alitaslimiAvalanche Transactions Daily
Updated 2022-10-26Copy Reference Fork
999
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,
CASE
WHEN token_address = '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599' THEN 'BTC.b'
WHEN token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' THEN 'WETH.e'
WHEN token_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' THEN 'USDC'
WHEN token_address = '0xdac17f958d2ee523a2206206994597c13d831ec7' THEN 'USDt'
WHEN token_address = '0x85f138bfee4ef8e540890cfb48f620571d67eda3' THEN 'AVAX'
WHEN token_address = '0x6b175474e89094c44da98b954eedeac495271d0f' THEN 'DAI.e'
WHEN token_address = '0x514910771af9ca656af840dff83e8264ecf986ca' THEN 'Link.e'
END as token,
AVG(price) AS price
FROM
ethereum.core.fact_hourly_token_prices
WHERE
hour::date BETWEEN (CURRENT_DATE - 91) AND (CURRENT_DATE - 1)
AND token_address IN (
'0x2260fac5e5542a773aa44fbcfedf7c193bc2c599', -- WBTC
'0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2', -- WETH
'0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48', -- USDC
'0xdac17f958d2ee523a2206206994597c13d831ec7', -- USDT
'0x85f138bfee4ef8e540890cfb48f620571d67eda3', -- AVAX
'0x6b175474e89094c44da98b954eedeac495271d0f', -- DAI
'0x514910771af9ca656af840dff83e8264ecf986ca' -- LINK
)
GROUP BY
date,
token
UNION
SELECT
hour::date AS date,
CASE
WHEN token_address = '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599' THEN 'WBTC.e'
WHEN token_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' THEN 'USDC.e'
Run a query to Download Data