special gas - over time sam's thing example

TheLaughingManspecial gas - over time sam's thing example

Updated 2025-02-20

-- forked from special gas - over time sam's thing @ https://flipsidecrypto.xyz/studio/queries/dbb7d373-050f-4062-b84f-76bd7bc97a3e

-- forked from special gas - over time contract interactor @ https://flipsidecrypto.xyz/studio/queries/ffddb2ea-925f-4d70-9ab4-252377940266

-- forked from special gas - over time only orig_func @ https://flipsidecrypto.xyz/studio/queries/618a596f-664b-4202-95a6-e30455821345

-- forked from special gas - over time copy @ https://flipsidecrypto.xyz/studio/queries/44b3d4e4-ed24-4080-823a-8c2bd6be1c46

-- forked from special gas - over time @ https://flipsidecrypto.xyz/studio/queries/f4d9a46a-86d0-400e-a6f8-ae8e30a6c748

-- forked from special gas - overview @ https://flipsidecrypto.xyz/studio/queries/a3005985-08d8-45d0-9508-af694e68c37f

with gas_base as (

SELECT

--, row_number() OVER (partition by to_address ORDER BY tx_hash DESC) as rank

from monad.testnet.fact_traces

WHERE 1=1

AND tx_hash = '0xa02bbee98b05ba24ad34e8db67c2266cb2f4b2905bc27ab83d7b9b8079e16168'

--and origin_from_address = lower('0xc0f2bACAfbc928be652cB6fbd3CaF75D651329b8')

and origin_function_signature = '0x7a53bcfc'

and type = 'CALL'

and input = '0x'

and value > 0

--AND block_number<4000000

)

-- SELECT

-- date_trunc('minute', block_timestamp) as dmin

-- , COUNT(distinct wallet) as users

-- , COUNT(distinct tx_hash) as txns

-- , MAX(tx_hash) as sample1

-- , SUM(amount) as total_mon

-- , SUM(total_mon) OVER (ORDER BY dmin ASC) as mon_cumulative

-- , SUM(users) OVER (ORDER BY dmin ASC) as users_cumulative

-- , SUM(txns) OVER (ORDER by dmin ASC) as txns_total

QueryRunArchived: QueryRun has been archived