raho2024-04-09 04:58 PM
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
WITH all_boost_tx AS (
SELECT
t.*,
p.price AS eth_price
FROM blast.core.fact_transactions t
-- LEFT JOIN blast.price.ez_hourly_token_prices p ON DATE_TRUNC('hour', t.block_timestamp) = p.hour
-- WHERE p.token_address = '0x4300000000000000000000000000000000000004'
AND t.to_address = '0x52629961f71c1c2564c5aa22372cb1b9fa9eba3e'
)
SELECT
SUM(tx_fee_precise)
FROM all_boost_tx