PREVIEW / stock_30min / 2022-03-23
file: by_date/stock_30min/2022/2022-03-23.parquet size: 2.2 MB rows: 109,394 symbols: 2,474
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 |
|---|---|---|---|---|---|---|---|
| 2022-03-23 04:00:00 | AAPL | Stock | 168.7 | 168.9 | 168.5 | 168.52 | 10452.0 |
| 2022-03-23 04:30:00 | AAPL | Stock | 168.59 | 168.74 | 168.58 | 168.68 | 6682.0 |
| 2022-03-23 05:00:00 | AAPL | Stock | 168.71 | 168.72 | 168.53 | 168.55 | 3368.0 |
| 2022-03-23 05:30:00 | AAPL | Stock | 168.53 | 168.55 | 168.21 | 168.21 | 8357.0 |
| 2022-03-23 06:00:00 | AAPL | Stock | 168.21 | 168.3 | 168.0 | 168.0 | 9960.0 |
| 2022-03-23 06:30:00 | AAPL | Stock | 168.0 | 168.13 | 167.87 | 167.93 | 8199.0 |
| 2022-03-23 07:00:00 | AAPL | Stock | 168.0 | 168.2 | 167.91 | 167.96 | 69824.0 |
| 2022-03-23 07:30:00 | AAPL | Stock | 167.99 | 168.1 | 167.77 | 167.95 | 34146.0 |
| 2022-03-23 08:00:00 | AAPL | Stock | 168.07 | 169.37 | 167.8 | 167.99 | 310902.0 |
| 2022-03-23 08:30:00 | AAPL | Stock | 168.05 | 168.07 | 167.601 | 167.77 | 155919.0 |
| 2022-03-23 09:00:00 | AAPL | Stock | 167.78 | 168.3 | 167.7503 | 168.03 | 244160.0 |
| 2022-03-23 09:30:00 | AAPL | Stock | 167.96 | 169.81 | 167.65 | 169.55 | 10833521.0 |
| 2022-03-23 10:00:00 | AAPL | Stock | 169.519 | 170.76 | 169.2 | 170.26 | 8836273.0 |
| 2022-03-23 10:30:00 | AAPL | Stock | 170.25 | 170.49 | 169.76 | 170.402 | 4723656.0 |
| 2022-03-23 11:00:00 | AAPL | Stock | 170.41 | 171.61 | 170.3306 | 171.2561 | 6241427.0 |
| 2022-03-23 11:30:00 | AAPL | Stock | 171.25 | 171.865 | 171.13 | 171.775 | 4309841.0 |
| 2022-03-23 12:00:00 | AAPL | Stock | 171.78 | 172.22 | 171.17 | 171.86 | 5667970.0 |
| 2022-03-23 12:30:00 | AAPL | Stock | 171.86 | 171.885 | 171.31 | 171.72 | 3983669.0 |
| 2022-03-23 13:00:00 | AAPL | Stock | 171.7116 | 172.64 | 171.69 | 171.79 | 6915917.0 |
| 2022-03-23 13:30:00 | AAPL | Stock | 171.79 | 172.44 | 171.71 | 172.325 | 4133015.0 |
| 2022-03-23 14:00:00 | AAPL | Stock | 172.33 | 172.4325 | 171.53 | 171.96 | 4390704.0 |
| 2022-03-23 14:30:00 | AAPL | Stock | 171.945 | 172.19 | 171.4139 | 171.725 | 3755069.0 |
| 2022-03-23 15:00:00 | AAPL | Stock | 171.73 | 171.97 | 170.95 | 171.25 | 4410178.0 |
| 2022-03-23 15:30:00 | AAPL | Stock | 171.24 | 171.47 | 170.1 | 170.22 | 8348205.0 |
| 2022-03-23 16:00:00 | AAPL | Stock | 170.25 | 170.46 | 170.05 | 170.29 | 8363571.0 |
| 2022-03-23 16:30:00 | AAPL | Stock | 170.28 | 170.47 | 170.17 | 170.33 | 521045.0 |
| 2022-03-23 17:00:00 | AAPL | Stock | 170.34 | 170.36 | 170.1 | 170.1 | 63823.0 |
| 2022-03-23 17:30:00 | AAPL | Stock | 170.1 | 170.18 | 170.02 | 170.15 | 20695.0 |
| 2022-03-23 18:00:00 | AAPL | Stock | 170.18 | 170.35 | 170.12 | 170.2 | 17803.0 |
| 2022-03-23 18:30:00 | AAPL | Stock | 170.24 | 170.36 | 170.21 | 170.24 | 16376.0 |
| 2022-03-23 19:00:00 | AAPL | Stock | 170.35 | 170.6 | 170.32 | 170.52 | 19773.0 |
| 2022-03-23 19:30:00 | AAPL | Stock | 170.55 | 170.69 | 170.47 | 170.69 | 33648.0 |
| 2022-03-23 04:00:00 | MSFT | Stock | 303.63 | 303.63 | 302.86 | 303.0 | 2379.0 |
| 2022-03-23 04:30:00 | MSFT | Stock | 303.3 | 303.49 | 303.2 | 303.49 | 310.0 |
| 2022-03-23 05:00:00 | MSFT | Stock | 303.49 | 303.49 | 303.46 | 303.49 | 961.0 |
| 2022-03-23 05:30:00 | MSFT | Stock | 303.32 | 303.32 | 302.52 | 302.52 | 693.0 |
| 2022-03-23 06:00:00 | MSFT | Stock | 302.77 | 302.77 | 302.77 | 302.77 | 623.0 |
| 2022-03-23 06:30:00 | MSFT | Stock | 302.05 | 302.33 | 302.05 | 302.28 | 904.0 |
| 2022-03-23 07:00:00 | MSFT | Stock | 302.33 | 302.85 | 302.11 | 302.2 | 5075.0 |
| 2022-03-23 07:30:00 | MSFT | Stock | 302.15 | 302.3 | 300.96 | 301.28 | 15962.0 |
| 2022-03-23 08:00:00 | MSFT | Stock | 302.1675 | 305.76 | 301.21 | 301.7 | 36930.0 |
| 2022-03-23 08:30:00 | MSFT | Stock | 301.71 | 301.73 | 301.43 | 301.49 | 9025.0 |
| 2022-03-23 09:00:00 | MSFT | Stock | 301.54 | 301.95 | 300.2 | 300.68 | 61454.0 |
| 2022-03-23 09:30:00 | MSFT | Stock | 300.68 | 300.79 | 297.7201 | 299.745 | 3233222.0 |
| 2022-03-23 10:00:00 | MSFT | Stock | 299.715 | 302.58 | 299.24 | 301.77 | 1517759.0 |
| 2022-03-23 10:30:00 | MSFT | Stock | 301.87 | 302.0944 | 300.45 | 301.07 | 1024095.0 |
| 2022-03-23 11:00:00 | MSFT | Stock | 301.11 | 302.1 | 300.89 | 301.7343 | 863932.0 |
| 2022-03-23 11:30:00 | MSFT | Stock | 301.75 | 302.26 | 301.22 | 302.22 | 724720.0 |
| 2022-03-23 12:00:00 | MSFT | Stock | 302.21 | 303.23 | 301.36 | 302.955 | 999315.0 |
| 2022-03-23 12:30:00 | MSFT | Stock | 302.94 | 303.17 | 301.72 | 302.18 | 662552.0 |
> showing 50 of 109,394 rows — these rows as CSV