美国亚马逊运动服饰榜单追踪 Amazon US Best Sellers · Top 100

数据管理

SQLite 数据库 /home/ubuntu/qlht/amazon-tracker/data/tracker.sqlite

表统计

表行数
snapshots35,200
products15,291
runs22
changes3,579
import_log25

下载

按日期下载

最近运行

日期状态行数抓详情失败开始结束
2026-11-05FAIL1,60011802026-11-05T07:10:012026-11-05T07:37:56
2026-11-04FAIL1,60011502026-11-04T07:10:012026-11-04T07:36:38
2026-11-03FAIL1,60011602026-11-03T07:10:012026-11-03T07:36:49
2026-11-02FAIL1,60011602026-11-02T07:10:012026-11-02T07:36:41
2026-11-01FAIL1,60011702026-11-01T07:10:012026-11-01T07:36:49
2026-10-31FAIL1,60011602026-10-31T07:10:012026-10-31T07:37:23
2026-10-30FAIL1,60011702026-10-30T07:10:012026-10-30T07:36:56
2026-10-29FAIL1,60011302026-10-29T07:10:012026-10-29T07:36:10
2026-10-28FAIL1,60011902026-10-28T07:10:012026-10-28T07:37:55
2026-10-27FAIL1,60011602026-10-27T07:10:012026-10-27T07:42:38
2026-10-26FAIL1,60011702026-10-26T07:10:012026-10-26T07:44:56
2026-10-25FAIL1,60011802026-10-25T07:10:012026-10-25T07:37:42
2026-10-24PASS1,60011302026-10-24T07:10:012026-10-24T07:36:47
2026-10-23PASS1,60011602026-10-23T07:10:022026-10-23T07:37:26
2026-10-22PASS1,60011802026-10-22T07:10:012026-10-22T07:37:59
2026-10-21PASS1,60011502026-10-21T07:10:012026-10-21T07:43:31
2026-10-20PASS1,60011602026-10-20T07:10:012026-10-20T07:40:20
2026-10-19PASS1,60011902026-10-19T07:10:012026-10-19T07:44:02
2026-10-18PASS1,60012002026-10-18T07:10:012026-10-18T07:48:41
2026-10-17PASS1,60011802026-10-17T07:10:012026-10-17T07:40:18

CSV 导入记录

每个文件的 SHA-256 都记录在 import_log，重复导入是幂等的。

文件快照日期读取写入快照写入商品状态导入时间
amazon-sportswear/out/columns_dictionary.csv—5100skipped2026-10-16T09:06:35
amazon-tracker/data/dim/columns_dictionary.csv—5300skipped2026-10-16T09:06:36
amazon-tracker/data/dim/products.csv—3310331ok2026-10-16T09:03:04
amazon-tracker/data/dim/products.csv—3310331ok2026-10-16T09:06:36
amazon-sportswear/out/amazon_us_sportswear_top100.csv2026-10-151,6001,600375ok2026-10-16T09:03:04
amazon-tracker/data/daily/2026-10-15/amazon_us_sportswear_top100_2026-10-15.csv2026-10-151,6001,600437ok2026-10-16T09:03:04
amazon-tracker/data/daily/2026-10-15/amazon_us_sportswear_top100_2026-10-15.csv2026-10-151,6001,600678ok2026-10-16T09:06:36
amazon-tracker/data/daily/2026-10-15/amazon_us_sportswear_top100_2026-10-15.csv2026-10-151,6001,600678ok2026-10-16T09:07:18
amazon-tracker/data/daily/2026-10-15/amazon_us_sportswear_top100_2026-10-15.csv2026-10-151,6001,600678ok2026-10-16T09:07:49
amazon-tracker/data/daily/2026-10-15/amazon_us_sportswear_top100_2026-10-15.csv2026-10-151,6001,600678ok2026-10-16T09:10:20
amazon-tracker/data/daily/2026-10-15/changes_2026-10-15.csv2026-10-151,6001,6000ok2026-10-16T09:03:04
amazon-tracker/data/daily/2026-10-15/changes_2026-10-15.csv2026-10-151,6001,6000ok2026-10-16T09:06:36
amazon-tracker/data/daily/2026-10-15/changes_2026-10-15.csv2026-10-151,6001,6000ok2026-10-16T09:07:49
amazon-tracker/data/daily/2026-10-15/changes_2026-10-15.csv2026-10-151,6001,6000ok2026-10-16T09:10:20
amazon-tracker/data/analysis/sportswear_timeseries.csv2026-10-15,2026-10-163,2003,2000ok2026-10-16T09:06:35
amazon-sportswear/out/amazon_us_sportswear_top100.csv2026-10-161,6001,600392ok2026-10-16T09:10:19
amazon-tracker/data/daily/2026-10-16/amazon_us_sportswear_top100_2026-10-16.csv2026-10-161,6001,600596ok2026-10-16T09:03:04
amazon-tracker/data/daily/2026-10-16/amazon_us_sportswear_top100_2026-10-16.csv2026-10-161,6001,600596ok2026-10-16T09:06:36
amazon-tracker/data/daily/2026-10-16/amazon_us_sportswear_top100_2026-10-16.csv2026-10-161,6001,600596ok2026-10-16T09:07:18
amazon-tracker/data/daily/2026-10-16/amazon_us_sportswear_top100_2026-10-16.csv2026-10-161,6001,600596ok2026-10-16T09:07:50
amazon-tracker/data/daily/2026-10-16/amazon_us_sportswear_top100_2026-10-16.csv2026-10-161,6001,600596ok2026-10-16T09:10:20
amazon-tracker/data/daily/2026-10-16/changes_2026-10-16.csv2026-10-161,9791,9790ok2026-10-16T09:03:04
amazon-tracker/data/daily/2026-10-16/changes_2026-10-16.csv2026-10-161,9791,9790ok2026-10-16T09:06:36
amazon-tracker/data/daily/2026-10-16/changes_2026-10-16.csv2026-10-161,9791,9790ok2026-10-16T09:07:50
amazon-tracker/data/daily/2026-10-16/changes_2026-10-16.csv2026-10-161,9791,9790ok2026-10-16T09:10:20