PREVIEW / stock_30min / 2022-11-25
file: by_date/stock_30min/2022/2022-11-25.parquet size: 1.3 MB rows: 60,126 symbols: 1,910
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-25 04:00:00 | AAPL | Stock | 151.16 | 151.16 | 150.37 | 150.52 | 23760.0 |
| 2022-11-25 04:30:00 | AAPL | Stock | 150.55 | 150.65 | 150.14 | 150.34 | 17173.0 |
| 2022-11-25 05:00:00 | AAPL | Stock | 150.35 | 150.42 | 150.16 | 150.26 | 12392.0 |
| 2022-11-25 05:30:00 | AAPL | Stock | 150.34 | 150.38 | 150.19 | 150.36 | 18051.0 |
| 2022-11-25 06:00:00 | AAPL | Stock | 150.34 | 150.5 | 150.27 | 150.34 | 9283.0 |
| 2022-11-25 06:30:00 | AAPL | Stock | 150.35 | 150.44 | 150.02 | 150.06 | 18544.0 |
| 2022-11-25 07:00:00 | AAPL | Stock | 150.06 | 150.25 | 150.06 | 150.2 | 27025.0 |
| 2022-11-25 07:30:00 | AAPL | Stock | 150.2 | 150.21 | 149.47 | 149.49 | 75187.0 |
| 2022-11-25 08:00:00 | AAPL | Stock | 150.2283 | 151.15 | 149.46 | 149.54 | 185970.0 |
| 2022-11-25 08:30:00 | AAPL | Stock | 149.54 | 149.54 | 149.09 | 149.13 | 172420.0 |
| 2022-11-25 09:00:00 | AAPL | Stock | 149.15 | 149.2 | 148.18 | 148.32 | 279389.0 |
| 2022-11-25 09:30:00 | AAPL | Stock | 148.305 | 148.73 | 147.12 | 148.65 | 8098846.0 |
| 2022-11-25 10:00:00 | AAPL | Stock | 148.645 | 148.88 | 148.35 | 148.3999 | 3613106.0 |
| 2022-11-25 10:30:00 | AAPL | Stock | 148.3818 | 148.39 | 147.95 | 148.155 | 2369092.0 |
| 2022-11-25 11:00:00 | AAPL | Stock | 148.151 | 148.4 | 147.75 | 147.8255 | 2477523.0 |
| 2022-11-25 11:30:00 | AAPL | Stock | 147.82 | 148.38 | 147.6 | 148.295 | 2854632.0 |
| 2022-11-25 12:00:00 | AAPL | Stock | 148.29 | 148.4099 | 147.875 | 148.17 | 2661831.0 |
| 2022-11-25 12:30:00 | AAPL | Stock | 148.18 | 148.2 | 147.8 | 148.16 | 4039978.0 |
| 2022-11-25 13:00:00 | AAPL | Stock | 148.11 | 148.16 | 147.9 | 148.03 | 3577684.0 |
| 2022-11-25 13:30:00 | AAPL | Stock | 148.09 | 148.13 | 148.02 | 148.12 | 60160.0 |
| 2022-11-25 14:00:00 | AAPL | Stock | 148.1299 | 148.15 | 148.11 | 148.14 | 25873.0 |
| 2022-11-25 14:30:00 | AAPL | Stock | 148.13 | 148.15 | 148.12 | 148.12 | 6054.0 |
| 2022-11-25 15:00:00 | AAPL | Stock | 148.115 | 148.12 | 148.11 | 148.1199 | 6024.0 |
| 2022-11-25 15:30:00 | AAPL | Stock | 148.12 | 148.12 | 148.11 | 148.115 | 13519.0 |
| 2022-11-25 16:00:00 | AAPL | Stock | 148.11 | 148.12 | 148.11 | 148.11 | 58000.0 |
| 2022-11-25 16:30:00 | AAPL | Stock | 148.12 | 148.12 | 148.11 | 148.12 | 19182.0 |
| 2022-11-25 04:00:00 | MSFT | Stock | 248.22 | 248.4 | 248.08 | 248.2 | 1729.0 |
| 2022-11-25 04:30:00 | MSFT | Stock | 248.4 | 248.4 | 247.65 | 247.81 | 2965.0 |
| 2022-11-25 05:00:00 | MSFT | Stock | 247.66 | 247.82 | 247.66 | 247.82 | 210.0 |
| 2022-11-25 05:30:00 | MSFT | Stock | 248.0 | 248.26 | 248.0 | 248.26 | 438.0 |
| 2022-11-25 06:00:00 | MSFT | Stock | 247.83 | 247.98 | 247.65 | 247.97 | 1161.0 |
| 2022-11-25 06:30:00 | MSFT | Stock | 247.97 | 247.97 | 247.58 | 247.61 | 2028.0 |
| 2022-11-25 07:00:00 | MSFT | Stock | 247.59 | 247.59 | 247.53 | 247.53 | 200.0 |
| 2022-11-25 07:30:00 | MSFT | Stock | 247.37 | 247.38 | 247.07 | 247.1 | 3626.0 |
| 2022-11-25 08:00:00 | MSFT | Stock | 247.5 | 247.74 | 246.962 | 247.23 | 12904.0 |
| 2022-11-25 08:30:00 | MSFT | Stock | 247.23 | 247.29 | 247.1 | 247.1 | 4412.0 |
| 2022-11-25 09:00:00 | MSFT | Stock | 247.11 | 247.42 | 246.42 | 247.42 | 15337.0 |
| 2022-11-25 09:30:00 | MSFT | Stock | 247.42 | 248.7 | 247.125 | 247.82 | 1641929.0 |
| 2022-11-25 10:00:00 | MSFT | Stock | 247.8421 | 248.15 | 247.41 | 247.81 | 722439.0 |
| 2022-11-25 10:30:00 | MSFT | Stock | 247.77 | 248.03 | 247.67 | 247.9758 | 461428.0 |
| 2022-11-25 11:00:00 | MSFT | Stock | 247.97 | 248.19 | 247.27 | 247.37 | 575773.0 |
| 2022-11-25 11:30:00 | MSFT | Stock | 247.355 | 247.6999 | 246.73 | 247.51 | 555042.0 |
| 2022-11-25 12:00:00 | MSFT | Stock | 247.51 | 247.77 | 247.16 | 247.76 | 493550.0 |
| 2022-11-25 12:30:00 | MSFT | Stock | 247.78 | 248.04 | 247.41 | 247.58 | 966544.0 |
| 2022-11-25 13:00:00 | MSFT | Stock | 247.66 | 247.67 | 247.47 | 247.5 | 1388509.0 |
| 2022-11-25 13:30:00 | MSFT | Stock | 247.5 | 247.5599 | 247.0 | 247.25 | 4703.0 |
| 2022-11-25 14:00:00 | MSFT | Stock | 247.42 | 247.8 | 247.42 | 247.5501 | 9756.0 |
| 2022-11-25 14:30:00 | MSFT | Stock | 247.61 | 247.62 | 247.51 | 247.51 | 1494.0 |
| 2022-11-25 15:00:00 | MSFT | Stock | 247.55 | 247.555 | 247.51 | 247.51 | 504.0 |
| 2022-11-25 15:30:00 | MSFT | Stock | 247.68 | 247.68 | 247.4 | 247.4 | 587.0 |
> showing 50 of 60,126 rows — these rows as CSV