0xpibblezFPI Supply
Updated 2023-02-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
date_trunc('day', last_recorded_price) as date,
symbol,
usd_value_now
FROM ETHEREUM.core.ez_current_balances
WHERE
-- the user address is the FPI Comptroller Contract
user_address = lower('0x6A7efa964Cf6D9Ab3BC3c47eBdDB853A8853C502') AND
-- the contract address is the FXS contract
contract_address = lower('0x3432B6A60D23Ca0dFCa7761B7ab56459D9C964D0')
OR contract_address = lower('0xc2544A32872A91F4A553b404C6950e89De901fdb')
AND
-- monthly interval
last_recorded_price >= getdate() - interval '1 month'
Run a query to Download Data