Query editor
------------------------------------------------------------ 1 Flows to Plasma based on source chain--------------------------------------------------------- WITH plasma_deposits AS (-- SELECT-- addr_from,-- source_chain,-- SUM(usd_value) AS total_volume,-- COUNT(*) AS tx_count,-- MIN(ts_source) AS first_tx,-- MAX(ts_source) AS last_tx-- FROM layerzero.messages a-- WHERE-- state = 'Success'-- AND destination_chain = 'Plasma'-- GROUP BY addr_from, source_chain-- ),-- big_depositors AS (-- SELECT *-- FROM plasma_deposits-- WHERE total_volume >= 1000000-- )-- SELECT-- source_chain,-- SUM(total_volume)-- FROM big_depositors-- group by 1------------------------------------------------------------ 2 Flows to Plasma (based on first source chain)-------------------------------------------------------WITH all_first_txs AS (SELECTaddr_from,MIN_BY(source_chain, ts_source) AS first_chain,MIN_BY(destination_chain, ts_source) AS first_destination,MIN(ts_source) AS first_txFROM layerzero.messagesWHERE state = 'Success'GROUP BY addr_from),plasma_deposits AS (SELECTaddr_from,source_chain,SUM(usd_value) AS total_volume,COUNT(*) AS tx_count,MIN(ts_source) AS first_tx,MAX(ts_source) AS last_txFROM layerzero.messagesWHEREstate = 'Success'AND destination_chain = 'Plasma'GROUP BY addr_from, source_chain),big_depositors AS (