Sei fee Total

h4wkSei fee Total

Updated 2023-09-23

-- forked from Sei fee Total type @ https://flipsidecrypto.xyz/edit/queries/fe5236e5-3845-4d9e-b34a-13db7b8096b1

-- forked from Sei fee @ https://flipsidecrypto.xyz/edit/queries/07c95159-375f-4294-bd97-d9a9d3058014

-- forked from Sei dApps Activity 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 (

Run a query to Download Data