PREVIEW / stock_5min / 2000-09-13
file: by_date/stock_5min/2000/2000-09-13.parquet size: 1.1 MB rows: 87,965 symbols: 1,209
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 |
|---|---|---|---|---|---|---|---|
| 2000-09-13 08:00:00 | AAPL | Stock | 1.0307 | 1.0307 | 1.0307 | 1.0307 | 78400.0 |
| 2000-09-13 08:15:00 | AAPL | Stock | 1.0357 | 1.0357 | 1.0201 | 1.0201 | 16800.0 |
| 2000-09-13 08:20:00 | AAPL | Stock | 1.0179 | 1.0179 | 1.0179 | 1.0179 | 16800.0 |
| 2000-09-13 08:25:00 | AAPL | Stock | 1.0179 | 1.0179 | 1.0179 | 1.0179 | 33600.0 |
| 2000-09-13 08:30:00 | AAPL | Stock | 1.0179 | 1.0179 | 1.0179 | 1.0179 | 84000.0 |
| 2000-09-13 08:35:00 | AAPL | Stock | 1.0179 | 1.0179 | 1.0179 | 1.0179 | 28000.0 |
| 2000-09-13 08:40:00 | AAPL | Stock | 1.0056 | 1.0201 | 1.0 | 1.0201 | 196000.0 |
| 2000-09-13 08:45:00 | AAPL | Stock | 1.0045 | 1.0089 | 1.0022 | 1.0033 | 190400.0 |
| 2000-09-13 08:50:00 | AAPL | Stock | 1.0179 | 1.0179 | 0.9989 | 1.0 | 246400.0 |
| 2000-09-13 08:55:00 | AAPL | Stock | 0.9844 | 1.0 | 0.9844 | 1.0 | 44800.0 |
| 2000-09-13 09:00:00 | AAPL | Stock | 0.9821 | 1.0 | 0.9821 | 1.0 | 106400.0 |
| 2000-09-13 09:05:00 | AAPL | Stock | 1.0045 | 1.0045 | 1.0045 | 1.0045 | 117600.0 |
| 2000-09-13 09:10:00 | AAPL | Stock | 1.0089 | 1.0134 | 1.0089 | 1.0123 | 1019200.0 |
| 2000-09-13 09:20:00 | AAPL | Stock | 1.0039 | 1.0039 | 1.0039 | 1.0039 | 5600.0 |
| 2000-09-13 09:25:00 | AAPL | Stock | 1.0056 | 1.0179 | 1.0056 | 1.0134 | 1321600.0 |
| 2000-09-13 09:30:00 | AAPL | Stock | 1.0134 | 1.0324 | 1.0134 | 1.0246 | 6154400.0 |
| 2000-09-13 09:35:00 | AAPL | Stock | 1.0324 | 1.0379 | 1.0179 | 1.0357 | 11328800.0 |
| 2000-09-13 09:40:00 | AAPL | Stock | 1.0346 | 1.0379 | 1.0335 | 1.0379 | 23839200.0 |
| 2000-09-13 09:45:00 | AAPL | Stock | 1.0368 | 1.0413 | 1.0357 | 1.0379 | 6944000.0 |
| 2000-09-13 09:50:00 | AAPL | Stock | 1.0396 | 1.0413 | 1.0335 | 1.0346 | 2884000.0 |
| 2000-09-13 09:55:00 | AAPL | Stock | 1.0335 | 1.0402 | 1.029 | 1.0357 | 7436800.0 |
| 2000-09-13 10:00:00 | AAPL | Stock | 1.0391 | 1.0391 | 1.0313 | 1.0324 | 7974400.0 |
| 2000-09-13 10:05:00 | AAPL | Stock | 1.0313 | 1.0357 | 1.0301 | 1.0324 | 22584800.0 |
| 2000-09-13 10:10:00 | AAPL | Stock | 1.0324 | 1.0513 | 1.0313 | 1.0508 | 8523200.0 |
| 2000-09-13 10:15:00 | AAPL | Stock | 1.0508 | 1.0625 | 1.0446 | 1.0547 | 4200000.0 |
| 2000-09-13 10:20:00 | AAPL | Stock | 1.0536 | 1.058 | 1.0525 | 1.0525 | 2828000.0 |
| 2000-09-13 10:25:00 | AAPL | Stock | 1.0525 | 1.0547 | 1.0502 | 1.0502 | 1887200.0 |
| 2000-09-13 10:30:00 | AAPL | Stock | 1.0513 | 1.0558 | 1.0502 | 1.0525 | 4659200.0 |
| 2000-09-13 10:35:00 | AAPL | Stock | 1.0536 | 1.0547 | 1.0491 | 1.0513 | 3488800.0 |
| 2000-09-13 10:40:00 | AAPL | Stock | 1.0525 | 1.0525 | 1.0502 | 1.0513 | 1036000.0 |
| 2000-09-13 10:45:00 | AAPL | Stock | 1.0502 | 1.0513 | 1.0435 | 1.0463 | 4832800.0 |
| 2000-09-13 10:50:00 | AAPL | Stock | 1.0458 | 1.048 | 1.0446 | 1.0458 | 1808800.0 |
| 2000-09-13 10:55:00 | AAPL | Stock | 1.0446 | 1.0469 | 1.0424 | 1.043 | 1814400.0 |
| 2000-09-13 11:00:00 | AAPL | Stock | 1.0446 | 1.0458 | 1.0435 | 1.0446 | 1136800.0 |
| 2000-09-13 11:05:00 | AAPL | Stock | 1.0435 | 1.0435 | 1.0368 | 1.0368 | 1097600.0 |
| 2000-09-13 11:10:00 | AAPL | Stock | 1.0379 | 1.0379 | 1.0268 | 1.0301 | 3690400.0 |
| 2000-09-13 11:15:00 | AAPL | Stock | 1.0301 | 1.0335 | 1.0257 | 1.0268 | 2385600.0 |
| 2000-09-13 11:20:00 | AAPL | Stock | 1.0279 | 1.029 | 1.0234 | 1.029 | 4916800.0 |
| 2000-09-13 11:25:00 | AAPL | Stock | 1.0279 | 1.029 | 1.0246 | 1.0268 | 2100000.0 |
| 2000-09-13 11:30:00 | AAPL | Stock | 1.0268 | 1.0301 | 1.0257 | 1.0301 | 2296000.0 |
| 2000-09-13 11:35:00 | AAPL | Stock | 1.029 | 1.0301 | 1.0257 | 1.0268 | 2643200.0 |
| 2000-09-13 11:40:00 | AAPL | Stock | 1.0268 | 1.0279 | 1.0234 | 1.0268 | 1276800.0 |
| 2000-09-13 11:45:00 | AAPL | Stock | 1.0268 | 1.0279 | 1.0223 | 1.0246 | 1814400.0 |
| 2000-09-13 11:50:00 | AAPL | Stock | 1.0257 | 1.0257 | 1.0234 | 1.0257 | 1708000.0 |
| 2000-09-13 11:55:00 | AAPL | Stock | 1.0257 | 1.0268 | 1.0234 | 1.0246 | 896000.0 |
| 2000-09-13 12:00:00 | AAPL | Stock | 1.0234 | 1.0257 | 1.0234 | 1.0234 | 1999200.0 |
| 2000-09-13 12:05:00 | AAPL | Stock | 1.0234 | 1.0234 | 1.0201 | 1.0223 | 817600.0 |
| 2000-09-13 12:10:00 | AAPL | Stock | 1.0234 | 1.0234 | 1.0223 | 1.0234 | 968800.0 |
| 2000-09-13 12:15:00 | AAPL | Stock | 1.0234 | 1.0246 | 1.0223 | 1.0246 | 1400000.0 |
| 2000-09-13 12:20:00 | AAPL | Stock | 1.0246 | 1.0257 | 1.0246 | 1.0257 | 347200.0 |
> showing 50 of 87,965 rows — these rows as CSV