PREVIEW / stock_5min / 2014-06-30
file: by_date/stock_5min/2014/2014-06-30.parquet size: 5.5 MB rows: 371,680 symbols: 3,598
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 |
|---|---|---|---|---|---|---|---|
| 2014-06-30 04:00:00 | AAPL | Stock | 23.0275 | 23.0975 | 23.0275 | 23.0975 | 800.0 |
| 2014-06-30 04:10:00 | AAPL | Stock | 23.1025 | 23.1025 | 23.0975 | 23.0975 | 2984.0 |
| 2014-06-30 04:20:00 | AAPL | Stock | 23.1 | 23.1 | 23.1 | 23.1 | 3600.0 |
| 2014-06-30 04:50:00 | AAPL | Stock | 23.0775 | 23.0775 | 23.075 | 23.075 | 2972.0 |
| 2014-06-30 05:05:00 | AAPL | Stock | 23.0825 | 23.0825 | 23.0825 | 23.0825 | 1680.0 |
| 2014-06-30 05:15:00 | AAPL | Stock | 23.09 | 23.09 | 23.09 | 23.09 | 800.0 |
| 2014-06-30 05:20:00 | AAPL | Stock | 23.09 | 23.09 | 23.09 | 23.09 | 1200.0 |
| 2014-06-30 05:35:00 | AAPL | Stock | 23.075 | 23.075 | 23.075 | 23.075 | 400.0 |
| 2014-06-30 05:40:00 | AAPL | Stock | 23.0725 | 23.0725 | 23.0725 | 23.0725 | 912.0 |
| 2014-06-30 05:55:00 | AAPL | Stock | 23.0175 | 23.065 | 23.0 | 23.0 | 15000.0 |
| 2014-06-30 06:00:00 | AAPL | Stock | 23.035 | 23.035 | 23.0275 | 23.0275 | 3800.0 |
| 2014-06-30 06:10:00 | AAPL | Stock | 23.02 | 23.02 | 23.02 | 23.02 | 400.0 |
| 2014-06-30 06:15:00 | AAPL | Stock | 23.0275 | 23.0275 | 23.0275 | 23.0275 | 2320.0 |
| 2014-06-30 06:20:00 | AAPL | Stock | 23.0525 | 23.0525 | 23.04 | 23.04 | 3800.0 |
| 2014-06-30 06:30:00 | AAPL | Stock | 23.0525 | 23.0525 | 23.04 | 23.04 | 12080.0 |
| 2014-06-30 06:35:00 | AAPL | Stock | 23.04 | 23.04 | 23.04 | 23.04 | 4000.0 |
| 2014-06-30 06:40:00 | AAPL | Stock | 23.055 | 23.055 | 23.055 | 23.055 | 400.0 |
| 2014-06-30 06:50:00 | AAPL | Stock | 23.05 | 23.05 | 23.05 | 23.05 | 560.0 |
| 2014-06-30 06:55:00 | AAPL | Stock | 23.05 | 23.05 | 23.05 | 23.05 | 5756.0 |
| 2014-06-30 07:00:00 | AAPL | Stock | 23.05 | 23.0575 | 23.04 | 23.0575 | 7580.0 |
| 2014-06-30 07:05:00 | AAPL | Stock | 23.0575 | 23.065 | 23.045 | 23.045 | 22420.0 |
| 2014-06-30 07:10:00 | AAPL | Stock | 23.045 | 23.045 | 23.03 | 23.035 | 5600.0 |
| 2014-06-30 07:15:00 | AAPL | Stock | 23.03 | 23.03 | 23.03 | 23.03 | 6000.0 |
| 2014-06-30 07:20:00 | AAPL | Stock | 23.0325 | 23.0325 | 23.0325 | 23.0325 | 800.0 |
| 2014-06-30 07:25:00 | AAPL | Stock | 23.0375 | 23.0375 | 23.0375 | 23.0375 | 400.0 |
| 2014-06-30 07:30:00 | AAPL | Stock | 23.0425 | 23.045 | 23.0275 | 23.0275 | 11980.0 |
| 2014-06-30 07:35:00 | AAPL | Stock | 23.0325 | 23.0375 | 23.0325 | 23.0375 | 4800.0 |
| 2014-06-30 07:40:00 | AAPL | Stock | 23.0375 | 23.0375 | 23.03 | 23.03 | 6000.0 |
| 2014-06-30 07:45:00 | AAPL | Stock | 23.03 | 23.03 | 23.03 | 23.03 | 800.0 |
| 2014-06-30 07:50:00 | AAPL | Stock | 23.0375 | 23.045 | 23.0375 | 23.045 | 5636.0 |
| 2014-06-30 08:00:00 | AAPL | Stock | 23.0375 | 23.045 | 22.995 | 23.025 | 385040.0 |
| 2014-06-30 08:05:00 | AAPL | Stock | 23.015 | 23.025 | 23.0075 | 23.0175 | 37832.0 |
| 2014-06-30 08:10:00 | AAPL | Stock | 23.035 | 23.0375 | 23.0275 | 23.035 | 28796.0 |
| 2014-06-30 08:15:00 | AAPL | Stock | 23.0375 | 23.0475 | 23.035 | 23.035 | 25860.0 |
| 2014-06-30 08:20:00 | AAPL | Stock | 23.035 | 23.05 | 23.03 | 23.0475 | 43300.0 |
| 2014-06-30 08:25:00 | AAPL | Stock | 23.045 | 23.055 | 23.045 | 23.055 | 22836.0 |
| 2014-06-30 08:30:00 | AAPL | Stock | 23.0525 | 23.0625 | 23.05 | 23.06 | 44640.0 |
| 2014-06-30 08:35:00 | AAPL | Stock | 23.06 | 23.065 | 23.0525 | 23.0625 | 23448.0 |
| 2014-06-30 08:40:00 | AAPL | Stock | 23.0625 | 23.065 | 23.055 | 23.055 | 55768.0 |
| 2014-06-30 08:45:00 | AAPL | Stock | 23.055 | 23.055 | 23.045 | 23.045 | 24580.0 |
| 2014-06-30 08:50:00 | AAPL | Stock | 23.045 | 23.0525 | 23.0225 | 23.04 | 28756.0 |
| 2014-06-30 08:55:00 | AAPL | Stock | 23.04 | 23.04 | 23.0225 | 23.03 | 23144.0 |
| 2014-06-30 09:00:00 | AAPL | Stock | 23.03 | 23.045 | 23.03 | 23.045 | 22700.0 |
| 2014-06-30 09:05:00 | AAPL | Stock | 23.04 | 23.0425 | 23.0375 | 23.0375 | 6676.0 |
| 2014-06-30 09:10:00 | AAPL | Stock | 23.0325 | 23.04 | 23.02 | 23.0375 | 30432.0 |
| 2014-06-30 09:15:00 | AAPL | Stock | 23.0375 | 23.0375 | 23.025 | 23.0275 | 12600.0 |
| 2014-06-30 09:20:00 | AAPL | Stock | 23.035 | 23.0375 | 23.03 | 23.035 | 17056.0 |
| 2014-06-30 09:25:00 | AAPL | Stock | 23.03 | 23.04 | 23.0175 | 23.04 | 118988.0 |
| 2014-06-30 09:30:00 | AAPL | Stock | 23.0275 | 23.1375 | 23.0225 | 23.1 | 9673124.0 |
| 2014-06-30 09:35:00 | AAPL | Stock | 23.0975 | 23.1725 | 23.08 | 23.1325 | 5720700.0 |
> showing 50 of 371,680 rows — these rows as CSV