PREVIEW / stock_5min / 2011-08-11
file: by_date/stock_5min/2011/2011-08-11.parquet size: 5.3 MB rows: 353,086 symbols: 3,542
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.2796 | 13.2621 | 13.2668 | 11200.0 |
| 2011-08-11 04:05:00 | AAPL | Stock | 13.2607 | 13.2607 | 13.2607 | 13.2607 | 25200.0 |
| 2011-08-11 04:10:00 | AAPL | Stock | 13.2654 | 13.2654 | 13.2654 | 13.2654 | 2800.0 |
| 2011-08-11 04:15:00 | AAPL | Stock | 13.2871 | 13.2871 | 13.2729 | 13.2729 | 5600.0 |
| 2011-08-11 04:25:00 | AAPL | Stock | 13.2761 | 13.2761 | 13.2761 | 13.2761 | 2800.0 |
| 2011-08-11 04:30:00 | AAPL | Stock | 13.2893 | 13.2893 | 13.2893 | 13.2893 | 4200.0 |
| 2011-08-11 04:35: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:55:00 | AAPL | Stock | 13.3021 | 13.3021 | 13.3021 | 13.3021 | 8400.0 |
| 2011-08-11 05:20:00 | AAPL | Stock | 13.2539 | 13.2539 | 13.2539 | 13.2539 | 2800.0 |
| 2011-08-11 05:30:00 | AAPL | Stock | 13.2582 | 13.2582 | 13.2582 | 13.2582 | 2800.0 |
| 2011-08-11 05:35:00 | AAPL | Stock | 13.2854 | 13.2854 | 13.2854 | 13.2854 | 2800.0 |
| 2011-08-11 05:40:00 | AAPL | Stock | 13.25 | 13.25 | 13.25 | 13.25 | 3500.0 |
| 2011-08-11 05:45: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.1786 | 13.1786 | 22400.0 |
| 2011-08-11 06:00:00 | AAPL | Stock | 13.1589 | 13.1786 | 13.1143 | 13.1243 | 26600.0 |
| 2011-08-11 06:10:00 | AAPL | Stock | 13.1171 | 13.1171 | 13.1139 | 13.1161 | 8400.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:25:00 | AAPL | Stock | 13.175 | 13.175 | 13.175 | 13.175 | 2800.0 |
| 2011-08-11 06:30:00 | AAPL | Stock | 13.1536 | 13.1714 | 13.1529 | 13.1529 | 45696.0 |
| 2011-08-11 06:35:00 | AAPL | Stock | 13.1786 | 13.1904 | 13.1786 | 13.1871 | 65240.0 |
| 2011-08-11 06:55:00 | AAPL | Stock | 13.2089 | 13.2596 | 13.2089 | 13.2182 | 114800.0 |
| 2011-08-11 07:00:00 | AAPL | Stock | 13.2161 | 13.2282 | 13.2143 | 13.2143 | 66108.0 |
| 2011-08-11 07:05:00 | AAPL | Stock | 13.2021 | 13.2086 | 13.1882 | 13.1882 | 58800.0 |
| 2011-08-11 07:10:00 | AAPL | Stock | 13.1804 | 13.19 | 13.1625 | 13.1643 | 143892.0 |
| 2011-08-11 07:15:00 | AAPL | Stock | 13.1786 | 13.1911 | 13.1786 | 13.1911 | 46480.0 |
| 2011-08-11 07:20:00 | AAPL | Stock | 13.1939 | 13.205 | 13.18 | 13.1804 | 96068.0 |
| 2011-08-11 07:25:00 | AAPL | Stock | 13.165 | 13.165 | 13.1071 | 13.1079 | 86604.0 |
| 2011-08-11 07:30:00 | AAPL | Stock | 13.1071 | 13.1254 | 13.0804 | 13.1254 | 126616.0 |
| 2011-08-11 07:35:00 | AAPL | Stock | 13.1125 | 13.1125 | 13.0107 | 13.0725 | 430500.0 |
| 2011-08-11 07:40:00 | AAPL | Stock | 13.0775 | 13.1036 | 13.0446 | 13.0714 | 820540.0 |
| 2011-08-11 07:45:00 | AAPL | Stock | 13.0714 | 13.0721 | 13.0132 | 13.0246 | 895160.0 |
| 2011-08-11 07:50:00 | AAPL | Stock | 13.0157 | 13.0618 | 13.0157 | 13.0596 | 456120.0 |
| 2011-08-11 07:55:00 | AAPL | Stock | 13.0639 | 13.0639 | 13.0357 | 13.0429 | 115304.0 |
| 2011-08-11 08:00:00 | AAPL | Stock | 13.0361 | 13.1289 | 13.0357 | 13.0739 | 483224.0 |
| 2011-08-11 08:05:00 | AAPL | Stock | 13.0725 | 13.0911 | 13.0546 | 13.0911 | 697144.0 |
| 2011-08-11 08:10:00 | AAPL | Stock | 13.0929 | 13.0929 | 13.0457 | 13.0457 | 638484.0 |
| 2011-08-11 08:15:00 | AAPL | Stock | 13.0404 | 13.0536 | 13.0089 | 13.035 | 592844.0 |
| 2011-08-11 08:20:00 | AAPL | Stock | 13.0204 | 13.0393 | 13.0054 | 13.0082 | 622104.0 |
| 2011-08-11 08:25:00 | AAPL | Stock | 13.0161 | 13.0357 | 13.0036 | 13.0179 | 456596.0 |
| 2011-08-11 08:30:00 | AAPL | Stock | 13.0268 | 13.0536 | 12.9811 | 13.0179 | 1547644.0 |
| 2011-08-11 08:35:00 | AAPL | Stock | 13.0025 | 13.0279 | 12.9914 | 13.0111 | 497812.0 |
| 2011-08-11 08:40:00 | AAPL | Stock | 13.0204 | 13.0857 | 13.0204 | 13.0821 | 502824.0 |
| 2011-08-11 08:45:00 | AAPL | Stock | 13.0854 | 13.1139 | 13.0571 | 13.0571 | 800100.0 |
| 2011-08-11 08:50:00 | AAPL | Stock | 13.0604 | 13.0671 | 13.0457 | 13.0618 | 368032.0 |
| 2011-08-11 08:55:00 | AAPL | Stock | 13.0607 | 13.1436 | 13.0411 | 13.1436 | 1048516.0 |
| 2011-08-11 09:00:00 | AAPL | Stock | 13.1307 | 13.1857 | 13.1179 | 13.1586 | 1474256.0 |
| 2011-08-11 09:05:00 | AAPL | Stock | 13.1521 | 13.1768 | 13.1429 | 13.1714 | 384748.0 |
> showing 50 of 353,086 rows — these rows as CSV