PREVIEW / stock_30min / 2022-12-21
file: by_date/stock_30min/2022/2022-12-21.parquet size: 2.1 MB rows: 102,959 symbols: 1,974
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-12-21 04:00:00 | AAPL | Stock | 133.31 | 133.31 | 133.07 | 133.25 | 17406.0 |
| 2022-12-21 04:30:00 | AAPL | Stock | 133.27 | 133.35 | 133.2 | 133.33 | 8497.0 |
| 2022-12-21 05:00:00 | AAPL | Stock | 133.33 | 133.33 | 133.2 | 133.3 | 5677.0 |
| 2022-12-21 05:30:00 | AAPL | Stock | 133.25 | 133.26 | 132.93 | 133.03 | 8694.0 |
| 2022-12-21 06:00:00 | AAPL | Stock | 133.08 | 133.19 | 132.93 | 132.93 | 6004.0 |
| 2022-12-21 06:30:00 | AAPL | Stock | 132.93 | 133.04 | 132.76 | 133.04 | 6245.0 |
| 2022-12-21 07:00:00 | AAPL | Stock | 133.0 | 133.06 | 132.53 | 132.66 | 42970.0 |
| 2022-12-21 07:30:00 | AAPL | Stock | 132.77 | 133.14 | 132.72 | 133.04 | 21027.0 |
| 2022-12-21 08:00:00 | AAPL | Stock | 132.6108 | 133.4 | 132.53 | 133.11 | 102004.0 |
| 2022-12-21 08:30:00 | AAPL | Stock | 133.1 | 133.3 | 133.01 | 133.1 | 86215.0 |
| 2022-12-21 09:00:00 | AAPL | Stock | 133.16 | 133.1799 | 132.75 | 132.95 | 118078.0 |
| 2022-12-21 09:30:00 | AAPL | Stock | 132.99 | 134.43 | 132.75 | 133.54 | 8157372.0 |
| 2022-12-21 10:00:00 | AAPL | Stock | 133.54 | 135.0754 | 133.47 | 134.89 | 6376290.0 |
| 2022-12-21 10:30:00 | AAPL | Stock | 134.89 | 136.67 | 134.78 | 136.605 | 7875168.0 |
| 2022-12-21 11:00:00 | AAPL | Stock | 136.6 | 136.81 | 135.715 | 135.941 | 5801377.0 |
| 2022-12-21 11:30:00 | AAPL | Stock | 135.945 | 136.16 | 135.281 | 135.5288 | 3850402.0 |
| 2022-12-21 12:00:00 | AAPL | Stock | 135.53 | 135.554 | 135.08 | 135.162 | 3163712.0 |
| 2022-12-21 12:30:00 | AAPL | Stock | 135.16 | 136.01 | 135.15 | 135.9935 | 2968915.0 |
| 2022-12-21 13:00:00 | AAPL | Stock | 136.01 | 136.17 | 135.16 | 135.19 | 3146262.0 |
| 2022-12-21 13:30:00 | AAPL | Stock | 135.19 | 135.58 | 135.1601 | 135.47 | 2129831.0 |
| 2022-12-21 14:00:00 | AAPL | Stock | 135.48 | 136.1199 | 135.445 | 135.495 | 3307327.0 |
| 2022-12-21 14:30:00 | AAPL | Stock | 135.49 | 135.79 | 135.11 | 135.39 | 2799016.0 |
| 2022-12-21 15:00:00 | AAPL | Stock | 135.4 | 135.59 | 135.115 | 135.35 | 2817457.0 |
| 2022-12-21 15:30:00 | AAPL | Stock | 135.36 | 135.77 | 135.01 | 135.43 | 6617869.0 |
| 2022-12-21 16:00:00 | AAPL | Stock | 135.43 | 135.73 | 135.32 | 135.58 | 13751932.0 |
| 2022-12-21 16:30:00 | AAPL | Stock | 135.45 | 135.63 | 135.45 | 135.59 | 57822.0 |
| 2022-12-21 17:00:00 | AAPL | Stock | 135.58 | 135.64 | 135.55 | 135.6398 | 23464.0 |
| 2022-12-21 17:30:00 | AAPL | Stock | 135.64 | 135.66 | 135.5 | 135.66 | 13092.0 |
| 2022-12-21 18:00:00 | AAPL | Stock | 135.67 | 135.7 | 135.56 | 135.63 | 24770.0 |
| 2022-12-21 18:30:00 | AAPL | Stock | 135.62 | 135.7 | 135.5985 | 135.63 | 10682.0 |
| 2022-12-21 19:00:00 | AAPL | Stock | 135.63 | 135.63 | 135.51 | 135.57 | 14001.0 |
| 2022-12-21 19:30:00 | AAPL | Stock | 135.57 | 135.73 | 135.55 | 135.67 | 17801.0 |
| 2022-12-21 04:00:00 | MSFT | Stock | 243.0 | 243.23 | 243.0 | 243.14 | 2654.0 |
| 2022-12-21 04:30:00 | MSFT | Stock | 243.23 | 243.39 | 243.0 | 243.39 | 3671.0 |
| 2022-12-21 05:00:00 | MSFT | Stock | 243.25 | 243.25 | 243.0 | 243.15 | 4741.0 |
| 2022-12-21 05:30:00 | MSFT | Stock | 243.12 | 243.12 | 242.55 | 242.55 | 8981.0 |
| 2022-12-21 06:00:00 | MSFT | Stock | 242.47 | 242.7 | 242.28 | 242.28 | 4011.0 |
| 2022-12-21 06:30:00 | MSFT | Stock | 242.33 | 242.57 | 242.1 | 242.47 | 1400.0 |
| 2022-12-21 07:00:00 | MSFT | Stock | 242.55 | 242.66 | 241.74 | 241.74 | 3271.0 |
| 2022-12-21 07:30:00 | MSFT | Stock | 242.16 | 242.55 | 242.16 | 242.55 | 3252.0 |
| 2022-12-21 08:00:00 | MSFT | Stock | 242.45 | 242.89 | 241.196 | 242.71 | 15875.0 |
| 2022-12-21 08:30:00 | MSFT | Stock | 242.73 | 242.9054 | 242.42 | 242.63 | 14117.0 |
| 2022-12-21 09:00:00 | MSFT | Stock | 242.59 | 242.6357 | 241.63 | 241.76 | 44546.0 |
| 2022-12-21 09:30:00 | MSFT | Stock | 241.71 | 243.68 | 240.11 | 242.1432 | 2651782.0 |
| 2022-12-21 10:00:00 | MSFT | Stock | 242.15 | 243.67 | 241.92 | 243.14 | 1449712.0 |
| 2022-12-21 10:30:00 | MSFT | Stock | 243.16 | 244.51 | 242.9399 | 244.37 | 1250099.0 |
| 2022-12-21 11:00:00 | MSFT | Stock | 244.39 | 245.39 | 243.775 | 244.18 | 1363499.0 |
| 2022-12-21 11:30:00 | MSFT | Stock | 244.18 | 244.67 | 243.48 | 243.67 | 690444.0 |
| 2022-12-21 12:00:00 | MSFT | Stock | 243.7 | 244.47 | 243.48 | 244.26 | 817896.0 |
| 2022-12-21 12:30:00 | MSFT | Stock | 244.25 | 245.18 | 244.25 | 245.1 | 683092.0 |
> showing 50 of 102,959 rows — these rows as CSV