PREVIEW / stock_5min / 2012-02-07
file: by_date/stock_5min/2012/2012-02-07.parquet size: 4.8 MB rows: 324,042 symbols: 3,533
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-07 04:15:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 14000.0 |
| 2012-02-07 04:20:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6068 | 16.6068 | 5600.0 |
| 2012-02-07 04:25:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 5600.0 |
| 2012-02-07 04:45:00 | AAPL | Stock | 16.6068 | 16.6071 | 16.6068 | 16.6071 | 19600.0 |
| 2012-02-07 05:50:00 | AAPL | Stock | 16.62 | 16.62 | 16.62 | 16.62 | 2800.0 |
| 2012-02-07 06:00:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 4956.0 |
| 2012-02-07 06:10:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 13356.0 |
| 2012-02-07 06:25:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 11200.0 |
| 2012-02-07 06:45:00 | AAPL | Stock | 16.5982 | 16.5982 | 16.5982 | 16.5982 | 25200.0 |
| 2012-02-07 06:50:00 | AAPL | Stock | 16.5982 | 16.5982 | 16.5982 | 16.5982 | 8400.0 |
| 2012-02-07 07:00:00 | AAPL | Stock | 16.5907 | 16.5907 | 16.5718 | 16.575 | 30576.0 |
| 2012-02-07 07:10:00 | AAPL | Stock | 16.5714 | 16.5714 | 16.5632 | 16.5632 | 14700.0 |
| 2012-02-07 07:15:00 | AAPL | Stock | 16.5625 | 16.5625 | 16.5589 | 16.5589 | 5600.0 |
| 2012-02-07 07:20:00 | AAPL | Stock | 16.5679 | 16.5679 | 16.5679 | 16.5679 | 3612.0 |
| 2012-02-07 07:30:00 | AAPL | Stock | 16.5618 | 16.5618 | 16.5607 | 16.5607 | 18872.0 |
| 2012-02-07 07:35:00 | AAPL | Stock | 16.5714 | 16.5879 | 16.5714 | 16.5861 | 13580.0 |
| 2012-02-07 07:40:00 | AAPL | Stock | 16.5886 | 16.5886 | 16.5864 | 16.5864 | 29512.0 |
| 2012-02-07 07:45:00 | AAPL | Stock | 16.5957 | 16.5961 | 16.5943 | 16.5961 | 14000.0 |
| 2012-02-07 07:50:00 | AAPL | Stock | 16.5868 | 16.5868 | 16.5868 | 16.5868 | 2800.0 |
| 2012-02-07 07:55:00 | AAPL | Stock | 16.5764 | 16.5764 | 16.5714 | 16.5714 | 32200.0 |
| 2012-02-07 08:00:00 | AAPL | Stock | 16.5854 | 16.5893 | 16.5714 | 16.5861 | 43960.0 |
| 2012-02-07 08:05:00 | AAPL | Stock | 16.5357 | 16.5839 | 16.5357 | 16.5821 | 89600.0 |
| 2012-02-07 08:10:00 | AAPL | Stock | 16.5893 | 16.595 | 16.5893 | 16.595 | 22400.0 |
| 2012-02-07 08:15:00 | AAPL | Stock | 16.5954 | 16.5954 | 16.5929 | 16.5929 | 14000.0 |
| 2012-02-07 08:20:00 | AAPL | Stock | 16.5868 | 16.5961 | 16.5868 | 16.5961 | 49532.0 |
| 2012-02-07 08:25:00 | AAPL | Stock | 16.5957 | 16.6054 | 16.5957 | 16.6 | 100800.0 |
| 2012-02-07 08:30:00 | AAPL | Stock | 16.6032 | 16.6232 | 16.6 | 16.6089 | 321748.0 |
| 2012-02-07 08:35:00 | AAPL | Stock | 16.6071 | 16.6136 | 16.6018 | 16.6068 | 126168.0 |
| 2012-02-07 08:40:00 | AAPL | Stock | 16.6046 | 16.6054 | 16.5982 | 16.6032 | 164696.0 |
| 2012-02-07 08:45:00 | AAPL | Stock | 16.6 | 16.6043 | 16.5975 | 16.5982 | 53200.0 |
| 2012-02-07 08:50:00 | AAPL | Stock | 16.59 | 16.59 | 16.5857 | 16.5875 | 94556.0 |
| 2012-02-07 08:55:00 | AAPL | Stock | 16.5875 | 16.5889 | 16.5786 | 16.5889 | 46620.0 |
| 2012-02-07 09:00:00 | AAPL | Stock | 16.5893 | 16.59 | 16.5893 | 16.5893 | 61684.0 |
| 2012-02-07 09:05:00 | AAPL | Stock | 16.5893 | 16.5893 | 16.5893 | 16.5893 | 2800.0 |
| 2012-02-07 09:10:00 | AAPL | Stock | 16.5961 | 16.5964 | 16.5961 | 16.5964 | 15904.0 |
| 2012-02-07 09:15:00 | AAPL | Stock | 16.5961 | 16.6107 | 16.5961 | 16.6071 | 241836.0 |
| 2012-02-07 09:20:00 | AAPL | Stock | 16.6071 | 16.6143 | 16.6068 | 16.6125 | 113344.0 |
| 2012-02-07 09:25:00 | AAPL | Stock | 16.6107 | 16.6368 | 16.6079 | 16.6161 | 491568.0 |
| 2012-02-07 09:30:00 | AAPL | Stock | 16.6239 | 16.6571 | 16.6071 | 16.6275 | 11500384.0 |
| 2012-02-07 09:35:00 | AAPL | Stock | 16.6268 | 16.6618 | 16.6261 | 16.6443 | 7738024.0 |
| 2012-02-07 09:40:00 | AAPL | Stock | 16.6439 | 16.675 | 16.6429 | 16.6664 | 8612856.0 |
| 2012-02-07 09:45:00 | AAPL | Stock | 16.6664 | 16.6696 | 16.6321 | 16.6621 | 9228184.0 |
| 2012-02-07 09:50:00 | AAPL | Stock | 16.6639 | 16.6639 | 16.6282 | 16.6354 | 7252784.0 |
| 2012-02-07 09:55:00 | AAPL | Stock | 16.6357 | 16.6389 | 16.5922 | 16.6285 | 8261624.0 |
| 2012-02-07 10:00:00 | AAPL | Stock | 16.6282 | 16.646 | 16.6071 | 16.6132 | 6063092.0 |
| 2012-02-07 10:05:00 | AAPL | Stock | 16.6161 | 16.6364 | 16.6071 | 16.6329 | 3383688.0 |
| 2012-02-07 10:10:00 | AAPL | Stock | 16.6321 | 16.6561 | 16.6189 | 16.6546 | 4245920.0 |
| 2012-02-07 10:15:00 | AAPL | Stock | 16.6546 | 16.6607 | 16.6479 | 16.6589 | 3773196.0 |
| 2012-02-07 10:20:00 | AAPL | Stock | 16.6589 | 16.6671 | 16.65 | 16.6625 | 4061456.0 |
| 2012-02-07 10:25:00 | AAPL | Stock | 16.6632 | 16.6664 | 16.6493 | 16.658 | 3459484.0 |
> showing 50 of 324,042 rows — these rows as CSV