PREVIEW / stock_5min / 2002-07-01
file: by_date/stock_5min/2002/2002-07-01.parquet size: 2.0 MB rows: 141,693 symbols: 1,447
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 |
|---|---|---|---|---|---|---|---|
| 2002-07-01 08:00:00 | AAPL | Stock | 0.3143 | 0.3143 | 0.3105 | 0.3141 | 78400.0 |
| 2002-07-01 08:05:00 | AAPL | Stock | 0.3155 | 0.3159 | 0.3155 | 0.3159 | 39200.0 |
| 2002-07-01 08:10:00 | AAPL | Stock | 0.3143 | 0.3143 | 0.3143 | 0.3143 | 56000.0 |
| 2002-07-01 08:15:00 | AAPL | Stock | 0.3152 | 0.3152 | 0.3143 | 0.3143 | 33600.0 |
| 2002-07-01 08:25:00 | AAPL | Stock | 0.3143 | 0.3143 | 0.3143 | 0.3143 | 56000.0 |
| 2002-07-01 08:30:00 | AAPL | Stock | 0.3152 | 0.3161 | 0.3143 | 0.3143 | 649600.0 |
| 2002-07-01 08:40:00 | AAPL | Stock | 0.3152 | 0.3152 | 0.3152 | 0.3152 | 280000.0 |
| 2002-07-01 08:50:00 | AAPL | Stock | 0.3164 | 0.3164 | 0.315 | 0.315 | 795200.0 |
| 2002-07-01 08:55:00 | AAPL | Stock | 0.3161 | 0.3161 | 0.3161 | 0.3161 | 11200.0 |
| 2002-07-01 09:00:00 | AAPL | Stock | 0.3164 | 0.3164 | 0.3164 | 0.3164 | 616000.0 |
| 2002-07-01 09:05:00 | AAPL | Stock | 0.3166 | 0.3166 | 0.3161 | 0.3164 | 2223200.0 |
| 2002-07-01 09:10:00 | AAPL | Stock | 0.317 | 0.317 | 0.317 | 0.317 | 61600.0 |
| 2002-07-01 09:15:00 | AAPL | Stock | 0.3186 | 0.3186 | 0.3164 | 0.3171 | 358400.0 |
| 2002-07-01 09:20:00 | AAPL | Stock | 0.3156 | 0.3163 | 0.3155 | 0.3163 | 100800.0 |
| 2002-07-01 09:25:00 | AAPL | Stock | 0.3157 | 0.3163 | 0.3157 | 0.3157 | 308000.0 |
| 2002-07-01 09:30:00 | AAPL | Stock | 0.3163 | 0.3193 | 0.3157 | 0.3166 | 8635200.0 |
| 2002-07-01 09:35:00 | AAPL | Stock | 0.3166 | 0.3175 | 0.3161 | 0.3166 | 3472000.0 |
| 2002-07-01 09:40:00 | AAPL | Stock | 0.3166 | 0.3171 | 0.3148 | 0.3157 | 2660000.0 |
| 2002-07-01 09:45:00 | AAPL | Stock | 0.3157 | 0.3184 | 0.3157 | 0.3173 | 2800000.0 |
| 2002-07-01 09:50:00 | AAPL | Stock | 0.3171 | 0.3177 | 0.3145 | 0.3152 | 1680000.0 |
| 2002-07-01 09:55:00 | AAPL | Stock | 0.3154 | 0.3166 | 0.3134 | 0.3143 | 1993600.0 |
| 2002-07-01 10:00:00 | AAPL | Stock | 0.3132 | 0.3157 | 0.3116 | 0.3116 | 2727200.0 |
| 2002-07-01 10:05:00 | AAPL | Stock | 0.3114 | 0.3114 | 0.3082 | 0.3102 | 3332000.0 |
| 2002-07-01 10:10:00 | AAPL | Stock | 0.3107 | 0.313 | 0.3105 | 0.3125 | 1685600.0 |
| 2002-07-01 10:15:00 | AAPL | Stock | 0.3121 | 0.3138 | 0.3104 | 0.3136 | 2307200.0 |
| 2002-07-01 10:20:00 | AAPL | Stock | 0.3132 | 0.3138 | 0.3123 | 0.3132 | 1551200.0 |
| 2002-07-01 10:25:00 | AAPL | Stock | 0.3138 | 0.3138 | 0.3116 | 0.3116 | 1052800.0 |
| 2002-07-01 10:30:00 | AAPL | Stock | 0.3114 | 0.3123 | 0.31 | 0.312 | 1528800.0 |
| 2002-07-01 10:35:00 | AAPL | Stock | 0.3118 | 0.3136 | 0.3118 | 0.312 | 1512000.0 |
| 2002-07-01 10:40:00 | AAPL | Stock | 0.312 | 0.3125 | 0.3093 | 0.3093 | 2447200.0 |
| 2002-07-01 10:45:00 | AAPL | Stock | 0.3093 | 0.3096 | 0.3089 | 0.3096 | 1948800.0 |
| 2002-07-01 10:50:00 | AAPL | Stock | 0.3096 | 0.3114 | 0.3091 | 0.3112 | 3595200.0 |
| 2002-07-01 10:55:00 | AAPL | Stock | 0.3105 | 0.3105 | 0.3091 | 0.3093 | 1125600.0 |
| 2002-07-01 11:00:00 | AAPL | Stock | 0.3095 | 0.31 | 0.308 | 0.3091 | 2766400.0 |
| 2002-07-01 11:05:00 | AAPL | Stock | 0.3092 | 0.3093 | 0.3079 | 0.3089 | 1887200.0 |
| 2002-07-01 11:10:00 | AAPL | Stock | 0.3089 | 0.3098 | 0.308 | 0.3095 | 1573600.0 |
| 2002-07-01 11:15:00 | AAPL | Stock | 0.3095 | 0.31 | 0.308 | 0.3089 | 2430400.0 |
| 2002-07-01 11:20:00 | AAPL | Stock | 0.3091 | 0.3091 | 0.3073 | 0.3077 | 2296000.0 |
| 2002-07-01 11:25:00 | AAPL | Stock | 0.3079 | 0.31 | 0.3079 | 0.31 | 1215200.0 |
| 2002-07-01 11:30:00 | AAPL | Stock | 0.3096 | 0.3104 | 0.3084 | 0.3088 | 862400.0 |
| 2002-07-01 11:35:00 | AAPL | Stock | 0.3088 | 0.3089 | 0.3084 | 0.3086 | 1691200.0 |
| 2002-07-01 11:40:00 | AAPL | Stock | 0.3086 | 0.3088 | 0.3075 | 0.3082 | 1640800.0 |
| 2002-07-01 11:45:00 | AAPL | Stock | 0.308 | 0.3082 | 0.3073 | 0.3079 | 3511200.0 |
| 2002-07-01 11:50:00 | AAPL | Stock | 0.3082 | 0.3095 | 0.3082 | 0.3093 | 1775200.0 |
| 2002-07-01 11:55:00 | AAPL | Stock | 0.3093 | 0.31 | 0.3075 | 0.3075 | 2772000.0 |
| 2002-07-01 12:00:00 | AAPL | Stock | 0.3075 | 0.3082 | 0.3064 | 0.3073 | 3108000.0 |
| 2002-07-01 12:05:00 | AAPL | Stock | 0.3073 | 0.3095 | 0.3073 | 0.3091 | 1500800.0 |
| 2002-07-01 12:10:00 | AAPL | Stock | 0.3091 | 0.3091 | 0.3073 | 0.3077 | 1366400.0 |
| 2002-07-01 12:15:00 | AAPL | Stock | 0.3075 | 0.3082 | 0.3068 | 0.3082 | 2150400.0 |
| 2002-07-01 12:20:00 | AAPL | Stock | 0.308 | 0.3084 | 0.3077 | 0.3077 | 1276800.0 |
> showing 50 of 141,693 rows — these rows as CSV