SELECT
  paper_id,
  paper_title,
  COALESCE(paper_publishedAt, publishedAt) AS created_at,
  paper_upvotes
FROM read_parquet('https://huggingface.co/datasets/cfahlgren1/hub-stats/resolve/refs%2Fconvert%2Fparquet/papers/train/0000.parquet')
WHERE COALESCE(paper_publishedAt, publishedAt) >= NOW() - INTERVAL 7 DAY
ORDER BY created_at DESC
