PREVIEW / stock_5min / 2017-04-10
file: by_date/stock_5min/2017/2017-04-10.parquet size: 5.4 MB rows: 353,469 symbols: 3,061
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-04-10 04:05:00 | AAPL | Stock | 35.925 | 35.925 | 35.925 | 35.925 | 400.0 |
| 2017-04-10 04:20:00 | AAPL | Stock | 35.91 | 35.91 | 35.91 | 35.91 | 408.0 |
| 2017-04-10 04:50:00 | AAPL | Stock | 35.9875 | 35.9875 | 35.9875 | 35.9875 | 736.0 |
| 2017-04-10 05:55:00 | AAPL | Stock | 35.9 | 35.9 | 35.895 | 35.895 | 3920.0 |
| 2017-04-10 06:00:00 | AAPL | Stock | 35.9 | 35.9 | 35.8775 | 35.8775 | 2800.0 |
| 2017-04-10 06:55:00 | AAPL | Stock | 35.925 | 35.925 | 35.9125 | 35.915 | 1200.0 |
| 2017-04-10 07:00:00 | AAPL | Stock | 35.925 | 35.925 | 35.88 | 35.88 | 5200.0 |
| 2017-04-10 07:05:00 | AAPL | Stock | 35.895 | 35.895 | 35.895 | 35.895 | 5600.0 |
| 2017-04-10 07:15:00 | AAPL | Stock | 35.9 | 35.9 | 35.9 | 35.9 | 504.0 |
| 2017-04-10 07:25:00 | AAPL | Stock | 35.9 | 35.9 | 35.9 | 35.9 | 7400.0 |
| 2017-04-10 07:30:00 | AAPL | Stock | 35.9325 | 35.9325 | 35.9325 | 35.9325 | 1332.0 |
| 2017-04-10 07:50:00 | AAPL | Stock | 35.9125 | 35.9125 | 35.9125 | 35.9125 | 1800.0 |
| 2017-04-10 07:55:00 | AAPL | Stock | 35.925 | 35.925 | 35.92 | 35.92 | 5600.0 |
| 2017-04-10 08:00:00 | AAPL | Stock | 35.9125 | 35.93 | 35.8875 | 35.93 | 44224.0 |
| 2017-04-10 08:05:00 | AAPL | Stock | 35.925 | 35.925 | 35.925 | 35.925 | 800.0 |
| 2017-04-10 08:10:00 | AAPL | Stock | 35.925 | 35.925 | 35.925 | 35.925 | 2148.0 |
| 2017-04-10 08:20:00 | AAPL | Stock | 35.91 | 35.9125 | 35.91 | 35.9125 | 4532.0 |
| 2017-04-10 08:25:00 | AAPL | Stock | 35.91 | 35.9125 | 35.91 | 35.9125 | 3780.0 |
| 2017-04-10 08:30:00 | AAPL | Stock | 35.9125 | 35.915 | 35.9 | 35.9025 | 19520.0 |
| 2017-04-10 08:35:00 | AAPL | Stock | 35.89 | 35.89 | 35.8875 | 35.8875 | 6800.0 |
| 2017-04-10 08:45:00 | AAPL | Stock | 35.895 | 35.8975 | 35.885 | 35.8875 | 8800.0 |
| 2017-04-10 08:50:00 | AAPL | Stock | 35.8875 | 35.8875 | 35.875 | 35.875 | 19560.0 |
| 2017-04-10 08:55:00 | AAPL | Stock | 35.8675 | 35.875 | 35.865 | 35.875 | 11200.0 |
| 2017-04-10 09:00:00 | AAPL | Stock | 35.885 | 35.885 | 35.875 | 35.885 | 15976.0 |
| 2017-04-10 09:05:00 | AAPL | Stock | 35.885 | 35.8875 | 35.885 | 35.8875 | 11940.0 |
| 2017-04-10 09:10:00 | AAPL | Stock | 35.8825 | 35.8825 | 35.8825 | 35.8825 | 400.0 |
| 2017-04-10 09:20:00 | AAPL | Stock | 35.8825 | 35.905 | 35.8825 | 35.905 | 3200.0 |
| 2017-04-10 09:25:00 | AAPL | Stock | 35.905 | 35.9125 | 35.875 | 35.89 | 32000.0 |
| 2017-04-10 09:30:00 | AAPL | Stock | 35.9 | 35.9698 | 35.875 | 35.93 | 2333368.0 |
| 2017-04-10 09:35:00 | AAPL | Stock | 35.93 | 35.945 | 35.905 | 35.935 | 1240308.0 |
| 2017-04-10 09:40:00 | AAPL | Stock | 35.935 | 35.9375 | 35.905 | 35.92 | 1043424.0 |
| 2017-04-10 09:45:00 | AAPL | Stock | 35.9212 | 35.93 | 35.89 | 35.9075 | 935688.0 |
| 2017-04-10 09:50:00 | AAPL | Stock | 35.9088 | 35.91 | 35.8625 | 35.8925 | 1435116.0 |
| 2017-04-10 09:55:00 | AAPL | Stock | 35.8912 | 35.925 | 35.875 | 35.915 | 888128.0 |
| 2017-04-10 10:00:00 | AAPL | Stock | 35.915 | 35.9175 | 35.8525 | 35.8775 | 881956.0 |
| 2017-04-10 10:05:00 | AAPL | Stock | 35.875 | 35.9038 | 35.865 | 35.8975 | 640080.0 |
| 2017-04-10 10:10:00 | AAPL | Stock | 35.8975 | 35.9075 | 35.8775 | 35.8775 | 554364.0 |
| 2017-04-10 10:15:00 | AAPL | Stock | 35.8775 | 35.8925 | 35.855 | 35.8775 | 762836.0 |
| 2017-04-10 10:20:00 | AAPL | Stock | 35.875 | 35.8872 | 35.8625 | 35.8675 | 604924.0 |
| 2017-04-10 10:25:00 | AAPL | Stock | 35.865 | 35.875 | 35.8475 | 35.856 | 553004.0 |
| 2017-04-10 10:30:00 | AAPL | Stock | 35.8575 | 35.895 | 35.8575 | 35.8825 | 725704.0 |
| 2017-04-10 10:35:00 | AAPL | Stock | 35.885 | 35.9175 | 35.884 | 35.8952 | 698512.0 |
| 2017-04-10 10:40:00 | AAPL | Stock | 35.895 | 35.905 | 35.885 | 35.895 | 936324.0 |
| 2017-04-10 10:45:00 | AAPL | Stock | 35.8975 | 35.9125 | 35.8875 | 35.8975 | 610188.0 |
| 2017-04-10 10:50:00 | AAPL | Stock | 35.9 | 35.915 | 35.8875 | 35.9125 | 596856.0 |
| 2017-04-10 10:55:00 | AAPL | Stock | 35.913 | 35.9188 | 35.86 | 35.87 | 967020.0 |
| 2017-04-10 11:00:00 | AAPL | Stock | 35.8675 | 35.885 | 35.8575 | 35.885 | 612532.0 |
| 2017-04-10 11:05:00 | AAPL | Stock | 35.885 | 35.89 | 35.8625 | 35.8775 | 441892.0 |
| 2017-04-10 11:10:00 | AAPL | Stock | 35.8775 | 35.8888 | 35.865 | 35.8725 | 626464.0 |
| 2017-04-10 11:15:00 | AAPL | Stock | 35.8738 | 35.8825 | 35.865 | 35.8675 | 402260.0 |
> showing 50 of 353,469 rows — these rows as CSV