flipside

Lordking bsc copy

Updated 2024-05-06

select

max(round(GAS_PRICE,1)) as "Max Gas Prics" ,

min(round(GAS_PRICE,1)) as "Min Gas Prics" ,

avg(round(GAS_PRICE,1)) as "Gas Prics" ,

'100' as "100" ,

'200' as "200" ,

'300' as "300" ,

'20' as "20 GWEI" ,

'50' as "50 GWEI" ,

date_trunc('day', block_timestamp)::date as date

from bsc.core.fact_transactions

where STATUS ='SUCCESS'

and block_timestamp::date >'2021-01-01'

group by 4 ,5,6,7,8,9

Last run: 11 days ago

	100	200	300	Max Gas Prics	Min Gas Prics	Gas Prics	20 GWEI	50 GWEI	DATE
1	100	200	300	30173.8	0	5.943213208	20	50	2021-09-04 00:00:00.000
2	100	200	300	34512.2	0	6.807947922	20	50	2022-01-24 00:00:00.000
3	100	200	300	49803.1	0	6.32196543	20	50	2022-02-03 00:00:00.000
4	100	200	300	52077.6	0	7.128457225	20	50	2022-10-25 00:00:00.000
5	100	200	300	110722.1	0	6.150866412	20	50	2022-12-27 00:00:00.000
6	100	200	300	147986.1	0	7.054441358	20	50	2023-02-23 00:00:00.000
7	100	200	300	154237.9	0	7.132441286	20	50	2023-02-10 00:00:00.000
8	100	200	300	327642.2	0	4.95327087	20	50	2023-05-06 00:00:00.000
9	100	200	300	276562.1	0	4.679710784	20	50	2023-07-02 00:00:00.000
10	100	200	300	38778	0	6.342350365	20	50	2021-05-01 00:00:00.000
11	100	200	300	749898	0	7.615240188	20	50	2024-03-10 00:00:00.000
12	100	200	300	579668.8	0	4.879477388	20	50	2024-03-29 00:00:00.000
13	100	200	300	427997.5	0	3.456175388	20	50	2024-12-24 00:00:00.000
14	100	200	300	410373.9	0	3.156804524	20	50	2024-12-29 00:00:00.000
15	100	200	300	523809.5	0	4.181757064	20	50	2025-02-03 00:00:00.000
16	100	200	300	1488496.6	0	2.541252699	20	50	2024-10-26 00:00:00.000
17	100	200	300	1190476.2	0	4.622261341	20	50	2025-02-21 00:00:00.000
18	100	200	300	29166.1	0	6.779701207	20	50	2022-08-09 00:00:00.000
19	100	200	300	55943.9	0	6.995591836	20	50	2022-09-21 00:00:00.000
20	100	200	300	87852.1	0	6.483094084	20	50	2023-01-10 00:00:00.000

...

1521

107KB

230s