PREVIEW / stock_5min / 2008-11-06
file: by_date/stock_5min/2008/2008-11-06.parquet size: 4.4 MB rows: 314,910 symbols: 3,307
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-11-06 05:50:00 | AAPL | Stock | 3.5836 | 3.5836 | 3.5836 | 3.5836 | 54320.0 |
| 2008-11-06 07:00:00 | AAPL | Stock | 3.6129 | 3.6246 | 3.6046 | 3.6214 | 51016.0 |
| 2008-11-06 07:05:00 | AAPL | Stock | 3.6143 | 3.625 | 3.6143 | 3.6143 | 49420.0 |
| 2008-11-06 07:15:00 | AAPL | Stock | 3.6143 | 3.6143 | 3.6143 | 3.6143 | 22120.0 |
| 2008-11-06 07:20:00 | AAPL | Stock | 3.6143 | 3.6143 | 3.6143 | 3.6143 | 11200.0 |
| 2008-11-06 07:25:00 | AAPL | Stock | 3.6196 | 3.6321 | 3.6196 | 3.6321 | 92596.0 |
| 2008-11-06 07:30:00 | AAPL | Stock | 3.635 | 3.635 | 3.635 | 3.635 | 11200.0 |
| 2008-11-06 07:35:00 | AAPL | Stock | 3.635 | 3.6443 | 3.635 | 3.6396 | 202776.0 |
| 2008-11-06 07:40:00 | AAPL | Stock | 3.6321 | 3.6321 | 3.6304 | 3.6304 | 28000.0 |
| 2008-11-06 07:45:00 | AAPL | Stock | 3.6304 | 3.6368 | 3.6143 | 3.6143 | 80276.0 |
| 2008-11-06 07:50:00 | AAPL | Stock | 3.6143 | 3.625 | 3.6143 | 3.6161 | 37324.0 |
| 2008-11-06 07:55:00 | AAPL | Stock | 3.6143 | 3.6161 | 3.6143 | 3.6161 | 38304.0 |
| 2008-11-06 08:00:00 | AAPL | Stock | 3.6186 | 3.6186 | 3.5857 | 3.5893 | 471212.0 |
| 2008-11-06 08:05:00 | AAPL | Stock | 3.5846 | 3.5929 | 3.5804 | 3.5929 | 412104.0 |
| 2008-11-06 08:10:00 | AAPL | Stock | 3.6032 | 3.6032 | 3.5893 | 3.5929 | 126588.0 |
| 2008-11-06 08:15:00 | AAPL | Stock | 3.5936 | 3.6036 | 3.5896 | 3.5968 | 101136.0 |
| 2008-11-06 08:20:00 | AAPL | Stock | 3.5982 | 3.6107 | 3.5982 | 3.6104 | 277900.0 |
| 2008-11-06 08:25:00 | AAPL | Stock | 3.6025 | 3.6071 | 3.6011 | 3.6071 | 215880.0 |
| 2008-11-06 08:30:00 | AAPL | Stock | 3.6071 | 3.6304 | 3.6054 | 3.6243 | 278152.0 |
| 2008-11-06 08:35:00 | AAPL | Stock | 3.625 | 3.6354 | 3.625 | 3.6321 | 366940.0 |
| 2008-11-06 08:40:00 | AAPL | Stock | 3.6321 | 3.6393 | 3.6321 | 3.6379 | 322924.0 |
| 2008-11-06 08:45:00 | AAPL | Stock | 3.6371 | 3.6379 | 3.6325 | 3.6357 | 249928.0 |
| 2008-11-06 08:50:00 | AAPL | Stock | 3.6357 | 3.6421 | 3.6357 | 3.6393 | 168000.0 |
| 2008-11-06 08:55:00 | AAPL | Stock | 3.6393 | 3.6393 | 3.63 | 3.6321 | 697060.0 |
| 2008-11-06 09:00:00 | AAPL | Stock | 3.6311 | 3.6321 | 3.625 | 3.6271 | 346052.0 |
| 2008-11-06 09:05:00 | AAPL | Stock | 3.6264 | 3.6321 | 3.625 | 3.6296 | 319956.0 |
| 2008-11-06 09:10:00 | AAPL | Stock | 3.6293 | 3.6429 | 3.6289 | 3.6343 | 404740.0 |
| 2008-11-06 09:15:00 | AAPL | Stock | 3.635 | 3.635 | 3.6225 | 3.6225 | 330344.0 |
| 2008-11-06 09:20:00 | AAPL | Stock | 3.6218 | 3.6268 | 3.6179 | 3.6179 | 546224.0 |
| 2008-11-06 09:25:00 | AAPL | Stock | 3.6243 | 3.6279 | 3.6075 | 3.6107 | 1059520.0 |
| 2008-11-06 09:30:00 | AAPL | Stock | 3.6107 | 3.6375 | 3.5925 | 3.6286 | 31689840.0 |
| 2008-11-06 09:35:00 | AAPL | Stock | 3.6286 | 3.6514 | 3.6186 | 3.6504 | 31877776.0 |
| 2008-11-06 09:40:00 | AAPL | Stock | 3.6518 | 3.6707 | 3.6418 | 3.6432 | 31091256.0 |
| 2008-11-06 09:45:00 | AAPL | Stock | 3.6429 | 3.6479 | 3.6179 | 3.6214 | 28659764.0 |
| 2008-11-06 09:50:00 | AAPL | Stock | 3.6214 | 3.6343 | 3.5804 | 3.5871 | 31054324.0 |
| 2008-11-06 09:55:00 | AAPL | Stock | 3.5875 | 3.6018 | 3.5714 | 3.5718 | 32901484.0 |
| 2008-11-06 10:00:00 | AAPL | Stock | 3.5718 | 3.5725 | 3.5143 | 3.5371 | 54272232.0 |
| 2008-11-06 10:05:00 | AAPL | Stock | 3.5371 | 3.5604 | 3.5296 | 3.5589 | 22682996.0 |
| 2008-11-06 10:10:00 | AAPL | Stock | 3.5593 | 3.5811 | 3.5561 | 3.5671 | 25951436.0 |
| 2008-11-06 10:15:00 | AAPL | Stock | 3.5671 | 3.5921 | 3.565 | 3.5793 | 21957096.0 |
| 2008-11-06 10:20:00 | AAPL | Stock | 3.5796 | 3.5907 | 3.5721 | 3.5821 | 18184012.0 |
| 2008-11-06 10:25:00 | AAPL | Stock | 3.5818 | 3.5854 | 3.5536 | 3.5675 | 19797428.0 |
| 2008-11-06 10:30:00 | AAPL | Stock | 3.5682 | 3.5693 | 3.5482 | 3.5664 | 15560692.0 |
| 2008-11-06 10:35:00 | AAPL | Stock | 3.5657 | 3.5732 | 3.5539 | 3.5714 | 12269460.0 |
| 2008-11-06 10:40:00 | AAPL | Stock | 3.5711 | 3.575 | 3.5357 | 3.5443 | 16112040.0 |
| 2008-11-06 10:45:00 | AAPL | Stock | 3.5427 | 3.5573 | 3.5389 | 3.5489 | 12933172.0 |
| 2008-11-06 10:50:00 | AAPL | Stock | 3.5489 | 3.555 | 3.5368 | 3.5546 | 12226172.0 |
| 2008-11-06 10:55:00 | AAPL | Stock | 3.5546 | 3.5679 | 3.55 | 3.5679 | 16067352.0 |
| 2008-11-06 11:00:00 | AAPL | Stock | 3.5682 | 3.5775 | 3.5632 | 3.5671 | 13306132.0 |
| 2008-11-06 11:05:00 | AAPL | Stock | 3.5664 | 3.5736 | 3.5443 | 3.5468 | 13341720.0 |
> showing 50 of 314,910 rows — these rows as CSV