PREVIEW / stock_5min / 2013-01-03
file: by_date/stock_5min/2013/2013-01-03.parquet size: 4.9 MB rows: 326,254 symbols: 3,476
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 |
|---|---|---|---|---|---|---|---|
| 2013-01-03 04:05:00 | AAPL | Stock | 19.6086 | 19.6086 | 19.6086 | 19.6086 | 2800.0 |
| 2013-01-03 04:10:00 | AAPL | Stock | 19.6036 | 19.6071 | 19.6036 | 19.6071 | 15344.0 |
| 2013-01-03 04:15:00 | AAPL | Stock | 19.6032 | 19.6032 | 19.6032 | 19.6032 | 2800.0 |
| 2013-01-03 04:45:00 | AAPL | Stock | 19.5636 | 19.5636 | 19.5636 | 19.5636 | 7000.0 |
| 2013-01-03 04:50:00 | AAPL | Stock | 19.5643 | 19.5643 | 19.5643 | 19.5643 | 2800.0 |
| 2013-01-03 05:45:00 | AAPL | Stock | 19.5218 | 19.5218 | 19.5218 | 19.5218 | 2800.0 |
| 2013-01-03 05:55:00 | AAPL | Stock | 19.5257 | 19.5257 | 19.5257 | 19.5257 | 2800.0 |
| 2013-01-03 06:00:00 | AAPL | Stock | 19.5004 | 19.5004 | 19.5004 | 19.5004 | 6972.0 |
| 2013-01-03 06:05:00 | AAPL | Stock | 19.5254 | 19.5254 | 19.5254 | 19.5254 | 14000.0 |
| 2013-01-03 06:55:00 | AAPL | Stock | 19.5386 | 19.5386 | 19.5386 | 19.5386 | 2800.0 |
| 2013-01-03 07:05:00 | AAPL | Stock | 19.5389 | 19.5389 | 19.5386 | 19.5386 | 29400.0 |
| 2013-01-03 07:10:00 | AAPL | Stock | 19.5296 | 19.5296 | 19.5036 | 19.5036 | 19600.0 |
| 2013-01-03 07:15:00 | AAPL | Stock | 19.5036 | 19.5107 | 19.5 | 19.5107 | 30520.0 |
| 2013-01-03 07:20:00 | AAPL | Stock | 19.5321 | 19.5321 | 19.5321 | 19.5321 | 2800.0 |
| 2013-01-03 07:25:00 | AAPL | Stock | 19.5186 | 19.5186 | 19.5186 | 19.5186 | 19600.0 |
| 2013-01-03 07:30:00 | AAPL | Stock | 19.5321 | 19.5321 | 19.5193 | 19.5193 | 5600.0 |
| 2013-01-03 07:40:00 | AAPL | Stock | 19.5111 | 19.5114 | 19.5 | 19.5007 | 28000.0 |
| 2013-01-03 07:45:00 | AAPL | Stock | 19.5111 | 19.5193 | 19.5007 | 19.5007 | 193200.0 |
| 2013-01-03 07:50:00 | AAPL | Stock | 19.4954 | 19.5 | 19.4954 | 19.4989 | 113708.0 |
| 2013-01-03 07:55:00 | AAPL | Stock | 19.4996 | 19.5 | 19.4996 | 19.5 | 5600.0 |
| 2013-01-03 08:00:00 | AAPL | Stock | 19.5 | 19.5229 | 19.4854 | 19.5021 | 214480.0 |
| 2013-01-03 08:05:00 | AAPL | Stock | 19.5018 | 19.5018 | 19.4861 | 19.4929 | 94080.0 |
| 2013-01-03 08:10:00 | AAPL | Stock | 19.4893 | 19.4893 | 19.4821 | 19.4821 | 25900.0 |
| 2013-01-03 08:15:00 | AAPL | Stock | 19.4993 | 19.6082 | 19.4821 | 19.5179 | 176904.0 |
| 2013-01-03 08:20:00 | AAPL | Stock | 19.5129 | 19.5179 | 19.4964 | 19.4964 | 301980.0 |
| 2013-01-03 08:25:00 | AAPL | Stock | 19.5089 | 19.5089 | 19.4882 | 19.5 | 155400.0 |
| 2013-01-03 08:30:00 | AAPL | Stock | 19.4921 | 19.5179 | 19.4921 | 19.505 | 122024.0 |
| 2013-01-03 08:35:00 | AAPL | Stock | 19.5139 | 19.5143 | 19.4914 | 19.4914 | 99120.0 |
| 2013-01-03 08:40:00 | AAPL | Stock | 19.4993 | 19.5 | 19.4911 | 19.4986 | 159600.0 |
| 2013-01-03 08:45:00 | AAPL | Stock | 19.5 | 19.5154 | 19.4929 | 19.5143 | 132300.0 |
| 2013-01-03 08:50:00 | AAPL | Stock | 19.5139 | 19.5179 | 19.5082 | 19.5143 | 101892.0 |
| 2013-01-03 08:55:00 | AAPL | Stock | 19.5157 | 19.5439 | 19.5143 | 19.5439 | 196196.0 |
| 2013-01-03 09:00:00 | AAPL | Stock | 19.5361 | 19.5393 | 19.5189 | 19.5261 | 61600.0 |
| 2013-01-03 09:05:00 | AAPL | Stock | 19.5271 | 19.5357 | 19.5193 | 19.5193 | 50680.0 |
| 2013-01-03 09:10:00 | AAPL | Stock | 19.5211 | 19.5321 | 19.52 | 19.5321 | 57372.0 |
| 2013-01-03 09:15:00 | AAPL | Stock | 19.5246 | 19.5289 | 19.4821 | 19.4925 | 329196.0 |
| 2013-01-03 09:20:00 | AAPL | Stock | 19.4929 | 19.5 | 19.4911 | 19.5 | 200060.0 |
| 2013-01-03 09:25:00 | AAPL | Stock | 19.52 | 19.5739 | 19.5004 | 19.5625 | 1067080.0 |
| 2013-01-03 09:30:00 | AAPL | Stock | 19.5654 | 19.5704 | 19.455 | 19.4682 | 16809128.0 |
| 2013-01-03 09:35:00 | AAPL | Stock | 19.4657 | 19.4714 | 19.4143 | 19.4425 | 10315900.0 |
| 2013-01-03 09:40:00 | AAPL | Stock | 19.4421 | 19.4946 | 19.4304 | 19.4804 | 7521472.0 |
| 2013-01-03 09:45:00 | AAPL | Stock | 19.4761 | 19.5214 | 19.4682 | 19.47 | 7980448.0 |
| 2013-01-03 09:50:00 | AAPL | Stock | 19.4668 | 19.5393 | 19.4489 | 19.5234 | 8260364.0 |
| 2013-01-03 09:55:00 | AAPL | Stock | 19.5246 | 19.5936 | 19.5143 | 19.5804 | 9731540.0 |
| 2013-01-03 10:00:00 | AAPL | Stock | 19.5804 | 19.5914 | 19.5357 | 19.555 | 6532876.0 |
| 2013-01-03 10:05:00 | AAPL | Stock | 19.555 | 19.6311 | 19.5407 | 19.6214 | 8556184.0 |
| 2013-01-03 10:10:00 | AAPL | Stock | 19.6175 | 19.6246 | 19.5925 | 19.598 | 6253268.0 |
| 2013-01-03 10:15:00 | AAPL | Stock | 19.5946 | 19.6089 | 19.5271 | 19.5464 | 7299908.0 |
| 2013-01-03 10:20:00 | AAPL | Stock | 19.5464 | 19.5757 | 19.5389 | 19.5632 | 3859100.0 |
| 2013-01-03 10:25:00 | AAPL | Stock | 19.5611 | 19.575 | 19.5436 | 19.5561 | 2819488.0 |
> showing 50 of 326,254 rows — these rows as CSV