PREVIEW / stock_30min / 2022-04-06
file: by_date/stock_30min/2022/2022-04-06.parquet size: 2.2 MB rows: 109,896 symbols: 2,495
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-04-06 04:00:00 | AAPL | Stock | 175.0 | 175.0 | 173.43 | 173.63 | 19236.0 |
| 2022-04-06 04:30:00 | AAPL | Stock | 173.72 | 174.1 | 173.66 | 173.93 | 11691.0 |
| 2022-04-06 05:00:00 | AAPL | Stock | 173.99 | 173.99 | 173.74 | 173.81 | 14319.0 |
| 2022-04-06 05:30:00 | AAPL | Stock | 173.81 | 173.81 | 173.45 | 173.75 | 20644.0 |
| 2022-04-06 06:00:00 | AAPL | Stock | 173.65 | 173.65 | 173.24 | 173.25 | 7710.0 |
| 2022-04-06 06:30:00 | AAPL | Stock | 173.34 | 173.34 | 173.11 | 173.17 | 10157.0 |
| 2022-04-06 07:00:00 | AAPL | Stock | 173.16 | 173.28 | 172.51 | 172.7 | 82822.0 |
| 2022-04-06 07:30:00 | AAPL | Stock | 172.69 | 172.69 | 172.29 | 172.38 | 76104.0 |
| 2022-04-06 08:00:00 | AAPL | Stock | 172.57 | 174.19 | 172.0 | 172.61 | 522965.0 |
| 2022-04-06 08:30:00 | AAPL | Stock | 172.61 | 172.67 | 172.2 | 172.51 | 179604.0 |
| 2022-04-06 09:00:00 | AAPL | Stock | 172.51 | 172.6 | 172.02 | 172.42 | 350293.0 |
| 2022-04-06 09:30:00 | AAPL | Stock | 172.42 | 173.24 | 171.21 | 171.605 | 11127881.0 |
| 2022-04-06 10:00:00 | AAPL | Stock | 171.63 | 171.67 | 171.02 | 171.13 | 6249826.0 |
| 2022-04-06 10:30:00 | AAPL | Stock | 171.13 | 171.58 | 170.82 | 170.89 | 5010481.0 |
| 2022-04-06 11:00:00 | AAPL | Stock | 170.875 | 170.98 | 170.13 | 170.835 | 4757203.0 |
| 2022-04-06 11:30:00 | AAPL | Stock | 170.84 | 171.74 | 170.49 | 171.62 | 4084370.0 |
| 2022-04-06 12:00:00 | AAPL | Stock | 171.62 | 171.71 | 170.835 | 170.975 | 2801020.0 |
| 2022-04-06 12:30:00 | AAPL | Stock | 170.97 | 171.47 | 170.8715 | 171.35 | 2446500.0 |
| 2022-04-06 13:00:00 | AAPL | Stock | 171.34 | 171.71 | 171.03 | 171.71 | 2356130.0 |
| 2022-04-06 13:30:00 | AAPL | Stock | 171.72 | 172.39 | 171.57 | 171.92 | 3198343.0 |
| 2022-04-06 14:00:00 | AAPL | Stock | 171.94 | 173.41 | 170.93 | 171.38 | 6436365.0 |
| 2022-04-06 14:30:00 | AAPL | Stock | 171.37 | 173.23 | 171.34 | 173.1 | 5125099.0 |
| 2022-04-06 15:00:00 | AAPL | Stock | 173.1113 | 173.63 | 171.62 | 171.67 | 4573763.0 |
| 2022-04-06 15:30:00 | AAPL | Stock | 171.675 | 172.91 | 171.51 | 171.57 | 8710444.0 |
| 2022-04-06 16:00:00 | AAPL | Stock | 171.59 | 171.89 | 171.3 | 171.43 | 8796113.0 |
| 2022-04-06 16:30:00 | AAPL | Stock | 171.4 | 171.83 | 171.2 | 171.31 | 118149.0 |
| 2022-04-06 17:00:00 | AAPL | Stock | 171.29 | 171.35 | 171.29 | 171.35 | 9508.0 |
| 2022-04-06 17:30:00 | AAPL | Stock | 171.36 | 171.42 | 171.28 | 171.32 | 5124.0 |
| 2022-04-06 18:00:00 | AAPL | Stock | 171.41 | 171.75 | 171.35 | 171.6 | 20620.0 |
| 2022-04-06 18:30:00 | AAPL | Stock | 171.65 | 171.76 | 171.6 | 171.7 | 9634.0 |
| 2022-04-06 19:00:00 | AAPL | Stock | 171.74 | 171.74 | 171.59 | 171.59 | 16760.0 |
| 2022-04-06 19:30:00 | AAPL | Stock | 171.54 | 171.54 | 170.85 | 170.9 | 53262.0 |
| 2022-04-06 04:00:00 | MSFT | Stock | 308.53 | 309.0 | 307.72 | 307.76 | 3475.0 |
| 2022-04-06 04:30:00 | MSFT | Stock | 308.2 | 308.62 | 307.8 | 308.31 | 1171.0 |
| 2022-04-06 05:00:00 | MSFT | Stock | 308.45 | 308.5 | 308.0 | 308.06 | 1299.0 |
| 2022-04-06 05:30:00 | MSFT | Stock | 307.53 | 307.8 | 306.95 | 307.49 | 2629.0 |
| 2022-04-06 06:00:00 | MSFT | Stock | 307.35 | 307.46 | 306.25 | 306.87 | 5976.0 |
| 2022-04-06 06:30:00 | MSFT | Stock | 306.25 | 306.36 | 306.12 | 306.24 | 1436.0 |
| 2022-04-06 07:00:00 | MSFT | Stock | 306.42 | 306.49 | 305.11 | 305.11 | 8217.0 |
| 2022-04-06 07:30:00 | MSFT | Stock | 305.11 | 305.4 | 304.51 | 304.53 | 13974.0 |
| 2022-04-06 08:00:00 | MSFT | Stock | 306.35 | 310.103 | 304.3449 | 305.2499 | 43029.0 |
| 2022-04-06 08:30:00 | MSFT | Stock | 305.13 | 305.14 | 304.66 | 304.9 | 23168.0 |
| 2022-04-06 09:00:00 | MSFT | Stock | 304.9 | 305.2 | 304.29 | 305.19 | 28392.0 |
| 2022-04-06 09:30:00 | MSFT | Stock | 305.19 | 307.0 | 302.275 | 302.99 | 3358855.0 |
| 2022-04-06 10:00:00 | MSFT | Stock | 303.03 | 303.2499 | 301.48 | 301.513 | 2306777.0 |
| 2022-04-06 10:30:00 | MSFT | Stock | 301.55 | 302.61 | 301.2 | 301.66 | 1595344.0 |
| 2022-04-06 11:00:00 | MSFT | Stock | 301.61 | 301.89 | 299.9 | 300.57 | 1727595.0 |
| 2022-04-06 11:30:00 | MSFT | Stock | 300.6 | 301.14 | 299.5 | 299.5767 | 1483129.0 |
| 2022-04-06 12:00:00 | MSFT | Stock | 299.58 | 300.06 | 298.01 | 298.15 | 1230125.0 |
| 2022-04-06 12:30:00 | MSFT | Stock | 298.14 | 298.62 | 297.8 | 297.95 | 1088281.0 |
> showing 50 of 109,896 rows — these rows as CSV