PREVIEW / stock_5min / 2010-08-13
file: by_date/stock_5min/2010/2010-08-13.parquet size: 4.5 MB rows: 317,446 symbols: 3,451
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-13 05:55:00 | AAPL | Stock | 8.9975 | 8.9975 | 8.9975 | 8.9975 | 5600.0 |
| 2010-08-13 06:05:00 | AAPL | Stock | 8.9725 | 8.9725 | 8.9725 | 8.9725 | 3808.0 |
| 2010-08-13 06:10:00 | AAPL | Stock | 8.9696 | 8.9696 | 8.9696 | 8.9696 | 5600.0 |
| 2010-08-13 07:10:00 | AAPL | Stock | 8.9714 | 8.975 | 8.9439 | 8.975 | 16800.0 |
| 2010-08-13 07:15:00 | AAPL | Stock | 8.9757 | 8.9757 | 8.9757 | 8.9757 | 2800.0 |
| 2010-08-13 07:20:00 | AAPL | Stock | 8.9646 | 8.9646 | 8.9579 | 8.9579 | 5600.0 |
| 2010-08-13 07:30:00 | AAPL | Stock | 8.95 | 8.95 | 8.95 | 8.95 | 2800.0 |
| 2010-08-13 07:50:00 | AAPL | Stock | 8.9575 | 8.9596 | 8.9554 | 8.9596 | 59640.0 |
| 2010-08-13 08:00:00 | AAPL | Stock | 8.9636 | 8.975 | 8.9632 | 8.9654 | 109732.0 |
| 2010-08-13 08:05:00 | AAPL | Stock | 8.9714 | 8.9821 | 8.9661 | 8.975 | 139048.0 |
| 2010-08-13 08:10:00 | AAPL | Stock | 8.9746 | 8.9821 | 8.9721 | 8.9754 | 91280.0 |
| 2010-08-13 08:15:00 | AAPL | Stock | 8.9775 | 8.9775 | 8.9629 | 8.9643 | 151116.0 |
| 2010-08-13 08:20:00 | AAPL | Stock | 8.9596 | 8.9643 | 8.9596 | 8.9632 | 37660.0 |
| 2010-08-13 08:25:00 | AAPL | Stock | 8.9632 | 8.9732 | 8.9632 | 8.9643 | 89796.0 |
| 2010-08-13 08:30:00 | AAPL | Stock | 8.9675 | 8.9796 | 8.9554 | 8.975 | 638148.0 |
| 2010-08-13 08:35:00 | AAPL | Stock | 8.9821 | 9.0 | 8.9754 | 8.9857 | 613340.0 |
| 2010-08-13 08:40:00 | AAPL | Stock | 8.9914 | 9.0061 | 8.9857 | 8.9918 | 529228.0 |
| 2010-08-13 08:45:00 | AAPL | Stock | 8.9946 | 9.005 | 8.9946 | 9.0 | 301420.0 |
| 2010-08-13 08:50:00 | AAPL | Stock | 8.9964 | 9.0029 | 8.9911 | 8.9929 | 214872.0 |
| 2010-08-13 08:55:00 | AAPL | Stock | 8.9986 | 8.9986 | 8.975 | 8.9875 | 232820.0 |
| 2010-08-13 09:00:00 | AAPL | Stock | 8.9925 | 8.9925 | 8.9857 | 8.9857 | 93380.0 |
| 2010-08-13 09:05:00 | AAPL | Stock | 8.9861 | 8.9964 | 8.9861 | 8.99 | 48944.0 |
| 2010-08-13 09:10:00 | AAPL | Stock | 8.9911 | 8.9911 | 8.9893 | 8.9893 | 10640.0 |
| 2010-08-13 09:15:00 | AAPL | Stock | 8.9936 | 8.9939 | 8.9857 | 8.9864 | 57820.0 |
| 2010-08-13 09:20:00 | AAPL | Stock | 8.9857 | 8.9936 | 8.9857 | 8.9857 | 425712.0 |
| 2010-08-13 09:25:00 | AAPL | Stock | 8.9882 | 8.9954 | 8.9686 | 8.9696 | 369628.0 |
| 2010-08-13 09:30:00 | AAPL | Stock | 8.9696 | 8.9957 | 8.9643 | 8.9934 | 11713212.0 |
| 2010-08-13 09:35:00 | AAPL | Stock | 8.9939 | 8.995 | 8.955 | 8.9677 | 12208448.0 |
| 2010-08-13 09:40:00 | AAPL | Stock | 8.9675 | 8.9714 | 8.92 | 8.9411 | 16206372.0 |
| 2010-08-13 09:45:00 | AAPL | Stock | 8.9414 | 8.9486 | 8.9168 | 8.9275 | 10998596.0 |
| 2010-08-13 09:50:00 | AAPL | Stock | 8.9271 | 8.9279 | 8.9089 | 8.9139 | 10031868.0 |
| 2010-08-13 09:55:00 | AAPL | Stock | 8.91 | 8.9514 | 8.91 | 8.9461 | 13217176.0 |
| 2010-08-13 10:00:00 | AAPL | Stock | 8.9482 | 8.9532 | 8.9379 | 8.9511 | 8679356.0 |
| 2010-08-13 10:05:00 | AAPL | Stock | 8.9499 | 8.9621 | 8.945 | 8.9568 | 7110628.0 |
| 2010-08-13 10:10:00 | AAPL | Stock | 8.9554 | 8.9574 | 8.9375 | 8.942 | 7598360.0 |
| 2010-08-13 10:15:00 | AAPL | Stock | 8.9407 | 8.9475 | 8.9293 | 8.9321 | 6491100.0 |
| 2010-08-13 10:20:00 | AAPL | Stock | 8.9321 | 8.9361 | 8.9186 | 8.9268 | 6901188.0 |
| 2010-08-13 10:25:00 | AAPL | Stock | 8.9257 | 8.9411 | 8.92 | 8.9404 | 3327912.0 |
| 2010-08-13 10:30:00 | AAPL | Stock | 8.9402 | 8.9425 | 8.9184 | 8.9311 | 5282984.0 |
| 2010-08-13 10:35:00 | AAPL | Stock | 8.9309 | 8.9429 | 8.9309 | 8.9429 | 3615808.0 |
| 2010-08-13 10:40:00 | AAPL | Stock | 8.9429 | 8.945 | 8.9286 | 8.9289 | 3579128.0 |
| 2010-08-13 10:45:00 | AAPL | Stock | 8.9289 | 8.9361 | 8.9196 | 8.9221 | 5228496.0 |
| 2010-08-13 10:50:00 | AAPL | Stock | 8.9224 | 8.9254 | 8.91 | 8.912 | 7277732.0 |
| 2010-08-13 10:55:00 | AAPL | Stock | 8.9107 | 8.9268 | 8.9054 | 8.9239 | 7816032.0 |
| 2010-08-13 11:00:00 | AAPL | Stock | 8.9243 | 8.9289 | 8.9193 | 8.9196 | 3489948.0 |
| 2010-08-13 11:05:00 | AAPL | Stock | 8.9196 | 8.9246 | 8.9143 | 8.9196 | 3609480.0 |
| 2010-08-13 11:10:00 | AAPL | Stock | 8.92 | 8.9207 | 8.9089 | 8.9169 | 3491068.0 |
| 2010-08-13 11:15:00 | AAPL | Stock | 8.9154 | 8.9243 | 8.9139 | 8.9171 | 2127916.0 |
| 2010-08-13 11:20:00 | AAPL | Stock | 8.9164 | 8.9232 | 8.9107 | 8.9157 | 3963568.0 |
| 2010-08-13 11:25:00 | AAPL | Stock | 8.9164 | 8.9218 | 8.91 | 8.9162 | 2184224.0 |
> showing 50 of 317,446 rows — these rows as CSV