PREVIEW / stock_5min / 2012-01-09
file: by_date/stock_5min/2012/2012-01-09.parquet size: 4.8 MB rows: 324,470 symbols: 3,534
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 |
|---|---|---|---|---|---|---|---|
| 2012-01-09 04:00:00 | AAPL | Stock | 15.1254 | 15.1254 | 15.1254 | 15.1254 | 3360.0 |
| 2012-01-09 04:05:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 2800.0 |
| 2012-01-09 05:00:00 | AAPL | Stock | 15.125 | 15.125 | 15.125 | 15.125 | 28000.0 |
| 2012-01-09 05:05:00 | AAPL | Stock | 15.125 | 15.125 | 15.1161 | 15.1161 | 25200.0 |
| 2012-01-09 05:25:00 | AAPL | Stock | 15.1075 | 15.1075 | 15.1075 | 15.1075 | 5600.0 |
| 2012-01-09 06:00:00 | AAPL | Stock | 15.0982 | 15.0982 | 15.0982 | 15.0982 | 28000.0 |
| 2012-01-09 06:05:00 | AAPL | Stock | 15.0914 | 15.0914 | 15.0914 | 15.0914 | 2800.0 |
| 2012-01-09 07:00:00 | AAPL | Stock | 15.0964 | 15.1329 | 15.0914 | 15.1207 | 72968.0 |
| 2012-01-09 07:05:00 | AAPL | Stock | 15.1221 | 15.1429 | 15.1221 | 15.1429 | 86800.0 |
| 2012-01-09 07:10:00 | AAPL | Stock | 15.1339 | 15.1339 | 15.1339 | 15.1339 | 67480.0 |
| 2012-01-09 07:15:00 | AAPL | Stock | 15.1304 | 15.1304 | 15.1207 | 15.1207 | 22400.0 |
| 2012-01-09 07:20:00 | AAPL | Stock | 15.1246 | 15.1254 | 15.1246 | 15.1254 | 30800.0 |
| 2012-01-09 07:25:00 | AAPL | Stock | 15.1257 | 15.1475 | 15.1257 | 15.1429 | 82740.0 |
| 2012-01-09 07:30:00 | AAPL | Stock | 15.1425 | 15.15 | 15.1329 | 15.1475 | 28000.0 |
| 2012-01-09 07:35:00 | AAPL | Stock | 15.1514 | 15.1518 | 15.1475 | 15.1475 | 17080.0 |
| 2012-01-09 07:40:00 | AAPL | Stock | 15.1568 | 15.1582 | 15.1518 | 15.1518 | 39200.0 |
| 2012-01-09 07:45:00 | AAPL | Stock | 15.1518 | 15.1518 | 15.1339 | 15.1339 | 40600.0 |
| 2012-01-09 07:50:00 | AAPL | Stock | 15.1332 | 15.1457 | 15.1304 | 15.1457 | 44800.0 |
| 2012-01-09 07:55:00 | AAPL | Stock | 15.1507 | 15.1514 | 15.1375 | 15.1429 | 223412.0 |
| 2012-01-09 08:00:00 | AAPL | Stock | 15.1332 | 15.1429 | 15.1232 | 15.1407 | 332724.0 |
| 2012-01-09 08:05:00 | AAPL | Stock | 15.1404 | 15.15 | 15.1357 | 15.1418 | 234668.0 |
| 2012-01-09 08:10:00 | AAPL | Stock | 15.1461 | 15.1554 | 15.1461 | 15.1536 | 351260.0 |
| 2012-01-09 08:15:00 | AAPL | Stock | 15.1529 | 15.1564 | 15.1475 | 15.15 | 138180.0 |
| 2012-01-09 08:20:00 | AAPL | Stock | 15.15 | 15.1607 | 15.1464 | 15.1607 | 247660.0 |
| 2012-01-09 08:25:00 | AAPL | Stock | 15.1582 | 15.1643 | 15.1564 | 15.1579 | 149744.0 |
| 2012-01-09 08:30:00 | AAPL | Stock | 15.1607 | 15.1636 | 15.1518 | 15.1625 | 146580.0 |
| 2012-01-09 08:35:00 | AAPL | Stock | 15.1625 | 15.175 | 15.1607 | 15.1711 | 123200.0 |
| 2012-01-09 08:40:00 | AAPL | Stock | 15.1732 | 15.2036 | 15.1643 | 15.2021 | 579180.0 |
| 2012-01-09 08:45:00 | AAPL | Stock | 15.2064 | 15.2107 | 15.18 | 15.1929 | 435988.0 |
| 2012-01-09 08:50:00 | AAPL | Stock | 15.1957 | 15.1971 | 15.1861 | 15.1929 | 146524.0 |
| 2012-01-09 08:55:00 | AAPL | Stock | 15.1943 | 15.1957 | 15.1793 | 15.1889 | 247744.0 |
| 2012-01-09 09:00:00 | AAPL | Stock | 15.1889 | 15.2032 | 15.1786 | 15.2032 | 445312.0 |
| 2012-01-09 09:05:00 | AAPL | Stock | 15.2 | 15.2282 | 15.2 | 15.2196 | 692412.0 |
| 2012-01-09 09:10:00 | AAPL | Stock | 15.2179 | 15.2425 | 15.2143 | 15.2364 | 784588.0 |
| 2012-01-09 09:15:00 | AAPL | Stock | 15.235 | 15.2393 | 15.2211 | 15.2239 | 412972.0 |
| 2012-01-09 09:20:00 | AAPL | Stock | 15.2239 | 15.2261 | 15.2143 | 15.225 | 232820.0 |
| 2012-01-09 09:25:00 | AAPL | Stock | 15.2286 | 15.24 | 15.1929 | 15.2029 | 1399160.0 |
| 2012-01-09 09:30:00 | AAPL | Stock | 15.2018 | 15.2418 | 15.1946 | 15.2075 | 22243732.0 |
| 2012-01-09 09:35:00 | AAPL | Stock | 15.2082 | 15.2125 | 15.1632 | 15.21 | 13908692.0 |
| 2012-01-09 09:40:00 | AAPL | Stock | 15.21 | 15.2321 | 15.1986 | 15.2243 | 10534972.0 |
| 2012-01-09 09:45:00 | AAPL | Stock | 15.2286 | 15.2304 | 15.2 | 15.2036 | 8321964.0 |
| 2012-01-09 09:50:00 | AAPL | Stock | 15.2057 | 15.2321 | 15.2015 | 15.2246 | 6932352.0 |
| 2012-01-09 09:55:00 | AAPL | Stock | 15.2232 | 15.2307 | 15.2129 | 15.2193 | 5388040.0 |
| 2012-01-09 10:00:00 | AAPL | Stock | 15.2193 | 15.2243 | 15.2029 | 15.2046 | 5356960.0 |
| 2012-01-09 10:05:00 | AAPL | Stock | 15.2036 | 15.2221 | 15.2008 | 15.2071 | 5004468.0 |
| 2012-01-09 10:10:00 | AAPL | Stock | 15.2057 | 15.2093 | 15.1921 | 15.2011 | 5233788.0 |
| 2012-01-09 10:15:00 | AAPL | Stock | 15.2018 | 15.26 | 15.1986 | 15.2475 | 14448504.0 |
| 2012-01-09 10:20:00 | AAPL | Stock | 15.2475 | 15.2636 | 15.2193 | 15.2336 | 9062060.0 |
| 2012-01-09 10:25:00 | AAPL | Stock | 15.2325 | 15.2532 | 15.2271 | 15.2418 | 4642988.0 |
| 2012-01-09 10:30:00 | AAPL | Stock | 15.2432 | 15.2432 | 15.2246 | 15.2357 | 4763500.0 |
> showing 50 of 324,470 rows — these rows as CSV