PREVIEW / stock_5min / 2011-04-14
file: by_date/stock_5min/2011/2011-04-14.parquet size: 4.7 MB rows: 322,072 symbols: 3,515
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 |
|---|---|---|---|---|---|---|---|
| 2011-04-14 04:10:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-04-14 05:10:00 | AAPL | Stock | 11.9664 | 11.9664 | 11.9664 | 11.9664 | 2800.0 |
| 2011-04-14 05:30:00 | AAPL | Stock | 11.9714 | 11.9714 | 11.97 | 11.97 | 14000.0 |
| 2011-04-14 05:55:00 | AAPL | Stock | 11.9464 | 11.9464 | 11.9464 | 11.9464 | 28000.0 |
| 2011-04-14 06:05:00 | AAPL | Stock | 11.9379 | 11.9379 | 11.9286 | 11.9286 | 5600.0 |
| 2011-04-14 06:15:00 | AAPL | Stock | 11.9321 | 11.9321 | 11.9286 | 11.9286 | 14000.0 |
| 2011-04-14 06:30:00 | AAPL | Stock | 11.9371 | 11.9371 | 11.9286 | 11.9286 | 8400.0 |
| 2011-04-14 06:35:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9286 | 11.9286 | 2800.0 |
| 2011-04-14 06:40:00 | AAPL | Stock | 11.9493 | 11.9493 | 11.9493 | 11.9493 | 2800.0 |
| 2011-04-14 06:45:00 | AAPL | Stock | 11.9393 | 11.9393 | 11.9393 | 11.9393 | 12880.0 |
| 2011-04-14 07:00:00 | AAPL | Stock | 11.9321 | 11.9464 | 11.9232 | 11.9232 | 46480.0 |
| 2011-04-14 07:05:00 | AAPL | Stock | 11.9196 | 11.9321 | 11.9146 | 11.9286 | 164780.0 |
| 2011-04-14 07:10:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9286 | 11.9286 | 14000.0 |
| 2011-04-14 07:15:00 | AAPL | Stock | 11.9282 | 11.9282 | 11.9282 | 11.9282 | 2800.0 |
| 2011-04-14 07:20:00 | AAPL | Stock | 11.9282 | 11.9321 | 11.9257 | 11.9286 | 114800.0 |
| 2011-04-14 07:25:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.925 | 11.925 | 19656.0 |
| 2011-04-14 07:30:00 | AAPL | Stock | 11.9246 | 11.9268 | 11.9207 | 11.9268 | 91224.0 |
| 2011-04-14 07:35:00 | AAPL | Stock | 11.9375 | 11.9375 | 11.9296 | 11.9296 | 5600.0 |
| 2011-04-14 07:40:00 | AAPL | Stock | 11.9368 | 11.9368 | 11.9354 | 11.9357 | 14840.0 |
| 2011-04-14 07:45:00 | AAPL | Stock | 11.9361 | 11.9361 | 11.9286 | 11.9293 | 39900.0 |
| 2011-04-14 07:50:00 | AAPL | Stock | 11.9357 | 11.9375 | 11.9218 | 11.9275 | 60760.0 |
| 2011-04-14 07:55:00 | AAPL | Stock | 11.9275 | 11.9318 | 11.9261 | 11.9314 | 99400.0 |
| 2011-04-14 08:00:00 | AAPL | Stock | 11.9296 | 11.9468 | 11.9296 | 11.9464 | 313208.0 |
| 2011-04-14 08:05:00 | AAPL | Stock | 11.95 | 11.9514 | 11.9464 | 11.9468 | 24332.0 |
| 2011-04-14 08:10:00 | AAPL | Stock | 11.9518 | 11.9536 | 11.9432 | 11.9436 | 127568.0 |
| 2011-04-14 08:15:00 | AAPL | Stock | 11.9464 | 11.9464 | 11.9432 | 11.9432 | 21560.0 |
| 2011-04-14 08:20:00 | AAPL | Stock | 11.9461 | 11.9464 | 11.9386 | 11.9429 | 85148.0 |
| 2011-04-14 08:25:00 | AAPL | Stock | 11.9464 | 11.9518 | 11.9464 | 11.9471 | 62244.0 |
| 2011-04-14 08:30:00 | AAPL | Stock | 11.9446 | 11.9607 | 11.9325 | 11.9482 | 495320.0 |
| 2011-04-14 08:35:00 | AAPL | Stock | 11.9479 | 11.9496 | 11.9429 | 11.9496 | 53060.0 |
| 2011-04-14 08:40:00 | AAPL | Stock | 11.9429 | 11.9429 | 11.9414 | 11.9414 | 9352.0 |
| 2011-04-14 08:45:00 | AAPL | Stock | 11.9393 | 11.9425 | 11.9346 | 11.9425 | 75628.0 |
| 2011-04-14 08:50:00 | AAPL | Stock | 11.9536 | 11.9714 | 11.9536 | 11.97 | 116676.0 |
| 2011-04-14 08:55:00 | AAPL | Stock | 11.9643 | 11.975 | 11.9643 | 11.9725 | 131712.0 |
| 2011-04-14 09:00:00 | AAPL | Stock | 11.9696 | 11.9696 | 11.9596 | 11.9607 | 95620.0 |
| 2011-04-14 09:05:00 | AAPL | Stock | 11.9575 | 11.9596 | 11.9536 | 11.9596 | 135800.0 |
| 2011-04-14 09:10:00 | AAPL | Stock | 11.96 | 11.965 | 11.9568 | 11.9646 | 116732.0 |
| 2011-04-14 09:15:00 | AAPL | Stock | 11.9668 | 11.9675 | 11.9607 | 11.9607 | 123200.0 |
| 2011-04-14 09:20:00 | AAPL | Stock | 11.9607 | 11.9607 | 11.9507 | 11.9511 | 141820.0 |
| 2011-04-14 09:25:00 | AAPL | Stock | 11.9475 | 11.9689 | 11.9429 | 11.9636 | 720328.0 |
| 2011-04-14 09:30:00 | AAPL | Stock | 11.9636 | 12.0 | 11.9446 | 11.9594 | 15591912.0 |
| 2011-04-14 09:35:00 | AAPL | Stock | 11.9593 | 11.9643 | 11.9286 | 11.9375 | 10337488.0 |
| 2011-04-14 09:40:00 | AAPL | Stock | 11.937 | 11.9557 | 11.9168 | 11.9282 | 10488548.0 |
| 2011-04-14 09:45:00 | AAPL | Stock | 11.9273 | 11.9343 | 11.9107 | 11.9121 | 7032004.0 |
| 2011-04-14 09:50:00 | AAPL | Stock | 11.9146 | 11.9346 | 11.9021 | 11.9196 | 7988288.0 |
| 2011-04-14 09:55:00 | AAPL | Stock | 11.9207 | 11.9421 | 11.9104 | 11.9389 | 7023548.0 |
| 2011-04-14 10:00:00 | AAPL | Stock | 11.9393 | 11.94 | 11.9214 | 11.9236 | 4630248.0 |
| 2011-04-14 10:05:00 | AAPL | Stock | 11.9249 | 11.9446 | 11.9164 | 11.9382 | 5544420.0 |
| 2011-04-14 10:10:00 | AAPL | Stock | 11.9369 | 11.9579 | 11.9239 | 11.9269 | 5795692.0 |
| 2011-04-14 10:15:00 | AAPL | Stock | 11.925 | 11.9371 | 11.9236 | 11.9314 | 3472028.0 |
> showing 50 of 322,072 rows — these rows as CSV