rahoBlast Claim Fees API
Updated 2024-04-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
-- 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) AS total_claim_fees
FROM blast.core.fact_transactions
WHERE to_address = '0x52629961f71c1c2564c5aa22372cb1b9fa9eba3e'
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived