rcepdaPool Balances
Updated 2023-07-06Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT date_trunc('month', block_timestamp) as metric_date,
symbol,
contract_address,
avg(current_bal_usd) as balance,
label,
address_name,
address
FROM ethereum.core.ez_balance_deltas INNER JOIN ethereum.core.dim_labels ON ethereum.core.ez_balance_deltas.user_address = ethereum.core.dim_labels.address
WHERE
-- the user address is the Curve Liquidty Pool
--user_address = '0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7' AND
-- the contract address is the USDC proxy contract
--contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' AND
block_timestamp >= getdate() - interval '24 months'
and label_subtype='pool' AND current_bal_usd > 500000
GROUP BY metric_date, symbol, contract_address,label,address_name ,address
Run a query to Download Data