yolo_gamesGas Costs MOD ETH
Updated 2024-08-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT day, SUM("Gas Cost") as "Gas Cost" FROM (
SELECT DATE_TRUNC('day', block_timestamp) as day,SUM(TX_FEE_PRECISE + value) as "Gas Cost" FROM blast.core.fact_transactions
WHERE FROM_ADDRESS = LOWER('0x8A2C35215313e435548870fDfA702d14426fe12a')
AND TO_ADDRESS NOT IN (LOWER('0xe77da411d79c620c67fb0afbcd73e3937c9361bc'), LOWER('0x313b86daaa3ffa72999253f0c0dc4bf4db521335'), LOWER('0xfb6fc60941e48e9d9c9fef802135b28f85f1e891'), LOWER('0xe77da411d79c620c67fb0afbcd73e3937c9361bc'))
GROUP BY 1
)
GROUP BY 1
ORDER BY 1 ASC
QueryRunArchived: QueryRun has been archived