alitaslimiAvalanche Transactions Daily
    Updated 2022-10-26
    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