retention plots batch data

TheLaughingManretention plots batch data

Updated 2025-04-11

-- forked from retention plots @ https://flipsidecrypto.xyz/studio/queries/d8637e50-b56b-4b0a-94c2-da5409ffda30

-- forked from new vs old traffic @ https://flipsidecrypto.xyz/studio/queries/32c825b6-9c3d-467a-811e-23cbd25bb896

-- forked from new users by instance @ https://flipsidecrypto.xyz/studio/queries/c8ac5c1a-c63d-4c2f-bb3c-8bf718b0822c

-- forked from new users @ https://flipsidecrypto.xyz/studio/queries/1a856392-7af8-4ad9-96ee-909b0154fe62

with merge_all_time as (

---arbitrum

SELECT * EXCLUDE version, 'arbitrum' as label from arbitrum.vertex.ez_perp_trades

WHERE 1=1

--AND block_timestamp::date BETWEEN '{{start_date}}' AND '{{end_date}}'

AND trader != '0x0000000000000000000000000000000000000000'

AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

UNION ALL

---base

SELECT *, 'base' as label from base.vertex.ez_perp_trades

WHERE 1=1

--AND block_timestamp::date BETWEEN '{{start_date}}' AND '{{end_date}}'

AND trader != '0x0000000000000000000000000000000000000000'

AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

UNION ALL

---blitz

SELECT * , 'blitz' as label from blast.blitz.ez_perp_trades

WHERE 1=1

--AND block_timestamp::date BETWEEN '{{start_date}}' AND '{{end_date}}'

AND trader != '0x0000000000000000000000000000000000000000'

AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

UNION ALL

---mantle

SELECT * , 'mantle' as label from mantle.vertex.ez_perp_trades

WHERE 1=1

Last run: 17 days ago

170B

47s