PREVIEW / stock_5min / 2000-04-17
file: by_date/stock_5min/2000/2000-04-17.parquet size: 1.3 MB rows: 96,442 symbols: 1,163
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-17 09:30:00 | AAPL | Stock | 0.9777 | 0.9944 | 0.9738 | 0.9944 | 6798400.0 |
| 2000-04-17 09:35:00 | AAPL | Stock | 0.9911 | 1.0128 | 0.9749 | 1.0095 | 5320000.0 |
| 2000-04-17 09:40:00 | AAPL | Stock | 1.005 | 1.0179 | 0.9972 | 1.0112 | 3852800.0 |
| 2000-04-17 09:45:00 | AAPL | Stock | 1.0112 | 1.0234 | 1.0089 | 1.0232 | 6462400.0 |
| 2000-04-17 09:50:00 | AAPL | Stock | 1.0215 | 1.0379 | 1.0095 | 1.0335 | 7907200.0 |
| 2000-04-17 09:55:00 | AAPL | Stock | 1.0318 | 1.0346 | 1.0134 | 1.0223 | 7201600.0 |
| 2000-04-17 10:00:00 | AAPL | Stock | 1.0229 | 1.0268 | 1.0145 | 1.0201 | 6809600.0 |
| 2000-04-17 10:05:00 | AAPL | Stock | 1.0218 | 1.0265 | 1.0167 | 1.0167 | 10584000.0 |
| 2000-04-17 10:10:00 | AAPL | Stock | 1.0167 | 1.0179 | 1.0145 | 1.0151 | 5118400.0 |
| 2000-04-17 10:15:00 | AAPL | Stock | 1.0156 | 1.0209 | 1.0134 | 1.0151 | 6171200.0 |
| 2000-04-17 10:20:00 | AAPL | Stock | 1.014 | 1.0179 | 1.01 | 1.0106 | 4558400.0 |
| 2000-04-17 10:25:00 | AAPL | Stock | 1.0145 | 1.0173 | 1.0078 | 1.0078 | 4726400.0 |
| 2000-04-17 10:30:00 | AAPL | Stock | 1.0078 | 1.0212 | 1.0 | 1.0184 | 5622400.0 |
| 2000-04-17 10:35:00 | AAPL | Stock | 1.0184 | 1.0346 | 1.0179 | 1.0346 | 4334400.0 |
| 2000-04-17 10:40:00 | AAPL | Stock | 1.0346 | 1.0357 | 1.0251 | 1.0307 | 3348800.0 |
| 2000-04-17 10:45:00 | AAPL | Stock | 1.0304 | 1.0402 | 1.0246 | 1.0391 | 4054400.0 |
| 2000-04-17 10:50:00 | AAPL | Stock | 1.0391 | 1.043 | 1.0268 | 1.0385 | 3819200.0 |
| 2000-04-17 10:55:00 | AAPL | Stock | 1.0391 | 1.0536 | 1.0368 | 1.0513 | 4681600.0 |
| 2000-04-17 11:00:00 | AAPL | Stock | 1.0525 | 1.0597 | 1.0441 | 1.0449 | 4278400.0 |
| 2000-04-17 11:05:00 | AAPL | Stock | 1.0446 | 1.0452 | 1.0368 | 1.0413 | 2318400.0 |
| 2000-04-17 11:10:00 | AAPL | Stock | 1.0419 | 1.0491 | 1.0402 | 1.0458 | 2172800.0 |
| 2000-04-17 11:15:00 | AAPL | Stock | 1.0458 | 1.0491 | 1.0379 | 1.0379 | 2643200.0 |
| 2000-04-17 11:20:00 | AAPL | Stock | 1.0379 | 1.0435 | 1.0346 | 1.043 | 2363200.0 |
| 2000-04-17 11:25:00 | AAPL | Stock | 1.0446 | 1.048 | 1.0402 | 1.0402 | 2587200.0 |
| 2000-04-17 11:30:00 | AAPL | Stock | 1.0402 | 1.0469 | 1.0402 | 1.0469 | 1579200.0 |
| 2000-04-17 11:35:00 | AAPL | Stock | 1.0466 | 1.0525 | 1.0446 | 1.0469 | 5700800.0 |
| 2000-04-17 11:40:00 | AAPL | Stock | 1.0463 | 1.0469 | 1.0407 | 1.0458 | 2116800.0 |
| 2000-04-17 11:45:00 | AAPL | Stock | 1.0446 | 1.046 | 1.0402 | 1.0413 | 1915200.0 |
| 2000-04-17 11:50:00 | AAPL | Stock | 1.0402 | 1.0446 | 1.0357 | 1.0446 | 2352000.0 |
| 2000-04-17 11:55:00 | AAPL | Stock | 1.0446 | 1.0446 | 1.0363 | 1.0363 | 2486400.0 |
| 2000-04-17 12:00:00 | AAPL | Stock | 1.0363 | 1.0407 | 1.0313 | 1.0313 | 2318400.0 |
| 2000-04-17 12:05:00 | AAPL | Stock | 1.0313 | 1.0357 | 1.0273 | 1.0273 | 2027200.0 |
| 2000-04-17 12:10:00 | AAPL | Stock | 1.0273 | 1.0335 | 1.0229 | 1.0324 | 2352000.0 |
| 2000-04-17 12:15:00 | AAPL | Stock | 1.0296 | 1.0352 | 1.024 | 1.0279 | 3808000.0 |
| 2000-04-17 12:20:00 | AAPL | Stock | 1.0268 | 1.0313 | 1.019 | 1.019 | 1836800.0 |
| 2000-04-17 12:25:00 | AAPL | Stock | 1.019 | 1.0206 | 1.0123 | 1.0128 | 2900800.0 |
| 2000-04-17 12:30:00 | AAPL | Stock | 1.0128 | 1.0128 | 1.0022 | 1.0022 | 2889600.0 |
| 2000-04-17 12:35:00 | AAPL | Stock | 1.0011 | 1.0179 | 0.9961 | 1.0112 | 5756800.0 |
| 2000-04-17 12:40:00 | AAPL | Stock | 1.01 | 1.0123 | 1.0022 | 1.0022 | 3483200.0 |
| 2000-04-17 12:45:00 | AAPL | Stock | 1.0028 | 1.0167 | 1.0 | 1.0167 | 4379200.0 |
| 2000-04-17 12:50:00 | AAPL | Stock | 1.0165 | 1.019 | 1.0095 | 1.0145 | 1960000.0 |
| 2000-04-17 12:55:00 | AAPL | Stock | 1.0153 | 1.0268 | 1.0134 | 1.024 | 4760000.0 |
| 2000-04-17 13:00:00 | AAPL | Stock | 1.0234 | 1.0285 | 1.0229 | 1.0262 | 4256000.0 |
| 2000-04-17 13:05:00 | AAPL | Stock | 1.0262 | 1.0262 | 1.0134 | 1.0223 | 2318400.0 |
| 2000-04-17 13:10:00 | AAPL | Stock | 1.0209 | 1.029 | 1.0112 | 1.0262 | 2296000.0 |
| 2000-04-17 13:15:00 | AAPL | Stock | 1.0223 | 1.0313 | 1.0223 | 1.0301 | 5801600.0 |
| 2000-04-17 13:20:00 | AAPL | Stock | 1.0324 | 1.0335 | 1.0246 | 1.0246 | 4076800.0 |
| 2000-04-17 13:25:00 | AAPL | Stock | 1.0254 | 1.0335 | 1.0251 | 1.0301 | 2206400.0 |
| 2000-04-17 13:30:00 | AAPL | Stock | 1.0335 | 1.0335 | 1.0257 | 1.029 | 2553600.0 |
| 2000-04-17 13:35:00 | AAPL | Stock | 1.0257 | 1.0368 | 1.0257 | 1.0313 | 2060800.0 |
> showing 50 of 96,442 rows — these rows as CSV