PREVIEW / stock_5min / 2015-03-23
file: by_date/stock_5min/2015/2015-03-23.parquet size: 5.5 MB rows: 366,878 symbols: 3,507
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 |
|---|---|---|---|---|---|---|---|
| 2015-03-23 04:00:00 | AAPL | Stock | 31.595 | 31.6 | 31.595 | 31.6 | 9768.0 |
| 2015-03-23 04:05:00 | AAPL | Stock | 31.6 | 31.6 | 31.5825 | 31.5825 | 1200.0 |
| 2015-03-23 04:10:00 | AAPL | Stock | 31.5825 | 31.5825 | 31.5825 | 31.5825 | 1100.0 |
| 2015-03-23 04:15:00 | AAPL | Stock | 31.5975 | 31.5975 | 31.5975 | 31.5975 | 2428.0 |
| 2015-03-23 04:25:00 | AAPL | Stock | 31.6425 | 31.6425 | 31.5925 | 31.5925 | 10100.0 |
| 2015-03-23 04:30:00 | AAPL | Stock | 31.5925 | 31.5925 | 31.5925 | 31.5925 | 6000.0 |
| 2015-03-23 04:40:00 | AAPL | Stock | 31.575 | 31.575 | 31.575 | 31.575 | 400.0 |
| 2015-03-23 04:55:00 | AAPL | Stock | 31.6475 | 31.6475 | 31.6475 | 31.6475 | 3500.0 |
| 2015-03-23 05:00:00 | AAPL | Stock | 31.6475 | 31.6475 | 31.6475 | 31.6475 | 500.0 |
| 2015-03-23 05:05:00 | AAPL | Stock | 31.6475 | 31.6475 | 31.6475 | 31.6475 | 1200.0 |
| 2015-03-23 05:10:00 | AAPL | Stock | 31.6475 | 31.6475 | 31.6475 | 31.6475 | 800.0 |
| 2015-03-23 05:15:00 | AAPL | Stock | 31.6325 | 31.6325 | 31.6325 | 31.6325 | 400.0 |
| 2015-03-23 05:20:00 | AAPL | Stock | 31.6475 | 31.6625 | 31.6475 | 31.6625 | 9880.0 |
| 2015-03-23 05:30:00 | AAPL | Stock | 31.67 | 31.67 | 31.635 | 31.635 | 4000.0 |
| 2015-03-23 05:40:00 | AAPL | Stock | 31.66 | 31.67 | 31.6475 | 31.67 | 3356.0 |
| 2015-03-23 05:50:00 | AAPL | Stock | 31.6475 | 31.685 | 31.6475 | 31.685 | 800.0 |
| 2015-03-23 06:00:00 | AAPL | Stock | 31.66 | 31.675 | 31.66 | 31.6625 | 10000.0 |
| 2015-03-23 06:05:00 | AAPL | Stock | 31.6625 | 31.6625 | 31.635 | 31.6475 | 33296.0 |
| 2015-03-23 06:10:00 | AAPL | Stock | 31.655 | 31.655 | 31.65 | 31.65 | 4600.0 |
| 2015-03-23 06:15:00 | AAPL | Stock | 31.655 | 31.655 | 31.655 | 31.655 | 800.0 |
| 2015-03-23 06:25:00 | AAPL | Stock | 31.655 | 31.655 | 31.645 | 31.645 | 4148.0 |
| 2015-03-23 06:30:00 | AAPL | Stock | 31.655 | 31.6725 | 31.655 | 31.6725 | 20736.0 |
| 2015-03-23 06:35:00 | AAPL | Stock | 31.67 | 31.67 | 31.66 | 31.66 | 5696.0 |
| 2015-03-23 06:40:00 | AAPL | Stock | 31.66 | 31.66 | 31.6575 | 31.6575 | 2400.0 |
| 2015-03-23 06:50:00 | AAPL | Stock | 31.655 | 31.66 | 31.655 | 31.66 | 17140.0 |
| 2015-03-23 06:55:00 | AAPL | Stock | 31.6375 | 31.6375 | 31.6275 | 31.6275 | 21008.0 |
| 2015-03-23 07:00:00 | AAPL | Stock | 31.64 | 31.6525 | 31.64 | 31.6525 | 4800.0 |
| 2015-03-23 07:05:00 | AAPL | Stock | 31.6325 | 31.6325 | 31.6325 | 31.6325 | 1924.0 |
| 2015-03-23 07:10:00 | AAPL | Stock | 31.65 | 31.65 | 31.65 | 31.65 | 4396.0 |
| 2015-03-23 07:15:00 | AAPL | Stock | 31.6375 | 31.655 | 31.625 | 31.655 | 18668.0 |
| 2015-03-23 07:20:00 | AAPL | Stock | 31.655 | 31.655 | 31.6325 | 31.655 | 9496.0 |
| 2015-03-23 07:25:00 | AAPL | Stock | 31.65 | 31.65 | 31.65 | 31.65 | 2800.0 |
| 2015-03-23 07:30:00 | AAPL | Stock | 31.655 | 31.6625 | 31.655 | 31.6575 | 2800.0 |
| 2015-03-23 07:35:00 | AAPL | Stock | 31.6575 | 31.6625 | 31.655 | 31.6625 | 2400.0 |
| 2015-03-23 07:40:00 | AAPL | Stock | 31.6625 | 31.67 | 31.6625 | 31.67 | 800.0 |
| 2015-03-23 07:45:00 | AAPL | Stock | 31.6825 | 31.685 | 31.6825 | 31.685 | 2696.0 |
| 2015-03-23 07:50:00 | AAPL | Stock | 31.685 | 31.6925 | 31.685 | 31.6925 | 16756.0 |
| 2015-03-23 07:55:00 | AAPL | Stock | 31.6975 | 31.71 | 31.6975 | 31.7 | 24800.0 |
| 2015-03-23 08:00:00 | AAPL | Stock | 31.69 | 31.71 | 31.475 | 31.7 | 168932.0 |
| 2015-03-23 08:05:00 | AAPL | Stock | 31.6925 | 31.7175 | 31.69 | 31.7175 | 57940.0 |
| 2015-03-23 08:10:00 | AAPL | Stock | 31.7175 | 31.7325 | 31.7125 | 31.725 | 66552.0 |
| 2015-03-23 08:15:00 | AAPL | Stock | 31.725 | 31.725 | 31.7025 | 31.7125 | 99456.0 |
| 2015-03-23 08:20:00 | AAPL | Stock | 31.7075 | 31.715 | 31.7025 | 31.7025 | 38224.0 |
| 2015-03-23 08:25:00 | AAPL | Stock | 31.705 | 31.7225 | 31.705 | 31.7125 | 67440.0 |
| 2015-03-23 08:30:00 | AAPL | Stock | 31.72 | 31.725 | 31.715 | 31.7225 | 60568.0 |
| 2015-03-23 08:35:00 | AAPL | Stock | 31.725 | 31.725 | 31.7125 | 31.7175 | 68932.0 |
| 2015-03-23 08:40:00 | AAPL | Stock | 31.725 | 31.7325 | 31.7225 | 31.725 | 71732.0 |
| 2015-03-23 08:45:00 | AAPL | Stock | 31.72 | 31.7275 | 31.6925 | 31.7125 | 139172.0 |
| 2015-03-23 08:50:00 | AAPL | Stock | 31.7 | 31.72 | 31.7 | 31.715 | 86080.0 |
| 2015-03-23 08:55:00 | AAPL | Stock | 31.72 | 31.745 | 31.715 | 31.7425 | 127260.0 |
> showing 50 of 366,878 rows — these rows as CSV