HOUR | TX_COUNT | CUM_TX_XOUNT | DEPOSITOR_COUNT | FEE_PAID | CUMFEE_PAID | |
|---|---|---|---|---|---|---|
1 | 2024-02-13 22:00:00.000 | 61 | 177175 | 55 | 0.2079933973 | 489.937409691 |
2 | 2024-02-13 21:00:00.000 | 49 | 177114 | 46 | 0.1584355612 | 489.729416293 |
3 | 2024-02-13 20:00:00.000 | 103 | 177065 | 96 | 0.3037637071 | 489.570980732 |
4 | 2024-02-13 19:00:00.000 | 126 | 176962 | 119 | 0.3516889175 | 489.267217025 |
5 | 2024-02-13 18:00:00.000 | 30 | 176836 | 27 | 0.09978457285 | 488.915528107 |
6 | 2024-02-13 17:00:00.000 | 57 | 176806 | 57 | 0.1968082112 | 488.815743535 |
7 | 2024-02-13 16:00:00.000 | 48 | 176749 | 47 | 0.1826445834 | 488.618935323 |
8 | 2024-02-13 15:00:00.000 | 47 | 176701 | 45 | 0.1869600945 | 488.43629074 |
9 | 2024-02-13 14:00:00.000 | 31 | 176654 | 26 | 0.166381743 | 488.249330646 |
10 | 2024-02-13 13:00:00.000 | 79 | 176623 | 79 | 0.2382029632 | 488.082948902 |
11 | 2024-02-13 12:00:00.000 | 45 | 176544 | 45 | 0.1317283311 | 487.844745939 |
12 | 2024-02-13 11:00:00.000 | 68 | 176499 | 65 | 0.1529649513 | 487.713017608 |
13 | 2024-02-13 10:00:00.000 | 90 | 176431 | 89 | 0.2200384 | 487.560052657 |
14 | 2024-02-13 09:00:00.000 | 99 | 176341 | 98 | 0.2489431999 | 487.340014257 |
15 | 2024-02-13 08:00:00.000 | 73 | 176242 | 72 | 0.156598361 | 487.091071057 |
16 | 2024-02-13 07:00:00.000 | 85 | 176169 | 84 | 0.1572170753 | 486.934472696 |
17 | 2024-02-13 06:00:00.000 | 257 | 176084 | 254 | 0.3945207594 | 486.777255621 |
18 | 2024-02-13 05:00:00.000 | 88 | 175827 | 87 | 0.1625180726 | 486.382734861 |
19 | 2024-02-13 04:00:00.000 | 89 | 175739 | 87 | 0.1785292702 | 486.220216789 |
20 | 2024-02-13 03:00:00.000 | 79 | 175650 | 78 | 0.2052220798 | 486.041687519 |
freemartianHourly General Infos
Updated 2024-02-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
date_trunc('hour',block_timestamp) AS hour,
COUNT(tx_hash) AS tx_count,
SUM(tx_count) OVER (ORDER BY hour ASC) cum_tx_xount,
COUNT(DISTINCT from_address) AS depositor_count,
SUM(tx_fee) AS fee_paid,
SUM(fee_paid) OVER (ORDER BY hour ASC) cumfee_paid
FROM ethereum.core.fact_transactions
WHERE to_address = lower('0x5f6ae08b8aeb7078cf2f96afb089d7c9f51da47d')
AND origin_function_signature IN ('0xf6326fb3','0x0a553dcb','0x3265aead','0xf688bcfb','0x365833e1')
AND block_timestamp::date >= '2023-11-20'
AND from_address <> '0x0000000000000000000000000000000000000000'
GROUP BY 1
ORDER BY 1 DESC
Last run: about 1 year agoAuto-refreshes every 3 hours
...
2042
136KB
65s