PREVIEW / stock_1min / 2007-12-04
file: by_date/stock_1min/2007/2007-12-04.parquet size: 12.0 MB rows: 978,425 symbols: 2,632
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-04 05:29:00 | AAPL | Stock | 6.375 | 6.375 | 6.3729 | 6.3729 | 14000.0 |
| 2007-12-04 05:44:00 | AAPL | Stock | 6.3721 | 6.3721 | 6.3721 | 6.3721 | 2800.0 |
| 2007-12-04 06:44:00 | AAPL | Stock | 6.3571 | 6.3571 | 6.3571 | 6.3571 | 53200.0 |
| 2007-12-04 07:13:00 | AAPL | Stock | 6.3571 | 6.375 | 6.3571 | 6.375 | 16800.0 |
| 2007-12-04 07:15:00 | AAPL | Stock | 6.3554 | 6.3554 | 6.3554 | 6.3554 | 8400.0 |
| 2007-12-04 07:16:00 | AAPL | Stock | 6.3571 | 6.3571 | 6.3571 | 6.3571 | 5600.0 |
| 2007-12-04 07:20:00 | AAPL | Stock | 6.3521 | 6.3521 | 6.3521 | 6.3521 | 5600.0 |
| 2007-12-04 07:23:00 | AAPL | Stock | 6.3521 | 6.3521 | 6.3521 | 6.3521 | 8400.0 |
| 2007-12-04 07:26:00 | AAPL | Stock | 6.3518 | 6.3518 | 6.3518 | 6.3518 | 4200.0 |
| 2007-12-04 07:29:00 | AAPL | Stock | 6.3429 | 6.3429 | 6.3371 | 6.3429 | 50176.0 |
| 2007-12-04 07:30:00 | AAPL | Stock | 6.3429 | 6.3429 | 6.3429 | 6.3429 | 28000.0 |
| 2007-12-04 07:31:00 | AAPL | Stock | 6.3429 | 6.3429 | 6.3429 | 6.3429 | 14000.0 |
| 2007-12-04 07:32:00 | AAPL | Stock | 6.3429 | 6.3429 | 6.3429 | 6.3429 | 14000.0 |
| 2007-12-04 07:33:00 | AAPL | Stock | 6.3429 | 6.3429 | 6.3429 | 6.3429 | 22428.0 |
| 2007-12-04 07:34:00 | AAPL | Stock | 6.3429 | 6.3429 | 6.3429 | 6.3429 | 12656.0 |
| 2007-12-04 07:38:00 | AAPL | Stock | 6.3325 | 6.3325 | 6.3325 | 6.3325 | 4424.0 |
| 2007-12-04 07:40:00 | AAPL | Stock | 6.3325 | 6.3325 | 6.3325 | 6.3325 | 14000.0 |
| 2007-12-04 07:44:00 | AAPL | Stock | 6.3393 | 6.3393 | 6.3393 | 6.3393 | 21840.0 |
| 2007-12-04 07:45:00 | AAPL | Stock | 6.3393 | 6.3393 | 6.3393 | 6.3393 | 28000.0 |
| 2007-12-04 07:46:00 | AAPL | Stock | 6.3325 | 6.3393 | 6.3325 | 6.3393 | 39760.0 |
| 2007-12-04 07:47:00 | AAPL | Stock | 6.3393 | 6.3393 | 6.3393 | 6.3393 | 11200.0 |
| 2007-12-04 07:48:00 | AAPL | Stock | 6.3464 | 6.3464 | 6.3464 | 6.3464 | 2800.0 |
| 2007-12-04 07:50:00 | AAPL | Stock | 6.3464 | 6.3464 | 6.3464 | 6.3464 | 7420.0 |
| 2007-12-04 07:52:00 | AAPL | Stock | 6.35 | 6.35 | 6.35 | 6.35 | 11200.0 |
| 2007-12-04 07:54:00 | AAPL | Stock | 6.3393 | 6.3393 | 6.3393 | 6.3393 | 16800.0 |
| 2007-12-04 07:57:00 | AAPL | Stock | 6.345 | 6.345 | 6.345 | 6.345 | 2800.0 |
| 2007-12-04 08:00:00 | AAPL | Stock | 6.345 | 6.35 | 6.3218 | 6.3275 | 206584.0 |
| 2007-12-04 08:01:00 | AAPL | Stock | 6.3275 | 6.3275 | 6.3214 | 6.3214 | 119420.0 |
| 2007-12-04 08:02:00 | AAPL | Stock | 6.32 | 6.3268 | 6.3182 | 6.3268 | 218960.0 |
| 2007-12-04 08:03:00 | AAPL | Stock | 6.3261 | 6.3268 | 6.3179 | 6.3179 | 119168.0 |
| 2007-12-04 08:04:00 | AAPL | Stock | 6.3161 | 6.3214 | 6.3161 | 6.3207 | 141232.0 |
| 2007-12-04 08:05:00 | AAPL | Stock | 6.3179 | 6.3179 | 6.3161 | 6.3168 | 55440.0 |
| 2007-12-04 08:06:00 | AAPL | Stock | 6.3168 | 6.3214 | 6.3168 | 6.3214 | 71372.0 |
| 2007-12-04 08:07:00 | AAPL | Stock | 6.3182 | 6.3268 | 6.3182 | 6.3214 | 151956.0 |
| 2007-12-04 08:08:00 | AAPL | Stock | 6.3214 | 6.3268 | 6.3179 | 6.3218 | 72576.0 |
| 2007-12-04 08:09:00 | AAPL | Stock | 6.3218 | 6.3264 | 6.3214 | 6.3232 | 107100.0 |
| 2007-12-04 08:10:00 | AAPL | Stock | 6.3261 | 6.3268 | 6.3179 | 6.3214 | 217280.0 |
| 2007-12-04 08:11:00 | AAPL | Stock | 6.3211 | 6.3214 | 6.3196 | 6.3196 | 56000.0 |
| 2007-12-04 08:12:00 | AAPL | Stock | 6.3182 | 6.3196 | 6.3129 | 6.3129 | 196644.0 |
| 2007-12-04 08:13:00 | AAPL | Stock | 6.3193 | 6.3214 | 6.3189 | 6.3214 | 81424.0 |
| 2007-12-04 08:14:00 | AAPL | Stock | 6.3211 | 6.3211 | 6.3089 | 6.31 | 113400.0 |
| 2007-12-04 08:15:00 | AAPL | Stock | 6.3136 | 6.3139 | 6.3111 | 6.3111 | 76412.0 |
| 2007-12-04 08:16:00 | AAPL | Stock | 6.3139 | 6.3161 | 6.3111 | 6.3111 | 68600.0 |
| 2007-12-04 08:17:00 | AAPL | Stock | 6.3125 | 6.3125 | 6.3043 | 6.3043 | 116200.0 |
| 2007-12-04 08:18:00 | AAPL | Stock | 6.3054 | 6.3054 | 6.2996 | 6.3036 | 130368.0 |
| 2007-12-04 08:19:00 | AAPL | Stock | 6.3036 | 6.3071 | 6.3011 | 6.3039 | 187656.0 |
| 2007-12-04 08:20:00 | AAPL | Stock | 6.3057 | 6.3068 | 6.3036 | 6.3036 | 39116.0 |
| 2007-12-04 08:21:00 | AAPL | Stock | 6.3011 | 6.3036 | 6.3 | 6.3 | 134400.0 |
| 2007-12-04 08:22:00 | AAPL | Stock | 6.3025 | 6.3064 | 6.3004 | 6.3036 | 84000.0 |
| 2007-12-04 08:23:00 | AAPL | Stock | 6.3032 | 6.305 | 6.3032 | 6.3036 | 122808.0 |
> showing 50 of 978,425 rows — these rows as CSV