PREVIEW / stock_5min / 2005-05-10
file: by_date/stock_5min/2005/2005-05-10.parquet size: 2.7 MB rows: 197,095 symbols: 1,963
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-10 08:00:00 | AAPL | Stock | 1.3204 | 1.325 | 1.3196 | 1.3196 | 72800.0 |
| 2005-05-10 08:05:00 | AAPL | Stock | 1.3179 | 1.3179 | 1.3161 | 1.3161 | 89600.0 |
| 2005-05-10 08:15:00 | AAPL | Stock | 1.3161 | 1.3161 | 1.3161 | 1.3161 | 6160.0 |
| 2005-05-10 08:20:00 | AAPL | Stock | 1.3179 | 1.3179 | 1.3179 | 1.3179 | 8400.0 |
| 2005-05-10 08:25:00 | AAPL | Stock | 1.3179 | 1.3196 | 1.3179 | 1.3186 | 15400.0 |
| 2005-05-10 08:30:00 | AAPL | Stock | 1.3179 | 1.3182 | 1.3179 | 1.3182 | 33600.0 |
| 2005-05-10 08:35:00 | AAPL | Stock | 1.3175 | 1.3175 | 1.3175 | 1.3175 | 25200.0 |
| 2005-05-10 08:40:00 | AAPL | Stock | 1.3164 | 1.3164 | 1.3164 | 1.3164 | 2800.0 |
| 2005-05-10 08:45:00 | AAPL | Stock | 1.3164 | 1.3168 | 1.3164 | 1.3168 | 33600.0 |
| 2005-05-10 08:50:00 | AAPL | Stock | 1.3168 | 1.3168 | 1.3164 | 1.3164 | 16800.0 |
| 2005-05-10 08:55:00 | AAPL | Stock | 1.3164 | 1.3164 | 1.3164 | 1.3164 | 8400.0 |
| 2005-05-10 09:00:00 | AAPL | Stock | 1.3161 | 1.3164 | 1.3161 | 1.3164 | 22400.0 |
| 2005-05-10 09:05:00 | AAPL | Stock | 1.3154 | 1.3154 | 1.3143 | 1.3143 | 137200.0 |
| 2005-05-10 09:10:00 | AAPL | Stock | 1.3136 | 1.3136 | 1.3125 | 1.3132 | 146160.0 |
| 2005-05-10 09:15:00 | AAPL | Stock | 1.3132 | 1.3132 | 1.3132 | 1.3132 | 27440.0 |
| 2005-05-10 09:20:00 | AAPL | Stock | 1.3132 | 1.3139 | 1.3132 | 1.3139 | 22400.0 |
| 2005-05-10 09:25:00 | AAPL | Stock | 1.3139 | 1.3146 | 1.31 | 1.3125 | 1123612.0 |
| 2005-05-10 09:30:00 | AAPL | Stock | 1.3125 | 1.315 | 1.3096 | 1.3118 | 10407264.0 |
| 2005-05-10 09:35:00 | AAPL | Stock | 1.3121 | 1.3143 | 1.3111 | 1.3132 | 5745152.0 |
| 2005-05-10 09:40:00 | AAPL | Stock | 1.3136 | 1.3146 | 1.3118 | 1.3129 | 6243832.0 |
| 2005-05-10 09:45:00 | AAPL | Stock | 1.3129 | 1.3211 | 1.3125 | 1.3139 | 10437420.0 |
| 2005-05-10 09:50:00 | AAPL | Stock | 1.3139 | 1.3196 | 1.3129 | 1.3182 | 7063672.0 |
| 2005-05-10 09:55:00 | AAPL | Stock | 1.3179 | 1.3186 | 1.3146 | 1.3168 | 4360468.0 |
| 2005-05-10 10:00:00 | AAPL | Stock | 1.3164 | 1.3189 | 1.3146 | 1.3186 | 5827584.0 |
| 2005-05-10 10:05:00 | AAPL | Stock | 1.3182 | 1.3204 | 1.3143 | 1.3164 | 5247732.0 |
| 2005-05-10 10:10:00 | AAPL | Stock | 1.3161 | 1.3179 | 1.3154 | 1.3154 | 3801504.0 |
| 2005-05-10 10:15:00 | AAPL | Stock | 1.3154 | 1.3168 | 1.3136 | 1.3161 | 5157992.0 |
| 2005-05-10 10:20:00 | AAPL | Stock | 1.3157 | 1.3161 | 1.3118 | 1.3146 | 6795012.0 |
| 2005-05-10 10:25:00 | AAPL | Stock | 1.3146 | 1.3171 | 1.3143 | 1.3157 | 4145232.0 |
| 2005-05-10 10:30:00 | AAPL | Stock | 1.3154 | 1.3161 | 1.3139 | 1.315 | 4108104.0 |
| 2005-05-10 10:35:00 | AAPL | Stock | 1.3154 | 1.3154 | 1.3136 | 1.3139 | 1724632.0 |
| 2005-05-10 10:40:00 | AAPL | Stock | 1.3139 | 1.315 | 1.3111 | 1.3146 | 4227384.0 |
| 2005-05-10 10:45:00 | AAPL | Stock | 1.3146 | 1.3154 | 1.3136 | 1.315 | 1990184.0 |
| 2005-05-10 10:50:00 | AAPL | Stock | 1.315 | 1.3154 | 1.3143 | 1.3146 | 1583344.0 |
| 2005-05-10 10:55:00 | AAPL | Stock | 1.315 | 1.3179 | 1.3146 | 1.3179 | 3392704.0 |
| 2005-05-10 11:00:00 | AAPL | Stock | 1.3175 | 1.3186 | 1.3157 | 1.3171 | 3926048.0 |
| 2005-05-10 11:05:00 | AAPL | Stock | 1.3175 | 1.32 | 1.3168 | 1.3186 | 3364424.0 |
| 2005-05-10 11:10:00 | AAPL | Stock | 1.3189 | 1.32 | 1.3186 | 1.3196 | 2165380.0 |
| 2005-05-10 11:15:00 | AAPL | Stock | 1.3196 | 1.3229 | 1.3196 | 1.3211 | 5475512.0 |
| 2005-05-10 11:20:00 | AAPL | Stock | 1.3211 | 1.3243 | 1.3207 | 1.3232 | 5232556.0 |
| 2005-05-10 11:25:00 | AAPL | Stock | 1.3232 | 1.3236 | 1.3189 | 1.3196 | 3284512.0 |
| 2005-05-10 11:30:00 | AAPL | Stock | 1.3196 | 1.3211 | 1.3193 | 1.3207 | 1247092.0 |
| 2005-05-10 11:35:00 | AAPL | Stock | 1.3211 | 1.3225 | 1.3204 | 1.3221 | 1202124.0 |
| 2005-05-10 11:40:00 | AAPL | Stock | 1.3225 | 1.3227 | 1.3204 | 1.3204 | 1163932.0 |
| 2005-05-10 11:45:00 | AAPL | Stock | 1.3207 | 1.3207 | 1.3171 | 1.3179 | 3151988.0 |
| 2005-05-10 11:50:00 | AAPL | Stock | 1.3179 | 1.3189 | 1.3154 | 1.3168 | 6031116.0 |
| 2005-05-10 11:55:00 | AAPL | Stock | 1.3168 | 1.3175 | 1.3161 | 1.3171 | 3703476.0 |
| 2005-05-10 12:00:00 | AAPL | Stock | 1.3171 | 1.3214 | 1.3168 | 1.3207 | 3627624.0 |
| 2005-05-10 12:05:00 | AAPL | Stock | 1.3207 | 1.3214 | 1.3193 | 1.32 | 2624440.0 |
| 2005-05-10 12:10:00 | AAPL | Stock | 1.3211 | 1.3218 | 1.32 | 1.32 | 1645168.0 |
> showing 50 of 197,095 rows — these rows as CSV