SELECT

COUNT(DISTINCT TX_HASH) AS "Total Transactions"

FROM

base.core.fact_transactions

),

Active_users AS (

SELECT

COUNT(DISTINCT TO_ADDRESS) AS "Total Holders"

FROM

base.core.fact_transactions

),

Total_Volume AS (

SELECT

SUM(ABS(AMOUNT_IN_USD) + ABS(AMOUNT_OUT_USD)) AS "Total Trading Volume ($)"

FROM

base.defi.ez_dex_swaps

SELECT

nt."Total Transactions",

au."Total Holders",

tv."Total Trading Volume ($)",

FROM

number_of_transactions nt

CROSS JOIN

Active_users au

CROSS JOIN

Total_Volume tv