PREVIEW / stock_1min / 2011-03-14
file: by_date/stock_1min/2011/2011-03-14.parquet size: 13.3 MB rows: 1,002,565 symbols: 2,850
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 |
|---|---|---|---|---|---|---|---|
| 2011-03-14 04:21:00 | AAPL | Stock | 12.25 | 12.2679 | 12.25 | 12.2679 | 22400.0 |
| 2011-03-14 04:32:00 | AAPL | Stock | 12.2961 | 12.2961 | 12.2961 | 12.2961 | 14000.0 |
| 2011-03-14 04:33:00 | AAPL | Stock | 12.3104 | 12.3104 | 12.3104 | 12.3104 | 5600.0 |
| 2011-03-14 04:36:00 | AAPL | Stock | 12.3036 | 12.3036 | 12.3036 | 12.3036 | 13300.0 |
| 2011-03-14 04:46:00 | AAPL | Stock | 12.295 | 12.3364 | 12.295 | 12.3364 | 14000.0 |
| 2011-03-14 04:51:00 | AAPL | Stock | 12.3418 | 12.3418 | 12.3418 | 12.3418 | 2800.0 |
| 2011-03-14 04:52:00 | AAPL | Stock | 12.3418 | 12.3418 | 12.3418 | 12.3418 | 16800.0 |
| 2011-03-14 04:56:00 | AAPL | Stock | 12.3589 | 12.3589 | 12.3589 | 12.3589 | 2800.0 |
| 2011-03-14 04:58:00 | AAPL | Stock | 12.3571 | 12.3571 | 12.3571 | 12.3571 | 2800.0 |
| 2011-03-14 05:05:00 | AAPL | Stock | 12.3482 | 12.3482 | 12.3482 | 12.3482 | 2800.0 |
| 2011-03-14 05:11:00 | AAPL | Stock | 12.365 | 12.365 | 12.365 | 12.365 | 5600.0 |
| 2011-03-14 05:13:00 | AAPL | Stock | 12.3857 | 12.3857 | 12.3857 | 12.3857 | 8400.0 |
| 2011-03-14 05:14:00 | AAPL | Stock | 12.3857 | 12.3857 | 12.3857 | 12.3857 | 2800.0 |
| 2011-03-14 05:19:00 | AAPL | Stock | 12.385 | 12.385 | 12.385 | 12.385 | 5600.0 |
| 2011-03-14 05:22:00 | AAPL | Stock | 12.3754 | 12.3754 | 12.3754 | 12.3754 | 2800.0 |
| 2011-03-14 05:29:00 | AAPL | Stock | 12.3879 | 12.3879 | 12.3879 | 12.3879 | 2800.0 |
| 2011-03-14 05:32:00 | AAPL | Stock | 12.3879 | 12.3879 | 12.3879 | 12.3879 | 2800.0 |
| 2011-03-14 05:42:00 | AAPL | Stock | 12.3786 | 12.3786 | 12.3786 | 12.3786 | 2800.0 |
| 2011-03-14 05:50:00 | AAPL | Stock | 12.4179 | 12.4214 | 12.4179 | 12.4214 | 25200.0 |
| 2011-03-14 05:51:00 | AAPL | Stock | 12.4214 | 12.4214 | 12.4214 | 12.4214 | 5600.0 |
| 2011-03-14 05:52:00 | AAPL | Stock | 12.4214 | 12.4214 | 12.4214 | 12.4214 | 19600.0 |
| 2011-03-14 05:53:00 | AAPL | Stock | 12.4214 | 12.4214 | 12.4214 | 12.4214 | 70364.0 |
| 2011-03-14 05:54:00 | AAPL | Stock | 12.4214 | 12.4214 | 12.4214 | 12.4214 | 2800.0 |
| 2011-03-14 05:55:00 | AAPL | Stock | 12.43 | 12.4321 | 12.43 | 12.4321 | 8400.0 |
| 2011-03-14 06:05:00 | AAPL | Stock | 12.4107 | 12.4107 | 12.4107 | 12.4107 | 2800.0 |
| 2011-03-14 06:08:00 | AAPL | Stock | 12.4436 | 12.4464 | 12.4436 | 12.4464 | 8400.0 |
| 2011-03-14 06:10:00 | AAPL | Stock | 12.4625 | 12.4714 | 12.4625 | 12.4714 | 8400.0 |
| 2011-03-14 06:15:00 | AAPL | Stock | 12.4821 | 12.4821 | 12.4821 | 12.4821 | 8400.0 |
| 2011-03-14 06:18:00 | AAPL | Stock | 12.4761 | 12.4761 | 12.4761 | 12.4761 | 2800.0 |
| 2011-03-14 06:20:00 | AAPL | Stock | 12.4796 | 12.4796 | 12.4796 | 12.4796 | 11200.0 |
| 2011-03-14 06:29:00 | AAPL | Stock | 12.4664 | 12.4679 | 12.4643 | 12.4643 | 16800.0 |
| 2011-03-14 06:46:00 | AAPL | Stock | 12.4629 | 12.4629 | 12.4629 | 12.4629 | 5600.0 |
| 2011-03-14 06:47:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4643 | 12.4643 | 5600.0 |
| 2011-03-14 06:48:00 | AAPL | Stock | 12.4661 | 12.4661 | 12.4661 | 12.4661 | 2800.0 |
| 2011-03-14 06:57:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4643 | 12.4643 | 5600.0 |
| 2011-03-14 07:00:00 | AAPL | Stock | 12.4682 | 12.4682 | 12.4682 | 12.4682 | 2800.0 |
| 2011-03-14 07:04:00 | AAPL | Stock | 12.4821 | 12.4821 | 12.4821 | 12.4821 | 2800.0 |
| 2011-03-14 07:05:00 | AAPL | Stock | 12.4821 | 12.4821 | 12.4821 | 12.4821 | 2800.0 |
| 2011-03-14 07:06:00 | AAPL | Stock | 12.4889 | 12.4889 | 12.4889 | 12.4889 | 14000.0 |
| 2011-03-14 07:07:00 | AAPL | Stock | 12.4879 | 12.4975 | 12.4879 | 12.4879 | 50960.0 |
| 2011-03-14 07:08:00 | AAPL | Stock | 12.505 | 12.5339 | 12.505 | 12.5189 | 42000.0 |
| 2011-03-14 07:10:00 | AAPL | Stock | 12.5089 | 12.5336 | 12.5089 | 12.5336 | 60760.0 |
| 2011-03-14 07:11:00 | AAPL | Stock | 12.5329 | 12.5329 | 12.5214 | 12.5214 | 16800.0 |
| 2011-03-14 07:13:00 | AAPL | Stock | 12.5214 | 12.5214 | 12.5214 | 12.5214 | 6440.0 |
| 2011-03-14 07:14:00 | AAPL | Stock | 12.5214 | 12.5214 | 12.5089 | 12.5089 | 13076.0 |
| 2011-03-14 07:16:00 | AAPL | Stock | 12.5211 | 12.5211 | 12.5211 | 12.5211 | 14000.0 |
| 2011-03-14 07:17:00 | AAPL | Stock | 12.5214 | 12.5214 | 12.5214 | 12.5214 | 27916.0 |
| 2011-03-14 07:18:00 | AAPL | Stock | 12.5214 | 12.5214 | 12.5107 | 12.5107 | 8400.0 |
| 2011-03-14 07:19:00 | AAPL | Stock | 12.5286 | 12.5336 | 12.5007 | 12.5007 | 102200.0 |
| 2011-03-14 07:20:00 | AAPL | Stock | 12.5 | 12.5007 | 12.5 | 12.5007 | 9800.0 |
> showing 50 of 1,002,565 rows — these rows as CSV