envious-amber

Sniperenvious-amber

Updated 2025-04-05

-- select 'dex' as type,

-- date_trunc('month', block_timestamp) as date,

-- count (DISTINCT TX_HASH) as tx_defi,

-- count (DISTINCT FROM_ADDRESS) as user,

-- from swell.core.fact_transactions x

-- join swell.core.dim_labels y on x.to_address=y.address

-- where block_timestamp :: Date >= '2024-09-01'

-- and label_type = 'dex'

-- and TX_SUCCEEDED = 'TRUE'

-- group by 1,2

select label_type,LABEL from

swell.core.dim_labels

group by 1,2

Last run: 19 days ago

	LABEL_TYPE	LABEL
1	dex	neptune

19B

flipside