PREVIEW / stock_5min / 2000-05-03
file: by_date/stock_5min/2000/2000-05-03.parquet size: 1.1 MB rows: 83,379 symbols: 1,153
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-05-03 09:30:00 | AAPL | Stock | 1.0619 | 1.0714 | 1.058 | 1.0647 | 18468800.0 |
| 2000-05-03 09:35:00 | AAPL | Stock | 1.0647 | 1.0804 | 1.0625 | 1.0804 | 20227200.0 |
| 2000-05-03 09:40:00 | AAPL | Stock | 1.0815 | 1.0826 | 1.0725 | 1.0725 | 15120000.0 |
| 2000-05-03 09:45:00 | AAPL | Stock | 1.0725 | 1.0781 | 1.058 | 1.0639 | 15467200.0 |
| 2000-05-03 09:50:00 | AAPL | Stock | 1.058 | 1.067 | 1.058 | 1.0636 | 20820800.0 |
| 2000-05-03 09:55:00 | AAPL | Stock | 1.065 | 1.0664 | 1.0402 | 1.0402 | 14358400.0 |
| 2000-05-03 10:00:00 | AAPL | Stock | 1.0402 | 1.048 | 1.0402 | 1.0458 | 9867200.0 |
| 2000-05-03 10:05:00 | AAPL | Stock | 1.0463 | 1.0536 | 1.0391 | 1.0508 | 20518400.0 |
| 2000-05-03 10:10:00 | AAPL | Stock | 1.053 | 1.0536 | 1.0407 | 1.0413 | 8960000.0 |
| 2000-05-03 10:15:00 | AAPL | Stock | 1.0402 | 1.0446 | 1.0335 | 1.0391 | 10337600.0 |
| 2000-05-03 10:20:00 | AAPL | Stock | 1.0391 | 1.0472 | 1.0374 | 1.0435 | 5320000.0 |
| 2000-05-03 10:25:00 | AAPL | Stock | 1.043 | 1.0536 | 1.0413 | 1.0505 | 4670400.0 |
| 2000-05-03 10:30:00 | AAPL | Stock | 1.0508 | 1.0558 | 1.0458 | 1.0497 | 8825600.0 |
| 2000-05-03 10:35:00 | AAPL | Stock | 1.0491 | 1.0541 | 1.0379 | 1.0396 | 7414400.0 |
| 2000-05-03 10:40:00 | AAPL | Stock | 1.0391 | 1.0413 | 1.0307 | 1.0357 | 7918400.0 |
| 2000-05-03 10:45:00 | AAPL | Stock | 1.0357 | 1.0413 | 1.0313 | 1.0318 | 4569600.0 |
| 2000-05-03 10:50:00 | AAPL | Stock | 1.0313 | 1.0346 | 1.029 | 1.0324 | 3236800.0 |
| 2000-05-03 10:55:00 | AAPL | Stock | 1.0318 | 1.0352 | 1.0279 | 1.0352 | 2844800.0 |
| 2000-05-03 11:00:00 | AAPL | Stock | 1.0335 | 1.0346 | 1.0273 | 1.0285 | 3449600.0 |
| 2000-05-03 11:05:00 | AAPL | Stock | 1.0279 | 1.0335 | 1.0273 | 1.0279 | 3774400.0 |
| 2000-05-03 11:10:00 | AAPL | Stock | 1.0273 | 1.0368 | 1.0268 | 1.0366 | 7067200.0 |
| 2000-05-03 11:15:00 | AAPL | Stock | 1.0368 | 1.0391 | 1.0335 | 1.036 | 6608000.0 |
| 2000-05-03 11:20:00 | AAPL | Stock | 1.0379 | 1.0424 | 1.034 | 1.0421 | 5062400.0 |
| 2000-05-03 11:25:00 | AAPL | Stock | 1.0402 | 1.0435 | 1.0357 | 1.0363 | 3124800.0 |
| 2000-05-03 11:30:00 | AAPL | Stock | 1.0379 | 1.0413 | 1.0324 | 1.0346 | 3897600.0 |
| 2000-05-03 11:35:00 | AAPL | Stock | 1.0346 | 1.0424 | 1.0335 | 1.0407 | 8265600.0 |
| 2000-05-03 11:40:00 | AAPL | Stock | 1.0413 | 1.0413 | 1.0318 | 1.0335 | 6372800.0 |
| 2000-05-03 11:45:00 | AAPL | Stock | 1.0346 | 1.0346 | 1.029 | 1.0313 | 3158400.0 |
| 2000-05-03 11:50:00 | AAPL | Stock | 1.0313 | 1.0324 | 1.0268 | 1.0285 | 2654400.0 |
| 2000-05-03 11:55:00 | AAPL | Stock | 1.029 | 1.0313 | 1.0279 | 1.0307 | 3136000.0 |
| 2000-05-03 12:00:00 | AAPL | Stock | 1.0313 | 1.0368 | 1.0307 | 1.0368 | 1545600.0 |
| 2000-05-03 12:05:00 | AAPL | Stock | 1.0368 | 1.0379 | 1.0357 | 1.0377 | 3684800.0 |
| 2000-05-03 12:10:00 | AAPL | Stock | 1.0363 | 1.0379 | 1.0318 | 1.0346 | 3774400.0 |
| 2000-05-03 12:15:00 | AAPL | Stock | 1.0346 | 1.0346 | 1.0301 | 1.0329 | 4894400.0 |
| 2000-05-03 12:20:00 | AAPL | Stock | 1.0335 | 1.034 | 1.0318 | 1.0338 | 817600.0 |
| 2000-05-03 12:25:00 | AAPL | Stock | 1.0332 | 1.0335 | 1.029 | 1.0296 | 1960000.0 |
| 2000-05-03 12:30:00 | AAPL | Stock | 1.0296 | 1.0301 | 1.0268 | 1.0268 | 3774400.0 |
| 2000-05-03 12:35:00 | AAPL | Stock | 1.0273 | 1.0329 | 1.0251 | 1.0313 | 5163200.0 |
| 2000-05-03 12:40:00 | AAPL | Stock | 1.0313 | 1.0391 | 1.0307 | 1.0379 | 1579200.0 |
| 2000-05-03 12:45:00 | AAPL | Stock | 1.0379 | 1.043 | 1.0357 | 1.043 | 1691200.0 |
| 2000-05-03 12:50:00 | AAPL | Stock | 1.0435 | 1.0452 | 1.0346 | 1.0435 | 2744000.0 |
| 2000-05-03 12:55:00 | AAPL | Stock | 1.043 | 1.0441 | 1.0391 | 1.0407 | 660800.0 |
| 2000-05-03 13:00:00 | AAPL | Stock | 1.0407 | 1.0413 | 1.0335 | 1.0363 | 1220800.0 |
| 2000-05-03 13:05:00 | AAPL | Stock | 1.0357 | 1.0368 | 1.0268 | 1.0313 | 3225600.0 |
| 2000-05-03 13:10:00 | AAPL | Stock | 1.0313 | 1.0335 | 1.0313 | 1.0324 | 347200.0 |
| 2000-05-03 13:15:00 | AAPL | Stock | 1.0324 | 1.0329 | 1.0257 | 1.0262 | 2172800.0 |
| 2000-05-03 13:20:00 | AAPL | Stock | 1.0262 | 1.0268 | 1.0201 | 1.0229 | 6081600.0 |
| 2000-05-03 13:25:00 | AAPL | Stock | 1.0243 | 1.0268 | 1.0223 | 1.0234 | 4468800.0 |
| 2000-05-03 13:30:00 | AAPL | Stock | 1.0229 | 1.029 | 1.0223 | 1.0223 | 3012800.0 |
| 2000-05-03 13:35:00 | AAPL | Stock | 1.0223 | 1.0285 | 1.0218 | 1.0251 | 1713600.0 |
> showing 50 of 83,379 rows — these rows as CSV