PREVIEW / stock_1min / 2012-03-01
file: by_date/stock_1min/2012/2012-03-01.parquet size: 13.6 MB rows: 1,019,264 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 |
|---|---|---|---|---|---|---|---|
| 2012-03-01 04:00:00 | AAPL | Stock | 19.4286 | 19.4654 | 19.4286 | 19.4654 | 12040.0 |
| 2012-03-01 04:01:00 | AAPL | Stock | 19.4632 | 19.4632 | 19.4632 | 19.4632 | 2800.0 |
| 2012-03-01 04:02:00 | AAPL | Stock | 19.4621 | 19.4621 | 19.4607 | 19.4607 | 16800.0 |
| 2012-03-01 04:03:00 | AAPL | Stock | 19.4611 | 19.4611 | 19.4586 | 19.4586 | 14000.0 |
| 2012-03-01 04:04:00 | AAPL | Stock | 19.4614 | 19.4614 | 19.4589 | 19.4589 | 11200.0 |
| 2012-03-01 04:05:00 | AAPL | Stock | 19.4643 | 19.4643 | 19.4643 | 19.4643 | 2800.0 |
| 2012-03-01 04:07:00 | AAPL | Stock | 19.4643 | 19.4643 | 19.4643 | 19.4643 | 5600.0 |
| 2012-03-01 04:13:00 | AAPL | Stock | 19.475 | 19.475 | 19.475 | 19.475 | 8400.0 |
| 2012-03-01 04:15:00 | AAPL | Stock | 19.4732 | 19.4732 | 19.4732 | 19.4732 | 25200.0 |
| 2012-03-01 04:16:00 | AAPL | Stock | 19.4714 | 19.4732 | 19.4714 | 19.4732 | 11200.0 |
| 2012-03-01 04:17:00 | AAPL | Stock | 19.4732 | 19.4732 | 19.4732 | 19.4732 | 5600.0 |
| 2012-03-01 04:18:00 | AAPL | Stock | 19.4643 | 19.4643 | 19.4643 | 19.4643 | 2800.0 |
| 2012-03-01 04:19:00 | AAPL | Stock | 19.4732 | 19.4732 | 19.4643 | 19.4679 | 11200.0 |
| 2012-03-01 04:20:00 | AAPL | Stock | 19.4689 | 19.475 | 19.4689 | 19.475 | 10780.0 |
| 2012-03-01 04:21:00 | AAPL | Stock | 19.4768 | 19.4768 | 19.4768 | 19.4768 | 3780.0 |
| 2012-03-01 04:25:00 | AAPL | Stock | 19.4957 | 19.4957 | 19.4957 | 19.4957 | 5180.0 |
| 2012-03-01 04:26:00 | AAPL | Stock | 19.4957 | 19.4957 | 19.4957 | 19.4957 | 5600.0 |
| 2012-03-01 04:31:00 | AAPL | Stock | 19.5107 | 19.5107 | 19.5107 | 19.5107 | 2800.0 |
| 2012-03-01 04:32:00 | AAPL | Stock | 19.5 | 19.5 | 19.5 | 19.5 | 4480.0 |
| 2012-03-01 04:33:00 | AAPL | Stock | 19.5 | 19.5 | 19.5 | 19.5 | 8820.0 |
| 2012-03-01 04:40:00 | AAPL | Stock | 19.5 | 19.5 | 19.5 | 19.5 | 18200.0 |
| 2012-03-01 04:48:00 | AAPL | Stock | 19.4643 | 19.4643 | 19.4643 | 19.4643 | 2800.0 |
| 2012-03-01 04:49:00 | AAPL | Stock | 19.4643 | 19.4643 | 19.4643 | 19.4643 | 2800.0 |
| 2012-03-01 04:50:00 | AAPL | Stock | 19.4671 | 19.4671 | 19.4671 | 19.4671 | 2800.0 |
| 2012-03-01 05:02:00 | AAPL | Stock | 19.5 | 19.5 | 19.5 | 19.5 | 2800.0 |
| 2012-03-01 05:09:00 | AAPL | Stock | 19.4929 | 19.4929 | 19.4929 | 19.4929 | 14000.0 |
| 2012-03-01 05:21:00 | AAPL | Stock | 19.4996 | 19.4996 | 19.4996 | 19.4996 | 2800.0 |
| 2012-03-01 05:23:00 | AAPL | Stock | 19.5161 | 19.5179 | 19.5161 | 19.5179 | 5600.0 |
| 2012-03-01 05:25:00 | AAPL | Stock | 19.4829 | 19.4829 | 19.4821 | 19.4821 | 10276.0 |
| 2012-03-01 05:37:00 | AAPL | Stock | 19.4964 | 19.4964 | 19.4964 | 19.4964 | 11200.0 |
| 2012-03-01 05:41:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 28000.0 |
| 2012-03-01 05:42:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 28000.0 |
| 2012-03-01 05:43:00 | AAPL | Stock | 19.4789 | 19.4821 | 19.4789 | 19.4821 | 16800.0 |
| 2012-03-01 05:44:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 5600.0 |
| 2012-03-01 05:47:00 | AAPL | Stock | 19.4786 | 19.4786 | 19.4786 | 19.4786 | 2800.0 |
| 2012-03-01 05:49:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 8400.0 |
| 2012-03-01 05:56:00 | AAPL | Stock | 19.4786 | 19.4786 | 19.4786 | 19.4786 | 2800.0 |
| 2012-03-01 05:57:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 2800.0 |
| 2012-03-01 06:01:00 | AAPL | Stock | 19.4786 | 19.4786 | 19.4786 | 19.4786 | 5600.0 |
| 2012-03-01 06:02:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 2800.0 |
| 2012-03-01 06:03:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 5600.0 |
| 2012-03-01 06:04:00 | AAPL | Stock | 19.4811 | 19.4821 | 19.4811 | 19.4821 | 13580.0 |
| 2012-03-01 06:20:00 | AAPL | Stock | 19.5 | 19.5 | 19.5 | 19.5 | 2800.0 |
| 2012-03-01 06:24:00 | AAPL | Stock | 19.5 | 19.5 | 19.5 | 19.5 | 2800.0 |
| 2012-03-01 06:25:00 | AAPL | Stock | 19.4893 | 19.4893 | 19.4893 | 19.4893 | 14000.0 |
| 2012-03-01 06:27:00 | AAPL | Stock | 19.4807 | 19.4807 | 19.4793 | 19.4793 | 8400.0 |
| 2012-03-01 06:28:00 | AAPL | Stock | 19.4893 | 19.4893 | 19.4893 | 19.4893 | 5600.0 |
| 2012-03-01 06:47:00 | AAPL | Stock | 19.4929 | 19.4929 | 19.4929 | 19.4929 | 13300.0 |
| 2012-03-01 06:50:00 | AAPL | Stock | 19.4929 | 19.4929 | 19.4929 | 19.4929 | 2800.0 |
| 2012-03-01 06:51:00 | AAPL | Stock | 19.4929 | 19.4929 | 19.4929 | 19.4929 | 2800.0 |
> showing 50 of 1,019,264 rows — these rows as CSV