PREVIEW / stock_5min / 2008-01-23
file: by_date/stock_5min/2008/2008-01-23.parquet size: 4.8 MB rows: 340,889 symbols: 3,269
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-23 04:15:00 | AAPL | Stock | 5.0121 | 5.0121 | 5.0104 | 5.0104 | 11816.0 |
| 2008-01-23 04:30:00 | AAPL | Stock | 4.9964 | 4.9964 | 4.9964 | 4.9964 | 8400.0 |
| 2008-01-23 05:05:00 | AAPL | Stock | 5.0 | 5.0189 | 5.0 | 5.0189 | 14000.0 |
| 2008-01-23 05:10:00 | AAPL | Stock | 5.0196 | 5.0196 | 5.0196 | 5.0196 | 19600.0 |
| 2008-01-23 05:15:00 | AAPL | Stock | 5.0264 | 5.0264 | 5.0196 | 5.0196 | 31920.0 |
| 2008-01-23 05:20:00 | AAPL | Stock | 5.0196 | 5.0196 | 5.0196 | 5.0196 | 28000.0 |
| 2008-01-23 05:55:00 | AAPL | Stock | 5.0143 | 5.0143 | 5.0143 | 5.0143 | 8400.0 |
| 2008-01-23 06:10:00 | AAPL | Stock | 4.9929 | 4.9929 | 4.9896 | 4.9896 | 30800.0 |
| 2008-01-23 06:15:00 | AAPL | Stock | 4.9896 | 4.9904 | 4.9643 | 4.9643 | 106764.0 |
| 2008-01-23 06:20:00 | AAPL | Stock | 4.9643 | 4.9739 | 4.9643 | 4.9739 | 11200.0 |
| 2008-01-23 06:25:00 | AAPL | Stock | 4.9657 | 4.9657 | 4.9646 | 4.9646 | 56000.0 |
| 2008-01-23 06:30:00 | AAPL | Stock | 4.9714 | 4.9714 | 4.9646 | 4.9646 | 25200.0 |
| 2008-01-23 06:35:00 | AAPL | Stock | 4.955 | 4.955 | 4.955 | 4.955 | 16800.0 |
| 2008-01-23 06:40:00 | AAPL | Stock | 4.9643 | 4.9643 | 4.9643 | 4.9643 | 128800.0 |
| 2008-01-23 06:45:00 | AAPL | Stock | 4.9643 | 4.9761 | 4.9643 | 4.9761 | 112000.0 |
| 2008-01-23 06:50:00 | AAPL | Stock | 4.9679 | 4.9682 | 4.9679 | 4.9682 | 8400.0 |
| 2008-01-23 06:55:00 | AAPL | Stock | 4.9818 | 4.9818 | 4.9818 | 4.9818 | 8400.0 |
| 2008-01-23 07:00:00 | AAPL | Stock | 4.9818 | 4.9821 | 4.9643 | 4.9664 | 409640.0 |
| 2008-01-23 07:05:00 | AAPL | Stock | 4.9661 | 4.9814 | 4.9643 | 4.9814 | 123312.0 |
| 2008-01-23 07:15:00 | AAPL | Stock | 4.9857 | 5.0007 | 4.9839 | 4.9993 | 119840.0 |
| 2008-01-23 07:20:00 | AAPL | Stock | 4.9979 | 5.0196 | 4.9979 | 5.0179 | 214900.0 |
| 2008-01-23 07:25:00 | AAPL | Stock | 5.0179 | 5.0393 | 5.0179 | 5.0357 | 249760.0 |
| 2008-01-23 07:30:00 | AAPL | Stock | 5.0364 | 5.0429 | 5.0214 | 5.0357 | 390740.0 |
| 2008-01-23 07:35:00 | AAPL | Stock | 5.0336 | 5.035 | 5.0179 | 5.025 | 244916.0 |
| 2008-01-23 07:40:00 | AAPL | Stock | 5.0254 | 5.0321 | 5.0018 | 5.0071 | 317296.0 |
| 2008-01-23 07:45:00 | AAPL | Stock | 5.0075 | 5.0239 | 4.9964 | 5.0 | 710108.0 |
| 2008-01-23 07:50:00 | AAPL | Stock | 5.0036 | 5.0168 | 5.0 | 5.0143 | 153048.0 |
| 2008-01-23 07:55:00 | AAPL | Stock | 5.0082 | 5.0082 | 4.9786 | 4.9807 | 922376.0 |
| 2008-01-23 08:00:00 | AAPL | Stock | 4.9889 | 4.9946 | 4.9464 | 4.96 | 4768232.0 |
| 2008-01-23 08:05:00 | AAPL | Stock | 4.96 | 4.9711 | 4.9325 | 4.9414 | 5013904.0 |
| 2008-01-23 08:10:00 | AAPL | Stock | 4.9468 | 4.9571 | 4.9286 | 4.9425 | 4903584.0 |
| 2008-01-23 08:15:00 | AAPL | Stock | 4.9418 | 4.9536 | 4.9375 | 4.94 | 4546836.0 |
| 2008-01-23 08:20:00 | AAPL | Stock | 4.9411 | 4.9446 | 4.9304 | 4.9375 | 4153380.0 |
| 2008-01-23 08:25:00 | AAPL | Stock | 4.9375 | 4.9464 | 4.93 | 4.9464 | 3640672.0 |
| 2008-01-23 08:30:00 | AAPL | Stock | 4.9464 | 4.9464 | 4.9214 | 4.9246 | 5883556.0 |
| 2008-01-23 08:35:00 | AAPL | Stock | 4.9246 | 4.9429 | 4.9232 | 4.9346 | 2271108.0 |
| 2008-01-23 08:40:00 | AAPL | Stock | 4.9321 | 4.9393 | 4.9232 | 4.925 | 2790788.0 |
| 2008-01-23 08:45:00 | AAPL | Stock | 4.9243 | 4.9411 | 4.9107 | 4.9243 | 3979080.0 |
| 2008-01-23 08:50:00 | AAPL | Stock | 4.9232 | 4.9329 | 4.9186 | 4.9325 | 2186968.0 |
| 2008-01-23 08:55:00 | AAPL | Stock | 4.9314 | 4.9464 | 4.9286 | 4.9407 | 4292400.0 |
| 2008-01-23 09:00:00 | AAPL | Stock | 4.9411 | 4.9411 | 4.9311 | 4.9321 | 2163532.0 |
| 2008-01-23 09:05:00 | AAPL | Stock | 4.9311 | 4.9361 | 4.9232 | 4.9246 | 1788948.0 |
| 2008-01-23 09:10:00 | AAPL | Stock | 4.9246 | 4.9286 | 4.8971 | 4.9 | 3535504.0 |
| 2008-01-23 09:15:00 | AAPL | Stock | 4.9 | 4.9182 | 4.8968 | 4.9093 | 2267440.0 |
| 2008-01-23 09:20:00 | AAPL | Stock | 4.9093 | 4.9096 | 4.8889 | 4.9 | 4969776.0 |
| 2008-01-23 09:25:00 | AAPL | Stock | 4.8996 | 4.9043 | 4.8571 | 4.8643 | 9728796.0 |
| 2008-01-23 09:30:00 | AAPL | Stock | 4.8639 | 5.0 | 4.8179 | 4.9754 | 162209768.0 |
| 2008-01-23 09:35:00 | AAPL | Stock | 4.975 | 5.0 | 4.9164 | 4.9446 | 75783540.0 |
| 2008-01-23 09:40:00 | AAPL | Stock | 4.9461 | 4.9564 | 4.8939 | 4.9129 | 59089016.0 |
| 2008-01-23 09:45:00 | AAPL | Stock | 4.9146 | 4.9354 | 4.8843 | 4.8907 | 55483876.0 |
> showing 50 of 340,889 rows — these rows as CSV