PREVIEW / stock_5min / 2000-05-18
file: by_date/stock_5min/2000/2000-05-18.parquet size: 1.0 MB rows: 79,105 symbols: 1,158
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-18 09:30:00 | AAPL | Stock | 0.9196 | 0.9196 | 0.9107 | 0.9135 | 15747200.0 |
| 2000-05-18 09:35:00 | AAPL | Stock | 0.9135 | 0.9258 | 0.9135 | 0.9258 | 9721600.0 |
| 2000-05-18 09:40:00 | AAPL | Stock | 0.9258 | 0.9263 | 0.9213 | 0.9219 | 5924800.0 |
| 2000-05-18 09:45:00 | AAPL | Stock | 0.9213 | 0.9224 | 0.9152 | 0.9163 | 7302400.0 |
| 2000-05-18 09:50:00 | AAPL | Stock | 0.9163 | 0.9185 | 0.9141 | 0.9146 | 6003200.0 |
| 2000-05-18 09:55:00 | AAPL | Stock | 0.9146 | 0.923 | 0.9141 | 0.9174 | 11782400.0 |
| 2000-05-18 10:00:00 | AAPL | Stock | 0.9174 | 0.918 | 0.9102 | 0.9163 | 6272000.0 |
| 2000-05-18 10:05:00 | AAPL | Stock | 0.9163 | 0.9235 | 0.9163 | 0.9196 | 4648000.0 |
| 2000-05-18 10:10:00 | AAPL | Stock | 0.9213 | 0.9219 | 0.9152 | 0.9191 | 5936000.0 |
| 2000-05-18 10:15:00 | AAPL | Stock | 0.9185 | 0.9213 | 0.9157 | 0.9157 | 5947200.0 |
| 2000-05-18 10:20:00 | AAPL | Stock | 0.9163 | 0.9185 | 0.9141 | 0.9152 | 2755200.0 |
| 2000-05-18 10:25:00 | AAPL | Stock | 0.9152 | 0.9185 | 0.9152 | 0.9166 | 3875200.0 |
| 2000-05-18 10:30:00 | AAPL | Stock | 0.9163 | 0.918 | 0.9163 | 0.9163 | 3035200.0 |
| 2000-05-18 10:35:00 | AAPL | Stock | 0.9174 | 0.918 | 0.9157 | 0.9157 | 3438400.0 |
| 2000-05-18 10:40:00 | AAPL | Stock | 0.9163 | 0.9208 | 0.9157 | 0.9202 | 6417600.0 |
| 2000-05-18 10:45:00 | AAPL | Stock | 0.9208 | 0.9263 | 0.9174 | 0.9252 | 11144000.0 |
| 2000-05-18 10:50:00 | AAPL | Stock | 0.9263 | 0.9263 | 0.9219 | 0.9258 | 2116800.0 |
| 2000-05-18 10:55:00 | AAPL | Stock | 0.9258 | 0.9269 | 0.923 | 0.9269 | 4457600.0 |
| 2000-05-18 11:00:00 | AAPL | Stock | 0.9269 | 0.9308 | 0.9258 | 0.9275 | 6854400.0 |
| 2000-05-18 11:05:00 | AAPL | Stock | 0.9275 | 0.9308 | 0.9275 | 0.9297 | 7224000.0 |
| 2000-05-18 11:10:00 | AAPL | Stock | 0.9291 | 0.9308 | 0.9272 | 0.9308 | 15232000.0 |
| 2000-05-18 11:15:00 | AAPL | Stock | 0.9308 | 0.9369 | 0.9297 | 0.9314 | 8948800.0 |
| 2000-05-18 11:20:00 | AAPL | Stock | 0.9308 | 0.933 | 0.9263 | 0.9275 | 3472000.0 |
| 2000-05-18 11:25:00 | AAPL | Stock | 0.928 | 0.928 | 0.9241 | 0.9252 | 3483200.0 |
| 2000-05-18 11:30:00 | AAPL | Stock | 0.9241 | 0.9241 | 0.9191 | 0.9196 | 3987200.0 |
| 2000-05-18 11:35:00 | AAPL | Stock | 0.9196 | 0.9208 | 0.9146 | 0.9152 | 6104000.0 |
| 2000-05-18 11:40:00 | AAPL | Stock | 0.9157 | 0.9219 | 0.9155 | 0.918 | 5051200.0 |
| 2000-05-18 11:45:00 | AAPL | Stock | 0.9208 | 0.9241 | 0.9196 | 0.9208 | 4345600.0 |
| 2000-05-18 11:50:00 | AAPL | Stock | 0.9208 | 0.9219 | 0.918 | 0.9191 | 15792000.0 |
| 2000-05-18 11:55:00 | AAPL | Stock | 0.9191 | 0.9196 | 0.9185 | 0.9196 | 6171200.0 |
| 2000-05-18 12:00:00 | AAPL | Stock | 0.9185 | 0.9213 | 0.9185 | 0.9202 | 6708800.0 |
| 2000-05-18 12:05:00 | AAPL | Stock | 0.9208 | 0.9241 | 0.9202 | 0.9235 | 4547200.0 |
| 2000-05-18 12:10:00 | AAPL | Stock | 0.9241 | 0.9258 | 0.9224 | 0.9252 | 1355200.0 |
| 2000-05-18 12:15:00 | AAPL | Stock | 0.9241 | 0.9247 | 0.9224 | 0.9224 | 1881600.0 |
| 2000-05-18 12:20:00 | AAPL | Stock | 0.923 | 0.9252 | 0.9224 | 0.9247 | 2531200.0 |
| 2000-05-18 12:25:00 | AAPL | Stock | 0.9263 | 0.9275 | 0.9241 | 0.9263 | 3449600.0 |
| 2000-05-18 12:30:00 | AAPL | Stock | 0.9263 | 0.9269 | 0.9247 | 0.9252 | 1500800.0 |
| 2000-05-18 12:35:00 | AAPL | Stock | 0.9252 | 0.9258 | 0.9219 | 0.9224 | 6966400.0 |
| 2000-05-18 12:40:00 | AAPL | Stock | 0.9224 | 0.9235 | 0.9208 | 0.9235 | 1310400.0 |
| 2000-05-18 12:45:00 | AAPL | Stock | 0.9219 | 0.9235 | 0.9185 | 0.9185 | 1870400.0 |
| 2000-05-18 12:50:00 | AAPL | Stock | 0.9185 | 0.9208 | 0.9185 | 0.9208 | 168000.0 |
| 2000-05-18 12:55:00 | AAPL | Stock | 0.9208 | 0.9219 | 0.9185 | 0.9219 | 582400.0 |
| 2000-05-18 13:00:00 | AAPL | Stock | 0.9208 | 0.9227 | 0.9202 | 0.9224 | 459200.0 |
| 2000-05-18 13:05:00 | AAPL | Stock | 0.9224 | 0.9241 | 0.9224 | 0.9241 | 291200.0 |
| 2000-05-18 13:10:00 | AAPL | Stock | 0.9235 | 0.9241 | 0.9219 | 0.9235 | 459200.0 |
| 2000-05-18 13:15:00 | AAPL | Stock | 0.9224 | 0.9235 | 0.9191 | 0.9196 | 1153600.0 |
| 2000-05-18 13:20:00 | AAPL | Stock | 0.9196 | 0.9202 | 0.9191 | 0.9191 | 1635200.0 |
| 2000-05-18 13:25:00 | AAPL | Stock | 0.9191 | 0.9208 | 0.9191 | 0.9196 | 2273600.0 |
| 2000-05-18 13:30:00 | AAPL | Stock | 0.9191 | 0.9196 | 0.9191 | 0.9196 | 2531200.0 |
| 2000-05-18 13:35:00 | AAPL | Stock | 0.9208 | 0.9213 | 0.9196 | 0.9202 | 1108800.0 |
> showing 50 of 79,105 rows — these rows as CSV