PREVIEW / stock_1min / 2004-07-02
file: by_date/stock_1min/2004/2004-07-02.parquet size: 5.5 MB rows: 465,281 symbols: 1,464
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2004-07-02 08:00:00 | AAPL | Stock | 0.5445 | 0.5445 | 0.542 | 0.542 | 33600.0 |
| 2004-07-02 08:01:00 | AAPL | Stock | 0.5446 | 0.5446 | 0.5402 | 0.5402 | 908320.0 |
| 2004-07-02 08:02:00 | AAPL | Stock | 0.5411 | 0.5446 | 0.5411 | 0.5434 | 392000.0 |
| 2004-07-02 08:04:00 | AAPL | Stock | 0.5434 | 0.5436 | 0.5434 | 0.5436 | 212800.0 |
| 2004-07-02 08:05:00 | AAPL | Stock | 0.5411 | 0.5438 | 0.5411 | 0.5438 | 733600.0 |
| 2004-07-02 08:06:00 | AAPL | Stock | 0.5441 | 0.5441 | 0.5429 | 0.5429 | 257600.0 |
| 2004-07-02 08:08:00 | AAPL | Stock | 0.542 | 0.542 | 0.542 | 0.542 | 5600.0 |
| 2004-07-02 08:09:00 | AAPL | Stock | 0.5411 | 0.5414 | 0.5411 | 0.5413 | 1920800.0 |
| 2004-07-02 08:10:00 | AAPL | Stock | 0.5413 | 0.5413 | 0.5411 | 0.5411 | 140000.0 |
| 2004-07-02 08:12:00 | AAPL | Stock | 0.5393 | 0.5393 | 0.5379 | 0.5379 | 72800.0 |
| 2004-07-02 08:13:00 | AAPL | Stock | 0.5379 | 0.538 | 0.5379 | 0.5379 | 246400.0 |
| 2004-07-02 08:14:00 | AAPL | Stock | 0.5393 | 0.5393 | 0.5375 | 0.5388 | 414400.0 |
| 2004-07-02 08:15:00 | AAPL | Stock | 0.5389 | 0.5411 | 0.5389 | 0.5391 | 940800.0 |
| 2004-07-02 08:16:00 | AAPL | Stock | 0.5393 | 0.5402 | 0.5393 | 0.5402 | 487200.0 |
| 2004-07-02 08:17:00 | AAPL | Stock | 0.5391 | 0.5402 | 0.5391 | 0.5395 | 397600.0 |
| 2004-07-02 08:18:00 | AAPL | Stock | 0.5393 | 0.5398 | 0.5384 | 0.5398 | 308000.0 |
| 2004-07-02 08:19:00 | AAPL | Stock | 0.5402 | 0.5402 | 0.5393 | 0.5393 | 554400.0 |
| 2004-07-02 08:20:00 | AAPL | Stock | 0.5402 | 0.5402 | 0.5393 | 0.5393 | 1120000.0 |
| 2004-07-02 08:21:00 | AAPL | Stock | 0.5396 | 0.5396 | 0.5393 | 0.5393 | 285600.0 |
| 2004-07-02 08:22:00 | AAPL | Stock | 0.5393 | 0.5393 | 0.5384 | 0.5393 | 663600.0 |
| 2004-07-02 08:23:00 | AAPL | Stock | 0.5379 | 0.5391 | 0.5379 | 0.5388 | 526400.0 |
| 2004-07-02 08:24:00 | AAPL | Stock | 0.538 | 0.5388 | 0.5379 | 0.5388 | 240800.0 |
| 2004-07-02 08:25:00 | AAPL | Stock | 0.5384 | 0.5393 | 0.5384 | 0.5393 | 179200.0 |
| 2004-07-02 08:26:00 | AAPL | Stock | 0.5384 | 0.5393 | 0.5384 | 0.5391 | 252000.0 |
| 2004-07-02 08:27:00 | AAPL | Stock | 0.5393 | 0.5393 | 0.5389 | 0.5389 | 78400.0 |
| 2004-07-02 08:28:00 | AAPL | Stock | 0.5391 | 0.5391 | 0.5391 | 0.5391 | 5600.0 |
| 2004-07-02 08:29:00 | AAPL | Stock | 0.5389 | 0.5389 | 0.5389 | 0.5389 | 44800.0 |
| 2004-07-02 08:30:00 | AAPL | Stock | 0.5393 | 0.5393 | 0.5384 | 0.5388 | 378000.0 |
| 2004-07-02 08:31:00 | AAPL | Stock | 0.5386 | 0.5388 | 0.5384 | 0.5388 | 504000.0 |
| 2004-07-02 08:32:00 | AAPL | Stock | 0.5388 | 0.5388 | 0.5388 | 0.5388 | 571200.0 |
| 2004-07-02 08:33:00 | AAPL | Stock | 0.5384 | 0.5384 | 0.5379 | 0.5379 | 128800.0 |
| 2004-07-02 08:34:00 | AAPL | Stock | 0.5384 | 0.5388 | 0.5384 | 0.5384 | 733600.0 |
| 2004-07-02 08:35:00 | AAPL | Stock | 0.5389 | 0.5402 | 0.5389 | 0.5402 | 666400.0 |
| 2004-07-02 08:36:00 | AAPL | Stock | 0.5402 | 0.5402 | 0.5402 | 0.5402 | 453600.0 |
| 2004-07-02 08:37:00 | AAPL | Stock | 0.5402 | 0.5402 | 0.5395 | 0.5395 | 229600.0 |
| 2004-07-02 08:38:00 | AAPL | Stock | 0.5402 | 0.5402 | 0.5402 | 0.5402 | 106400.0 |
| 2004-07-02 08:39:00 | AAPL | Stock | 0.5404 | 0.5436 | 0.5404 | 0.5429 | 1439200.0 |
| 2004-07-02 08:40:00 | AAPL | Stock | 0.5429 | 0.5429 | 0.5429 | 0.5429 | 112000.0 |
| 2004-07-02 08:41:00 | AAPL | Stock | 0.5418 | 0.5429 | 0.5418 | 0.5429 | 756000.0 |
| 2004-07-02 08:42:00 | AAPL | Stock | 0.5429 | 0.5429 | 0.5429 | 0.5429 | 56000.0 |
| 2004-07-02 08:43:00 | AAPL | Stock | 0.542 | 0.542 | 0.5411 | 0.542 | 705600.0 |
| 2004-07-02 08:44:00 | AAPL | Stock | 0.542 | 0.5423 | 0.542 | 0.5423 | 184800.0 |
| 2004-07-02 08:45:00 | AAPL | Stock | 0.5402 | 0.542 | 0.5402 | 0.5411 | 1691200.0 |
| 2004-07-02 08:47:00 | AAPL | Stock | 0.5423 | 0.5464 | 0.5423 | 0.5464 | 1215200.0 |
| 2004-07-02 08:49:00 | AAPL | Stock | 0.5445 | 0.5445 | 0.5445 | 0.5445 | 28000.0 |
| 2004-07-02 08:52:00 | AAPL | Stock | 0.5429 | 0.5429 | 0.5429 | 0.5429 | 11200.0 |
| 2004-07-02 08:54:00 | AAPL | Stock | 0.5429 | 0.5429 | 0.5429 | 0.5429 | 84000.0 |
| 2004-07-02 08:55:00 | AAPL | Stock | 0.5438 | 0.5438 | 0.5438 | 0.5438 | 28000.0 |
| 2004-07-02 08:56:00 | AAPL | Stock | 0.5438 | 0.5438 | 0.5429 | 0.5429 | 352800.0 |
| 2004-07-02 08:57:00 | AAPL | Stock | 0.543 | 0.5438 | 0.543 | 0.5438 | 1411200.0 |
> showing 50 of 465,281 rows — these rows as CSV