PREVIEW / stock_5min / 2011-11-25
file: by_date/stock_5min/2011/2011-11-25.parquet size: 2.7 MB rows: 173,467 symbols: 3,359
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-11-25 04:00:00 | AAPL | Stock | 13.0571 | 13.0571 | 13.0571 | 13.0571 | 8400.0 |
| 2011-11-25 04:10:00 | AAPL | Stock | 13.0093 | 13.0093 | 13.0093 | 13.0093 | 2800.0 |
| 2011-11-25 04:40:00 | AAPL | Stock | 13.0089 | 13.0089 | 13.0089 | 13.0089 | 11200.0 |
| 2011-11-25 04:45:00 | AAPL | Stock | 12.9964 | 12.9964 | 12.9964 | 12.9964 | 12572.0 |
| 2011-11-25 06:45:00 | AAPL | Stock | 13.0179 | 13.0179 | 13.0179 | 13.0179 | 12740.0 |
| 2011-11-25 07:05:00 | AAPL | Stock | 13.0554 | 13.0554 | 13.0554 | 13.0554 | 2800.0 |
| 2011-11-25 07:15:00 | AAPL | Stock | 13.05 | 13.05 | 13.05 | 13.05 | 5320.0 |
| 2011-11-25 07:20:00 | AAPL | Stock | 13.0357 | 13.0457 | 13.0357 | 13.0396 | 11200.0 |
| 2011-11-25 07:25:00 | AAPL | Stock | 13.0604 | 13.0604 | 13.0604 | 13.0604 | 2800.0 |
| 2011-11-25 07:30:00 | AAPL | Stock | 13.0536 | 13.0539 | 13.0536 | 13.0539 | 8400.0 |
| 2011-11-25 07:40:00 | AAPL | Stock | 13.0554 | 13.0554 | 13.0554 | 13.0554 | 2800.0 |
| 2011-11-25 08:00:00 | AAPL | Stock | 13.0707 | 13.0768 | 13.0536 | 13.0704 | 148988.0 |
| 2011-11-25 08:05:00 | AAPL | Stock | 13.0646 | 13.1029 | 13.0575 | 13.0861 | 219128.0 |
| 2011-11-25 08:10:00 | AAPL | Stock | 13.0889 | 13.0979 | 13.07 | 13.07 | 73472.0 |
| 2011-11-25 08:15:00 | AAPL | Stock | 13.0675 | 13.0675 | 13.0493 | 13.0493 | 50120.0 |
| 2011-11-25 08:20:00 | AAPL | Stock | 13.0607 | 13.1032 | 13.0607 | 13.0836 | 208012.0 |
| 2011-11-25 08:25:00 | AAPL | Stock | 13.0857 | 13.1161 | 13.0857 | 13.1118 | 74704.0 |
| 2011-11-25 08:30:00 | AAPL | Stock | 13.125 | 13.1343 | 13.1071 | 13.1254 | 256200.0 |
| 2011-11-25 08:35:00 | AAPL | Stock | 13.12 | 13.1357 | 13.1071 | 13.125 | 432628.0 |
| 2011-11-25 08:40:00 | AAPL | Stock | 13.125 | 13.13 | 13.1161 | 13.1179 | 190680.0 |
| 2011-11-25 08:45:00 | AAPL | Stock | 13.1282 | 13.1554 | 13.1268 | 13.1554 | 174832.0 |
| 2011-11-25 08:50:00 | AAPL | Stock | 13.1561 | 13.1893 | 13.1432 | 13.1814 | 413000.0 |
| 2011-11-25 08:55:00 | AAPL | Stock | 13.1779 | 13.1857 | 13.1704 | 13.1821 | 105560.0 |
| 2011-11-25 09:00:00 | AAPL | Stock | 13.1757 | 13.1896 | 13.1664 | 13.1896 | 494004.0 |
| 2011-11-25 09:05:00 | AAPL | Stock | 13.1914 | 13.2018 | 13.1811 | 13.2018 | 284340.0 |
| 2011-11-25 09:10:00 | AAPL | Stock | 13.1982 | 13.2104 | 13.1964 | 13.2021 | 365428.0 |
| 2011-11-25 09:15:00 | AAPL | Stock | 13.1989 | 13.2354 | 13.1989 | 13.2321 | 603484.0 |
| 2011-11-25 09:20:00 | AAPL | Stock | 13.2236 | 13.2311 | 13.2021 | 13.2021 | 132720.0 |
| 2011-11-25 09:25:00 | AAPL | Stock | 13.2021 | 13.2207 | 13.1468 | 13.1468 | 2234428.0 |
| 2011-11-25 09:30:00 | AAPL | Stock | 13.1529 | 13.2054 | 13.1468 | 13.1954 | 10920084.0 |
| 2011-11-25 09:35:00 | AAPL | Stock | 13.1939 | 13.2389 | 13.1939 | 13.2318 | 9534112.0 |
| 2011-11-25 09:40:00 | AAPL | Stock | 13.2307 | 13.2554 | 13.2132 | 13.2196 | 8755600.0 |
| 2011-11-25 09:45:00 | AAPL | Stock | 13.2225 | 13.2225 | 13.1889 | 13.1971 | 5754280.0 |
| 2011-11-25 09:50:00 | AAPL | Stock | 13.1948 | 13.225 | 13.1943 | 13.2036 | 4549972.0 |
| 2011-11-25 09:55:00 | AAPL | Stock | 13.2026 | 13.2179 | 13.1721 | 13.1746 | 5386584.0 |
| 2011-11-25 10:00:00 | AAPL | Stock | 13.1718 | 13.2061 | 13.1707 | 13.1939 | 3584532.0 |
| 2011-11-25 10:05:00 | AAPL | Stock | 13.1936 | 13.2054 | 13.1882 | 13.2 | 3223696.0 |
| 2011-11-25 10:10:00 | AAPL | Stock | 13.2012 | 13.2096 | 13.1807 | 13.2021 | 3871504.0 |
| 2011-11-25 10:15:00 | AAPL | Stock | 13.2039 | 13.2064 | 13.185 | 13.1957 | 2594452.0 |
| 2011-11-25 10:20:00 | AAPL | Stock | 13.1968 | 13.2004 | 13.1671 | 13.1874 | 3909248.0 |
| 2011-11-25 10:25:00 | AAPL | Stock | 13.1861 | 13.1929 | 13.1418 | 13.1418 | 5434212.0 |
| 2011-11-25 10:30:00 | AAPL | Stock | 13.1418 | 13.1521 | 13.13 | 13.1493 | 4942336.0 |
| 2011-11-25 10:35:00 | AAPL | Stock | 13.1479 | 13.1546 | 13.125 | 13.1254 | 3618356.0 |
| 2011-11-25 10:40:00 | AAPL | Stock | 13.125 | 13.1321 | 13.1164 | 13.1261 | 4176704.0 |
| 2011-11-25 10:45:00 | AAPL | Stock | 13.13 | 13.1414 | 13.1239 | 13.1321 | 3309320.0 |
| 2011-11-25 10:50:00 | AAPL | Stock | 13.1341 | 13.1464 | 13.1196 | 13.1225 | 4226096.0 |
| 2011-11-25 10:55:00 | AAPL | Stock | 13.1207 | 13.1236 | 13.0986 | 13.1021 | 6531952.0 |
| 2011-11-25 11:00:00 | AAPL | Stock | 13.1018 | 13.1071 | 13.0804 | 13.0925 | 4623164.0 |
| 2011-11-25 11:05:00 | AAPL | Stock | 13.0921 | 13.115 | 13.0871 | 13.1071 | 3299324.0 |
| 2011-11-25 11:10:00 | AAPL | Stock | 13.1084 | 13.1214 | 13.1027 | 13.1143 | 3497620.0 |
> showing 50 of 173,467 rows — these rows as CSV