PREVIEW / stock_5min / 2007-11-21
file: by_date/stock_5min/2007/2007-11-21.parquet size: 4.3 MB rows: 311,965 symbols: 3,193
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-11-21 05:15:00 | AAPL | Stock | 5.95 | 5.95 | 5.95 | 5.95 | 11928.0 |
| 2007-11-21 06:00:00 | AAPL | Stock | 5.9314 | 5.9314 | 5.9314 | 5.9314 | 6328.0 |
| 2007-11-21 07:00:00 | AAPL | Stock | 5.9493 | 5.9771 | 5.9493 | 5.9657 | 67144.0 |
| 2007-11-21 07:10:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9643 | 5.9643 | 26600.0 |
| 2007-11-21 07:15:00 | AAPL | Stock | 5.965 | 5.965 | 5.965 | 5.965 | 5600.0 |
| 2007-11-21 07:20:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9643 | 5.9643 | 56000.0 |
| 2007-11-21 07:25:00 | AAPL | Stock | 5.9375 | 5.9375 | 5.9071 | 5.9071 | 84000.0 |
| 2007-11-21 07:30:00 | AAPL | Stock | 5.9286 | 5.9286 | 5.9286 | 5.9286 | 17304.0 |
| 2007-11-21 07:35:00 | AAPL | Stock | 5.9286 | 5.9464 | 5.9286 | 5.935 | 74200.0 |
| 2007-11-21 07:40:00 | AAPL | Stock | 5.9307 | 5.9375 | 5.9296 | 5.9375 | 14000.0 |
| 2007-11-21 07:45:00 | AAPL | Stock | 5.9507 | 5.9714 | 5.9464 | 5.9464 | 143220.0 |
| 2007-11-21 07:50:00 | AAPL | Stock | 5.9607 | 5.9607 | 5.9607 | 5.9607 | 28000.0 |
| 2007-11-21 07:55:00 | AAPL | Stock | 5.9582 | 5.9582 | 5.9432 | 5.9432 | 112000.0 |
| 2007-11-21 08:00:00 | AAPL | Stock | 5.9446 | 5.9643 | 5.9182 | 5.9532 | 943460.0 |
| 2007-11-21 08:05:00 | AAPL | Stock | 5.95 | 5.9536 | 5.9325 | 5.9393 | 563248.0 |
| 2007-11-21 08:10:00 | AAPL | Stock | 5.9393 | 5.9464 | 5.9286 | 5.9325 | 451556.0 |
| 2007-11-21 08:15:00 | AAPL | Stock | 5.9339 | 5.9414 | 5.9282 | 5.9286 | 542108.0 |
| 2007-11-21 08:20:00 | AAPL | Stock | 5.9286 | 5.9357 | 5.9246 | 5.9321 | 264488.0 |
| 2007-11-21 08:25:00 | AAPL | Stock | 5.9311 | 5.9311 | 5.9196 | 5.92 | 394520.0 |
| 2007-11-21 08:30:00 | AAPL | Stock | 5.9214 | 5.9375 | 5.9214 | 5.9311 | 589260.0 |
| 2007-11-21 08:35:00 | AAPL | Stock | 5.9314 | 5.9375 | 5.9236 | 5.9286 | 435568.0 |
| 2007-11-21 08:40:00 | AAPL | Stock | 5.9286 | 5.9286 | 5.9214 | 5.9221 | 297444.0 |
| 2007-11-21 08:45:00 | AAPL | Stock | 5.9232 | 5.9304 | 5.9214 | 5.9214 | 379708.0 |
| 2007-11-21 08:50:00 | AAPL | Stock | 5.9214 | 5.9286 | 5.9125 | 5.9279 | 1116920.0 |
| 2007-11-21 08:55:00 | AAPL | Stock | 5.9279 | 5.94 | 5.9279 | 5.9361 | 928872.0 |
| 2007-11-21 09:00:00 | AAPL | Stock | 5.9386 | 5.9393 | 5.9329 | 5.9339 | 564396.0 |
| 2007-11-21 09:05:00 | AAPL | Stock | 5.9336 | 5.9336 | 5.9107 | 5.9146 | 1043812.0 |
| 2007-11-21 09:10:00 | AAPL | Stock | 5.9186 | 5.9218 | 5.9125 | 5.9196 | 725956.0 |
| 2007-11-21 09:15:00 | AAPL | Stock | 5.9204 | 5.9261 | 5.9107 | 5.9125 | 1829912.0 |
| 2007-11-21 09:20:00 | AAPL | Stock | 5.9107 | 5.9211 | 5.9107 | 5.9136 | 277844.0 |
| 2007-11-21 09:25:00 | AAPL | Stock | 5.9139 | 5.9214 | 5.9018 | 5.9214 | 833868.0 |
| 2007-11-21 09:30:00 | AAPL | Stock | 5.9236 | 5.9554 | 5.8929 | 5.9532 | 33619684.0 |
| 2007-11-21 09:35:00 | AAPL | Stock | 5.9535 | 5.9657 | 5.9218 | 5.9546 | 26962376.0 |
| 2007-11-21 09:40:00 | AAPL | Stock | 5.9546 | 5.9818 | 5.9446 | 5.9639 | 27220452.0 |
| 2007-11-21 09:45:00 | AAPL | Stock | 5.9629 | 5.9793 | 5.9307 | 5.9486 | 25158868.0 |
| 2007-11-21 09:50:00 | AAPL | Stock | 5.9489 | 5.9821 | 5.9321 | 5.9682 | 21094080.0 |
| 2007-11-21 09:55:00 | AAPL | Stock | 5.9679 | 5.9946 | 5.9554 | 5.9775 | 21865060.0 |
| 2007-11-21 10:00:00 | AAPL | Stock | 5.9775 | 6.0 | 5.9479 | 5.9507 | 27688080.0 |
| 2007-11-21 10:05:00 | AAPL | Stock | 5.9514 | 5.9739 | 5.9411 | 5.9614 | 13827436.0 |
| 2007-11-21 10:10:00 | AAPL | Stock | 5.96 | 5.9804 | 5.9404 | 5.9732 | 13802068.0 |
| 2007-11-21 10:15:00 | AAPL | Stock | 5.9714 | 5.9982 | 5.955 | 5.9929 | 17161564.0 |
| 2007-11-21 10:20:00 | AAPL | Stock | 5.9943 | 5.995 | 5.95 | 5.9575 | 13570368.0 |
| 2007-11-21 10:25:00 | AAPL | Stock | 5.9571 | 5.9729 | 5.9507 | 5.9607 | 7682668.0 |
| 2007-11-21 10:30:00 | AAPL | Stock | 5.9618 | 5.9682 | 5.9243 | 5.9243 | 18479524.0 |
| 2007-11-21 10:35:00 | AAPL | Stock | 5.9243 | 5.9464 | 5.9171 | 5.9411 | 19566596.0 |
| 2007-11-21 10:40:00 | AAPL | Stock | 5.9393 | 5.9511 | 5.9275 | 5.9357 | 14618520.0 |
| 2007-11-21 10:45:00 | AAPL | Stock | 5.9368 | 5.9443 | 5.9179 | 5.9204 | 14356580.0 |
| 2007-11-21 10:50:00 | AAPL | Stock | 5.9204 | 5.9214 | 5.8929 | 5.8929 | 17336256.0 |
| 2007-11-21 10:55:00 | AAPL | Stock | 5.8929 | 5.9189 | 5.8929 | 5.915 | 13512744.0 |
| 2007-11-21 11:00:00 | AAPL | Stock | 5.915 | 5.9189 | 5.8811 | 5.8916 | 15879920.0 |
> showing 50 of 311,965 rows — these rows as CSV