PREVIEW / stock_5min / 2010-06-14
file: by_date/stock_5min/2010/2010-06-14.parquet size: 4.8 MB rows: 331,547 symbols: 3,467
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-14 04:15:00 | AAPL | Stock | 9.0943 | 9.0943 | 9.0943 | 9.0943 | 2800.0 |
| 2010-06-14 04:30:00 | AAPL | Stock | 9.0921 | 9.0921 | 9.0921 | 9.0921 | 5600.0 |
| 2010-06-14 04:35:00 | AAPL | Stock | 9.1039 | 9.1039 | 9.1039 | 9.1039 | 5600.0 |
| 2010-06-14 05:05:00 | AAPL | Stock | 9.1204 | 9.1204 | 9.1204 | 9.1204 | 2800.0 |
| 2010-06-14 05:10:00 | AAPL | Stock | 9.125 | 9.125 | 9.125 | 9.125 | 2800.0 |
| 2010-06-14 05:30:00 | AAPL | Stock | 9.1321 | 9.1429 | 9.1321 | 9.1429 | 11200.0 |
| 2010-06-14 05:40:00 | AAPL | Stock | 9.125 | 9.1729 | 9.125 | 9.1521 | 23856.0 |
| 2010-06-14 06:25:00 | AAPL | Stock | 9.1643 | 9.1643 | 9.1643 | 9.1643 | 8456.0 |
| 2010-06-14 06:30:00 | AAPL | Stock | 9.1643 | 9.1643 | 9.1643 | 9.1643 | 17444.0 |
| 2010-06-14 06:55:00 | AAPL | Stock | 9.1429 | 9.1429 | 9.1429 | 9.1429 | 5628.0 |
| 2010-06-14 07:00:00 | AAPL | Stock | 9.1293 | 9.1429 | 9.1293 | 9.1429 | 19600.0 |
| 2010-06-14 07:10:00 | AAPL | Stock | 9.1325 | 9.1425 | 9.1314 | 9.1314 | 34160.0 |
| 2010-06-14 07:15:00 | AAPL | Stock | 9.1393 | 9.1393 | 9.1393 | 9.1393 | 4872.0 |
| 2010-06-14 07:20:00 | AAPL | Stock | 9.1268 | 9.1268 | 9.1129 | 9.1129 | 67228.0 |
| 2010-06-14 07:25:00 | AAPL | Stock | 9.1129 | 9.1339 | 9.1129 | 9.1339 | 68740.0 |
| 2010-06-14 07:30:00 | AAPL | Stock | 9.1343 | 9.1418 | 9.1214 | 9.1214 | 61600.0 |
| 2010-06-14 07:35:00 | AAPL | Stock | 9.125 | 9.1268 | 9.125 | 9.1268 | 8400.0 |
| 2010-06-14 07:40:00 | AAPL | Stock | 9.1286 | 9.1286 | 9.1268 | 9.1268 | 9800.0 |
| 2010-06-14 07:45:00 | AAPL | Stock | 9.1268 | 9.1393 | 9.1268 | 9.1389 | 35000.0 |
| 2010-06-14 07:50:00 | AAPL | Stock | 9.1389 | 9.1425 | 9.1293 | 9.1293 | 26600.0 |
| 2010-06-14 07:55:00 | AAPL | Stock | 9.1357 | 9.1429 | 9.1339 | 9.1375 | 69776.0 |
| 2010-06-14 08:00:00 | AAPL | Stock | 9.1361 | 9.14 | 9.1268 | 9.1379 | 182420.0 |
| 2010-06-14 08:05:00 | AAPL | Stock | 9.1404 | 9.1486 | 9.0686 | 9.1446 | 310072.0 |
| 2010-06-14 08:10:00 | AAPL | Stock | 9.1446 | 9.1446 | 9.1404 | 9.1407 | 138740.0 |
| 2010-06-14 08:15:00 | AAPL | Stock | 9.1393 | 9.1421 | 9.1311 | 9.1364 | 145040.0 |
| 2010-06-14 08:20:00 | AAPL | Stock | 9.1393 | 9.1443 | 9.1379 | 9.1436 | 302232.0 |
| 2010-06-14 08:25:00 | AAPL | Stock | 9.1436 | 9.15 | 9.1414 | 9.1429 | 304724.0 |
| 2010-06-14 08:30:00 | AAPL | Stock | 9.1429 | 9.1504 | 9.1396 | 9.1496 | 192248.0 |
| 2010-06-14 08:35:00 | AAPL | Stock | 9.1493 | 9.1493 | 9.1375 | 9.1411 | 257628.0 |
| 2010-06-14 08:40:00 | AAPL | Stock | 9.1382 | 9.1454 | 9.1382 | 9.1425 | 150864.0 |
| 2010-06-14 08:45:00 | AAPL | Stock | 9.1454 | 9.1471 | 9.1382 | 9.14 | 163744.0 |
| 2010-06-14 08:50:00 | AAPL | Stock | 9.1411 | 9.1454 | 9.14 | 9.1411 | 158620.0 |
| 2010-06-14 08:55:00 | AAPL | Stock | 9.14 | 9.1471 | 9.1393 | 9.1471 | 295736.0 |
| 2010-06-14 09:00:00 | AAPL | Stock | 9.1457 | 9.1471 | 9.1436 | 9.1464 | 127372.0 |
| 2010-06-14 09:05:00 | AAPL | Stock | 9.1468 | 9.1489 | 9.1425 | 9.1425 | 239344.0 |
| 2010-06-14 09:10:00 | AAPL | Stock | 9.1414 | 9.1429 | 9.1361 | 9.1429 | 441504.0 |
| 2010-06-14 09:15:00 | AAPL | Stock | 9.1418 | 9.1429 | 9.1396 | 9.1421 | 95200.0 |
| 2010-06-14 09:20:00 | AAPL | Stock | 9.1411 | 9.1443 | 9.1339 | 9.1339 | 390040.0 |
| 2010-06-14 09:25:00 | AAPL | Stock | 9.1339 | 9.1579 | 9.1339 | 9.1411 | 1844836.0 |
| 2010-06-14 09:30:00 | AAPL | Stock | 9.1407 | 9.15 | 9.1161 | 9.1271 | 21841344.0 |
| 2010-06-14 09:35:00 | AAPL | Stock | 9.1286 | 9.1643 | 9.1261 | 9.1489 | 18557196.0 |
| 2010-06-14 09:40:00 | AAPL | Stock | 9.1498 | 9.1693 | 9.1357 | 9.1607 | 13321168.0 |
| 2010-06-14 09:45:00 | AAPL | Stock | 9.1607 | 9.1889 | 9.1493 | 9.1818 | 13198640.0 |
| 2010-06-14 09:50:00 | AAPL | Stock | 9.1836 | 9.1889 | 9.1564 | 9.1632 | 11348848.0 |
| 2010-06-14 09:55:00 | AAPL | Stock | 9.1632 | 9.1875 | 9.1618 | 9.175 | 7599312.0 |
| 2010-06-14 10:00:00 | AAPL | Stock | 9.1764 | 9.1911 | 9.1721 | 9.1809 | 7140980.0 |
| 2010-06-14 10:05:00 | AAPL | Stock | 9.1821 | 9.2046 | 9.1807 | 9.1961 | 11976496.0 |
| 2010-06-14 10:10:00 | AAPL | Stock | 9.1963 | 9.23 | 9.1961 | 9.2171 | 15855364.0 |
| 2010-06-14 10:15:00 | AAPL | Stock | 9.2174 | 9.2336 | 9.2146 | 9.2296 | 9514260.0 |
| 2010-06-14 10:20:00 | AAPL | Stock | 9.2304 | 9.2304 | 9.2178 | 9.2234 | 6112540.0 |
> showing 50 of 331,547 rows — these rows as CSV