PREVIEW / stock_5min / 2012-12-31
file: by_date/stock_5min/2012/2012-12-31.parquet size: 5.0 MB rows: 336,527 symbols: 3,523
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-12-31 06:50:00 | AAPL | Stock | 18.15 | 18.1643 | 18.15 | 18.1643 | 16800.0 |
| 2012-12-31 06:55:00 | AAPL | Stock | 18.1732 | 18.1732 | 18.1732 | 18.1732 | 2800.0 |
| 2012-12-31 07:00:00 | AAPL | Stock | 18.15 | 18.175 | 18.15 | 18.175 | 17808.0 |
| 2012-12-31 07:05:00 | AAPL | Stock | 18.1518 | 18.1518 | 18.15 | 18.1504 | 25200.0 |
| 2012-12-31 07:10:00 | AAPL | Stock | 18.1504 | 18.1504 | 18.125 | 18.125 | 28000.0 |
| 2012-12-31 07:15:00 | AAPL | Stock | 18.1196 | 18.125 | 18.1071 | 18.1071 | 33600.0 |
| 2012-12-31 07:20:00 | AAPL | Stock | 18.1071 | 18.1071 | 18.0893 | 18.0893 | 22400.0 |
| 2012-12-31 07:25:00 | AAPL | Stock | 18.0982 | 18.1071 | 18.0982 | 18.1071 | 11200.0 |
| 2012-12-31 07:30:00 | AAPL | Stock | 18.125 | 18.125 | 18.1071 | 18.1161 | 19880.0 |
| 2012-12-31 07:35:00 | AAPL | Stock | 18.0979 | 18.0979 | 18.0971 | 18.0971 | 6160.0 |
| 2012-12-31 07:40:00 | AAPL | Stock | 18.1243 | 18.1321 | 18.1243 | 18.1321 | 11200.0 |
| 2012-12-31 07:45:00 | AAPL | Stock | 18.125 | 18.125 | 18.125 | 18.125 | 8400.0 |
| 2012-12-31 07:50:00 | AAPL | Stock | 18.1361 | 18.1429 | 18.1271 | 18.1271 | 39928.0 |
| 2012-12-31 07:55:00 | AAPL | Stock | 18.1379 | 18.1411 | 18.115 | 18.115 | 47600.0 |
| 2012-12-31 08:00:00 | AAPL | Stock | 18.1268 | 18.15 | 18.0075 | 18.1096 | 780808.0 |
| 2012-12-31 08:05:00 | AAPL | Stock | 18.1082 | 18.1204 | 18.0875 | 18.1071 | 130816.0 |
| 2012-12-31 08:10:00 | AAPL | Stock | 18.1071 | 18.1071 | 18.1 | 18.1 | 9884.0 |
| 2012-12-31 08:15:00 | AAPL | Stock | 18.1071 | 18.1232 | 18.1071 | 18.1232 | 28000.0 |
| 2012-12-31 08:20:00 | AAPL | Stock | 18.1225 | 18.13 | 18.1143 | 18.13 | 93212.0 |
| 2012-12-31 08:25:00 | AAPL | Stock | 18.13 | 18.1689 | 18.13 | 18.16 | 243208.0 |
| 2012-12-31 08:30:00 | AAPL | Stock | 18.1679 | 18.2214 | 18.1579 | 18.2054 | 391664.0 |
| 2012-12-31 08:35:00 | AAPL | Stock | 18.2121 | 18.2286 | 18.1882 | 18.2143 | 464100.0 |
| 2012-12-31 08:40:00 | AAPL | Stock | 18.2239 | 18.28 | 18.2089 | 18.2682 | 659596.0 |
| 2012-12-31 08:45:00 | AAPL | Stock | 18.2679 | 18.3146 | 18.2261 | 18.2393 | 611100.0 |
| 2012-12-31 08:50:00 | AAPL | Stock | 18.2489 | 18.3 | 18.2393 | 18.2839 | 575344.0 |
| 2012-12-31 08:55:00 | AAPL | Stock | 18.2718 | 18.2982 | 18.2679 | 18.2864 | 261968.0 |
| 2012-12-31 09:00:00 | AAPL | Stock | 18.2857 | 18.2964 | 18.2729 | 18.2964 | 211568.0 |
| 2012-12-31 09:05:00 | AAPL | Stock | 18.2893 | 18.2943 | 18.2504 | 18.2771 | 270088.0 |
| 2012-12-31 09:10:00 | AAPL | Stock | 18.2661 | 18.2782 | 18.2543 | 18.2589 | 138740.0 |
| 2012-12-31 09:15:00 | AAPL | Stock | 18.2575 | 18.2575 | 18.2386 | 18.2386 | 144200.0 |
| 2012-12-31 09:20:00 | AAPL | Stock | 18.2386 | 18.2654 | 18.2386 | 18.25 | 177352.0 |
| 2012-12-31 09:25:00 | AAPL | Stock | 18.2464 | 18.2536 | 18.2143 | 18.2257 | 608328.0 |
| 2012-12-31 09:30:00 | AAPL | Stock | 18.2332 | 18.4104 | 18.1786 | 18.3803 | 22312696.0 |
| 2012-12-31 09:35:00 | AAPL | Stock | 18.3879 | 18.5154 | 18.3757 | 18.5089 | 18254264.0 |
| 2012-12-31 09:40:00 | AAPL | Stock | 18.5132 | 18.5446 | 18.4661 | 18.4871 | 13685616.0 |
| 2012-12-31 09:45:00 | AAPL | Stock | 18.4943 | 18.5193 | 18.4464 | 18.5193 | 9772476.0 |
| 2012-12-31 09:50:00 | AAPL | Stock | 18.5107 | 18.5543 | 18.4536 | 18.5364 | 10238228.0 |
| 2012-12-31 09:55:00 | AAPL | Stock | 18.5421 | 18.7286 | 18.5255 | 18.7118 | 21590632.0 |
| 2012-12-31 10:00:00 | AAPL | Stock | 18.7118 | 18.7568 | 18.6897 | 18.7364 | 12897752.0 |
| 2012-12-31 10:05:00 | AAPL | Stock | 18.7325 | 18.7643 | 18.6636 | 18.6786 | 13323436.0 |
| 2012-12-31 10:10:00 | AAPL | Stock | 18.6786 | 18.7018 | 18.6304 | 18.6739 | 9706256.0 |
| 2012-12-31 10:15:00 | AAPL | Stock | 18.6721 | 18.6786 | 18.6339 | 18.6639 | 7610400.0 |
| 2012-12-31 10:20:00 | AAPL | Stock | 18.6629 | 18.7211 | 18.6575 | 18.7191 | 7523768.0 |
| 2012-12-31 10:25:00 | AAPL | Stock | 18.7139 | 18.7675 | 18.6911 | 18.7546 | 10660048.0 |
| 2012-12-31 10:30:00 | AAPL | Stock | 18.7557 | 18.8293 | 18.7429 | 18.7908 | 11431028.0 |
| 2012-12-31 10:35:00 | AAPL | Stock | 18.7907 | 18.815 | 18.7536 | 18.8068 | 7554848.0 |
| 2012-12-31 10:40:00 | AAPL | Stock | 18.805 | 18.8132 | 18.7814 | 18.7886 | 6306328.0 |
| 2012-12-31 10:45:00 | AAPL | Stock | 18.7955 | 18.81 | 18.7393 | 18.7586 | 7474292.0 |
| 2012-12-31 10:50:00 | AAPL | Stock | 18.7607 | 18.7643 | 18.7197 | 18.75 | 8063132.0 |
| 2012-12-31 10:55:00 | AAPL | Stock | 18.7477 | 18.7764 | 18.7414 | 18.7554 | 4793012.0 |
> showing 50 of 336,527 rows — these rows as CSV