PREVIEW / stock_5min / 2011-09-22
file: by_date/stock_5min/2011/2011-09-22.parquet size: 5.2 MB rows: 350,346 symbols: 3,542
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-09-22 04:00:00 | AAPL | Stock | 14.525 | 14.525 | 14.525 | 14.525 | 2800.0 |
| 2011-09-22 04:05:00 | AAPL | Stock | 14.5 | 14.5 | 14.4643 | 14.4643 | 44296.0 |
| 2011-09-22 04:20:00 | AAPL | Stock | 14.5304 | 14.5304 | 14.5275 | 14.5275 | 5600.0 |
| 2011-09-22 04:25:00 | AAPL | Stock | 14.5329 | 14.5386 | 14.5296 | 14.5296 | 8400.0 |
| 2011-09-22 04:30:00 | AAPL | Stock | 14.5196 | 14.5196 | 14.5196 | 14.5196 | 2800.0 |
| 2011-09-22 04:40:00 | AAPL | Stock | 14.5 | 14.5 | 14.5 | 14.5 | 2800.0 |
| 2011-09-22 04:45:00 | AAPL | Stock | 14.4954 | 14.4954 | 14.4946 | 14.4946 | 5600.0 |
| 2011-09-22 04:50:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 7700.0 |
| 2011-09-22 04:55:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.4896 | 14.4896 | 8400.0 |
| 2011-09-22 05:00:00 | AAPL | Stock | 14.4893 | 14.4893 | 14.4821 | 14.4821 | 14000.0 |
| 2011-09-22 05:10:00 | AAPL | Stock | 14.4857 | 14.4857 | 14.4821 | 14.4821 | 14000.0 |
| 2011-09-22 05:15:00 | AAPL | Stock | 14.4836 | 14.4836 | 14.4643 | 14.4643 | 16800.0 |
| 2011-09-22 05:20:00 | AAPL | Stock | 14.4725 | 14.4764 | 14.4643 | 14.4679 | 53200.0 |
| 2011-09-22 05:25:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4643 | 14.4643 | 2800.0 |
| 2011-09-22 05:30:00 | AAPL | Stock | 14.4679 | 14.4821 | 14.4679 | 14.4821 | 5600.0 |
| 2011-09-22 05:40:00 | AAPL | Stock | 14.4846 | 14.4868 | 14.4846 | 14.4868 | 5600.0 |
| 2011-09-22 05:45:00 | AAPL | Stock | 14.4821 | 14.4893 | 14.4821 | 14.4893 | 5600.0 |
| 2011-09-22 05:50:00 | AAPL | Stock | 14.4821 | 14.4893 | 14.4821 | 14.4821 | 19600.0 |
| 2011-09-22 05:55:00 | AAPL | Stock | 14.4757 | 14.4757 | 14.4757 | 14.4757 | 2800.0 |
| 2011-09-22 06:00:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4643 | 14.4643 | 5600.0 |
| 2011-09-22 06:05:00 | AAPL | Stock | 14.4682 | 14.4682 | 14.4682 | 14.4682 | 2800.0 |
| 2011-09-22 06:10:00 | AAPL | Stock | 14.4679 | 14.4679 | 14.4643 | 14.4643 | 8400.0 |
| 2011-09-22 06:20:00 | AAPL | Stock | 14.4882 | 14.4882 | 14.4882 | 14.4882 | 2800.0 |
| 2011-09-22 06:25:00 | AAPL | Stock | 14.4732 | 14.5107 | 14.4732 | 14.5107 | 8400.0 |
| 2011-09-22 06:30:00 | AAPL | Stock | 14.4929 | 14.4929 | 14.4929 | 14.4929 | 2800.0 |
| 2011-09-22 06:35:00 | AAPL | Stock | 14.4821 | 14.4893 | 14.4643 | 14.4643 | 42000.0 |
| 2011-09-22 06:40:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4386 | 14.44 | 33600.0 |
| 2011-09-22 06:45:00 | AAPL | Stock | 14.4386 | 14.4529 | 14.4386 | 14.4529 | 22400.0 |
| 2011-09-22 06:50:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4643 | 14.4643 | 12600.0 |
| 2011-09-22 06:55:00 | AAPL | Stock | 14.4529 | 14.4529 | 14.4286 | 14.4286 | 60116.0 |
| 2011-09-22 07:00:00 | AAPL | Stock | 14.4286 | 14.4679 | 14.4239 | 14.4357 | 182168.0 |
| 2011-09-22 07:05:00 | AAPL | Stock | 14.4461 | 14.4639 | 14.4379 | 14.4639 | 104244.0 |
| 2011-09-22 07:10:00 | AAPL | Stock | 14.4607 | 14.4607 | 14.4343 | 14.4464 | 207452.0 |
| 2011-09-22 07:15:00 | AAPL | Stock | 14.4464 | 14.4507 | 14.4357 | 14.4393 | 78400.0 |
| 2011-09-22 07:20:00 | AAPL | Stock | 14.4393 | 14.4536 | 14.4393 | 14.4464 | 139720.0 |
| 2011-09-22 07:25:00 | AAPL | Stock | 14.4461 | 14.4529 | 14.4393 | 14.4471 | 131600.0 |
| 2011-09-22 07:30:00 | AAPL | Stock | 14.4511 | 14.4604 | 14.4393 | 14.4393 | 294420.0 |
| 2011-09-22 07:35:00 | AAPL | Stock | 14.4446 | 14.4546 | 14.4357 | 14.4454 | 266308.0 |
| 2011-09-22 07:40:00 | AAPL | Stock | 14.4361 | 14.4821 | 14.4357 | 14.4579 | 201124.0 |
| 2011-09-22 07:45:00 | AAPL | Stock | 14.4711 | 14.5 | 14.4711 | 14.4861 | 272440.0 |
| 2011-09-22 07:50:00 | AAPL | Stock | 14.4861 | 14.5179 | 14.4821 | 14.5118 | 274568.0 |
| 2011-09-22 07:55:00 | AAPL | Stock | 14.5157 | 14.5161 | 14.5 | 14.5089 | 189952.0 |
| 2011-09-22 08:00:00 | AAPL | Stock | 14.5079 | 14.5246 | 14.45 | 14.5179 | 869932.0 |
| 2011-09-22 08:05:00 | AAPL | Stock | 14.5193 | 14.5304 | 14.5132 | 14.5239 | 313488.0 |
| 2011-09-22 08:10:00 | AAPL | Stock | 14.5239 | 14.5511 | 14.5043 | 14.5271 | 997556.0 |
| 2011-09-22 08:15:00 | AAPL | Stock | 14.5314 | 14.5429 | 14.5271 | 14.5393 | 482356.0 |
| 2011-09-22 08:20:00 | AAPL | Stock | 14.5389 | 14.5418 | 14.5121 | 14.5136 | 527968.0 |
| 2011-09-22 08:25:00 | AAPL | Stock | 14.5175 | 14.5536 | 14.5154 | 14.5279 | 1019004.0 |
| 2011-09-22 08:30:00 | AAPL | Stock | 14.5311 | 14.5357 | 14.5 | 14.5161 | 403368.0 |
| 2011-09-22 08:35:00 | AAPL | Stock | 14.5054 | 14.5054 | 14.4657 | 14.4682 | 910896.0 |
> showing 50 of 350,346 rows — these rows as CSV