theericstoneBounty and Hunts - Total Paid USD copy
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
›
⌄
-- 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