PREVIEW / stock_30min / 2023-02-28
file: by_date/stock_30min/2023/2023-02-28.parquet size: 2.1 MB rows: 101,707 symbols: 1,798
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 |
|---|---|---|---|---|---|---|---|
| 2023-02-28 04:00:00 | AAPL | Stock | 147.04 | 147.43 | 147.04 | 147.23 | 14016.0 |
| 2023-02-28 04:30:00 | AAPL | Stock | 147.16 | 147.2 | 147.06 | 147.2 | 6137.0 |
| 2023-02-28 05:00:00 | AAPL | Stock | 147.2 | 147.4 | 147.18 | 147.39 | 8015.0 |
| 2023-02-28 05:30:00 | AAPL | Stock | 147.39 | 147.69 | 147.39 | 147.61 | 5690.0 |
| 2023-02-28 06:00:00 | AAPL | Stock | 147.63 | 147.67 | 147.46 | 147.57 | 7175.0 |
| 2023-02-28 06:30:00 | AAPL | Stock | 147.58 | 147.85 | 147.55 | 147.83 | 3340.0 |
| 2023-02-28 07:00:00 | AAPL | Stock | 147.83 | 148.23 | 147.75 | 148.18 | 18144.0 |
| 2023-02-28 07:30:00 | AAPL | Stock | 148.13 | 148.13 | 147.95 | 148.11 | 16495.0 |
| 2023-02-28 08:00:00 | AAPL | Stock | 147.8901 | 148.26 | 147.28 | 147.7 | 75888.0 |
| 2023-02-28 08:30:00 | AAPL | Stock | 147.68 | 147.707 | 147.41 | 147.59 | 48773.0 |
| 2023-02-28 09:00:00 | AAPL | Stock | 147.64 | 147.64 | 146.75 | 147.05 | 122955.0 |
| 2023-02-28 09:30:00 | AAPL | Stock | 147.05 | 147.78 | 146.83 | 147.71 | 4408217.0 |
| 2023-02-28 10:00:00 | AAPL | Stock | 147.71 | 148.0 | 147.1 | 147.26 | 3425840.0 |
| 2023-02-28 10:30:00 | AAPL | Stock | 147.265 | 147.67 | 147.08 | 147.52 | 2275533.0 |
| 2023-02-28 11:00:00 | AAPL | Stock | 147.53 | 148.18 | 147.5136 | 147.92 | 1897663.0 |
| 2023-02-28 11:30:00 | AAPL | Stock | 147.91 | 148.09 | 147.62 | 147.95 | 1379159.0 |
| 2023-02-28 12:00:00 | AAPL | Stock | 147.96 | 148.41 | 147.96 | 148.316 | 1382209.0 |
| 2023-02-28 12:30:00 | AAPL | Stock | 148.32 | 148.8244 | 148.21 | 148.6686 | 1642948.0 |
| 2023-02-28 13:00:00 | AAPL | Stock | 148.67 | 148.97 | 148.62 | 148.96 | 1575089.0 |
| 2023-02-28 13:30:00 | AAPL | Stock | 148.9575 | 149.08 | 148.72 | 148.825 | 1582655.0 |
| 2023-02-28 14:00:00 | AAPL | Stock | 148.83 | 148.985 | 148.53 | 148.62 | 1426739.0 |
| 2023-02-28 14:30:00 | AAPL | Stock | 148.62 | 148.76 | 148.26 | 148.318 | 1671961.0 |
| 2023-02-28 15:00:00 | AAPL | Stock | 148.315 | 148.38 | 148.01 | 148.07 | 1850221.0 |
| 2023-02-28 15:30:00 | AAPL | Stock | 148.08 | 148.12 | 147.37 | 147.4 | 5704598.0 |
| 2023-02-28 16:00:00 | AAPL | Stock | 147.39 | 147.65 | 147.0 | 147.15 | 12657679.0 |
| 2023-02-28 16:30:00 | AAPL | Stock | 147.2 | 147.41 | 147.06 | 147.13 | 54786.0 |
| 2023-02-28 17:00:00 | AAPL | Stock | 147.19 | 147.41 | 147.1 | 147.2 | 14079.0 |
| 2023-02-28 17:30:00 | AAPL | Stock | 147.14 | 147.27 | 147.1 | 147.17 | 13153.0 |
| 2023-02-28 18:00:00 | AAPL | Stock | 147.26 | 147.37 | 147.1 | 147.1 | 13504.0 |
| 2023-02-28 18:30:00 | AAPL | Stock | 147.12 | 147.14 | 147.03 | 147.13 | 11184.0 |
| 2023-02-28 19:00:00 | AAPL | Stock | 147.1 | 147.1 | 146.99 | 147.01 | 32106.0 |
| 2023-02-28 19:30:00 | AAPL | Stock | 147.05 | 147.08 | 146.85 | 146.93 | 22259.0 |
| 2023-02-28 04:00:00 | MSFT | Stock | 250.01 | 250.3 | 249.21 | 249.21 | 3430.0 |
| 2023-02-28 04:30:00 | MSFT | Stock | 249.27 | 249.27 | 249.14 | 249.16 | 600.0 |
| 2023-02-28 05:00:00 | MSFT | Stock | 249.17 | 249.83 | 249.17 | 249.62 | 674.0 |
| 2023-02-28 05:30:00 | MSFT | Stock | 249.68 | 249.74 | 249.66 | 249.66 | 800.0 |
| 2023-02-28 06:00:00 | MSFT | Stock | 249.7 | 250.01 | 249.7 | 249.95 | 1423.0 |
| 2023-02-28 06:30:00 | MSFT | Stock | 249.95 | 250.16 | 249.95 | 250.16 | 554.0 |
| 2023-02-28 07:00:00 | MSFT | Stock | 250.5 | 250.9 | 250.49 | 250.9 | 4549.0 |
| 2023-02-28 07:30:00 | MSFT | Stock | 250.91 | 250.91 | 250.59 | 250.8 | 3480.0 |
| 2023-02-28 08:00:00 | MSFT | Stock | 250.65 | 251.47 | 250.19 | 250.28 | 20539.0 |
| 2023-02-28 08:30:00 | MSFT | Stock | 250.25 | 250.25 | 249.75 | 250.0 | 8312.0 |
| 2023-02-28 09:00:00 | MSFT | Stock | 250.16 | 250.17 | 248.69 | 248.95 | 15423.0 |
| 2023-02-28 09:30:00 | MSFT | Stock | 248.95 | 250.26 | 248.73 | 249.8 | 1399233.0 |
| 2023-02-28 10:00:00 | MSFT | Stock | 249.84 | 250.41 | 249.36 | 249.53 | 835722.0 |
| 2023-02-28 10:30:00 | MSFT | Stock | 249.54 | 250.0 | 249.1 | 249.815 | 808883.0 |
| 2023-02-28 11:00:00 | MSFT | Stock | 249.82 | 250.5 | 249.79 | 250.12 | 943536.0 |
| 2023-02-28 11:30:00 | MSFT | Stock | 250.1 | 250.12 | 249.13 | 249.6 | 639813.0 |
| 2023-02-28 12:00:00 | MSFT | Stock | 249.65 | 250.4 | 249.63 | 250.2553 | 503377.0 |
| 2023-02-28 12:30:00 | MSFT | Stock | 250.28 | 251.19 | 250.05 | 250.88 | 617028.0 |
> showing 50 of 101,707 rows — these rows as CSV