PREVIEW / stock_5min / 2007-09-14
file: by_date/stock_5min/2007/2007-09-14.parquet size: 3.8 MB rows: 285,412 symbols: 3,090
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-09-14 09:30:00 | AAPL | Stock | 4.8775 | 4.8907 | 4.8643 | 4.8771 | 18262524.0 |
| 2007-09-14 09:35:00 | AAPL | Stock | 4.8768 | 4.9107 | 4.875 | 4.9057 | 17191468.0 |
| 2007-09-14 09:40:00 | AAPL | Stock | 4.9068 | 4.9254 | 4.905 | 4.9075 | 20422388.0 |
| 2007-09-14 09:45:00 | AAPL | Stock | 4.9071 | 4.9111 | 4.8932 | 4.9029 | 11706604.0 |
| 2007-09-14 09:50:00 | AAPL | Stock | 4.9036 | 4.9268 | 4.9004 | 4.9236 | 13130964.0 |
| 2007-09-14 09:55:00 | AAPL | Stock | 4.9236 | 4.9268 | 4.9036 | 4.9118 | 9796416.0 |
| 2007-09-14 10:00:00 | AAPL | Stock | 4.9118 | 4.9232 | 4.9064 | 4.9143 | 14555828.0 |
| 2007-09-14 10:05:00 | AAPL | Stock | 4.9143 | 4.9286 | 4.91 | 4.9264 | 13276032.0 |
| 2007-09-14 10:10:00 | AAPL | Stock | 4.9267 | 4.9282 | 4.9189 | 4.9225 | 8345372.0 |
| 2007-09-14 10:15:00 | AAPL | Stock | 4.9225 | 4.9321 | 4.9171 | 4.9171 | 16358916.0 |
| 2007-09-14 10:20:00 | AAPL | Stock | 4.9171 | 4.9282 | 4.9171 | 4.9196 | 8109388.0 |
| 2007-09-14 10:25:00 | AAPL | Stock | 4.92 | 4.9264 | 4.9171 | 4.9229 | 4503436.0 |
| 2007-09-14 10:30:00 | AAPL | Stock | 4.9218 | 4.9264 | 4.9179 | 4.9257 | 5628728.0 |
| 2007-09-14 10:35:00 | AAPL | Stock | 4.9246 | 4.9421 | 4.9246 | 4.9393 | 16737112.0 |
| 2007-09-14 10:40:00 | AAPL | Stock | 4.9393 | 4.955 | 4.9332 | 4.9543 | 21938784.0 |
| 2007-09-14 10:45:00 | AAPL | Stock | 4.9543 | 4.9636 | 4.9504 | 4.9536 | 15941772.0 |
| 2007-09-14 10:50:00 | AAPL | Stock | 4.9532 | 4.9539 | 4.9436 | 4.9475 | 8149988.0 |
| 2007-09-14 10:55:00 | AAPL | Stock | 4.9475 | 4.9514 | 4.9411 | 4.9471 | 7061488.0 |
| 2007-09-14 11:00:00 | AAPL | Stock | 4.9471 | 4.9532 | 4.9429 | 4.9518 | 6002696.0 |
| 2007-09-14 11:05:00 | AAPL | Stock | 4.9514 | 4.9546 | 4.9461 | 4.95 | 7026600.0 |
| 2007-09-14 11:10:00 | AAPL | Stock | 4.95 | 4.9503 | 4.9289 | 4.9354 | 11291560.0 |
| 2007-09-14 11:15:00 | AAPL | Stock | 4.935 | 4.9414 | 4.9336 | 4.9375 | 4354140.0 |
| 2007-09-14 11:20:00 | AAPL | Stock | 4.9371 | 4.9371 | 4.9254 | 4.9296 | 7197092.0 |
| 2007-09-14 11:25:00 | AAPL | Stock | 4.9293 | 4.9368 | 4.9268 | 4.9318 | 6547772.0 |
| 2007-09-14 11:30:00 | AAPL | Stock | 4.9318 | 4.9329 | 4.9225 | 4.9246 | 5272988.0 |
| 2007-09-14 11:35:00 | AAPL | Stock | 4.9246 | 4.9304 | 4.9239 | 4.9279 | 3884552.0 |
| 2007-09-14 11:40:00 | AAPL | Stock | 4.9279 | 4.9411 | 4.9271 | 4.9353 | 7681604.0 |
| 2007-09-14 11:45:00 | AAPL | Stock | 4.9354 | 4.9393 | 4.9344 | 4.9361 | 3221820.0 |
| 2007-09-14 11:50:00 | AAPL | Stock | 4.9361 | 4.94 | 4.9314 | 4.94 | 3921708.0 |
| 2007-09-14 11:55:00 | AAPL | Stock | 4.94 | 4.9543 | 4.9393 | 4.9418 | 8774528.0 |
| 2007-09-14 12:00:00 | AAPL | Stock | 4.9421 | 4.9536 | 4.9414 | 4.9418 | 5654012.0 |
| 2007-09-14 12:05:00 | AAPL | Stock | 4.9418 | 4.9429 | 4.9371 | 4.9409 | 4031776.0 |
| 2007-09-14 12:10:00 | AAPL | Stock | 4.9407 | 4.9425 | 4.9307 | 4.9321 | 3978212.0 |
| 2007-09-14 12:15:00 | AAPL | Stock | 4.9318 | 4.9361 | 4.9257 | 4.9308 | 4672360.0 |
| 2007-09-14 12:20:00 | AAPL | Stock | 4.9309 | 4.9386 | 4.9293 | 4.9357 | 2321956.0 |
| 2007-09-14 12:25:00 | AAPL | Stock | 4.9359 | 4.9364 | 4.9321 | 4.9339 | 2358188.0 |
| 2007-09-14 12:30:00 | AAPL | Stock | 4.935 | 4.9389 | 4.9289 | 4.9304 | 2936948.0 |
| 2007-09-14 12:35:00 | AAPL | Stock | 4.9304 | 4.9357 | 4.9304 | 4.9329 | 1776348.0 |
| 2007-09-14 12:40:00 | AAPL | Stock | 4.9336 | 4.9357 | 4.9304 | 4.9325 | 1649928.0 |
| 2007-09-14 12:45:00 | AAPL | Stock | 4.9325 | 4.9325 | 4.92 | 4.9232 | 6279980.0 |
| 2007-09-14 12:50:00 | AAPL | Stock | 4.9229 | 4.9286 | 4.92 | 4.9271 | 3095736.0 |
| 2007-09-14 12:55:00 | AAPL | Stock | 4.9264 | 4.9304 | 4.9229 | 4.9257 | 3705716.0 |
| 2007-09-14 13:00:00 | AAPL | Stock | 4.9257 | 4.9286 | 4.9229 | 4.9229 | 2754612.0 |
| 2007-09-14 13:05:00 | AAPL | Stock | 4.9236 | 4.9268 | 4.9196 | 4.9218 | 4772572.0 |
| 2007-09-14 13:10:00 | AAPL | Stock | 4.9218 | 4.9318 | 4.9196 | 4.9286 | 4759720.0 |
| 2007-09-14 13:15:00 | AAPL | Stock | 4.9289 | 4.9293 | 4.9221 | 4.9246 | 2882432.0 |
| 2007-09-14 13:20:00 | AAPL | Stock | 4.925 | 4.9314 | 4.9221 | 4.9314 | 3948644.0 |
| 2007-09-14 13:25:00 | AAPL | Stock | 4.9311 | 4.9386 | 4.9286 | 4.9375 | 4821488.0 |
| 2007-09-14 13:30:00 | AAPL | Stock | 4.9371 | 4.9375 | 4.9318 | 4.9336 | 2908136.0 |
| 2007-09-14 13:35:00 | AAPL | Stock | 4.9339 | 4.9343 | 4.9264 | 4.9304 | 3578008.0 |
> showing 50 of 285,412 rows — these rows as CSV