PREVIEW / stock_5min / 2013-03-12
file: by_date/stock_5min/2013/2013-03-12.parquet size: 4.9 MB rows: 332,614 symbols: 3,465
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-03-12 04:25:00 | AAPL | Stock | 15.5382 | 15.5382 | 15.5382 | 15.5382 | 2800.0 |
| 2013-03-12 05:00:00 | AAPL | Stock | 15.5625 | 15.5625 | 15.5625 | 15.5625 | 2800.0 |
| 2013-03-12 05:05:00 | AAPL | Stock | 15.5625 | 15.5625 | 15.5625 | 15.5625 | 2800.0 |
| 2013-03-12 05:10:00 | AAPL | Stock | 15.555 | 15.555 | 15.5539 | 15.5539 | 12600.0 |
| 2013-03-12 05:15:00 | AAPL | Stock | 15.5786 | 15.5786 | 15.5786 | 15.5786 | 4200.0 |
| 2013-03-12 05:20:00 | AAPL | Stock | 15.555 | 15.555 | 15.5543 | 15.5543 | 14000.0 |
| 2013-03-12 05:25:00 | AAPL | Stock | 15.5707 | 15.5707 | 15.5707 | 15.5707 | 2800.0 |
| 2013-03-12 05:30:00 | AAPL | Stock | 15.5893 | 15.5893 | 15.5893 | 15.5893 | 2800.0 |
| 2013-03-12 05:45:00 | AAPL | Stock | 15.5607 | 15.5607 | 15.5607 | 15.5607 | 2800.0 |
| 2013-03-12 05:55:00 | AAPL | Stock | 15.5604 | 15.5604 | 15.5604 | 15.5604 | 2800.0 |
| 2013-03-12 06:15:00 | AAPL | Stock | 15.5875 | 15.5879 | 15.5875 | 15.5879 | 5600.0 |
| 2013-03-12 06:20:00 | AAPL | Stock | 15.5889 | 15.5893 | 15.5889 | 15.5893 | 5600.0 |
| 2013-03-12 06:25:00 | AAPL | Stock | 15.5721 | 15.5721 | 15.5721 | 15.5721 | 8400.0 |
| 2013-03-12 06:35:00 | AAPL | Stock | 15.5893 | 15.5893 | 15.5893 | 15.5893 | 2800.0 |
| 2013-03-12 06:45:00 | AAPL | Stock | 15.5804 | 15.5857 | 15.5804 | 15.5857 | 5600.0 |
| 2013-03-12 07:00:00 | AAPL | Stock | 15.5854 | 15.5857 | 15.5821 | 15.5854 | 21280.0 |
| 2013-03-12 07:05:00 | AAPL | Stock | 15.5854 | 15.5854 | 15.5589 | 15.5589 | 39004.0 |
| 2013-03-12 07:10:00 | AAPL | Stock | 15.5571 | 15.5571 | 15.5268 | 15.5354 | 80416.0 |
| 2013-03-12 07:15:00 | AAPL | Stock | 15.5357 | 15.5357 | 15.5179 | 15.5179 | 26488.0 |
| 2013-03-12 07:20:00 | AAPL | Stock | 15.5018 | 15.5179 | 15.4993 | 15.5179 | 60816.0 |
| 2013-03-12 07:25:00 | AAPL | Stock | 15.5243 | 15.5464 | 15.5243 | 15.525 | 56000.0 |
| 2013-03-12 07:30:00 | AAPL | Stock | 15.525 | 15.535 | 15.5214 | 15.535 | 19600.0 |
| 2013-03-12 07:35:00 | AAPL | Stock | 15.5257 | 15.5464 | 15.5257 | 15.535 | 40208.0 |
| 2013-03-12 07:40:00 | AAPL | Stock | 15.5461 | 15.5514 | 15.5461 | 15.5514 | 11200.0 |
| 2013-03-12 07:45:00 | AAPL | Stock | 15.5521 | 15.5536 | 15.5436 | 15.5489 | 67844.0 |
| 2013-03-12 07:50:00 | AAPL | Stock | 15.5268 | 15.5436 | 15.4714 | 15.4836 | 152824.0 |
| 2013-03-12 07:55:00 | AAPL | Stock | 15.4943 | 15.5089 | 15.4679 | 15.4696 | 256396.0 |
| 2013-03-12 08:00:00 | AAPL | Stock | 15.4925 | 15.6068 | 15.4925 | 15.5186 | 448588.0 |
| 2013-03-12 08:05:00 | AAPL | Stock | 15.5089 | 15.5179 | 15.4982 | 15.5075 | 211932.0 |
| 2013-03-12 08:10:00 | AAPL | Stock | 15.5164 | 15.5171 | 15.4861 | 15.51 | 135660.0 |
| 2013-03-12 08:15:00 | AAPL | Stock | 15.5 | 15.5179 | 15.5 | 15.5179 | 97636.0 |
| 2013-03-12 08:20:00 | AAPL | Stock | 15.5179 | 15.5254 | 15.5125 | 15.5125 | 57876.0 |
| 2013-03-12 08:25:00 | AAPL | Stock | 15.5018 | 15.5175 | 15.5018 | 15.5071 | 173292.0 |
| 2013-03-12 08:30:00 | AAPL | Stock | 15.5071 | 15.5143 | 15.5 | 15.5007 | 398104.0 |
| 2013-03-12 08:35:00 | AAPL | Stock | 15.5125 | 15.5282 | 15.5057 | 15.5268 | 157248.0 |
| 2013-03-12 08:40:00 | AAPL | Stock | 15.52 | 15.5339 | 15.52 | 15.5289 | 176120.0 |
| 2013-03-12 08:45:00 | AAPL | Stock | 15.5321 | 15.5464 | 15.5246 | 15.5339 | 333256.0 |
| 2013-03-12 08:50:00 | AAPL | Stock | 15.5354 | 15.5357 | 15.5111 | 15.5111 | 204596.0 |
| 2013-03-12 08:55:00 | AAPL | Stock | 15.5136 | 15.5139 | 15.4993 | 15.5057 | 318948.0 |
| 2013-03-12 09:00:00 | AAPL | Stock | 15.5104 | 15.5343 | 15.5089 | 15.5279 | 222600.0 |
| 2013-03-12 09:05:00 | AAPL | Stock | 15.5229 | 15.5293 | 15.5071 | 15.5089 | 160944.0 |
| 2013-03-12 09:10:00 | AAPL | Stock | 15.5071 | 15.5189 | 15.4821 | 15.4961 | 554568.0 |
| 2013-03-12 09:15:00 | AAPL | Stock | 15.4982 | 15.5 | 15.4875 | 15.5 | 296408.0 |
| 2013-03-12 09:20:00 | AAPL | Stock | 15.5 | 15.5107 | 15.5 | 15.5107 | 219912.0 |
| 2013-03-12 09:25:00 | AAPL | Stock | 15.5057 | 15.5704 | 15.5057 | 15.5643 | 1699236.0 |
| 2013-03-12 09:30:00 | AAPL | Stock | 15.5571 | 15.6071 | 15.4821 | 15.5136 | 22723260.0 |
| 2013-03-12 09:35:00 | AAPL | Stock | 15.5139 | 15.6161 | 15.5032 | 15.5664 | 14902412.0 |
| 2013-03-12 09:40:00 | AAPL | Stock | 15.5704 | 15.6307 | 15.55 | 15.575 | 10216920.0 |
| 2013-03-12 09:45:00 | AAPL | Stock | 15.58 | 15.6507 | 15.5546 | 15.6446 | 10442040.0 |
| 2013-03-12 09:50:00 | AAPL | Stock | 15.6423 | 15.6743 | 15.6157 | 15.6307 | 13669936.0 |
> showing 50 of 332,614 rows — these rows as CSV