dan-smith2023-04-17 07:06 PM
    Updated 2023-04-17
    SELECT
    SUM(amount) AS total_lp
    FROM (
    SELECT
    block_timestamp
    ,amount
    ,'mint' AS action
    FROM ethereum.core.ez_token_transfers
    WHERE
    contract_address = lower('0xf43211935C781D5ca1a41d2041F397B8A7366C7A')
    AND from_address = '0x0000000000000000000000000000000000000000'
    UNION
    SELECT block_timestamp
    ,-amount
    ,'burn' AS action
    FROM ethereum.core.ez_token_transfers
    WHERE
    contract_address = lower('0xf43211935C781D5ca1a41d2041F397B8A7366C7A')
    AND to_address = '0x0000000000000000000000000000000000000000'
    )
    Run a query to Download Data