h4wkSei dApps 2
Updated 2023-09-17
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
›
⌄
-- forked from Sei dApps Table @ https://flipsidecrypto.xyz/edit/queries/96b6bf75-04a8-4c58-a399-d8ae042bdca8
-- forked from dapps @ https://flipsidecrypto.xyz/edit/queries/45f7636f-6e4d-4172-b799-ff41cb221e1e
-- forked from base @ https://flipsidecrypto.xyz/edit/queries/16a82735-47fa-42cd-b37d-7207cfc5f153
-- 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,
upper(label_type) as label_type,
initcap(label) as 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
and label_type not in ('cex', 'token')
)
, 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'
)
Run a query to Download Data