PREVIEW / stock_5min / 2017-03-29
file: by_date/stock_5min/2017/2017-03-29.parquet size: 5.4 MB rows: 354,804 symbols: 3,095
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-29 04:00:00 | AAPL | Stock | 35.925 | 35.925 | 35.925 | 35.925 | 800.0 |
| 2017-03-29 04:05:00 | AAPL | Stock | 35.98 | 35.9975 | 35.975 | 35.975 | 11624.0 |
| 2017-03-29 04:15:00 | AAPL | Stock | 35.975 | 35.9875 | 35.975 | 35.9875 | 16000.0 |
| 2017-03-29 04:25:00 | AAPL | Stock | 35.9875 | 35.9875 | 35.9875 | 35.9875 | 1200.0 |
| 2017-03-29 04:35:00 | AAPL | Stock | 35.9625 | 35.9625 | 35.9625 | 35.9625 | 560.0 |
| 2017-03-29 04:45:00 | AAPL | Stock | 35.9625 | 35.9625 | 35.9625 | 35.9625 | 800.0 |
| 2017-03-29 05:45:00 | AAPL | Stock | 35.905 | 35.905 | 35.905 | 35.905 | 4800.0 |
| 2017-03-29 06:05:00 | AAPL | Stock | 35.93 | 35.93 | 35.9125 | 35.93 | 1960.0 |
| 2017-03-29 06:10:00 | AAPL | Stock | 35.9125 | 35.9125 | 35.91 | 35.91 | 3332.0 |
| 2017-03-29 06:15:00 | AAPL | Stock | 35.91 | 35.91 | 35.91 | 35.91 | 4384.0 |
| 2017-03-29 06:25:00 | AAPL | Stock | 35.9075 | 35.9425 | 35.9075 | 35.925 | 3760.0 |
| 2017-03-29 06:40:00 | AAPL | Stock | 35.9375 | 35.9375 | 35.9375 | 35.9375 | 1700.0 |
| 2017-03-29 06:45:00 | AAPL | Stock | 35.905 | 35.905 | 35.905 | 35.905 | 800.0 |
| 2017-03-29 07:00:00 | AAPL | Stock | 35.875 | 35.88 | 35.875 | 35.88 | 2800.0 |
| 2017-03-29 07:05:00 | AAPL | Stock | 35.8875 | 35.9025 | 35.8875 | 35.9 | 6124.0 |
| 2017-03-29 07:15:00 | AAPL | Stock | 35.93 | 35.93 | 35.925 | 35.925 | 5200.0 |
| 2017-03-29 07:20:00 | AAPL | Stock | 35.925 | 35.925 | 35.905 | 35.905 | 5600.0 |
| 2017-03-29 07:25:00 | AAPL | Stock | 35.905 | 35.925 | 35.9025 | 35.9225 | 4800.0 |
| 2017-03-29 07:30:00 | AAPL | Stock | 35.9225 | 35.9225 | 35.91 | 35.9225 | 9432.0 |
| 2017-03-29 07:35:00 | AAPL | Stock | 35.9125 | 35.9125 | 35.9 | 35.9 | 15084.0 |
| 2017-03-29 07:40:00 | AAPL | Stock | 35.9 | 35.9 | 35.875 | 35.875 | 5460.0 |
| 2017-03-29 07:45:00 | AAPL | Stock | 35.875 | 35.875 | 35.855 | 35.855 | 800.0 |
| 2017-03-29 07:50:00 | AAPL | Stock | 35.865 | 35.8875 | 35.86 | 35.875 | 7192.0 |
| 2017-03-29 07:55:00 | AAPL | Stock | 35.875 | 35.885 | 35.875 | 35.885 | 1200.0 |
| 2017-03-29 08:00:00 | AAPL | Stock | 35.885 | 35.925 | 35.875 | 35.89 | 60236.0 |
| 2017-03-29 08:05:00 | AAPL | Stock | 35.9025 | 35.9075 | 35.9025 | 35.9075 | 5284.0 |
| 2017-03-29 08:10:00 | AAPL | Stock | 35.8875 | 35.9075 | 35.8875 | 35.8925 | 5172.0 |
| 2017-03-29 08:15:00 | AAPL | Stock | 35.9 | 35.91 | 35.8925 | 35.895 | 16000.0 |
| 2017-03-29 08:20:00 | AAPL | Stock | 35.8925 | 35.9 | 35.8925 | 35.9 | 3400.0 |
| 2017-03-29 08:25:00 | AAPL | Stock | 35.905 | 35.905 | 35.895 | 35.895 | 6160.0 |
| 2017-03-29 08:30:00 | AAPL | Stock | 35.895 | 35.915 | 35.8875 | 35.915 | 9672.0 |
| 2017-03-29 08:35:00 | AAPL | Stock | 35.9125 | 35.9125 | 35.9075 | 35.9075 | 14200.0 |
| 2017-03-29 08:40:00 | AAPL | Stock | 35.915 | 35.9175 | 35.91 | 35.9175 | 7388.0 |
| 2017-03-29 08:45:00 | AAPL | Stock | 35.92 | 35.925 | 35.9 | 35.9 | 32296.0 |
| 2017-03-29 08:50:00 | AAPL | Stock | 35.9075 | 35.9075 | 35.9 | 35.9075 | 8084.0 |
| 2017-03-29 08:55:00 | AAPL | Stock | 35.9 | 35.9175 | 35.9 | 35.9175 | 10000.0 |
| 2017-03-29 09:00:00 | AAPL | Stock | 35.905 | 35.92 | 35.905 | 35.905 | 21252.0 |
| 2017-03-29 09:05:00 | AAPL | Stock | 35.905 | 35.905 | 35.9 | 35.905 | 36700.0 |
| 2017-03-29 09:10:00 | AAPL | Stock | 35.9075 | 35.9075 | 35.9 | 35.9 | 26860.0 |
| 2017-03-29 09:15:00 | AAPL | Stock | 35.8975 | 35.9 | 35.875 | 35.875 | 84308.0 |
| 2017-03-29 09:20:00 | AAPL | Stock | 35.875 | 35.8975 | 35.875 | 35.885 | 18692.0 |
| 2017-03-29 09:25:00 | AAPL | Stock | 35.9 | 35.92 | 35.89 | 35.92 | 52288.0 |
| 2017-03-29 09:30:00 | AAPL | Stock | 35.92 | 35.9375 | 35.855 | 35.935 | 5237776.0 |
| 2017-03-29 09:35:00 | AAPL | Stock | 35.935 | 35.995 | 35.9125 | 35.9875 | 3336188.0 |
| 2017-03-29 09:40:00 | AAPL | Stock | 35.9875 | 36.05 | 35.915 | 35.9225 | 4625180.0 |
| 2017-03-29 09:45:00 | AAPL | Stock | 35.9212 | 35.9225 | 35.7975 | 35.8525 | 4261512.0 |
| 2017-03-29 09:50:00 | AAPL | Stock | 35.855 | 35.89 | 35.8275 | 35.89 | 2529516.0 |
| 2017-03-29 09:55:00 | AAPL | Stock | 35.8925 | 35.955 | 35.8775 | 35.9525 | 1917344.0 |
| 2017-03-29 10:00:00 | AAPL | Stock | 35.9525 | 35.955 | 35.8775 | 35.88 | 1824704.0 |
| 2017-03-29 10:05:00 | AAPL | Stock | 35.88 | 35.88 | 35.8275 | 35.8325 | 1632644.0 |
> showing 50 of 354,804 rows — these rows as CSV