badboyUntitled Query
Updated 2022-12-22
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 eth_price
as (
SELECT
hour::date as p_date,
avg(price) as eth_price
FROM ethereum.core.fact_hourly_token_prices
WHERE symbol = 'WETH'
AND p_date > CURRENT_DATE - 180
GROUP by 1
)
SELECT
BLOCK_TIMESTAMP::DATE as date,
CASE
WHEN CONTRACT_ADDRESS = '0x6b175474e89094c44da98b954eedeac495271d0f' THEN 'Withdaw DAI'
WHEN CONTRACT_ADDRESS = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' THEN 'Withdaw WETH'
WHEN CONTRACT_ADDRESS = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' THEN 'Withdaw USDC'
WHEN CONTRACT_ADDRESS = '0xdac17f958d2ee523a2206206994597c13d831ec7' THEN 'Withdaw USDT'
END as status,
Run a query to Download Data