PREVIEW / stock_5min / 2011-03-23
file: by_date/stock_5min/2011/2011-03-23.parquet size: 4.8 MB rows: 326,452 symbols: 3,514
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-03-23 04:10:00 | AAPL | Stock | 12.1875 | 12.1875 | 12.1875 | 12.1875 | 2800.0 |
| 2011-03-23 04:25:00 | AAPL | Stock | 12.1875 | 12.1875 | 12.1875 | 12.1875 | 5600.0 |
| 2011-03-23 04:45:00 | AAPL | Stock | 12.1857 | 12.1857 | 12.1857 | 12.1857 | 5600.0 |
| 2011-03-23 04:50:00 | AAPL | Stock | 12.1829 | 12.1829 | 12.1829 | 12.1829 | 2800.0 |
| 2011-03-23 05:35:00 | AAPL | Stock | 12.175 | 12.1893 | 12.175 | 12.1893 | 30800.0 |
| 2011-03-23 05:50:00 | AAPL | Stock | 12.1832 | 12.1832 | 12.1832 | 12.1832 | 5600.0 |
| 2011-03-23 05:55:00 | AAPL | Stock | 12.1964 | 12.1964 | 12.1964 | 12.1964 | 2800.0 |
| 2011-03-23 06:05:00 | AAPL | Stock | 12.1964 | 12.1964 | 12.1964 | 12.1964 | 2800.0 |
| 2011-03-23 06:15:00 | AAPL | Stock | 12.2036 | 12.2036 | 12.2036 | 12.2036 | 2800.0 |
| 2011-03-23 06:20:00 | AAPL | Stock | 12.2032 | 12.2032 | 12.2032 | 12.2032 | 2800.0 |
| 2011-03-23 06:25:00 | AAPL | Stock | 12.2207 | 12.2207 | 12.2207 | 12.2207 | 2800.0 |
| 2011-03-23 06:45:00 | AAPL | Stock | 12.2186 | 12.2193 | 12.2186 | 12.2193 | 5600.0 |
| 2011-03-23 07:00:00 | AAPL | Stock | 12.2036 | 12.2036 | 12.2036 | 12.2036 | 2800.0 |
| 2011-03-23 07:05:00 | AAPL | Stock | 12.2143 | 12.2143 | 12.2036 | 12.2036 | 6300.0 |
| 2011-03-23 07:15:00 | AAPL | Stock | 12.2118 | 12.2118 | 12.2118 | 12.2118 | 2800.0 |
| 2011-03-23 07:20:00 | AAPL | Stock | 12.1946 | 12.2054 | 12.1946 | 12.2054 | 11200.0 |
| 2011-03-23 07:25:00 | AAPL | Stock | 12.2068 | 12.2068 | 12.1968 | 12.1968 | 8400.0 |
| 2011-03-23 07:30:00 | AAPL | Stock | 12.1932 | 12.1932 | 12.1686 | 12.1686 | 32200.0 |
| 2011-03-23 07:35:00 | AAPL | Stock | 12.1593 | 12.1593 | 12.1582 | 12.1582 | 13692.0 |
| 2011-03-23 07:45:00 | AAPL | Stock | 12.1593 | 12.1593 | 12.1546 | 12.1546 | 11200.0 |
| 2011-03-23 07:50:00 | AAPL | Stock | 12.1546 | 12.1546 | 12.1429 | 12.1482 | 25200.0 |
| 2011-03-23 07:55:00 | AAPL | Stock | 12.1493 | 12.1493 | 12.1407 | 12.1429 | 38220.0 |
| 2011-03-23 08:00:00 | AAPL | Stock | 12.1429 | 12.1536 | 12.1357 | 12.1536 | 116648.0 |
| 2011-03-23 08:05:00 | AAPL | Stock | 12.1479 | 12.1518 | 12.1357 | 12.1418 | 156800.0 |
| 2011-03-23 08:10:00 | AAPL | Stock | 12.1496 | 12.1496 | 12.1411 | 12.1432 | 114520.0 |
| 2011-03-23 08:15:00 | AAPL | Stock | 12.1429 | 12.1532 | 12.1429 | 12.15 | 66024.0 |
| 2011-03-23 08:20:00 | AAPL | Stock | 12.15 | 12.155 | 12.1393 | 12.1393 | 138544.0 |
| 2011-03-23 08:25:00 | AAPL | Stock | 12.1393 | 12.1429 | 12.1357 | 12.1361 | 39760.0 |
| 2011-03-23 08:30:00 | AAPL | Stock | 12.1393 | 12.1429 | 12.1393 | 12.1429 | 69580.0 |
| 2011-03-23 08:35:00 | AAPL | Stock | 12.1471 | 12.1529 | 12.1471 | 12.1529 | 37520.0 |
| 2011-03-23 08:40:00 | AAPL | Stock | 12.1464 | 12.1518 | 12.1464 | 12.1464 | 16800.0 |
| 2011-03-23 08:45:00 | AAPL | Stock | 12.1471 | 12.1536 | 12.1471 | 12.1514 | 40320.0 |
| 2011-03-23 08:50:00 | AAPL | Stock | 12.1496 | 12.1496 | 12.1343 | 12.1343 | 103124.0 |
| 2011-03-23 08:55:00 | AAPL | Stock | 12.1361 | 12.1361 | 12.1154 | 12.1179 | 200200.0 |
| 2011-03-23 09:00:00 | AAPL | Stock | 12.1157 | 12.125 | 12.1029 | 12.125 | 211820.0 |
| 2011-03-23 09:05:00 | AAPL | Stock | 12.1246 | 12.135 | 12.1239 | 12.1332 | 83048.0 |
| 2011-03-23 09:10:00 | AAPL | Stock | 12.1332 | 12.1411 | 12.1332 | 12.14 | 97160.0 |
| 2011-03-23 09:15:00 | AAPL | Stock | 12.1389 | 12.1389 | 12.1214 | 12.1214 | 120400.0 |
| 2011-03-23 09:20:00 | AAPL | Stock | 12.125 | 12.125 | 12.12 | 12.1214 | 95200.0 |
| 2011-03-23 09:25:00 | AAPL | Stock | 12.125 | 12.1286 | 12.1107 | 12.1114 | 261800.0 |
| 2011-03-23 09:30:00 | AAPL | Stock | 12.1211 | 12.1214 | 12.0811 | 12.1086 | 13892340.0 |
| 2011-03-23 09:35:00 | AAPL | Stock | 12.1086 | 12.1179 | 12.0789 | 12.0843 | 8425368.0 |
| 2011-03-23 09:40:00 | AAPL | Stock | 12.0857 | 12.0886 | 12.0668 | 12.0693 | 11005904.0 |
| 2011-03-23 09:45:00 | AAPL | Stock | 12.0679 | 12.0832 | 12.0629 | 12.0782 | 8486268.0 |
| 2011-03-23 09:50:00 | AAPL | Stock | 12.0782 | 12.0957 | 12.0657 | 12.0768 | 6772808.0 |
| 2011-03-23 09:55:00 | AAPL | Stock | 12.0768 | 12.1068 | 12.0711 | 12.0718 | 6375516.0 |
| 2011-03-23 10:00:00 | AAPL | Stock | 12.0718 | 12.0718 | 12.04 | 12.0614 | 12015080.0 |
| 2011-03-23 10:05:00 | AAPL | Stock | 12.0614 | 12.0621 | 12.04 | 12.0436 | 5792248.0 |
| 2011-03-23 10:10:00 | AAPL | Stock | 12.0443 | 12.0464 | 11.9982 | 12.0045 | 14156996.0 |
| 2011-03-23 10:15:00 | AAPL | Stock | 12.0046 | 12.0225 | 12.0 | 12.013 | 8644272.0 |
> showing 50 of 326,452 rows — these rows as CSV