PREVIEW / stock_30min / 2022-06-03
file: by_date/stock_30min/2022/2022-06-03.parquet size: 2.1 MB rows: 102,872 symbols: 2,364
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-06-03 04:00:00 | AAPL | Stock | 150.7 | 150.7 | 149.87 | 150.24 | 35349.0 |
| 2022-06-03 04:30:00 | AAPL | Stock | 150.34 | 150.48 | 150.21 | 150.39 | 12354.0 |
| 2022-06-03 05:00:00 | AAPL | Stock | 150.29 | 150.32 | 150.08 | 150.08 | 12332.0 |
| 2022-06-03 05:30:00 | AAPL | Stock | 150.1 | 150.24 | 150.02 | 150.24 | 8570.0 |
| 2022-06-03 06:00:00 | AAPL | Stock | 150.2 | 150.27 | 150.0 | 150.22 | 8437.0 |
| 2022-06-03 06:30:00 | AAPL | Stock | 150.17 | 150.21 | 147.65 | 148.21 | 133017.0 |
| 2022-06-03 07:00:00 | AAPL | Stock | 148.34 | 148.82 | 148.0 | 148.48 | 152357.0 |
| 2022-06-03 07:30:00 | AAPL | Stock | 148.45 | 148.68 | 147.58 | 147.71 | 198462.0 |
| 2022-06-03 08:00:00 | AAPL | Stock | 148.7 | 151.0 | 147.53 | 148.0 | 502715.0 |
| 2022-06-03 08:30:00 | AAPL | Stock | 148.07 | 148.94 | 147.07 | 147.56 | 1017065.0 |
| 2022-06-03 09:00:00 | AAPL | Stock | 147.6199 | 148.05 | 146.75 | 146.89 | 637155.0 |
| 2022-06-03 09:30:00 | AAPL | Stock | 146.9 | 147.97 | 145.72 | 147.135 | 12663985.0 |
| 2022-06-03 10:00:00 | AAPL | Stock | 147.15 | 147.4782 | 146.1416 | 146.345 | 6917796.0 |
| 2022-06-03 10:30:00 | AAPL | Stock | 146.345 | 146.345 | 145.25 | 145.52 | 5571042.0 |
| 2022-06-03 11:00:00 | AAPL | Stock | 145.51 | 145.585 | 144.46 | 144.76 | 5358775.0 |
| 2022-06-03 11:30:00 | AAPL | Stock | 144.7639 | 145.535 | 144.71 | 145.1316 | 3968414.0 |
| 2022-06-03 12:00:00 | AAPL | Stock | 145.13 | 145.74 | 145.01 | 145.66 | 3708932.0 |
| 2022-06-03 12:30:00 | AAPL | Stock | 145.67 | 146.105 | 145.475 | 145.95 | 2781430.0 |
| 2022-06-03 13:00:00 | AAPL | Stock | 145.9521 | 146.3442 | 145.16 | 145.35 | 4016792.0 |
| 2022-06-03 13:30:00 | AAPL | Stock | 145.34 | 145.42 | 144.85 | 145.0499 | 3048217.0 |
| 2022-06-03 14:00:00 | AAPL | Stock | 145.0451 | 145.7012 | 144.92 | 145.6807 | 2717579.0 |
| 2022-06-03 14:30:00 | AAPL | Stock | 145.68 | 145.72 | 145.14 | 145.48 | 3119603.0 |
| 2022-06-03 15:00:00 | AAPL | Stock | 145.48 | 145.74 | 144.81 | 145.4331 | 4393234.0 |
| 2022-06-03 15:30:00 | AAPL | Stock | 145.44 | 145.7 | 145.02 | 145.39 | 8335142.0 |
| 2022-06-03 16:00:00 | AAPL | Stock | 145.38 | 145.54 | 145.24 | 145.54 | 7319880.0 |
| 2022-06-03 16:30:00 | AAPL | Stock | 145.54 | 145.57 | 145.38 | 145.4 | 148535.0 |
| 2022-06-03 17:00:00 | AAPL | Stock | 145.3901 | 145.64 | 145.3507 | 145.4608 | 42716.0 |
| 2022-06-03 17:30:00 | AAPL | Stock | 145.46 | 145.55 | 145.4 | 145.47 | 17810.0 |
| 2022-06-03 18:00:00 | AAPL | Stock | 145.47 | 145.47 | 145.25 | 145.35 | 25706.0 |
| 2022-06-03 18:30:00 | AAPL | Stock | 145.32 | 145.34 | 145.15 | 145.2 | 22630.0 |
| 2022-06-03 19:00:00 | AAPL | Stock | 145.21 | 145.33 | 145.2 | 145.24 | 12510.0 |
| 2022-06-03 19:30:00 | AAPL | Stock | 145.25 | 145.25 | 145.1 | 145.2 | 27835.0 |
| 2022-06-03 04:00:00 | MSFT | Stock | 272.7 | 272.7 | 272.7 | 272.7 | 100.0 |
| 2022-06-03 04:30:00 | MSFT | Stock | 272.89 | 273.24 | 272.85 | 273.1 | 6808.0 |
| 2022-06-03 05:00:00 | MSFT | Stock | 273.3 | 273.38 | 272.98 | 273.03 | 8072.0 |
| 2022-06-03 05:30:00 | MSFT | Stock | 273.2 | 273.57 | 273.01 | 273.05 | 9595.0 |
| 2022-06-03 06:00:00 | MSFT | Stock | 273.12 | 273.28 | 273.12 | 273.25 | 6278.0 |
| 2022-06-03 06:30:00 | MSFT | Stock | 273.38 | 273.39 | 272.3 | 272.34 | 11532.0 |
| 2022-06-03 07:00:00 | MSFT | Stock | 272.49 | 273.0 | 271.9 | 272.13 | 28890.0 |
| 2022-06-03 07:30:00 | MSFT | Stock | 272.33 | 272.96 | 271.61 | 271.7 | 21248.0 |
| 2022-06-03 08:00:00 | MSFT | Stock | 274.0 | 274.0 | 271.75 | 272.0 | 57596.0 |
| 2022-06-03 08:30:00 | MSFT | Stock | 272.08 | 273.0 | 270.26 | 270.99 | 107869.0 |
| 2022-06-03 09:00:00 | MSFT | Stock | 270.9 | 271.54 | 269.75 | 269.87 | 67346.0 |
| 2022-06-03 09:30:00 | MSFT | Stock | 270.0 | 272.8454 | 269.4701 | 272.09 | 2982083.0 |
| 2022-06-03 10:00:00 | MSFT | Stock | 272.14 | 273.45 | 271.36 | 271.98 | 1366671.0 |
| 2022-06-03 10:30:00 | MSFT | Stock | 271.99 | 272.1474 | 270.48 | 270.77 | 874808.0 |
| 2022-06-03 11:00:00 | MSFT | Stock | 270.76 | 270.81 | 268.41 | 268.82 | 1045607.0 |
| 2022-06-03 11:30:00 | MSFT | Stock | 268.82 | 269.8643 | 268.7 | 269.333 | 901998.0 |
| 2022-06-03 12:00:00 | MSFT | Stock | 269.33 | 270.07 | 268.87 | 269.74 | 656989.0 |
| 2022-06-03 12:30:00 | MSFT | Stock | 269.74 | 270.8664 | 269.44 | 270.68 | 551481.0 |
> showing 50 of 102,872 rows — these rows as CSV