PREVIEW / stock_5min / 2011-10-24
file: by_date/stock_5min/2011/2011-10-24.parquet size: 4.9 MB rows: 325,562 symbols: 3,512
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-10-24 04:25:00 | AAPL | Stock | 14.125 | 14.125 | 14.125 | 14.125 | 5600.0 |
| 2011-10-24 04:40:00 | AAPL | Stock | 14.125 | 14.125 | 14.125 | 14.125 | 2800.0 |
| 2011-10-24 04:45:00 | AAPL | Stock | 14.125 | 14.125 | 14.125 | 14.125 | 2800.0 |
| 2011-10-24 04:50:00 | AAPL | Stock | 14.1071 | 14.1071 | 14.1061 | 14.1061 | 16800.0 |
| 2011-10-24 05:00:00 | AAPL | Stock | 14.0786 | 14.0786 | 14.0786 | 14.0786 | 2800.0 |
| 2011-10-24 05:05:00 | AAPL | Stock | 14.0786 | 14.0786 | 14.0786 | 14.0786 | 2800.0 |
| 2011-10-24 05:25:00 | AAPL | Stock | 14.0786 | 14.0786 | 14.0786 | 14.0786 | 2800.0 |
| 2011-10-24 05:50:00 | AAPL | Stock | 14.0964 | 14.0964 | 14.0964 | 14.0964 | 5600.0 |
| 2011-10-24 06:05:00 | AAPL | Stock | 14.1071 | 14.1071 | 14.1071 | 14.1071 | 3920.0 |
| 2011-10-24 06:15:00 | AAPL | Stock | 14.1071 | 14.1071 | 14.1071 | 14.1071 | 10920.0 |
| 2011-10-24 06:20:00 | AAPL | Stock | 14.1036 | 14.1036 | 14.1036 | 14.1036 | 2800.0 |
| 2011-10-24 06:45:00 | AAPL | Stock | 14.1036 | 14.1036 | 14.1036 | 14.1036 | 2800.0 |
| 2011-10-24 06:55:00 | AAPL | Stock | 14.1 | 14.1164 | 14.1 | 14.1164 | 19600.0 |
| 2011-10-24 07:00:00 | AAPL | Stock | 14.1064 | 14.1064 | 14.1064 | 14.1064 | 2800.0 |
| 2011-10-24 07:10:00 | AAPL | Stock | 14.1064 | 14.1064 | 14.1064 | 14.1064 | 8120.0 |
| 2011-10-24 07:25:00 | AAPL | Stock | 14.1021 | 14.1071 | 14.1021 | 14.1021 | 71876.0 |
| 2011-10-24 07:30:00 | AAPL | Stock | 14.0964 | 14.1071 | 14.0964 | 14.0964 | 29932.0 |
| 2011-10-24 07:35:00 | AAPL | Stock | 14.0929 | 14.0929 | 14.0904 | 14.0904 | 5600.0 |
| 2011-10-24 07:40:00 | AAPL | Stock | 14.0943 | 14.0943 | 14.0943 | 14.0943 | 5600.0 |
| 2011-10-24 07:45:00 | AAPL | Stock | 14.0946 | 14.1204 | 14.09 | 14.1075 | 135240.0 |
| 2011-10-24 07:50:00 | AAPL | Stock | 14.1154 | 14.1154 | 14.1107 | 14.1107 | 14000.0 |
| 2011-10-24 07:55:00 | AAPL | Stock | 14.1182 | 14.1214 | 14.1071 | 14.1214 | 78008.0 |
| 2011-10-24 08:00:00 | AAPL | Stock | 14.1179 | 14.1339 | 14.1025 | 14.1321 | 201544.0 |
| 2011-10-24 08:05:00 | AAPL | Stock | 14.1286 | 14.15 | 14.1286 | 14.1339 | 241444.0 |
| 2011-10-24 08:10:00 | AAPL | Stock | 14.125 | 14.1429 | 14.1232 | 14.1429 | 99316.0 |
| 2011-10-24 08:15:00 | AAPL | Stock | 14.1464 | 14.1657 | 14.1429 | 14.1554 | 236292.0 |
| 2011-10-24 08:20:00 | AAPL | Stock | 14.1464 | 14.1464 | 14.13 | 14.13 | 83160.0 |
| 2011-10-24 08:25:00 | AAPL | Stock | 14.1464 | 14.1575 | 14.1464 | 14.1571 | 114996.0 |
| 2011-10-24 08:30:00 | AAPL | Stock | 14.1536 | 14.1568 | 14.1429 | 14.1532 | 167216.0 |
| 2011-10-24 08:35:00 | AAPL | Stock | 14.1529 | 14.1589 | 14.1468 | 14.1589 | 361928.0 |
| 2011-10-24 08:40:00 | AAPL | Stock | 14.1554 | 14.1629 | 14.155 | 14.1589 | 272832.0 |
| 2011-10-24 08:45:00 | AAPL | Stock | 14.1571 | 14.1643 | 14.1571 | 14.1625 | 105364.0 |
| 2011-10-24 08:50:00 | AAPL | Stock | 14.1571 | 14.1679 | 14.1571 | 14.1571 | 260120.0 |
| 2011-10-24 08:55:00 | AAPL | Stock | 14.1604 | 14.1607 | 14.1407 | 14.1407 | 202412.0 |
| 2011-10-24 09:00:00 | AAPL | Stock | 14.14 | 14.1607 | 14.14 | 14.1543 | 86968.0 |
| 2011-10-24 09:05:00 | AAPL | Stock | 14.1571 | 14.1607 | 14.1436 | 14.1496 | 124880.0 |
| 2011-10-24 09:10:00 | AAPL | Stock | 14.1489 | 14.1536 | 14.1468 | 14.1518 | 61600.0 |
| 2011-10-24 09:15:00 | AAPL | Stock | 14.1468 | 14.1514 | 14.1429 | 14.1429 | 56140.0 |
| 2011-10-24 09:20:00 | AAPL | Stock | 14.1429 | 14.1432 | 14.1375 | 14.1382 | 213304.0 |
| 2011-10-24 09:25:00 | AAPL | Stock | 14.1386 | 14.1554 | 14.1257 | 14.1464 | 708036.0 |
| 2011-10-24 09:30:00 | AAPL | Stock | 14.1457 | 14.2204 | 14.1214 | 14.2193 | 26718776.0 |
| 2011-10-24 09:35:00 | AAPL | Stock | 14.2146 | 14.2721 | 14.2021 | 14.2654 | 18556048.0 |
| 2011-10-24 09:40:00 | AAPL | Stock | 14.2643 | 14.2721 | 14.2361 | 14.2468 | 11242392.0 |
| 2011-10-24 09:45:00 | AAPL | Stock | 14.2474 | 14.2679 | 14.2321 | 14.2529 | 7695352.0 |
| 2011-10-24 09:50:00 | AAPL | Stock | 14.2557 | 14.2639 | 14.2396 | 14.2404 | 5925360.0 |
| 2011-10-24 09:55:00 | AAPL | Stock | 14.2411 | 14.2554 | 14.2375 | 14.2532 | 5652724.0 |
| 2011-10-24 10:00:00 | AAPL | Stock | 14.255 | 14.2661 | 14.2354 | 14.2547 | 7426216.0 |
| 2011-10-24 10:05:00 | AAPL | Stock | 14.2525 | 14.2857 | 14.2429 | 14.2821 | 12910520.0 |
| 2011-10-24 10:10:00 | AAPL | Stock | 14.2818 | 14.3779 | 14.2814 | 14.3571 | 29954204.0 |
| 2011-10-24 10:15:00 | AAPL | Stock | 14.3579 | 14.3643 | 14.3382 | 14.3382 | 10773588.0 |
> showing 50 of 325,562 rows — these rows as CSV