PREVIEW / stock_5min / 2011-10-05
file: by_date/stock_5min/2011/2011-10-05.parquet size: 4.9 MB rows: 332,727 symbols: 3,510
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-05 04:40:00 | AAPL | Stock | 13.2411 | 13.2411 | 13.2411 | 13.2411 | 5600.0 |
| 2011-10-05 04:45:00 | AAPL | Stock | 13.2321 | 13.2321 | 13.2321 | 13.2321 | 2800.0 |
| 2011-10-05 04:55:00 | AAPL | Stock | 13.2554 | 13.2554 | 13.2554 | 13.2554 | 8400.0 |
| 2011-10-05 05:15:00 | AAPL | Stock | 13.2321 | 13.2321 | 13.2321 | 13.2321 | 2800.0 |
| 2011-10-05 05:25:00 | AAPL | Stock | 13.1964 | 13.1964 | 13.1964 | 13.1964 | 11200.0 |
| 2011-10-05 05:30:00 | AAPL | Stock | 13.2214 | 13.2214 | 13.2214 | 13.2214 | 14000.0 |
| 2011-10-05 05:45:00 | AAPL | Stock | 13.2143 | 13.2143 | 13.2143 | 13.2143 | 2800.0 |
| 2011-10-05 06:05:00 | AAPL | Stock | 13.2143 | 13.2143 | 13.2143 | 13.2143 | 2800.0 |
| 2011-10-05 06:15:00 | AAPL | Stock | 13.2321 | 13.2321 | 13.2321 | 13.2321 | 16800.0 |
| 2011-10-05 06:20:00 | AAPL | Stock | 13.2321 | 13.2321 | 13.2321 | 13.2321 | 16800.0 |
| 2011-10-05 06:25:00 | AAPL | Stock | 13.2143 | 13.2214 | 13.2143 | 13.2214 | 16240.0 |
| 2011-10-05 06:30:00 | AAPL | Stock | 13.2321 | 13.2321 | 13.2321 | 13.2321 | 8400.0 |
| 2011-10-05 06:40:00 | AAPL | Stock | 13.2429 | 13.2661 | 13.2429 | 13.2661 | 25200.0 |
| 2011-10-05 06:45:00 | AAPL | Stock | 13.2643 | 13.2643 | 13.2221 | 13.2221 | 19600.0 |
| 2011-10-05 06:50:00 | AAPL | Stock | 13.2482 | 13.2607 | 13.2482 | 13.2607 | 14000.0 |
| 2011-10-05 07:00:00 | AAPL | Stock | 13.2679 | 13.2679 | 13.2679 | 13.2679 | 31920.0 |
| 2011-10-05 07:05:00 | AAPL | Stock | 13.2857 | 13.295 | 13.2857 | 13.295 | 14000.0 |
| 2011-10-05 07:10:00 | AAPL | Stock | 13.3157 | 13.3346 | 13.3157 | 13.3346 | 16800.0 |
| 2011-10-05 07:15:00 | AAPL | Stock | 13.335 | 13.3371 | 13.3179 | 13.3304 | 46900.0 |
| 2011-10-05 07:20:00 | AAPL | Stock | 13.3157 | 13.3157 | 13.2857 | 13.3125 | 99316.0 |
| 2011-10-05 07:25:00 | AAPL | Stock | 13.3214 | 13.3214 | 13.315 | 13.3214 | 14000.0 |
| 2011-10-05 07:30:00 | AAPL | Stock | 13.3089 | 13.3089 | 13.2857 | 13.2857 | 90216.0 |
| 2011-10-05 07:35:00 | AAPL | Stock | 13.2857 | 13.2879 | 13.2743 | 13.2754 | 42000.0 |
| 2011-10-05 07:40:00 | AAPL | Stock | 13.2679 | 13.2736 | 13.2443 | 13.2443 | 39900.0 |
| 2011-10-05 07:45:00 | AAPL | Stock | 13.2357 | 13.25 | 13.2214 | 13.2261 | 75628.0 |
| 2011-10-05 07:50:00 | AAPL | Stock | 13.2354 | 13.25 | 13.1843 | 13.2 | 115332.0 |
| 2011-10-05 07:55:00 | AAPL | Stock | 13.1964 | 13.1964 | 13.1732 | 13.1804 | 81368.0 |
| 2011-10-05 08:00:00 | AAPL | Stock | 13.2143 | 13.2143 | 13.1564 | 13.1879 | 542220.0 |
| 2011-10-05 08:05:00 | AAPL | Stock | 13.1857 | 13.2261 | 13.1857 | 13.2082 | 262360.0 |
| 2011-10-05 08:10:00 | AAPL | Stock | 13.2082 | 13.2143 | 13.2004 | 13.2054 | 104104.0 |
| 2011-10-05 08:15:00 | AAPL | Stock | 13.2036 | 13.2371 | 13.1829 | 13.2132 | 801696.0 |
| 2011-10-05 08:20:00 | AAPL | Stock | 13.2054 | 13.215 | 13.1607 | 13.1607 | 249424.0 |
| 2011-10-05 08:25:00 | AAPL | Stock | 13.1521 | 13.1696 | 13.0982 | 13.0982 | 906612.0 |
| 2011-10-05 08:30:00 | AAPL | Stock | 13.0982 | 13.1161 | 13.0457 | 13.1143 | 1023400.0 |
| 2011-10-05 08:35:00 | AAPL | Stock | 13.1093 | 13.1532 | 13.1071 | 13.1214 | 1099784.0 |
| 2011-10-05 08:40:00 | AAPL | Stock | 13.1143 | 13.1286 | 13.1064 | 13.1111 | 690368.0 |
| 2011-10-05 08:45:00 | AAPL | Stock | 13.1154 | 13.1289 | 13.0925 | 13.0925 | 356384.0 |
| 2011-10-05 08:50:00 | AAPL | Stock | 13.1007 | 13.1171 | 13.0893 | 13.1171 | 145544.0 |
| 2011-10-05 08:55:00 | AAPL | Stock | 13.1246 | 13.1246 | 13.0907 | 13.0964 | 319200.0 |
| 2011-10-05 09:00:00 | AAPL | Stock | 13.1011 | 13.16 | 13.1011 | 13.16 | 493136.0 |
| 2011-10-05 09:05:00 | AAPL | Stock | 13.1486 | 13.1696 | 13.1429 | 13.1532 | 466956.0 |
| 2011-10-05 09:10:00 | AAPL | Stock | 13.1429 | 13.1925 | 13.1429 | 13.175 | 650496.0 |
| 2011-10-05 09:15:00 | AAPL | Stock | 13.1657 | 13.1782 | 13.1557 | 13.1736 | 110460.0 |
| 2011-10-05 09:20:00 | AAPL | Stock | 13.1786 | 13.1857 | 13.1525 | 13.1525 | 278320.0 |
| 2011-10-05 09:25:00 | AAPL | Stock | 13.1539 | 13.1539 | 13.13 | 13.1379 | 476280.0 |
| 2011-10-05 09:30:00 | AAPL | Stock | 13.1386 | 13.1389 | 12.95 | 13.03 | 36389248.0 |
| 2011-10-05 09:35:00 | AAPL | Stock | 13.0229 | 13.0518 | 12.9854 | 13.0075 | 17194520.0 |
| 2011-10-05 09:40:00 | AAPL | Stock | 13.0107 | 13.0446 | 12.9843 | 13.0189 | 17431988.0 |
| 2011-10-05 09:45:00 | AAPL | Stock | 13.0204 | 13.0779 | 12.9646 | 12.9886 | 20518736.0 |
| 2011-10-05 09:50:00 | AAPL | Stock | 12.9886 | 13.0161 | 12.8679 | 12.9275 | 23719556.0 |
> showing 50 of 332,727 rows — these rows as CSV