PREVIEW / stock_5min / 2005-05-04
file: by_date/stock_5min/2005/2005-05-04.parquet size: 2.7 MB rows: 197,286 symbols: 1,969
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-05-04 08:00:00 | AAPL | Stock | 1.2964 | 1.2964 | 1.2957 | 1.2957 | 408800.0 |
| 2005-05-04 08:05:00 | AAPL | Stock | 1.2911 | 1.2911 | 1.2911 | 1.2911 | 14000.0 |
| 2005-05-04 08:10:00 | AAPL | Stock | 1.2929 | 1.2946 | 1.2929 | 1.2946 | 42000.0 |
| 2005-05-04 08:20:00 | AAPL | Stock | 1.2979 | 1.2979 | 1.2929 | 1.2946 | 12320.0 |
| 2005-05-04 08:25:00 | AAPL | Stock | 1.2929 | 1.2946 | 1.2929 | 1.2946 | 33740.0 |
| 2005-05-04 08:30:00 | AAPL | Stock | 1.2946 | 1.2946 | 1.2936 | 1.2936 | 19740.0 |
| 2005-05-04 08:35:00 | AAPL | Stock | 1.2946 | 1.2946 | 1.2946 | 1.2946 | 19460.0 |
| 2005-05-04 08:40:00 | AAPL | Stock | 1.2946 | 1.295 | 1.2911 | 1.2911 | 462896.0 |
| 2005-05-04 08:45:00 | AAPL | Stock | 1.2918 | 1.2918 | 1.2911 | 1.2911 | 112000.0 |
| 2005-05-04 08:50:00 | AAPL | Stock | 1.2911 | 1.2918 | 1.2911 | 1.2914 | 154000.0 |
| 2005-05-04 08:55:00 | AAPL | Stock | 1.2918 | 1.2943 | 1.2918 | 1.2943 | 51016.0 |
| 2005-05-04 09:05:00 | AAPL | Stock | 1.2936 | 1.2946 | 1.2936 | 1.2946 | 123312.0 |
| 2005-05-04 09:10:00 | AAPL | Stock | 1.2946 | 1.2946 | 1.2936 | 1.2936 | 41384.0 |
| 2005-05-04 09:15:00 | AAPL | Stock | 1.2939 | 1.2943 | 1.2939 | 1.2943 | 11340.0 |
| 2005-05-04 09:20:00 | AAPL | Stock | 1.2939 | 1.2939 | 1.2936 | 1.2939 | 16800.0 |
| 2005-05-04 09:25:00 | AAPL | Stock | 1.2946 | 1.2975 | 1.2889 | 1.2964 | 411684.0 |
| 2005-05-04 09:30:00 | AAPL | Stock | 1.2896 | 1.3018 | 1.2893 | 1.2986 | 13736268.0 |
| 2005-05-04 09:35:00 | AAPL | Stock | 1.2986 | 1.3114 | 1.2957 | 1.3114 | 14711816.0 |
| 2005-05-04 09:40:00 | AAPL | Stock | 1.3107 | 1.3125 | 1.3029 | 1.3118 | 19137888.0 |
| 2005-05-04 09:45:00 | AAPL | Stock | 1.3118 | 1.3125 | 1.3039 | 1.3043 | 8410164.0 |
| 2005-05-04 09:50:00 | AAPL | Stock | 1.3046 | 1.3093 | 1.3043 | 1.3057 | 5754000.0 |
| 2005-05-04 09:55:00 | AAPL | Stock | 1.3057 | 1.3082 | 1.3054 | 1.3075 | 4119668.0 |
| 2005-05-04 10:00:00 | AAPL | Stock | 1.3071 | 1.3118 | 1.3043 | 1.3086 | 8574916.0 |
| 2005-05-04 10:05:00 | AAPL | Stock | 1.3082 | 1.31 | 1.3072 | 1.3089 | 2554160.0 |
| 2005-05-04 10:10:00 | AAPL | Stock | 1.3089 | 1.3111 | 1.3075 | 1.3107 | 7964320.0 |
| 2005-05-04 10:15:00 | AAPL | Stock | 1.3104 | 1.3104 | 1.3064 | 1.3068 | 4353832.0 |
| 2005-05-04 10:20:00 | AAPL | Stock | 1.3064 | 1.3107 | 1.3061 | 1.3104 | 2720200.0 |
| 2005-05-04 10:25:00 | AAPL | Stock | 1.31 | 1.3121 | 1.3082 | 1.31 | 5386248.0 |
| 2005-05-04 10:30:00 | AAPL | Stock | 1.31 | 1.3154 | 1.3071 | 1.3146 | 20426476.0 |
| 2005-05-04 10:35:00 | AAPL | Stock | 1.3143 | 1.3186 | 1.3114 | 1.3164 | 14499464.0 |
| 2005-05-04 10:40:00 | AAPL | Stock | 1.3164 | 1.3164 | 1.3136 | 1.3146 | 6831972.0 |
| 2005-05-04 10:45:00 | AAPL | Stock | 1.3143 | 1.3157 | 1.3129 | 1.3129 | 5552148.0 |
| 2005-05-04 10:50:00 | AAPL | Stock | 1.3129 | 1.3143 | 1.3111 | 1.3136 | 5535600.0 |
| 2005-05-04 10:55:00 | AAPL | Stock | 1.3132 | 1.3161 | 1.3125 | 1.3143 | 6006868.0 |
| 2005-05-04 11:00:00 | AAPL | Stock | 1.3139 | 1.3154 | 1.3139 | 1.315 | 4220468.0 |
| 2005-05-04 11:05:00 | AAPL | Stock | 1.315 | 1.3168 | 1.3146 | 1.315 | 2469656.0 |
| 2005-05-04 11:10:00 | AAPL | Stock | 1.3151 | 1.3161 | 1.3143 | 1.315 | 4591356.0 |
| 2005-05-04 11:15:00 | AAPL | Stock | 1.315 | 1.3154 | 1.3143 | 1.3146 | 3072188.0 |
| 2005-05-04 11:20:00 | AAPL | Stock | 1.3143 | 1.3143 | 1.3125 | 1.3143 | 3948000.0 |
| 2005-05-04 11:25:00 | AAPL | Stock | 1.3143 | 1.3164 | 1.3142 | 1.315 | 3685556.0 |
| 2005-05-04 11:30:00 | AAPL | Stock | 1.3154 | 1.3168 | 1.3143 | 1.315 | 3435824.0 |
| 2005-05-04 11:35:00 | AAPL | Stock | 1.3146 | 1.3161 | 1.3143 | 1.315 | 2605624.0 |
| 2005-05-04 11:40:00 | AAPL | Stock | 1.315 | 1.3168 | 1.315 | 1.3157 | 2470664.0 |
| 2005-05-04 11:45:00 | AAPL | Stock | 1.3161 | 1.3189 | 1.3157 | 1.3171 | 6385988.0 |
| 2005-05-04 11:50:00 | AAPL | Stock | 1.3168 | 1.3171 | 1.3143 | 1.3143 | 4412548.0 |
| 2005-05-04 11:55:00 | AAPL | Stock | 1.3143 | 1.3161 | 1.3118 | 1.3136 | 7685636.0 |
| 2005-05-04 12:00:00 | AAPL | Stock | 1.3136 | 1.3139 | 1.3089 | 1.3093 | 3557092.0 |
| 2005-05-04 12:05:00 | AAPL | Stock | 1.3096 | 1.3132 | 1.3096 | 1.3111 | 5354664.0 |
| 2005-05-04 12:10:00 | AAPL | Stock | 1.3107 | 1.3125 | 1.3093 | 1.3118 | 13693120.0 |
| 2005-05-04 12:15:00 | AAPL | Stock | 1.3114 | 1.3125 | 1.3104 | 1.3111 | 2243948.0 |
> showing 50 of 197,286 rows — these rows as CSV