PREVIEW / stock_30min / 2022-02-04
file: by_date/stock_30min/2022/2022-02-04.parquet size: 2.1 MB rows: 106,728 symbols: 2,523
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-04 04:00:00 | AAPL | Stock | 174.38 | 174.38 | 173.64 | 173.72 | 13813.0 |
| 2022-02-04 04:30:00 | AAPL | Stock | 173.71 | 173.83 | 173.55 | 173.55 | 13408.0 |
| 2022-02-04 05:00:00 | AAPL | Stock | 173.51 | 173.51 | 172.75 | 172.8 | 20156.0 |
| 2022-02-04 05:30:00 | AAPL | Stock | 172.79 | 173.05 | 172.48 | 172.51 | 27547.0 |
| 2022-02-04 06:00:00 | AAPL | Stock | 172.85 | 172.87 | 172.08 | 172.55 | 12138.0 |
| 2022-02-04 06:30:00 | AAPL | Stock | 172.5 | 172.64 | 171.49 | 171.65 | 23822.0 |
| 2022-02-04 07:00:00 | AAPL | Stock | 171.86 | 172.57 | 171.72 | 172.51 | 106456.0 |
| 2022-02-04 07:30:00 | AAPL | Stock | 172.52 | 173.18 | 172.23 | 173.11 | 114753.0 |
| 2022-02-04 08:00:00 | AAPL | Stock | 172.8601 | 173.18 | 172.0 | 172.4 | 355698.0 |
| 2022-02-04 08:30:00 | AAPL | Stock | 172.3 | 172.35 | 170.29 | 170.32 | 522035.0 |
| 2022-02-04 09:00:00 | AAPL | Stock | 170.45 | 171.85 | 170.02 | 171.7 | 447600.0 |
| 2022-02-04 09:30:00 | AAPL | Stock | 171.73 | 172.3795 | 170.68 | 172.19 | 8869873.0 |
| 2022-02-04 10:00:00 | AAPL | Stock | 172.18 | 172.92 | 171.52 | 171.575 | 5551927.0 |
| 2022-02-04 10:30:00 | AAPL | Stock | 171.57 | 172.02 | 171.02 | 171.23 | 4841426.0 |
| 2022-02-04 11:00:00 | AAPL | Stock | 171.23 | 171.68 | 170.81 | 171.55 | 3991512.0 |
| 2022-02-04 11:30:00 | AAPL | Stock | 171.54 | 172.62 | 171.47 | 172.053 | 3598813.0 |
| 2022-02-04 12:00:00 | AAPL | Stock | 172.0618 | 172.23 | 171.69 | 171.975 | 2430426.0 |
| 2022-02-04 12:30:00 | AAPL | Stock | 171.99 | 172.61 | 171.675 | 172.47 | 2945616.0 |
| 2022-02-04 13:00:00 | AAPL | Stock | 172.47 | 173.45 | 172.46 | 173.02 | 3526881.0 |
| 2022-02-04 13:30:00 | AAPL | Stock | 173.02 | 173.73 | 172.89 | 173.33 | 3318038.0 |
| 2022-02-04 14:00:00 | AAPL | Stock | 173.34 | 173.43 | 172.52 | 172.852 | 3180836.0 |
| 2022-02-04 14:30:00 | AAPL | Stock | 172.86 | 173.5 | 172.77 | 173.225 | 2975560.0 |
| 2022-02-04 15:00:00 | AAPL | Stock | 173.23 | 173.93 | 173.23 | 173.535 | 3583108.0 |
| 2022-02-04 15:30:00 | AAPL | Stock | 173.55 | 174.1 | 172.22 | 172.32 | 6528398.0 |
| 2022-02-04 16:00:00 | AAPL | Stock | 172.34 | 172.54 | 172.02 | 172.48 | 7899009.0 |
| 2022-02-04 16:30:00 | AAPL | Stock | 172.48 | 172.55 | 172.39 | 172.51 | 84964.0 |
| 2022-02-04 17:00:00 | AAPL | Stock | 172.49 | 172.49 | 172.39 | 172.46 | 48801.0 |
| 2022-02-04 17:30:00 | AAPL | Stock | 172.43 | 172.66 | 172.41 | 172.6 | 8892.0 |
| 2022-02-04 18:00:00 | AAPL | Stock | 172.6 | 172.6 | 172.52 | 172.52 | 10750.0 |
| 2022-02-04 18:30:00 | AAPL | Stock | 172.56 | 172.6 | 172.51 | 172.55 | 11536.0 |
| 2022-02-04 19:00:00 | AAPL | Stock | 172.52 | 172.55 | 172.52 | 172.54 | 4148.0 |
| 2022-02-04 19:30:00 | AAPL | Stock | 172.52 | 172.55 | 172.4 | 172.5 | 12897.0 |
| 2022-02-04 04:00:00 | MSFT | Stock | 304.9 | 304.9 | 303.81 | 304.46 | 6568.0 |
| 2022-02-04 04:30:00 | MSFT | Stock | 304.0 | 304.55 | 303.61 | 303.61 | 6072.0 |
| 2022-02-04 05:00:00 | MSFT | Stock | 303.6 | 303.61 | 302.25 | 302.72 | 4109.0 |
| 2022-02-04 05:30:00 | MSFT | Stock | 302.46 | 302.51 | 301.7 | 301.74 | 5303.0 |
| 2022-02-04 06:00:00 | MSFT | Stock | 302.1 | 302.1 | 300.66 | 301.5 | 10614.0 |
| 2022-02-04 06:30:00 | MSFT | Stock | 301.52 | 301.52 | 300.02 | 300.4 | 5399.0 |
| 2022-02-04 07:00:00 | MSFT | Stock | 300.46 | 301.6 | 300.16 | 301.26 | 29985.0 |
| 2022-02-04 07:30:00 | MSFT | Stock | 301.21 | 302.49 | 300.81 | 302.48 | 40815.0 |
| 2022-02-04 08:00:00 | MSFT | Stock | 301.2522 | 303.37 | 300.64 | 303.0 | 48598.0 |
| 2022-02-04 08:30:00 | MSFT | Stock | 302.83 | 302.83 | 298.99 | 299.0 | 148088.0 |
| 2022-02-04 09:00:00 | MSFT | Stock | 298.91 | 300.893 | 297.28 | 300.12 | 125157.0 |
| 2022-02-04 09:30:00 | MSFT | Stock | 300.12 | 304.625 | 299.97 | 304.295 | 3253143.0 |
| 2022-02-04 10:00:00 | MSFT | Stock | 304.29 | 306.43 | 303.58 | 303.7 | 2229029.0 |
| 2022-02-04 10:30:00 | MSFT | Stock | 303.67 | 304.6 | 302.54 | 303.43 | 1466907.0 |
| 2022-02-04 11:00:00 | MSFT | Stock | 303.4 | 305.56 | 302.82 | 305.115 | 1163684.0 |
| 2022-02-04 11:30:00 | MSFT | Stock | 305.26 | 306.06 | 304.84 | 305.15 | 1244902.0 |
| 2022-02-04 12:00:00 | MSFT | Stock | 305.22 | 306.265 | 304.61 | 305.75 | 988858.0 |
| 2022-02-04 12:30:00 | MSFT | Stock | 305.78 | 307.0 | 305.18 | 306.41 | 933449.0 |
> showing 50 of 106,728 rows — these rows as CSV