select BLOCK_TIMESTAMP::date date ,

TX_HASH,

SOURCE_ADDRESS SENDER,

DESTINATION_ADDRESS RECEIVER,

SOURCE_CHAIN SOURCE_CHAIN_NAME,

DESTINATION_CHAIN DESTINATION_CHAIN_NAME,

AMOUNT_USD,

direction,

from near.defi.ez_bridge_activity

where platform = 'rainbow'

and receipt_succeeded = 1

and BLOCK_TIMESTAMP ::date >= '2024-01-01'

select

symbol token ,

count (tx_hash) num_bridges ,

count (distinct iff(direction = 'inbound', RECEIVER, SENDER)) num_bridgers ,

sum (iff(direction='inbound',amount_USD,-amount_USD)) bridged_debridged_volume ,

avg (amount_USD) avg_bridged_volume

from bridge_txns

where date < date_trunc('week',current_date)::Date

and symbol is not NULL

and amount_USD < 1e6

group by 1