PREVIEW / stock_5min / 2011-07-08
file: by_date/stock_5min/2011/2011-07-08.parquet size: 4.8 MB rows: 324,900 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 |
|---|---|---|---|---|---|---|---|
| 2011-07-08 04:00:00 | AAPL | Stock | 12.7696 | 12.7696 | 12.7696 | 12.7696 | 2800.0 |
| 2011-07-08 05:00:00 | AAPL | Stock | 12.785 | 12.785 | 12.785 | 12.785 | 2800.0 |
| 2011-07-08 05:05:00 | AAPL | Stock | 12.7868 | 12.7893 | 12.7868 | 12.7893 | 5600.0 |
| 2011-07-08 05:30:00 | AAPL | Stock | 12.7654 | 12.7654 | 12.7654 | 12.7654 | 2800.0 |
| 2011-07-08 05:50:00 | AAPL | Stock | 12.7654 | 12.7654 | 12.7654 | 12.7654 | 2800.0 |
| 2011-07-08 06:10:00 | AAPL | Stock | 12.7493 | 12.7493 | 12.7493 | 12.7493 | 2800.0 |
| 2011-07-08 06:50:00 | AAPL | Stock | 12.7829 | 12.7829 | 12.7829 | 12.7829 | 2800.0 |
| 2011-07-08 07:00:00 | AAPL | Stock | 12.7846 | 12.785 | 12.7846 | 12.7846 | 14000.0 |
| 2011-07-08 07:05:00 | AAPL | Stock | 12.7896 | 12.8068 | 12.7879 | 12.8036 | 36400.0 |
| 2011-07-08 07:10:00 | AAPL | Stock | 12.7857 | 12.8032 | 12.7857 | 12.8032 | 16800.0 |
| 2011-07-08 07:15:00 | AAPL | Stock | 12.7946 | 12.7946 | 12.7893 | 12.7925 | 28504.0 |
| 2011-07-08 07:20:00 | AAPL | Stock | 12.7893 | 12.7893 | 12.7893 | 12.7893 | 14000.0 |
| 2011-07-08 07:30:00 | AAPL | Stock | 12.7754 | 12.7768 | 12.775 | 12.7768 | 35000.0 |
| 2011-07-08 07:35:00 | AAPL | Stock | 12.775 | 12.7857 | 12.775 | 12.7857 | 9940.0 |
| 2011-07-08 07:40:00 | AAPL | Stock | 12.7879 | 12.7904 | 12.7879 | 12.7904 | 15400.0 |
| 2011-07-08 07:45:00 | AAPL | Stock | 12.8 | 12.8 | 12.8 | 12.8 | 2800.0 |
| 2011-07-08 07:50:00 | AAPL | Stock | 12.8036 | 12.8107 | 12.8 | 12.8107 | 39200.0 |
| 2011-07-08 07:55:00 | AAPL | Stock | 12.8057 | 12.8057 | 12.7904 | 12.7986 | 67200.0 |
| 2011-07-08 08:00:00 | AAPL | Stock | 12.7914 | 12.8054 | 12.7893 | 12.8 | 104580.0 |
| 2011-07-08 08:05:00 | AAPL | Stock | 12.8068 | 12.8125 | 12.7964 | 12.8107 | 215180.0 |
| 2011-07-08 08:10:00 | AAPL | Stock | 12.8143 | 12.8214 | 12.8139 | 12.8146 | 220780.0 |
| 2011-07-08 08:15:00 | AAPL | Stock | 12.8143 | 12.8204 | 12.8129 | 12.82 | 79604.0 |
| 2011-07-08 08:20:00 | AAPL | Stock | 12.8143 | 12.8207 | 12.8093 | 12.8143 | 210280.0 |
| 2011-07-08 08:25:00 | AAPL | Stock | 12.8139 | 12.8214 | 12.8036 | 12.8107 | 386232.0 |
| 2011-07-08 08:30:00 | AAPL | Stock | 12.8 | 12.8207 | 12.65 | 12.65 | 2194696.0 |
| 2011-07-08 08:35:00 | AAPL | Stock | 12.65 | 12.6554 | 12.6071 | 12.6368 | 1297240.0 |
| 2011-07-08 08:40:00 | AAPL | Stock | 12.6389 | 12.6707 | 12.635 | 12.6571 | 689304.0 |
| 2011-07-08 08:45:00 | AAPL | Stock | 12.6607 | 12.6693 | 12.6521 | 12.6607 | 430976.0 |
| 2011-07-08 08:50:00 | AAPL | Stock | 12.6607 | 12.6607 | 12.6346 | 12.6364 | 531664.0 |
| 2011-07-08 08:55:00 | AAPL | Stock | 12.6368 | 12.6368 | 12.6082 | 12.6096 | 660800.0 |
| 2011-07-08 09:00:00 | AAPL | Stock | 12.6089 | 12.6139 | 12.5804 | 12.5925 | 859740.0 |
| 2011-07-08 09:05:00 | AAPL | Stock | 12.5939 | 12.6121 | 12.5911 | 12.6114 | 851060.0 |
| 2011-07-08 09:10:00 | AAPL | Stock | 12.6121 | 12.6121 | 12.5921 | 12.5968 | 299516.0 |
| 2011-07-08 09:15:00 | AAPL | Stock | 12.5989 | 12.6125 | 12.5911 | 12.6125 | 495852.0 |
| 2011-07-08 09:20:00 | AAPL | Stock | 12.6089 | 12.6189 | 12.5964 | 12.6007 | 240352.0 |
| 2011-07-08 09:25:00 | AAPL | Stock | 12.5964 | 12.6296 | 12.5964 | 12.6193 | 446600.0 |
| 2011-07-08 09:30:00 | AAPL | Stock | 12.6193 | 12.7471 | 12.5786 | 12.7436 | 28799848.0 |
| 2011-07-08 09:35:00 | AAPL | Stock | 12.7436 | 12.7675 | 12.7243 | 12.725 | 23103976.0 |
| 2011-07-08 09:40:00 | AAPL | Stock | 12.7268 | 12.7904 | 12.7243 | 12.7882 | 18549356.0 |
| 2011-07-08 09:45:00 | AAPL | Stock | 12.7868 | 12.8025 | 12.7761 | 12.7807 | 17792180.0 |
| 2011-07-08 09:50:00 | AAPL | Stock | 12.784 | 12.8196 | 12.775 | 12.8129 | 14094892.0 |
| 2011-07-08 09:55:00 | AAPL | Stock | 12.8131 | 12.8382 | 12.8131 | 12.8299 | 17465924.0 |
| 2011-07-08 10:00:00 | AAPL | Stock | 12.8311 | 12.8532 | 12.8086 | 12.8114 | 17614996.0 |
| 2011-07-08 10:05:00 | AAPL | Stock | 12.8104 | 12.8318 | 12.8018 | 12.8257 | 13811112.0 |
| 2011-07-08 10:10:00 | AAPL | Stock | 12.825 | 12.8318 | 12.7968 | 12.7979 | 8687868.0 |
| 2011-07-08 10:15:00 | AAPL | Stock | 12.7979 | 12.81 | 12.7632 | 12.7729 | 16133600.0 |
| 2011-07-08 10:20:00 | AAPL | Stock | 12.7736 | 12.8036 | 12.7679 | 12.8036 | 8456084.0 |
| 2011-07-08 10:25:00 | AAPL | Stock | 12.8029 | 12.8211 | 12.7946 | 12.8193 | 7715652.0 |
| 2011-07-08 10:30:00 | AAPL | Stock | 12.8157 | 12.82 | 12.7661 | 12.7739 | 10193428.0 |
| 2011-07-08 10:35:00 | AAPL | Stock | 12.7732 | 12.7993 | 12.7621 | 12.7818 | 9349452.0 |
> showing 50 of 324,900 rows — these rows as CSV