PREVIEW / stock_1min / 2011-08-11
file: by_date/stock_1min/2011/2011-08-11.parquet size: 15.6 MB rows: 1,122,336 symbols: 2,861
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-08-11 04:00:00 | AAPL | Stock | 13.2621 | 13.2621 | 13.2621 | 13.2621 | 2800.0 |
| 2011-08-11 04:02:00 | AAPL | Stock | 13.2796 | 13.2796 | 13.2796 | 13.2796 | 2800.0 |
| 2011-08-11 04:03:00 | AAPL | Stock | 13.2768 | 13.2768 | 13.2668 | 13.2668 | 5600.0 |
| 2011-08-11 04:06:00 | AAPL | Stock | 13.2607 | 13.2607 | 13.2607 | 13.2607 | 25200.0 |
| 2011-08-11 04:11:00 | AAPL | Stock | 13.2654 | 13.2654 | 13.2654 | 13.2654 | 2800.0 |
| 2011-08-11 04:18:00 | AAPL | Stock | 13.2871 | 13.2871 | 13.2871 | 13.2871 | 2800.0 |
| 2011-08-11 04:19:00 | AAPL | Stock | 13.2729 | 13.2729 | 13.2729 | 13.2729 | 2800.0 |
| 2011-08-11 04:26:00 | AAPL | Stock | 13.2761 | 13.2761 | 13.2761 | 13.2761 | 2800.0 |
| 2011-08-11 04:32:00 | AAPL | Stock | 13.2893 | 13.2893 | 13.2893 | 13.2893 | 4200.0 |
| 2011-08-11 04:38:00 | AAPL | Stock | 13.2993 | 13.2993 | 13.2993 | 13.2993 | 2800.0 |
| 2011-08-11 04:40:00 | AAPL | Stock | 13.2993 | 13.2993 | 13.2979 | 13.2979 | 5600.0 |
| 2011-08-11 04:56:00 | AAPL | Stock | 13.3021 | 13.3021 | 13.3021 | 13.3021 | 8400.0 |
| 2011-08-11 05:22:00 | AAPL | Stock | 13.2539 | 13.2539 | 13.2539 | 13.2539 | 2800.0 |
| 2011-08-11 05:32:00 | AAPL | Stock | 13.2582 | 13.2582 | 13.2582 | 13.2582 | 2800.0 |
| 2011-08-11 05:36:00 | AAPL | Stock | 13.2854 | 13.2854 | 13.2854 | 13.2854 | 2800.0 |
| 2011-08-11 05:44:00 | AAPL | Stock | 13.25 | 13.25 | 13.25 | 13.25 | 3500.0 |
| 2011-08-11 05:49:00 | AAPL | Stock | 13.22 | 13.22 | 13.22 | 13.22 | 2800.0 |
| 2011-08-11 05:50:00 | AAPL | Stock | 13.1964 | 13.1964 | 13.1964 | 13.1964 | 16800.0 |
| 2011-08-11 05:55:00 | AAPL | Stock | 13.2032 | 13.2032 | 13.2032 | 13.2032 | 8400.0 |
| 2011-08-11 05:56:00 | AAPL | Stock | 13.2032 | 13.2032 | 13.2032 | 13.2032 | 5600.0 |
| 2011-08-11 05:57:00 | AAPL | Stock | 13.1786 | 13.1786 | 13.1786 | 13.1786 | 5600.0 |
| 2011-08-11 05:59:00 | AAPL | Stock | 13.1786 | 13.1786 | 13.1786 | 13.1786 | 2800.0 |
| 2011-08-11 06:00:00 | AAPL | Stock | 13.1589 | 13.1589 | 13.1496 | 13.15 | 8400.0 |
| 2011-08-11 06:01:00 | AAPL | Stock | 13.1518 | 13.1786 | 13.1518 | 13.1786 | 7000.0 |
| 2011-08-11 06:02:00 | AAPL | Stock | 13.1446 | 13.1446 | 13.1189 | 13.1189 | 5600.0 |
| 2011-08-11 06:03:00 | AAPL | Stock | 13.1143 | 13.1243 | 13.1143 | 13.1243 | 5600.0 |
| 2011-08-11 06:11:00 | AAPL | Stock | 13.1171 | 13.1171 | 13.1171 | 13.1171 | 2800.0 |
| 2011-08-11 06:12:00 | AAPL | Stock | 13.1139 | 13.1139 | 13.1139 | 13.1139 | 2800.0 |
| 2011-08-11 06:13:00 | AAPL | Stock | 13.1161 | 13.1161 | 13.1161 | 13.1161 | 2800.0 |
| 2011-08-11 06:15:00 | AAPL | Stock | 13.1429 | 13.1429 | 13.1429 | 13.1429 | 25200.0 |
| 2011-08-11 06:20:00 | AAPL | Stock | 13.1425 | 13.1425 | 13.1425 | 13.1425 | 8400.0 |
| 2011-08-11 06:29:00 | AAPL | Stock | 13.175 | 13.175 | 13.175 | 13.175 | 2800.0 |
| 2011-08-11 06:31:00 | AAPL | Stock | 13.1536 | 13.1714 | 13.1529 | 13.1529 | 45696.0 |
| 2011-08-11 06:38:00 | AAPL | Stock | 13.1786 | 13.1786 | 13.1786 | 13.1786 | 26040.0 |
| 2011-08-11 06:39:00 | AAPL | Stock | 13.1871 | 13.1904 | 13.1871 | 13.1871 | 39200.0 |
| 2011-08-11 06:56:00 | AAPL | Stock | 13.2089 | 13.21 | 13.2089 | 13.21 | 5600.0 |
| 2011-08-11 06:57:00 | AAPL | Stock | 13.2596 | 13.2596 | 13.2596 | 13.2596 | 103600.0 |
| 2011-08-11 06:59:00 | AAPL | Stock | 13.2164 | 13.2182 | 13.2164 | 13.2182 | 5600.0 |
| 2011-08-11 07:00:00 | AAPL | Stock | 13.2161 | 13.2282 | 13.2143 | 13.2282 | 14000.0 |
| 2011-08-11 07:01:00 | AAPL | Stock | 13.2232 | 13.2232 | 13.2232 | 13.2232 | 4508.0 |
| 2011-08-11 07:02:00 | AAPL | Stock | 13.2146 | 13.2146 | 13.2143 | 13.2143 | 47600.0 |
| 2011-08-11 07:06:00 | AAPL | Stock | 13.2021 | 13.2021 | 13.1943 | 13.2 | 11200.0 |
| 2011-08-11 07:07:00 | AAPL | Stock | 13.1886 | 13.2086 | 13.1886 | 13.2086 | 16800.0 |
| 2011-08-11 07:08:00 | AAPL | Stock | 13.2071 | 13.2071 | 13.1882 | 13.1882 | 30800.0 |
| 2011-08-11 07:10:00 | AAPL | Stock | 13.1804 | 13.1804 | 13.1782 | 13.1782 | 19600.0 |
| 2011-08-11 07:11:00 | AAPL | Stock | 13.1821 | 13.19 | 13.1743 | 13.1761 | 16800.0 |
| 2011-08-11 07:12:00 | AAPL | Stock | 13.1864 | 13.1893 | 13.1864 | 13.1893 | 11200.0 |
| 2011-08-11 07:13:00 | AAPL | Stock | 13.1846 | 13.1846 | 13.165 | 13.165 | 51800.0 |
| 2011-08-11 07:14:00 | AAPL | Stock | 13.1654 | 13.1654 | 13.1625 | 13.1643 | 44492.0 |
| 2011-08-11 07:15:00 | AAPL | Stock | 13.1786 | 13.1793 | 13.1786 | 13.1793 | 21028.0 |
> showing 50 of 1,122,336 rows — these rows as CSV