PREVIEW / stock_5min / 2000-09-12
file: by_date/stock_5min/2000/2000-09-12.parquet size: 1.2 MB rows: 90,376 symbols: 1,224
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-12 08:00:00 | AAPL | Stock | 1.0441 | 1.0441 | 1.0441 | 1.0441 | 184800.0 |
| 2000-09-12 08:05:00 | AAPL | Stock | 1.0491 | 1.0491 | 1.0491 | 1.0491 | 22400.0 |
| 2000-09-12 08:25:00 | AAPL | Stock | 1.0536 | 1.0597 | 1.0536 | 1.0597 | 39200.0 |
| 2000-09-12 09:20:00 | AAPL | Stock | 1.0513 | 1.0513 | 1.0513 | 1.0513 | 212800.0 |
| 2000-09-12 09:25:00 | AAPL | Stock | 1.048 | 1.048 | 1.0246 | 1.0246 | 789600.0 |
| 2000-09-12 09:30:00 | AAPL | Stock | 1.024 | 1.029 | 1.0234 | 1.0257 | 6188000.0 |
| 2000-09-12 09:35:00 | AAPL | Stock | 1.0257 | 1.0268 | 1.0234 | 1.0257 | 5958400.0 |
| 2000-09-12 09:40:00 | AAPL | Stock | 1.0257 | 1.0357 | 1.0246 | 1.0301 | 4782400.0 |
| 2000-09-12 09:45:00 | AAPL | Stock | 1.0324 | 1.0335 | 1.029 | 1.0313 | 2156000.0 |
| 2000-09-12 09:50:00 | AAPL | Stock | 1.0335 | 1.0335 | 1.0234 | 1.029 | 2184000.0 |
| 2000-09-12 09:55:00 | AAPL | Stock | 1.0279 | 1.029 | 1.0234 | 1.0246 | 2296000.0 |
| 2000-09-12 10:00:00 | AAPL | Stock | 1.0234 | 1.0379 | 1.0212 | 1.0379 | 5924800.0 |
| 2000-09-12 10:05:00 | AAPL | Stock | 1.0379 | 1.0491 | 1.0357 | 1.0458 | 3908800.0 |
| 2000-09-12 10:10:00 | AAPL | Stock | 1.0463 | 1.0491 | 1.0402 | 1.0469 | 5415200.0 |
| 2000-09-12 10:15:00 | AAPL | Stock | 1.0446 | 1.048 | 1.0379 | 1.0402 | 4888800.0 |
| 2000-09-12 10:20:00 | AAPL | Stock | 1.0402 | 1.0435 | 1.0391 | 1.0424 | 1260000.0 |
| 2000-09-12 10:25:00 | AAPL | Stock | 1.0424 | 1.0446 | 1.0402 | 1.0402 | 1764000.0 |
| 2000-09-12 10:30:00 | AAPL | Stock | 1.0391 | 1.0391 | 1.0335 | 1.0368 | 1153600.0 |
| 2000-09-12 10:35:00 | AAPL | Stock | 1.0357 | 1.0368 | 1.0313 | 1.0313 | 2956800.0 |
| 2000-09-12 10:40:00 | AAPL | Stock | 1.029 | 1.0446 | 1.029 | 1.0446 | 1338400.0 |
| 2000-09-12 10:45:00 | AAPL | Stock | 1.0435 | 1.0446 | 1.0413 | 1.0446 | 1181600.0 |
| 2000-09-12 10:50:00 | AAPL | Stock | 1.0435 | 1.0435 | 1.0402 | 1.0407 | 963200.0 |
| 2000-09-12 10:55:00 | AAPL | Stock | 1.0402 | 1.0458 | 1.0402 | 1.0435 | 1898400.0 |
| 2000-09-12 11:00:00 | AAPL | Stock | 1.0435 | 1.0491 | 1.0424 | 1.0446 | 1226400.0 |
| 2000-09-12 11:05:00 | AAPL | Stock | 1.0435 | 1.0491 | 1.0435 | 1.048 | 1204000.0 |
| 2000-09-12 11:10:00 | AAPL | Stock | 1.048 | 1.048 | 1.0446 | 1.0469 | 1808800.0 |
| 2000-09-12 11:15:00 | AAPL | Stock | 1.048 | 1.0513 | 1.0469 | 1.0513 | 1002400.0 |
| 2000-09-12 11:20:00 | AAPL | Stock | 1.0513 | 1.058 | 1.0502 | 1.0558 | 2861600.0 |
| 2000-09-12 11:25:00 | AAPL | Stock | 1.0558 | 1.0603 | 1.0558 | 1.058 | 1976800.0 |
| 2000-09-12 11:30:00 | AAPL | Stock | 1.0603 | 1.067 | 1.0597 | 1.0625 | 2671200.0 |
| 2000-09-12 11:35:00 | AAPL | Stock | 1.067 | 1.0714 | 1.0647 | 1.0703 | 4340000.0 |
| 2000-09-12 11:40:00 | AAPL | Stock | 1.0703 | 1.0703 | 1.0614 | 1.0692 | 3091200.0 |
| 2000-09-12 11:45:00 | AAPL | Stock | 1.0692 | 1.0703 | 1.067 | 1.0681 | 1394400.0 |
| 2000-09-12 11:50:00 | AAPL | Stock | 1.0692 | 1.0692 | 1.067 | 1.0681 | 1752800.0 |
| 2000-09-12 11:55:00 | AAPL | Stock | 1.0681 | 1.0681 | 1.0647 | 1.0658 | 1092000.0 |
| 2000-09-12 12:00:00 | AAPL | Stock | 1.0653 | 1.0681 | 1.0647 | 1.0658 | 2508800.0 |
| 2000-09-12 12:05:00 | AAPL | Stock | 1.0658 | 1.0681 | 1.0658 | 1.0675 | 1136800.0 |
| 2000-09-12 12:10:00 | AAPL | Stock | 1.067 | 1.0692 | 1.0658 | 1.0658 | 560000.0 |
| 2000-09-12 12:15:00 | AAPL | Stock | 1.0647 | 1.067 | 1.0647 | 1.0658 | 481600.0 |
| 2000-09-12 12:20:00 | AAPL | Stock | 1.0658 | 1.067 | 1.0647 | 1.067 | 1069600.0 |
| 2000-09-12 12:25:00 | AAPL | Stock | 1.0658 | 1.067 | 1.0647 | 1.0658 | 672000.0 |
| 2000-09-12 12:30:00 | AAPL | Stock | 1.067 | 1.0714 | 1.0658 | 1.0703 | 1388800.0 |
| 2000-09-12 12:35:00 | AAPL | Stock | 1.067 | 1.0725 | 1.067 | 1.0714 | 3528000.0 |
| 2000-09-12 12:40:00 | AAPL | Stock | 1.0714 | 1.072 | 1.0681 | 1.0692 | 705600.0 |
| 2000-09-12 12:45:00 | AAPL | Stock | 1.0692 | 1.0703 | 1.0681 | 1.0681 | 1086400.0 |
| 2000-09-12 12:50:00 | AAPL | Stock | 1.0692 | 1.0703 | 1.067 | 1.0692 | 1612800.0 |
| 2000-09-12 12:55:00 | AAPL | Stock | 1.0703 | 1.0714 | 1.0681 | 1.0692 | 2016000.0 |
| 2000-09-12 13:00:00 | AAPL | Stock | 1.0692 | 1.0692 | 1.0681 | 1.0681 | 459200.0 |
| 2000-09-12 13:05:00 | AAPL | Stock | 1.0692 | 1.0692 | 1.0692 | 1.0692 | 235200.0 |
| 2000-09-12 13:10:00 | AAPL | Stock | 1.0692 | 1.0692 | 1.067 | 1.0692 | 470400.0 |
> showing 50 of 90,376 rows — these rows as CSV