TheLaughingManOverview Redux
Updated 2025-02-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from special gas - over time sam's thing example @ https://flipsidecrypto.xyz/studio/queries/1dd7e264-2516-4e78-89b6-07e76c9e1a99
-- 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
block_timestamp
, tx_hash
, to_address as wallet
, VALUE as amount
, origin_from_address
, origin_to_address
--, 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_timestamp::date between '2025-02-18' and '2025-02-19'
)
SELECT
QueryRunArchived: QueryRun has been archived