TOTAL_TXS | USERS | TOTAL_TX_AMOUNT | AVG_TX_AMOUNT | |
|---|---|---|---|---|
1 | 2827 | 448 | 11132144.9580112 | 324.278160098 |
bobby_danielHempy total transaction amount
Updated 2025-03-21
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
Count(distinct t.*) as total_txs,
Count(distinct t.FROM_ADDRESS) as users,
SUM(t.AMOUNT_USD) AS Total_tx_amount,
AVG(t.AMOUNT_USD) AS Avg_tx_amount
FROM base.core.ez_decoded_event_logs e
Left Join base.core.ez_token_transfers t ON e.tx_hash = t.tx_hash
WHERE t.contract_address = LOWER('0xe18c07D858fB1bbF8c06fD78c13b86AfD3d04e28')
AND e.tx_status = 'SUCCESS'
AND t.AMOUNT_USD IS NOT NULL
AND t.block_timestamp >= '2024-08-24'
Last run: 2 months ago
1
43B
88s