PREVIEW / stock_5min / 2018-05-18
file: by_date/stock_5min/2018/2018-05-18.parquet size: 5.5 MB rows: 355,620 symbols: 2,837
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 |
|---|---|---|---|---|---|---|---|
| 2018-05-18 04:15:00 | AAPL | Stock | 46.7975 | 46.7975 | 46.7975 | 46.7975 | 400.0 |
| 2018-05-18 04:20:00 | AAPL | Stock | 46.84 | 46.8425 | 46.84 | 46.8425 | 3200.0 |
| 2018-05-18 04:55:00 | AAPL | Stock | 46.8425 | 46.8425 | 46.8425 | 46.8425 | 984.0 |
| 2018-05-18 05:00:00 | AAPL | Stock | 46.845 | 46.8725 | 46.845 | 46.8725 | 2400.0 |
| 2018-05-18 05:05:00 | AAPL | Stock | 46.845 | 46.845 | 46.845 | 46.845 | 19584.0 |
| 2018-05-18 05:10:00 | AAPL | Stock | 46.8625 | 46.8725 | 46.8625 | 46.8725 | 2400.0 |
| 2018-05-18 05:35:00 | AAPL | Stock | 46.9 | 46.9 | 46.9 | 46.9 | 400.0 |
| 2018-05-18 05:40:00 | AAPL | Stock | 46.9 | 46.9 | 46.9 | 46.9 | 3200.0 |
| 2018-05-18 05:45:00 | AAPL | Stock | 46.9 | 46.9 | 46.9 | 46.9 | 400.0 |
| 2018-05-18 05:55:00 | AAPL | Stock | 46.9 | 46.9 | 46.875 | 46.875 | 2284.0 |
| 2018-05-18 06:05:00 | AAPL | Stock | 46.875 | 46.875 | 46.875 | 46.875 | 4000.0 |
| 2018-05-18 06:10:00 | AAPL | Stock | 46.875 | 46.875 | 46.875 | 46.875 | 2000.0 |
| 2018-05-18 06:35:00 | AAPL | Stock | 46.8675 | 46.8675 | 46.8675 | 46.8675 | 400.0 |
| 2018-05-18 07:00:00 | AAPL | Stock | 46.825 | 46.85 | 46.825 | 46.85 | 9656.0 |
| 2018-05-18 07:05:00 | AAPL | Stock | 46.845 | 46.95 | 46.845 | 46.875 | 60192.0 |
| 2018-05-18 07:15:00 | AAPL | Stock | 46.875 | 46.875 | 46.875 | 46.875 | 3676.0 |
| 2018-05-18 07:20:00 | AAPL | Stock | 46.8525 | 46.87 | 46.7775 | 46.87 | 10940.0 |
| 2018-05-18 07:25:00 | AAPL | Stock | 46.8375 | 46.8375 | 46.8375 | 46.8375 | 400.0 |
| 2018-05-18 07:30:00 | AAPL | Stock | 46.8375 | 46.845 | 46.8375 | 46.845 | 5520.0 |
| 2018-05-18 07:35:00 | AAPL | Stock | 46.85 | 46.85 | 46.8375 | 46.8375 | 6064.0 |
| 2018-05-18 07:45:00 | AAPL | Stock | 46.85 | 46.85 | 46.85 | 46.85 | 4280.0 |
| 2018-05-18 07:50:00 | AAPL | Stock | 46.84 | 46.8725 | 46.84 | 46.8725 | 2800.0 |
| 2018-05-18 07:55:00 | AAPL | Stock | 46.8625 | 46.8625 | 46.8375 | 46.8375 | 6600.0 |
| 2018-05-18 08:00:00 | AAPL | Stock | 46.8475 | 46.875 | 46.8125 | 46.8125 | 62088.0 |
| 2018-05-18 08:05:00 | AAPL | Stock | 46.8125 | 46.8125 | 46.8125 | 46.8125 | 1632.0 |
| 2018-05-18 08:10:00 | AAPL | Stock | 46.7875 | 46.79 | 46.7725 | 46.7825 | 13392.0 |
| 2018-05-18 08:15:00 | AAPL | Stock | 46.7625 | 46.775 | 46.75 | 46.75 | 8320.0 |
| 2018-05-18 08:20:00 | AAPL | Stock | 46.7375 | 46.7375 | 46.7375 | 46.7375 | 800.0 |
| 2018-05-18 08:25:00 | AAPL | Stock | 46.7912 | 46.7912 | 46.7525 | 46.775 | 11680.0 |
| 2018-05-18 08:30:00 | AAPL | Stock | 46.755 | 46.775 | 46.725 | 46.725 | 21472.0 |
| 2018-05-18 08:35:00 | AAPL | Stock | 46.7275 | 46.74 | 46.7 | 46.7075 | 31884.0 |
| 2018-05-18 08:40:00 | AAPL | Stock | 46.7125 | 46.7125 | 46.685 | 46.69 | 50592.0 |
| 2018-05-18 08:45:00 | AAPL | Stock | 46.69 | 46.69 | 46.6525 | 46.6675 | 17336.0 |
| 2018-05-18 08:50:00 | AAPL | Stock | 46.6675 | 46.6675 | 46.6375 | 46.645 | 26032.0 |
| 2018-05-18 08:55:00 | AAPL | Stock | 46.645 | 46.685 | 46.64 | 46.64 | 17952.0 |
| 2018-05-18 09:00:00 | AAPL | Stock | 46.6375 | 46.6625 | 46.6375 | 46.6625 | 4712.0 |
| 2018-05-18 09:05:00 | AAPL | Stock | 46.6625 | 46.69 | 46.6525 | 46.69 | 7520.0 |
| 2018-05-18 09:10:00 | AAPL | Stock | 46.685 | 46.685 | 46.625 | 46.6275 | 26220.0 |
| 2018-05-18 09:15:00 | AAPL | Stock | 46.6475 | 46.6725 | 46.635 | 46.6725 | 24192.0 |
| 2018-05-18 09:20:00 | AAPL | Stock | 46.6725 | 46.69 | 46.6725 | 46.685 | 11468.0 |
| 2018-05-18 09:25:00 | AAPL | Stock | 46.7 | 46.8925 | 46.68 | 46.7825 | 208404.0 |
| 2018-05-18 09:30:00 | AAPL | Stock | 46.7975 | 46.84 | 46.6675 | 46.6975 | 5908760.0 |
| 2018-05-18 09:35:00 | AAPL | Stock | 46.7 | 46.71 | 46.62 | 46.665 | 1549924.0 |
| 2018-05-18 09:40:00 | AAPL | Stock | 46.6625 | 46.77 | 46.64 | 46.74 | 977156.0 |
| 2018-05-18 09:45:00 | AAPL | Stock | 46.73 | 46.8325 | 46.7 | 46.8025 | 1146328.0 |
| 2018-05-18 09:50:00 | AAPL | Stock | 46.805 | 46.8075 | 46.6655 | 46.67 | 1106936.0 |
| 2018-05-18 09:55:00 | AAPL | Stock | 46.675 | 46.7 | 46.645 | 46.68 | 677320.0 |
| 2018-05-18 10:00:00 | AAPL | Stock | 46.6825 | 46.7332 | 46.63 | 46.6775 | 931096.0 |
| 2018-05-18 10:05:00 | AAPL | Stock | 46.675 | 46.7325 | 46.615 | 46.7138 | 999440.0 |
| 2018-05-18 10:10:00 | AAPL | Stock | 46.7125 | 46.8125 | 46.695 | 46.8112 | 1520540.0 |
> showing 50 of 355,620 rows — these rows as CSV