PREVIEW / stock_30min / 2020-12-10
file: by_date/stock_30min/2020/2020-12-10.parquet size: 2.1 MB rows: 108,532 symbols: 2,665
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-10 04:00:00 | AAPL | Stock | 121.26 | 122.0 | 121.26 | 122.0 | 27392.0 |
| 2020-12-10 04:30:00 | AAPL | Stock | 121.91 | 121.92 | 121.69 | 121.74 | 9379.0 |
| 2020-12-10 05:00:00 | AAPL | Stock | 121.84 | 121.93 | 121.73 | 121.89 | 6741.0 |
| 2020-12-10 05:30:00 | AAPL | Stock | 121.91 | 122.0 | 121.79 | 121.8 | 8479.0 |
| 2020-12-10 06:00:00 | AAPL | Stock | 121.75 | 121.88 | 121.61 | 121.88 | 2181.0 |
| 2020-12-10 06:30:00 | AAPL | Stock | 121.71 | 121.8 | 121.36 | 121.36 | 8065.0 |
| 2020-12-10 07:00:00 | AAPL | Stock | 121.5 | 121.67 | 120.86 | 120.92 | 86072.0 |
| 2020-12-10 07:30:00 | AAPL | Stock | 120.91 | 121.09 | 120.67 | 120.83 | 147085.0 |
| 2020-12-10 08:00:00 | AAPL | Stock | 121.05 | 121.68 | 120.68 | 121.089 | 328221.0 |
| 2020-12-10 08:30:00 | AAPL | Stock | 121.08 | 121.1 | 120.3 | 120.42 | 230782.0 |
| 2020-12-10 09:00:00 | AAPL | Stock | 120.4 | 120.7 | 120.01 | 120.48 | 390244.0 |
| 2020-12-10 09:30:00 | AAPL | Stock | 120.49 | 122.48 | 120.15 | 122.445 | 11968263.0 |
| 2020-12-10 10:00:00 | AAPL | Stock | 122.44 | 123.18 | 121.995 | 122.985 | 6854840.0 |
| 2020-12-10 10:30:00 | AAPL | Stock | 122.99 | 123.57 | 122.735 | 123.5 | 5360894.0 |
| 2020-12-10 11:00:00 | AAPL | Stock | 123.49 | 123.83 | 123.15 | 123.77 | 4724760.0 |
| 2020-12-10 11:30:00 | AAPL | Stock | 123.77 | 123.87 | 123.12 | 123.3 | 3949886.0 |
| 2020-12-10 12:00:00 | AAPL | Stock | 123.29 | 123.58 | 122.86 | 123.28 | 3993797.0 |
| 2020-12-10 12:30:00 | AAPL | Stock | 123.271 | 123.425 | 122.71 | 122.79 | 3015457.0 |
| 2020-12-10 13:00:00 | AAPL | Stock | 122.793 | 123.53 | 122.745 | 123.53 | 2795036.0 |
| 2020-12-10 13:30:00 | AAPL | Stock | 123.529 | 123.58 | 123.165 | 123.49 | 2708144.0 |
| 2020-12-10 14:00:00 | AAPL | Stock | 123.49 | 123.62 | 123.11 | 123.15 | 2896750.0 |
| 2020-12-10 14:30:00 | AAPL | Stock | 123.15 | 123.47 | 122.76 | 122.84 | 3059581.0 |
| 2020-12-10 15:00:00 | AAPL | Stock | 122.84 | 123.21 | 122.71 | 123.165 | 3717483.0 |
| 2020-12-10 15:30:00 | AAPL | Stock | 123.16 | 123.6 | 123.15 | 123.22 | 7133131.0 |
| 2020-12-10 16:00:00 | AAPL | Stock | 123.24 | 123.45 | 122.96 | 123.18 | 8217575.0 |
| 2020-12-10 16:30:00 | AAPL | Stock | 123.09 | 123.25 | 123.08 | 123.25 | 22239.0 |
| 2020-12-10 17:00:00 | AAPL | Stock | 123.25 | 123.25 | 123.13 | 123.16 | 18820.0 |
| 2020-12-10 17:30:00 | AAPL | Stock | 123.15 | 123.32 | 123.15 | 123.3 | 24465.0 |
| 2020-12-10 18:00:00 | AAPL | Stock | 123.21 | 123.29 | 123.0 | 123.03 | 41175.0 |
| 2020-12-10 18:30:00 | AAPL | Stock | 123.1 | 123.26 | 122.89 | 123.19 | 63283.0 |
| 2020-12-10 19:00:00 | AAPL | Stock | 123.16 | 123.24 | 123.0 | 123.1 | 37044.0 |
| 2020-12-10 19:30:00 | AAPL | Stock | 123.07 | 123.29 | 123.04 | 123.17 | 44493.0 |
| 2020-12-10 04:00:00 | MSFT | Stock | 212.2 | 212.2 | 212.0 | 212.05 | 2766.0 |
| 2020-12-10 04:30:00 | MSFT | Stock | 212.08 | 212.5 | 212.08 | 212.31 | 8336.0 |
| 2020-12-10 05:00:00 | MSFT | Stock | 212.65 | 212.73 | 212.65 | 212.7 | 6980.0 |
| 2020-12-10 05:30:00 | MSFT | Stock | 212.78 | 212.9 | 212.72 | 212.9 | 4217.0 |
| 2020-12-10 06:00:00 | MSFT | Stock | 212.73 | 212.73 | 212.4 | 212.4 | 929.0 |
| 2020-12-10 06:30:00 | MSFT | Stock | 212.31 | 212.59 | 212.21 | 212.21 | 1392.0 |
| 2020-12-10 07:00:00 | MSFT | Stock | 212.35 | 212.35 | 211.3 | 211.3 | 10322.0 |
| 2020-12-10 07:30:00 | MSFT | Stock | 211.34 | 211.44 | 210.88 | 211.11 | 35296.0 |
| 2020-12-10 08:00:00 | MSFT | Stock | 212.2 | 212.49 | 210.8 | 211.22 | 36729.0 |
| 2020-12-10 08:30:00 | MSFT | Stock | 211.2 | 211.43 | 210.72 | 210.87 | 81680.0 |
| 2020-12-10 09:00:00 | MSFT | Stock | 210.73 | 212.04 | 210.73 | 211.85 | 124136.0 |
| 2020-12-10 09:30:00 | MSFT | Stock | 211.83 | 213.08 | 210.36 | 212.55 | 2959401.0 |
| 2020-12-10 10:00:00 | MSFT | Stock | 212.55 | 213.04 | 212.13 | 212.27 | 1403599.0 |
| 2020-12-10 10:30:00 | MSFT | Stock | 212.29 | 213.0 | 211.95 | 212.6 | 1019102.0 |
| 2020-12-10 11:00:00 | MSFT | Stock | 212.62 | 212.66 | 211.906 | 211.97 | 1176880.0 |
| 2020-12-10 11:30:00 | MSFT | Stock | 211.97 | 212.03 | 211.08 | 211.2 | 1194654.0 |
| 2020-12-10 12:00:00 | MSFT | Stock | 211.19 | 211.395 | 211.0 | 211.23 | 867500.0 |
| 2020-12-10 12:30:00 | MSFT | Stock | 211.24 | 211.5 | 210.73 | 210.93 | 895968.0 |
> showing 50 of 108,532 rows — these rows as CSV