h4wkbase
Updated 2023-09-13
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
33
34
35
36
›
⌄
-- top dApps by transaction volume, DAUs, and network fees.
-- Axelar (bridge)
-- Wormhole (bridge)
-- Dagora (NFT)
-- Webump (NFT)
-- Fuzio (DEX)
-- Astroport (DEX)
-- SeaSwap (DEX)
-- Simba (DEX)
-- Levana (Perps)
-- Space ID (Naming)
-- Yolee Universe (Game)
-- DoubleJump (Game)
with label_msg as (
select block_timestamp,
tx_id,
label_type,
label
FROM sei.core.fact_msg_attributes
join sei.core.dim_labels on (address = ATTRIBUTE_VALUE)
where block_timestamp >= '2023-08-12' and label_type != 'operator' and TX_SUCCEEDED = TRUE
)
, tx_fee as (
select block_timestamp, tx_id, split(attribute_value, 'usei')[0]::number/1e6 as sei_fee
from sei.core.fact_msg_attributes
where block_timestamp >= '2023-08-12' and attribute_key = 'fee'
)
, period_txs as (
select block_timestamp, tx_id, tx_from
from sei.core.fact_transactions
where block_timestamp >= '2023-08-12'
)
, base as (
Run a query to Download Data