PREVIEW / stock_1min / 2010-02-09
file: by_date/stock_1min/2010/2010-02-09.parquet size: 12.8 MB rows: 970,979 symbols: 2,795
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-09 04:15:00 | AAPL | Stock | 6.9361 | 6.9682 | 6.9361 | 6.9682 | 9100.0 |
| 2010-02-09 04:45:00 | AAPL | Stock | 6.9961 | 6.9961 | 6.9961 | 6.9961 | 2800.0 |
| 2010-02-09 05:43:00 | AAPL | Stock | 6.9657 | 6.9657 | 6.9657 | 6.9657 | 14000.0 |
| 2010-02-09 06:25:00 | AAPL | Stock | 6.9793 | 6.9793 | 6.9793 | 6.9793 | 3640.0 |
| 2010-02-09 07:07:00 | AAPL | Stock | 6.9611 | 6.9611 | 6.9607 | 6.9607 | 5600.0 |
| 2010-02-09 07:10:00 | AAPL | Stock | 6.9679 | 6.9679 | 6.9679 | 6.9679 | 112392.0 |
| 2010-02-09 07:11:00 | AAPL | Stock | 6.9679 | 6.9679 | 6.9679 | 6.9679 | 55860.0 |
| 2010-02-09 07:12:00 | AAPL | Stock | 6.9714 | 6.9821 | 6.9714 | 6.9821 | 109508.0 |
| 2010-02-09 07:13:00 | AAPL | Stock | 6.9821 | 6.9821 | 6.9821 | 6.9821 | 13048.0 |
| 2010-02-09 07:14:00 | AAPL | Stock | 6.9846 | 6.9846 | 6.9786 | 6.9786 | 32200.0 |
| 2010-02-09 07:15:00 | AAPL | Stock | 6.9921 | 6.9921 | 6.9821 | 6.9854 | 94612.0 |
| 2010-02-09 07:16:00 | AAPL | Stock | 6.9854 | 6.9854 | 6.9854 | 6.9854 | 4200.0 |
| 2010-02-09 07:19:00 | AAPL | Stock | 6.9893 | 6.99 | 6.9893 | 6.99 | 8400.0 |
| 2010-02-09 07:20:00 | AAPL | Stock | 6.9911 | 6.9911 | 6.9907 | 6.9907 | 22596.0 |
| 2010-02-09 07:22:00 | AAPL | Stock | 6.99 | 6.99 | 6.99 | 6.99 | 2800.0 |
| 2010-02-09 07:25:00 | AAPL | Stock | 6.9911 | 6.9921 | 6.9911 | 6.9921 | 8400.0 |
| 2010-02-09 07:33:00 | AAPL | Stock | 6.9893 | 6.9893 | 6.9893 | 6.9893 | 28000.0 |
| 2010-02-09 07:35:00 | AAPL | Stock | 6.975 | 6.975 | 6.975 | 6.975 | 8400.0 |
| 2010-02-09 07:36:00 | AAPL | Stock | 6.9786 | 6.9786 | 6.9782 | 6.9782 | 28000.0 |
| 2010-02-09 07:37:00 | AAPL | Stock | 6.9782 | 6.9782 | 6.9782 | 6.9782 | 2800.0 |
| 2010-02-09 07:39:00 | AAPL | Stock | 6.9821 | 6.9825 | 6.9821 | 6.9825 | 5600.0 |
| 2010-02-09 07:40:00 | AAPL | Stock | 6.9882 | 6.9882 | 6.9868 | 6.9868 | 5600.0 |
| 2010-02-09 07:41:00 | AAPL | Stock | 6.9893 | 6.9925 | 6.9893 | 6.9925 | 16800.0 |
| 2010-02-09 07:42:00 | AAPL | Stock | 6.9871 | 6.9911 | 6.9868 | 6.9868 | 14000.0 |
| 2010-02-09 07:43:00 | AAPL | Stock | 6.9868 | 6.9868 | 6.9868 | 6.9868 | 11200.0 |
| 2010-02-09 07:44:00 | AAPL | Stock | 6.9868 | 6.99 | 6.9807 | 6.9807 | 19600.0 |
| 2010-02-09 07:45:00 | AAPL | Stock | 6.9889 | 6.9889 | 6.9889 | 6.9889 | 2800.0 |
| 2010-02-09 07:46:00 | AAPL | Stock | 6.9868 | 6.9889 | 6.9861 | 6.9864 | 16800.0 |
| 2010-02-09 07:47:00 | AAPL | Stock | 6.9886 | 6.9886 | 6.9886 | 6.9886 | 2800.0 |
| 2010-02-09 07:48:00 | AAPL | Stock | 6.9893 | 6.9893 | 6.9893 | 6.9893 | 8400.0 |
| 2010-02-09 07:49:00 | AAPL | Stock | 6.9864 | 6.9864 | 6.9864 | 6.9864 | 2800.0 |
| 2010-02-09 07:50:00 | AAPL | Stock | 6.9893 | 6.9893 | 6.9893 | 6.9893 | 2800.0 |
| 2010-02-09 07:51:00 | AAPL | Stock | 6.9868 | 6.9868 | 6.9864 | 6.9864 | 5600.0 |
| 2010-02-09 07:52:00 | AAPL | Stock | 6.9864 | 6.9864 | 6.9857 | 6.9857 | 32200.0 |
| 2010-02-09 07:54:00 | AAPL | Stock | 6.9857 | 6.9861 | 6.9857 | 6.9861 | 30800.0 |
| 2010-02-09 08:00:00 | AAPL | Stock | 6.9821 | 6.9864 | 6.9764 | 6.9864 | 147532.0 |
| 2010-02-09 08:01:00 | AAPL | Stock | 6.9871 | 6.9871 | 6.9786 | 6.9786 | 78988.0 |
| 2010-02-09 08:02:00 | AAPL | Stock | 6.9804 | 6.9814 | 6.9796 | 6.9814 | 16800.0 |
| 2010-02-09 08:03:00 | AAPL | Stock | 6.98 | 7.0 | 6.9796 | 7.0 | 323400.0 |
| 2010-02-09 08:04:00 | AAPL | Stock | 7.0 | 7.0 | 6.9954 | 6.9954 | 113680.0 |
| 2010-02-09 08:05:00 | AAPL | Stock | 6.9857 | 6.9946 | 6.9857 | 6.9946 | 198884.0 |
| 2010-02-09 08:06:00 | AAPL | Stock | 6.9946 | 6.9971 | 6.9946 | 6.9968 | 63000.0 |
| 2010-02-09 08:07:00 | AAPL | Stock | 6.9971 | 6.9982 | 6.9971 | 6.9982 | 22400.0 |
| 2010-02-09 08:08:00 | AAPL | Stock | 6.9993 | 7.0 | 6.9968 | 6.9968 | 38920.0 |
| 2010-02-09 08:09:00 | AAPL | Stock | 6.9968 | 6.9968 | 6.9964 | 6.9964 | 19320.0 |
| 2010-02-09 08:10:00 | AAPL | Stock | 6.9946 | 6.9968 | 6.9946 | 6.9964 | 98644.0 |
| 2010-02-09 08:11:00 | AAPL | Stock | 6.9946 | 6.9964 | 6.9946 | 6.9946 | 19600.0 |
| 2010-02-09 08:12:00 | AAPL | Stock | 6.9964 | 7.0018 | 6.9961 | 7.0004 | 118440.0 |
| 2010-02-09 08:13:00 | AAPL | Stock | 7.0021 | 7.0025 | 6.9975 | 6.9975 | 146244.0 |
| 2010-02-09 08:14:00 | AAPL | Stock | 7.0 | 7.0 | 7.0 | 7.0 | 2800.0 |
> showing 50 of 970,979 rows — these rows as CSV