PREVIEW / stock_1min / 2008-05-14
file: by_date/stock_1min/2008/2008-05-14.parquet size: 12.2 MB rows: 988,710 symbols: 2,714
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 |
|---|---|---|---|---|---|---|---|
| 2008-05-14 04:40:00 | AAPL | Stock | 6.7975 | 6.7975 | 6.7975 | 6.7975 | 11200.0 |
| 2008-05-14 07:47:00 | AAPL | Stock | 6.7879 | 6.7879 | 6.7879 | 6.7879 | 7000.0 |
| 2008-05-14 07:48:00 | AAPL | Stock | 6.7875 | 6.7875 | 6.7875 | 6.7875 | 2800.0 |
| 2008-05-14 07:58:00 | AAPL | Stock | 6.7943 | 6.7943 | 6.7943 | 6.7943 | 5600.0 |
| 2008-05-14 08:00:00 | AAPL | Stock | 6.7843 | 6.7904 | 6.7843 | 6.7857 | 72940.0 |
| 2008-05-14 08:01:00 | AAPL | Stock | 6.785 | 6.7857 | 6.785 | 6.7857 | 13300.0 |
| 2008-05-14 08:02:00 | AAPL | Stock | 6.7836 | 6.7857 | 6.7836 | 6.7857 | 14000.0 |
| 2008-05-14 08:03:00 | AAPL | Stock | 6.7893 | 6.7893 | 6.7893 | 6.7893 | 14000.0 |
| 2008-05-14 08:04:00 | AAPL | Stock | 6.7893 | 6.7893 | 6.7882 | 6.7882 | 15260.0 |
| 2008-05-14 08:05:00 | AAPL | Stock | 6.7857 | 6.7857 | 6.7857 | 6.7857 | 26460.0 |
| 2008-05-14 08:06:00 | AAPL | Stock | 6.7893 | 6.7896 | 6.7893 | 6.7896 | 26740.0 |
| 2008-05-14 08:07:00 | AAPL | Stock | 6.7896 | 6.7943 | 6.7896 | 6.7929 | 76776.0 |
| 2008-05-14 08:08:00 | AAPL | Stock | 6.7943 | 6.7946 | 6.7929 | 6.7929 | 35588.0 |
| 2008-05-14 08:09:00 | AAPL | Stock | 6.7946 | 6.7946 | 6.7939 | 6.7939 | 13748.0 |
| 2008-05-14 08:10:00 | AAPL | Stock | 6.795 | 6.7964 | 6.795 | 6.7964 | 59248.0 |
| 2008-05-14 08:11:00 | AAPL | Stock | 6.7964 | 6.7982 | 6.7964 | 6.7982 | 47264.0 |
| 2008-05-14 08:12:00 | AAPL | Stock | 6.8018 | 6.81 | 6.8018 | 6.8064 | 73416.0 |
| 2008-05-14 08:13:00 | AAPL | Stock | 6.805 | 6.8054 | 6.8039 | 6.8039 | 51800.0 |
| 2008-05-14 08:14:00 | AAPL | Stock | 6.8029 | 6.8029 | 6.8025 | 6.8025 | 8400.0 |
| 2008-05-14 08:15:00 | AAPL | Stock | 6.8025 | 6.8025 | 6.8025 | 6.8025 | 19600.0 |
| 2008-05-14 08:16:00 | AAPL | Stock | 6.8046 | 6.8071 | 6.8046 | 6.8071 | 31864.0 |
| 2008-05-14 08:17:00 | AAPL | Stock | 6.8096 | 6.8146 | 6.8096 | 6.8121 | 169176.0 |
| 2008-05-14 08:18:00 | AAPL | Stock | 6.8125 | 6.8143 | 6.8125 | 6.8136 | 50400.0 |
| 2008-05-14 08:19:00 | AAPL | Stock | 6.8125 | 6.8125 | 6.8125 | 6.8125 | 6580.0 |
| 2008-05-14 08:20:00 | AAPL | Stock | 6.8118 | 6.8143 | 6.8114 | 6.8143 | 103320.0 |
| 2008-05-14 08:21:00 | AAPL | Stock | 6.8157 | 6.8161 | 6.8146 | 6.8146 | 106400.0 |
| 2008-05-14 08:22:00 | AAPL | Stock | 6.8157 | 6.8157 | 6.8125 | 6.8125 | 90300.0 |
| 2008-05-14 08:23:00 | AAPL | Stock | 6.8125 | 6.8125 | 6.8075 | 6.8079 | 72660.0 |
| 2008-05-14 08:24:00 | AAPL | Stock | 6.8071 | 6.8075 | 6.805 | 6.8075 | 47600.0 |
| 2008-05-14 08:25:00 | AAPL | Stock | 6.8079 | 6.8079 | 6.8054 | 6.8057 | 28700.0 |
| 2008-05-14 08:26:00 | AAPL | Stock | 6.8054 | 6.8054 | 6.8054 | 6.8054 | 16100.0 |
| 2008-05-14 08:27:00 | AAPL | Stock | 6.8036 | 6.8039 | 6.8032 | 6.8039 | 26600.0 |
| 2008-05-14 08:28:00 | AAPL | Stock | 6.8039 | 6.8111 | 6.8039 | 6.8075 | 64400.0 |
| 2008-05-14 08:29:00 | AAPL | Stock | 6.8132 | 6.8139 | 6.8107 | 6.8111 | 34356.0 |
| 2008-05-14 08:30:00 | AAPL | Stock | 6.8139 | 6.8393 | 6.8136 | 6.8307 | 379568.0 |
| 2008-05-14 08:31:00 | AAPL | Stock | 6.8307 | 6.8368 | 6.8282 | 6.8304 | 265328.0 |
| 2008-05-14 08:32:00 | AAPL | Stock | 6.8304 | 6.8321 | 6.8286 | 6.8321 | 101416.0 |
| 2008-05-14 08:33:00 | AAPL | Stock | 6.8354 | 6.8382 | 6.8339 | 6.8357 | 206892.0 |
| 2008-05-14 08:34:00 | AAPL | Stock | 6.8368 | 6.8368 | 6.8321 | 6.8325 | 237384.0 |
| 2008-05-14 08:35:00 | AAPL | Stock | 6.8321 | 6.8354 | 6.8293 | 6.8354 | 43400.0 |
| 2008-05-14 08:36:00 | AAPL | Stock | 6.8357 | 6.8379 | 6.8354 | 6.8371 | 262444.0 |
| 2008-05-14 08:37:00 | AAPL | Stock | 6.8375 | 6.8464 | 6.8357 | 6.8446 | 283920.0 |
| 2008-05-14 08:38:00 | AAPL | Stock | 6.8446 | 6.8446 | 6.8443 | 6.8443 | 109200.0 |
| 2008-05-14 08:39:00 | AAPL | Stock | 6.8429 | 6.8436 | 6.8393 | 6.8393 | 109620.0 |
| 2008-05-14 08:40:00 | AAPL | Stock | 6.8375 | 6.8429 | 6.8375 | 6.8429 | 131628.0 |
| 2008-05-14 08:41:00 | AAPL | Stock | 6.8446 | 6.8457 | 6.8429 | 6.8443 | 109984.0 |
| 2008-05-14 08:42:00 | AAPL | Stock | 6.8432 | 6.8436 | 6.8414 | 6.8429 | 103600.0 |
| 2008-05-14 08:43:00 | AAPL | Stock | 6.8429 | 6.8429 | 6.8425 | 6.8429 | 48244.0 |
| 2008-05-14 08:44:00 | AAPL | Stock | 6.8429 | 6.8429 | 6.8418 | 6.8418 | 61040.0 |
| 2008-05-14 08:45:00 | AAPL | Stock | 6.8425 | 6.8425 | 6.8414 | 6.8421 | 105140.0 |
> showing 50 of 988,710 rows — these rows as CSV