PREVIEW / stock_5min / 2021-12-17
file: by_date/stock_5min/2021/2021-12-17.parquet size: 7.6 MB rows: 471,844 symbols: 2,646
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-17 04:00:00 | AAPL | Stock | 171.66 | 171.66 | 171.02 | 171.21 | 16080.0 |
| 2021-12-17 04:05:00 | AAPL | Stock | 171.16 | 171.16 | 170.84 | 171.14 | 4685.0 |
| 2021-12-17 04:10:00 | AAPL | Stock | 171.13 | 171.13 | 170.3 | 170.3 | 10904.0 |
| 2021-12-17 04:15:00 | AAPL | Stock | 170.21 | 170.43 | 170.03 | 170.43 | 6032.0 |
| 2021-12-17 04:20:00 | AAPL | Stock | 170.78 | 170.93 | 170.77 | 170.93 | 7391.0 |
| 2021-12-17 04:25:00 | AAPL | Stock | 170.92 | 170.92 | 170.92 | 170.92 | 150.0 |
| 2021-12-17 04:30:00 | AAPL | Stock | 170.9 | 170.98 | 170.8 | 170.82 | 946.0 |
| 2021-12-17 04:35:00 | AAPL | Stock | 170.89 | 170.89 | 170.84 | 170.84 | 266.0 |
| 2021-12-17 04:40:00 | AAPL | Stock | 170.67 | 170.74 | 170.35 | 170.35 | 3179.0 |
| 2021-12-17 04:45:00 | AAPL | Stock | 170.3 | 170.7 | 170.3 | 170.7 | 2738.0 |
| 2021-12-17 04:50:00 | AAPL | Stock | 170.76 | 171.0 | 170.76 | 170.95 | 6917.0 |
| 2021-12-17 04:55:00 | AAPL | Stock | 170.9 | 171.0 | 170.8 | 170.98 | 1978.0 |
| 2021-12-17 05:00:00 | AAPL | Stock | 170.96 | 170.97 | 170.86 | 170.86 | 1575.0 |
| 2021-12-17 05:05:00 | AAPL | Stock | 170.97 | 170.97 | 170.97 | 170.97 | 300.0 |
| 2021-12-17 05:10:00 | AAPL | Stock | 170.93 | 170.93 | 170.88 | 170.88 | 1270.0 |
| 2021-12-17 05:20:00 | AAPL | Stock | 170.88 | 170.94 | 170.65 | 170.65 | 6910.0 |
| 2021-12-17 05:25:00 | AAPL | Stock | 170.65 | 170.65 | 170.33 | 170.4 | 809.0 |
| 2021-12-17 05:30:00 | AAPL | Stock | 170.49 | 170.74 | 170.48 | 170.74 | 1182.0 |
| 2021-12-17 05:35:00 | AAPL | Stock | 170.6 | 170.6 | 170.6 | 170.6 | 371.0 |
| 2021-12-17 05:40:00 | AAPL | Stock | 170.5 | 170.5 | 170.37 | 170.37 | 2618.0 |
| 2021-12-17 05:45:00 | AAPL | Stock | 170.43 | 170.45 | 170.43 | 170.45 | 476.0 |
| 2021-12-17 05:50:00 | AAPL | Stock | 170.35 | 170.35 | 170.26 | 170.35 | 1113.0 |
| 2021-12-17 05:55:00 | AAPL | Stock | 170.35 | 170.42 | 170.2 | 170.25 | 14672.0 |
| 2021-12-17 06:00:00 | AAPL | Stock | 170.3 | 170.59 | 170.3 | 170.38 | 7570.0 |
| 2021-12-17 06:05:00 | AAPL | Stock | 170.47 | 170.7 | 170.39 | 170.54 | 3631.0 |
| 2021-12-17 06:10:00 | AAPL | Stock | 170.51 | 170.55 | 170.51 | 170.51 | 1053.0 |
| 2021-12-17 06:15:00 | AAPL | Stock | 170.6 | 170.64 | 170.6 | 170.64 | 771.0 |
| 2021-12-17 06:20:00 | AAPL | Stock | 170.7 | 170.96 | 170.7 | 170.91 | 1374.0 |
| 2021-12-17 06:25:00 | AAPL | Stock | 170.96 | 171.0 | 170.92 | 170.92 | 4179.0 |
| 2021-12-17 06:30:00 | AAPL | Stock | 170.95 | 170.99 | 170.86 | 170.86 | 1822.0 |
| 2021-12-17 06:35:00 | AAPL | Stock | 170.92 | 170.92 | 170.8 | 170.8 | 5566.0 |
| 2021-12-17 06:40:00 | AAPL | Stock | 170.87 | 170.87 | 170.87 | 170.87 | 118.0 |
| 2021-12-17 06:50:00 | AAPL | Stock | 170.95 | 171.0 | 170.94 | 170.96 | 2003.0 |
| 2021-12-17 06:55:00 | AAPL | Stock | 170.98 | 170.99 | 170.95 | 170.95 | 572.0 |
| 2021-12-17 07:00:00 | AAPL | Stock | 171.0 | 171.0 | 170.67 | 170.75 | 28916.0 |
| 2021-12-17 07:05:00 | AAPL | Stock | 170.74 | 170.85 | 170.7 | 170.82 | 9898.0 |
| 2021-12-17 07:10:00 | AAPL | Stock | 170.82 | 170.82 | 170.23 | 170.25 | 28058.0 |
| 2021-12-17 07:15:00 | AAPL | Stock | 170.27 | 170.3 | 170.16 | 170.25 | 16107.0 |
| 2021-12-17 07:20:00 | AAPL | Stock | 170.25 | 170.45 | 170.0 | 170.0 | 49807.0 |
| 2021-12-17 07:25:00 | AAPL | Stock | 170.0 | 170.09 | 169.67 | 169.67 | 62396.0 |
| 2021-12-17 07:30:00 | AAPL | Stock | 169.69 | 169.8 | 169.65 | 169.68 | 39002.0 |
| 2021-12-17 07:35:00 | AAPL | Stock | 169.68 | 169.8 | 169.58 | 169.58 | 12094.0 |
| 2021-12-17 07:40:00 | AAPL | Stock | 169.56 | 169.72 | 169.54 | 169.65 | 33347.0 |
| 2021-12-17 07:45:00 | AAPL | Stock | 169.66 | 169.76 | 169.5 | 169.5 | 38876.0 |
| 2021-12-17 07:50:00 | AAPL | Stock | 169.5 | 169.51 | 169.14 | 169.35 | 46804.0 |
| 2021-12-17 07:55:00 | AAPL | Stock | 169.34 | 169.44 | 169.3 | 169.4 | 28482.0 |
| 2021-12-17 08:00:00 | AAPL | Stock | 170.6906 | 171.0 | 169.13 | 169.5901 | 402305.0 |
| 2021-12-17 08:05:00 | AAPL | Stock | 169.59 | 169.65 | 169.45 | 169.45 | 57212.0 |
| 2021-12-17 08:10:00 | AAPL | Stock | 169.45 | 169.68 | 169.45 | 169.68 | 46989.0 |
| 2021-12-17 08:15:00 | AAPL | Stock | 169.67 | 169.72 | 169.46 | 169.5 | 36015.0 |
> showing 50 of 471,844 rows — these rows as CSV