DATE | TOTAL_TXNS | USERS | TOTAL_FEES | AVG_FEES | |
|---|---|---|---|---|---|
1 | 2024-10-08 00:00:00.000 | 7819158 | 933266 | 4208.938142 | 0.000538285342 |
2 | 2024-09-10 00:00:00.000 | 6780570 | 989696 | 3836.1219 | 0.000565752127 |
3 | 2024-10-04 00:00:00.000 | 7359989 | 1016899 | 3930.410156 | 0.000534023917 |
4 | 2024-10-09 00:00:00.000 | 7801783 | 1052986 | 4083.052246 | 0.000523348605 |
5 | 2024-10-15 00:00:00.000 | 7218885 | 1061459 | 3944.989596 | 0.000546481845 |
6 | 2024-09-03 00:00:00.000 | 7459650 | 712544 | 4236.101956 | 0.000567868728 |
7 | 2024-09-25 00:00:00.000 | 8384268 | 994666 | 4873.227487 | 0.000581234699 |
8 | 2024-09-02 00:00:00.000 | 7334701 | 697923 | 4187.742135 | 0.000570949264 |
9 | 2024-09-27 00:00:00.000 | 6971423 | 999573 | 4001.194244 | 0.000573942256 |
10 | 2024-09-01 00:00:00.000 | 6950947 | 687617 | 3921.381232 | 0.000564150645 |
11 | 2024-09-23 00:00:00.000 | 7445531 | 992565 | 4603.518286 | 0.00061829281 |
12 | 2024-09-09 00:00:00.000 | 6943671 | 954003 | 3905.029347 | 0.000562386862 |
13 | 2024-10-24 00:00:00.000 | 6835810 | 1039093 | 3743.923432 | 0.000547692729 |
14 | 2024-10-18 00:00:00.000 | 7035321 | 944816 | 3801.487842 | 0.000540343197 |
15 | 2024-09-14 00:00:00.000 | 7135429 | 1006274 | 4009.975073 | 0.000561980937 |
16 | 2024-10-30 00:00:00.000 | 6889608 | 941175 | 3735.47838 | 0.000542190264 |
17 | 2024-09-11 00:00:00.000 | 7047847 | 1015126 | 3898.178138 | 0.000553101981 |
18 | 2024-09-15 00:00:00.000 | 7320831 | 1045848 | 3980.062574 | 0.000543662676 |
19 | 2024-10-31 00:00:00.000 | 6886660 | 926076 | 3714.842298 | 0.000539425832 |
20 | 2024-10-22 00:00:00.000 | 6866383 | 1016624 | 3725.654718 | 0.00054259349 |
feyikemiNEAR Users Daily Txn
Updated 2025-03-31
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
Date_trunc('day', Block_timestamp) AS Date,
COUNT(DISTINCT TX_HASH) AS Total_Txns,
COUNT(DISTINCT Tx_signer) AS Users,
SUM(TRANSACTION_FEE / 1e24) AS Total_fees,
AVG(TRANSACTION_FEE / 1e24) AS Avg_Fees
FROM near.core.fact_transactions
WHERE BLOCK_TIMESTAMP::DATE BETWEEN '{{Start_Date}}' AND '{{End_Date}}'
AND TX_SUCCEEDED = 'true'
GROUP BY Date
Last run: 2 months ago
61
4KB
60s