PREVIEW / stock_5min / 2020-12-31
file: by_date/stock_5min/2020/2020-12-31.parquet size: 7.3 MB rows: 453,121 symbols: 2,685
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 |
|---|---|---|---|---|---|---|---|
| 2020-12-31 04:00:00 | AAPL | Stock | 133.81 | 133.81 | 133.56 | 133.6 | 1039.0 |
| 2020-12-31 04:05:00 | AAPL | Stock | 133.57 | 133.57 | 133.57 | 133.57 | 100.0 |
| 2020-12-31 04:10:00 | AAPL | Stock | 133.54 | 133.54 | 133.54 | 133.54 | 323.0 |
| 2020-12-31 04:15:00 | AAPL | Stock | 133.4 | 133.45 | 133.39 | 133.39 | 1729.0 |
| 2020-12-31 04:20:00 | AAPL | Stock | 133.42 | 133.42 | 133.42 | 133.42 | 100.0 |
| 2020-12-31 04:25:00 | AAPL | Stock | 133.43 | 133.43 | 133.38 | 133.38 | 381.0 |
| 2020-12-31 04:30:00 | AAPL | Stock | 133.38 | 133.4 | 133.38 | 133.4 | 386.0 |
| 2020-12-31 04:35:00 | AAPL | Stock | 133.43 | 133.43 | 133.43 | 133.43 | 246.0 |
| 2020-12-31 05:00:00 | AAPL | Stock | 133.61 | 133.61 | 133.61 | 133.61 | 100.0 |
| 2020-12-31 05:05:00 | AAPL | Stock | 133.61 | 133.61 | 133.61 | 133.61 | 146.0 |
| 2020-12-31 05:15:00 | AAPL | Stock | 133.68 | 133.72 | 133.68 | 133.72 | 855.0 |
| 2020-12-31 05:20:00 | AAPL | Stock | 133.7 | 133.7 | 133.68 | 133.68 | 477.0 |
| 2020-12-31 05:25:00 | AAPL | Stock | 133.53 | 133.53 | 133.53 | 133.53 | 153.0 |
| 2020-12-31 05:30:00 | AAPL | Stock | 133.53 | 133.53 | 133.53 | 133.53 | 110.0 |
| 2020-12-31 05:35:00 | AAPL | Stock | 133.57 | 133.57 | 133.53 | 133.53 | 220.0 |
| 2020-12-31 05:40:00 | AAPL | Stock | 133.56 | 133.56 | 133.56 | 133.56 | 282.0 |
| 2020-12-31 05:50:00 | AAPL | Stock | 133.57 | 133.72 | 133.57 | 133.72 | 619.0 |
| 2020-12-31 05:55:00 | AAPL | Stock | 133.72 | 133.72 | 133.72 | 133.72 | 100.0 |
| 2020-12-31 06:10:00 | AAPL | Stock | 133.71 | 133.71 | 133.71 | 133.71 | 105.0 |
| 2020-12-31 06:25:00 | AAPL | Stock | 133.72 | 133.8 | 133.72 | 133.8 | 1958.0 |
| 2020-12-31 06:30:00 | AAPL | Stock | 133.81 | 133.9 | 133.81 | 133.9 | 345.0 |
| 2020-12-31 06:35:00 | AAPL | Stock | 133.89 | 133.89 | 133.88 | 133.88 | 244.0 |
| 2020-12-31 06:45:00 | AAPL | Stock | 133.8 | 133.82 | 133.8 | 133.82 | 620.0 |
| 2020-12-31 06:50:00 | AAPL | Stock | 133.89 | 133.92 | 133.89 | 133.92 | 797.0 |
| 2020-12-31 06:55:00 | AAPL | Stock | 133.91 | 133.99 | 133.91 | 133.97 | 947.0 |
| 2020-12-31 07:00:00 | AAPL | Stock | 133.82 | 134.32 | 133.82 | 134.12 | 44438.0 |
| 2020-12-31 07:05:00 | AAPL | Stock | 134.07 | 134.28 | 134.07 | 134.28 | 15890.0 |
| 2020-12-31 07:10:00 | AAPL | Stock | 134.25 | 134.49 | 134.24 | 134.45 | 44951.0 |
| 2020-12-31 07:15:00 | AAPL | Stock | 134.42 | 134.46 | 134.41 | 134.43 | 5608.0 |
| 2020-12-31 07:20:00 | AAPL | Stock | 134.44 | 134.65 | 134.44 | 134.63 | 37651.0 |
| 2020-12-31 07:25:00 | AAPL | Stock | 134.64 | 134.65 | 134.34 | 134.38 | 30354.0 |
| 2020-12-31 07:30:00 | AAPL | Stock | 134.401 | 134.401 | 134.25 | 134.35 | 16438.0 |
| 2020-12-31 07:35:00 | AAPL | Stock | 134.33 | 134.33 | 134.25 | 134.3 | 8863.0 |
| 2020-12-31 07:40:00 | AAPL | Stock | 134.3 | 134.4 | 134.3 | 134.33 | 7454.0 |
| 2020-12-31 07:45:00 | AAPL | Stock | 134.35 | 134.58 | 134.35 | 134.57 | 11795.0 |
| 2020-12-31 07:50:00 | AAPL | Stock | 134.58 | 134.58 | 134.4 | 134.4 | 28517.0 |
| 2020-12-31 07:55:00 | AAPL | Stock | 134.39 | 134.4 | 134.31 | 134.38 | 12827.0 |
| 2020-12-31 08:00:00 | AAPL | Stock | 134.298 | 134.65 | 133.9 | 134.54 | 284567.0 |
| 2020-12-31 08:05:00 | AAPL | Stock | 134.53 | 134.55 | 134.41 | 134.44 | 22988.0 |
| 2020-12-31 08:10:00 | AAPL | Stock | 134.41 | 134.5 | 134.39 | 134.4 | 18103.0 |
| 2020-12-31 08:15:00 | AAPL | Stock | 134.4 | 134.44 | 134.36 | 134.4 | 15321.0 |
| 2020-12-31 08:20:00 | AAPL | Stock | 134.38 | 134.4 | 134.26 | 134.38 | 27721.0 |
| 2020-12-31 08:25:00 | AAPL | Stock | 134.35 | 134.39 | 134.33 | 134.35 | 9209.0 |
| 2020-12-31 08:30:00 | AAPL | Stock | 134.32 | 134.45 | 134.31 | 134.43 | 28951.0 |
| 2020-12-31 08:35:00 | AAPL | Stock | 134.43 | 134.43 | 134.35 | 134.35 | 16507.0 |
| 2020-12-31 08:40:00 | AAPL | Stock | 134.36 | 134.43 | 134.31 | 134.43 | 19397.0 |
| 2020-12-31 08:45:00 | AAPL | Stock | 134.43 | 134.45 | 134.34 | 134.4 | 16999.0 |
| 2020-12-31 08:50:00 | AAPL | Stock | 134.41 | 134.41 | 134.3 | 134.36 | 25158.0 |
| 2020-12-31 08:55:00 | AAPL | Stock | 134.38 | 134.44 | 134.33 | 134.35 | 15877.0 |
| 2020-12-31 09:00:00 | AAPL | Stock | 134.35 | 134.39 | 134.27 | 134.3 | 23305.0 |
> showing 50 of 453,121 rows — these rows as CSV