PREVIEW / stock_5min / 2000-04-24
file: by_date/stock_5min/2000/2000-04-24.parquet size: 1.1 MB rows: 83,720 symbols: 1,160
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-04-24 09:30:00 | AAPL | Stock | 1.0268 | 1.0346 | 1.0246 | 1.034 | 11121600.0 |
| 2000-04-24 09:35:00 | AAPL | Stock | 1.0324 | 1.0324 | 1.0262 | 1.0301 | 12331200.0 |
| 2000-04-24 09:40:00 | AAPL | Stock | 1.029 | 1.048 | 1.0268 | 1.0446 | 17035200.0 |
| 2000-04-24 09:45:00 | AAPL | Stock | 1.0446 | 1.0474 | 1.0357 | 1.0385 | 12096000.0 |
| 2000-04-24 09:50:00 | AAPL | Stock | 1.0385 | 1.0446 | 1.0313 | 1.0446 | 7470400.0 |
| 2000-04-24 09:55:00 | AAPL | Stock | 1.0424 | 1.0441 | 1.0301 | 1.0346 | 9732800.0 |
| 2000-04-24 10:00:00 | AAPL | Stock | 1.0346 | 1.0368 | 1.0301 | 1.034 | 8904000.0 |
| 2000-04-24 10:05:00 | AAPL | Stock | 1.034 | 1.0379 | 1.0335 | 1.0368 | 14268800.0 |
| 2000-04-24 10:10:00 | AAPL | Stock | 1.0357 | 1.0413 | 1.0313 | 1.0399 | 4961600.0 |
| 2000-04-24 10:15:00 | AAPL | Stock | 1.0399 | 1.0424 | 1.029 | 1.0318 | 10158400.0 |
| 2000-04-24 10:20:00 | AAPL | Stock | 1.0324 | 1.0357 | 1.0285 | 1.034 | 6787200.0 |
| 2000-04-24 10:25:00 | AAPL | Stock | 1.029 | 1.0324 | 1.0279 | 1.0315 | 2732800.0 |
| 2000-04-24 10:30:00 | AAPL | Stock | 1.0324 | 1.0357 | 1.0301 | 1.0324 | 7840000.0 |
| 2000-04-24 10:35:00 | AAPL | Stock | 1.0324 | 1.0357 | 1.0324 | 1.0352 | 7952000.0 |
| 2000-04-24 10:40:00 | AAPL | Stock | 1.0352 | 1.0357 | 1.029 | 1.0357 | 4446400.0 |
| 2000-04-24 10:45:00 | AAPL | Stock | 1.0363 | 1.0396 | 1.0346 | 1.0396 | 8288000.0 |
| 2000-04-24 10:50:00 | AAPL | Stock | 1.0396 | 1.0402 | 1.0324 | 1.0391 | 2419200.0 |
| 2000-04-24 10:55:00 | AAPL | Stock | 1.0391 | 1.0402 | 1.029 | 1.0391 | 3964800.0 |
| 2000-04-24 11:00:00 | AAPL | Stock | 1.0399 | 1.0413 | 1.0346 | 1.0346 | 2049600.0 |
| 2000-04-24 11:05:00 | AAPL | Stock | 1.0352 | 1.0402 | 1.0346 | 1.0402 | 5857600.0 |
| 2000-04-24 11:10:00 | AAPL | Stock | 1.0391 | 1.0402 | 1.0357 | 1.0374 | 2296000.0 |
| 2000-04-24 11:15:00 | AAPL | Stock | 1.0385 | 1.0402 | 1.0368 | 1.0385 | 1388800.0 |
| 2000-04-24 11:20:00 | AAPL | Stock | 1.0402 | 1.0413 | 1.0374 | 1.0374 | 2318400.0 |
| 2000-04-24 11:25:00 | AAPL | Stock | 1.0396 | 1.0424 | 1.0374 | 1.0399 | 2408000.0 |
| 2000-04-24 11:30:00 | AAPL | Stock | 1.0396 | 1.0413 | 1.0379 | 1.0402 | 2598400.0 |
| 2000-04-24 11:35:00 | AAPL | Stock | 1.0413 | 1.0424 | 1.0374 | 1.0424 | 1680000.0 |
| 2000-04-24 11:40:00 | AAPL | Stock | 1.0424 | 1.0435 | 1.0385 | 1.0424 | 2385600.0 |
| 2000-04-24 11:45:00 | AAPL | Stock | 1.0419 | 1.0458 | 1.0413 | 1.0446 | 14795200.0 |
| 2000-04-24 11:50:00 | AAPL | Stock | 1.0449 | 1.0463 | 1.0424 | 1.0424 | 9452800.0 |
| 2000-04-24 11:55:00 | AAPL | Stock | 1.043 | 1.0469 | 1.043 | 1.0452 | 5006400.0 |
| 2000-04-24 12:00:00 | AAPL | Stock | 1.0458 | 1.0469 | 1.0441 | 1.0469 | 5779200.0 |
| 2000-04-24 12:05:00 | AAPL | Stock | 1.0458 | 1.0511 | 1.0407 | 1.0424 | 7560000.0 |
| 2000-04-24 12:10:00 | AAPL | Stock | 1.0441 | 1.0446 | 1.0357 | 1.0357 | 2990400.0 |
| 2000-04-24 12:15:00 | AAPL | Stock | 1.0357 | 1.0441 | 1.0357 | 1.0441 | 1892800.0 |
| 2000-04-24 12:20:00 | AAPL | Stock | 1.0424 | 1.0458 | 1.0402 | 1.0458 | 2531200.0 |
| 2000-04-24 12:25:00 | AAPL | Stock | 1.0446 | 1.0458 | 1.0446 | 1.0458 | 1444800.0 |
| 2000-04-24 12:30:00 | AAPL | Stock | 1.0446 | 1.0458 | 1.0446 | 1.0452 | 2475200.0 |
| 2000-04-24 12:35:00 | AAPL | Stock | 1.0452 | 1.0458 | 1.0446 | 1.0458 | 3315200.0 |
| 2000-04-24 12:40:00 | AAPL | Stock | 1.0458 | 1.0469 | 1.0446 | 1.0446 | 7078400.0 |
| 2000-04-24 12:45:00 | AAPL | Stock | 1.0449 | 1.0449 | 1.0419 | 1.0435 | 571200.0 |
| 2000-04-24 12:50:00 | AAPL | Stock | 1.043 | 1.0441 | 1.0419 | 1.0441 | 548800.0 |
| 2000-04-24 12:55:00 | AAPL | Stock | 1.0435 | 1.0491 | 1.0424 | 1.0485 | 4558400.0 |
| 2000-04-24 13:00:00 | AAPL | Stock | 1.0469 | 1.0513 | 1.0469 | 1.0502 | 5801600.0 |
| 2000-04-24 13:05:00 | AAPL | Stock | 1.0497 | 1.0536 | 1.0497 | 1.0536 | 16352000.0 |
| 2000-04-24 13:10:00 | AAPL | Stock | 1.0536 | 1.058 | 1.053 | 1.0541 | 2240000.0 |
| 2000-04-24 13:15:00 | AAPL | Stock | 1.0541 | 1.0569 | 1.0536 | 1.0569 | 2721600.0 |
| 2000-04-24 13:20:00 | AAPL | Stock | 1.0569 | 1.0575 | 1.0513 | 1.0536 | 2475200.0 |
| 2000-04-24 13:25:00 | AAPL | Stock | 1.0533 | 1.058 | 1.0525 | 1.0558 | 3908800.0 |
| 2000-04-24 13:30:00 | AAPL | Stock | 1.0575 | 1.0625 | 1.0564 | 1.058 | 6708800.0 |
| 2000-04-24 13:35:00 | AAPL | Stock | 1.058 | 1.0603 | 1.0547 | 1.058 | 3550400.0 |
> showing 50 of 83,720 rows — these rows as CSV