ft.block_number,

ft.block_timestamp,

SUM(((ft.EFFECTIVE_GAS_PRICE - (CAST(GET(fb.block_header_json, 'baseFeePerGas') AS FLOAT) / 1e9)) * ft.gas_used) / 1e9) AS Tips

FROM ethereum.core.fact_transactions ft

JOIN ethereum.core.fact_blocks fb ON ft.block_number = fb.block_number

WHERE ft.block_number = 15596838

GROUP BY 1, 2

ORDER BY 1;

SELECT

date_trunc('day',ft.block_timestamp) as dt,

SUM(((ft.gas_price_paid - (CAST(GET(fb.block_header_json, 'baseFeePerGas') AS FLOAT) / 1e9)) * ft.gas_used) / 1e9) AS Tips

FROM arbitrum.core.fact_transactions ft

JOIN arbitrum.core.fact_blocks fb ON ft.block_number = fb.block_number

WHERE ft.block_timestamp >= CAST('2024-01-01' AS TIMESTAMP)

GROUP BY 1

ORDER BY 1;

SELECT

ft.cumulative_gas_used,

ft.gas_price_paid,

CAST(GET(fb.block_header_json, 'baseFeePerGas') AS FLOAT) / 1e9

FROM arbitrum.core.fact_transactions ft

JOIN arbitrum.core.fact_blocks fb ON ft.block_number = fb.block_number

WHERE ft.block_number = 223376250

GROUP BY 1, 2, 3

ORDER BY 1;