PREVIEW / stock_5min / 2012-08-28
file: by_date/stock_5min/2012/2012-08-28.parquet size: 4.6 MB rows: 308,258 symbols: 3,441
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-08-28 04:00:00 | AAPL | Stock | 24.1429 | 24.2143 | 24.1429 | 24.2139 | 40600.0 |
| 2012-08-28 04:15:00 | AAPL | Stock | 24.1879 | 24.1879 | 24.1879 | 24.1879 | 2800.0 |
| 2012-08-28 04:20:00 | AAPL | Stock | 24.1786 | 24.1786 | 24.1786 | 24.1786 | 2800.0 |
| 2012-08-28 04:30:00 | AAPL | Stock | 24.2132 | 24.2143 | 24.2132 | 24.2143 | 52500.0 |
| 2012-08-28 04:45:00 | AAPL | Stock | 24.2343 | 24.2343 | 24.2343 | 24.2343 | 2800.0 |
| 2012-08-28 05:20:00 | AAPL | Stock | 24.2325 | 24.2325 | 24.2325 | 24.2325 | 2800.0 |
| 2012-08-28 05:30:00 | AAPL | Stock | 24.2321 | 24.2321 | 24.2321 | 24.2321 | 11200.0 |
| 2012-08-28 05:55:00 | AAPL | Stock | 24.2411 | 24.2411 | 24.2411 | 24.2411 | 6720.0 |
| 2012-08-28 06:00:00 | AAPL | Stock | 24.2218 | 24.2218 | 24.2214 | 24.2214 | 8400.0 |
| 2012-08-28 06:05:00 | AAPL | Stock | 24.225 | 24.225 | 24.225 | 24.225 | 5600.0 |
| 2012-08-28 06:25:00 | AAPL | Stock | 24.2143 | 24.2143 | 24.2143 | 24.2143 | 2800.0 |
| 2012-08-28 06:40:00 | AAPL | Stock | 24.2036 | 24.2036 | 24.2036 | 24.2036 | 7280.0 |
| 2012-08-28 07:00:00 | AAPL | Stock | 24.1843 | 24.1964 | 24.1786 | 24.1786 | 24920.0 |
| 2012-08-28 07:05:00 | AAPL | Stock | 24.1679 | 24.1679 | 24.1439 | 24.1439 | 39200.0 |
| 2012-08-28 07:10:00 | AAPL | Stock | 24.1482 | 24.1536 | 24.1446 | 24.1536 | 25704.0 |
| 2012-08-28 07:15:00 | AAPL | Stock | 24.1525 | 24.1704 | 24.1525 | 24.1546 | 37800.0 |
| 2012-08-28 07:20:00 | AAPL | Stock | 24.1643 | 24.1643 | 24.1571 | 24.1571 | 8820.0 |
| 2012-08-28 07:25:00 | AAPL | Stock | 24.1589 | 24.1739 | 24.1571 | 24.1739 | 33600.0 |
| 2012-08-28 07:30:00 | AAPL | Stock | 24.1696 | 24.1696 | 24.1661 | 24.1661 | 16800.0 |
| 2012-08-28 07:35:00 | AAPL | Stock | 24.1571 | 24.1571 | 24.1571 | 24.1571 | 2800.0 |
| 2012-08-28 07:40:00 | AAPL | Stock | 24.1643 | 24.1643 | 24.1496 | 24.15 | 19600.0 |
| 2012-08-28 07:45:00 | AAPL | Stock | 24.1464 | 24.1464 | 24.1286 | 24.1404 | 58800.0 |
| 2012-08-28 07:50:00 | AAPL | Stock | 24.14 | 24.14 | 24.1296 | 24.1296 | 5600.0 |
| 2012-08-28 07:55:00 | AAPL | Stock | 24.14 | 24.1564 | 24.1389 | 24.1429 | 94388.0 |
| 2012-08-28 08:00:00 | AAPL | Stock | 24.1568 | 24.2 | 24.125 | 24.1357 | 478688.0 |
| 2012-08-28 08:05:00 | AAPL | Stock | 24.1321 | 24.1339 | 24.0929 | 24.1057 | 404488.0 |
| 2012-08-28 08:10:00 | AAPL | Stock | 24.1036 | 24.1071 | 24.0943 | 24.1011 | 76636.0 |
| 2012-08-28 08:15:00 | AAPL | Stock | 24.0982 | 24.1064 | 24.0893 | 24.0982 | 134736.0 |
| 2012-08-28 08:20:00 | AAPL | Stock | 24.1029 | 24.1079 | 24.1018 | 24.1079 | 76972.0 |
| 2012-08-28 08:25:00 | AAPL | Stock | 24.1161 | 24.1314 | 24.1089 | 24.1161 | 75320.0 |
| 2012-08-28 08:30:00 | AAPL | Stock | 24.1125 | 24.1207 | 24.0982 | 24.0982 | 57344.0 |
| 2012-08-28 08:35:00 | AAPL | Stock | 24.0946 | 24.1029 | 24.0757 | 24.0757 | 160300.0 |
| 2012-08-28 08:40:00 | AAPL | Stock | 24.0789 | 24.0971 | 24.0775 | 24.0964 | 144312.0 |
| 2012-08-28 08:45:00 | AAPL | Stock | 24.0968 | 24.0993 | 24.0839 | 24.0839 | 51072.0 |
| 2012-08-28 08:50:00 | AAPL | Stock | 24.0857 | 24.0857 | 24.0857 | 24.0857 | 14000.0 |
| 2012-08-28 08:55:00 | AAPL | Stock | 24.0911 | 24.0939 | 24.0911 | 24.0939 | 15400.0 |
| 2012-08-28 09:00:00 | AAPL | Stock | 24.0871 | 24.0954 | 24.0871 | 24.0893 | 42812.0 |
| 2012-08-28 09:05:00 | AAPL | Stock | 24.0943 | 24.0993 | 24.0896 | 24.0993 | 39648.0 |
| 2012-08-28 09:10:00 | AAPL | Stock | 24.1068 | 24.1089 | 24.0954 | 24.1071 | 303212.0 |
| 2012-08-28 09:15:00 | AAPL | Stock | 24.1071 | 24.1071 | 24.1021 | 24.1036 | 116200.0 |
| 2012-08-28 09:20:00 | AAPL | Stock | 24.1032 | 24.1071 | 24.1032 | 24.1071 | 72744.0 |
| 2012-08-28 09:25:00 | AAPL | Stock | 24.1036 | 24.1071 | 24.0943 | 24.1071 | 235340.0 |
| 2012-08-28 09:30:00 | AAPL | Stock | 24.1061 | 24.1071 | 24.0186 | 24.0414 | 15488060.0 |
| 2012-08-28 09:35:00 | AAPL | Stock | 24.0425 | 24.0675 | 23.9911 | 24.0618 | 12414108.0 |
| 2012-08-28 09:40:00 | AAPL | Stock | 24.0621 | 24.125 | 24.055 | 24.0961 | 11184656.0 |
| 2012-08-28 09:45:00 | AAPL | Stock | 24.0936 | 24.1143 | 24.0625 | 24.0889 | 6013924.0 |
| 2012-08-28 09:50:00 | AAPL | Stock | 24.0886 | 24.1018 | 24.04 | 24.0446 | 6579412.0 |
| 2012-08-28 09:55:00 | AAPL | Stock | 24.0411 | 24.0489 | 24.0121 | 24.0236 | 4515924.0 |
| 2012-08-28 10:00:00 | AAPL | Stock | 24.0189 | 24.0607 | 24.0079 | 24.0368 | 5793088.0 |
| 2012-08-28 10:05:00 | AAPL | Stock | 24.0371 | 24.0711 | 24.0196 | 24.0618 | 4886840.0 |
> showing 50 of 308,258 rows — these rows as CSV