PREVIEW / stock_5min / 2007-11-19
file: by_date/stock_5min/2007/2007-11-19.parquet size: 4.4 MB rows: 318,080 symbols: 3,211
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-19 06:35:00 | AAPL | Stock | 5.9286 | 5.9286 | 5.9286 | 5.9286 | 2800.0 |
| 2007-11-19 06:45:00 | AAPL | Stock | 5.9286 | 5.9286 | 5.925 | 5.925 | 8400.0 |
| 2007-11-19 06:50:00 | AAPL | Stock | 5.9214 | 5.9214 | 5.9214 | 5.9214 | 12600.0 |
| 2007-11-19 06:55:00 | AAPL | Stock | 5.9311 | 5.9311 | 5.9311 | 5.9311 | 2800.0 |
| 2007-11-19 07:00:00 | AAPL | Stock | 5.9214 | 5.9286 | 5.9139 | 5.9286 | 53200.0 |
| 2007-11-19 07:05:00 | AAPL | Stock | 5.9371 | 5.9425 | 5.9243 | 5.9425 | 50400.0 |
| 2007-11-19 07:10:00 | AAPL | Stock | 5.9286 | 5.9286 | 5.9286 | 5.9286 | 2800.0 |
| 2007-11-19 07:15:00 | AAPL | Stock | 5.9286 | 5.9286 | 5.9171 | 5.9171 | 5600.0 |
| 2007-11-19 07:20:00 | AAPL | Stock | 5.9171 | 5.9171 | 5.9171 | 5.9171 | 8400.0 |
| 2007-11-19 07:25:00 | AAPL | Stock | 5.9179 | 5.9179 | 5.9171 | 5.9171 | 26600.0 |
| 2007-11-19 07:30:00 | AAPL | Stock | 5.9171 | 5.9171 | 5.9018 | 5.9071 | 50372.0 |
| 2007-11-19 07:35:00 | AAPL | Stock | 5.9179 | 5.9179 | 5.9107 | 5.9107 | 29708.0 |
| 2007-11-19 07:40:00 | AAPL | Stock | 5.9107 | 5.9107 | 5.9107 | 5.9107 | 5600.0 |
| 2007-11-19 07:50:00 | AAPL | Stock | 5.9229 | 5.9271 | 5.9114 | 5.9114 | 140000.0 |
| 2007-11-19 07:55:00 | AAPL | Stock | 5.9168 | 5.9179 | 5.9168 | 5.9175 | 32704.0 |
| 2007-11-19 08:00:00 | AAPL | Stock | 5.9329 | 5.9329 | 5.9107 | 5.9129 | 566496.0 |
| 2007-11-19 08:05:00 | AAPL | Stock | 5.9129 | 5.92 | 5.9054 | 5.9054 | 432600.0 |
| 2007-11-19 08:10:00 | AAPL | Stock | 5.9036 | 5.9164 | 5.8986 | 5.9054 | 317492.0 |
| 2007-11-19 08:15:00 | AAPL | Stock | 5.9093 | 5.9093 | 5.9004 | 5.9079 | 169400.0 |
| 2007-11-19 08:20:00 | AAPL | Stock | 5.9075 | 5.9143 | 5.8968 | 5.8968 | 325304.0 |
| 2007-11-19 08:25:00 | AAPL | Stock | 5.8993 | 5.9004 | 5.8932 | 5.8932 | 354228.0 |
| 2007-11-19 08:30:00 | AAPL | Stock | 5.8943 | 5.9046 | 5.8939 | 5.9046 | 267820.0 |
| 2007-11-19 08:35:00 | AAPL | Stock | 5.9036 | 5.9114 | 5.9036 | 5.9071 | 314160.0 |
| 2007-11-19 08:40:00 | AAPL | Stock | 5.9057 | 5.9125 | 5.9021 | 5.9021 | 539700.0 |
| 2007-11-19 08:45:00 | AAPL | Stock | 5.9018 | 5.9193 | 5.895 | 5.9179 | 717920.0 |
| 2007-11-19 08:50:00 | AAPL | Stock | 5.9175 | 5.9175 | 5.9039 | 5.9157 | 102200.0 |
| 2007-11-19 08:55:00 | AAPL | Stock | 5.9175 | 5.9204 | 5.9129 | 5.9129 | 93240.0 |
| 2007-11-19 09:00:00 | AAPL | Stock | 5.9129 | 5.9214 | 5.9107 | 5.9214 | 214200.0 |
| 2007-11-19 09:05:00 | AAPL | Stock | 5.9211 | 5.9232 | 5.9168 | 5.9196 | 406980.0 |
| 2007-11-19 09:10:00 | AAPL | Stock | 5.9207 | 5.9246 | 5.9207 | 5.9232 | 318444.0 |
| 2007-11-19 09:15:00 | AAPL | Stock | 5.9232 | 5.9286 | 5.92 | 5.9286 | 489160.0 |
| 2007-11-19 09:20:00 | AAPL | Stock | 5.9261 | 5.9286 | 5.9139 | 5.915 | 359324.0 |
| 2007-11-19 09:25:00 | AAPL | Stock | 5.9129 | 5.9307 | 5.9107 | 5.9293 | 1180564.0 |
| 2007-11-19 09:30:00 | AAPL | Stock | 5.9304 | 5.9561 | 5.9107 | 5.9532 | 27466684.0 |
| 2007-11-19 09:35:00 | AAPL | Stock | 5.9484 | 5.955 | 5.9018 | 5.9393 | 29708336.0 |
| 2007-11-19 09:40:00 | AAPL | Stock | 5.9389 | 5.9875 | 5.9254 | 5.9711 | 34575464.0 |
| 2007-11-19 09:45:00 | AAPL | Stock | 5.9686 | 6.0071 | 5.9596 | 5.9746 | 28368872.0 |
| 2007-11-19 09:50:00 | AAPL | Stock | 5.9732 | 5.9993 | 5.9652 | 5.9968 | 22451604.0 |
| 2007-11-19 09:55:00 | AAPL | Stock | 5.9954 | 6.0 | 5.9614 | 5.9646 | 17961776.0 |
| 2007-11-19 10:00:00 | AAPL | Stock | 5.9646 | 5.9943 | 5.9643 | 5.9929 | 17768828.0 |
| 2007-11-19 10:05:00 | AAPL | Stock | 5.9929 | 5.9986 | 5.9557 | 5.9729 | 16124332.0 |
| 2007-11-19 10:10:00 | AAPL | Stock | 5.9729 | 5.9875 | 5.9607 | 5.9679 | 15520484.0 |
| 2007-11-19 10:15:00 | AAPL | Stock | 5.9686 | 5.9821 | 5.9504 | 5.9782 | 17435320.0 |
| 2007-11-19 10:20:00 | AAPL | Stock | 5.9786 | 5.9821 | 5.9479 | 5.9482 | 14701288.0 |
| 2007-11-19 10:25:00 | AAPL | Stock | 5.9475 | 5.9661 | 5.9357 | 5.9618 | 18040652.0 |
| 2007-11-19 10:30:00 | AAPL | Stock | 5.9607 | 5.9614 | 5.9296 | 5.9546 | 13355328.0 |
| 2007-11-19 10:35:00 | AAPL | Stock | 5.9543 | 5.9625 | 5.9375 | 5.9443 | 15920968.0 |
| 2007-11-19 10:40:00 | AAPL | Stock | 5.9436 | 5.9707 | 5.9407 | 5.9568 | 12691308.0 |
| 2007-11-19 10:45:00 | AAPL | Stock | 5.9604 | 5.9775 | 5.9536 | 5.9711 | 11577524.0 |
| 2007-11-19 10:50:00 | AAPL | Stock | 5.9707 | 5.9729 | 5.9414 | 5.9489 | 10455088.0 |
> showing 50 of 318,080 rows — these rows as CSV