Number of Daily users | Total Fee | Average Fee | Maximum Fee Paid | Minimum Fee Paid | Label | |
|---|---|---|---|---|---|---|
1 | 4929733 | 11556.861356129 | 0.0001145101051 | 0.9876405634 | 0 | After Bedrock |
2 | 2610796 | 12747.719800139 | 0.0001663040585 | 0.3517620239 | 0.00001553573167 | Before Bedrock |
freemartianBedrock Total Comparison
Updated 2024-01-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
with dates as (
select
timestampdiff('day', '2023-06-06 16:00:00.000', current_date) as X_days_after_bedrock,
'2023-06-06 16:00:00.000' as Bedrock_live,
current_date - (2*X_days_after_bedrock) as X_days_before_bedrock
)
SELECT
COUNT(DISTINCT from_address) AS "Number of Daily users",
SUM(tx_fee) AS "Total Fee",
AVG(tx_fee) AS "Average Fee",
MAX(tx_fee) AS "Maximum Fee Paid",
MIN(tx_fee) AS "Minimum Fee Paid",
(CASE
WHEN block_timestamp < '2023-06-06 16:00:00.000' THEN 'Before Bedrock'
when block_timestamp > '2023-06-06 16:00:00.000' then 'After Bedrock' END
) AS "Label"
FROM optimism.core.fact_transactions
inner join dates d
WHERE block_timestamp BETWEEN X_days_before_bedrock and current_date
GROUP BY "Label"
ORDER BY "Label"
Last run: about 1 year agoAuto-refreshes every 3 hours
2
163B
96s