HippynonsenseUntitled Query
Updated 2021-12-09
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
date_trunc('day', balance_date) as metric_date,
symbol,
amount_usd
FROM ethereum.erc20_balances
WHERE
-- the user address is the Curve Liquidty Pool
user_address = '0xa5407eae9ba41422680e2e00537571bcc53efbfd' AND
-- the contract address is the USDC proxy contract
contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' AND
balance_date >= getdate() - interval '1 month'
Run a query to Download Data