PREVIEW / stock_1min / 2008-02-08
file: by_date/stock_1min/2008/2008-02-08.parquet size: 12.3 MB rows: 999,951 symbols: 2,657
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-02-08 06:10:00 | AAPL | Stock | 4.3464 | 4.3464 | 4.3464 | 4.3464 | 9800.0 |
| 2008-02-08 06:42:00 | AAPL | Stock | 4.3382 | 4.3382 | 4.3382 | 4.3382 | 2800.0 |
| 2008-02-08 07:00:00 | AAPL | Stock | 4.3311 | 4.3311 | 4.3304 | 4.3304 | 142800.0 |
| 2008-02-08 07:02:00 | AAPL | Stock | 4.3304 | 4.3307 | 4.3304 | 4.3304 | 18200.0 |
| 2008-02-08 07:05:00 | AAPL | Stock | 4.3429 | 4.3429 | 4.3429 | 4.3429 | 2800.0 |
| 2008-02-08 07:06:00 | AAPL | Stock | 4.3271 | 4.3271 | 4.3271 | 4.3271 | 11200.0 |
| 2008-02-08 07:10:00 | AAPL | Stock | 4.295 | 4.2961 | 4.295 | 4.295 | 18480.0 |
| 2008-02-08 07:12:00 | AAPL | Stock | 4.2957 | 4.2957 | 4.2957 | 4.2957 | 8400.0 |
| 2008-02-08 07:13:00 | AAPL | Stock | 4.2989 | 4.2989 | 4.2964 | 4.2964 | 14000.0 |
| 2008-02-08 07:15:00 | AAPL | Stock | 4.2964 | 4.2964 | 4.295 | 4.295 | 5600.0 |
| 2008-02-08 07:16:00 | AAPL | Stock | 4.2957 | 4.2957 | 4.2957 | 4.2957 | 28000.0 |
| 2008-02-08 07:17:00 | AAPL | Stock | 4.2957 | 4.2957 | 4.2957 | 4.2957 | 24584.0 |
| 2008-02-08 07:18:00 | AAPL | Stock | 4.3104 | 4.3104 | 4.3104 | 4.3104 | 2800.0 |
| 2008-02-08 07:21:00 | AAPL | Stock | 4.3175 | 4.3175 | 4.3175 | 4.3175 | 8400.0 |
| 2008-02-08 07:25:00 | AAPL | Stock | 4.3071 | 4.3071 | 4.3071 | 4.3071 | 28000.0 |
| 2008-02-08 07:28:00 | AAPL | Stock | 4.3036 | 4.3036 | 4.3036 | 4.3036 | 2800.0 |
| 2008-02-08 07:29:00 | AAPL | Stock | 4.3107 | 4.3107 | 4.3107 | 4.3107 | 14000.0 |
| 2008-02-08 07:30:00 | AAPL | Stock | 4.3107 | 4.3107 | 4.3107 | 4.3107 | 2800.0 |
| 2008-02-08 07:31:00 | AAPL | Stock | 4.3107 | 4.3175 | 4.3107 | 4.3175 | 14000.0 |
| 2008-02-08 07:32:00 | AAPL | Stock | 4.3175 | 4.3175 | 4.3175 | 4.3175 | 2800.0 |
| 2008-02-08 07:33:00 | AAPL | Stock | 4.3214 | 4.3214 | 4.3214 | 4.3214 | 5740.0 |
| 2008-02-08 07:34:00 | AAPL | Stock | 4.3143 | 4.3179 | 4.3143 | 4.3179 | 16800.0 |
| 2008-02-08 07:36:00 | AAPL | Stock | 4.3214 | 4.3214 | 4.3214 | 4.3214 | 8400.0 |
| 2008-02-08 07:39:00 | AAPL | Stock | 4.3179 | 4.3179 | 4.3179 | 4.3179 | 2800.0 |
| 2008-02-08 07:42:00 | AAPL | Stock | 4.3179 | 4.3179 | 4.3179 | 4.3179 | 8400.0 |
| 2008-02-08 07:48:00 | AAPL | Stock | 4.3179 | 4.3179 | 4.3179 | 4.3179 | 14000.0 |
| 2008-02-08 07:49:00 | AAPL | Stock | 4.3179 | 4.3179 | 4.3179 | 4.3179 | 8400.0 |
| 2008-02-08 07:54:00 | AAPL | Stock | 4.3179 | 4.3179 | 4.3075 | 4.3075 | 8400.0 |
| 2008-02-08 07:59:00 | AAPL | Stock | 4.3089 | 4.3089 | 4.3089 | 4.3089 | 2800.0 |
| 2008-02-08 08:00:00 | AAPL | Stock | 4.3157 | 4.3179 | 4.3157 | 4.3179 | 25900.0 |
| 2008-02-08 08:01:00 | AAPL | Stock | 4.3136 | 4.3214 | 4.3129 | 4.3214 | 52136.0 |
| 2008-02-08 08:02:00 | AAPL | Stock | 4.3264 | 4.3386 | 4.3264 | 4.3371 | 74760.0 |
| 2008-02-08 08:03:00 | AAPL | Stock | 4.3375 | 4.3486 | 4.3375 | 4.3486 | 157920.0 |
| 2008-02-08 08:04:00 | AAPL | Stock | 4.3464 | 4.3464 | 4.3396 | 4.3443 | 11508.0 |
| 2008-02-08 08:05:00 | AAPL | Stock | 4.3496 | 4.3514 | 4.3429 | 4.3514 | 52360.0 |
| 2008-02-08 08:06:00 | AAPL | Stock | 4.3514 | 4.3514 | 4.3393 | 4.3393 | 50400.0 |
| 2008-02-08 08:07:00 | AAPL | Stock | 4.3393 | 4.3393 | 4.3393 | 4.3393 | 5600.0 |
| 2008-02-08 08:08:00 | AAPL | Stock | 4.3432 | 4.3432 | 4.3393 | 4.3429 | 61600.0 |
| 2008-02-08 08:09:00 | AAPL | Stock | 4.3396 | 4.3482 | 4.3396 | 4.3482 | 28000.0 |
| 2008-02-08 08:10:00 | AAPL | Stock | 4.3482 | 4.3486 | 4.3482 | 4.3482 | 19600.0 |
| 2008-02-08 08:11:00 | AAPL | Stock | 4.345 | 4.345 | 4.3407 | 4.3429 | 39592.0 |
| 2008-02-08 08:12:00 | AAPL | Stock | 4.3396 | 4.34 | 4.3364 | 4.3364 | 88424.0 |
| 2008-02-08 08:13:00 | AAPL | Stock | 4.3375 | 4.3375 | 4.3357 | 4.3364 | 44800.0 |
| 2008-02-08 08:14:00 | AAPL | Stock | 4.3364 | 4.3364 | 4.3364 | 4.3364 | 2800.0 |
| 2008-02-08 08:15:00 | AAPL | Stock | 4.3357 | 4.3429 | 4.3357 | 4.3393 | 22400.0 |
| 2008-02-08 08:16:00 | AAPL | Stock | 4.3357 | 4.3393 | 4.3354 | 4.3354 | 53676.0 |
| 2008-02-08 08:17:00 | AAPL | Stock | 4.3354 | 4.3354 | 4.3336 | 4.3336 | 40600.0 |
| 2008-02-08 08:20:00 | AAPL | Stock | 4.3339 | 4.3339 | 4.3329 | 4.3329 | 8400.0 |
| 2008-02-08 08:21:00 | AAPL | Stock | 4.3304 | 4.3314 | 4.3304 | 4.3307 | 30800.0 |
| 2008-02-08 08:22:00 | AAPL | Stock | 4.3311 | 4.3311 | 4.3257 | 4.3307 | 112000.0 |
> showing 50 of 999,951 rows — these rows as CSV