PREVIEW / stock_5min / 2013-12-13
file: by_date/stock_5min/2013/2013-12-13.parquet size: 5.3 MB rows: 354,268 symbols: 3,530
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-13 05:00:00 | AAPL | Stock | 20.0946 | 20.0946 | 20.0946 | 20.0946 | 2800.0 |
| 2013-12-13 05:10:00 | AAPL | Stock | 20.0586 | 20.0586 | 20.0586 | 20.0586 | 2800.0 |
| 2013-12-13 05:45:00 | AAPL | Stock | 20.0536 | 20.0611 | 20.02 | 20.0611 | 8400.0 |
| 2013-12-13 06:00:00 | AAPL | Stock | 20.0625 | 20.0625 | 20.0625 | 20.0625 | 4200.0 |
| 2013-12-13 06:25:00 | AAPL | Stock | 20.075 | 20.075 | 20.0518 | 20.0518 | 8400.0 |
| 2013-12-13 06:30:00 | AAPL | Stock | 20.0696 | 20.0696 | 20.0696 | 20.0696 | 4200.0 |
| 2013-12-13 06:35:00 | AAPL | Stock | 20.0882 | 20.0882 | 20.0882 | 20.0882 | 2800.0 |
| 2013-12-13 06:40:00 | AAPL | Stock | 20.0961 | 20.0961 | 20.0961 | 20.0961 | 11200.0 |
| 2013-12-13 06:45:00 | AAPL | Stock | 20.0971 | 20.1018 | 20.0971 | 20.1018 | 18200.0 |
| 2013-12-13 06:50:00 | AAPL | Stock | 20.1189 | 20.1357 | 20.1189 | 20.1354 | 30800.0 |
| 2013-12-13 06:55:00 | AAPL | Stock | 20.1389 | 20.1418 | 20.1357 | 20.1418 | 8400.0 |
| 2013-12-13 07:00:00 | AAPL | Stock | 20.1371 | 20.1461 | 20.1236 | 20.13 | 60200.0 |
| 2013-12-13 07:05:00 | AAPL | Stock | 20.1189 | 20.1318 | 20.1082 | 20.1082 | 24080.0 |
| 2013-12-13 07:10:00 | AAPL | Stock | 20.1107 | 20.1232 | 20.1107 | 20.1232 | 19320.0 |
| 2013-12-13 07:15:00 | AAPL | Stock | 20.1175 | 20.1429 | 20.1175 | 20.1429 | 68964.0 |
| 2013-12-13 07:20:00 | AAPL | Stock | 20.1461 | 20.1661 | 20.1257 | 20.1607 | 81480.0 |
| 2013-12-13 07:25:00 | AAPL | Stock | 20.1436 | 20.1536 | 20.1404 | 20.1518 | 53900.0 |
| 2013-12-13 07:30:00 | AAPL | Stock | 20.1636 | 20.1782 | 20.1482 | 20.1782 | 135380.0 |
| 2013-12-13 07:35:00 | AAPL | Stock | 20.1782 | 20.1821 | 20.1714 | 20.1714 | 144592.0 |
| 2013-12-13 07:40:00 | AAPL | Stock | 20.1607 | 20.1696 | 20.1504 | 20.1671 | 64400.0 |
| 2013-12-13 07:45:00 | AAPL | Stock | 20.1518 | 20.1604 | 20.1518 | 20.1589 | 43596.0 |
| 2013-12-13 07:50:00 | AAPL | Stock | 20.1536 | 20.1536 | 20.1475 | 20.1475 | 74900.0 |
| 2013-12-13 07:55:00 | AAPL | Stock | 20.1489 | 20.1536 | 20.1429 | 20.1429 | 30800.0 |
| 2013-12-13 08:00:00 | AAPL | Stock | 20.1429 | 20.1643 | 20.0357 | 20.1171 | 211372.0 |
| 2013-12-13 08:05:00 | AAPL | Stock | 20.1161 | 20.1282 | 20.1129 | 20.1164 | 58688.0 |
| 2013-12-13 08:10:00 | AAPL | Stock | 20.1214 | 20.1318 | 20.1214 | 20.125 | 70000.0 |
| 2013-12-13 08:15:00 | AAPL | Stock | 20.125 | 20.1357 | 20.0193 | 20.0193 | 132552.0 |
| 2013-12-13 08:20:00 | AAPL | Stock | 20.125 | 20.1382 | 20.12 | 20.1214 | 134708.0 |
| 2013-12-13 08:25:00 | AAPL | Stock | 20.1239 | 20.1257 | 20.1179 | 20.1179 | 39200.0 |
| 2013-12-13 08:30:00 | AAPL | Stock | 20.1207 | 20.125 | 20.1121 | 20.1125 | 124432.0 |
| 2013-12-13 08:35:00 | AAPL | Stock | 20.1136 | 20.1136 | 20.0875 | 20.0979 | 321748.0 |
| 2013-12-13 08:40:00 | AAPL | Stock | 20.0964 | 20.0964 | 20.0804 | 20.0839 | 136276.0 |
| 2013-12-13 08:45:00 | AAPL | Stock | 20.0968 | 20.1 | 20.085 | 20.095 | 63700.0 |
| 2013-12-13 08:50:00 | AAPL | Stock | 20.095 | 20.1021 | 20.0939 | 20.095 | 93100.0 |
| 2013-12-13 08:55:00 | AAPL | Stock | 20.1032 | 20.1157 | 20.1032 | 20.1036 | 83720.0 |
| 2013-12-13 09:00:00 | AAPL | Stock | 20.0929 | 20.0929 | 20.0929 | 20.0929 | 3360.0 |
| 2013-12-13 09:05:00 | AAPL | Stock | 20.0964 | 20.1004 | 20.0907 | 20.0914 | 22148.0 |
| 2013-12-13 09:10:00 | AAPL | Stock | 20.0975 | 20.0975 | 20.0896 | 20.0904 | 1221472.0 |
| 2013-12-13 09:15:00 | AAPL | Stock | 20.0839 | 20.0971 | 20.0818 | 20.0971 | 75600.0 |
| 2013-12-13 09:20:00 | AAPL | Stock | 20.0929 | 20.1032 | 20.0907 | 20.0911 | 228116.0 |
| 2013-12-13 09:25:00 | AAPL | Stock | 20.0893 | 20.1157 | 20.0836 | 20.0839 | 120736.0 |
| 2013-12-13 09:30:00 | AAPL | Stock | 20.0843 | 20.1029 | 20.0439 | 20.0548 | 9144940.0 |
| 2013-12-13 09:35:00 | AAPL | Stock | 20.0552 | 20.08 | 20.0279 | 20.0393 | 5500992.0 |
| 2013-12-13 09:40:00 | AAPL | Stock | 20.04 | 20.0461 | 19.9579 | 19.9579 | 8695876.0 |
| 2013-12-13 09:45:00 | AAPL | Stock | 19.9628 | 19.9707 | 19.8664 | 19.9064 | 12717880.0 |
| 2013-12-13 09:50:00 | AAPL | Stock | 19.9121 | 19.9121 | 19.8589 | 19.8986 | 9494408.0 |
| 2013-12-13 09:55:00 | AAPL | Stock | 19.9006 | 19.9214 | 19.8357 | 19.8398 | 8437828.0 |
| 2013-12-13 10:00:00 | AAPL | Stock | 19.837 | 19.8429 | 19.7796 | 19.8125 | 12090736.0 |
| 2013-12-13 10:05:00 | AAPL | Stock | 19.8089 | 19.8929 | 19.8036 | 19.8916 | 9158044.0 |
| 2013-12-13 10:10:00 | AAPL | Stock | 19.8911 | 19.905 | 19.8693 | 19.895 | 7859264.0 |
> showing 50 of 354,268 rows — these rows as CSV