PREVIEW / stock_1min / 2009-01-28
file: by_date/stock_1min/2009/2009-01-28.parquet size: 12.2 MB rows: 949,627 symbols: 2,687
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 |
|---|---|---|---|---|---|---|---|
| 2009-01-28 04:15:00 | AAPL | Stock | 3.2661 | 3.2661 | 3.2661 | 3.2661 | 2800.0 |
| 2009-01-28 04:17:00 | AAPL | Stock | 3.2661 | 3.2661 | 3.2661 | 3.2661 | 14000.0 |
| 2009-01-28 04:21:00 | AAPL | Stock | 3.2661 | 3.2661 | 3.2661 | 3.2661 | 14000.0 |
| 2009-01-28 04:34:00 | AAPL | Stock | 3.2661 | 3.2661 | 3.2661 | 3.2661 | 5600.0 |
| 2009-01-28 04:36:00 | AAPL | Stock | 3.2661 | 3.2661 | 3.2661 | 3.2661 | 14000.0 |
| 2009-01-28 04:38:00 | AAPL | Stock | 3.2661 | 3.2661 | 3.2661 | 3.2661 | 2800.0 |
| 2009-01-28 04:42:00 | AAPL | Stock | 3.2661 | 3.2661 | 3.2661 | 3.2661 | 2800.0 |
| 2009-01-28 06:38:00 | AAPL | Stock | 3.2768 | 3.2768 | 3.2768 | 3.2768 | 84000.0 |
| 2009-01-28 06:51:00 | AAPL | Stock | 3.2893 | 3.2911 | 3.2807 | 3.2807 | 25200.0 |
| 2009-01-28 06:58:00 | AAPL | Stock | 3.2954 | 3.2954 | 3.2954 | 3.2954 | 28000.0 |
| 2009-01-28 07:06:00 | AAPL | Stock | 3.2857 | 3.2857 | 3.2857 | 3.2857 | 2800.0 |
| 2009-01-28 07:07:00 | AAPL | Stock | 3.2857 | 3.2857 | 3.2857 | 3.2857 | 25200.0 |
| 2009-01-28 07:09:00 | AAPL | Stock | 3.2857 | 3.2857 | 3.2857 | 3.2857 | 2800.0 |
| 2009-01-28 07:13:00 | AAPL | Stock | 3.3 | 3.3 | 3.3 | 3.3 | 11200.0 |
| 2009-01-28 07:14:00 | AAPL | Stock | 3.2961 | 3.2961 | 3.2961 | 3.2961 | 2800.0 |
| 2009-01-28 07:15:00 | AAPL | Stock | 3.2961 | 3.2961 | 3.2946 | 3.2946 | 70560.0 |
| 2009-01-28 07:16:00 | AAPL | Stock | 3.2946 | 3.2946 | 3.2946 | 3.2946 | 7924.0 |
| 2009-01-28 07:18:00 | AAPL | Stock | 3.2946 | 3.2946 | 3.2946 | 3.2946 | 58716.0 |
| 2009-01-28 07:24:00 | AAPL | Stock | 3.2925 | 3.2946 | 3.2925 | 3.2946 | 14000.0 |
| 2009-01-28 07:29:00 | AAPL | Stock | 3.2946 | 3.2946 | 3.2946 | 3.2946 | 42000.0 |
| 2009-01-28 07:35:00 | AAPL | Stock | 3.2857 | 3.2857 | 3.2857 | 3.2857 | 14000.0 |
| 2009-01-28 07:43:00 | AAPL | Stock | 3.2821 | 3.2821 | 3.2821 | 3.2821 | 7560.0 |
| 2009-01-28 07:48:00 | AAPL | Stock | 3.2857 | 3.2857 | 3.2857 | 3.2857 | 25200.0 |
| 2009-01-28 07:54:00 | AAPL | Stock | 3.2946 | 3.2946 | 3.2946 | 3.2946 | 5600.0 |
| 2009-01-28 07:57:00 | AAPL | Stock | 3.2861 | 3.2946 | 3.2857 | 3.2946 | 27384.0 |
| 2009-01-28 07:58:00 | AAPL | Stock | 3.3125 | 3.3125 | 3.3036 | 3.3036 | 56000.0 |
| 2009-01-28 07:59:00 | AAPL | Stock | 3.3121 | 3.3121 | 3.3036 | 3.3121 | 69132.0 |
| 2009-01-28 08:00:00 | AAPL | Stock | 3.3039 | 3.3039 | 3.2857 | 3.2975 | 151900.0 |
| 2009-01-28 08:01:00 | AAPL | Stock | 3.3029 | 3.3036 | 3.3 | 3.3 | 20440.0 |
| 2009-01-28 08:02:00 | AAPL | Stock | 3.3025 | 3.3036 | 3.3025 | 3.3036 | 55524.0 |
| 2009-01-28 08:03:00 | AAPL | Stock | 3.3036 | 3.3036 | 3.3 | 3.3 | 38892.0 |
| 2009-01-28 08:04:00 | AAPL | Stock | 3.2975 | 3.3036 | 3.2964 | 3.3036 | 125048.0 |
| 2009-01-28 08:05:00 | AAPL | Stock | 3.3036 | 3.3071 | 3.3036 | 3.3071 | 93800.0 |
| 2009-01-28 08:06:00 | AAPL | Stock | 3.3071 | 3.3093 | 3.3071 | 3.3071 | 70000.0 |
| 2009-01-28 08:07:00 | AAPL | Stock | 3.3071 | 3.3093 | 3.3071 | 3.3093 | 28000.0 |
| 2009-01-28 08:08:00 | AAPL | Stock | 3.3096 | 3.31 | 3.3036 | 3.3096 | 148764.0 |
| 2009-01-28 08:09:00 | AAPL | Stock | 3.3121 | 3.3139 | 3.3107 | 3.3139 | 292712.0 |
| 2009-01-28 08:10:00 | AAPL | Stock | 3.3125 | 3.3139 | 3.3107 | 3.3139 | 58716.0 |
| 2009-01-28 08:11:00 | AAPL | Stock | 3.3139 | 3.3139 | 3.3139 | 3.3139 | 8400.0 |
| 2009-01-28 08:12:00 | AAPL | Stock | 3.3125 | 3.3125 | 3.3125 | 3.3125 | 2800.0 |
| 2009-01-28 08:13:00 | AAPL | Stock | 3.3079 | 3.3079 | 3.3079 | 3.3079 | 4200.0 |
| 2009-01-28 08:15:00 | AAPL | Stock | 3.3079 | 3.3104 | 3.3071 | 3.3104 | 14756.0 |
| 2009-01-28 08:16:00 | AAPL | Stock | 3.3075 | 3.3075 | 3.3071 | 3.3071 | 28000.0 |
| 2009-01-28 08:18:00 | AAPL | Stock | 3.3125 | 3.3125 | 3.3125 | 3.3125 | 11200.0 |
| 2009-01-28 08:19:00 | AAPL | Stock | 3.3107 | 3.3107 | 3.3093 | 3.3107 | 41300.0 |
| 2009-01-28 08:20:00 | AAPL | Stock | 3.3121 | 3.3125 | 3.3086 | 3.3086 | 28784.0 |
| 2009-01-28 08:21:00 | AAPL | Stock | 3.3107 | 3.3107 | 3.3107 | 3.3107 | 26600.0 |
| 2009-01-28 08:22:00 | AAPL | Stock | 3.3089 | 3.3089 | 3.3089 | 3.3089 | 14000.0 |
| 2009-01-28 08:23:00 | AAPL | Stock | 3.3107 | 3.3107 | 3.3089 | 3.3089 | 14280.0 |
| 2009-01-28 08:24:00 | AAPL | Stock | 3.3089 | 3.3107 | 3.3089 | 3.3107 | 15400.0 |
> showing 50 of 949,627 rows — these rows as CSV