theericstoneDAI/WETH Price from Daily Pool Balances
Updated 2021-02-08
99
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
›
⌄
WITH combo AS (
SELECT
balance_date,
contract_address,
balance
FROM gold.ethereum_erc20_balances
WHERE
user_address = '0xa478c2975ab1ea89e8196811f51a7b7ade33eb11' AND --ETH/DAI pool
contract_address IN (
'0x6b175474e89094c44da98b954eedeac495271d0f',
'0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
) AND
balance_date > '2021-02-01'
),
dai AS (
SELECT * FROM combo WHERE contract_address = '0x6b175474e89094c44da98b954eedeac495271d0f'
),
weth AS (
SELECT * FROM combo WHERE contract_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
)
SELECT
dai.balance_date,
dai.balance / weth.balance as eth_dai_price
FROM dai
JOIN weth ON dai.balance_date = weth.balance_date
ORDER BY balance_date
Run a query to Download Data