v_swap_txns as (

select

'Velodrome' as dex,

block_timestamp,

symbol_in,

symbol_out,

amount_in_usd,

amount_out_usd,

tx_hash,

origin_from_address

from optimism.velodrome.ez_swaps

),

s_swap_txns as (

select

'SushiSwap' as dex,

block_timestamp,

symbol_in,

symbol_out,

amount_in_usd,

amount_out_usd,

tx_hash,

origin_from_address

from optimism.sushi.ez_swaps

),

contracts as (

(select * from optimism.core.dim_contracts)

union ( select

'0x1318811b1c6aed9c48623adb1ee22f81c6c6f876' as address,

'DC Token' as symbol,

'0' as decimals

)

union ( select

'0xe649951f6e18492fca574d6113bbf446269312ee' as address,

'US Token' as symbol,

'0' as decimals