Source Chain Distribution copy

SpecterSource Chain Distribution copy

Updated 2024-06-05

solana.core.fact_blockssolana.core.ez_signers-- forked from gigiokoba / Source Chain Distribution @ https://flipsidecrypto.xyz/gigiokoba/q/bFTkbs-Ud6rF/source-chain-distribution

SELECT

source_chain,

COUNT(*) AS transaction_count

FROM

AXELAR.defi.ez_bridge_squid

-- WHERE block_timestamp >= '2024-06-04 00:00:00' AND block_timestamp < '2024-06-05 00:00:00';

WHERE block_timestamp::date = current_date - 1

GROUP BY

source_chain

ORDER BY

transaction_count DESC;

QueryRunArchived: QueryRun has been archived