-- forked from Ericmoore_1 / NEAR Protocol : Active Bridge Builders over Time @ https://flipsidecrypto.xyz/Ericmoore_1/q/br5Gc4POz6YB/near-protocol-active-bridge-builders-over-time
SELECT
date_trunc('day', block_timestamp) Date,
--amount_usd,
destination_chain,
COUNT(DISTINCT bridge_address) Active_bridge_builders
--block_id,
--direction
FROM near.defi.ez_bridge_activity
WHERE amount_usd IS NOT NULL
AND Date(block_timestamp) >= '2024-05-28'
GROUP BY 1, 2
ORDER BY Active_bridge_builders DESC