flipside

    Supreme skull Fees
    nitsSupreme skull Fees
    Updated 2022-04-27
    with fees as
    (SELECT hr, status, sum(tx_fee) as total_eth_spent,sum(total_eth_spent) over (partition by status order by hr) as cumulative_gas
    from
    (SELECT trunc(block_timestamp, 'hour') as hr, * from ethereum_core.fact_transactions
    where to_address = '0x553cb3f9dfb836f0d192545f99987c0bce1cd27c' and (ORIGIN_FUNCTION_SIGNATURE='0x9f41554a' ) )
    group by 1 , 2 )

    SELECT *,total_eth_spent*3000 as total_eth_spent_usd, cumulative_gas*3000 as cumulative_gas_usd
    from fees
    -- SELECT * from ethereum_core.fact_transactions
    -- where tx_hash ilike '0x75cc3d452dd2be3af549dd144ccf7da93d182b280698dd097ef47b6cf74e9755'
    LIMIT 100
    Run a query to Download Data