PREVIEW / stock_5min / 2010-09-01
file: by_date/stock_5min/2010/2010-09-01.parquet size: 4.8 MB rows: 331,533 symbols: 3,483
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-09-01 05:00:00 | AAPL | Stock | 8.7679 | 8.7679 | 8.7679 | 8.7679 | 5600.0 |
| 2010-09-01 05:30:00 | AAPL | Stock | 8.7675 | 8.7675 | 8.7675 | 8.7675 | 2800.0 |
| 2010-09-01 05:35:00 | AAPL | Stock | 8.7679 | 8.7679 | 8.7679 | 8.7679 | 5600.0 |
| 2010-09-01 05:50:00 | AAPL | Stock | 8.7571 | 8.7571 | 8.7571 | 8.7571 | 22400.0 |
| 2010-09-01 05:55:00 | AAPL | Stock | 8.7571 | 8.7571 | 8.7571 | 8.7571 | 5600.0 |
| 2010-09-01 06:10:00 | AAPL | Stock | 8.7554 | 8.7554 | 8.7554 | 8.7554 | 2800.0 |
| 2010-09-01 06:15:00 | AAPL | Stock | 8.7554 | 8.7554 | 8.7554 | 8.7554 | 8400.0 |
| 2010-09-01 06:25:00 | AAPL | Stock | 8.7571 | 8.7571 | 8.7571 | 8.7571 | 14000.0 |
| 2010-09-01 06:45:00 | AAPL | Stock | 8.7679 | 8.7754 | 8.7679 | 8.7754 | 5600.0 |
| 2010-09-01 06:55:00 | AAPL | Stock | 8.7714 | 8.7714 | 8.7714 | 8.7714 | 14000.0 |
| 2010-09-01 07:00:00 | AAPL | Stock | 8.7679 | 8.7821 | 8.7661 | 8.7821 | 77980.0 |
| 2010-09-01 07:05:00 | AAPL | Stock | 8.765 | 8.765 | 8.7643 | 8.7643 | 8400.0 |
| 2010-09-01 07:10:00 | AAPL | Stock | 8.7643 | 8.7643 | 8.7575 | 8.7575 | 36400.0 |
| 2010-09-01 07:15:00 | AAPL | Stock | 8.765 | 8.7682 | 8.765 | 8.7679 | 60480.0 |
| 2010-09-01 07:20:00 | AAPL | Stock | 8.7675 | 8.7675 | 8.7675 | 8.7675 | 11200.0 |
| 2010-09-01 07:25:00 | AAPL | Stock | 8.7771 | 8.7771 | 8.7764 | 8.7764 | 16800.0 |
| 2010-09-01 07:30:00 | AAPL | Stock | 8.7686 | 8.7804 | 8.7686 | 8.7714 | 60060.0 |
| 2010-09-01 07:35:00 | AAPL | Stock | 8.7786 | 8.7814 | 8.7718 | 8.7718 | 39844.0 |
| 2010-09-01 07:40:00 | AAPL | Stock | 8.7821 | 8.7857 | 8.7732 | 8.7832 | 105308.0 |
| 2010-09-01 07:45:00 | AAPL | Stock | 8.7818 | 8.7818 | 8.7718 | 8.7746 | 80500.0 |
| 2010-09-01 07:50:00 | AAPL | Stock | 8.77 | 8.7804 | 8.77 | 8.7804 | 30800.0 |
| 2010-09-01 07:55:00 | AAPL | Stock | 8.7796 | 8.7796 | 8.7775 | 8.7775 | 28896.0 |
| 2010-09-01 08:00:00 | AAPL | Stock | 8.775 | 8.7946 | 8.7721 | 8.7936 | 773500.0 |
| 2010-09-01 08:05:00 | AAPL | Stock | 8.7936 | 8.7946 | 8.7879 | 8.7925 | 269164.0 |
| 2010-09-01 08:10:00 | AAPL | Stock | 8.7893 | 8.7918 | 8.7857 | 8.7893 | 180600.0 |
| 2010-09-01 08:15:00 | AAPL | Stock | 8.7875 | 8.7929 | 8.7839 | 8.7875 | 652120.0 |
| 2010-09-01 08:20:00 | AAPL | Stock | 8.7875 | 8.8011 | 8.7857 | 8.7932 | 434644.0 |
| 2010-09-01 08:25:00 | AAPL | Stock | 8.7961 | 8.8032 | 8.7857 | 8.8007 | 260344.0 |
| 2010-09-01 08:30:00 | AAPL | Stock | 8.8021 | 8.8021 | 8.6918 | 8.7946 | 285992.0 |
| 2010-09-01 08:35:00 | AAPL | Stock | 8.7982 | 8.8004 | 8.7971 | 8.8004 | 100324.0 |
| 2010-09-01 08:40:00 | AAPL | Stock | 8.7971 | 8.8043 | 8.7971 | 8.8021 | 114044.0 |
| 2010-09-01 08:45:00 | AAPL | Stock | 8.8011 | 8.8157 | 8.6821 | 8.8114 | 474992.0 |
| 2010-09-01 08:50:00 | AAPL | Stock | 8.8143 | 8.8143 | 8.8039 | 8.8043 | 102004.0 |
| 2010-09-01 08:55:00 | AAPL | Stock | 8.8043 | 8.8043 | 8.6821 | 8.7921 | 619500.0 |
| 2010-09-01 09:00:00 | AAPL | Stock | 8.7943 | 8.8 | 8.7893 | 8.8 | 317492.0 |
| 2010-09-01 09:05:00 | AAPL | Stock | 8.7979 | 8.805 | 8.7961 | 8.8043 | 213080.0 |
| 2010-09-01 09:10:00 | AAPL | Stock | 8.805 | 8.8211 | 8.8046 | 8.8154 | 577332.0 |
| 2010-09-01 09:15:00 | AAPL | Stock | 8.8168 | 8.8193 | 8.8132 | 8.8143 | 318024.0 |
| 2010-09-01 09:20:00 | AAPL | Stock | 8.8132 | 8.8171 | 8.8132 | 8.8143 | 137004.0 |
| 2010-09-01 09:25:00 | AAPL | Stock | 8.815 | 8.85 | 8.81 | 8.8379 | 1293796.0 |
| 2010-09-01 09:30:00 | AAPL | Stock | 8.8379 | 8.8561 | 8.8314 | 8.8375 | 25967900.0 |
| 2010-09-01 09:35:00 | AAPL | Stock | 8.8386 | 8.844 | 8.7957 | 8.8009 | 16334500.0 |
| 2010-09-01 09:40:00 | AAPL | Stock | 8.8007 | 8.8196 | 8.7982 | 8.8104 | 9932860.0 |
| 2010-09-01 09:45:00 | AAPL | Stock | 8.8106 | 8.8239 | 8.8075 | 8.8234 | 7413168.0 |
| 2010-09-01 09:50:00 | AAPL | Stock | 8.8246 | 8.8393 | 8.8197 | 8.8264 | 9926812.0 |
| 2010-09-01 09:55:00 | AAPL | Stock | 8.8271 | 8.8357 | 8.8232 | 8.8357 | 6917260.0 |
| 2010-09-01 10:00:00 | AAPL | Stock | 8.8339 | 8.8868 | 8.8279 | 8.8739 | 28601776.0 |
| 2010-09-01 10:05:00 | AAPL | Stock | 8.875 | 8.8807 | 8.8614 | 8.8701 | 14574168.0 |
| 2010-09-01 10:10:00 | AAPL | Stock | 8.8704 | 8.8857 | 8.8643 | 8.8821 | 10491488.0 |
| 2010-09-01 10:15:00 | AAPL | Stock | 8.8825 | 8.8911 | 8.8807 | 8.8829 | 8442392.0 |
> showing 50 of 331,533 rows — these rows as CSV