PREVIEW / stock_1min / 2010-12-14
file: by_date/stock_1min/2010/2010-12-14.parquet size: 13.2 MB rows: 992,158 symbols: 2,863
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-12-14 04:00:00 | AAPL | Stock | 11.5 | 11.5 | 11.5 | 11.5 | 13440.0 |
| 2010-12-14 04:23:00 | AAPL | Stock | 11.4768 | 11.4768 | 11.4768 | 11.4768 | 14000.0 |
| 2010-12-14 04:38:00 | AAPL | Stock | 11.4893 | 11.4893 | 11.4893 | 11.4893 | 5600.0 |
| 2010-12-14 04:52:00 | AAPL | Stock | 11.4721 | 11.4721 | 11.4718 | 11.4718 | 8400.0 |
| 2010-12-14 05:03:00 | AAPL | Stock | 11.4718 | 11.4718 | 11.4718 | 11.4718 | 2800.0 |
| 2010-12-14 05:05:00 | AAPL | Stock | 11.4846 | 11.4846 | 11.4846 | 11.4846 | 2800.0 |
| 2010-12-14 05:23:00 | AAPL | Stock | 11.4979 | 11.4979 | 11.4975 | 11.4975 | 5600.0 |
| 2010-12-14 05:24:00 | AAPL | Stock | 11.5043 | 11.5043 | 11.5043 | 11.5043 | 2800.0 |
| 2010-12-14 05:27:00 | AAPL | Stock | 11.5164 | 11.5164 | 11.5071 | 11.5071 | 16800.0 |
| 2010-12-14 05:28:00 | AAPL | Stock | 11.5154 | 11.5154 | 11.5154 | 11.5154 | 11200.0 |
| 2010-12-14 05:42:00 | AAPL | Stock | 11.5143 | 11.5143 | 11.5143 | 11.5143 | 2800.0 |
| 2010-12-14 05:48:00 | AAPL | Stock | 11.5293 | 11.5293 | 11.5293 | 11.5293 | 25200.0 |
| 2010-12-14 05:56:00 | AAPL | Stock | 11.5357 | 11.5357 | 11.5357 | 11.5357 | 2800.0 |
| 2010-12-14 05:57:00 | AAPL | Stock | 11.5357 | 11.5357 | 11.5357 | 11.5357 | 11200.0 |
| 2010-12-14 05:58:00 | AAPL | Stock | 11.5357 | 11.5357 | 11.5357 | 11.5357 | 2800.0 |
| 2010-12-14 06:19:00 | AAPL | Stock | 11.5089 | 11.5089 | 11.5089 | 11.5089 | 28000.0 |
| 2010-12-14 06:21:00 | AAPL | Stock | 11.5179 | 11.5179 | 11.5179 | 11.5179 | 5600.0 |
| 2010-12-14 06:25:00 | AAPL | Stock | 11.5179 | 11.5179 | 11.5179 | 11.5179 | 2800.0 |
| 2010-12-14 06:30:00 | AAPL | Stock | 11.525 | 11.5286 | 11.525 | 11.5286 | 11200.0 |
| 2010-12-14 06:40:00 | AAPL | Stock | 11.5357 | 11.5357 | 11.5357 | 11.5357 | 2800.0 |
| 2010-12-14 06:50:00 | AAPL | Stock | 11.5318 | 11.5318 | 11.5286 | 11.5286 | 8400.0 |
| 2010-12-14 06:55:00 | AAPL | Stock | 11.5179 | 11.5179 | 11.5179 | 11.5179 | 6720.0 |
| 2010-12-14 06:56:00 | AAPL | Stock | 11.5157 | 11.5157 | 11.5157 | 11.5157 | 2800.0 |
| 2010-12-14 07:01:00 | AAPL | Stock | 11.5196 | 11.5196 | 11.5196 | 11.5196 | 5600.0 |
| 2010-12-14 07:02:00 | AAPL | Stock | 11.5214 | 11.5214 | 11.5196 | 11.5196 | 28000.0 |
| 2010-12-14 07:03:00 | AAPL | Stock | 11.5143 | 11.5143 | 11.5143 | 11.5143 | 2800.0 |
| 2010-12-14 07:04:00 | AAPL | Stock | 11.5143 | 11.5143 | 11.5089 | 11.5089 | 36764.0 |
| 2010-12-14 07:05:00 | AAPL | Stock | 11.5075 | 11.5075 | 11.5071 | 11.5071 | 11200.0 |
| 2010-12-14 07:06:00 | AAPL | Stock | 11.5007 | 11.5007 | 11.495 | 11.495 | 11200.0 |
| 2010-12-14 07:07:00 | AAPL | Stock | 11.495 | 11.495 | 11.4868 | 11.4893 | 36400.0 |
| 2010-12-14 07:08:00 | AAPL | Stock | 11.4868 | 11.4868 | 11.4821 | 11.4821 | 19600.0 |
| 2010-12-14 07:09:00 | AAPL | Stock | 11.4821 | 11.4821 | 11.4821 | 11.4821 | 19600.0 |
| 2010-12-14 07:10:00 | AAPL | Stock | 11.485 | 11.4875 | 11.485 | 11.4875 | 22904.0 |
| 2010-12-14 07:12:00 | AAPL | Stock | 11.5 | 11.5 | 11.5 | 11.5 | 5600.0 |
| 2010-12-14 07:13:00 | AAPL | Stock | 11.5 | 11.5 | 11.5 | 11.5 | 51100.0 |
| 2010-12-14 07:14:00 | AAPL | Stock | 11.5 | 11.5 | 11.5 | 11.5 | 2800.0 |
| 2010-12-14 07:15:00 | AAPL | Stock | 11.5 | 11.5 | 11.5 | 11.5 | 11200.0 |
| 2010-12-14 07:21:00 | AAPL | Stock | 11.5125 | 11.5125 | 11.5071 | 11.5071 | 11200.0 |
| 2010-12-14 07:22:00 | AAPL | Stock | 11.5071 | 11.5071 | 11.5 | 11.5 | 47600.0 |
| 2010-12-14 07:23:00 | AAPL | Stock | 11.5 | 11.5 | 11.4971 | 11.4971 | 26880.0 |
| 2010-12-14 07:24:00 | AAPL | Stock | 11.4879 | 11.4971 | 11.4879 | 11.4971 | 11200.0 |
| 2010-12-14 07:26:00 | AAPL | Stock | 11.4893 | 11.4946 | 11.4893 | 11.4946 | 5600.0 |
| 2010-12-14 07:27:00 | AAPL | Stock | 11.4946 | 11.4946 | 11.4946 | 11.4946 | 8400.0 |
| 2010-12-14 07:29:00 | AAPL | Stock | 11.4929 | 11.4929 | 11.49 | 11.49 | 5600.0 |
| 2010-12-14 07:30:00 | AAPL | Stock | 11.4893 | 11.4893 | 11.4893 | 11.4893 | 2800.0 |
| 2010-12-14 07:31:00 | AAPL | Stock | 11.4925 | 11.4925 | 11.4925 | 11.4925 | 5600.0 |
| 2010-12-14 07:33:00 | AAPL | Stock | 11.4921 | 11.4929 | 11.4921 | 11.4929 | 19600.0 |
| 2010-12-14 07:34:00 | AAPL | Stock | 11.4925 | 11.4929 | 11.4925 | 11.4929 | 39200.0 |
| 2010-12-14 07:35:00 | AAPL | Stock | 11.4929 | 11.4929 | 11.4893 | 11.4925 | 39200.0 |
| 2010-12-14 07:36:00 | AAPL | Stock | 11.4929 | 11.5118 | 11.4929 | 11.5118 | 109200.0 |
> showing 50 of 992,158 rows — these rows as CSV