PREVIEW / stock_5min / 2009-08-14
file: by_date/stock_5min/2009/2009-08-14.parquet size: 4.6 MB rows: 321,111 symbols: 3,355
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-14 05:05:00 | AAPL | Stock | 6.0268 | 6.0268 | 6.0268 | 6.0268 | 2800.0 |
| 2009-08-14 06:40:00 | AAPL | Stock | 6.0211 | 6.0268 | 6.0211 | 6.0268 | 11200.0 |
| 2009-08-14 06:50:00 | AAPL | Stock | 6.0211 | 6.0211 | 6.0211 | 6.0211 | 5600.0 |
| 2009-08-14 07:35:00 | AAPL | Stock | 6.0179 | 6.0179 | 6.0179 | 6.0179 | 8400.0 |
| 2009-08-14 07:40:00 | AAPL | Stock | 6.0179 | 6.0179 | 6.0179 | 6.0179 | 16800.0 |
| 2009-08-14 07:55:00 | AAPL | Stock | 6.0089 | 6.0089 | 6.0089 | 6.0089 | 4200.0 |
| 2009-08-14 08:00:00 | AAPL | Stock | 6.0175 | 6.0179 | 6.0111 | 6.0157 | 14700.0 |
| 2009-08-14 08:05:00 | AAPL | Stock | 6.0154 | 6.0157 | 6.0114 | 6.0157 | 40964.0 |
| 2009-08-14 08:10:00 | AAPL | Stock | 6.0179 | 6.0179 | 6.0125 | 6.0157 | 134568.0 |
| 2009-08-14 08:15:00 | AAPL | Stock | 6.0129 | 6.0139 | 6.0129 | 6.0139 | 28980.0 |
| 2009-08-14 08:20:00 | AAPL | Stock | 6.0114 | 6.0139 | 6.0107 | 6.0136 | 52500.0 |
| 2009-08-14 08:25:00 | AAPL | Stock | 6.0107 | 6.0139 | 6.0107 | 6.0107 | 20972.0 |
| 2009-08-14 08:30:00 | AAPL | Stock | 6.0136 | 6.0143 | 6.0089 | 6.0089 | 86352.0 |
| 2009-08-14 08:35:00 | AAPL | Stock | 6.0125 | 6.0125 | 6.0104 | 6.0114 | 46956.0 |
| 2009-08-14 08:45:00 | AAPL | Stock | 6.0154 | 6.0157 | 6.0107 | 6.0139 | 39200.0 |
| 2009-08-14 08:50:00 | AAPL | Stock | 6.0096 | 6.0111 | 6.0011 | 6.0018 | 126756.0 |
| 2009-08-14 08:55:00 | AAPL | Stock | 6.0039 | 6.0046 | 6.0039 | 6.0046 | 5600.0 |
| 2009-08-14 09:00:00 | AAPL | Stock | 6.0036 | 6.0043 | 5.9946 | 5.9957 | 42588.0 |
| 2009-08-14 09:05:00 | AAPL | Stock | 6.0007 | 6.0007 | 6.0007 | 6.0007 | 5600.0 |
| 2009-08-14 09:10:00 | AAPL | Stock | 6.005 | 6.0054 | 6.005 | 6.0054 | 56000.0 |
| 2009-08-14 09:15:00 | AAPL | Stock | 6.0032 | 6.0032 | 5.9957 | 5.9971 | 43400.0 |
| 2009-08-14 09:20:00 | AAPL | Stock | 5.9989 | 6.0029 | 5.9968 | 6.0029 | 41720.0 |
| 2009-08-14 09:25:00 | AAPL | Stock | 6.0018 | 6.0018 | 5.9921 | 5.9936 | 108472.0 |
| 2009-08-14 09:30:00 | AAPL | Stock | 5.9968 | 6.0081 | 5.9893 | 5.9952 | 11296236.0 |
| 2009-08-14 09:35:00 | AAPL | Stock | 5.995 | 5.9961 | 5.9746 | 5.9793 | 10131072.0 |
| 2009-08-14 09:40:00 | AAPL | Stock | 5.9793 | 5.9818 | 5.9654 | 5.9668 | 6760236.0 |
| 2009-08-14 09:45:00 | AAPL | Stock | 5.9668 | 5.9732 | 5.9561 | 5.9732 | 9952964.0 |
| 2009-08-14 09:50:00 | AAPL | Stock | 5.9729 | 5.9746 | 5.9586 | 5.965 | 5181428.0 |
| 2009-08-14 09:55:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.935 | 5.9554 | 13688724.0 |
| 2009-08-14 10:00:00 | AAPL | Stock | 5.9554 | 5.9568 | 5.9396 | 5.945 | 8857856.0 |
| 2009-08-14 10:05:00 | AAPL | Stock | 5.9446 | 5.9482 | 5.9361 | 5.9389 | 6931428.0 |
| 2009-08-14 10:10:00 | AAPL | Stock | 5.94 | 5.9493 | 5.9379 | 5.9404 | 5162192.0 |
| 2009-08-14 10:15:00 | AAPL | Stock | 5.9404 | 5.9418 | 5.9325 | 5.9375 | 5119912.0 |
| 2009-08-14 10:20:00 | AAPL | Stock | 5.9368 | 5.9489 | 5.9343 | 5.9489 | 4562908.0 |
| 2009-08-14 10:25:00 | AAPL | Stock | 5.9489 | 5.9525 | 5.9411 | 5.9414 | 6067768.0 |
| 2009-08-14 10:30:00 | AAPL | Stock | 5.9411 | 5.945 | 5.9332 | 5.9386 | 4835852.0 |
| 2009-08-14 10:35:00 | AAPL | Stock | 5.9379 | 5.9393 | 5.9325 | 5.9368 | 3541832.0 |
| 2009-08-14 10:40:00 | AAPL | Stock | 5.9364 | 5.9393 | 5.9268 | 5.9339 | 6693680.0 |
| 2009-08-14 10:45:00 | AAPL | Stock | 5.9336 | 5.935 | 5.9275 | 5.9304 | 3033716.0 |
| 2009-08-14 10:50:00 | AAPL | Stock | 5.9304 | 5.9314 | 5.9146 | 5.915 | 5940424.0 |
| 2009-08-14 10:55:00 | AAPL | Stock | 5.9161 | 5.9264 | 5.9161 | 5.9263 | 3316488.0 |
| 2009-08-14 11:00:00 | AAPL | Stock | 5.9257 | 5.9304 | 5.9196 | 5.9263 | 4394236.0 |
| 2009-08-14 11:05:00 | AAPL | Stock | 5.9265 | 5.9321 | 5.9221 | 5.9263 | 3794896.0 |
| 2009-08-14 11:10:00 | AAPL | Stock | 5.9282 | 5.9293 | 5.9232 | 5.9275 | 2698668.0 |
| 2009-08-14 11:15:00 | AAPL | Stock | 5.9269 | 5.9314 | 5.9218 | 5.9257 | 1907556.0 |
| 2009-08-14 11:20:00 | AAPL | Stock | 5.9253 | 5.9268 | 5.9229 | 5.925 | 2049208.0 |
| 2009-08-14 11:25:00 | AAPL | Stock | 5.925 | 5.9252 | 5.9175 | 5.9175 | 3177944.0 |
| 2009-08-14 11:30:00 | AAPL | Stock | 5.9171 | 5.92 | 5.9118 | 5.9192 | 4777612.0 |
| 2009-08-14 11:35:00 | AAPL | Stock | 5.9193 | 5.9221 | 5.9154 | 5.9182 | 2723728.0 |
| 2009-08-14 11:40:00 | AAPL | Stock | 5.9175 | 5.9214 | 5.9154 | 5.9214 | 1880508.0 |
> showing 50 of 321,111 rows — these rows as CSV