kasadeghUntitled Query
    Updated 2022-08-01
    WITH Data_Opensea AS(
    SELECT
    DATE(block_timestamp) as date,
    tx_id AS id,
    MAX(IFF(event_inputs:to != '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073' AND event_inputs:from != '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d', event_inputs:value / 1e18, 0)) as price,
    MAX(IFF(event_inputs:to = '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073', event_inputs:value / 1e18, 0)) as fee
    --MAX(IFF(event_inputs:to != '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073' AND event_inputs:from != '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d', event_inputs:to::string, '')) as buyer,
    --MAX(IFF(event_inputs:to != '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073' AND event_inputs:from != '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d', event_inputs:from::string, '')) as seller,
    FROM polygon.events_emitted
    WHERE event_name = 'Transfer' AND tx_to_address = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'
    GROUP BY 1,2
    ),



    SELECT sum(fee) AS USD_Fee
    FROM Data_Opensea o JOIN ETH_Price e ON o.date=e.date

    Run a query to Download Data