PREVIEW / stock_1min / 2010-10-07
file: by_date/stock_1min/2010/2010-10-07.parquet size: 12.7 MB rows: 966,048 symbols: 2,831
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-07 07:06:00 | AAPL | Stock | 10.3675 | 10.3675 | 10.3675 | 10.3675 | 2800.0 |
| 2010-10-07 07:07:00 | AAPL | Stock | 10.3714 | 10.3714 | 10.3714 | 10.3714 | 7700.0 |
| 2010-10-07 07:14:00 | AAPL | Stock | 10.3686 | 10.3686 | 10.3686 | 10.3686 | 5600.0 |
| 2010-10-07 07:17:00 | AAPL | Stock | 10.3657 | 10.3657 | 10.3657 | 10.3657 | 2800.0 |
| 2010-10-07 07:20:00 | AAPL | Stock | 10.365 | 10.365 | 10.3643 | 10.3643 | 8400.0 |
| 2010-10-07 07:21:00 | AAPL | Stock | 10.3643 | 10.3643 | 10.3643 | 10.3643 | 5600.0 |
| 2010-10-07 07:22:00 | AAPL | Stock | 10.3589 | 10.3589 | 10.3589 | 10.3589 | 11200.0 |
| 2010-10-07 07:24:00 | AAPL | Stock | 10.3639 | 10.3654 | 10.3639 | 10.3654 | 14420.0 |
| 2010-10-07 07:25:00 | AAPL | Stock | 10.3571 | 10.3571 | 10.3571 | 10.3571 | 11200.0 |
| 2010-10-07 07:32:00 | AAPL | Stock | 10.3568 | 10.3568 | 10.3568 | 10.3568 | 5404.0 |
| 2010-10-07 07:37:00 | AAPL | Stock | 10.3525 | 10.3525 | 10.3496 | 10.3496 | 31304.0 |
| 2010-10-07 07:38:00 | AAPL | Stock | 10.3568 | 10.3568 | 10.3568 | 10.3568 | 8400.0 |
| 2010-10-07 07:39:00 | AAPL | Stock | 10.3518 | 10.3518 | 10.3518 | 10.3518 | 2800.0 |
| 2010-10-07 07:40:00 | AAPL | Stock | 10.35 | 10.35 | 10.35 | 10.35 | 2800.0 |
| 2010-10-07 07:42:00 | AAPL | Stock | 10.3518 | 10.3611 | 10.3518 | 10.3611 | 5600.0 |
| 2010-10-07 07:46:00 | AAPL | Stock | 10.3571 | 10.3571 | 10.35 | 10.35 | 35000.0 |
| 2010-10-07 07:49:00 | AAPL | Stock | 10.3557 | 10.3557 | 10.3557 | 10.3557 | 12404.0 |
| 2010-10-07 07:50:00 | AAPL | Stock | 10.355 | 10.355 | 10.355 | 10.355 | 8400.0 |
| 2010-10-07 07:52:00 | AAPL | Stock | 10.3514 | 10.3568 | 10.3514 | 10.3532 | 14000.0 |
| 2010-10-07 07:55:00 | AAPL | Stock | 10.3546 | 10.3546 | 10.3546 | 10.3546 | 2800.0 |
| 2010-10-07 07:56:00 | AAPL | Stock | 10.3532 | 10.3532 | 10.3532 | 10.3532 | 2800.0 |
| 2010-10-07 07:58:00 | AAPL | Stock | 10.3454 | 10.3482 | 10.3446 | 10.3482 | 14000.0 |
| 2010-10-07 07:59:00 | AAPL | Stock | 10.3464 | 10.3464 | 10.3446 | 10.3464 | 11200.0 |
| 2010-10-07 08:00:00 | AAPL | Stock | 10.3432 | 10.3432 | 10.3307 | 10.3307 | 152712.0 |
| 2010-10-07 08:01:00 | AAPL | Stock | 10.3289 | 10.3289 | 10.325 | 10.3254 | 11200.0 |
| 2010-10-07 08:02:00 | AAPL | Stock | 10.3286 | 10.3307 | 10.3232 | 10.3232 | 25200.0 |
| 2010-10-07 08:03:00 | AAPL | Stock | 10.3225 | 10.3225 | 10.3189 | 10.3189 | 8400.0 |
| 2010-10-07 08:04:00 | AAPL | Stock | 10.3121 | 10.3121 | 10.3121 | 10.3121 | 2800.0 |
| 2010-10-07 08:05:00 | AAPL | Stock | 10.3175 | 10.3175 | 10.3175 | 10.3175 | 2800.0 |
| 2010-10-07 08:06:00 | AAPL | Stock | 10.3207 | 10.3236 | 10.3207 | 10.3236 | 55160.0 |
| 2010-10-07 08:07:00 | AAPL | Stock | 10.3186 | 10.3186 | 10.3186 | 10.3186 | 2800.0 |
| 2010-10-07 08:08:00 | AAPL | Stock | 10.3186 | 10.3186 | 10.3179 | 10.3179 | 53200.0 |
| 2010-10-07 08:09:00 | AAPL | Stock | 10.3179 | 10.3179 | 10.3179 | 10.3179 | 2800.0 |
| 2010-10-07 08:10:00 | AAPL | Stock | 10.3125 | 10.3143 | 10.3107 | 10.3125 | 36680.0 |
| 2010-10-07 08:11:00 | AAPL | Stock | 10.3093 | 10.3093 | 10.3071 | 10.3071 | 13300.0 |
| 2010-10-07 08:12:00 | AAPL | Stock | 10.3079 | 10.3079 | 10.2857 | 10.2857 | 50064.0 |
| 2010-10-07 08:13:00 | AAPL | Stock | 10.2946 | 10.2946 | 10.2929 | 10.2929 | 5600.0 |
| 2010-10-07 08:14:00 | AAPL | Stock | 10.2882 | 10.2889 | 10.2854 | 10.2854 | 8400.0 |
| 2010-10-07 08:15:00 | AAPL | Stock | 10.2839 | 10.2929 | 10.2839 | 10.2929 | 184800.0 |
| 2010-10-07 08:16:00 | AAPL | Stock | 10.2943 | 10.2943 | 10.2882 | 10.2929 | 45360.0 |
| 2010-10-07 08:17:00 | AAPL | Stock | 10.2864 | 10.2868 | 10.2786 | 10.2786 | 72800.0 |
| 2010-10-07 08:18:00 | AAPL | Stock | 10.2818 | 10.285 | 10.2768 | 10.2768 | 86940.0 |
| 2010-10-07 08:19:00 | AAPL | Stock | 10.2786 | 10.2786 | 10.2786 | 10.2786 | 5376.0 |
| 2010-10-07 08:20:00 | AAPL | Stock | 10.2832 | 10.2836 | 10.2721 | 10.2786 | 90104.0 |
| 2010-10-07 08:21:00 | AAPL | Stock | 10.2786 | 10.2857 | 10.2786 | 10.2843 | 36400.0 |
| 2010-10-07 08:22:00 | AAPL | Stock | 10.2857 | 10.3139 | 10.2857 | 10.3139 | 261520.0 |
| 2010-10-07 08:23:00 | AAPL | Stock | 10.3096 | 10.3096 | 10.3036 | 10.3039 | 89600.0 |
| 2010-10-07 08:24:00 | AAPL | Stock | 10.3036 | 10.3096 | 10.3032 | 10.3036 | 70588.0 |
| 2010-10-07 08:25:00 | AAPL | Stock | 10.3096 | 10.3107 | 10.3064 | 10.3075 | 59640.0 |
| 2010-10-07 08:26:00 | AAPL | Stock | 10.3075 | 10.3079 | 10.3036 | 10.3071 | 126532.0 |
> showing 50 of 966,048 rows — these rows as CSV