PREVIEW / stock_5min / 2015-03-16
file: by_date/stock_5min/2015/2015-03-16.parquet size: 5.5 MB rows: 365,224 symbols: 3,525
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-03-16 04:00:00 | AAPL | Stock | 30.9075 | 30.9275 | 30.9075 | 30.9275 | 5840.0 |
| 2015-03-16 04:05:00 | AAPL | Stock | 30.95 | 30.95 | 30.95 | 30.95 | 1200.0 |
| 2015-03-16 04:30:00 | AAPL | Stock | 30.925 | 30.925 | 30.925 | 30.925 | 400.0 |
| 2015-03-16 04:35:00 | AAPL | Stock | 30.95 | 30.95 | 30.95 | 30.95 | 4800.0 |
| 2015-03-16 04:40:00 | AAPL | Stock | 30.9625 | 30.9625 | 30.9625 | 30.9625 | 1600.0 |
| 2015-03-16 04:50:00 | AAPL | Stock | 30.9625 | 31.0075 | 30.9625 | 31.0075 | 6640.0 |
| 2015-03-16 04:55:00 | AAPL | Stock | 31.0125 | 31.0125 | 31.0 | 31.0 | 12000.0 |
| 2015-03-16 05:00:00 | AAPL | Stock | 31.02 | 31.02 | 31.02 | 31.02 | 400.0 |
| 2015-03-16 05:10:00 | AAPL | Stock | 31.0425 | 31.0425 | 30.995 | 30.995 | 2800.0 |
| 2015-03-16 05:30:00 | AAPL | Stock | 30.985 | 30.985 | 30.985 | 30.985 | 400.0 |
| 2015-03-16 05:55:00 | AAPL | Stock | 31.0 | 31.0 | 30.995 | 30.995 | 10000.0 |
| 2015-03-16 06:05:00 | AAPL | Stock | 31.0 | 31.0 | 31.0 | 31.0 | 7992.0 |
| 2015-03-16 06:10:00 | AAPL | Stock | 30.9975 | 31.0 | 30.9975 | 31.0 | 10800.0 |
| 2015-03-16 06:15:00 | AAPL | Stock | 30.9975 | 30.9975 | 30.9975 | 30.9975 | 520.0 |
| 2015-03-16 06:35:00 | AAPL | Stock | 30.9975 | 30.9975 | 30.9975 | 30.9975 | 6040.0 |
| 2015-03-16 06:40:00 | AAPL | Stock | 30.9975 | 30.9975 | 30.97 | 30.97 | 3704.0 |
| 2015-03-16 06:45:00 | AAPL | Stock | 30.9675 | 30.9675 | 30.9625 | 30.9625 | 800.0 |
| 2015-03-16 06:50:00 | AAPL | Stock | 30.9625 | 30.9625 | 30.9625 | 30.9625 | 1404.0 |
| 2015-03-16 07:00:00 | AAPL | Stock | 30.98 | 30.9825 | 30.98 | 30.9825 | 2800.0 |
| 2015-03-16 07:10:00 | AAPL | Stock | 30.965 | 30.965 | 30.965 | 30.965 | 1000.0 |
| 2015-03-16 07:20:00 | AAPL | Stock | 30.95 | 30.95 | 30.95 | 30.95 | 400.0 |
| 2015-03-16 07:30:00 | AAPL | Stock | 30.9575 | 30.9575 | 30.9375 | 30.945 | 18556.0 |
| 2015-03-16 07:35:00 | AAPL | Stock | 30.945 | 30.955 | 30.945 | 30.955 | 24400.0 |
| 2015-03-16 07:40:00 | AAPL | Stock | 30.95 | 30.95 | 30.95 | 30.95 | 5200.0 |
| 2015-03-16 07:45:00 | AAPL | Stock | 30.95 | 30.95 | 30.95 | 30.95 | 6800.0 |
| 2015-03-16 07:50:00 | AAPL | Stock | 30.9375 | 30.9375 | 30.9325 | 30.9325 | 9248.0 |
| 2015-03-16 08:00:00 | AAPL | Stock | 30.95 | 30.9825 | 30.8975 | 30.9075 | 103176.0 |
| 2015-03-16 08:05:00 | AAPL | Stock | 30.91 | 30.915 | 30.8825 | 30.885 | 56696.0 |
| 2015-03-16 08:10:00 | AAPL | Stock | 30.885 | 30.8975 | 30.86 | 30.8625 | 85864.0 |
| 2015-03-16 08:15:00 | AAPL | Stock | 30.8625 | 30.875 | 30.8625 | 30.8675 | 19600.0 |
| 2015-03-16 08:20:00 | AAPL | Stock | 30.87 | 30.88 | 30.8625 | 30.88 | 38652.0 |
| 2015-03-16 08:25:00 | AAPL | Stock | 30.875 | 30.905 | 30.875 | 30.905 | 21304.0 |
| 2015-03-16 08:30:00 | AAPL | Stock | 30.9002 | 30.9275 | 30.9002 | 30.915 | 63084.0 |
| 2015-03-16 08:35:00 | AAPL | Stock | 30.92 | 30.925 | 30.89 | 30.89 | 66300.0 |
| 2015-03-16 08:40:00 | AAPL | Stock | 30.88 | 30.895 | 30.8625 | 30.875 | 82296.0 |
| 2015-03-16 08:45:00 | AAPL | Stock | 30.875 | 30.8875 | 30.845 | 30.86 | 120700.0 |
| 2015-03-16 08:50:00 | AAPL | Stock | 30.8575 | 30.8725 | 30.8375 | 30.86 | 32020.0 |
| 2015-03-16 08:55:00 | AAPL | Stock | 30.87 | 30.8875 | 30.8625 | 30.8775 | 37116.0 |
| 2015-03-16 09:00:00 | AAPL | Stock | 30.8775 | 30.905 | 30.8775 | 30.8975 | 69572.0 |
| 2015-03-16 09:05:00 | AAPL | Stock | 30.9 | 30.9 | 30.8902 | 30.8925 | 50920.0 |
| 2015-03-16 09:10:00 | AAPL | Stock | 30.9 | 30.9175 | 30.895 | 30.905 | 60588.0 |
| 2015-03-16 09:15:00 | AAPL | Stock | 30.9075 | 30.9175 | 30.8875 | 30.8875 | 58168.0 |
| 2015-03-16 09:20:00 | AAPL | Stock | 30.8875 | 30.915 | 30.8825 | 30.9125 | 70396.0 |
| 2015-03-16 09:25:00 | AAPL | Stock | 30.915 | 30.975 | 30.9 | 30.9225 | 305308.0 |
| 2015-03-16 09:30:00 | AAPL | Stock | 30.97 | 30.9975 | 30.805 | 30.845 | 6707704.0 |
| 2015-03-16 09:35:00 | AAPL | Stock | 30.8425 | 30.8775 | 30.7175 | 30.755 | 4268416.0 |
| 2015-03-16 09:40:00 | AAPL | Stock | 30.755 | 30.8725 | 30.755 | 30.7878 | 2763844.0 |
| 2015-03-16 09:45:00 | AAPL | Stock | 30.7888 | 30.8075 | 30.72 | 30.755 | 3075412.0 |
| 2015-03-16 09:50:00 | AAPL | Stock | 30.755 | 30.9625 | 30.755 | 30.9325 | 3986500.0 |
| 2015-03-16 09:55:00 | AAPL | Stock | 30.935 | 30.9625 | 30.9 | 30.91 | 2717024.0 |
> showing 50 of 365,224 rows — these rows as CSV