LTirrellsolana_wallets_per_month_tx_fees
Updated 2022-07-14
999
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
33
34
35
36
›
⌄
--sql @name: all_tps_info@
with consumption_tx as (
select
t.block_timestamp,
t.tx_id,
t.fee,
t.succeeded,
sum(
split(
regexp_substr(s.value, '[0-9]* of [0-9]*'),
' of '
) [0] :: int
) as compute_units_used,
avg(
split(
regexp_substr(s.value, '[0-9]* of [0-9]*'),
' of '
) [1] :: int
) as avg_compute_units_requested,
avg(
split(
regexp_substr(s.value, '[0-9]* of [0-9]*'),
' of '
) [0] :: int / split(
regexp_substr(s.value, '[0-9]* of [0-9]*'),
' of '
) [1] :: int
) as avg_compute_units_proportion
from
solana.core.fact_transactions t,
lateral flatten(input => t.log_messages) s
where
block_timestamp :: date = '2022-01-06'
and s.value like '% consumed %'
group by
Run a query to Download Data