PREVIEW / stock_30min / 2022-06-06
file: by_date/stock_30min/2022/2022-06-06.parquet size: 2.1 MB rows: 105,864 symbols: 2,374
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-06 04:00:00 | AAPL | Stock | 146.19 | 147.72 | 146.19 | 147.48 | 32567.0 |
| 2022-06-06 04:30:00 | AAPL | Stock | 147.5 | 147.68 | 147.45 | 147.68 | 11506.0 |
| 2022-06-06 05:00:00 | AAPL | Stock | 147.6 | 147.67 | 147.49 | 147.62 | 7361.0 |
| 2022-06-06 05:30:00 | AAPL | Stock | 147.49 | 147.5 | 147.27 | 147.39 | 4776.0 |
| 2022-06-06 06:00:00 | AAPL | Stock | 147.44 | 147.7 | 147.44 | 147.6 | 12417.0 |
| 2022-06-06 06:30:00 | AAPL | Stock | 147.58 | 148.0 | 147.58 | 147.71 | 17039.0 |
| 2022-06-06 07:00:00 | AAPL | Stock | 147.75 | 147.75 | 147.27 | 147.4 | 68505.0 |
| 2022-06-06 07:30:00 | AAPL | Stock | 147.36 | 147.5 | 147.14 | 147.4 | 47755.0 |
| 2022-06-06 08:00:00 | AAPL | Stock | 147.43 | 147.64 | 146.76 | 147.23 | 332126.0 |
| 2022-06-06 08:30:00 | AAPL | Stock | 147.24 | 147.33 | 146.95 | 146.96 | 251154.0 |
| 2022-06-06 09:00:00 | AAPL | Stock | 146.96 | 147.15 | 146.75 | 146.95 | 359177.0 |
| 2022-06-06 09:30:00 | AAPL | Stock | 146.99 | 148.31 | 146.99 | 147.83 | 8656396.0 |
| 2022-06-06 10:00:00 | AAPL | Stock | 147.83 | 148.44 | 147.75 | 148.21 | 5044473.0 |
| 2022-06-06 10:30:00 | AAPL | Stock | 148.21 | 148.5689 | 148.0 | 148.17 | 3704975.0 |
| 2022-06-06 11:00:00 | AAPL | Stock | 148.18 | 148.3385 | 146.01 | 146.5591 | 5861538.0 |
| 2022-06-06 11:30:00 | AAPL | Stock | 146.56 | 146.8 | 146.12 | 146.52 | 2899869.0 |
| 2022-06-06 12:00:00 | AAPL | Stock | 146.52 | 146.57 | 145.4 | 145.58 | 3529057.0 |
| 2022-06-06 12:30:00 | AAPL | Stock | 145.58 | 146.14 | 145.2 | 146.085 | 2752344.0 |
| 2022-06-06 13:00:00 | AAPL | Stock | 146.08 | 146.23 | 145.6 | 145.8701 | 2754520.0 |
| 2022-06-06 13:30:00 | AAPL | Stock | 145.87 | 146.74 | 145.81 | 146.6487 | 2912868.0 |
| 2022-06-06 14:00:00 | AAPL | Stock | 146.65 | 146.89 | 145.66 | 145.76 | 3333089.0 |
| 2022-06-06 14:30:00 | AAPL | Stock | 145.75 | 145.97 | 145.07 | 145.3999 | 4402982.0 |
| 2022-06-06 15:00:00 | AAPL | Stock | 145.4 | 145.75 | 144.9 | 145.3495 | 4111639.0 |
| 2022-06-06 15:30:00 | AAPL | Stock | 145.345 | 146.47 | 145.2401 | 146.14 | 6581405.0 |
| 2022-06-06 16:00:00 | AAPL | Stock | 146.14 | 146.5 | 146.05 | 146.2 | 3878358.0 |
| 2022-06-06 16:30:00 | AAPL | Stock | 146.21 | 146.32 | 146.14 | 146.27 | 343857.0 |
| 2022-06-06 17:00:00 | AAPL | Stock | 146.27 | 146.42 | 146.14 | 146.24 | 50733.0 |
| 2022-06-06 17:30:00 | AAPL | Stock | 146.2 | 146.29 | 146.17 | 146.2883 | 10550.0 |
| 2022-06-06 18:00:00 | AAPL | Stock | 146.29 | 146.3 | 146.18 | 146.24 | 15763.0 |
| 2022-06-06 18:30:00 | AAPL | Stock | 146.23 | 146.23 | 146.03 | 146.07 | 24658.0 |
| 2022-06-06 19:00:00 | AAPL | Stock | 146.06 | 146.13 | 146.06 | 146.1 | 15334.0 |
| 2022-06-06 19:30:00 | AAPL | Stock | 146.07 | 146.54 | 146.07 | 146.5 | 37242.0 |
| 2022-06-06 04:00:00 | MSFT | Stock | 272.35 | 273.54 | 271.37 | 273.54 | 2697.0 |
| 2022-06-06 04:30:00 | MSFT | Stock | 273.79 | 273.79 | 273.47 | 273.6 | 885.0 |
| 2022-06-06 05:00:00 | MSFT | Stock | 273.7 | 273.7 | 273.26 | 273.4 | 3696.0 |
| 2022-06-06 05:30:00 | MSFT | Stock | 273.4 | 273.48 | 273.0 | 273.0 | 4038.0 |
| 2022-06-06 06:00:00 | MSFT | Stock | 273.15 | 273.3 | 273.15 | 273.17 | 2105.0 |
| 2022-06-06 06:30:00 | MSFT | Stock | 273.37 | 273.5 | 273.37 | 273.5 | 726.0 |
| 2022-06-06 07:00:00 | MSFT | Stock | 273.4 | 273.65 | 272.8 | 273.35 | 9581.0 |
| 2022-06-06 07:30:00 | MSFT | Stock | 273.35 | 273.5 | 272.71 | 273.19 | 6262.0 |
| 2022-06-06 08:00:00 | MSFT | Stock | 273.19 | 273.5 | 269.345 | 273.18 | 24008.0 |
| 2022-06-06 08:30:00 | MSFT | Stock | 273.0 | 273.37 | 272.65 | 272.65 | 21525.0 |
| 2022-06-06 09:00:00 | MSFT | Stock | 272.66 | 272.86 | 271.65 | 271.94 | 34305.0 |
| 2022-06-06 09:30:00 | MSFT | Stock | 272.06 | 273.88 | 271.32 | 273.29 | 1890801.0 |
| 2022-06-06 10:00:00 | MSFT | Stock | 273.275 | 274.18 | 272.56 | 273.17 | 1095917.0 |
| 2022-06-06 10:30:00 | MSFT | Stock | 273.1996 | 273.92 | 273.1 | 273.66 | 761578.0 |
| 2022-06-06 11:00:00 | MSFT | Stock | 273.71 | 273.97 | 270.1 | 270.5 | 1254201.0 |
| 2022-06-06 11:30:00 | MSFT | Stock | 270.48 | 270.98 | 269.81 | 270.46 | 689024.0 |
| 2022-06-06 12:00:00 | MSFT | Stock | 270.45 | 270.4924 | 268.521 | 268.6905 | 683638.0 |
| 2022-06-06 12:30:00 | MSFT | Stock | 268.68 | 269.68 | 268.17 | 269.576 | 629003.0 |
> showing 50 of 105,864 rows — these rows as CSV