with
ALLTABLES as (
select
VOLUME,
PROTOCOL,
DATE
from
external.defillama.fact_dex_volume
UNION
SELECT
DEPOSIT_USD + WITHDRAW_USD as VOLUME,
BRIDGE as PROTOCOL,
DATE
from
external.defillama.fact_bridge_volume
UNION
SELECT
DEPOSIT_USD + WITHDRAW_USD as VOLUME,
BRIDGE as PROTOCOL,
DATE
from
external.defillama.fact_bridge_volume
UNION
select
SUM(PRICE_USD) as Volume,
PLATFORM_NAME AS PROTOCOL,
TRUNC(BLOCK_TIMESTAMP, 'Day') as DATE
from
ethereum.core.ez_nft_sales
GROUP by
DATE,
PROTOCOL
)
select
SUM(VOLUME) as VOLUMETOTAL,
PROTOCOL