PREVIEW / stock_1min / 2008-01-11
file: by_date/stock_1min/2008/2008-01-11.parquet size: 12.7 MB rows: 1,035,795 symbols: 2,664
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-01-11 06:57:00 | AAPL | Stock | 6.3036 | 6.3036 | 6.3036 | 6.3036 | 5600.0 |
| 2008-01-11 06:58:00 | AAPL | Stock | 6.3036 | 6.3036 | 6.3036 | 6.3036 | 5600.0 |
| 2008-01-11 07:02:00 | AAPL | Stock | 6.3036 | 6.3036 | 6.3036 | 6.3036 | 19600.0 |
| 2008-01-11 07:12:00 | AAPL | Stock | 6.3032 | 6.3032 | 6.3032 | 6.3032 | 16800.0 |
| 2008-01-11 07:13:00 | AAPL | Stock | 6.3032 | 6.3032 | 6.3032 | 6.3032 | 8400.0 |
| 2008-01-11 07:14:00 | AAPL | Stock | 6.2939 | 6.2939 | 6.2857 | 6.2857 | 14280.0 |
| 2008-01-11 07:19:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2857 | 6.2857 | 8708.0 |
| 2008-01-11 07:21:00 | AAPL | Stock | 6.2946 | 6.2946 | 6.2946 | 6.2946 | 56000.0 |
| 2008-01-11 07:22:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2857 | 6.2857 | 17080.0 |
| 2008-01-11 07:46:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2857 | 6.2857 | 5600.0 |
| 2008-01-11 07:47:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2854 | 6.2857 | 30800.0 |
| 2008-01-11 07:49:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2857 | 6.2857 | 8400.0 |
| 2008-01-11 07:50:00 | AAPL | Stock | 6.2929 | 6.2929 | 6.2929 | 6.2929 | 16800.0 |
| 2008-01-11 07:51:00 | AAPL | Stock | 6.2982 | 6.2982 | 6.2982 | 6.2982 | 4620.0 |
| 2008-01-11 07:52:00 | AAPL | Stock | 6.2982 | 6.3011 | 6.2982 | 6.3011 | 30800.0 |
| 2008-01-11 07:56:00 | AAPL | Stock | 6.3032 | 6.3171 | 6.3032 | 6.3171 | 19600.0 |
| 2008-01-11 07:57:00 | AAPL | Stock | 6.3089 | 6.3089 | 6.3089 | 6.3089 | 2800.0 |
| 2008-01-11 07:58:00 | AAPL | Stock | 6.3089 | 6.3089 | 6.3089 | 6.3089 | 2800.0 |
| 2008-01-11 07:59:00 | AAPL | Stock | 6.3168 | 6.3168 | 6.3168 | 6.3168 | 8400.0 |
| 2008-01-11 08:00:00 | AAPL | Stock | 6.3107 | 6.3107 | 6.2936 | 6.3018 | 155484.0 |
| 2008-01-11 08:01:00 | AAPL | Stock | 6.3 | 6.3 | 6.2857 | 6.2857 | 126812.0 |
| 2008-01-11 08:02:00 | AAPL | Stock | 6.2918 | 6.2918 | 6.28 | 6.28 | 276948.0 |
| 2008-01-11 08:03:00 | AAPL | Stock | 6.2854 | 6.2854 | 6.2786 | 6.2786 | 65800.0 |
| 2008-01-11 08:04:00 | AAPL | Stock | 6.2786 | 6.2861 | 6.2786 | 6.285 | 133168.0 |
| 2008-01-11 08:05:00 | AAPL | Stock | 6.2789 | 6.2846 | 6.2704 | 6.2771 | 194600.0 |
| 2008-01-11 08:06:00 | AAPL | Stock | 6.2732 | 6.2839 | 6.2732 | 6.2839 | 78680.0 |
| 2008-01-11 08:07:00 | AAPL | Stock | 6.28 | 6.28 | 6.2786 | 6.28 | 19600.0 |
| 2008-01-11 08:08:00 | AAPL | Stock | 6.28 | 6.2804 | 6.2732 | 6.2768 | 169064.0 |
| 2008-01-11 08:09:00 | AAPL | Stock | 6.2793 | 6.2857 | 6.2739 | 6.2775 | 207620.0 |
| 2008-01-11 08:10:00 | AAPL | Stock | 6.2775 | 6.2821 | 6.2775 | 6.2818 | 50400.0 |
| 2008-01-11 08:11:00 | AAPL | Stock | 6.2786 | 6.2821 | 6.2771 | 6.2771 | 132664.0 |
| 2008-01-11 08:12:00 | AAPL | Stock | 6.2786 | 6.2821 | 6.2771 | 6.2804 | 33264.0 |
| 2008-01-11 08:13:00 | AAPL | Stock | 6.2846 | 6.2857 | 6.2846 | 6.2857 | 33712.0 |
| 2008-01-11 08:14:00 | AAPL | Stock | 6.2864 | 6.2925 | 6.2864 | 6.2925 | 10612.0 |
| 2008-01-11 08:15:00 | AAPL | Stock | 6.2929 | 6.2929 | 6.2857 | 6.2857 | 126700.0 |
| 2008-01-11 08:16:00 | AAPL | Stock | 6.2843 | 6.2857 | 6.2843 | 6.2857 | 72828.0 |
| 2008-01-11 08:17:00 | AAPL | Stock | 6.2854 | 6.2857 | 6.2854 | 6.2857 | 98000.0 |
| 2008-01-11 08:18:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2829 | 6.2857 | 105028.0 |
| 2008-01-11 08:19:00 | AAPL | Stock | 6.2839 | 6.2857 | 6.2821 | 6.2857 | 54796.0 |
| 2008-01-11 08:20:00 | AAPL | Stock | 6.2807 | 6.2807 | 6.2771 | 6.2771 | 37800.0 |
| 2008-01-11 08:21:00 | AAPL | Stock | 6.2804 | 6.2821 | 6.2804 | 6.2821 | 26180.0 |
| 2008-01-11 08:22:00 | AAPL | Stock | 6.2821 | 6.2857 | 6.2771 | 6.2854 | 164808.0 |
| 2008-01-11 08:23:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2857 | 6.2857 | 89488.0 |
| 2008-01-11 08:24:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2857 | 6.2857 | 14000.0 |
| 2008-01-11 08:25:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2857 | 6.2857 | 39200.0 |
| 2008-01-11 08:26:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2821 | 6.2821 | 12264.0 |
| 2008-01-11 08:27:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2804 | 6.2804 | 35308.0 |
| 2008-01-11 08:28:00 | AAPL | Stock | 6.2804 | 6.2804 | 6.2804 | 6.2804 | 11620.0 |
| 2008-01-11 08:29:00 | AAPL | Stock | 6.2786 | 6.2786 | 6.2771 | 6.2771 | 84420.0 |
| 2008-01-11 08:30:00 | AAPL | Stock | 6.2771 | 6.2771 | 6.2714 | 6.2714 | 284676.0 |
> showing 50 of 1,035,795 rows — these rows as CSV