Query editor
-- Todo-- Add RedBelly sourceswith all_tx as(select*,'Ethereum' as chainfrom query_6752215 -- AUDF Ethereum Contractunionselect*,'Polygon' as chainfrom query_6752172 -- AUDF Polygon Contractunionselect*,'Base' as chainfrom query_6752230 -- AUDF Base Contractunionselect*,'Avalanche' as chainfrom query_6752238 -- AUDF Avalanche Contract)select*,row_number() over (partition by chain order by day desc) as rnfrom all_txorder by 1 desc