with
ALLTABLES as (
select
VOLUME,
PROTOCOL,
DATE,
'dex' as
TYPE
from
external.defillama.fact_dex_volume
UNION
SELECT
DEPOSIT_USD + WITHDRAW_USD as VOLUME,
BRIDGE as PROTOCOL,
DATE,
'bridge' as
TYPE
from
external.defillama.fact_bridge_volume
UNION
SELECT
DEPOSIT_USD + WITHDRAW_USD as VOLUME,
BRIDGE as PROTOCOL,
DATE,
'bridge' as
TYPE
from
external.defillama.fact_bridge_volume
UNION
select
SUM(PRICE_USD) as Volume,
PLATFORM_NAME AS PROTOCOL,
TRUNC(BLOCK_TIMESTAMP, 'Day') as DATE,
'nft' as
TYPE
from