PREVIEW / stock_5min / 2017-03-22
file: by_date/stock_5min/2017/2017-03-22.parquet size: 5.4 MB rows: 359,106 symbols: 3,076
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 |
|---|---|---|---|---|---|---|---|
| 2017-03-22 04:00:00 | AAPL | Stock | 34.8125 | 34.8125 | 34.75 | 34.75 | 2508.0 |
| 2017-03-22 04:05:00 | AAPL | Stock | 34.7125 | 34.7125 | 34.6875 | 34.6875 | 1200.0 |
| 2017-03-22 04:10:00 | AAPL | Stock | 34.6925 | 34.6925 | 34.6925 | 34.6925 | 800.0 |
| 2017-03-22 04:15:00 | AAPL | Stock | 34.7225 | 34.75 | 34.715 | 34.715 | 6064.0 |
| 2017-03-22 04:25:00 | AAPL | Stock | 34.75 | 34.75 | 34.75 | 34.75 | 800.0 |
| 2017-03-22 04:35:00 | AAPL | Stock | 34.725 | 34.725 | 34.725 | 34.725 | 400.0 |
| 2017-03-22 04:45:00 | AAPL | Stock | 34.685 | 34.735 | 34.685 | 34.735 | 5440.0 |
| 2017-03-22 05:00:00 | AAPL | Stock | 34.6775 | 34.685 | 34.6775 | 34.685 | 800.0 |
| 2017-03-22 05:05:00 | AAPL | Stock | 34.6725 | 34.6725 | 34.6675 | 34.6675 | 800.0 |
| 2017-03-22 05:15:00 | AAPL | Stock | 34.7 | 34.725 | 34.7 | 34.725 | 6688.0 |
| 2017-03-22 05:20:00 | AAPL | Stock | 34.7475 | 34.7475 | 34.7475 | 34.7475 | 700.0 |
| 2017-03-22 05:25:00 | AAPL | Stock | 34.725 | 34.725 | 34.725 | 34.725 | 4288.0 |
| 2017-03-22 05:30:00 | AAPL | Stock | 34.7 | 34.7 | 34.7 | 34.7 | 2000.0 |
| 2017-03-22 05:35:00 | AAPL | Stock | 34.67 | 34.67 | 34.67 | 34.67 | 400.0 |
| 2017-03-22 05:40:00 | AAPL | Stock | 34.7025 | 34.7025 | 34.7025 | 34.7025 | 800.0 |
| 2017-03-22 05:45:00 | AAPL | Stock | 34.7 | 34.7 | 34.7 | 34.7 | 2128.0 |
| 2017-03-22 05:50:00 | AAPL | Stock | 34.7475 | 34.75 | 34.7375 | 34.75 | 3900.0 |
| 2017-03-22 05:55:00 | AAPL | Stock | 34.76 | 34.775 | 34.76 | 34.775 | 3204.0 |
| 2017-03-22 06:00:00 | AAPL | Stock | 34.76 | 34.76 | 34.75 | 34.75 | 7500.0 |
| 2017-03-22 06:10:00 | AAPL | Stock | 34.755 | 34.755 | 34.73 | 34.75 | 5180.0 |
| 2017-03-22 06:15:00 | AAPL | Stock | 34.7525 | 34.7525 | 34.75 | 34.75 | 1600.0 |
| 2017-03-22 06:20:00 | AAPL | Stock | 34.73 | 34.75 | 34.73 | 34.75 | 3648.0 |
| 2017-03-22 06:25:00 | AAPL | Stock | 34.7725 | 34.7725 | 34.73 | 34.73 | 1392.0 |
| 2017-03-22 06:30:00 | AAPL | Stock | 34.7575 | 34.7625 | 34.7575 | 34.7625 | 5600.0 |
| 2017-03-22 06:35:00 | AAPL | Stock | 34.73 | 34.75 | 34.715 | 34.75 | 3600.0 |
| 2017-03-22 06:40:00 | AAPL | Stock | 34.75 | 34.75 | 34.75 | 34.75 | 800.0 |
| 2017-03-22 06:45:00 | AAPL | Stock | 34.73 | 34.73 | 34.73 | 34.73 | 400.0 |
| 2017-03-22 06:50:00 | AAPL | Stock | 34.7625 | 34.7625 | 34.7625 | 34.7625 | 2400.0 |
| 2017-03-22 06:55:00 | AAPL | Stock | 34.7625 | 34.7625 | 34.75 | 34.75 | 8140.0 |
| 2017-03-22 07:00:00 | AAPL | Stock | 34.775 | 34.775 | 34.755 | 34.7625 | 14252.0 |
| 2017-03-22 07:05:00 | AAPL | Stock | 34.775 | 34.775 | 34.775 | 34.775 | 3340.0 |
| 2017-03-22 07:10:00 | AAPL | Stock | 34.785 | 34.805 | 34.785 | 34.7875 | 15928.0 |
| 2017-03-22 07:15:00 | AAPL | Stock | 34.795 | 34.8 | 34.7875 | 34.795 | 9600.0 |
| 2017-03-22 07:20:00 | AAPL | Stock | 34.8 | 34.825 | 34.8 | 34.825 | 18336.0 |
| 2017-03-22 07:25:00 | AAPL | Stock | 34.825 | 34.825 | 34.8125 | 34.8125 | 17720.0 |
| 2017-03-22 07:30:00 | AAPL | Stock | 34.8125 | 34.825 | 34.8 | 34.815 | 15600.0 |
| 2017-03-22 07:35:00 | AAPL | Stock | 34.8125 | 34.8375 | 34.8125 | 34.8375 | 26752.0 |
| 2017-03-22 07:40:00 | AAPL | Stock | 34.8375 | 34.875 | 34.8 | 34.845 | 130152.0 |
| 2017-03-22 07:45:00 | AAPL | Stock | 34.8375 | 34.8375 | 34.825 | 34.835 | 4600.0 |
| 2017-03-22 07:50:00 | AAPL | Stock | 34.8375 | 34.8375 | 34.8375 | 34.8375 | 400.0 |
| 2017-03-22 07:55:00 | AAPL | Stock | 34.85 | 34.85 | 34.85 | 34.85 | 9196.0 |
| 2017-03-22 08:00:00 | AAPL | Stock | 34.85 | 34.875 | 34.73 | 34.8325 | 63324.0 |
| 2017-03-22 08:05:00 | AAPL | Stock | 34.825 | 34.825 | 34.8125 | 34.825 | 23336.0 |
| 2017-03-22 08:10:00 | AAPL | Stock | 34.8275 | 34.8725 | 34.8275 | 34.8425 | 25080.0 |
| 2017-03-22 08:15:00 | AAPL | Stock | 34.8425 | 34.875 | 34.835 | 34.8375 | 21444.0 |
| 2017-03-22 08:20:00 | AAPL | Stock | 34.855 | 34.865 | 34.85 | 34.86 | 38004.0 |
| 2017-03-22 08:25:00 | AAPL | Stock | 34.8625 | 34.8625 | 34.8575 | 34.8575 | 15448.0 |
| 2017-03-22 08:30:00 | AAPL | Stock | 34.8575 | 34.8975 | 34.8575 | 34.875 | 39888.0 |
| 2017-03-22 08:35:00 | AAPL | Stock | 34.875 | 34.88 | 34.87 | 34.87 | 26220.0 |
| 2017-03-22 08:40:00 | AAPL | Stock | 34.87 | 34.875 | 34.855 | 34.8725 | 6504.0 |
> showing 50 of 359,106 rows — these rows as CSV