PREVIEW / stock_30min / 2022-02-11
file: by_date/stock_30min/2022/2022-02-11.parquet size: 2.2 MB rows: 108,048 symbols: 2,547
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-02-11 04:00:00 | AAPL | Stock | 171.18 | 171.55 | 171.08 | 171.41 | 9561.0 |
| 2022-02-11 04:30:00 | AAPL | Stock | 171.33 | 171.33 | 170.76 | 170.96 | 11130.0 |
| 2022-02-11 05:00:00 | AAPL | Stock | 170.99 | 171.3 | 170.99 | 171.21 | 4521.0 |
| 2022-02-11 05:30:00 | AAPL | Stock | 171.25 | 171.4 | 171.11 | 171.4 | 4623.0 |
| 2022-02-11 06:00:00 | AAPL | Stock | 171.31 | 171.31 | 170.74 | 170.74 | 4436.0 |
| 2022-02-11 06:30:00 | AAPL | Stock | 170.92 | 171.28 | 170.9 | 171.06 | 4074.0 |
| 2022-02-11 07:00:00 | AAPL | Stock | 171.12 | 172.26 | 171.12 | 172.24 | 53988.0 |
| 2022-02-11 07:30:00 | AAPL | Stock | 172.23 | 172.26 | 171.79 | 171.98 | 58812.0 |
| 2022-02-11 08:00:00 | AAPL | Stock | 171.2801 | 172.55 | 171.19 | 172.28 | 308139.0 |
| 2022-02-11 08:30:00 | AAPL | Stock | 172.29 | 172.74 | 172.29 | 172.5 | 121528.0 |
| 2022-02-11 09:00:00 | AAPL | Stock | 172.47 | 172.64 | 172.01 | 172.35 | 185668.0 |
| 2022-02-11 09:30:00 | AAPL | Stock | 172.33 | 173.08 | 171.62 | 171.8287 | 7305511.0 |
| 2022-02-11 10:00:00 | AAPL | Stock | 171.82 | 172.65 | 171.03 | 171.72 | 6262954.0 |
| 2022-02-11 10:30:00 | AAPL | Stock | 171.73 | 172.695 | 171.58 | 172.0899 | 4406428.0 |
| 2022-02-11 11:00:00 | AAPL | Stock | 172.09 | 172.56 | 171.4 | 172.06 | 3407473.0 |
| 2022-02-11 11:30:00 | AAPL | Stock | 172.06 | 172.18 | 171.3 | 171.79 | 3079247.0 |
| 2022-02-11 12:00:00 | AAPL | Stock | 171.78 | 172.2 | 171.52 | 171.81 | 2988341.0 |
| 2022-02-11 12:30:00 | AAPL | Stock | 171.8 | 172.07 | 171.35 | 171.515 | 2278260.0 |
| 2022-02-11 13:00:00 | AAPL | Stock | 171.51 | 171.85 | 171.02 | 171.025 | 2589613.0 |
| 2022-02-11 13:30:00 | AAPL | Stock | 171.03 | 171.0495 | 168.89 | 169.15 | 7116703.0 |
| 2022-02-11 14:00:00 | AAPL | Stock | 169.14 | 170.0 | 168.5 | 168.98 | 6866751.0 |
| 2022-02-11 14:30:00 | AAPL | Stock | 168.98 | 169.85 | 168.29 | 168.82 | 4960940.0 |
| 2022-02-11 15:00:00 | AAPL | Stock | 168.84 | 169.5 | 168.38 | 168.835 | 5699255.0 |
| 2022-02-11 15:30:00 | AAPL | Stock | 168.835 | 169.7 | 168.04 | 168.43 | 10149881.0 |
| 2022-02-11 16:00:00 | AAPL | Stock | 168.45 | 168.86 | 168.32 | 168.85 | 8890357.0 |
| 2022-02-11 16:30:00 | AAPL | Stock | 168.89 | 169.3 | 168.6 | 168.6 | 265593.0 |
| 2022-02-11 17:00:00 | AAPL | Stock | 168.6 | 168.74 | 168.58 | 168.65 | 15354.0 |
| 2022-02-11 17:30:00 | AAPL | Stock | 168.65 | 168.78 | 168.65 | 168.7 | 15106.0 |
| 2022-02-11 18:00:00 | AAPL | Stock | 168.68 | 168.74 | 168.5 | 168.5099 | 20130.0 |
| 2022-02-11 18:30:00 | AAPL | Stock | 168.5 | 168.5 | 168.37 | 168.42 | 10121.0 |
| 2022-02-11 19:00:00 | AAPL | Stock | 168.36 | 168.47 | 168.23 | 168.41 | 30902.0 |
| 2022-02-11 19:30:00 | AAPL | Stock | 168.35 | 168.39 | 168.1 | 168.2 | 37632.0 |
| 2022-02-11 04:00:00 | MSFT | Stock | 300.0 | 300.94 | 300.0 | 300.89 | 3970.0 |
| 2022-02-11 04:30:00 | MSFT | Stock | 300.98 | 300.98 | 299.74 | 299.75 | 1868.0 |
| 2022-02-11 05:00:00 | MSFT | Stock | 299.74 | 300.35 | 299.74 | 300.34 | 2018.0 |
| 2022-02-11 05:30:00 | MSFT | Stock | 300.04 | 300.18 | 300.04 | 300.18 | 482.0 |
| 2022-02-11 06:00:00 | MSFT | Stock | 300.01 | 300.01 | 299.5 | 299.5 | 899.0 |
| 2022-02-11 06:30:00 | MSFT | Stock | 299.99 | 300.52 | 299.99 | 300.5 | 3711.0 |
| 2022-02-11 07:00:00 | MSFT | Stock | 300.6 | 302.69 | 300.58 | 302.67 | 40119.0 |
| 2022-02-11 07:30:00 | MSFT | Stock | 302.5 | 302.7 | 301.72 | 301.8 | 20582.0 |
| 2022-02-11 08:00:00 | MSFT | Stock | 300.3839 | 302.94 | 298.99 | 302.46 | 43855.0 |
| 2022-02-11 08:30:00 | MSFT | Stock | 302.56 | 303.75 | 302.38 | 303.28 | 298350.0 |
| 2022-02-11 09:00:00 | MSFT | Stock | 303.28 | 303.49 | 302.09 | 303.3 | 33576.0 |
| 2022-02-11 09:30:00 | MSFT | Stock | 303.3 | 304.29 | 300.98 | 301.4754 | 2585858.0 |
| 2022-02-11 10:00:00 | MSFT | Stock | 301.46 | 302.98 | 299.02 | 300.43 | 2397394.0 |
| 2022-02-11 10:30:00 | MSFT | Stock | 300.455 | 301.34 | 299.95 | 300.185 | 1264314.0 |
| 2022-02-11 11:00:00 | MSFT | Stock | 300.17 | 301.3241 | 299.21 | 299.82 | 1332559.0 |
| 2022-02-11 11:30:00 | MSFT | Stock | 299.76 | 300.91 | 299.24 | 300.4 | 1127621.0 |
| 2022-02-11 12:00:00 | MSFT | Stock | 300.39 | 301.28 | 300.03 | 300.57 | 795442.0 |
| 2022-02-11 12:30:00 | MSFT | Stock | 300.56 | 301.07 | 299.2548 | 299.455 | 929310.0 |
> showing 50 of 108,048 rows — these rows as CSV