-- forked from Crypticyl / Near Top 5 Source Chains by Number of Transactions August 2024 @ https://flipsidecrypto.xyz/Crypticyl/q/ESc28oltD8ca/near-top-5-source-chains-by-number-of-transactions-august-2024
SELECT
SOURCE_CHAIN,
COUNT(TX_HASH) AS transactions_count
FROM
near.defi.ez_bridge_activity
WHERE
BLOCK_TIMESTAMP >= '2024-08-01' AND BLOCK_TIMESTAMP < '2024-09-01'
GROUP BY
SOURCE_CHAIN
ORDER BY
transactions_count DESC
LIMIT 5;