b.block_number,

b.block_timestamp,

b.tx_hash,

b.event_name,

b.direction,

l.label_type,

l.address_name,

b.bridge_address,

b.token_address,

b.amount_unadj

FROM

aptos.defi.fact_bridge_activity b

JOIN

aptos.core.dim_labels l

ON b.bridge_address = l.address

WHERE

b.block_timestamp BETWEEN '2024-03-20' AND '2024-03-30'

--b.block_timestamp >= '2024-03-20'

ORDER BY

--b.block_timestamp ASC

b.block_timestamp DESC

LIMIT

100