PREVIEW / stock_5min / 2016-05-25
file: by_date/stock_5min/2016/2016-05-25.parquet size: 5.3 MB rows: 355,100 symbols: 3,300
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 |
|---|---|---|---|---|---|---|---|
| 2016-05-25 04:00:00 | AAPL | Stock | 24.6125 | 24.6725 | 24.6125 | 24.67 | 14432.0 |
| 2016-05-25 04:05:00 | AAPL | Stock | 24.6725 | 24.6725 | 24.6725 | 24.6725 | 3600.0 |
| 2016-05-25 04:10:00 | AAPL | Stock | 24.67 | 24.67 | 24.67 | 24.67 | 2312.0 |
| 2016-05-25 04:15:00 | AAPL | Stock | 24.675 | 24.6875 | 24.675 | 24.6875 | 3896.0 |
| 2016-05-25 04:20:00 | AAPL | Stock | 24.6875 | 24.6875 | 24.6875 | 24.6875 | 3068.0 |
| 2016-05-25 04:30:00 | AAPL | Stock | 24.685 | 24.685 | 24.6525 | 24.6625 | 1792.0 |
| 2016-05-25 04:55:00 | AAPL | Stock | 24.685 | 24.6925 | 24.685 | 24.6925 | 2140.0 |
| 2016-05-25 05:15:00 | AAPL | Stock | 24.7225 | 24.7225 | 24.7225 | 24.7225 | 1400.0 |
| 2016-05-25 05:20:00 | AAPL | Stock | 24.7375 | 24.7375 | 24.7375 | 24.7375 | 908.0 |
| 2016-05-25 05:30:00 | AAPL | Stock | 24.7325 | 24.7375 | 24.675 | 24.675 | 1760.0 |
| 2016-05-25 05:45:00 | AAPL | Stock | 24.7375 | 24.7375 | 24.735 | 24.735 | 2800.0 |
| 2016-05-25 05:50:00 | AAPL | Stock | 24.7225 | 24.7225 | 24.7225 | 24.7225 | 1600.0 |
| 2016-05-25 05:55:00 | AAPL | Stock | 24.7225 | 24.7225 | 24.7125 | 24.7125 | 1200.0 |
| 2016-05-25 06:05:00 | AAPL | Stock | 24.7 | 24.7 | 24.67 | 24.675 | 6100.0 |
| 2016-05-25 06:10:00 | AAPL | Stock | 24.71 | 24.71 | 24.71 | 24.71 | 400.0 |
| 2016-05-25 06:15:00 | AAPL | Stock | 24.6875 | 24.6875 | 24.6875 | 24.6875 | 4000.0 |
| 2016-05-25 06:20:00 | AAPL | Stock | 24.7 | 24.71 | 24.7 | 24.71 | 800.0 |
| 2016-05-25 06:25:00 | AAPL | Stock | 24.7125 | 24.7125 | 24.6975 | 24.6975 | 6824.0 |
| 2016-05-25 06:30:00 | AAPL | Stock | 24.7 | 24.7 | 24.7 | 24.7 | 5600.0 |
| 2016-05-25 06:35:00 | AAPL | Stock | 24.6875 | 24.69 | 24.675 | 24.675 | 7964.0 |
| 2016-05-25 06:40:00 | AAPL | Stock | 24.675 | 24.675 | 24.675 | 24.675 | 1200.0 |
| 2016-05-25 06:45:00 | AAPL | Stock | 24.675 | 24.675 | 24.67 | 24.67 | 4372.0 |
| 2016-05-25 06:50:00 | AAPL | Stock | 24.675 | 24.675 | 24.67 | 24.67 | 4400.0 |
| 2016-05-25 06:55:00 | AAPL | Stock | 24.6725 | 24.675 | 24.665 | 24.665 | 8956.0 |
| 2016-05-25 07:00:00 | AAPL | Stock | 24.67 | 24.675 | 24.665 | 24.665 | 10816.0 |
| 2016-05-25 07:05:00 | AAPL | Stock | 24.6725 | 24.6725 | 24.65 | 24.65 | 56828.0 |
| 2016-05-25 07:10:00 | AAPL | Stock | 24.65 | 24.65 | 24.625 | 24.625 | 32112.0 |
| 2016-05-25 07:15:00 | AAPL | Stock | 24.625 | 24.625 | 24.6125 | 24.6125 | 15376.0 |
| 2016-05-25 07:20:00 | AAPL | Stock | 24.605 | 24.625 | 24.605 | 24.625 | 20392.0 |
| 2016-05-25 07:25:00 | AAPL | Stock | 24.625 | 24.6425 | 24.6075 | 24.6425 | 10608.0 |
| 2016-05-25 07:30:00 | AAPL | Stock | 24.625 | 24.6375 | 24.6175 | 24.6175 | 11000.0 |
| 2016-05-25 07:35:00 | AAPL | Stock | 24.6275 | 24.6275 | 24.6225 | 24.6225 | 24372.0 |
| 2016-05-25 07:40:00 | AAPL | Stock | 24.625 | 24.625 | 24.6075 | 24.6075 | 6188.0 |
| 2016-05-25 07:50:00 | AAPL | Stock | 24.625 | 24.625 | 24.5975 | 24.6 | 14720.0 |
| 2016-05-25 07:55:00 | AAPL | Stock | 24.6125 | 24.6125 | 24.595 | 24.6125 | 14836.0 |
| 2016-05-25 08:00:00 | AAPL | Stock | 24.5925 | 24.675 | 24.5875 | 24.6175 | 142648.0 |
| 2016-05-25 08:05:00 | AAPL | Stock | 24.6225 | 24.625 | 24.62 | 24.6225 | 22720.0 |
| 2016-05-25 08:10:00 | AAPL | Stock | 24.6225 | 24.625 | 24.615 | 24.625 | 61968.0 |
| 2016-05-25 08:15:00 | AAPL | Stock | 24.6325 | 24.635 | 24.625 | 24.6325 | 20200.0 |
| 2016-05-25 08:20:00 | AAPL | Stock | 24.635 | 24.6475 | 24.6325 | 24.6425 | 40104.0 |
| 2016-05-25 08:25:00 | AAPL | Stock | 24.6425 | 24.65 | 24.6375 | 24.6375 | 19704.0 |
| 2016-05-25 08:30:00 | AAPL | Stock | 24.64 | 24.6625 | 24.64 | 24.6625 | 31784.0 |
| 2016-05-25 08:35:00 | AAPL | Stock | 24.6625 | 24.6625 | 24.65 | 24.65 | 11240.0 |
| 2016-05-25 08:40:00 | AAPL | Stock | 24.6625 | 24.6625 | 24.65 | 24.65 | 23908.0 |
| 2016-05-25 08:45:00 | AAPL | Stock | 24.65 | 24.6575 | 24.6175 | 24.6175 | 66632.0 |
| 2016-05-25 08:50:00 | AAPL | Stock | 24.63 | 24.645 | 24.625 | 24.625 | 22128.0 |
| 2016-05-25 08:55:00 | AAPL | Stock | 24.645 | 24.6575 | 24.645 | 24.6575 | 46852.0 |
| 2016-05-25 09:00:00 | AAPL | Stock | 24.6525 | 24.6625 | 24.65 | 24.6625 | 27800.0 |
| 2016-05-25 09:05:00 | AAPL | Stock | 24.65 | 24.6675 | 24.625 | 24.63 | 106744.0 |
| 2016-05-25 09:10:00 | AAPL | Stock | 24.63 | 24.645 | 24.6275 | 24.64 | 39800.0 |
> showing 50 of 355,100 rows — these rows as CSV