PREVIEW / stock_1min / 2008-11-12
file: by_date/stock_1min/2008/2008-11-12.parquet size: 12.4 MB rows: 993,559 symbols: 2,692
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-12 07:47:00 | AAPL | Stock | 3.3821 | 3.3821 | 3.3821 | 3.3821 | 2800.0 |
| 2008-11-12 08:00:00 | AAPL | Stock | 3.3825 | 3.3918 | 3.3714 | 3.3714 | 16968.0 |
| 2008-11-12 08:01:00 | AAPL | Stock | 3.3857 | 3.3857 | 3.3693 | 3.3693 | 14000.0 |
| 2008-11-12 08:02:00 | AAPL | Stock | 3.3714 | 3.3714 | 3.3654 | 3.3654 | 84000.0 |
| 2008-11-12 08:03:00 | AAPL | Stock | 3.3661 | 3.3679 | 3.3625 | 3.3625 | 50400.0 |
| 2008-11-12 08:04:00 | AAPL | Stock | 3.3607 | 3.3607 | 3.3464 | 3.3464 | 208012.0 |
| 2008-11-12 08:05:00 | AAPL | Stock | 3.3464 | 3.3504 | 3.3364 | 3.3432 | 159152.0 |
| 2008-11-12 08:06:00 | AAPL | Stock | 3.3375 | 3.3454 | 3.3307 | 3.3321 | 111496.0 |
| 2008-11-12 08:07:00 | AAPL | Stock | 3.3325 | 3.3368 | 3.3214 | 3.3214 | 206752.0 |
| 2008-11-12 08:08:00 | AAPL | Stock | 3.3125 | 3.3214 | 3.3125 | 3.3161 | 53200.0 |
| 2008-11-12 08:09:00 | AAPL | Stock | 3.3214 | 3.3214 | 3.3214 | 3.3214 | 8400.0 |
| 2008-11-12 08:10:00 | AAPL | Stock | 3.325 | 3.3311 | 3.3211 | 3.3214 | 220948.0 |
| 2008-11-12 08:11:00 | AAPL | Stock | 3.3211 | 3.3246 | 3.3211 | 3.3214 | 89012.0 |
| 2008-11-12 08:12:00 | AAPL | Stock | 3.3211 | 3.3214 | 3.3211 | 3.3214 | 9520.0 |
| 2008-11-12 08:13:00 | AAPL | Stock | 3.3211 | 3.325 | 3.3143 | 3.3246 | 100800.0 |
| 2008-11-12 08:14:00 | AAPL | Stock | 3.325 | 3.325 | 3.325 | 3.325 | 14000.0 |
| 2008-11-12 08:15:00 | AAPL | Stock | 3.3286 | 3.3286 | 3.3286 | 3.3286 | 14000.0 |
| 2008-11-12 08:16:00 | AAPL | Stock | 3.3279 | 3.3279 | 3.3218 | 3.3218 | 42000.0 |
| 2008-11-12 08:17:00 | AAPL | Stock | 3.32 | 3.3214 | 3.32 | 3.32 | 97580.0 |
| 2008-11-12 08:18:00 | AAPL | Stock | 3.32 | 3.3214 | 3.3143 | 3.3143 | 98868.0 |
| 2008-11-12 08:19:00 | AAPL | Stock | 3.3157 | 3.3157 | 3.3157 | 3.3157 | 4088.0 |
| 2008-11-12 08:20:00 | AAPL | Stock | 3.3143 | 3.3179 | 3.3125 | 3.3179 | 40292.0 |
| 2008-11-12 08:21:00 | AAPL | Stock | 3.3211 | 3.3211 | 3.3179 | 3.3179 | 30800.0 |
| 2008-11-12 08:22:00 | AAPL | Stock | 3.3236 | 3.3236 | 3.3236 | 3.3236 | 6020.0 |
| 2008-11-12 08:23:00 | AAPL | Stock | 3.3236 | 3.3254 | 3.3236 | 3.3236 | 13440.0 |
| 2008-11-12 08:24:00 | AAPL | Stock | 3.3243 | 3.3243 | 3.3211 | 3.3211 | 56560.0 |
| 2008-11-12 08:25:00 | AAPL | Stock | 3.3214 | 3.3214 | 3.3161 | 3.3161 | 84560.0 |
| 2008-11-12 08:26:00 | AAPL | Stock | 3.3164 | 3.3204 | 3.3157 | 3.3204 | 14000.0 |
| 2008-11-12 08:27:00 | AAPL | Stock | 3.3214 | 3.3214 | 3.3179 | 3.3207 | 79072.0 |
| 2008-11-12 08:28:00 | AAPL | Stock | 3.3214 | 3.3239 | 3.3211 | 3.3214 | 73920.0 |
| 2008-11-12 08:30:00 | AAPL | Stock | 3.3257 | 3.3257 | 3.3229 | 3.3229 | 17500.0 |
| 2008-11-12 08:31:00 | AAPL | Stock | 3.3243 | 3.3243 | 3.3229 | 3.3229 | 25900.0 |
| 2008-11-12 08:32:00 | AAPL | Stock | 3.3254 | 3.3254 | 3.3246 | 3.325 | 44800.0 |
| 2008-11-12 08:33:00 | AAPL | Stock | 3.3243 | 3.3246 | 3.3229 | 3.3243 | 103880.0 |
| 2008-11-12 08:34:00 | AAPL | Stock | 3.3236 | 3.325 | 3.3236 | 3.325 | 32200.0 |
| 2008-11-12 08:36:00 | AAPL | Stock | 3.3275 | 3.3275 | 3.3275 | 3.3275 | 8400.0 |
| 2008-11-12 08:37:00 | AAPL | Stock | 3.3286 | 3.3286 | 3.3279 | 3.3286 | 19600.0 |
| 2008-11-12 08:38:00 | AAPL | Stock | 3.325 | 3.3282 | 3.3246 | 3.3282 | 43400.0 |
| 2008-11-12 08:39:00 | AAPL | Stock | 3.325 | 3.3264 | 3.3236 | 3.3236 | 11200.0 |
| 2008-11-12 08:40:00 | AAPL | Stock | 3.3246 | 3.3246 | 3.3246 | 3.3246 | 2800.0 |
| 2008-11-12 08:41:00 | AAPL | Stock | 3.325 | 3.325 | 3.3225 | 3.3225 | 53620.0 |
| 2008-11-12 08:42:00 | AAPL | Stock | 3.3225 | 3.325 | 3.3196 | 3.3196 | 169624.0 |
| 2008-11-12 08:43:00 | AAPL | Stock | 3.3196 | 3.3196 | 3.3186 | 3.3196 | 87164.0 |
| 2008-11-12 08:44:00 | AAPL | Stock | 3.3196 | 3.3196 | 3.3129 | 3.3129 | 39956.0 |
| 2008-11-12 08:46:00 | AAPL | Stock | 3.3161 | 3.3161 | 3.3139 | 3.3139 | 82320.0 |
| 2008-11-12 08:47:00 | AAPL | Stock | 3.3196 | 3.3207 | 3.3043 | 3.3125 | 47628.0 |
| 2008-11-12 08:48:00 | AAPL | Stock | 3.3107 | 3.3107 | 3.3071 | 3.3071 | 30800.0 |
| 2008-11-12 08:49:00 | AAPL | Stock | 3.3071 | 3.3082 | 3.3064 | 3.3075 | 22400.0 |
| 2008-11-12 08:50:00 | AAPL | Stock | 3.3125 | 3.3125 | 3.3039 | 3.3039 | 77000.0 |
| 2008-11-12 08:51:00 | AAPL | Stock | 3.3068 | 3.3071 | 3.3054 | 3.3061 | 24920.0 |
> showing 50 of 993,559 rows — these rows as CSV