PREVIEW / stock_5min / 2011-03-30
file: by_date/stock_5min/2011/2011-03-30.parquet size: 4.9 MB rows: 327,720 symbols: 3,522
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-03-30 04:05:00 | AAPL | Stock | 12.6518 | 12.655 | 12.6518 | 12.655 | 8400.0 |
| 2011-03-30 04:10:00 | AAPL | Stock | 12.655 | 12.655 | 12.655 | 12.655 | 2800.0 |
| 2011-03-30 04:15:00 | AAPL | Stock | 12.6468 | 12.6468 | 12.6468 | 12.6468 | 5600.0 |
| 2011-03-30 04:30:00 | AAPL | Stock | 12.6429 | 12.6429 | 12.64 | 12.6429 | 19600.0 |
| 2011-03-30 04:45:00 | AAPL | Stock | 12.6304 | 12.6389 | 12.6304 | 12.6389 | 5600.0 |
| 2011-03-30 04:55:00 | AAPL | Stock | 12.6214 | 12.6214 | 12.6214 | 12.6214 | 2800.0 |
| 2011-03-30 05:10:00 | AAPL | Stock | 12.625 | 12.625 | 12.625 | 12.625 | 2800.0 |
| 2011-03-30 05:30:00 | AAPL | Stock | 12.6107 | 12.6107 | 12.6107 | 12.6107 | 2800.0 |
| 2011-03-30 05:35:00 | AAPL | Stock | 12.6143 | 12.6143 | 12.6143 | 12.6143 | 2800.0 |
| 2011-03-30 05:45:00 | AAPL | Stock | 12.6096 | 12.6096 | 12.6096 | 12.6096 | 2800.0 |
| 2011-03-30 06:20:00 | AAPL | Stock | 12.6096 | 12.6096 | 12.6096 | 12.6096 | 2800.0 |
| 2011-03-30 06:35:00 | AAPL | Stock | 12.6196 | 12.6221 | 12.6196 | 12.6196 | 14000.0 |
| 2011-03-30 06:40:00 | AAPL | Stock | 12.6125 | 12.6125 | 12.6107 | 12.6107 | 38136.0 |
| 2011-03-30 06:50:00 | AAPL | Stock | 12.6089 | 12.6089 | 12.6089 | 12.6089 | 2800.0 |
| 2011-03-30 07:00:00 | AAPL | Stock | 12.6204 | 12.6204 | 12.6 | 12.6054 | 14000.0 |
| 2011-03-30 07:05:00 | AAPL | Stock | 12.6071 | 12.6071 | 12.5946 | 12.5946 | 81200.0 |
| 2011-03-30 07:10:00 | AAPL | Stock | 12.5946 | 12.6071 | 12.5929 | 12.6029 | 115752.0 |
| 2011-03-30 07:15:00 | AAPL | Stock | 12.6029 | 12.6054 | 12.6004 | 12.6004 | 110600.0 |
| 2011-03-30 07:20:00 | AAPL | Stock | 12.5971 | 12.6036 | 12.5968 | 12.5968 | 31892.0 |
| 2011-03-30 07:25:00 | AAPL | Stock | 12.5968 | 12.6061 | 12.5968 | 12.6 | 101836.0 |
| 2011-03-30 07:30:00 | AAPL | Stock | 12.6 | 12.6036 | 12.5968 | 12.6032 | 89236.0 |
| 2011-03-30 07:35:00 | AAPL | Stock | 12.6036 | 12.6068 | 12.5975 | 12.6029 | 61600.0 |
| 2011-03-30 07:40:00 | AAPL | Stock | 12.6161 | 12.6161 | 12.6 | 12.6054 | 78540.0 |
| 2011-03-30 07:45:00 | AAPL | Stock | 12.6039 | 12.6071 | 12.6036 | 12.6039 | 95200.0 |
| 2011-03-30 07:50:00 | AAPL | Stock | 12.6054 | 12.6054 | 12.5607 | 12.5679 | 434084.0 |
| 2011-03-30 07:55:00 | AAPL | Stock | 12.5732 | 12.5854 | 12.5625 | 12.5854 | 309372.0 |
| 2011-03-30 08:00:00 | AAPL | Stock | 12.5764 | 12.5854 | 12.5357 | 12.5571 | 451976.0 |
| 2011-03-30 08:05:00 | AAPL | Stock | 12.5536 | 12.5632 | 12.55 | 12.5571 | 237272.0 |
| 2011-03-30 08:10:00 | AAPL | Stock | 12.5543 | 12.555 | 12.5396 | 12.54 | 388920.0 |
| 2011-03-30 08:15:00 | AAPL | Stock | 12.5425 | 12.5521 | 12.5171 | 12.5464 | 1047788.0 |
| 2011-03-30 08:20:00 | AAPL | Stock | 12.5393 | 12.5457 | 12.5289 | 12.5396 | 528976.0 |
| 2011-03-30 08:25:00 | AAPL | Stock | 12.5393 | 12.5429 | 12.5336 | 12.5386 | 270200.0 |
| 2011-03-30 08:30:00 | AAPL | Stock | 12.5357 | 12.5571 | 12.5357 | 12.5564 | 195776.0 |
| 2011-03-30 08:35:00 | AAPL | Stock | 12.555 | 12.5589 | 12.5536 | 12.5554 | 120876.0 |
| 2011-03-30 08:40:00 | AAPL | Stock | 12.5589 | 12.56 | 12.5489 | 12.5554 | 89040.0 |
| 2011-03-30 08:45:00 | AAPL | Stock | 12.5546 | 12.5564 | 12.5504 | 12.5507 | 125468.0 |
| 2011-03-30 08:50:00 | AAPL | Stock | 12.5507 | 12.5507 | 12.5382 | 12.5389 | 182784.0 |
| 2011-03-30 08:55:00 | AAPL | Stock | 12.5404 | 12.5404 | 12.5186 | 12.52 | 509376.0 |
| 2011-03-30 09:00:00 | AAPL | Stock | 12.5211 | 12.5325 | 12.5179 | 12.5179 | 494620.0 |
| 2011-03-30 09:05:00 | AAPL | Stock | 12.5146 | 12.5214 | 12.5146 | 12.5171 | 312088.0 |
| 2011-03-30 09:10:00 | AAPL | Stock | 12.5168 | 12.5186 | 12.5046 | 12.5111 | 406700.0 |
| 2011-03-30 09:15:00 | AAPL | Stock | 12.5093 | 12.5175 | 12.5054 | 12.5071 | 224336.0 |
| 2011-03-30 09:20:00 | AAPL | Stock | 12.5093 | 12.5104 | 12.4893 | 12.4893 | 993244.0 |
| 2011-03-30 09:25:00 | AAPL | Stock | 12.4996 | 12.5314 | 12.4936 | 12.5254 | 1376872.0 |
| 2011-03-30 09:30:00 | AAPL | Stock | 12.5254 | 12.5314 | 12.4764 | 12.4822 | 16315908.0 |
| 2011-03-30 09:35:00 | AAPL | Stock | 12.4823 | 12.485 | 12.4393 | 12.4618 | 16081772.0 |
| 2011-03-30 09:40:00 | AAPL | Stock | 12.4614 | 12.4725 | 12.4293 | 12.4307 | 11914616.0 |
| 2011-03-30 09:45:00 | AAPL | Stock | 12.4318 | 12.4504 | 12.4214 | 12.4471 | 16332064.0 |
| 2011-03-30 09:50:00 | AAPL | Stock | 12.4464 | 12.4671 | 12.444 | 12.4525 | 9632112.0 |
| 2011-03-30 09:55:00 | AAPL | Stock | 12.4525 | 12.4796 | 12.4518 | 12.4739 | 6832056.0 |
> showing 50 of 327,720 rows — these rows as CSV