PREVIEW / stock_30min / 2022-11-28
file: by_date/stock_30min/2022/2022-11-28.parquet size: 2.1 MB rows: 102,092 symbols: 2,104
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-28 04:00:00 | AAPL | Stock | 147.05 | 147.64 | 145.93 | 146.0 | 54995.0 |
| 2022-11-28 04:30:00 | AAPL | Stock | 145.82 | 145.83 | 145.03 | 145.3 | 37320.0 |
| 2022-11-28 05:00:00 | AAPL | Stock | 145.26 | 145.48 | 145.15 | 145.4 | 8149.0 |
| 2022-11-28 05:30:00 | AAPL | Stock | 145.43 | 145.5 | 145.25 | 145.37 | 7958.0 |
| 2022-11-28 06:00:00 | AAPL | Stock | 145.31 | 145.58 | 145.2 | 145.47 | 16420.0 |
| 2022-11-28 06:30:00 | AAPL | Stock | 145.4 | 145.48 | 145.07 | 145.43 | 22413.0 |
| 2022-11-28 07:00:00 | AAPL | Stock | 145.48 | 145.86 | 145.32 | 145.32 | 112145.0 |
| 2022-11-28 07:30:00 | AAPL | Stock | 145.34 | 145.63 | 145.3 | 145.5 | 59803.0 |
| 2022-11-28 08:00:00 | AAPL | Stock | 145.48 | 147.74 | 144.78 | 145.0 | 316889.0 |
| 2022-11-28 08:30:00 | AAPL | Stock | 145.03 | 145.34 | 144.88 | 145.32 | 219270.0 |
| 2022-11-28 09:00:00 | AAPL | Stock | 145.29 | 145.29 | 144.89 | 145.18 | 224823.0 |
| 2022-11-28 09:30:00 | AAPL | Stock | 145.17 | 146.64 | 144.82 | 145.96 | 8366117.0 |
| 2022-11-28 10:00:00 | AAPL | Stock | 145.97 | 146.19 | 144.8299 | 145.13 | 5307375.0 |
| 2022-11-28 10:30:00 | AAPL | Stock | 145.13 | 145.57 | 144.935 | 145.01 | 3435389.0 |
| 2022-11-28 11:00:00 | AAPL | Stock | 145.005 | 145.48 | 144.77 | 145.09 | 3675699.0 |
| 2022-11-28 11:30:00 | AAPL | Stock | 145.098 | 145.32 | 144.93 | 145.1599 | 2434659.0 |
| 2022-11-28 12:00:00 | AAPL | Stock | 145.16 | 145.7556 | 144.74 | 145.18 | 3278741.0 |
| 2022-11-28 12:30:00 | AAPL | Stock | 145.175 | 145.4299 | 144.78 | 144.8292 | 2056742.0 |
| 2022-11-28 13:00:00 | AAPL | Stock | 144.82 | 145.0801 | 144.7 | 144.917 | 2296693.0 |
| 2022-11-28 13:30:00 | AAPL | Stock | 144.91 | 144.95 | 143.93 | 143.967 | 3253855.0 |
| 2022-11-28 14:00:00 | AAPL | Stock | 143.965 | 144.03 | 143.38 | 143.54 | 3291245.0 |
| 2022-11-28 14:30:00 | AAPL | Stock | 143.545 | 144.0823 | 143.485 | 143.94 | 2995129.0 |
| 2022-11-28 15:00:00 | AAPL | Stock | 143.94 | 144.02 | 143.64 | 143.8001 | 3205354.0 |
| 2022-11-28 15:30:00 | AAPL | Stock | 143.81 | 144.46 | 143.65 | 144.22 | 6651864.0 |
| 2022-11-28 16:00:00 | AAPL | Stock | 144.23 | 144.55 | 144.17 | 144.49 | 9242650.0 |
| 2022-11-28 16:30:00 | AAPL | Stock | 144.47 | 144.68 | 144.22 | 144.5 | 99445.0 |
| 2022-11-28 17:00:00 | AAPL | Stock | 144.48 | 144.48 | 144.33 | 144.41 | 33440.0 |
| 2022-11-28 17:30:00 | AAPL | Stock | 144.4 | 144.42 | 144.22 | 144.3699 | 194160.0 |
| 2022-11-28 18:00:00 | AAPL | Stock | 144.36 | 144.42 | 144.32 | 144.34 | 10985.0 |
| 2022-11-28 18:30:00 | AAPL | Stock | 144.35 | 144.39 | 144.25 | 144.25 | 25527.0 |
| 2022-11-28 19:00:00 | AAPL | Stock | 144.23 | 144.37 | 144.23 | 144.28 | 16875.0 |
| 2022-11-28 19:30:00 | AAPL | Stock | 144.3 | 144.5 | 144.3 | 144.48 | 33011.0 |
| 2022-11-28 04:00:00 | MSFT | Stock | 246.98 | 246.98 | 245.86 | 245.86 | 3981.0 |
| 2022-11-28 04:30:00 | MSFT | Stock | 246.05 | 246.05 | 245.43 | 245.43 | 1653.0 |
| 2022-11-28 05:00:00 | MSFT | Stock | 245.21 | 245.3 | 245.21 | 245.3 | 1222.0 |
| 2022-11-28 05:30:00 | MSFT | Stock | 245.8 | 245.8 | 245.62 | 245.75 | 1430.0 |
| 2022-11-28 06:00:00 | MSFT | Stock | 245.88 | 245.93 | 245.88 | 245.9 | 1457.0 |
| 2022-11-28 06:30:00 | MSFT | Stock | 245.89 | 245.95 | 245.78 | 245.94 | 1714.0 |
| 2022-11-28 07:00:00 | MSFT | Stock | 246.14 | 246.31 | 245.94 | 246.1 | 2593.0 |
| 2022-11-28 07:30:00 | MSFT | Stock | 246.0 | 246.0 | 245.92 | 245.95 | 3353.0 |
| 2022-11-28 08:00:00 | MSFT | Stock | 246.0001 | 246.32 | 245.52 | 245.9 | 18568.0 |
| 2022-11-28 08:30:00 | MSFT | Stock | 246.0 | 246.6 | 245.9 | 246.4 | 29401.0 |
| 2022-11-28 09:00:00 | MSFT | Stock | 246.29 | 246.29 | 245.7406 | 246.07 | 12956.0 |
| 2022-11-28 09:30:00 | MSFT | Stock | 246.07 | 246.65 | 244.65 | 244.91 | 1852306.0 |
| 2022-11-28 10:00:00 | MSFT | Stock | 244.9 | 245.205 | 242.64 | 243.05 | 1272314.0 |
| 2022-11-28 10:30:00 | MSFT | Stock | 243.04 | 243.6 | 242.72 | 242.99 | 934100.0 |
| 2022-11-28 11:00:00 | MSFT | Stock | 242.99 | 243.34 | 242.33 | 242.925 | 982106.0 |
| 2022-11-28 11:30:00 | MSFT | Stock | 242.92 | 243.31 | 242.5711 | 243.11 | 695182.0 |
| 2022-11-28 12:00:00 | MSFT | Stock | 243.11 | 243.7 | 242.1 | 242.8 | 1017602.0 |
| 2022-11-28 12:30:00 | MSFT | Stock | 242.81 | 243.34 | 241.98 | 242.035 | 954192.0 |
> showing 50 of 102,092 rows — these rows as CSV