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

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