PREVIEW / stock_5min / 2004-09-01
file: by_date/stock_5min/2004/2004-09-01.parquet size: 2.4 MB rows: 177,572 symbols: 1,827
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 |
|---|---|---|---|---|---|---|---|
| 2004-09-01 08:00:00 | AAPL | Stock | 0.6149 | 0.6149 | 0.6149 | 0.6149 | 168448.0 |
| 2004-09-01 08:50:00 | AAPL | Stock | 0.6157 | 0.6157 | 0.6157 | 0.6157 | 5600.0 |
| 2004-09-01 09:25:00 | AAPL | Stock | 0.6141 | 0.615 | 0.6123 | 0.6127 | 264432.0 |
| 2004-09-01 09:30:00 | AAPL | Stock | 0.6125 | 0.6164 | 0.6107 | 0.6161 | 9285864.0 |
| 2004-09-01 09:35:00 | AAPL | Stock | 0.6161 | 0.6163 | 0.6125 | 0.6136 | 3678976.0 |
| 2004-09-01 09:40:00 | AAPL | Stock | 0.6143 | 0.6143 | 0.6129 | 0.6136 | 3676904.0 |
| 2004-09-01 09:45:00 | AAPL | Stock | 0.6132 | 0.6161 | 0.6132 | 0.6161 | 3205720.0 |
| 2004-09-01 09:50:00 | AAPL | Stock | 0.6161 | 0.6164 | 0.6134 | 0.6157 | 5302920.0 |
| 2004-09-01 09:55:00 | AAPL | Stock | 0.6155 | 0.6168 | 0.6152 | 0.6163 | 3271800.0 |
| 2004-09-01 10:00:00 | AAPL | Stock | 0.6161 | 0.619 | 0.6157 | 0.6188 | 3418016.0 |
| 2004-09-01 10:05:00 | AAPL | Stock | 0.6189 | 0.62 | 0.6182 | 0.6191 | 5855416.0 |
| 2004-09-01 10:10:00 | AAPL | Stock | 0.6195 | 0.6241 | 0.6189 | 0.6239 | 6884360.0 |
| 2004-09-01 10:15:00 | AAPL | Stock | 0.6239 | 0.625 | 0.6229 | 0.6229 | 10340456.0 |
| 2004-09-01 10:20:00 | AAPL | Stock | 0.623 | 0.6243 | 0.6225 | 0.6243 | 2240224.0 |
| 2004-09-01 10:25:00 | AAPL | Stock | 0.6243 | 0.6268 | 0.6232 | 0.6264 | 8105104.0 |
| 2004-09-01 10:30:00 | AAPL | Stock | 0.6266 | 0.6268 | 0.6229 | 0.6243 | 6503952.0 |
| 2004-09-01 10:35:00 | AAPL | Stock | 0.6243 | 0.6245 | 0.6218 | 0.6225 | 4094384.0 |
| 2004-09-01 10:40:00 | AAPL | Stock | 0.6225 | 0.6245 | 0.6216 | 0.6243 | 3837512.0 |
| 2004-09-01 10:45:00 | AAPL | Stock | 0.6245 | 0.625 | 0.6227 | 0.6246 | 3944864.0 |
| 2004-09-01 10:50:00 | AAPL | Stock | 0.6245 | 0.6263 | 0.6241 | 0.6254 | 3136168.0 |
| 2004-09-01 10:55:00 | AAPL | Stock | 0.6254 | 0.6257 | 0.6239 | 0.6241 | 2593864.0 |
| 2004-09-01 11:00:00 | AAPL | Stock | 0.6241 | 0.6247 | 0.6239 | 0.6243 | 1461432.0 |
| 2004-09-01 11:05:00 | AAPL | Stock | 0.6241 | 0.6243 | 0.6229 | 0.6229 | 1211728.0 |
| 2004-09-01 11:10:00 | AAPL | Stock | 0.6229 | 0.6241 | 0.6229 | 0.6234 | 2167760.0 |
| 2004-09-01 11:15:00 | AAPL | Stock | 0.623 | 0.6238 | 0.6223 | 0.6223 | 1813672.0 |
| 2004-09-01 11:20:00 | AAPL | Stock | 0.6223 | 0.6229 | 0.621 | 0.622 | 2706480.0 |
| 2004-09-01 11:25:00 | AAPL | Stock | 0.622 | 0.6229 | 0.6218 | 0.6223 | 1923824.0 |
| 2004-09-01 11:30:00 | AAPL | Stock | 0.622 | 0.6221 | 0.6202 | 0.6203 | 3244136.0 |
| 2004-09-01 11:35:00 | AAPL | Stock | 0.6203 | 0.6211 | 0.6198 | 0.6198 | 3259088.0 |
| 2004-09-01 11:40:00 | AAPL | Stock | 0.6198 | 0.6216 | 0.6193 | 0.6216 | 3356192.0 |
| 2004-09-01 11:45:00 | AAPL | Stock | 0.6216 | 0.6241 | 0.6216 | 0.6238 | 3000088.0 |
| 2004-09-01 11:50:00 | AAPL | Stock | 0.6238 | 0.6261 | 0.6236 | 0.6255 | 4226432.0 |
| 2004-09-01 11:55:00 | AAPL | Stock | 0.6252 | 0.6261 | 0.6246 | 0.6257 | 3827320.0 |
| 2004-09-01 12:00:00 | AAPL | Stock | 0.6257 | 0.6264 | 0.6255 | 0.6264 | 3800160.0 |
| 2004-09-01 12:05:00 | AAPL | Stock | 0.6264 | 0.6266 | 0.625 | 0.6254 | 2868320.0 |
| 2004-09-01 12:10:00 | AAPL | Stock | 0.6257 | 0.6261 | 0.6255 | 0.6259 | 1869672.0 |
| 2004-09-01 12:15:00 | AAPL | Stock | 0.6261 | 0.6288 | 0.6261 | 0.6282 | 7362544.0 |
| 2004-09-01 12:20:00 | AAPL | Stock | 0.6282 | 0.632 | 0.6277 | 0.6316 | 11744936.0 |
| 2004-09-01 12:25:00 | AAPL | Stock | 0.6311 | 0.6334 | 0.6305 | 0.6332 | 12004384.0 |
| 2004-09-01 12:30:00 | AAPL | Stock | 0.6329 | 0.6364 | 0.6329 | 0.6348 | 17587584.0 |
| 2004-09-01 12:35:00 | AAPL | Stock | 0.635 | 0.6369 | 0.6343 | 0.6352 | 22792896.0 |
| 2004-09-01 12:40:00 | AAPL | Stock | 0.635 | 0.6388 | 0.6346 | 0.6388 | 10180576.0 |
| 2004-09-01 12:45:00 | AAPL | Stock | 0.6386 | 0.6414 | 0.6384 | 0.6413 | 19318152.0 |
| 2004-09-01 12:50:00 | AAPL | Stock | 0.6413 | 0.6416 | 0.637 | 0.637 | 13950440.0 |
| 2004-09-01 12:55:00 | AAPL | Stock | 0.637 | 0.638 | 0.6363 | 0.6371 | 5692624.0 |
| 2004-09-01 13:00:00 | AAPL | Stock | 0.6371 | 0.6371 | 0.6338 | 0.6338 | 7158368.0 |
| 2004-09-01 13:05:00 | AAPL | Stock | 0.6339 | 0.635 | 0.6304 | 0.6307 | 15395128.0 |
| 2004-09-01 13:10:00 | AAPL | Stock | 0.6307 | 0.6343 | 0.6293 | 0.633 | 18077864.0 |
| 2004-09-01 13:15:00 | AAPL | Stock | 0.6332 | 0.638 | 0.6321 | 0.6359 | 11910024.0 |
| 2004-09-01 13:20:00 | AAPL | Stock | 0.6366 | 0.6396 | 0.6352 | 0.6395 | 9772224.0 |
> showing 50 of 177,572 rows — these rows as CSV