PREVIEW / stock_30min / 2022-10-04
file: by_date/stock_30min/2022/2022-10-04.parquet size: 2.1 MB rows: 107,096 symbols: 2,269
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-10-04 04:00:00 | AAPL | Stock | 144.02 | 145.27 | 144.02 | 144.86 | 24713.0 |
| 2022-10-04 04:30:00 | AAPL | Stock | 144.83 | 144.96 | 144.74 | 144.96 | 10560.0 |
| 2022-10-04 05:00:00 | AAPL | Stock | 144.91 | 144.98 | 144.66 | 144.98 | 27405.0 |
| 2022-10-04 05:30:00 | AAPL | Stock | 144.98 | 145.19 | 144.71 | 145.15 | 29289.0 |
| 2022-10-04 06:00:00 | AAPL | Stock | 145.07 | 145.56 | 145.04 | 145.39 | 13642.0 |
| 2022-10-04 06:30:00 | AAPL | Stock | 145.34 | 145.5 | 145.07 | 145.07 | 15215.0 |
| 2022-10-04 07:00:00 | AAPL | Stock | 145.07 | 145.18 | 144.86 | 145.0 | 72771.0 |
| 2022-10-04 07:30:00 | AAPL | Stock | 145.0 | 145.18 | 144.97 | 145.18 | 52735.0 |
| 2022-10-04 08:00:00 | AAPL | Stock | 145.0 | 145.48 | 144.55 | 145.0 | 297903.0 |
| 2022-10-04 08:30:00 | AAPL | Stock | 145.01 | 145.22 | 144.8 | 145.18 | 133419.0 |
| 2022-10-04 09:00:00 | AAPL | Stock | 145.15 | 145.25 | 144.83 | 145.09 | 245952.0 |
| 2022-10-04 09:30:00 | AAPL | Stock | 145.03 | 145.34 | 144.5 | 145.085 | 11373142.0 |
| 2022-10-04 10:00:00 | AAPL | Stock | 145.085 | 146.1 | 145.045 | 145.72 | 7066892.0 |
| 2022-10-04 10:30:00 | AAPL | Stock | 145.72 | 146.22 | 145.41 | 145.75 | 6249220.0 |
| 2022-10-04 11:00:00 | AAPL | Stock | 145.755 | 145.79 | 145.04 | 145.23 | 4443059.0 |
| 2022-10-04 11:30:00 | AAPL | Stock | 145.23 | 145.79 | 144.96 | 145.2802 | 3941870.0 |
| 2022-10-04 12:00:00 | AAPL | Stock | 145.285 | 145.67 | 145.07 | 145.475 | 3076480.0 |
| 2022-10-04 12:30:00 | AAPL | Stock | 145.4709 | 145.6 | 144.85 | 144.86 | 2666765.0 |
| 2022-10-04 13:00:00 | AAPL | Stock | 144.86 | 144.95 | 144.26 | 144.8801 | 3656082.0 |
| 2022-10-04 13:30:00 | AAPL | Stock | 144.89 | 145.53 | 144.63 | 145.25 | 3369655.0 |
| 2022-10-04 14:00:00 | AAPL | Stock | 145.25 | 145.4539 | 145.06 | 145.1079 | 2367404.0 |
| 2022-10-04 14:30:00 | AAPL | Stock | 145.1022 | 146.09 | 145.04 | 145.8639 | 3506608.0 |
| 2022-10-04 15:00:00 | AAPL | Stock | 145.86 | 145.92 | 145.11 | 145.73 | 3938988.0 |
| 2022-10-04 15:30:00 | AAPL | Stock | 145.73 | 146.22 | 145.52 | 146.16 | 7935771.0 |
| 2022-10-04 16:00:00 | AAPL | Stock | 146.17 | 146.22 | 145.85 | 146.02 | 10277434.0 |
| 2022-10-04 16:30:00 | AAPL | Stock | 146.02 | 146.1 | 145.94 | 145.98 | 116212.0 |
| 2022-10-04 17:00:00 | AAPL | Stock | 145.97 | 146.06 | 145.71 | 145.97 | 32463.0 |
| 2022-10-04 17:30:00 | AAPL | Stock | 145.99 | 146.09 | 145.9 | 145.99 | 14830.0 |
| 2022-10-04 18:00:00 | AAPL | Stock | 145.96 | 146.01 | 145.7 | 145.78 | 21569.0 |
| 2022-10-04 18:30:00 | AAPL | Stock | 145.79 | 145.81 | 145.63 | 145.81 | 20845.0 |
| 2022-10-04 19:00:00 | AAPL | Stock | 145.8 | 145.9 | 145.69 | 145.82 | 38003.0 |
| 2022-10-04 19:30:00 | AAPL | Stock | 145.8 | 146.08 | 145.8 | 146.0 | 22583.0 |
| 2022-10-04 04:00:00 | MSFT | Stock | 244.31 | 244.99 | 243.01 | 244.12 | 5253.0 |
| 2022-10-04 04:30:00 | MSFT | Stock | 244.61 | 244.61 | 244.36 | 244.4 | 2693.0 |
| 2022-10-04 05:00:00 | MSFT | Stock | 244.79 | 245.0 | 244.41 | 245.0 | 3058.0 |
| 2022-10-04 05:30:00 | MSFT | Stock | 244.86 | 245.25 | 244.71 | 245.25 | 4885.0 |
| 2022-10-04 06:00:00 | MSFT | Stock | 245.15 | 246.0 | 244.89 | 246.0 | 5596.0 |
| 2022-10-04 06:30:00 | MSFT | Stock | 246.23 | 246.23 | 245.67 | 245.96 | 9403.0 |
| 2022-10-04 07:00:00 | MSFT | Stock | 245.9 | 245.97 | 245.5 | 245.62 | 18915.0 |
| 2022-10-04 07:30:00 | MSFT | Stock | 245.63 | 245.89 | 245.5 | 245.6 | 11948.0 |
| 2022-10-04 08:00:00 | MSFT | Stock | 245.45 | 246.0 | 240.139 | 244.9 | 45630.0 |
| 2022-10-04 08:30:00 | MSFT | Stock | 244.91 | 244.91 | 244.2 | 244.85 | 40845.0 |
| 2022-10-04 09:00:00 | MSFT | Stock | 244.85 | 245.26 | 244.41 | 244.98 | 29701.0 |
| 2022-10-04 09:30:00 | MSFT | Stock | 245.09 | 249.24 | 244.975 | 249.155 | 4077344.0 |
| 2022-10-04 10:00:00 | MSFT | Stock | 249.155 | 250.36 | 248.62 | 249.2801 | 3047709.0 |
| 2022-10-04 10:30:00 | MSFT | Stock | 249.305 | 250.2 | 249.0635 | 249.589 | 1766144.0 |
| 2022-10-04 11:00:00 | MSFT | Stock | 249.57 | 249.92 | 249.06 | 249.17 | 1484044.0 |
| 2022-10-04 11:30:00 | MSFT | Stock | 249.19 | 249.403 | 248.23 | 248.53 | 1316260.0 |
| 2022-10-04 12:00:00 | MSFT | Stock | 248.54 | 249.2 | 248.2204 | 249.02 | 1045878.0 |
| 2022-10-04 12:30:00 | MSFT | Stock | 249.02 | 249.1234 | 247.7403 | 248.05 | 884561.0 |
> showing 50 of 107,096 rows — these rows as CSV