theericstoneBounty and Hunts - Total Paid USD copy
    -- forked from flipsidecrypto / Bounty and Hunts - Total Paid USD @ https://flipsidecrypto.xyz/flipsidecrypto/q/2023-04-12-11-57-am-0BhlsA

    WITH prices AS (
    SELECT
    date_trunc('day', recorded_at) as day,
    symbol,
    avg(price) AS price
    FROM FLIPSIDE_PROD_DB.SILVER.PRICES_V2
    WHERE recorded_at::DATE between '2022-01-01' and '2022-11-28'
    AND name in ('Algorand', 'Anchor Protocol', 'Avalanche', 'Axelar', 'Celo', 'Cosmos', 'Curve DAO Token', 'Curve DAO', 'Dai', 'Ethereum', 'Flow', 'Friends With Benefits Pro', 'Gnosis', 'Injective', 'JUNO', 'Kujira', 'Lido DAO', 'NEAR Protocol', 'Polkadot', 'Polygon', 'Optimism', 'Osmosis', 'Ribbon Finance', 'Secret', 'Solana', 'Sushi', 'SushiSwap', 'Synthetix', 'Terra', 'TerraUSD', 'THORChain', 'Uniswap', 'USD Coin' )
    GROUP BY day, symbol
    UNION

    SELECT
    hour::DATE AS day,
    upper(symbol) AS symbol,
    avg(price) AS price
    from CROSSCHAIN.CORE.EZ_HOURLY_PRICES p
    WHERE hour::DATE >= '2022-11-29'
    AND token_address IN ('0xa693b19d2931d498c5b318df961919bb4aee87a5', --ANC
    '0x2c89bbc92bd86f8075d1decc58c7f4e0107f286b', --AVAX
    '0xd533a949740bb3306d119cc777fa900ba034cd52', --CRV
    '0x6b175474e89094c44da98b954eedeac495271d0f', --DAI
    '0x35bd01fc9d6d5d81ca9e055db88dc49aa2c699a8', --FWB
    '0x6810e776880c02933d47db1b9fc05908e5386b96', --GNO
    '0xe28b3b32b6c345a34ff64674606124dd5aceca30', --INJ
    '0x96543ef8d2c75c26387c1a319ae69c0bee6f3fe7', --KUJI
    '0x5a98fcbea516cf06857215779fd812ca3bef1b32', --LDO
    '0xbd31ea8212119f94a611fa969881cba3ea06fa3d', --LUNA
    '0x0000000000000000000000000000000000001010', --MATIC
    '0x4200000000000000000000000000000000000042', --OP
    '0x6123b0049f904d730db3c36a31167d9d4121fa6b', --RBN
    '0x2d0deab7eb3235bebd7e17d1c97a0512a2c6d41d', --SIE
    '0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f', --SNX
    '0x6b3595068778dd592e39a122f4f5a5cf09c90fe2', --SUSHI
    Run a query to Download Data