PREVIEW / stock_1min / 2007-07-24
file: by_date/stock_1min/2007/2007-07-24.parquet size: 12.3 MB rows: 999,098 symbols: 2,525
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 |
|---|---|---|---|---|---|---|---|
| 2007-07-24 09:30:00 | AAPL | Stock | 4.96 | 4.9625 | 4.9179 | 4.925 | 19759544.0 |
| 2007-07-24 09:31:00 | AAPL | Stock | 4.9246 | 4.9607 | 4.8929 | 4.8954 | 17694852.0 |
| 2007-07-24 09:32:00 | AAPL | Stock | 4.8954 | 4.9298 | 4.8768 | 4.8979 | 19608652.0 |
| 2007-07-24 09:33:00 | AAPL | Stock | 4.8982 | 4.9075 | 4.8929 | 4.9025 | 12610500.0 |
| 2007-07-24 09:34:00 | AAPL | Stock | 4.9025 | 4.9036 | 4.8857 | 4.8875 | 14356020.0 |
| 2007-07-24 09:35:00 | AAPL | Stock | 4.8879 | 4.8954 | 4.8804 | 4.8929 | 14551936.0 |
| 2007-07-24 09:36:00 | AAPL | Stock | 4.8929 | 4.9057 | 4.8843 | 4.9039 | 12270608.0 |
| 2007-07-24 09:37:00 | AAPL | Stock | 4.9046 | 4.9061 | 4.8893 | 4.9046 | 11175416.0 |
| 2007-07-24 09:38:00 | AAPL | Stock | 4.905 | 4.9264 | 4.8982 | 4.9186 | 13812400.0 |
| 2007-07-24 09:39:00 | AAPL | Stock | 4.9186 | 4.9236 | 4.9111 | 4.9218 | 10143364.0 |
| 2007-07-24 09:40:00 | AAPL | Stock | 4.9214 | 4.9382 | 4.9214 | 4.9318 | 10960124.0 |
| 2007-07-24 09:41:00 | AAPL | Stock | 4.9321 | 4.9364 | 4.9264 | 4.9361 | 11965072.0 |
| 2007-07-24 09:42:00 | AAPL | Stock | 4.9361 | 4.9457 | 4.935 | 4.9454 | 8679580.0 |
| 2007-07-24 09:43:00 | AAPL | Stock | 4.9454 | 4.9714 | 4.9429 | 4.9625 | 14314328.0 |
| 2007-07-24 09:44:00 | AAPL | Stock | 4.9632 | 4.966 | 4.9525 | 4.9564 | 11741296.0 |
| 2007-07-24 09:45:00 | AAPL | Stock | 4.9561 | 4.9564 | 4.9464 | 4.9554 | 8267532.0 |
| 2007-07-24 09:46:00 | AAPL | Stock | 4.955 | 4.9714 | 4.955 | 4.97 | 13172376.0 |
| 2007-07-24 09:47:00 | AAPL | Stock | 4.9693 | 4.9768 | 4.9643 | 4.9693 | 9994628.0 |
| 2007-07-24 09:48:00 | AAPL | Stock | 4.9703 | 4.9811 | 4.9643 | 4.9661 | 10664276.0 |
| 2007-07-24 09:49:00 | AAPL | Stock | 4.9664 | 4.9711 | 4.9557 | 4.9596 | 9826992.0 |
| 2007-07-24 09:50:00 | AAPL | Stock | 4.9597 | 4.9679 | 4.9504 | 4.9643 | 6797700.0 |
| 2007-07-24 09:51:00 | AAPL | Stock | 4.9643 | 4.9654 | 4.9579 | 4.9593 | 4792816.0 |
| 2007-07-24 09:52:00 | AAPL | Stock | 4.9593 | 4.9604 | 4.9536 | 4.955 | 5225976.0 |
| 2007-07-24 09:53:00 | AAPL | Stock | 4.9554 | 4.9679 | 4.9544 | 4.9632 | 4913608.0 |
| 2007-07-24 09:54:00 | AAPL | Stock | 4.9632 | 4.9639 | 4.9554 | 4.9582 | 4509876.0 |
| 2007-07-24 09:55:00 | AAPL | Stock | 4.9586 | 4.9586 | 4.9371 | 4.9382 | 11688488.0 |
| 2007-07-24 09:56:00 | AAPL | Stock | 4.9382 | 4.9479 | 4.9368 | 4.9454 | 7169596.0 |
| 2007-07-24 09:57:00 | AAPL | Stock | 4.9457 | 4.95 | 4.9357 | 4.9357 | 7035672.0 |
| 2007-07-24 09:58:00 | AAPL | Stock | 4.9357 | 4.9429 | 4.9321 | 4.9339 | 6234256.0 |
| 2007-07-24 09:59:00 | AAPL | Stock | 4.9339 | 4.9386 | 4.9286 | 4.9379 | 7070840.0 |
| 2007-07-24 10:00:00 | AAPL | Stock | 4.9368 | 4.9429 | 4.9361 | 4.9361 | 4022424.0 |
| 2007-07-24 10:01:00 | AAPL | Stock | 4.9371 | 4.9375 | 4.9321 | 4.9332 | 4985988.0 |
| 2007-07-24 10:02:00 | AAPL | Stock | 4.9333 | 4.9454 | 4.9332 | 4.9404 | 5574520.0 |
| 2007-07-24 10:03:00 | AAPL | Stock | 4.9407 | 4.9582 | 4.9386 | 4.9536 | 6157060.0 |
| 2007-07-24 10:04:00 | AAPL | Stock | 4.9532 | 4.9579 | 4.9518 | 4.9547 | 3298400.0 |
| 2007-07-24 10:05:00 | AAPL | Stock | 4.9548 | 4.9557 | 4.9468 | 4.9479 | 3366720.0 |
| 2007-07-24 10:06:00 | AAPL | Stock | 4.9471 | 4.9475 | 4.94 | 4.9439 | 3827768.0 |
| 2007-07-24 10:07:00 | AAPL | Stock | 4.9443 | 4.9446 | 4.9343 | 4.938 | 2977968.0 |
| 2007-07-24 10:08:00 | AAPL | Stock | 4.9364 | 4.9418 | 4.9311 | 4.9414 | 3602788.0 |
| 2007-07-24 10:09:00 | AAPL | Stock | 4.9404 | 4.9557 | 4.9368 | 4.955 | 6007036.0 |
| 2007-07-24 10:10:00 | AAPL | Stock | 4.9554 | 4.9646 | 4.9518 | 4.9639 | 6103832.0 |
| 2007-07-24 10:11:00 | AAPL | Stock | 4.9639 | 4.9825 | 4.9625 | 4.9825 | 11413864.0 |
| 2007-07-24 10:12:00 | AAPL | Stock | 4.9829 | 4.9879 | 4.9654 | 4.9771 | 9270688.0 |
| 2007-07-24 10:13:00 | AAPL | Stock | 4.9771 | 4.9854 | 4.9743 | 4.9793 | 5955012.0 |
| 2007-07-24 10:14:00 | AAPL | Stock | 4.9793 | 4.9896 | 4.9793 | 4.9814 | 6154064.0 |
| 2007-07-24 10:15:00 | AAPL | Stock | 4.9814 | 4.9821 | 4.9775 | 4.9818 | 4297104.0 |
| 2007-07-24 10:16:00 | AAPL | Stock | 4.9818 | 4.9943 | 4.9796 | 4.9939 | 7786380.0 |
| 2007-07-24 10:17:00 | AAPL | Stock | 4.9939 | 4.9996 | 4.9914 | 4.9996 | 8920324.0 |
| 2007-07-24 10:18:00 | AAPL | Stock | 4.9996 | 5.0 | 4.9929 | 4.9942 | 9423820.0 |
| 2007-07-24 10:19:00 | AAPL | Stock | 4.9946 | 4.9971 | 4.9893 | 4.9936 | 4190816.0 |
> showing 50 of 999,098 rows — these rows as CSV