PREVIEW / stock_30min / 2023-02-15
file: by_date/stock_30min/2023/2023-02-15.parquet size: 2.1 MB rows: 102,204 symbols: 1,868
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 |
|---|---|---|---|---|---|---|---|
| 2023-02-15 04:00:00 | AAPL | Stock | 152.8 | 152.91 | 152.36 | 152.5 | 17932.0 |
| 2023-02-15 04:30:00 | AAPL | Stock | 152.51 | 152.63 | 152.5 | 152.51 | 3238.0 |
| 2023-02-15 05:00:00 | AAPL | Stock | 152.51 | 152.55 | 152.44 | 152.51 | 2219.0 |
| 2023-02-15 05:30:00 | AAPL | Stock | 152.49 | 152.66 | 152.49 | 152.65 | 1601.0 |
| 2023-02-15 06:00:00 | AAPL | Stock | 152.66 | 152.76 | 152.54 | 152.75 | 3728.0 |
| 2023-02-15 06:30:00 | AAPL | Stock | 152.69 | 152.76 | 152.62 | 152.72 | 6101.0 |
| 2023-02-15 07:00:00 | AAPL | Stock | 152.7 | 153.15 | 152.69 | 153.04 | 31478.0 |
| 2023-02-15 07:30:00 | AAPL | Stock | 153.09 | 153.15 | 152.71 | 152.87 | 32301.0 |
| 2023-02-15 08:00:00 | AAPL | Stock | 152.75 | 153.15 | 151.7 | 152.66 | 101037.0 |
| 2023-02-15 08:30:00 | AAPL | Stock | 152.6 | 153.4 | 151.9992 | 152.96 | 203294.0 |
| 2023-02-15 09:00:00 | AAPL | Stock | 152.99 | 153.12 | 152.34 | 153.12 | 144658.0 |
| 2023-02-15 09:30:00 | AAPL | Stock | 153.11 | 154.52 | 152.88 | 153.5663 | 7373556.0 |
| 2023-02-15 10:00:00 | AAPL | Stock | 153.57 | 153.975 | 153.05 | 153.72 | 4259517.0 |
| 2023-02-15 10:30:00 | AAPL | Stock | 153.73 | 154.4 | 153.57 | 153.8299 | 3952620.0 |
| 2023-02-15 11:00:00 | AAPL | Stock | 153.82 | 154.71 | 153.81 | 154.645 | 3215103.0 |
| 2023-02-15 11:30:00 | AAPL | Stock | 154.645 | 155.5 | 154.36 | 155.25 | 4957905.0 |
| 2023-02-15 12:00:00 | AAPL | Stock | 155.26 | 155.3975 | 154.57 | 154.65 | 2497462.0 |
| 2023-02-15 12:30:00 | AAPL | Stock | 154.6502 | 154.98 | 153.5 | 154.07 | 4729812.0 |
| 2023-02-15 13:00:00 | AAPL | Stock | 154.09 | 154.4 | 153.715 | 154.375 | 2345556.0 |
| 2023-02-15 13:30:00 | AAPL | Stock | 154.38 | 155.05 | 154.15 | 155.01 | 2672878.0 |
| 2023-02-15 14:00:00 | AAPL | Stock | 155.01 | 155.3255 | 154.9 | 155.2321 | 2174249.0 |
| 2023-02-15 14:30:00 | AAPL | Stock | 155.24 | 155.47 | 154.92 | 155.02 | 2153780.0 |
| 2023-02-15 15:00:00 | AAPL | Stock | 155.02 | 155.28 | 154.7217 | 154.8499 | 2211937.0 |
| 2023-02-15 15:30:00 | AAPL | Stock | 154.85 | 155.38 | 154.67 | 155.36 | 4445342.0 |
| 2023-02-15 16:00:00 | AAPL | Stock | 155.36 | 155.45 | 155.08 | 155.35 | 5573788.0 |
| 2023-02-15 16:30:00 | AAPL | Stock | 155.33 | 155.38 | 155.28 | 155.3 | 40910.0 |
| 2023-02-15 17:00:00 | AAPL | Stock | 155.29 | 155.31 | 155.2404 | 155.28 | 13902.0 |
| 2023-02-15 17:30:00 | AAPL | Stock | 155.27 | 155.33 | 155.26 | 155.29 | 22769.0 |
| 2023-02-15 18:00:00 | AAPL | Stock | 155.26 | 155.32 | 155.26 | 155.32 | 15510.0 |
| 2023-02-15 18:30:00 | AAPL | Stock | 155.33 | 155.39 | 155.32 | 155.33 | 12074.0 |
| 2023-02-15 19:00:00 | AAPL | Stock | 155.31 | 155.5 | 155.3 | 155.47 | 21341.0 |
| 2023-02-15 19:30:00 | AAPL | Stock | 155.46 | 155.51 | 155.4 | 155.48 | 29524.0 |
| 2023-02-15 04:00:00 | MSFT | Stock | 271.21 | 271.47 | 270.5 | 270.91 | 5697.0 |
| 2023-02-15 04:30:00 | MSFT | Stock | 270.85 | 271.52 | 270.72 | 270.8 | 11362.0 |
| 2023-02-15 05:00:00 | MSFT | Stock | 270.53 | 270.74 | 270.4 | 270.61 | 1289.0 |
| 2023-02-15 05:30:00 | MSFT | Stock | 270.6 | 271.3 | 270.6 | 271.2 | 1401.0 |
| 2023-02-15 06:00:00 | MSFT | Stock | 271.1 | 271.15 | 270.75 | 271.15 | 750.0 |
| 2023-02-15 06:30:00 | MSFT | Stock | 271.24 | 271.24 | 270.66 | 270.67 | 1332.0 |
| 2023-02-15 07:00:00 | MSFT | Stock | 271.0 | 271.96 | 270.84 | 271.55 | 14348.0 |
| 2023-02-15 07:30:00 | MSFT | Stock | 271.51 | 271.7 | 270.95 | 271.21 | 8518.0 |
| 2023-02-15 08:00:00 | MSFT | Stock | 270.98 | 272.17 | 270.0 | 270.8 | 60837.0 |
| 2023-02-15 08:30:00 | MSFT | Stock | 270.71 | 271.85 | 269.8 | 270.9104 | 57481.0 |
| 2023-02-15 09:00:00 | MSFT | Stock | 271.11 | 271.11 | 268.18 | 268.35 | 90987.0 |
| 2023-02-15 09:30:00 | MSFT | Stock | 268.31 | 270.73 | 268.22 | 269.285 | 2770733.0 |
| 2023-02-15 10:00:00 | MSFT | Stock | 269.3 | 269.8899 | 267.84 | 267.96 | 1657680.0 |
| 2023-02-15 10:30:00 | MSFT | Stock | 268.0099 | 268.63 | 266.53 | 266.7033 | 1699424.0 |
| 2023-02-15 11:00:00 | MSFT | Stock | 266.67 | 268.06 | 266.64 | 267.96 | 998050.0 |
| 2023-02-15 11:30:00 | MSFT | Stock | 267.98 | 268.24 | 266.65 | 266.745 | 1172061.0 |
| 2023-02-15 12:00:00 | MSFT | Stock | 266.745 | 267.65 | 266.18 | 267.4 | 1161973.0 |
| 2023-02-15 12:30:00 | MSFT | Stock | 267.43 | 268.14 | 267.34 | 267.515 | 650985.0 |
> showing 50 of 102,204 rows — these rows as CSV