PREVIEW / stock_5min / 2008-10-17
file: by_date/stock_5min/2008/2008-10-17.parquet size: 4.6 MB rows: 322,341 symbols: 3,329
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-10-17 05:30:00 | AAPL | Stock | 3.6268 | 3.6268 | 3.6268 | 3.6268 | 28000.0 |
| 2008-10-17 05:35:00 | AAPL | Stock | 3.6268 | 3.6268 | 3.6268 | 3.6268 | 12600.0 |
| 2008-10-17 07:00:00 | AAPL | Stock | 3.6175 | 3.6175 | 3.6175 | 3.6175 | 5600.0 |
| 2008-10-17 07:10:00 | AAPL | Stock | 3.6436 | 3.65 | 3.6429 | 3.65 | 44800.0 |
| 2008-10-17 07:15:00 | AAPL | Stock | 3.6414 | 3.6429 | 3.6339 | 3.6429 | 47600.0 |
| 2008-10-17 07:25:00 | AAPL | Stock | 3.6486 | 3.6675 | 3.6464 | 3.6675 | 86800.0 |
| 2008-10-17 07:30:00 | AAPL | Stock | 3.6668 | 3.6786 | 3.6668 | 3.6668 | 15400.0 |
| 2008-10-17 07:35:00 | AAPL | Stock | 3.6786 | 3.6786 | 3.6786 | 3.6786 | 2800.0 |
| 2008-10-17 07:40:00 | AAPL | Stock | 3.6786 | 3.6786 | 3.6604 | 3.6604 | 27972.0 |
| 2008-10-17 07:45:00 | AAPL | Stock | 3.6464 | 3.6471 | 3.6464 | 3.6464 | 47600.0 |
| 2008-10-17 07:55:00 | AAPL | Stock | 3.6593 | 3.6789 | 3.6593 | 3.6721 | 131600.0 |
| 2008-10-17 08:00:00 | AAPL | Stock | 3.6879 | 3.7032 | 3.6679 | 3.6964 | 702744.0 |
| 2008-10-17 08:05:00 | AAPL | Stock | 3.6964 | 3.7268 | 3.6864 | 3.7157 | 575624.0 |
| 2008-10-17 08:10:00 | AAPL | Stock | 3.7011 | 3.7021 | 3.6689 | 3.6768 | 361648.0 |
| 2008-10-17 08:15:00 | AAPL | Stock | 3.6768 | 3.6875 | 3.6714 | 3.675 | 354396.0 |
| 2008-10-17 08:20:00 | AAPL | Stock | 3.675 | 3.675 | 3.6386 | 3.6443 | 501760.0 |
| 2008-10-17 08:25:00 | AAPL | Stock | 3.6443 | 3.6629 | 3.6443 | 3.6625 | 164052.0 |
| 2008-10-17 08:30:00 | AAPL | Stock | 3.6579 | 3.66 | 3.6254 | 3.6286 | 1347724.0 |
| 2008-10-17 08:35:00 | AAPL | Stock | 3.6293 | 3.6293 | 3.6125 | 3.6161 | 886648.0 |
| 2008-10-17 08:40:00 | AAPL | Stock | 3.6175 | 3.6271 | 3.6 | 3.6046 | 499184.0 |
| 2008-10-17 08:45:00 | AAPL | Stock | 3.5986 | 3.6143 | 3.5846 | 3.6143 | 370020.0 |
| 2008-10-17 08:50:00 | AAPL | Stock | 3.6143 | 3.6146 | 3.6018 | 3.6143 | 630840.0 |
| 2008-10-17 08:55:00 | AAPL | Stock | 3.6125 | 3.6125 | 3.5982 | 3.6071 | 259784.0 |
| 2008-10-17 09:00:00 | AAPL | Stock | 3.6043 | 3.6043 | 3.5714 | 3.5775 | 759164.0 |
| 2008-10-17 09:05:00 | AAPL | Stock | 3.5818 | 3.5875 | 3.5779 | 3.5839 | 289800.0 |
| 2008-10-17 09:10:00 | AAPL | Stock | 3.5875 | 3.5875 | 3.5375 | 3.575 | 1267644.0 |
| 2008-10-17 09:15:00 | AAPL | Stock | 3.5743 | 3.575 | 3.5675 | 3.5707 | 451976.0 |
| 2008-10-17 09:20:00 | AAPL | Stock | 3.5696 | 3.5896 | 3.5661 | 3.5882 | 522144.0 |
| 2008-10-17 09:25:00 | AAPL | Stock | 3.5875 | 3.5904 | 3.5357 | 3.5571 | 3420396.0 |
| 2008-10-17 09:30:00 | AAPL | Stock | 3.5571 | 3.5714 | 3.5059 | 3.535 | 98360696.0 |
| 2008-10-17 09:35:00 | AAPL | Stock | 3.5354 | 3.5668 | 3.5182 | 3.5418 | 48175792.0 |
| 2008-10-17 09:40:00 | AAPL | Stock | 3.5418 | 3.5554 | 3.53 | 3.5532 | 35962500.0 |
| 2008-10-17 09:45:00 | AAPL | Stock | 3.5532 | 3.5786 | 3.5261 | 3.5486 | 41073788.0 |
| 2008-10-17 09:50:00 | AAPL | Stock | 3.55 | 3.5725 | 3.5321 | 3.5346 | 26432784.0 |
| 2008-10-17 09:55:00 | AAPL | Stock | 3.5343 | 3.575 | 3.5136 | 3.5686 | 34921936.0 |
| 2008-10-17 10:00:00 | AAPL | Stock | 3.5693 | 3.58 | 3.5536 | 3.56 | 31449936.0 |
| 2008-10-17 10:05:00 | AAPL | Stock | 3.5611 | 3.5886 | 3.5214 | 3.5329 | 27819372.0 |
| 2008-10-17 10:10:00 | AAPL | Stock | 3.5311 | 3.5693 | 3.48 | 3.4854 | 28475524.0 |
| 2008-10-17 10:15:00 | AAPL | Stock | 3.4861 | 3.5307 | 3.4861 | 3.5189 | 24885728.0 |
| 2008-10-17 10:20:00 | AAPL | Stock | 3.5189 | 3.5243 | 3.495 | 3.5054 | 20729548.0 |
| 2008-10-17 10:25:00 | AAPL | Stock | 3.5043 | 3.5264 | 3.4914 | 3.5237 | 21447076.0 |
| 2008-10-17 10:30:00 | AAPL | Stock | 3.5236 | 3.5257 | 3.4821 | 3.49 | 22717016.0 |
| 2008-10-17 10:35:00 | AAPL | Stock | 3.49 | 3.5071 | 3.4821 | 3.4979 | 20203428.0 |
| 2008-10-17 10:40:00 | AAPL | Stock | 3.4989 | 3.5364 | 3.4886 | 3.5339 | 23736692.0 |
| 2008-10-17 10:45:00 | AAPL | Stock | 3.5334 | 3.5714 | 3.5314 | 3.5704 | 31111192.0 |
| 2008-10-17 10:50:00 | AAPL | Stock | 3.57 | 3.5714 | 3.5457 | 3.5536 | 21904176.0 |
| 2008-10-17 10:55:00 | AAPL | Stock | 3.5539 | 3.5643 | 3.54 | 3.5589 | 15812580.0 |
| 2008-10-17 11:00:00 | AAPL | Stock | 3.5589 | 3.5714 | 3.5557 | 3.5682 | 16234400.0 |
| 2008-10-17 11:05:00 | AAPL | Stock | 3.5682 | 3.59 | 3.5643 | 3.5711 | 31338860.0 |
| 2008-10-17 11:10:00 | AAPL | Stock | 3.5714 | 3.5718 | 3.5546 | 3.5625 | 15724016.0 |
> showing 50 of 322,341 rows — these rows as CSV