github.com/diadata-org/diadata@v1.4.593/scripts/dump-exchange_dex.sql (about)

     1  COPY (
     2      SELECT * FROM exchange WHERE "name" IN (
     3          SELECT distinct exchange FROM pool WHERE pool_id IN (
     4              SELECT DISTINCT pool_id FROM poolasset WHERE "time_stamp" >= now() - interval '7 days'
     5          )
     6      )
     7  ) TO STDOUT WITH (format csv, delimiter ';');