Query editor
WITH plasma_bridgers AS (SELECTaddr_from AS user_address,COUNT(DISTINCT tx_hash_source) AS bridge_transaction_count,SUM(usd_value / 10) AS total_usd_bridged, -- Divide by 10 to correctMIN(ts_source) AS first_bridge_time,MAX(ts_source) AS last_bridge_time,COUNT(DISTINCT source_chain) AS source_chains_used,COUNT(DISTINCT DATE_TRUNC('day', ts_source)) AS active_days_countFROM layerzero.messagesWHERE destination_chain = 'Plasma'AND source_chain != 'Plasma'AND state = 'Success'GROUP BY addr_from)SELECTROW_NUMBER() OVER (ORDER BY total_usd_bridged DESC) AS rank,user_address,total_usd_bridged,bridge_transaction_count,source_chains_used,active_days_count,first_bridge_time,last_bridge_timeFROM plasma_bridgersORDER BY total_usd_bridged DESCLIMIT 500;