HeminOsmosis Bounties Transaction Fees
Updated 2022-05-20
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
›
⌄
WITH tr_fee AS(
SELECT
BLOCK_TIMESTAMP,
gas_used,
GAS_WANTED,
tx_id,
TX_STATUS
FROM
osmosis.core.fact_transactions
WHERE
BLOCK_TIMESTAMP::date >= '2022-04-20'
),
tr_type AS(
SELECT
TX_ID,
MSG_TYPE
FROM
osmosis.core.fact_msgs
WHERE
BLOCK_TIMESTAMP::date >= '2022-04-20'
)
SELECT
BLOCK_TIMESTAMP::date as date,
sum(GAS_USED) as total_gas_payed,
count(GAS_USED) as number_of_transaction,
tx_status,
MSG_TYPE
FROM
tr_fee LEFT JOIN tr_type on tr_fee.tx_id = tr_type.tx_id
GROUP by 1,4,5
Run a query to Download Data