theericstoneDAI/WETH Price from Daily Pool Balances
    Updated 2021-02-08
    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