PREVIEW / stock_5min / 2018-12-11
file: by_date/stock_5min/2018/2018-12-11.parquet size: 5.7 MB rows: 364,508 symbols: 2,730
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-12-11 04:05:00 | AAPL | Stock | 42.375 | 42.375 | 42.375 | 42.375 | 572.0 |
| 2018-12-11 04:10:00 | AAPL | Stock | 42.375 | 42.375 | 42.375 | 42.375 | 568.0 |
| 2018-12-11 04:15:00 | AAPL | Stock | 42.3325 | 42.5125 | 42.2875 | 42.5125 | 7984.0 |
| 2018-12-11 04:20:00 | AAPL | Stock | 42.5 | 42.5 | 42.5 | 42.5 | 400.0 |
| 2018-12-11 04:25:00 | AAPL | Stock | 42.485 | 42.485 | 42.485 | 42.485 | 1360.0 |
| 2018-12-11 04:30:00 | AAPL | Stock | 42.5 | 42.5 | 42.5 | 42.5 | 400.0 |
| 2018-12-11 04:40:00 | AAPL | Stock | 42.45 | 42.45 | 42.45 | 42.45 | 1700.0 |
| 2018-12-11 04:55:00 | AAPL | Stock | 42.6425 | 42.6425 | 42.6425 | 42.6425 | 400.0 |
| 2018-12-11 05:00:00 | AAPL | Stock | 42.6425 | 42.675 | 42.6425 | 42.675 | 4152.0 |
| 2018-12-11 05:15:00 | AAPL | Stock | 42.7 | 42.8275 | 42.7 | 42.8275 | 2808.0 |
| 2018-12-11 05:20:00 | AAPL | Stock | 42.85 | 42.85 | 42.85 | 42.85 | 1184.0 |
| 2018-12-11 05:30:00 | AAPL | Stock | 42.805 | 42.805 | 42.8 | 42.8 | 4000.0 |
| 2018-12-11 05:35:00 | AAPL | Stock | 42.78 | 42.8075 | 42.775 | 42.8075 | 5000.0 |
| 2018-12-11 05:45:00 | AAPL | Stock | 42.8125 | 42.8125 | 42.8125 | 42.8125 | 7080.0 |
| 2018-12-11 05:50:00 | AAPL | Stock | 42.8125 | 42.8375 | 42.8125 | 42.8375 | 2888.0 |
| 2018-12-11 05:55:00 | AAPL | Stock | 42.8375 | 42.845 | 42.8375 | 42.845 | 8172.0 |
| 2018-12-11 06:00:00 | AAPL | Stock | 42.7575 | 42.8175 | 42.75 | 42.8175 | 11576.0 |
| 2018-12-11 06:05:00 | AAPL | Stock | 42.8175 | 42.82 | 42.81 | 42.81 | 2200.0 |
| 2018-12-11 06:10:00 | AAPL | Stock | 42.7875 | 42.7875 | 42.775 | 42.775 | 2864.0 |
| 2018-12-11 06:15:00 | AAPL | Stock | 42.78 | 42.78 | 42.7625 | 42.7625 | 15924.0 |
| 2018-12-11 06:20:00 | AAPL | Stock | 42.79 | 42.7925 | 42.78 | 42.78 | 12088.0 |
| 2018-12-11 06:25:00 | AAPL | Stock | 42.7975 | 42.7975 | 42.7975 | 42.7975 | 1340.0 |
| 2018-12-11 06:35:00 | AAPL | Stock | 42.8 | 42.845 | 42.8 | 42.8225 | 13600.0 |
| 2018-12-11 06:40:00 | AAPL | Stock | 42.8425 | 42.8425 | 42.8375 | 42.8375 | 2464.0 |
| 2018-12-11 06:45:00 | AAPL | Stock | 42.8075 | 42.895 | 42.8 | 42.895 | 22704.0 |
| 2018-12-11 06:50:00 | AAPL | Stock | 42.85 | 42.85 | 42.8 | 42.8 | 3600.0 |
| 2018-12-11 06:55:00 | AAPL | Stock | 42.775 | 42.8 | 42.775 | 42.78 | 3200.0 |
| 2018-12-11 07:00:00 | AAPL | Stock | 42.84 | 42.95 | 42.795 | 42.95 | 50428.0 |
| 2018-12-11 07:05:00 | AAPL | Stock | 42.925 | 42.9475 | 42.875 | 42.9475 | 12500.0 |
| 2018-12-11 07:10:00 | AAPL | Stock | 42.9475 | 42.9475 | 42.9125 | 42.925 | 11260.0 |
| 2018-12-11 07:15:00 | AAPL | Stock | 42.925 | 42.9475 | 42.905 | 42.925 | 22780.0 |
| 2018-12-11 07:20:00 | AAPL | Stock | 42.9475 | 42.9475 | 42.88 | 42.89 | 43344.0 |
| 2018-12-11 07:25:00 | AAPL | Stock | 42.8875 | 42.8875 | 42.85 | 42.8625 | 23068.0 |
| 2018-12-11 07:30:00 | AAPL | Stock | 42.8425 | 42.8425 | 42.7775 | 42.8125 | 16660.0 |
| 2018-12-11 07:35:00 | AAPL | Stock | 42.8125 | 42.8575 | 42.8 | 42.8225 | 25948.0 |
| 2018-12-11 07:40:00 | AAPL | Stock | 42.8025 | 42.825 | 42.8 | 42.815 | 12260.0 |
| 2018-12-11 07:45:00 | AAPL | Stock | 42.815 | 42.85 | 42.7925 | 42.825 | 42208.0 |
| 2018-12-11 07:50:00 | AAPL | Stock | 42.8375 | 42.8575 | 42.825 | 42.8475 | 21824.0 |
| 2018-12-11 07:55:00 | AAPL | Stock | 42.84 | 42.8425 | 42.8025 | 42.8025 | 39256.0 |
| 2018-12-11 08:00:00 | AAPL | Stock | 42.8962 | 42.95 | 42.7875 | 42.83 | 189784.0 |
| 2018-12-11 08:05:00 | AAPL | Stock | 42.835 | 42.8375 | 42.7975 | 42.7975 | 42380.0 |
| 2018-12-11 08:10:00 | AAPL | Stock | 42.7975 | 42.85 | 42.4 | 42.825 | 62912.0 |
| 2018-12-11 08:15:00 | AAPL | Stock | 42.8425 | 42.8975 | 42.825 | 42.8875 | 73968.0 |
| 2018-12-11 08:20:00 | AAPL | Stock | 42.8925 | 42.9125 | 42.8775 | 42.9125 | 69496.0 |
| 2018-12-11 08:25:00 | AAPL | Stock | 42.9 | 42.96 | 42.8875 | 42.925 | 79992.0 |
| 2018-12-11 08:30:00 | AAPL | Stock | 42.925 | 42.95 | 42.8975 | 42.945 | 108720.0 |
| 2018-12-11 08:35:00 | AAPL | Stock | 42.9425 | 42.975 | 42.94 | 42.9625 | 83308.0 |
| 2018-12-11 08:40:00 | AAPL | Stock | 42.965 | 42.995 | 42.9125 | 42.955 | 191484.0 |
| 2018-12-11 08:45:00 | AAPL | Stock | 42.9825 | 42.985 | 42.9025 | 42.94 | 97124.0 |
| 2018-12-11 08:50:00 | AAPL | Stock | 42.925 | 42.925 | 42.9 | 42.9025 | 43920.0 |
> showing 50 of 364,508 rows — these rows as CSV