PREVIEW / stock_1min / 2012-05-10
file: by_date/stock_1min/2012/2012-05-10.parquet size: 13.1 MB rows: 984,780 symbols: 2,844
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 |
|---|---|---|---|---|---|---|---|
| 2012-05-10 04:00:00 | AAPL | Stock | 20.3571 | 20.3571 | 20.3571 | 20.3571 | 25900.0 |
| 2012-05-10 04:14:00 | AAPL | Stock | 20.325 | 20.325 | 20.3246 | 20.3246 | 5600.0 |
| 2012-05-10 04:15:00 | AAPL | Stock | 20.3246 | 20.3246 | 20.3246 | 20.3246 | 2800.0 |
| 2012-05-10 04:17:00 | AAPL | Stock | 20.3286 | 20.3286 | 20.3286 | 20.3286 | 2800.0 |
| 2012-05-10 04:25:00 | AAPL | Stock | 20.2896 | 20.2896 | 20.2857 | 20.2857 | 8400.0 |
| 2012-05-10 04:26:00 | AAPL | Stock | 20.2857 | 20.2857 | 20.2857 | 20.2857 | 5600.0 |
| 2012-05-10 04:27:00 | AAPL | Stock | 20.2857 | 20.2857 | 20.2857 | 20.2857 | 11200.0 |
| 2012-05-10 04:28:00 | AAPL | Stock | 20.2821 | 20.2821 | 20.2821 | 20.2821 | 19600.0 |
| 2012-05-10 04:29:00 | AAPL | Stock | 20.2821 | 20.2821 | 20.2821 | 20.2821 | 5600.0 |
| 2012-05-10 04:30:00 | AAPL | Stock | 20.2857 | 20.2857 | 20.2857 | 20.2857 | 2800.0 |
| 2012-05-10 04:39:00 | AAPL | Stock | 20.2857 | 20.2857 | 20.2857 | 20.2857 | 2800.0 |
| 2012-05-10 04:40:00 | AAPL | Stock | 20.2893 | 20.2893 | 20.2893 | 20.2893 | 2800.0 |
| 2012-05-10 04:45:00 | AAPL | Stock | 20.2893 | 20.2893 | 20.2893 | 20.2893 | 8344.0 |
| 2012-05-10 05:07:00 | AAPL | Stock | 20.2771 | 20.2771 | 20.2771 | 20.2771 | 2800.0 |
| 2012-05-10 05:09:00 | AAPL | Stock | 20.2771 | 20.2771 | 20.2771 | 20.2771 | 11200.0 |
| 2012-05-10 05:19:00 | AAPL | Stock | 20.2643 | 20.2643 | 20.2643 | 20.2643 | 9212.0 |
| 2012-05-10 05:28:00 | AAPL | Stock | 20.2643 | 20.2643 | 20.2643 | 20.2643 | 5880.0 |
| 2012-05-10 05:31:00 | AAPL | Stock | 20.2643 | 20.2643 | 20.2643 | 20.2643 | 7336.0 |
| 2012-05-10 06:16:00 | AAPL | Stock | 20.2643 | 20.2643 | 20.2643 | 20.2643 | 2800.0 |
| 2012-05-10 06:31:00 | AAPL | Stock | 20.2857 | 20.2857 | 20.2857 | 20.2857 | 2800.0 |
| 2012-05-10 06:38:00 | AAPL | Stock | 20.3 | 20.3 | 20.3 | 20.3 | 2800.0 |
| 2012-05-10 06:39:00 | AAPL | Stock | 20.3446 | 20.3446 | 20.3446 | 20.3446 | 22400.0 |
| 2012-05-10 06:48:00 | AAPL | Stock | 20.3446 | 20.3446 | 20.3446 | 20.3446 | 2800.0 |
| 2012-05-10 06:52:00 | AAPL | Stock | 20.33 | 20.33 | 20.33 | 20.33 | 4732.0 |
| 2012-05-10 06:58:00 | AAPL | Stock | 20.3554 | 20.3571 | 20.3554 | 20.3571 | 20188.0 |
| 2012-05-10 06:59:00 | AAPL | Stock | 20.3571 | 20.3725 | 20.3571 | 20.3725 | 18732.0 |
| 2012-05-10 07:00:00 | AAPL | Stock | 20.3739 | 20.4025 | 20.3739 | 20.4025 | 5600.0 |
| 2012-05-10 07:01:00 | AAPL | Stock | 20.4068 | 20.4068 | 20.4068 | 20.4068 | 4200.0 |
| 2012-05-10 07:02:00 | AAPL | Stock | 20.3989 | 20.3989 | 20.3989 | 20.3989 | 2800.0 |
| 2012-05-10 07:03:00 | AAPL | Stock | 20.3875 | 20.3875 | 20.3875 | 20.3875 | 2800.0 |
| 2012-05-10 07:04:00 | AAPL | Stock | 20.3839 | 20.3925 | 20.3839 | 20.3925 | 11200.0 |
| 2012-05-10 07:06:00 | AAPL | Stock | 20.3893 | 20.3929 | 20.3893 | 20.3929 | 12740.0 |
| 2012-05-10 07:07:00 | AAPL | Stock | 20.4071 | 20.4071 | 20.4071 | 20.4071 | 21000.0 |
| 2012-05-10 07:09:00 | AAPL | Stock | 20.4075 | 20.4075 | 20.4075 | 20.4075 | 2800.0 |
| 2012-05-10 07:10:00 | AAPL | Stock | 20.4075 | 20.4107 | 20.4075 | 20.4107 | 13468.0 |
| 2012-05-10 07:15:00 | AAPL | Stock | 20.395 | 20.395 | 20.395 | 20.395 | 2800.0 |
| 2012-05-10 07:19:00 | AAPL | Stock | 20.3957 | 20.3957 | 20.3929 | 20.3929 | 5600.0 |
| 2012-05-10 07:26:00 | AAPL | Stock | 20.4018 | 20.4018 | 20.4018 | 20.4018 | 7000.0 |
| 2012-05-10 07:28:00 | AAPL | Stock | 20.4057 | 20.4061 | 20.4057 | 20.4057 | 19600.0 |
| 2012-05-10 07:30:00 | AAPL | Stock | 20.4089 | 20.4089 | 20.4089 | 20.4089 | 2800.0 |
| 2012-05-10 07:34:00 | AAPL | Stock | 20.4189 | 20.4311 | 20.4189 | 20.4311 | 14000.0 |
| 2012-05-10 07:36:00 | AAPL | Stock | 20.4286 | 20.4286 | 20.4164 | 20.4182 | 8400.0 |
| 2012-05-10 07:37:00 | AAPL | Stock | 20.4321 | 20.4321 | 20.4321 | 20.4321 | 5600.0 |
| 2012-05-10 07:38:00 | AAPL | Stock | 20.4375 | 20.4375 | 20.4375 | 20.4375 | 5600.0 |
| 2012-05-10 07:40:00 | AAPL | Stock | 20.4296 | 20.4296 | 20.4296 | 20.4296 | 2800.0 |
| 2012-05-10 07:41:00 | AAPL | Stock | 20.4364 | 20.4364 | 20.4364 | 20.4364 | 2800.0 |
| 2012-05-10 07:44:00 | AAPL | Stock | 20.4371 | 20.4375 | 20.4371 | 20.4375 | 12572.0 |
| 2012-05-10 07:45:00 | AAPL | Stock | 20.4454 | 20.4464 | 20.4454 | 20.4464 | 8400.0 |
| 2012-05-10 07:46:00 | AAPL | Stock | 20.455 | 20.5357 | 20.455 | 20.5 | 165340.0 |
| 2012-05-10 07:49:00 | AAPL | Stock | 20.4979 | 20.4989 | 20.4979 | 20.4989 | 25200.0 |
> showing 50 of 984,780 rows — these rows as CSV