leonProject types on Ethereum mainnet by volume during the past 7 days
    Updated 2023-03-25
    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
    Run a query to Download Data