PREVIEW / stock_30min / 2022-09-02
file: by_date/stock_30min/2022/2022-09-02.parquet size: 2.1 MB rows: 102,439 symbols: 2,211
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-09-02 04:00:00 | AAPL | Stock | 157.86 | 158.35 | 157.55 | 158.19 | 13890.0 |
| 2022-09-02 04:30:00 | AAPL | Stock | 158.28 | 158.55 | 158.23 | 158.48 | 6624.0 |
| 2022-09-02 05:00:00 | AAPL | Stock | 158.26 | 158.28 | 158.08 | 158.1 | 5898.0 |
| 2022-09-02 05:30:00 | AAPL | Stock | 158.07 | 158.13 | 158.01 | 158.1 | 5077.0 |
| 2022-09-02 06:00:00 | AAPL | Stock | 158.17 | 158.19 | 157.85 | 157.85 | 14572.0 |
| 2022-09-02 06:30:00 | AAPL | Stock | 157.76 | 157.86 | 157.69 | 157.86 | 4686.0 |
| 2022-09-02 07:00:00 | AAPL | Stock | 157.96 | 158.05 | 157.89 | 158.0 | 17430.0 |
| 2022-09-02 07:30:00 | AAPL | Stock | 158.03 | 158.26 | 157.98 | 158.18 | 27857.0 |
| 2022-09-02 08:00:00 | AAPL | Stock | 158.0 | 158.39 | 157.566 | 158.05 | 143107.0 |
| 2022-09-02 08:30:00 | AAPL | Stock | 158.36 | 159.74 | 158.0 | 159.35 | 560663.0 |
| 2022-09-02 09:00:00 | AAPL | Stock | 159.25 | 160.17 | 159.15 | 159.73 | 325184.0 |
| 2022-09-02 09:30:00 | AAPL | Stock | 159.75 | 160.01 | 159.13 | 159.32 | 8228089.0 |
| 2022-09-02 10:00:00 | AAPL | Stock | 159.32 | 160.17 | 158.66 | 160.1 | 5596945.0 |
| 2022-09-02 10:30:00 | AAPL | Stock | 160.1 | 160.362 | 158.98 | 159.45 | 4728512.0 |
| 2022-09-02 11:00:00 | AAPL | Stock | 159.45 | 159.99 | 159.32 | 159.93 | 3586171.0 |
| 2022-09-02 11:30:00 | AAPL | Stock | 159.9202 | 160.12 | 159.42 | 159.775 | 2748992.0 |
| 2022-09-02 12:00:00 | AAPL | Stock | 159.78 | 159.9 | 158.54 | 158.64 | 2963320.0 |
| 2022-09-02 12:30:00 | AAPL | Stock | 158.63 | 158.84 | 157.2 | 157.73 | 4176825.0 |
| 2022-09-02 13:00:00 | AAPL | Stock | 157.7233 | 157.7233 | 156.27 | 156.4 | 4366072.0 |
| 2022-09-02 13:30:00 | AAPL | Stock | 156.39 | 156.785 | 155.6501 | 155.68 | 3892837.0 |
| 2022-09-02 14:00:00 | AAPL | Stock | 155.69 | 156.55 | 155.65 | 156.46 | 3248369.0 |
| 2022-09-02 14:30:00 | AAPL | Stock | 156.485 | 156.565 | 155.87 | 155.96 | 2613548.0 |
| 2022-09-02 15:00:00 | AAPL | Stock | 155.9595 | 156.51 | 155.5 | 155.89 | 4418425.0 |
| 2022-09-02 15:30:00 | AAPL | Stock | 155.88 | 156.0 | 154.965 | 155.85 | 7985416.0 |
| 2022-09-02 16:00:00 | AAPL | Stock | 155.86 | 156.18 | 155.66 | 155.98 | 7607572.0 |
| 2022-09-02 16:30:00 | AAPL | Stock | 155.99 | 156.19 | 155.81 | 156.12 | 84116.0 |
| 2022-09-02 17:00:00 | AAPL | Stock | 156.11 | 156.15 | 156.02 | 156.13 | 19152.0 |
| 2022-09-02 17:30:00 | AAPL | Stock | 156.11 | 156.11 | 155.65 | 155.8 | 54570.0 |
| 2022-09-02 18:00:00 | AAPL | Stock | 155.85 | 155.89 | 155.71 | 155.88 | 7133.0 |
| 2022-09-02 18:30:00 | AAPL | Stock | 155.87 | 155.87 | 155.71 | 155.75 | 5105.0 |
| 2022-09-02 19:00:00 | AAPL | Stock | 155.76 | 155.78 | 155.72 | 155.78 | 5001.0 |
| 2022-09-02 19:30:00 | AAPL | Stock | 155.77 | 155.79 | 155.61 | 155.65 | 22305.0 |
| 2022-09-02 04:00:00 | MSFT | Stock | 260.11 | 260.28 | 260.11 | 260.28 | 1630.0 |
| 2022-09-02 04:30:00 | MSFT | Stock | 260.44 | 260.57 | 260.25 | 260.32 | 704.0 |
| 2022-09-02 05:30:00 | MSFT | Stock | 260.2 | 260.2 | 259.9 | 259.9 | 403.0 |
| 2022-09-02 06:00:00 | MSFT | Stock | 259.95 | 259.95 | 259.95 | 259.95 | 100.0 |
| 2022-09-02 07:00:00 | MSFT | Stock | 259.3 | 259.32 | 258.94 | 259.03 | 4749.0 |
| 2022-09-02 07:30:00 | MSFT | Stock | 259.2 | 259.68 | 259.2 | 259.5 | 3170.0 |
| 2022-09-02 08:00:00 | MSFT | Stock | 259.4978 | 259.851 | 259.0 | 259.8 | 26855.0 |
| 2022-09-02 08:30:00 | MSFT | Stock | 259.98 | 262.5 | 259.1 | 261.22 | 119954.0 |
| 2022-09-02 09:00:00 | MSFT | Stock | 261.01 | 262.33 | 260.75 | 261.35 | 37566.0 |
| 2022-09-02 09:30:00 | MSFT | Stock | 261.69 | 262.9 | 260.27 | 261.66 | 1852077.0 |
| 2022-09-02 10:00:00 | MSFT | Stock | 261.76 | 263.41 | 260.8 | 263.39 | 959975.0 |
| 2022-09-02 10:30:00 | MSFT | Stock | 263.41 | 264.74 | 262.6 | 263.2867 | 1176691.0 |
| 2022-09-02 11:00:00 | MSFT | Stock | 263.28 | 263.82 | 263.1 | 263.68 | 574639.0 |
| 2022-09-02 11:30:00 | MSFT | Stock | 263.7 | 264.05 | 263.03 | 263.39 | 536849.0 |
| 2022-09-02 12:00:00 | MSFT | Stock | 263.4 | 263.46 | 260.87 | 261.21 | 824317.0 |
| 2022-09-02 12:30:00 | MSFT | Stock | 261.1529 | 261.5 | 258.72 | 259.47 | 1063243.0 |
| 2022-09-02 13:00:00 | MSFT | Stock | 259.42 | 259.44 | 257.4284 | 257.65 | 867564.0 |
| 2022-09-02 13:30:00 | MSFT | Stock | 257.65 | 257.98 | 255.87 | 255.88 | 825355.0 |
> showing 50 of 102,439 rows — these rows as CSV