PREVIEW / stock_5min / 2015-10-16
file: by_date/stock_5min/2015/2015-10-16.parquet size: 5.3 MB rows: 349,902 symbols: 3,419
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 |
|---|---|---|---|---|---|---|---|
| 2015-10-16 04:00:00 | AAPL | Stock | 27.9775 | 27.9775 | 27.9775 | 27.9775 | 400.0 |
| 2015-10-16 04:40:00 | AAPL | Stock | 27.99 | 27.99 | 27.99 | 27.99 | 400.0 |
| 2015-10-16 05:10:00 | AAPL | Stock | 28.0025 | 28.0025 | 28.0025 | 28.0025 | 2000.0 |
| 2015-10-16 05:15:00 | AAPL | Stock | 27.985 | 27.985 | 27.985 | 27.985 | 400.0 |
| 2015-10-16 06:25:00 | AAPL | Stock | 27.9575 | 27.9575 | 27.95 | 27.95 | 3124.0 |
| 2015-10-16 06:30:00 | AAPL | Stock | 27.945 | 27.945 | 27.925 | 27.93 | 4400.0 |
| 2015-10-16 06:35:00 | AAPL | Stock | 27.9275 | 27.9275 | 27.925 | 27.925 | 800.0 |
| 2015-10-16 06:40:00 | AAPL | Stock | 27.925 | 27.925 | 27.91 | 27.91 | 4400.0 |
| 2015-10-16 06:45:00 | AAPL | Stock | 27.925 | 27.925 | 27.925 | 27.925 | 760.0 |
| 2015-10-16 07:00:00 | AAPL | Stock | 27.9075 | 27.9075 | 27.9 | 27.9 | 11600.0 |
| 2015-10-16 07:05:00 | AAPL | Stock | 27.8925 | 27.9 | 27.8925 | 27.9 | 7984.0 |
| 2015-10-16 07:10:00 | AAPL | Stock | 27.9 | 27.9 | 27.8825 | 27.8825 | 1600.0 |
| 2015-10-16 07:20:00 | AAPL | Stock | 27.88 | 27.88 | 27.875 | 27.875 | 1736.0 |
| 2015-10-16 07:25:00 | AAPL | Stock | 27.875 | 27.8775 | 27.875 | 27.875 | 3464.0 |
| 2015-10-16 07:35:00 | AAPL | Stock | 27.8925 | 27.895 | 27.8925 | 27.895 | 2400.0 |
| 2015-10-16 07:55:00 | AAPL | Stock | 27.89 | 27.9 | 27.89 | 27.9 | 8400.0 |
| 2015-10-16 08:00:00 | AAPL | Stock | 27.9075 | 27.9475 | 27.875 | 27.92 | 35460.0 |
| 2015-10-16 08:05:00 | AAPL | Stock | 27.92 | 27.92 | 27.9025 | 27.9025 | 19028.0 |
| 2015-10-16 08:10:00 | AAPL | Stock | 27.915 | 27.9225 | 27.915 | 27.92 | 8800.0 |
| 2015-10-16 08:15:00 | AAPL | Stock | 27.925 | 27.9625 | 27.9125 | 27.9625 | 6564.0 |
| 2015-10-16 08:20:00 | AAPL | Stock | 27.94 | 27.94 | 27.8825 | 27.8825 | 85552.0 |
| 2015-10-16 08:25:00 | AAPL | Stock | 27.895 | 27.9 | 27.875 | 27.8875 | 86628.0 |
| 2015-10-16 08:30:00 | AAPL | Stock | 27.8875 | 27.8925 | 27.8875 | 27.89 | 35200.0 |
| 2015-10-16 08:35:00 | AAPL | Stock | 27.89 | 27.89 | 27.85 | 27.85 | 109504.0 |
| 2015-10-16 08:40:00 | AAPL | Stock | 27.85 | 27.8625 | 27.8375 | 27.8625 | 54480.0 |
| 2015-10-16 08:45:00 | AAPL | Stock | 27.8625 | 27.875 | 27.85 | 27.855 | 71924.0 |
| 2015-10-16 08:50:00 | AAPL | Stock | 27.865 | 27.8675 | 27.85 | 27.85 | 36000.0 |
| 2015-10-16 08:55:00 | AAPL | Stock | 27.85 | 27.8575 | 27.8475 | 27.8575 | 24108.0 |
| 2015-10-16 09:00:00 | AAPL | Stock | 27.875 | 27.8875 | 27.875 | 27.885 | 39264.0 |
| 2015-10-16 09:05:00 | AAPL | Stock | 27.8875 | 27.91 | 27.885 | 27.89 | 24536.0 |
| 2015-10-16 09:10:00 | AAPL | Stock | 27.89 | 27.9075 | 27.89 | 27.9075 | 11688.0 |
| 2015-10-16 09:15:00 | AAPL | Stock | 27.895 | 27.895 | 27.875 | 27.875 | 30200.0 |
| 2015-10-16 09:20:00 | AAPL | Stock | 27.86 | 27.8825 | 27.86 | 27.8725 | 38400.0 |
| 2015-10-16 09:25:00 | AAPL | Stock | 27.8625 | 27.9975 | 27.8375 | 27.88 | 2061216.0 |
| 2015-10-16 09:30:00 | AAPL | Stock | 27.945 | 28.0 | 27.8525 | 27.8725 | 12066772.0 |
| 2015-10-16 09:35:00 | AAPL | Stock | 27.8675 | 27.875 | 27.7875 | 27.86 | 3905624.0 |
| 2015-10-16 09:40:00 | AAPL | Stock | 27.8608 | 27.8825 | 27.8225 | 27.825 | 2779980.0 |
| 2015-10-16 09:45:00 | AAPL | Stock | 27.8238 | 27.8758 | 27.8025 | 27.8475 | 2502652.0 |
| 2015-10-16 09:50:00 | AAPL | Stock | 27.8478 | 27.9138 | 27.835 | 27.8975 | 2396480.0 |
| 2015-10-16 09:55:00 | AAPL | Stock | 27.8952 | 27.9 | 27.845 | 27.8865 | 2112500.0 |
| 2015-10-16 10:00:00 | AAPL | Stock | 27.8875 | 27.97 | 27.8725 | 27.92 | 3327032.0 |
| 2015-10-16 10:05:00 | AAPL | Stock | 27.9175 | 27.935 | 27.8325 | 27.8675 | 3163832.0 |
| 2015-10-16 10:10:00 | AAPL | Stock | 27.8675 | 27.9025 | 27.84 | 27.86 | 2091896.0 |
| 2015-10-16 10:15:00 | AAPL | Stock | 27.86 | 27.8625 | 27.805 | 27.8188 | 2327000.0 |
| 2015-10-16 10:20:00 | AAPL | Stock | 27.8175 | 27.84 | 27.7675 | 27.8025 | 2384152.0 |
| 2015-10-16 10:25:00 | AAPL | Stock | 27.8025 | 27.82 | 27.78 | 27.8198 | 1440620.0 |
| 2015-10-16 10:30:00 | AAPL | Stock | 27.82 | 27.8775 | 27.8025 | 27.849 | 1844068.0 |
| 2015-10-16 10:35:00 | AAPL | Stock | 27.85 | 27.8675 | 27.816 | 27.8175 | 1140556.0 |
| 2015-10-16 10:40:00 | AAPL | Stock | 27.8175 | 27.8275 | 27.795 | 27.7975 | 1045412.0 |
| 2015-10-16 10:45:00 | AAPL | Stock | 27.7975 | 27.9 | 27.7925 | 27.88 | 2744640.0 |
> showing 50 of 349,902 rows — these rows as CSV