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

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