PREVIEW / stock_5min / 2011-11-21
file: by_date/stock_5min/2011/2011-11-21.parquet size: 4.8 MB rows: 324,435 symbols: 3,513
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-21 04:00:00 | AAPL | Stock | 13.1821 | 13.1821 | 13.1821 | 13.1821 | 2800.0 |
| 2011-11-21 04:05:00 | AAPL | Stock | 13.1925 | 13.1925 | 13.1921 | 13.1921 | 8400.0 |
| 2011-11-21 04:20:00 | AAPL | Stock | 13.1975 | 13.1975 | 13.1975 | 13.1975 | 2800.0 |
| 2011-11-21 04:30:00 | AAPL | Stock | 13.1893 | 13.1893 | 13.1893 | 13.1893 | 4200.0 |
| 2011-11-21 04:50:00 | AAPL | Stock | 13.1389 | 13.1389 | 13.1332 | 13.1382 | 47600.0 |
| 2011-11-21 04:55:00 | AAPL | Stock | 13.1332 | 13.1429 | 13.1332 | 13.1429 | 50400.0 |
| 2011-11-21 05:00:00 | AAPL | Stock | 13.1518 | 13.1518 | 13.1518 | 13.1518 | 8400.0 |
| 2011-11-21 05:35:00 | AAPL | Stock | 13.1836 | 13.1836 | 13.1786 | 13.1786 | 16800.0 |
| 2011-11-21 05:50:00 | AAPL | Stock | 13.1789 | 13.2093 | 13.1786 | 13.1786 | 45640.0 |
| 2011-11-21 05:55:00 | AAPL | Stock | 13.2136 | 13.2136 | 13.2136 | 13.2136 | 2800.0 |
| 2011-11-21 06:10:00 | AAPL | Stock | 13.2046 | 13.2046 | 13.2046 | 13.2046 | 2800.0 |
| 2011-11-21 06:40:00 | AAPL | Stock | 13.2104 | 13.2104 | 13.2104 | 13.2104 | 5600.0 |
| 2011-11-21 07:00:00 | AAPL | Stock | 13.2143 | 13.2143 | 13.1964 | 13.1964 | 27272.0 |
| 2011-11-21 07:05:00 | AAPL | Stock | 13.2089 | 13.2143 | 13.2089 | 13.2089 | 63560.0 |
| 2011-11-21 07:10:00 | AAPL | Stock | 13.2071 | 13.2071 | 13.1964 | 13.1964 | 56000.0 |
| 2011-11-21 07:15:00 | AAPL | Stock | 13.2068 | 13.2143 | 13.2039 | 13.2039 | 151256.0 |
| 2011-11-21 07:20:00 | AAPL | Stock | 13.2071 | 13.2107 | 13.2071 | 13.2107 | 27300.0 |
| 2011-11-21 07:25:00 | AAPL | Stock | 13.2143 | 13.2232 | 13.2129 | 13.2232 | 61656.0 |
| 2011-11-21 07:30:00 | AAPL | Stock | 13.2218 | 13.2321 | 13.2218 | 13.2321 | 17220.0 |
| 2011-11-21 07:35:00 | AAPL | Stock | 13.2321 | 13.2321 | 13.2321 | 13.2321 | 22400.0 |
| 2011-11-21 07:40:00 | AAPL | Stock | 13.22 | 13.225 | 13.2179 | 13.225 | 8400.0 |
| 2011-11-21 07:50:00 | AAPL | Stock | 13.2232 | 13.2304 | 13.2179 | 13.2189 | 12740.0 |
| 2011-11-21 07:55:00 | AAPL | Stock | 13.2243 | 13.2339 | 13.2214 | 13.2214 | 19600.0 |
| 2011-11-21 08:00:00 | AAPL | Stock | 13.225 | 13.2679 | 13.2196 | 13.2479 | 231336.0 |
| 2011-11-21 08:05:00 | AAPL | Stock | 13.2507 | 13.2607 | 13.25 | 13.2536 | 259980.0 |
| 2011-11-21 08:10:00 | AAPL | Stock | 13.2229 | 13.2657 | 13.2143 | 13.2657 | 339220.0 |
| 2011-11-21 08:15:00 | AAPL | Stock | 13.2643 | 13.2836 | 13.245 | 13.25 | 396368.0 |
| 2011-11-21 08:20:00 | AAPL | Stock | 13.2464 | 13.2464 | 13.2314 | 13.2339 | 389816.0 |
| 2011-11-21 08:25:00 | AAPL | Stock | 13.2339 | 13.25 | 13.2339 | 13.2379 | 161028.0 |
| 2011-11-21 08:30:00 | AAPL | Stock | 13.2368 | 13.2464 | 13.2329 | 13.2464 | 123200.0 |
| 2011-11-21 08:35:00 | AAPL | Stock | 13.2493 | 13.2507 | 13.2389 | 13.25 | 96600.0 |
| 2011-11-21 08:40:00 | AAPL | Stock | 13.25 | 13.2711 | 13.2464 | 13.2589 | 119308.0 |
| 2011-11-21 08:45:00 | AAPL | Stock | 13.2679 | 13.2854 | 13.2679 | 13.2679 | 520548.0 |
| 2011-11-21 08:50:00 | AAPL | Stock | 13.2579 | 13.2586 | 13.2382 | 13.2382 | 568232.0 |
| 2011-11-21 08:55:00 | AAPL | Stock | 13.2429 | 13.2496 | 13.2414 | 13.2414 | 171080.0 |
| 2011-11-21 09:00:00 | AAPL | Stock | 13.2429 | 13.2464 | 13.2357 | 13.24 | 359940.0 |
| 2011-11-21 09:05:00 | AAPL | Stock | 13.2375 | 13.2389 | 13.2304 | 13.2339 | 291396.0 |
| 2011-11-21 09:10:00 | AAPL | Stock | 13.2275 | 13.2275 | 13.2179 | 13.2196 | 205184.0 |
| 2011-11-21 09:15:00 | AAPL | Stock | 13.2196 | 13.2232 | 13.2154 | 13.2157 | 259140.0 |
| 2011-11-21 09:20:00 | AAPL | Stock | 13.2168 | 13.225 | 13.2168 | 13.2229 | 143164.0 |
| 2011-11-21 09:25:00 | AAPL | Stock | 13.2214 | 13.2375 | 13.22 | 13.2286 | 204904.0 |
| 2011-11-21 09:30:00 | AAPL | Stock | 13.2286 | 13.2743 | 13.1696 | 13.2014 | 22257872.0 |
| 2011-11-21 09:35:00 | AAPL | Stock | 13.2014 | 13.2318 | 13.1107 | 13.1479 | 15778028.0 |
| 2011-11-21 09:40:00 | AAPL | Stock | 13.1489 | 13.175 | 13.1254 | 13.1714 | 11424560.0 |
| 2011-11-21 09:45:00 | AAPL | Stock | 13.1714 | 13.1929 | 13.1429 | 13.1796 | 7170968.0 |
| 2011-11-21 09:50:00 | AAPL | Stock | 13.1821 | 13.1886 | 13.1464 | 13.1511 | 7094164.0 |
| 2011-11-21 09:55:00 | AAPL | Stock | 13.1493 | 13.1936 | 13.1486 | 13.1529 | 7366632.0 |
| 2011-11-21 10:00:00 | AAPL | Stock | 13.1571 | 13.1675 | 13.115 | 13.1361 | 10843504.0 |
| 2011-11-21 10:05:00 | AAPL | Stock | 13.1361 | 13.1589 | 13.1179 | 13.152 | 8824396.0 |
| 2011-11-21 10:10:00 | AAPL | Stock | 13.1496 | 13.1643 | 13.1393 | 13.1629 | 5140576.0 |
> showing 50 of 324,435 rows — these rows as CSV