PREVIEW / stock_1min / 2005-01-28
file: by_date/stock_1min/2005/2005-01-28.parquet size: 6.4 MB rows: 536,377 symbols: 1,578
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-28 08:00:00 | AAPL | Stock | 1.2975 | 1.2975 | 1.2973 | 1.2973 | 22400.0 |
| 2005-01-28 08:01:00 | AAPL | Stock | 1.2973 | 1.2973 | 1.2946 | 1.2973 | 114800.0 |
| 2005-01-28 08:20:00 | AAPL | Stock | 1.2975 | 1.2975 | 1.2975 | 1.2975 | 16800.0 |
| 2005-01-28 08:26:00 | AAPL | Stock | 1.2968 | 1.2968 | 1.2964 | 1.2964 | 62272.0 |
| 2005-01-28 08:27:00 | AAPL | Stock | 1.2964 | 1.2964 | 1.2964 | 1.2964 | 33600.0 |
| 2005-01-28 08:28:00 | AAPL | Stock | 1.2964 | 1.2964 | 1.2946 | 1.2946 | 83328.0 |
| 2005-01-28 08:29:00 | AAPL | Stock | 1.2973 | 1.2973 | 1.2973 | 1.2973 | 33992.0 |
| 2005-01-28 08:30:00 | AAPL | Stock | 1.2946 | 1.2954 | 1.2946 | 1.2952 | 74144.0 |
| 2005-01-28 08:31:00 | AAPL | Stock | 1.2946 | 1.2946 | 1.2946 | 1.2946 | 24920.0 |
| 2005-01-28 08:36:00 | AAPL | Stock | 1.2948 | 1.2948 | 1.2948 | 1.2948 | 16800.0 |
| 2005-01-28 08:37:00 | AAPL | Stock | 1.2948 | 1.2948 | 1.2948 | 1.2948 | 7840.0 |
| 2005-01-28 08:41:00 | AAPL | Stock | 1.2963 | 1.2973 | 1.2963 | 1.2973 | 84000.0 |
| 2005-01-28 08:51:00 | AAPL | Stock | 1.2964 | 1.297 | 1.2964 | 1.297 | 28000.0 |
| 2005-01-28 09:01:00 | AAPL | Stock | 1.2964 | 1.2964 | 1.2964 | 1.2964 | 38920.0 |
| 2005-01-28 09:09:00 | AAPL | Stock | 1.2955 | 1.2955 | 1.2955 | 1.2955 | 5600.0 |
| 2005-01-28 09:17:00 | AAPL | Stock | 1.2955 | 1.2955 | 1.2955 | 1.2955 | 55888.0 |
| 2005-01-28 09:18:00 | AAPL | Stock | 1.2964 | 1.2964 | 1.2959 | 1.2963 | 33600.0 |
| 2005-01-28 09:19:00 | AAPL | Stock | 1.2964 | 1.2964 | 1.2964 | 1.2964 | 156800.0 |
| 2005-01-28 09:20:00 | AAPL | Stock | 1.297 | 1.2973 | 1.297 | 1.2973 | 31920.0 |
| 2005-01-28 09:23:00 | AAPL | Stock | 1.2964 | 1.2964 | 1.2964 | 1.2964 | 5600.0 |
| 2005-01-28 09:25:00 | AAPL | Stock | 1.2964 | 1.2964 | 1.2964 | 1.2964 | 56000.0 |
| 2005-01-28 09:27:00 | AAPL | Stock | 1.2979 | 1.2979 | 1.2954 | 1.2954 | 89600.0 |
| 2005-01-28 09:28:00 | AAPL | Stock | 1.2982 | 1.2998 | 1.2979 | 1.2998 | 321384.0 |
| 2005-01-28 09:29:00 | AAPL | Stock | 1.2998 | 1.3002 | 1.2946 | 1.2966 | 1210664.0 |
| 2005-01-28 09:30:00 | AAPL | Stock | 1.2968 | 1.2995 | 1.2936 | 1.298 | 5689376.0 |
| 2005-01-28 09:31:00 | AAPL | Stock | 1.2979 | 1.2988 | 1.2964 | 1.2975 | 1356376.0 |
| 2005-01-28 09:32:00 | AAPL | Stock | 1.2975 | 1.298 | 1.2936 | 1.298 | 3072160.0 |
| 2005-01-28 09:33:00 | AAPL | Stock | 1.2971 | 1.2982 | 1.2964 | 1.2971 | 1477336.0 |
| 2005-01-28 09:34:00 | AAPL | Stock | 1.2982 | 1.2982 | 1.295 | 1.2955 | 1068928.0 |
| 2005-01-28 09:35:00 | AAPL | Stock | 1.2955 | 1.2982 | 1.2936 | 1.2948 | 3737328.0 |
| 2005-01-28 09:36:00 | AAPL | Stock | 1.295 | 1.3009 | 1.295 | 1.3002 | 4629128.0 |
| 2005-01-28 09:37:00 | AAPL | Stock | 1.3007 | 1.3034 | 1.2991 | 1.3011 | 3885392.0 |
| 2005-01-28 09:38:00 | AAPL | Stock | 1.3011 | 1.3016 | 1.2995 | 1.3004 | 2676408.0 |
| 2005-01-28 09:39:00 | AAPL | Stock | 1.3004 | 1.3052 | 1.3 | 1.3038 | 8443680.0 |
| 2005-01-28 09:40:00 | AAPL | Stock | 1.3041 | 1.3075 | 1.3036 | 1.3063 | 6961416.0 |
| 2005-01-28 09:41:00 | AAPL | Stock | 1.3061 | 1.3063 | 1.3045 | 1.3057 | 3164840.0 |
| 2005-01-28 09:42:00 | AAPL | Stock | 1.3059 | 1.3068 | 1.3023 | 1.3041 | 2719248.0 |
| 2005-01-28 09:43:00 | AAPL | Stock | 1.3043 | 1.3064 | 1.3034 | 1.3064 | 2916592.0 |
| 2005-01-28 09:44:00 | AAPL | Stock | 1.3063 | 1.307 | 1.3039 | 1.305 | 2724848.0 |
| 2005-01-28 09:45:00 | AAPL | Stock | 1.3048 | 1.3052 | 1.3004 | 1.3011 | 4975320.0 |
| 2005-01-28 09:46:00 | AAPL | Stock | 1.3014 | 1.3027 | 1.3004 | 1.302 | 2293592.0 |
| 2005-01-28 09:47:00 | AAPL | Stock | 1.3018 | 1.3066 | 1.3018 | 1.3066 | 4824568.0 |
| 2005-01-28 09:48:00 | AAPL | Stock | 1.3066 | 1.3071 | 1.3054 | 1.3068 | 5310760.0 |
| 2005-01-28 09:49:00 | AAPL | Stock | 1.3068 | 1.3089 | 1.305 | 1.3089 | 4775400.0 |
| 2005-01-28 09:50:00 | AAPL | Stock | 1.3089 | 1.3105 | 1.3071 | 1.3093 | 4608576.0 |
| 2005-01-28 09:51:00 | AAPL | Stock | 1.3091 | 1.3102 | 1.3071 | 1.3089 | 4166120.0 |
| 2005-01-28 09:52:00 | AAPL | Stock | 1.3084 | 1.3098 | 1.3077 | 1.3089 | 2368240.0 |
| 2005-01-28 09:53:00 | AAPL | Stock | 1.3082 | 1.3089 | 1.3063 | 1.3066 | 4599840.0 |
| 2005-01-28 09:54:00 | AAPL | Stock | 1.3066 | 1.3102 | 1.3064 | 1.3098 | 3002160.0 |
| 2005-01-28 09:55:00 | AAPL | Stock | 1.3096 | 1.3113 | 1.3096 | 1.31 | 3947328.0 |
> showing 50 of 536,377 rows — these rows as CSV