PREVIEW / stock_5min / 2012-07-30
file: by_date/stock_5min/2012/2012-07-30.parquet size: 4.6 MB rows: 309,101 symbols: 3,502
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-07-30 04:20:00 | AAPL | Stock | 20.8964 | 20.8964 | 20.8964 | 20.8964 | 2800.0 |
| 2012-07-30 04:35:00 | AAPL | Stock | 20.8661 | 20.8661 | 20.8661 | 20.8661 | 2800.0 |
| 2012-07-30 04:55:00 | AAPL | Stock | 20.8679 | 20.8679 | 20.8679 | 20.8679 | 5600.0 |
| 2012-07-30 05:25:00 | AAPL | Stock | 20.8682 | 20.8682 | 20.8679 | 20.8682 | 19600.0 |
| 2012-07-30 05:40:00 | AAPL | Stock | 20.8929 | 20.8929 | 20.8929 | 20.8929 | 4732.0 |
| 2012-07-30 05:55:00 | AAPL | Stock | 20.9171 | 20.9171 | 20.9171 | 20.9171 | 2800.0 |
| 2012-07-30 06:00:00 | AAPL | Stock | 20.9104 | 20.9104 | 20.9104 | 20.9104 | 2800.0 |
| 2012-07-30 06:20:00 | AAPL | Stock | 20.8929 | 20.8929 | 20.8929 | 20.8929 | 14000.0 |
| 2012-07-30 06:25:00 | AAPL | Stock | 20.8696 | 20.8696 | 20.8696 | 20.8696 | 3108.0 |
| 2012-07-30 06:35:00 | AAPL | Stock | 20.9107 | 20.9107 | 20.9107 | 20.9107 | 2800.0 |
| 2012-07-30 06:45:00 | AAPL | Stock | 20.8968 | 20.8968 | 20.8968 | 20.8968 | 5320.0 |
| 2012-07-30 06:55:00 | AAPL | Stock | 20.8964 | 20.8964 | 20.8964 | 20.8964 | 10808.0 |
| 2012-07-30 07:00:00 | AAPL | Stock | 20.8964 | 20.9107 | 20.8929 | 20.8929 | 65520.0 |
| 2012-07-30 07:05:00 | AAPL | Stock | 20.8929 | 20.8929 | 20.8929 | 20.8929 | 2800.0 |
| 2012-07-30 07:10:00 | AAPL | Stock | 20.8929 | 20.9125 | 20.8929 | 20.8929 | 58968.0 |
| 2012-07-30 07:15:00 | AAPL | Stock | 20.8864 | 20.9086 | 20.8864 | 20.8929 | 39200.0 |
| 2012-07-30 07:20:00 | AAPL | Stock | 20.8789 | 20.8857 | 20.87 | 20.8857 | 10948.0 |
| 2012-07-30 07:25:00 | AAPL | Stock | 20.9014 | 20.9086 | 20.9014 | 20.9086 | 11452.0 |
| 2012-07-30 07:30:00 | AAPL | Stock | 20.9071 | 20.9071 | 20.9071 | 20.9071 | 2800.0 |
| 2012-07-30 07:40:00 | AAPL | Stock | 20.8964 | 20.8964 | 20.8857 | 20.8857 | 19600.0 |
| 2012-07-30 07:45:00 | AAPL | Stock | 20.8857 | 20.9029 | 20.8857 | 20.9029 | 51380.0 |
| 2012-07-30 07:50:00 | AAPL | Stock | 20.8946 | 20.8946 | 20.8861 | 20.8861 | 28000.0 |
| 2012-07-30 07:55:00 | AAPL | Stock | 20.8839 | 20.8839 | 20.8711 | 20.8839 | 16800.0 |
| 2012-07-30 08:00:00 | AAPL | Stock | 20.8832 | 20.9679 | 20.875 | 20.9679 | 554008.0 |
| 2012-07-30 08:05:00 | AAPL | Stock | 20.965 | 21.0282 | 20.9607 | 21.0229 | 1120644.0 |
| 2012-07-30 08:10:00 | AAPL | Stock | 21.0211 | 21.0679 | 21.0189 | 21.0529 | 1165136.0 |
| 2012-07-30 08:15:00 | AAPL | Stock | 21.0446 | 21.0775 | 21.0357 | 21.0411 | 475552.0 |
| 2012-07-30 08:20:00 | AAPL | Stock | 21.0489 | 21.0786 | 21.0432 | 21.0786 | 223356.0 |
| 2012-07-30 08:25:00 | AAPL | Stock | 21.0786 | 21.1071 | 21.0714 | 21.08 | 444332.0 |
| 2012-07-30 08:30:00 | AAPL | Stock | 21.0732 | 21.0893 | 21.0614 | 21.0893 | 154616.0 |
| 2012-07-30 08:35:00 | AAPL | Stock | 21.0832 | 21.1607 | 21.0832 | 21.1525 | 600376.0 |
| 2012-07-30 08:40:00 | AAPL | Stock | 21.1468 | 21.1929 | 21.145 | 21.1589 | 494368.0 |
| 2012-07-30 08:45:00 | AAPL | Stock | 21.1564 | 21.1714 | 21.125 | 21.125 | 333592.0 |
| 2012-07-30 08:50:00 | AAPL | Stock | 21.1357 | 21.1371 | 21.0989 | 21.1075 | 219380.0 |
| 2012-07-30 08:55:00 | AAPL | Stock | 21.11 | 21.1168 | 21.0993 | 21.1071 | 245280.0 |
| 2012-07-30 09:00:00 | AAPL | Stock | 21.1064 | 21.1071 | 21.09 | 21.1021 | 189560.0 |
| 2012-07-30 09:05:00 | AAPL | Stock | 21.1071 | 21.1286 | 21.1071 | 21.1164 | 182588.0 |
| 2012-07-30 09:10:00 | AAPL | Stock | 21.1125 | 21.1136 | 21.0989 | 21.1075 | 132020.0 |
| 2012-07-30 09:15:00 | AAPL | Stock | 21.0989 | 21.1071 | 21.08 | 21.0829 | 119000.0 |
| 2012-07-30 09:20:00 | AAPL | Stock | 21.0829 | 21.0964 | 21.0786 | 21.0893 | 205800.0 |
| 2012-07-30 09:25:00 | AAPL | Stock | 21.0875 | 21.1061 | 21.0811 | 21.1029 | 369292.0 |
| 2012-07-30 09:30:00 | AAPL | Stock | 21.1029 | 21.1796 | 20.9936 | 21.17 | 17715236.0 |
| 2012-07-30 09:35:00 | AAPL | Stock | 21.1699 | 21.2968 | 21.1586 | 21.2669 | 24973172.0 |
| 2012-07-30 09:40:00 | AAPL | Stock | 21.2611 | 21.3571 | 21.2464 | 21.3529 | 16562784.0 |
| 2012-07-30 09:45:00 | AAPL | Stock | 21.3529 | 21.3686 | 21.2879 | 21.2989 | 13341524.0 |
| 2012-07-30 09:50:00 | AAPL | Stock | 21.2986 | 21.3136 | 21.2654 | 21.2804 | 8422120.0 |
| 2012-07-30 09:55:00 | AAPL | Stock | 21.2804 | 21.3464 | 21.2768 | 21.3179 | 8596924.0 |
| 2012-07-30 10:00:00 | AAPL | Stock | 21.3199 | 21.3643 | 21.2904 | 21.3482 | 8496824.0 |
| 2012-07-30 10:05:00 | AAPL | Stock | 21.3454 | 21.3743 | 21.3304 | 21.3614 | 9349676.0 |
| 2012-07-30 10:10:00 | AAPL | Stock | 21.3575 | 21.4086 | 21.3561 | 21.3757 | 13006980.0 |
> showing 50 of 309,101 rows — these rows as CSV