rmasFloorDAO - FLOOR Tokens - Past 90 days summary
    Updated 2022-07-05
    WITH

    staking_transactions AS (
    SELECT
    tx_hash
    , block_timestamp
    , from_address AS wallet
    , 'Stake' AS action
    , raw_amount / pow(10, 9) AS amount
    FROM ethereum.core.ez_token_transfers
    WHERE block_timestamp >= CURRENT_TIMESTAMP - interval '90 days'
    AND to_address = '0x759c6de5bca9ade8a1a2719a31553c4b7de02539' -- FloorStaking contract
    AND contract_address = '0xf59257e961883636290411c11ec5ae622d19455e' -- FLOOR token
    ),


    unstaking_transactions AS (
    SELECT
    tx_hash
    , block_timestamp
    , to_address AS wallet
    , 'Unstake' AS action
    , raw_amount / pow(10, 9) AS amount
    FROM ethereum.core.ez_token_transfers
    WHERE block_timestamp >= CURRENT_TIMESTAMP - interval '90 days'
    AND from_address = '0x759c6de5bca9ade8a1a2719a31553c4b7de02539' -- FloorStaking contract
    AND contract_address = '0xf59257e961883636290411c11ec5ae622d19455e' -- FLOOR token
    ),


    floor_to_eth_swaps AS (
    SELECT
    ev.tx_hash
    , ev.block_timestamp
    Run a query to Download Data