PREVIEW / stock_5min / 2000-03-16
file: by_date/stock_5min/2000/2000-03-16.parquet size: 1.3 MB rows: 94,867 symbols: 1,150
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-03-16 09:30:00 | AAPL | Stock | 1.0474 | 1.0497 | 1.0446 | 1.0463 | 7828800.0 |
| 2000-03-16 09:35:00 | AAPL | Stock | 1.0463 | 1.0536 | 1.0463 | 1.053 | 6238400.0 |
| 2000-03-16 09:40:00 | AAPL | Stock | 1.0502 | 1.0569 | 1.0458 | 1.0458 | 5476800.0 |
| 2000-03-16 09:45:00 | AAPL | Stock | 1.0463 | 1.0558 | 1.0458 | 1.053 | 4984000.0 |
| 2000-03-16 09:50:00 | AAPL | Stock | 1.0536 | 1.0552 | 1.0458 | 1.0502 | 10684800.0 |
| 2000-03-16 09:55:00 | AAPL | Stock | 1.0519 | 1.0525 | 1.048 | 1.0502 | 2520000.0 |
| 2000-03-16 10:00:00 | AAPL | Stock | 1.0497 | 1.0497 | 1.0446 | 1.048 | 5476800.0 |
| 2000-03-16 10:05:00 | AAPL | Stock | 1.048 | 1.0485 | 1.0446 | 1.0463 | 3673600.0 |
| 2000-03-16 10:10:00 | AAPL | Stock | 1.0463 | 1.0463 | 1.0446 | 1.0463 | 3942400.0 |
| 2000-03-16 10:15:00 | AAPL | Stock | 1.0463 | 1.0469 | 1.0458 | 1.0458 | 4480000.0 |
| 2000-03-16 10:20:00 | AAPL | Stock | 1.0463 | 1.0469 | 1.0402 | 1.0402 | 6238400.0 |
| 2000-03-16 10:25:00 | AAPL | Stock | 1.0402 | 1.0463 | 1.0402 | 1.0446 | 6988800.0 |
| 2000-03-16 10:30:00 | AAPL | Stock | 1.0441 | 1.0446 | 1.0407 | 1.0435 | 4592000.0 |
| 2000-03-16 10:35:00 | AAPL | Stock | 1.0435 | 1.0446 | 1.043 | 1.0435 | 795200.0 |
| 2000-03-16 10:40:00 | AAPL | Stock | 1.0435 | 1.0446 | 1.0357 | 1.0357 | 3819200.0 |
| 2000-03-16 10:45:00 | AAPL | Stock | 1.0357 | 1.0413 | 1.0313 | 1.0329 | 3662400.0 |
| 2000-03-16 10:50:00 | AAPL | Stock | 1.0324 | 1.0324 | 1.0279 | 1.0285 | 4267200.0 |
| 2000-03-16 10:55:00 | AAPL | Stock | 1.0285 | 1.0335 | 1.0234 | 1.0237 | 5073600.0 |
| 2000-03-16 11:00:00 | AAPL | Stock | 1.024 | 1.0285 | 1.0234 | 1.0251 | 3606400.0 |
| 2000-03-16 11:05:00 | AAPL | Stock | 1.0251 | 1.0268 | 1.0223 | 1.0268 | 3270400.0 |
| 2000-03-16 11:10:00 | AAPL | Stock | 1.0268 | 1.0307 | 1.024 | 1.0307 | 5555200.0 |
| 2000-03-16 11:15:00 | AAPL | Stock | 1.0307 | 1.0413 | 1.0296 | 1.0402 | 4502400.0 |
| 2000-03-16 11:20:00 | AAPL | Stock | 1.0385 | 1.0407 | 1.0385 | 1.0388 | 1635200.0 |
| 2000-03-16 11:25:00 | AAPL | Stock | 1.0391 | 1.0391 | 1.0324 | 1.034 | 1523200.0 |
| 2000-03-16 11:30:00 | AAPL | Stock | 1.034 | 1.0391 | 1.0318 | 1.0385 | 3628800.0 |
| 2000-03-16 11:35:00 | AAPL | Stock | 1.0385 | 1.0391 | 1.0324 | 1.0391 | 2609600.0 |
| 2000-03-16 11:40:00 | AAPL | Stock | 1.0396 | 1.0469 | 1.0396 | 1.043 | 6787200.0 |
| 2000-03-16 11:45:00 | AAPL | Stock | 1.043 | 1.0435 | 1.0413 | 1.0419 | 5443200.0 |
| 2000-03-16 11:50:00 | AAPL | Stock | 1.0413 | 1.048 | 1.0413 | 1.0458 | 5208000.0 |
| 2000-03-16 11:55:00 | AAPL | Stock | 1.0446 | 1.0458 | 1.0346 | 1.0363 | 5084800.0 |
| 2000-03-16 12:00:00 | AAPL | Stock | 1.0357 | 1.0391 | 1.0346 | 1.0363 | 2744000.0 |
| 2000-03-16 12:05:00 | AAPL | Stock | 1.0357 | 1.0396 | 1.0357 | 1.0396 | 2945600.0 |
| 2000-03-16 12:10:00 | AAPL | Stock | 1.0391 | 1.0435 | 1.0368 | 1.0396 | 828800.0 |
| 2000-03-16 12:15:00 | AAPL | Stock | 1.0402 | 1.0435 | 1.0396 | 1.0396 | 627200.0 |
| 2000-03-16 12:20:00 | AAPL | Stock | 1.0402 | 1.0435 | 1.0363 | 1.0396 | 4468800.0 |
| 2000-03-16 12:25:00 | AAPL | Stock | 1.0396 | 1.0458 | 1.0396 | 1.0446 | 1769600.0 |
| 2000-03-16 12:30:00 | AAPL | Stock | 1.0446 | 1.0458 | 1.043 | 1.0435 | 4334400.0 |
| 2000-03-16 12:35:00 | AAPL | Stock | 1.0435 | 1.0525 | 1.0435 | 1.0525 | 9643200.0 |
| 2000-03-16 12:40:00 | AAPL | Stock | 1.0525 | 1.0525 | 1.0469 | 1.0525 | 3416000.0 |
| 2000-03-16 12:45:00 | AAPL | Stock | 1.0508 | 1.0525 | 1.0491 | 1.0519 | 2228800.0 |
| 2000-03-16 12:50:00 | AAPL | Stock | 1.0525 | 1.0552 | 1.0519 | 1.0525 | 6204800.0 |
| 2000-03-16 12:55:00 | AAPL | Stock | 1.0525 | 1.0569 | 1.0497 | 1.0497 | 6305600.0 |
| 2000-03-16 13:00:00 | AAPL | Stock | 1.0497 | 1.0497 | 1.048 | 1.048 | 2564800.0 |
| 2000-03-16 13:05:00 | AAPL | Stock | 1.0474 | 1.0491 | 1.0469 | 1.0474 | 996800.0 |
| 2000-03-16 13:10:00 | AAPL | Stock | 1.048 | 1.048 | 1.0458 | 1.0474 | 3068800.0 |
| 2000-03-16 13:15:00 | AAPL | Stock | 1.0469 | 1.048 | 1.0469 | 1.048 | 1601600.0 |
| 2000-03-16 13:20:00 | AAPL | Stock | 1.048 | 1.0513 | 1.0435 | 1.0441 | 3158400.0 |
| 2000-03-16 13:25:00 | AAPL | Stock | 1.0441 | 1.048 | 1.0357 | 1.0388 | 4144000.0 |
| 2000-03-16 13:30:00 | AAPL | Stock | 1.0385 | 1.0391 | 1.0346 | 1.0352 | 4088000.0 |
| 2000-03-16 13:35:00 | AAPL | Stock | 1.0352 | 1.0385 | 1.0346 | 1.0385 | 1187200.0 |
> showing 50 of 94,867 rows — these rows as CSV