PREVIEW / stock_5min / 2019-12-02
file: by_date/stock_5min/2019/2019-12-02.parquet size: 5.9 MB rows: 371,569 symbols: 2,496
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 |
|---|---|---|---|---|---|---|---|
| 2019-12-02 04:00:00 | AAPL | Stock | 67.0625 | 67.2125 | 67.0625 | 67.2125 | 14756.0 |
| 2019-12-02 04:05:00 | AAPL | Stock | 67.1925 | 67.25 | 67.1925 | 67.25 | 6180.0 |
| 2019-12-02 04:10:00 | AAPL | Stock | 67.225 | 67.225 | 67.225 | 67.225 | 2400.0 |
| 2019-12-02 04:15:00 | AAPL | Stock | 67.225 | 67.25 | 67.225 | 67.25 | 4400.0 |
| 2019-12-02 04:20:00 | AAPL | Stock | 67.24 | 67.2575 | 67.24 | 67.25 | 14068.0 |
| 2019-12-02 04:25:00 | AAPL | Stock | 67.31 | 67.31 | 67.2475 | 67.25 | 4000.0 |
| 2019-12-02 04:30:00 | AAPL | Stock | 67.25 | 67.25 | 67.25 | 67.25 | 2100.0 |
| 2019-12-02 04:35:00 | AAPL | Stock | 67.25 | 67.25 | 67.25 | 67.25 | 2696.0 |
| 2019-12-02 04:40:00 | AAPL | Stock | 67.2525 | 67.2525 | 67.25 | 67.25 | 3204.0 |
| 2019-12-02 04:45:00 | AAPL | Stock | 67.25 | 67.25 | 67.25 | 67.25 | 3600.0 |
| 2019-12-02 04:50:00 | AAPL | Stock | 67.2525 | 67.2525 | 67.2225 | 67.2225 | 4800.0 |
| 2019-12-02 04:55:00 | AAPL | Stock | 67.225 | 67.225 | 67.225 | 67.225 | 2000.0 |
| 2019-12-02 05:10:00 | AAPL | Stock | 67.2525 | 67.2525 | 67.2525 | 67.2525 | 8484.0 |
| 2019-12-02 05:20:00 | AAPL | Stock | 67.27 | 67.27 | 67.27 | 67.27 | 3600.0 |
| 2019-12-02 05:30:00 | AAPL | Stock | 67.29 | 67.3 | 67.29 | 67.3 | 1600.0 |
| 2019-12-02 05:40:00 | AAPL | Stock | 67.2925 | 67.2925 | 67.275 | 67.275 | 1200.0 |
| 2019-12-02 05:45:00 | AAPL | Stock | 67.2625 | 67.275 | 67.2625 | 67.275 | 3800.0 |
| 2019-12-02 05:50:00 | AAPL | Stock | 67.2675 | 67.2675 | 67.2675 | 67.2675 | 1200.0 |
| 2019-12-02 05:55:00 | AAPL | Stock | 67.2675 | 67.2675 | 67.2675 | 67.2675 | 640.0 |
| 2019-12-02 06:00:00 | AAPL | Stock | 67.2675 | 67.2675 | 67.1875 | 67.1875 | 21384.0 |
| 2019-12-02 06:05:00 | AAPL | Stock | 67.2075 | 67.225 | 67.2075 | 67.225 | 4000.0 |
| 2019-12-02 06:10:00 | AAPL | Stock | 67.1875 | 67.1875 | 67.17 | 67.17 | 21356.0 |
| 2019-12-02 06:15:00 | AAPL | Stock | 67.125 | 67.125 | 67.1 | 67.1 | 1536.0 |
| 2019-12-02 06:20:00 | AAPL | Stock | 67.125 | 67.125 | 67.1225 | 67.125 | 2000.0 |
| 2019-12-02 06:25:00 | AAPL | Stock | 67.1225 | 67.1225 | 67.1225 | 67.1225 | 4000.0 |
| 2019-12-02 06:30:00 | AAPL | Stock | 67.09 | 67.09 | 67.0275 | 67.0275 | 8280.0 |
| 2019-12-02 06:35:00 | AAPL | Stock | 67.03 | 67.03 | 66.975 | 66.98 | 7832.0 |
| 2019-12-02 06:40:00 | AAPL | Stock | 67.025 | 67.0725 | 67.025 | 67.0725 | 4800.0 |
| 2019-12-02 06:45:00 | AAPL | Stock | 67.03 | 67.0875 | 67.025 | 67.0875 | 3976.0 |
| 2019-12-02 06:55:00 | AAPL | Stock | 67.085 | 67.1 | 67.085 | 67.1 | 4800.0 |
| 2019-12-02 07:00:00 | AAPL | Stock | 67.075 | 67.075 | 66.9775 | 67.05 | 137040.0 |
| 2019-12-02 07:05:00 | AAPL | Stock | 67.0275 | 67.0275 | 66.9775 | 67.0225 | 42524.0 |
| 2019-12-02 07:10:00 | AAPL | Stock | 67.025 | 67.0275 | 67.0025 | 67.0025 | 7576.0 |
| 2019-12-02 07:15:00 | AAPL | Stock | 67.0225 | 67.025 | 67.0125 | 67.0125 | 4784.0 |
| 2019-12-02 07:20:00 | AAPL | Stock | 67.0125 | 67.0125 | 66.9675 | 66.9675 | 7952.0 |
| 2019-12-02 07:25:00 | AAPL | Stock | 66.9875 | 67.0 | 66.9875 | 67.0 | 8916.0 |
| 2019-12-02 07:30:00 | AAPL | Stock | 67.005 | 67.02 | 66.9775 | 67.0075 | 5860.0 |
| 2019-12-02 07:35:00 | AAPL | Stock | 67.0175 | 67.0175 | 67.0025 | 67.0025 | 1492.0 |
| 2019-12-02 07:40:00 | AAPL | Stock | 67.0025 | 67.0225 | 66.9675 | 67.0225 | 6164.0 |
| 2019-12-02 07:45:00 | AAPL | Stock | 67.0 | 67.0175 | 67.0 | 67.0 | 4796.0 |
| 2019-12-02 07:50:00 | AAPL | Stock | 67.0 | 67.0375 | 67.0 | 67.025 | 15304.0 |
| 2019-12-02 07:55:00 | AAPL | Stock | 67.03 | 67.05 | 67.0 | 67.0175 | 15372.0 |
| 2019-12-02 08:00:00 | AAPL | Stock | 67.0175 | 67.045 | 66.95 | 67.0025 | 94704.0 |
| 2019-12-02 08:05:00 | AAPL | Stock | 67.01 | 67.0125 | 66.975 | 66.975 | 14344.0 |
| 2019-12-02 08:10:00 | AAPL | Stock | 66.9825 | 67.0125 | 66.98 | 66.9975 | 15600.0 |
| 2019-12-02 08:15:00 | AAPL | Stock | 66.9775 | 66.9775 | 66.9 | 66.9275 | 25300.0 |
| 2019-12-02 08:20:00 | AAPL | Stock | 66.94 | 66.9525 | 66.8125 | 66.925 | 10484.0 |
| 2019-12-02 08:25:00 | AAPL | Stock | 66.925 | 66.9625 | 66.925 | 66.9625 | 10876.0 |
| 2019-12-02 08:30:00 | AAPL | Stock | 66.9425 | 66.9475 | 66.875 | 66.8875 | 36616.0 |
| 2019-12-02 08:35:00 | AAPL | Stock | 66.8875 | 66.925 | 66.8875 | 66.9175 | 22708.0 |
> showing 50 of 371,569 rows — these rows as CSV