highly_engaged _users

lindyyhighly_engaged _users

Updated 2025-02-21

--with AERODROME_ACTIVITIES AS

--(

--SELECT

--BLOCK_TIMESTAMP :: date AS date,

--count ( DISTINCT TX_HASH) as aero_swap,

--count ( DISTINCT ORIGIN_FROM_ADDRESS) as active_users,

--sum(AMOUNT_IN_USD) as total_volume

--from base.defi.ez_dex_swaps

--where

--BLOCK_TIMESTAMP :: date >= '2024-01-01'

--and PLATFORM = 'aerodrome'

--group by date

--)

--SELECT

--date,

--aero_swap,

--active_users,

--total_volume

--from

--AERODROME_ACTIVITIES

--where aero_swap >1

--order by

--date desc

--;

WITH AERODROME_ACTIVITIES AS

(

SELECT

date_trunc('day', BLOCK_TIMESTAMP) AS day,

ORIGIN_FROM_ADDRESS,

count(DISTINCT TX_HASH) AS aero_swaps

FROM

base.defi.ez_dex_swaps

WHERE

BLOCK_TIMESTAMP >= '2024-01-01'

AND PLATFORM = 'aerodrome'

GROUP BY

Last run: 2 months ago

...

417

16KB

flipside