PREVIEW / stock_5min / 2012-03-21
file: by_date/stock_5min/2012/2012-03-21.parquet size: 4.8 MB rows: 324,975 symbols: 3,511
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 |
|---|---|---|---|---|---|---|---|
| 2012-03-21 04:00:00 | AAPL | Stock | 21.6679 | 21.6779 | 21.6679 | 21.6779 | 16800.0 |
| 2012-03-21 04:05:00 | AAPL | Stock | 21.6786 | 21.6929 | 21.6786 | 21.6896 | 39200.0 |
| 2012-03-21 04:10:00 | AAPL | Stock | 21.6893 | 21.6932 | 21.6875 | 21.6875 | 26600.0 |
| 2012-03-21 04:15:00 | AAPL | Stock | 21.6821 | 21.6854 | 21.6768 | 21.6829 | 14000.0 |
| 2012-03-21 04:20:00 | AAPL | Stock | 21.6721 | 21.6721 | 21.6721 | 21.6721 | 4200.0 |
| 2012-03-21 04:30:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6786 | 21.6786 | 5600.0 |
| 2012-03-21 04:40:00 | AAPL | Stock | 21.6629 | 21.6629 | 21.6607 | 21.6607 | 5600.0 |
| 2012-03-21 04:45:00 | AAPL | Stock | 21.65 | 21.65 | 21.65 | 21.65 | 2800.0 |
| 2012-03-21 04:55:00 | AAPL | Stock | 21.6571 | 21.6571 | 21.6571 | 21.6571 | 5600.0 |
| 2012-03-21 05:00:00 | AAPL | Stock | 21.6607 | 21.6607 | 21.6607 | 21.6607 | 2940.0 |
| 2012-03-21 05:05:00 | AAPL | Stock | 21.6536 | 21.6536 | 21.6536 | 21.6536 | 2800.0 |
| 2012-03-21 05:10:00 | AAPL | Stock | 21.6536 | 21.6536 | 21.6461 | 21.6461 | 11200.0 |
| 2012-03-21 05:15:00 | AAPL | Stock | 21.6518 | 21.6518 | 21.6518 | 21.6518 | 2800.0 |
| 2012-03-21 05:20:00 | AAPL | Stock | 21.6518 | 21.6518 | 21.6407 | 21.6407 | 8400.0 |
| 2012-03-21 05:25:00 | AAPL | Stock | 21.6196 | 21.6196 | 21.6146 | 21.6146 | 5600.0 |
| 2012-03-21 05:40:00 | AAPL | Stock | 21.6196 | 21.6196 | 21.6196 | 21.6196 | 2800.0 |
| 2012-03-21 05:45:00 | AAPL | Stock | 21.5964 | 21.5964 | 21.5964 | 21.5964 | 5600.0 |
| 2012-03-21 05:50:00 | AAPL | Stock | 21.6196 | 21.6196 | 21.6196 | 21.6196 | 2800.0 |
| 2012-03-21 06:00:00 | AAPL | Stock | 21.6107 | 21.6107 | 21.6107 | 21.6107 | 8372.0 |
| 2012-03-21 06:20:00 | AAPL | Stock | 21.6075 | 21.6075 | 21.6075 | 21.6075 | 2800.0 |
| 2012-03-21 06:30:00 | AAPL | Stock | 21.6196 | 21.6196 | 21.6196 | 21.6196 | 2800.0 |
| 2012-03-21 06:45:00 | AAPL | Stock | 21.6018 | 21.6018 | 21.6018 | 21.6018 | 2800.0 |
| 2012-03-21 07:00:00 | AAPL | Stock | 21.5982 | 21.6171 | 21.5982 | 21.6071 | 14000.0 |
| 2012-03-21 07:05:00 | AAPL | Stock | 21.6154 | 21.625 | 21.6154 | 21.625 | 5600.0 |
| 2012-03-21 07:10:00 | AAPL | Stock | 21.6246 | 21.6339 | 21.6071 | 21.6107 | 39536.0 |
| 2012-03-21 07:15:00 | AAPL | Stock | 21.5957 | 21.6107 | 21.5714 | 21.5714 | 88480.0 |
| 2012-03-21 07:20:00 | AAPL | Stock | 21.5714 | 21.5714 | 21.5611 | 21.5714 | 25760.0 |
| 2012-03-21 07:25:00 | AAPL | Stock | 21.5889 | 21.5889 | 21.5714 | 21.5714 | 42560.0 |
| 2012-03-21 07:30:00 | AAPL | Stock | 21.5625 | 21.5625 | 21.5532 | 21.5536 | 16800.0 |
| 2012-03-21 07:35:00 | AAPL | Stock | 21.5679 | 21.5679 | 21.5679 | 21.5679 | 2800.0 |
| 2012-03-21 07:40:00 | AAPL | Stock | 21.5643 | 21.5679 | 21.5557 | 21.5679 | 54600.0 |
| 2012-03-21 07:45:00 | AAPL | Stock | 21.5643 | 21.5643 | 21.5464 | 21.5475 | 45220.0 |
| 2012-03-21 07:50:00 | AAPL | Stock | 21.5639 | 21.5739 | 21.5471 | 21.5643 | 177968.0 |
| 2012-03-21 07:55:00 | AAPL | Stock | 21.5646 | 21.5793 | 21.5646 | 21.5789 | 107520.0 |
| 2012-03-21 08:00:00 | AAPL | Stock | 21.5721 | 21.6414 | 21.5025 | 21.5839 | 1538544.0 |
| 2012-03-21 08:05:00 | AAPL | Stock | 21.5839 | 21.5839 | 21.5543 | 21.5696 | 546420.0 |
| 2012-03-21 08:10:00 | AAPL | Stock | 21.5714 | 21.5893 | 21.5618 | 21.5804 | 622216.0 |
| 2012-03-21 08:15:00 | AAPL | Stock | 21.5732 | 21.5857 | 21.5704 | 21.5725 | 506660.0 |
| 2012-03-21 08:20:00 | AAPL | Stock | 21.5764 | 21.5764 | 21.5489 | 21.55 | 884016.0 |
| 2012-03-21 08:25:00 | AAPL | Stock | 21.5518 | 21.5546 | 21.5404 | 21.5446 | 242564.0 |
| 2012-03-21 08:30:00 | AAPL | Stock | 21.5514 | 21.5568 | 21.5357 | 21.5568 | 412832.0 |
| 2012-03-21 08:35:00 | AAPL | Stock | 21.5518 | 21.5621 | 21.5282 | 21.5346 | 882224.0 |
| 2012-03-21 08:40:00 | AAPL | Stock | 21.54 | 21.5479 | 21.5289 | 21.5289 | 447048.0 |
| 2012-03-21 08:45:00 | AAPL | Stock | 21.5393 | 21.5393 | 21.5082 | 21.5179 | 730240.0 |
| 2012-03-21 08:50:00 | AAPL | Stock | 21.5175 | 21.5179 | 21.4825 | 21.4839 | 939904.0 |
| 2012-03-21 08:55:00 | AAPL | Stock | 21.485 | 21.4929 | 21.4682 | 21.4929 | 1090880.0 |
| 2012-03-21 09:00:00 | AAPL | Stock | 21.4993 | 21.5246 | 21.4896 | 21.5246 | 673904.0 |
| 2012-03-21 09:05:00 | AAPL | Stock | 21.525 | 21.5307 | 21.5139 | 21.5161 | 434000.0 |
| 2012-03-21 09:10:00 | AAPL | Stock | 21.515 | 21.515 | 21.4932 | 21.5 | 513660.0 |
| 2012-03-21 09:15:00 | AAPL | Stock | 21.5 | 21.515 | 21.4946 | 21.5121 | 257124.0 |
> showing 50 of 324,975 rows — these rows as CSV