dan-smithCurve frxETH LP Owned by Frax
    Updated 2023-05-18
    WITH
    dates AS (
    SELECT
    *
    FROM (
    SELECT
    dateadd(
    day
    ,'-' || row_number() over (order by null)
    ,dateadd(day, '+1', date_trunc('day',current_timestamp()))
    ) as dt
    FROM table (GENERATOR(rowcount => 3000))
    )
    WHERE dt >= '2022-10-13'
    ),

    pool AS (
    SELECT
    date_trunc('day',dt) AS dt
    ,SUM(amount) AS total_lp
    FROM (
    SELECT
    block_timestamp AS dt
    ,amount
    ,'mint' AS action
    FROM ethereum.core.ez_token_transfers
    WHERE
    contract_address = lower('0xf43211935C781D5ca1a41d2041F397B8A7366C7A')
    AND from_address = '0x0000000000000000000000000000000000000000'
    UNION ALL
    SELECT
    block_timestamp AS dt
    ,-amount
    ,'burn' AS action
    FROM ethereum.core.ez_token_transfers
    WHERE
    Run a query to Download Data