theericstoneHarvests
    Updated 2021-11-10
    SELECT from_address, from_address_name, SUM(tx_fee) as Amount
    FROM ethereum.transactions as tx

    WHERE (
    (to_address = LOWER('0xc21D353FF4ee73C572425697f4F5aaD2109fe35b') AND (function_name = 'harvest' OR function_name = 'flush') )
    OR
    (to_address = LOWER('0xf3cFfaEEa177Db444b68FB6f033d4a82f6D8C82d') AND function_name = 'harvest')
    OR
    to_address = LOWER('0x8392F6669292fA56123F71949B52d883aE57e225')
    AND
    block_timestamp >= '2021-03-25'
    )

    GROUP BY 1,2 ORDER BY Amount DESC
    limit 500
    Run a query to Download Data