PREVIEW / stock_5min / 2012-03-01
file: by_date/stock_5min/2012/2012-03-01.parquet size: 4.9 MB rows: 333,966 symbols: 3,517
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.4589 | 56840.0 |
| 2012-03-01 04:05:00 | AAPL | Stock | 19.4643 | 19.4643 | 19.4643 | 19.4643 | 8400.0 |
| 2012-03-01 04:10: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.4643 | 19.4679 | 56000.0 |
| 2012-03-01 04:20:00 | AAPL | Stock | 19.4689 | 19.4768 | 19.4689 | 19.4768 | 14560.0 |
| 2012-03-01 04:25:00 | AAPL | Stock | 19.4957 | 19.4957 | 19.4957 | 19.4957 | 10780.0 |
| 2012-03-01 04:30:00 | AAPL | Stock | 19.5107 | 19.5107 | 19.5 | 19.5 | 16100.0 |
| 2012-03-01 04:40:00 | AAPL | Stock | 19.5 | 19.5 | 19.5 | 19.5 | 18200.0 |
| 2012-03-01 04:45:00 | AAPL | Stock | 19.4643 | 19.4643 | 19.4643 | 19.4643 | 5600.0 |
| 2012-03-01 04:50:00 | AAPL | Stock | 19.4671 | 19.4671 | 19.4671 | 19.4671 | 2800.0 |
| 2012-03-01 05:00:00 | AAPL | Stock | 19.5 | 19.5 | 19.5 | 19.5 | 2800.0 |
| 2012-03-01 05:05:00 | AAPL | Stock | 19.4929 | 19.4929 | 19.4929 | 19.4929 | 14000.0 |
| 2012-03-01 05:20:00 | AAPL | Stock | 19.4996 | 19.5179 | 19.4996 | 19.5179 | 8400.0 |
| 2012-03-01 05:25:00 | AAPL | Stock | 19.4829 | 19.4829 | 19.4821 | 19.4821 | 10276.0 |
| 2012-03-01 05:35:00 | AAPL | Stock | 19.4964 | 19.4964 | 19.4964 | 19.4964 | 11200.0 |
| 2012-03-01 05:40:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4789 | 19.4821 | 78400.0 |
| 2012-03-01 05:45:00 | AAPL | Stock | 19.4786 | 19.4821 | 19.4786 | 19.4821 | 11200.0 |
| 2012-03-01 05:55:00 | AAPL | Stock | 19.4786 | 19.4821 | 19.4786 | 19.4821 | 5600.0 |
| 2012-03-01 06:00:00 | AAPL | Stock | 19.4786 | 19.4821 | 19.4786 | 19.4821 | 27580.0 |
| 2012-03-01 06:20:00 | AAPL | Stock | 19.5 | 19.5 | 19.5 | 19.5 | 5600.0 |
| 2012-03-01 06:25:00 | AAPL | Stock | 19.4893 | 19.4893 | 19.4793 | 19.4893 | 28000.0 |
| 2012-03-01 06:45: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 | 5600.0 |
| 2012-03-01 06:55:00 | AAPL | Stock | 19.4911 | 19.4911 | 19.4893 | 19.4893 | 20300.0 |
| 2012-03-01 07:00:00 | AAPL | Stock | 19.4821 | 19.4911 | 19.4754 | 19.4911 | 118384.0 |
| 2012-03-01 07:05:00 | AAPL | Stock | 19.4814 | 19.4882 | 19.4814 | 19.4821 | 91840.0 |
| 2012-03-01 07:10:00 | AAPL | Stock | 19.4793 | 19.4929 | 19.4793 | 19.4929 | 39200.0 |
| 2012-03-01 07:15:00 | AAPL | Stock | 19.4929 | 19.5004 | 19.4921 | 19.4996 | 67200.0 |
| 2012-03-01 07:20:00 | AAPL | Stock | 19.4989 | 19.5118 | 19.4989 | 19.5 | 110152.0 |
| 2012-03-01 07:25:00 | AAPL | Stock | 19.5096 | 19.5096 | 19.4857 | 19.4857 | 50540.0 |
| 2012-03-01 07:30:00 | AAPL | Stock | 19.4893 | 19.4893 | 19.46 | 19.4711 | 115024.0 |
| 2012-03-01 07:35:00 | AAPL | Stock | 19.4732 | 19.4732 | 19.4393 | 19.4489 | 118300.0 |
| 2012-03-01 07:40:00 | AAPL | Stock | 19.4496 | 19.46 | 19.4464 | 19.46 | 67200.0 |
| 2012-03-01 07:45:00 | AAPL | Stock | 19.4604 | 19.48 | 19.4604 | 19.4643 | 137900.0 |
| 2012-03-01 07:50:00 | AAPL | Stock | 19.475 | 19.475 | 19.4689 | 19.475 | 16800.0 |
| 2012-03-01 07:55:00 | AAPL | Stock | 19.4754 | 19.4857 | 19.4754 | 19.4839 | 182672.0 |
| 2012-03-01 08:00:00 | AAPL | Stock | 19.4786 | 19.5125 | 19.4643 | 19.4964 | 1120168.0 |
| 2012-03-01 08:05:00 | AAPL | Stock | 19.5 | 19.5046 | 19.4839 | 19.5046 | 589736.0 |
| 2012-03-01 08:10:00 | AAPL | Stock | 19.5011 | 19.5036 | 19.4896 | 19.5 | 472808.0 |
| 2012-03-01 08:15:00 | AAPL | Stock | 19.4996 | 19.5071 | 19.4996 | 19.5054 | 277788.0 |
| 2012-03-01 08:20:00 | AAPL | Stock | 19.5068 | 19.5107 | 19.5025 | 19.5071 | 422660.0 |
| 2012-03-01 08:25:00 | AAPL | Stock | 19.5075 | 19.5243 | 19.5064 | 19.5193 | 471632.0 |
| 2012-03-01 08:30:00 | AAPL | Stock | 19.5196 | 19.5346 | 19.5036 | 19.5182 | 959308.0 |
| 2012-03-01 08:35:00 | AAPL | Stock | 19.5179 | 19.5357 | 19.5179 | 19.5182 | 835184.0 |
| 2012-03-01 08:40:00 | AAPL | Stock | 19.5179 | 19.5286 | 19.5075 | 19.5168 | 492268.0 |
| 2012-03-01 08:45:00 | AAPL | Stock | 19.5225 | 19.525 | 19.4925 | 19.4929 | 880180.0 |
| 2012-03-01 08:50:00 | AAPL | Stock | 19.4964 | 19.5225 | 19.4929 | 19.5171 | 839440.0 |
| 2012-03-01 08:55:00 | AAPL | Stock | 19.5189 | 19.5314 | 19.5136 | 19.5314 | 342272.0 |
| 2012-03-01 09:00:00 | AAPL | Stock | 19.5257 | 19.5482 | 19.5196 | 19.5396 | 816760.0 |
| 2012-03-01 09:05:00 | AAPL | Stock | 19.545 | 19.5582 | 19.54 | 19.5429 | 819532.0 |
> showing 50 of 333,966 rows — these rows as CSV