0xpibblezFPI Supply
    Updated 2023-02-16
    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