PREVIEW / stock_5min / 2008-05-06
file: by_date/stock_5min/2008/2008-05-06.parquet size: 4.6 MB rows: 331,012 symbols: 3,326
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-05-06 06:25:00 | AAPL | Stock | 6.6161 | 6.6161 | 6.6161 | 6.6161 | 5600.0 |
| 2008-05-06 06:55:00 | AAPL | Stock | 6.6143 | 6.6275 | 6.6143 | 6.6275 | 53200.0 |
| 2008-05-06 07:00:00 | AAPL | Stock | 6.6254 | 6.6257 | 6.6232 | 6.6254 | 268492.0 |
| 2008-05-06 07:05:00 | AAPL | Stock | 6.6254 | 6.6254 | 6.6254 | 6.6254 | 60984.0 |
| 2008-05-06 07:10:00 | AAPL | Stock | 6.6214 | 6.6214 | 6.6164 | 6.6164 | 154000.0 |
| 2008-05-06 07:15:00 | AAPL | Stock | 6.6214 | 6.6329 | 6.6132 | 6.6329 | 137116.0 |
| 2008-05-06 07:20:00 | AAPL | Stock | 6.6321 | 6.6321 | 6.6321 | 6.6321 | 14000.0 |
| 2008-05-06 07:25:00 | AAPL | Stock | 6.6279 | 6.6279 | 6.625 | 6.625 | 19600.0 |
| 2008-05-06 07:30:00 | AAPL | Stock | 6.6214 | 6.6225 | 6.6125 | 6.6125 | 79800.0 |
| 2008-05-06 07:35:00 | AAPL | Stock | 6.6125 | 6.6125 | 6.5946 | 6.5946 | 87920.0 |
| 2008-05-06 07:40:00 | AAPL | Stock | 6.5946 | 6.5946 | 6.5861 | 6.5946 | 47600.0 |
| 2008-05-06 07:45:00 | AAPL | Stock | 6.5893 | 6.5893 | 6.5857 | 6.5893 | 36400.0 |
| 2008-05-06 07:50:00 | AAPL | Stock | 6.5943 | 6.5946 | 6.5939 | 6.5943 | 109200.0 |
| 2008-05-06 07:55:00 | AAPL | Stock | 6.5964 | 6.5964 | 6.5857 | 6.5857 | 93800.0 |
| 2008-05-06 08:00:00 | AAPL | Stock | 6.5925 | 6.6036 | 6.5789 | 6.5796 | 813316.0 |
| 2008-05-06 08:05:00 | AAPL | Stock | 6.5821 | 6.5846 | 6.5754 | 6.5832 | 319732.0 |
| 2008-05-06 08:10:00 | AAPL | Stock | 6.5871 | 6.5957 | 6.5832 | 6.5954 | 370020.0 |
| 2008-05-06 08:15:00 | AAPL | Stock | 6.5964 | 6.6143 | 6.5964 | 6.6107 | 479164.0 |
| 2008-05-06 08:20:00 | AAPL | Stock | 6.6129 | 6.6179 | 6.6114 | 6.6168 | 355124.0 |
| 2008-05-06 08:25:00 | AAPL | Stock | 6.6161 | 6.6161 | 6.61 | 6.61 | 232820.0 |
| 2008-05-06 08:30:00 | AAPL | Stock | 6.6079 | 6.6296 | 6.6071 | 6.6254 | 702968.0 |
| 2008-05-06 08:35:00 | AAPL | Stock | 6.6229 | 6.6336 | 6.6207 | 6.6307 | 769636.0 |
| 2008-05-06 08:40:00 | AAPL | Stock | 6.6314 | 6.6318 | 6.6182 | 6.6182 | 544152.0 |
| 2008-05-06 08:45:00 | AAPL | Stock | 6.6179 | 6.6239 | 6.6179 | 6.6218 | 178752.0 |
| 2008-05-06 08:50:00 | AAPL | Stock | 6.6218 | 6.6218 | 6.6118 | 6.6132 | 621124.0 |
| 2008-05-06 08:55:00 | AAPL | Stock | 6.6146 | 6.6161 | 6.6107 | 6.6107 | 447636.0 |
| 2008-05-06 09:00:00 | AAPL | Stock | 6.6093 | 6.6093 | 6.5982 | 6.6014 | 674968.0 |
| 2008-05-06 09:05:00 | AAPL | Stock | 6.6014 | 6.6018 | 6.5839 | 6.5943 | 639464.0 |
| 2008-05-06 09:10:00 | AAPL | Stock | 6.5936 | 6.6004 | 6.5911 | 6.6 | 790580.0 |
| 2008-05-06 09:15:00 | AAPL | Stock | 6.6 | 6.6086 | 6.6 | 6.6054 | 546616.0 |
| 2008-05-06 09:20:00 | AAPL | Stock | 6.6075 | 6.6086 | 6.6021 | 6.6025 | 323568.0 |
| 2008-05-06 09:25:00 | AAPL | Stock | 6.6039 | 6.6082 | 6.5775 | 6.5936 | 1725892.0 |
| 2008-05-06 09:30:00 | AAPL | Stock | 6.5936 | 6.6157 | 6.5679 | 6.5836 | 28342468.0 |
| 2008-05-06 09:35:00 | AAPL | Stock | 6.5846 | 6.6029 | 6.55 | 6.5575 | 24827040.0 |
| 2008-05-06 09:40:00 | AAPL | Stock | 6.5582 | 6.5786 | 6.5436 | 6.5739 | 20039852.0 |
| 2008-05-06 09:45:00 | AAPL | Stock | 6.575 | 6.5761 | 6.5286 | 6.5407 | 25529672.0 |
| 2008-05-06 09:50:00 | AAPL | Stock | 6.5411 | 6.5446 | 6.5071 | 6.5079 | 22885912.0 |
| 2008-05-06 09:55:00 | AAPL | Stock | 6.5086 | 6.5429 | 6.5064 | 6.535 | 19435752.0 |
| 2008-05-06 10:00:00 | AAPL | Stock | 6.5346 | 6.5532 | 6.5286 | 6.5429 | 13891836.0 |
| 2008-05-06 10:05:00 | AAPL | Stock | 6.5421 | 6.5486 | 6.5332 | 6.5429 | 11617872.0 |
| 2008-05-06 10:10:00 | AAPL | Stock | 6.5429 | 6.5564 | 6.5357 | 6.5468 | 14576380.0 |
| 2008-05-06 10:15:00 | AAPL | Stock | 6.5468 | 6.57 | 6.545 | 6.5654 | 15605100.0 |
| 2008-05-06 10:20:00 | AAPL | Stock | 6.565 | 6.5711 | 6.5393 | 6.5457 | 17216024.0 |
| 2008-05-06 10:25:00 | AAPL | Stock | 6.545 | 6.5521 | 6.5332 | 6.5404 | 13018040.0 |
| 2008-05-06 10:30:00 | AAPL | Stock | 6.5404 | 6.5432 | 6.5279 | 6.5375 | 13588848.0 |
| 2008-05-06 10:35:00 | AAPL | Stock | 6.5375 | 6.5536 | 6.5361 | 6.5463 | 8914360.0 |
| 2008-05-06 10:40:00 | AAPL | Stock | 6.5457 | 6.5596 | 6.5407 | 6.5555 | 9467472.0 |
| 2008-05-06 10:45:00 | AAPL | Stock | 6.5557 | 6.5564 | 6.5321 | 6.5443 | 10585372.0 |
| 2008-05-06 10:50:00 | AAPL | Stock | 6.545 | 6.5625 | 6.53 | 6.5587 | 16336824.0 |
| 2008-05-06 10:55:00 | AAPL | Stock | 6.5596 | 6.5811 | 6.5539 | 6.5804 | 13782916.0 |
> showing 50 of 331,012 rows — these rows as CSV