PREVIEW / stock_1min / 2013-05-13
file: by_date/stock_1min/2013/2013-05-13.parquet size: 13.1 MB rows: 965,360 symbols: 2,836
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 |
|---|---|---|---|---|---|---|---|
| 2013-05-13 04:00:00 | AAPL | Stock | 16.1607 | 16.1607 | 16.1607 | 16.1607 | 2800.0 |
| 2013-05-13 05:52:00 | AAPL | Stock | 16.0964 | 16.0964 | 16.0964 | 16.0964 | 2800.0 |
| 2013-05-13 06:06:00 | AAPL | Stock | 16.0739 | 16.0739 | 16.0739 | 16.0739 | 7000.0 |
| 2013-05-13 06:09:00 | AAPL | Stock | 16.0743 | 16.0743 | 16.0739 | 16.0739 | 8400.0 |
| 2013-05-13 06:47:00 | AAPL | Stock | 16.0643 | 16.0643 | 16.0643 | 16.0643 | 2800.0 |
| 2013-05-13 07:18:00 | AAPL | Stock | 16.0732 | 16.0732 | 16.0732 | 16.0732 | 22736.0 |
| 2013-05-13 07:24:00 | AAPL | Stock | 16.0761 | 16.0761 | 16.0761 | 16.0761 | 8400.0 |
| 2013-05-13 07:26:00 | AAPL | Stock | 16.0846 | 16.0846 | 16.0846 | 16.0846 | 2800.0 |
| 2013-05-13 07:27:00 | AAPL | Stock | 16.0861 | 16.0861 | 16.0861 | 16.0861 | 8400.0 |
| 2013-05-13 07:28:00 | AAPL | Stock | 16.0861 | 16.0861 | 16.0861 | 16.0861 | 2800.0 |
| 2013-05-13 07:30:00 | AAPL | Stock | 16.0911 | 16.0911 | 16.0911 | 16.0911 | 2800.0 |
| 2013-05-13 07:32:00 | AAPL | Stock | 16.0911 | 16.0911 | 16.0911 | 16.0911 | 25200.0 |
| 2013-05-13 07:38:00 | AAPL | Stock | 16.0911 | 16.0982 | 16.0911 | 16.0982 | 22288.0 |
| 2013-05-13 07:45:00 | AAPL | Stock | 16.1061 | 16.1071 | 16.1061 | 16.1071 | 19600.0 |
| 2013-05-13 07:50:00 | AAPL | Stock | 16.1196 | 16.1196 | 16.1196 | 16.1196 | 2800.0 |
| 2013-05-13 07:56:00 | AAPL | Stock | 16.1196 | 16.125 | 16.1196 | 16.125 | 75880.0 |
| 2013-05-13 08:00:00 | AAPL | Stock | 16.1421 | 16.1421 | 16.0661 | 16.1196 | 234444.0 |
| 2013-05-13 08:01:00 | AAPL | Stock | 16.1161 | 16.1393 | 16.1161 | 16.1304 | 57988.0 |
| 2013-05-13 08:02:00 | AAPL | Stock | 16.1318 | 16.145 | 16.1307 | 16.1429 | 143892.0 |
| 2013-05-13 08:03:00 | AAPL | Stock | 16.1443 | 16.1443 | 16.1343 | 16.1429 | 50400.0 |
| 2013-05-13 08:04:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.1357 | 16.1357 | 13160.0 |
| 2013-05-13 08:05:00 | AAPL | Stock | 16.1357 | 16.1393 | 16.1357 | 16.1393 | 11200.0 |
| 2013-05-13 08:06:00 | AAPL | Stock | 16.1368 | 16.1368 | 16.1336 | 16.1336 | 5600.0 |
| 2013-05-13 08:07:00 | AAPL | Stock | 16.1325 | 16.1393 | 16.1325 | 16.1393 | 8400.0 |
| 2013-05-13 08:08:00 | AAPL | Stock | 16.1343 | 16.1343 | 16.1325 | 16.1325 | 14000.0 |
| 2013-05-13 08:10:00 | AAPL | Stock | 16.1257 | 16.1257 | 16.1129 | 16.1129 | 30800.0 |
| 2013-05-13 08:11:00 | AAPL | Stock | 16.1125 | 16.1125 | 16.1107 | 16.1107 | 8400.0 |
| 2013-05-13 08:12:00 | AAPL | Stock | 16.1218 | 16.125 | 16.1189 | 16.125 | 70420.0 |
| 2013-05-13 08:17:00 | AAPL | Stock | 16.1243 | 16.1243 | 16.1179 | 16.1179 | 14000.0 |
| 2013-05-13 08:18:00 | AAPL | Stock | 16.1289 | 16.1293 | 16.1289 | 16.1293 | 13552.0 |
| 2013-05-13 08:19:00 | AAPL | Stock | 16.1243 | 16.1243 | 16.1243 | 16.1243 | 2800.0 |
| 2013-05-13 08:20:00 | AAPL | Stock | 16.1243 | 16.125 | 16.1243 | 16.125 | 43568.0 |
| 2013-05-13 08:21:00 | AAPL | Stock | 16.1179 | 16.1289 | 16.1179 | 16.1254 | 12152.0 |
| 2013-05-13 08:25:00 | AAPL | Stock | 16.1296 | 16.1411 | 16.1254 | 16.1411 | 70616.0 |
| 2013-05-13 08:27:00 | AAPL | Stock | 16.13 | 16.1321 | 16.13 | 16.1321 | 8400.0 |
| 2013-05-13 08:28:00 | AAPL | Stock | 16.1321 | 16.1321 | 16.1311 | 16.1321 | 8400.0 |
| 2013-05-13 08:30:00 | AAPL | Stock | 16.14 | 16.14 | 16.14 | 16.14 | 8400.0 |
| 2013-05-13 08:31:00 | AAPL | Stock | 16.1339 | 16.1411 | 16.1339 | 16.1411 | 25396.0 |
| 2013-05-13 08:32:00 | AAPL | Stock | 16.1418 | 16.1861 | 16.1418 | 16.18 | 110236.0 |
| 2013-05-13 08:33:00 | AAPL | Stock | 16.1625 | 16.2157 | 16.1625 | 16.2143 | 186172.0 |
| 2013-05-13 08:34:00 | AAPL | Stock | 16.2143 | 16.2243 | 16.2071 | 16.2239 | 190064.0 |
| 2013-05-13 08:35:00 | AAPL | Stock | 16.2154 | 16.2196 | 16.2036 | 16.2036 | 77000.0 |
| 2013-05-13 08:36:00 | AAPL | Stock | 16.2036 | 16.2114 | 16.1964 | 16.205 | 41440.0 |
| 2013-05-13 08:37:00 | AAPL | Stock | 16.1989 | 16.1989 | 16.1986 | 16.1986 | 5600.0 |
| 2013-05-13 08:38:00 | AAPL | Stock | 16.1971 | 16.2107 | 16.1964 | 16.2107 | 19768.0 |
| 2013-05-13 08:39:00 | AAPL | Stock | 16.21 | 16.2104 | 16.21 | 16.2104 | 14000.0 |
| 2013-05-13 08:40:00 | AAPL | Stock | 16.21 | 16.2268 | 16.21 | 16.2268 | 69020.0 |
| 2013-05-13 08:41:00 | AAPL | Stock | 16.2282 | 16.2282 | 16.2268 | 16.2271 | 11760.0 |
| 2013-05-13 08:42:00 | AAPL | Stock | 16.2282 | 16.2282 | 16.2232 | 16.2279 | 81620.0 |
| 2013-05-13 08:43:00 | AAPL | Stock | 16.2321 | 16.2464 | 16.2321 | 16.2371 | 69020.0 |
> showing 50 of 965,360 rows — these rows as CSV