PREVIEW / stock_5min / 2000-08-28
file: by_date/stock_5min/2000/2000-08-28.parquet size: 1.1 MB rows: 87,213 symbols: 1,219
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-08-28 08:00:00 | AAPL | Stock | 1.014 | 1.014 | 1.014 | 1.014 | 100800.0 |
| 2000-08-28 08:30:00 | AAPL | Stock | 1.0145 | 1.0156 | 1.0134 | 1.0134 | 84000.0 |
| 2000-08-28 09:00:00 | AAPL | Stock | 1.0134 | 1.0134 | 1.0134 | 1.0134 | 5600.0 |
| 2000-08-28 09:25:00 | AAPL | Stock | 1.0145 | 1.0201 | 1.0145 | 1.0201 | 375200.0 |
| 2000-08-28 09:30:00 | AAPL | Stock | 1.0223 | 1.0223 | 1.019 | 1.0223 | 6288800.0 |
| 2000-08-28 09:35:00 | AAPL | Stock | 1.0212 | 1.0379 | 1.0201 | 1.0368 | 21039200.0 |
| 2000-08-28 09:40:00 | AAPL | Stock | 1.0357 | 1.0379 | 1.0313 | 1.0368 | 8887200.0 |
| 2000-08-28 09:45:00 | AAPL | Stock | 1.0346 | 1.0402 | 1.0335 | 1.0368 | 7610400.0 |
| 2000-08-28 09:50:00 | AAPL | Stock | 1.0379 | 1.0446 | 1.0357 | 1.0446 | 10740800.0 |
| 2000-08-28 09:55:00 | AAPL | Stock | 1.0446 | 1.0446 | 1.0391 | 1.0413 | 10063200.0 |
| 2000-08-28 10:00:00 | AAPL | Stock | 1.0435 | 1.0446 | 1.0402 | 1.0407 | 7140000.0 |
| 2000-08-28 10:05:00 | AAPL | Stock | 1.0402 | 1.0424 | 1.0368 | 1.0368 | 3981600.0 |
| 2000-08-28 10:10:00 | AAPL | Stock | 1.0368 | 1.0424 | 1.0368 | 1.0424 | 5510400.0 |
| 2000-08-28 10:15:00 | AAPL | Stock | 1.0424 | 1.0424 | 1.0402 | 1.0413 | 2290400.0 |
| 2000-08-28 10:20:00 | AAPL | Stock | 1.0424 | 1.0502 | 1.0413 | 1.048 | 7890400.0 |
| 2000-08-28 10:25:00 | AAPL | Stock | 1.048 | 1.0536 | 1.0469 | 1.0502 | 6535200.0 |
| 2000-08-28 10:30:00 | AAPL | Stock | 1.0502 | 1.0513 | 1.0469 | 1.0491 | 2951200.0 |
| 2000-08-28 10:35:00 | AAPL | Stock | 1.0491 | 1.0536 | 1.0491 | 1.0513 | 8758400.0 |
| 2000-08-28 10:40:00 | AAPL | Stock | 1.0513 | 1.0536 | 1.0469 | 1.0491 | 7067200.0 |
| 2000-08-28 10:45:00 | AAPL | Stock | 1.0502 | 1.0502 | 1.0469 | 1.0469 | 4043200.0 |
| 2000-08-28 10:50:00 | AAPL | Stock | 1.0491 | 1.0491 | 1.0469 | 1.048 | 3701600.0 |
| 2000-08-28 10:55:00 | AAPL | Stock | 1.048 | 1.0491 | 1.0391 | 1.0402 | 3578400.0 |
| 2000-08-28 11:00:00 | AAPL | Stock | 1.0402 | 1.0402 | 1.0379 | 1.0391 | 8120000.0 |
| 2000-08-28 11:05:00 | AAPL | Stock | 1.0379 | 1.0424 | 1.0379 | 1.0424 | 9497600.0 |
| 2000-08-28 11:10:00 | AAPL | Stock | 1.0424 | 1.0446 | 1.0424 | 1.0435 | 3712800.0 |
| 2000-08-28 11:15:00 | AAPL | Stock | 1.0424 | 1.0469 | 1.0424 | 1.0446 | 3600800.0 |
| 2000-08-28 11:20:00 | AAPL | Stock | 1.0446 | 1.0446 | 1.0424 | 1.0435 | 1086400.0 |
| 2000-08-28 11:25:00 | AAPL | Stock | 1.0435 | 1.0435 | 1.0413 | 1.0413 | 3617600.0 |
| 2000-08-28 11:30:00 | AAPL | Stock | 1.0413 | 1.0424 | 1.0402 | 1.0413 | 2234400.0 |
| 2000-08-28 11:35:00 | AAPL | Stock | 1.0424 | 1.0424 | 1.0379 | 1.0379 | 4351200.0 |
| 2000-08-28 11:40:00 | AAPL | Stock | 1.0379 | 1.0396 | 1.0357 | 1.0391 | 2178400.0 |
| 2000-08-28 11:45:00 | AAPL | Stock | 1.0391 | 1.0402 | 1.0368 | 1.0368 | 4300800.0 |
| 2000-08-28 11:50:00 | AAPL | Stock | 1.0357 | 1.0379 | 1.0335 | 1.0346 | 6809600.0 |
| 2000-08-28 11:55:00 | AAPL | Stock | 1.0346 | 1.0368 | 1.0335 | 1.0357 | 3108000.0 |
| 2000-08-28 12:00:00 | AAPL | Stock | 1.0357 | 1.0368 | 1.0346 | 1.0368 | 3455200.0 |
| 2000-08-28 12:05:00 | AAPL | Stock | 1.0368 | 1.0379 | 1.0357 | 1.0368 | 2928800.0 |
| 2000-08-28 12:10:00 | AAPL | Stock | 1.0368 | 1.0379 | 1.0357 | 1.0368 | 2228800.0 |
| 2000-08-28 12:15:00 | AAPL | Stock | 1.0357 | 1.0391 | 1.0357 | 1.0391 | 4020800.0 |
| 2000-08-28 12:20:00 | AAPL | Stock | 1.0379 | 1.0391 | 1.0379 | 1.0391 | 3343200.0 |
| 2000-08-28 12:25:00 | AAPL | Stock | 1.0391 | 1.0391 | 1.0379 | 1.0379 | 2189600.0 |
| 2000-08-28 12:30:00 | AAPL | Stock | 1.0391 | 1.0391 | 1.0379 | 1.0379 | 1024800.0 |
| 2000-08-28 12:35:00 | AAPL | Stock | 1.0379 | 1.0424 | 1.0368 | 1.0413 | 9245600.0 |
| 2000-08-28 12:40:00 | AAPL | Stock | 1.0424 | 1.0424 | 1.0391 | 1.0402 | 2744000.0 |
| 2000-08-28 12:45:00 | AAPL | Stock | 1.0402 | 1.0424 | 1.0379 | 1.0402 | 924000.0 |
| 2000-08-28 12:50:00 | AAPL | Stock | 1.0402 | 1.0413 | 1.0402 | 1.0413 | 2368800.0 |
| 2000-08-28 12:55:00 | AAPL | Stock | 1.0413 | 1.0413 | 1.0402 | 1.0413 | 1920800.0 |
| 2000-08-28 13:00:00 | AAPL | Stock | 1.0413 | 1.0413 | 1.0402 | 1.0413 | 2923200.0 |
| 2000-08-28 13:05:00 | AAPL | Stock | 1.0402 | 1.0424 | 1.0402 | 1.0419 | 4860800.0 |
| 2000-08-28 13:10:00 | AAPL | Stock | 1.0424 | 1.0424 | 1.0413 | 1.0424 | 3438400.0 |
| 2000-08-28 13:15:00 | AAPL | Stock | 1.0413 | 1.0424 | 1.0391 | 1.0391 | 1444800.0 |
> showing 50 of 87,213 rows — these rows as CSV