PREVIEW / stock_30min / 2022-11-23
file: by_date/stock_30min/2022/2022-11-23.parquet size: 2.0 MB rows: 99,431 symbols: 2,057
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-11-23 04:00:00 | AAPL | Stock | 149.75 | 150.14 | 149.68 | 149.96 | 21082.0 |
| 2022-11-23 04:30:00 | AAPL | Stock | 150.03 | 150.26 | 150.03 | 150.18 | 11304.0 |
| 2022-11-23 05:00:00 | AAPL | Stock | 150.08 | 150.09 | 149.75 | 149.94 | 9366.0 |
| 2022-11-23 05:30:00 | AAPL | Stock | 149.91 | 149.94 | 149.8 | 149.8 | 4932.0 |
| 2022-11-23 06:00:00 | AAPL | Stock | 149.89 | 149.91 | 149.54 | 149.58 | 15254.0 |
| 2022-11-23 06:30:00 | AAPL | Stock | 149.75 | 149.88 | 149.72 | 149.8 | 10757.0 |
| 2022-11-23 07:00:00 | AAPL | Stock | 149.82 | 149.91 | 149.62 | 149.78 | 50773.0 |
| 2022-11-23 07:30:00 | AAPL | Stock | 149.79 | 150.0 | 149.78 | 149.87 | 35946.0 |
| 2022-11-23 08:00:00 | AAPL | Stock | 149.7 | 150.0 | 149.1 | 149.14 | 136269.0 |
| 2022-11-23 08:30:00 | AAPL | Stock | 149.15 | 149.47 | 148.78 | 149.32 | 257900.0 |
| 2022-11-23 09:00:00 | AAPL | Stock | 149.32 | 149.59 | 149.1 | 149.43 | 149881.0 |
| 2022-11-23 09:30:00 | AAPL | Stock | 149.45 | 151.4296 | 149.3881 | 151.09 | 6596860.0 |
| 2022-11-23 10:00:00 | AAPL | Stock | 151.11 | 151.47 | 150.63 | 151.365 | 4263662.0 |
| 2022-11-23 10:30:00 | AAPL | Stock | 151.365 | 151.83 | 151.24 | 151.5811 | 3381653.0 |
| 2022-11-23 11:00:00 | AAPL | Stock | 151.59 | 151.76 | 151.09 | 151.3 | 2998898.0 |
| 2022-11-23 11:30:00 | AAPL | Stock | 151.29 | 151.29 | 149.79 | 150.1 | 3516602.0 |
| 2022-11-23 12:00:00 | AAPL | Stock | 150.09 | 150.42 | 149.97 | 150.19 | 2088651.0 |
| 2022-11-23 12:30:00 | AAPL | Stock | 150.2 | 150.29 | 149.34 | 149.645 | 2362656.0 |
| 2022-11-23 13:00:00 | AAPL | Stock | 149.64 | 150.14 | 149.53 | 150.12 | 1915982.0 |
| 2022-11-23 13:30:00 | AAPL | Stock | 150.13 | 150.46 | 150.13 | 150.304 | 1888881.0 |
| 2022-11-23 14:00:00 | AAPL | Stock | 150.29 | 151.31 | 149.76 | 151.0363 | 3783567.0 |
| 2022-11-23 14:30:00 | AAPL | Stock | 151.0385 | 151.13 | 150.53 | 150.98 | 3130061.0 |
| 2022-11-23 15:00:00 | AAPL | Stock | 150.99 | 151.42 | 150.74 | 151.175 | 3469600.0 |
| 2022-11-23 15:30:00 | AAPL | Stock | 151.17 | 151.1709 | 150.63 | 151.14 | 5122810.0 |
| 2022-11-23 16:00:00 | AAPL | Stock | 151.14 | 151.19 | 151.0327 | 151.14 | 5919074.0 |
| 2022-11-23 16:30:00 | AAPL | Stock | 151.15 | 151.16 | 151.07 | 151.12 | 26401.0 |
| 2022-11-23 17:00:00 | AAPL | Stock | 151.12 | 151.15 | 151.1 | 151.11 | 17911.0 |
| 2022-11-23 17:30:00 | AAPL | Stock | 151.11 | 151.17 | 151.11 | 151.1601 | 12355.0 |
| 2022-11-23 18:00:00 | AAPL | Stock | 151.16 | 151.2 | 151.14 | 151.18 | 4484.0 |
| 2022-11-23 18:30:00 | AAPL | Stock | 151.16 | 151.18 | 151.09 | 151.17 | 18676.0 |
| 2022-11-23 19:00:00 | AAPL | Stock | 151.17 | 151.21 | 151.11 | 151.13 | 13451.0 |
| 2022-11-23 19:30:00 | AAPL | Stock | 151.14 | 151.16 | 151.11 | 151.15 | 17227.0 |
| 2022-11-23 04:00:00 | MSFT | Stock | 245.18 | 245.18 | 245.18 | 245.18 | 390.0 |
| 2022-11-23 04:30:00 | MSFT | Stock | 245.7 | 246.0 | 245.7 | 246.0 | 4823.0 |
| 2022-11-23 05:00:00 | MSFT | Stock | 246.0 | 246.03 | 245.51 | 245.63 | 20741.0 |
| 2022-11-23 05:30:00 | MSFT | Stock | 245.5 | 245.5 | 245.49 | 245.49 | 822.0 |
| 2022-11-23 06:00:00 | MSFT | Stock | 245.36 | 245.36 | 245.25 | 245.25 | 200.0 |
| 2022-11-23 06:30:00 | MSFT | Stock | 245.57 | 246.0 | 245.57 | 246.0 | 1415.0 |
| 2022-11-23 07:00:00 | MSFT | Stock | 246.0 | 246.0 | 245.5 | 245.6 | 3580.0 |
| 2022-11-23 07:30:00 | MSFT | Stock | 245.76 | 245.82 | 245.6 | 245.75 | 3639.0 |
| 2022-11-23 08:00:00 | MSFT | Stock | 245.51 | 245.89 | 245.4 | 245.5 | 7324.0 |
| 2022-11-23 08:30:00 | MSFT | Stock | 245.55 | 245.8 | 245.07 | 245.48 | 6955.0 |
| 2022-11-23 09:00:00 | MSFT | Stock | 245.63 | 245.89 | 244.95 | 245.1 | 22042.0 |
| 2022-11-23 09:30:00 | MSFT | Stock | 245.04 | 246.789 | 244.27 | 246.41 | 2001107.0 |
| 2022-11-23 10:00:00 | MSFT | Stock | 246.44 | 247.26 | 245.8809 | 246.95 | 1019176.0 |
| 2022-11-23 10:30:00 | MSFT | Stock | 246.97 | 247.64 | 246.81 | 247.4 | 807883.0 |
| 2022-11-23 11:00:00 | MSFT | Stock | 247.4 | 247.73 | 247.09 | 247.1006 | 792039.0 |
| 2022-11-23 11:30:00 | MSFT | Stock | 247.11 | 247.13 | 245.09 | 245.6443 | 620611.0 |
| 2022-11-23 12:00:00 | MSFT | Stock | 245.62 | 246.415 | 245.29 | 245.99 | 585989.0 |
| 2022-11-23 12:30:00 | MSFT | Stock | 246.01 | 246.23 | 245.02 | 245.33 | 452925.0 |
> showing 50 of 99,431 rows — these rows as CSV