TRANSACTIONS | USERS | GAS_FEE_VOLUME | AVG_GAS_FEE | |
|---|---|---|---|---|
1 | 1059107540 | 824774 | 2192583.353034 | 0.002070217868 |
jackguySei activty 2
Updated 2024-01-29
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
-- date_trunc('day', block_timestamp) as day,
count(DISTINCT tx_id) as transactions,
count(DISTINCT tx_from) as users,
sum(CAST(REPLACE(FEE, 'usei', '') AS NUMBER) / power(10, 6)) as gas_fee_volume,
avg(CAST(REPLACE(FEE, 'usei', '') AS NUMBER) / power(10, 6)) as avg_gas_fee
FROM sei.core.fact_transactions
WHERE block_timestamp > '2023-05-30'
Last run: about 1 year agoAuto-refreshes every 3 hours
1
51B
54s