PREVIEW / stock_5min / 2007-12-10
file: by_date/stock_5min/2007/2007-12-10.parquet size: 4.3 MB rows: 320,274 symbols: 3,241
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-12-10 05:25:00 | AAPL | Stock | 6.9346 | 6.9375 | 6.9346 | 6.9375 | 52444.0 |
| 2007-12-10 05:35:00 | AAPL | Stock | 6.9407 | 6.9407 | 6.9407 | 6.9407 | 2800.0 |
| 2007-12-10 05:40:00 | AAPL | Stock | 6.9204 | 6.9204 | 6.9104 | 6.9104 | 5600.0 |
| 2007-12-10 06:35:00 | AAPL | Stock | 6.9471 | 6.9604 | 6.9471 | 6.9554 | 36400.0 |
| 2007-12-10 06:40:00 | AAPL | Stock | 6.9554 | 6.9554 | 6.9554 | 6.9554 | 2800.0 |
| 2007-12-10 07:00:00 | AAPL | Stock | 6.9482 | 6.9482 | 6.9339 | 6.9339 | 72800.0 |
| 2007-12-10 07:05:00 | AAPL | Stock | 6.9339 | 6.9339 | 6.9189 | 6.9304 | 95200.0 |
| 2007-12-10 07:10:00 | AAPL | Stock | 6.9354 | 6.9354 | 6.9354 | 6.9354 | 28000.0 |
| 2007-12-10 07:20:00 | AAPL | Stock | 6.9375 | 6.9375 | 6.9375 | 6.9375 | 9520.0 |
| 2007-12-10 07:25:00 | AAPL | Stock | 6.9286 | 6.9286 | 6.9286 | 6.9286 | 2800.0 |
| 2007-12-10 07:30:00 | AAPL | Stock | 6.9286 | 6.9375 | 6.9282 | 6.9282 | 60144.0 |
| 2007-12-10 07:45:00 | AAPL | Stock | 6.935 | 6.9375 | 6.935 | 6.9375 | 80052.0 |
| 2007-12-10 07:50:00 | AAPL | Stock | 6.9375 | 6.9375 | 6.9357 | 6.9375 | 70700.0 |
| 2007-12-10 07:55:00 | AAPL | Stock | 6.9375 | 6.95 | 6.9375 | 6.95 | 159600.0 |
| 2007-12-10 08:00:00 | AAPL | Stock | 6.95 | 6.9539 | 6.9136 | 6.92 | 1011500.0 |
| 2007-12-10 08:05:00 | AAPL | Stock | 6.9232 | 6.9357 | 6.9214 | 6.9286 | 776216.0 |
| 2007-12-10 08:10:00 | AAPL | Stock | 6.9286 | 6.9286 | 6.9129 | 6.9129 | 308840.0 |
| 2007-12-10 08:15:00 | AAPL | Stock | 6.9179 | 6.9179 | 6.9086 | 6.9107 | 325920.0 |
| 2007-12-10 08:20:00 | AAPL | Stock | 6.9107 | 6.9268 | 6.9107 | 6.9268 | 209244.0 |
| 2007-12-10 08:25:00 | AAPL | Stock | 6.9268 | 6.9318 | 6.9268 | 6.9286 | 388108.0 |
| 2007-12-10 08:30:00 | AAPL | Stock | 6.9286 | 6.9314 | 6.9271 | 6.9279 | 435456.0 |
| 2007-12-10 08:35:00 | AAPL | Stock | 6.9311 | 6.9311 | 6.9218 | 6.9264 | 854476.0 |
| 2007-12-10 08:40:00 | AAPL | Stock | 6.9261 | 6.9261 | 6.9207 | 6.9221 | 384776.0 |
| 2007-12-10 08:45:00 | AAPL | Stock | 6.9225 | 6.9239 | 6.8954 | 6.9071 | 884716.0 |
| 2007-12-10 08:50:00 | AAPL | Stock | 6.9096 | 6.9107 | 6.8929 | 6.8929 | 1129268.0 |
| 2007-12-10 08:55:00 | AAPL | Stock | 6.8975 | 6.9046 | 6.8929 | 6.8971 | 692132.0 |
| 2007-12-10 09:00:00 | AAPL | Stock | 6.9011 | 6.9029 | 6.8971 | 6.8971 | 96180.0 |
| 2007-12-10 09:05:00 | AAPL | Stock | 6.8996 | 6.8996 | 6.8836 | 6.8879 | 1329468.0 |
| 2007-12-10 09:10:00 | AAPL | Stock | 6.8879 | 6.8986 | 6.8839 | 6.8964 | 953036.0 |
| 2007-12-10 09:15:00 | AAPL | Stock | 6.8964 | 6.9071 | 6.895 | 6.9043 | 300496.0 |
| 2007-12-10 09:20:00 | AAPL | Stock | 6.9064 | 6.9064 | 6.8968 | 6.9032 | 219492.0 |
| 2007-12-10 09:25:00 | AAPL | Stock | 6.9046 | 6.9186 | 6.9018 | 6.9136 | 1364524.0 |
| 2007-12-10 09:30:00 | AAPL | Stock | 6.9139 | 6.9314 | 6.8818 | 6.9207 | 35479024.0 |
| 2007-12-10 09:35:00 | AAPL | Stock | 6.9221 | 6.9311 | 6.9021 | 6.9221 | 21802452.0 |
| 2007-12-10 09:40:00 | AAPL | Stock | 6.9218 | 6.9636 | 6.9196 | 6.9514 | 30209088.0 |
| 2007-12-10 09:45:00 | AAPL | Stock | 6.9514 | 6.9536 | 6.9268 | 6.9382 | 18573548.0 |
| 2007-12-10 09:50:00 | AAPL | Stock | 6.9382 | 6.9396 | 6.9232 | 6.9236 | 12525044.0 |
| 2007-12-10 09:55:00 | AAPL | Stock | 6.9236 | 6.9368 | 6.9096 | 6.91 | 14963116.0 |
| 2007-12-10 10:00:00 | AAPL | Stock | 6.9111 | 6.9286 | 6.9011 | 6.9246 | 16531592.0 |
| 2007-12-10 10:05:00 | AAPL | Stock | 6.9264 | 6.9304 | 6.9196 | 6.9286 | 10750992.0 |
| 2007-12-10 10:10:00 | AAPL | Stock | 6.9279 | 6.9286 | 6.9004 | 6.9164 | 14250096.0 |
| 2007-12-10 10:15:00 | AAPL | Stock | 6.9171 | 6.9232 | 6.8929 | 6.8968 | 16801232.0 |
| 2007-12-10 10:20:00 | AAPL | Stock | 6.8964 | 6.9132 | 6.8957 | 6.9025 | 12043892.0 |
| 2007-12-10 10:25:00 | AAPL | Stock | 6.9021 | 6.9064 | 6.8893 | 6.9036 | 12463108.0 |
| 2007-12-10 10:30:00 | AAPL | Stock | 6.9036 | 6.925 | 6.9025 | 6.9221 | 11348092.0 |
| 2007-12-10 10:35:00 | AAPL | Stock | 6.9214 | 6.9286 | 6.9161 | 6.9246 | 9945656.0 |
| 2007-12-10 10:40:00 | AAPL | Stock | 6.9239 | 6.9414 | 6.9122 | 6.9268 | 13740384.0 |
| 2007-12-10 10:45:00 | AAPL | Stock | 6.9268 | 6.9371 | 6.9239 | 6.9289 | 7297780.0 |
| 2007-12-10 10:50:00 | AAPL | Stock | 6.9282 | 6.9332 | 6.9239 | 6.9332 | 4879000.0 |
| 2007-12-10 10:55:00 | AAPL | Stock | 6.9332 | 6.9393 | 6.9271 | 6.9382 | 6381900.0 |
> showing 50 of 320,274 rows — these rows as CSV