PREVIEW / stock_5min / 2007-10-03
file: by_date/stock_5min/2007/2007-10-03.parquet size: 4.2 MB rows: 310,425 symbols: 3,130
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 |
|---|---|---|---|---|---|---|---|
| 2007-10-03 05:50:00 | AAPL | Stock | 5.6439 | 5.6439 | 5.6429 | 5.6429 | 28000.0 |
| 2007-10-03 06:30:00 | AAPL | Stock | 5.6214 | 5.6214 | 5.6214 | 5.6214 | 14000.0 |
| 2007-10-03 07:00:00 | AAPL | Stock | 5.6211 | 5.65 | 5.6211 | 5.6425 | 11200.0 |
| 2007-10-03 07:05:00 | AAPL | Stock | 5.6429 | 5.6429 | 5.6407 | 5.6429 | 19600.0 |
| 2007-10-03 07:10:00 | AAPL | Stock | 5.6286 | 5.6321 | 5.6286 | 5.6321 | 5600.0 |
| 2007-10-03 07:15:00 | AAPL | Stock | 5.6286 | 5.6286 | 5.625 | 5.625 | 8680.0 |
| 2007-10-03 07:20:00 | AAPL | Stock | 5.6214 | 5.6221 | 5.6207 | 5.6214 | 73528.0 |
| 2007-10-03 07:25:00 | AAPL | Stock | 5.6214 | 5.6214 | 5.62 | 5.6214 | 36120.0 |
| 2007-10-03 07:30:00 | AAPL | Stock | 5.62 | 5.6214 | 5.62 | 5.6214 | 8400.0 |
| 2007-10-03 07:35:00 | AAPL | Stock | 5.6246 | 5.625 | 5.6246 | 5.6246 | 25200.0 |
| 2007-10-03 07:40:00 | AAPL | Stock | 5.6254 | 5.6254 | 5.6246 | 5.6246 | 42000.0 |
| 2007-10-03 07:45:00 | AAPL | Stock | 5.6246 | 5.625 | 5.6246 | 5.625 | 98000.0 |
| 2007-10-03 07:50:00 | AAPL | Stock | 5.6254 | 5.6254 | 5.6214 | 5.6214 | 5600.0 |
| 2007-10-03 07:55:00 | AAPL | Stock | 5.6271 | 5.6361 | 5.6271 | 5.6339 | 118160.0 |
| 2007-10-03 08:00:00 | AAPL | Stock | 5.6286 | 5.6589 | 5.6214 | 5.6332 | 3460380.0 |
| 2007-10-03 08:05:00 | AAPL | Stock | 5.6325 | 5.6425 | 5.6325 | 5.6396 | 392672.0 |
| 2007-10-03 08:10:00 | AAPL | Stock | 5.6407 | 5.6407 | 5.6361 | 5.6375 | 235788.0 |
| 2007-10-03 08:15:00 | AAPL | Stock | 5.6375 | 5.6396 | 5.6329 | 5.6396 | 279300.0 |
| 2007-10-03 08:20:00 | AAPL | Stock | 5.6379 | 5.6393 | 5.6368 | 5.6382 | 185696.0 |
| 2007-10-03 08:25:00 | AAPL | Stock | 5.6382 | 5.6386 | 5.6346 | 5.6357 | 284844.0 |
| 2007-10-03 08:30:00 | AAPL | Stock | 5.6343 | 5.6371 | 5.6339 | 5.6339 | 75600.0 |
| 2007-10-03 08:35:00 | AAPL | Stock | 5.6339 | 5.6361 | 5.625 | 5.6357 | 513996.0 |
| 2007-10-03 08:40:00 | AAPL | Stock | 5.6357 | 5.6361 | 5.635 | 5.6357 | 86660.0 |
| 2007-10-03 08:45:00 | AAPL | Stock | 5.6357 | 5.6364 | 5.6311 | 5.6339 | 110460.0 |
| 2007-10-03 08:50:00 | AAPL | Stock | 5.6321 | 5.6357 | 5.63 | 5.6357 | 153440.0 |
| 2007-10-03 08:55:00 | AAPL | Stock | 5.6343 | 5.6361 | 5.6339 | 5.6346 | 64792.0 |
| 2007-10-03 09:00:00 | AAPL | Stock | 5.6339 | 5.6375 | 5.6339 | 5.6375 | 72520.0 |
| 2007-10-03 09:05:00 | AAPL | Stock | 5.6375 | 5.6396 | 5.6357 | 5.6357 | 577500.0 |
| 2007-10-03 09:10:00 | AAPL | Stock | 5.6357 | 5.6361 | 5.6321 | 5.6321 | 480788.0 |
| 2007-10-03 09:15:00 | AAPL | Stock | 5.6318 | 5.6321 | 5.6293 | 5.6293 | 94416.0 |
| 2007-10-03 09:20:00 | AAPL | Stock | 5.6307 | 5.6357 | 5.6293 | 5.6325 | 82320.0 |
| 2007-10-03 09:25:00 | AAPL | Stock | 5.6325 | 5.6479 | 5.6321 | 5.6396 | 771316.0 |
| 2007-10-03 09:30:00 | AAPL | Stock | 5.6396 | 5.6536 | 5.6214 | 5.6286 | 21267848.0 |
| 2007-10-03 09:35:00 | AAPL | Stock | 5.6289 | 5.6514 | 5.6282 | 5.6411 | 13427092.0 |
| 2007-10-03 09:40:00 | AAPL | Stock | 5.6414 | 5.6461 | 5.6246 | 5.6311 | 14072380.0 |
| 2007-10-03 09:45:00 | AAPL | Stock | 5.6321 | 5.6386 | 5.6268 | 5.6375 | 10239012.0 |
| 2007-10-03 09:50:00 | AAPL | Stock | 5.6382 | 5.6418 | 5.625 | 5.6264 | 9732856.0 |
| 2007-10-03 09:55:00 | AAPL | Stock | 5.6264 | 5.6286 | 5.6086 | 5.6136 | 19387032.0 |
| 2007-10-03 10:00:00 | AAPL | Stock | 5.6125 | 5.6304 | 5.6125 | 5.6236 | 12225556.0 |
| 2007-10-03 10:05:00 | AAPL | Stock | 5.6232 | 5.6371 | 5.6171 | 5.6332 | 12095580.0 |
| 2007-10-03 10:10:00 | AAPL | Stock | 5.6329 | 5.6564 | 5.6325 | 5.6532 | 15927744.0 |
| 2007-10-03 10:15:00 | AAPL | Stock | 5.653 | 5.6571 | 5.6443 | 5.6507 | 14835436.0 |
| 2007-10-03 10:20:00 | AAPL | Stock | 5.6507 | 5.6554 | 5.64 | 5.6504 | 11043648.0 |
| 2007-10-03 10:25:00 | AAPL | Stock | 5.6507 | 5.6521 | 5.6418 | 5.6489 | 7266616.0 |
| 2007-10-03 10:30:00 | AAPL | Stock | 5.6489 | 5.6679 | 5.6393 | 5.6571 | 17886344.0 |
| 2007-10-03 10:35:00 | AAPL | Stock | 5.6568 | 5.6679 | 5.6457 | 5.6457 | 16904776.0 |
| 2007-10-03 10:40:00 | AAPL | Stock | 5.6457 | 5.6475 | 5.6346 | 5.6432 | 12137972.0 |
| 2007-10-03 10:45:00 | AAPL | Stock | 5.6432 | 5.6464 | 5.6396 | 5.6429 | 4934356.0 |
| 2007-10-03 10:50:00 | AAPL | Stock | 5.6432 | 5.6604 | 5.6432 | 5.66 | 8359568.0 |
| 2007-10-03 10:55:00 | AAPL | Stock | 5.66 | 5.6636 | 5.6539 | 5.6636 | 10985436.0 |
> showing 50 of 310,425 rows — these rows as CSV