PREVIEW / stock_5min / 2013-08-08
file: by_date/stock_5min/2013/2013-08-08.parquet size: 5.1 MB rows: 336,153 symbols: 3,514
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-08-08 04:00:00 | AAPL | Stock | 16.5679 | 16.5679 | 16.5679 | 16.5679 | 10640.0 |
| 2013-08-08 04:15:00 | AAPL | Stock | 16.5679 | 16.5679 | 16.5679 | 16.5679 | 2800.0 |
| 2013-08-08 04:55:00 | AAPL | Stock | 16.5714 | 16.5714 | 16.5714 | 16.5714 | 2800.0 |
| 2013-08-08 05:05:00 | AAPL | Stock | 16.5775 | 16.5775 | 16.5775 | 16.5775 | 2800.0 |
| 2013-08-08 05:10:00 | AAPL | Stock | 16.5939 | 16.5939 | 16.5939 | 16.5939 | 2800.0 |
| 2013-08-08 05:15:00 | AAPL | Stock | 16.5971 | 16.5971 | 16.5964 | 16.5964 | 5600.0 |
| 2013-08-08 05:20:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6068 | 16.6071 | 11200.0 |
| 2013-08-08 05:40:00 | AAPL | Stock | 16.6075 | 16.6075 | 16.6 | 16.6032 | 16800.0 |
| 2013-08-08 05:45:00 | AAPL | Stock | 16.5982 | 16.5982 | 16.5929 | 16.5929 | 8400.0 |
| 2013-08-08 05:50:00 | AAPL | Stock | 16.5911 | 16.5911 | 16.5911 | 16.5911 | 2800.0 |
| 2013-08-08 05:55:00 | AAPL | Stock | 16.5982 | 16.5982 | 16.5982 | 16.5982 | 2800.0 |
| 2013-08-08 06:05:00 | AAPL | Stock | 16.5857 | 16.5857 | 16.5825 | 16.5825 | 8400.0 |
| 2013-08-08 06:10:00 | AAPL | Stock | 16.5893 | 16.5893 | 16.5893 | 16.5893 | 5600.0 |
| 2013-08-08 06:20:00 | AAPL | Stock | 16.5825 | 16.5825 | 16.5768 | 16.5786 | 19600.0 |
| 2013-08-08 06:25:00 | AAPL | Stock | 16.5754 | 16.5754 | 16.5714 | 16.5714 | 8400.0 |
| 2013-08-08 06:35:00 | AAPL | Stock | 16.5714 | 16.5714 | 16.5464 | 16.5464 | 21000.0 |
| 2013-08-08 06:50:00 | AAPL | Stock | 16.5696 | 16.5714 | 16.5696 | 16.5714 | 11200.0 |
| 2013-08-08 07:05:00 | AAPL | Stock | 16.5714 | 16.5714 | 16.5714 | 16.5714 | 30800.0 |
| 2013-08-08 07:10:00 | AAPL | Stock | 16.5679 | 16.5679 | 16.5625 | 16.5625 | 8400.0 |
| 2013-08-08 07:15:00 | AAPL | Stock | 16.5682 | 16.5682 | 16.5654 | 16.5654 | 8400.0 |
| 2013-08-08 07:20:00 | AAPL | Stock | 16.5686 | 16.5686 | 16.5679 | 16.5686 | 19208.0 |
| 2013-08-08 07:25:00 | AAPL | Stock | 16.5714 | 16.5857 | 16.5714 | 16.575 | 79716.0 |
| 2013-08-08 07:30:00 | AAPL | Stock | 16.5789 | 16.5789 | 16.5789 | 16.5789 | 5320.0 |
| 2013-08-08 07:35:00 | AAPL | Stock | 16.5725 | 16.5725 | 16.5643 | 16.5643 | 8400.0 |
| 2013-08-08 07:40:00 | AAPL | Stock | 16.565 | 16.565 | 16.5643 | 16.5643 | 11200.0 |
| 2013-08-08 07:45:00 | AAPL | Stock | 16.5557 | 16.5557 | 16.5396 | 16.5396 | 25200.0 |
| 2013-08-08 07:50:00 | AAPL | Stock | 16.5439 | 16.5439 | 16.5214 | 16.5214 | 78540.0 |
| 2013-08-08 07:55:00 | AAPL | Stock | 16.5346 | 16.5357 | 16.5346 | 16.5357 | 30800.0 |
| 2013-08-08 08:00:00 | AAPL | Stock | 16.5357 | 16.5821 | 16.5311 | 16.5821 | 589232.0 |
| 2013-08-08 08:05:00 | AAPL | Stock | 16.5821 | 16.5982 | 16.5796 | 16.5857 | 266588.0 |
| 2013-08-08 08:10:00 | AAPL | Stock | 16.5857 | 16.5857 | 16.5786 | 16.5786 | 82376.0 |
| 2013-08-08 08:15:00 | AAPL | Stock | 16.5718 | 16.5857 | 16.5718 | 16.5857 | 28000.0 |
| 2013-08-08 08:20:00 | AAPL | Stock | 16.5786 | 16.5786 | 16.5714 | 16.5714 | 62496.0 |
| 2013-08-08 08:25:00 | AAPL | Stock | 16.5714 | 16.5718 | 16.5714 | 16.5718 | 8400.0 |
| 2013-08-08 08:30:00 | AAPL | Stock | 16.5764 | 16.5775 | 16.5714 | 16.5714 | 19600.0 |
| 2013-08-08 08:35:00 | AAPL | Stock | 16.5707 | 16.5854 | 16.5704 | 16.5854 | 106456.0 |
| 2013-08-08 08:40:00 | AAPL | Stock | 16.585 | 16.5871 | 16.58 | 16.5871 | 123200.0 |
| 2013-08-08 08:45:00 | AAPL | Stock | 16.5804 | 16.5839 | 16.5679 | 16.5679 | 143976.0 |
| 2013-08-08 08:50:00 | AAPL | Stock | 16.5711 | 16.5711 | 16.5554 | 16.5643 | 286020.0 |
| 2013-08-08 08:55:00 | AAPL | Stock | 16.5643 | 16.5643 | 16.5636 | 16.5636 | 56000.0 |
| 2013-08-08 09:00:00 | AAPL | Stock | 16.5661 | 16.5661 | 16.55 | 16.55 | 280840.0 |
| 2013-08-08 09:05:00 | AAPL | Stock | 16.5504 | 16.5536 | 16.5404 | 16.5536 | 159600.0 |
| 2013-08-08 09:10:00 | AAPL | Stock | 16.5568 | 16.5657 | 16.5443 | 16.5443 | 137004.0 |
| 2013-08-08 09:15:00 | AAPL | Stock | 16.5543 | 16.5543 | 16.5357 | 16.5536 | 133392.0 |
| 2013-08-08 09:20:00 | AAPL | Stock | 16.5521 | 16.5736 | 16.5521 | 16.5736 | 332976.0 |
| 2013-08-08 09:25:00 | AAPL | Stock | 16.5611 | 16.5729 | 16.5611 | 16.5729 | 48944.0 |
| 2013-08-08 09:30:00 | AAPL | Stock | 16.5714 | 16.5746 | 16.5268 | 16.5445 | 11046056.0 |
| 2013-08-08 09:35:00 | AAPL | Stock | 16.5436 | 16.5475 | 16.5007 | 16.5068 | 6907012.0 |
| 2013-08-08 09:40:00 | AAPL | Stock | 16.5086 | 16.5475 | 16.5068 | 16.5446 | 4846240.0 |
| 2013-08-08 09:45:00 | AAPL | Stock | 16.5457 | 16.575 | 16.5361 | 16.5614 | 6131804.0 |
> showing 50 of 336,153 rows — these rows as CSV