PREVIEW / stock_30min / 2024-02-12
file: by_date/stock_30min/2024/2024-02-12.parquet size: 2.1 MB rows: 101,131 symbols: 1,151
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 |
|---|---|---|---|---|---|---|---|
| 2024-02-12 04:00:00 | AAPL | Stock | 188.8 | 189.9 | 188.71 | 189.36 | 20751.0 |
| 2024-02-12 04:30:00 | AAPL | Stock | 189.19 | 189.21 | 188.96 | 189.05 | 6551.0 |
| 2024-02-12 05:00:00 | AAPL | Stock | 188.89 | 189.02 | 188.8 | 189.0 | 4153.0 |
| 2024-02-12 05:30:00 | AAPL | Stock | 188.95 | 189.05 | 188.95 | 189.05 | 2906.0 |
| 2024-02-12 06:00:00 | AAPL | Stock | 189.05 | 189.34 | 189.0 | 189.34 | 15829.0 |
| 2024-02-12 06:30:00 | AAPL | Stock | 189.3 | 189.37 | 188.08 | 188.48 | 35273.0 |
| 2024-02-12 07:00:00 | AAPL | Stock | 188.48 | 188.71 | 188.1 | 188.6 | 11023.0 |
| 2024-02-12 07:30:00 | AAPL | Stock | 188.62 | 188.81 | 188.58 | 188.66 | 3886.0 |
| 2024-02-12 08:00:00 | AAPL | Stock | 188.4 | 188.9 | 188.22 | 188.72 | 53018.0 |
| 2024-02-12 08:30:00 | AAPL | Stock | 188.69 | 188.75 | 188.18 | 188.4 | 39900.0 |
| 2024-02-12 09:00:00 | AAPL | Stock | 188.346 | 188.85 | 188.25 | 188.39 | 107976.0 |
| 2024-02-12 09:30:00 | AAPL | Stock | 188.44 | 188.67 | 187.44 | 187.985 | 5029886.0 |
| 2024-02-12 10:00:00 | AAPL | Stock | 187.985 | 187.99 | 187.46 | 187.4686 | 2274138.0 |
| 2024-02-12 10:30:00 | AAPL | Stock | 187.47 | 188.0599 | 187.3801 | 187.79 | 2739626.0 |
| 2024-02-12 11:00:00 | AAPL | Stock | 187.795 | 188.06 | 187.69 | 187.99 | 1387542.0 |
| 2024-02-12 11:30:00 | AAPL | Stock | 187.99 | 188.18 | 187.9 | 188.005 | 1308292.0 |
| 2024-02-12 12:00:00 | AAPL | Stock | 188.015 | 188.1 | 187.7 | 187.865 | 1073768.0 |
| 2024-02-12 12:30:00 | AAPL | Stock | 187.8603 | 188.21 | 187.8602 | 188.16 | 1290045.0 |
| 2024-02-12 13:00:00 | AAPL | Stock | 188.16 | 188.37 | 187.97 | 187.975 | 1230017.0 |
| 2024-02-12 13:30:00 | AAPL | Stock | 187.975 | 188.1097 | 187.55 | 187.99 | 1507390.0 |
| 2024-02-12 14:00:00 | AAPL | Stock | 187.985 | 188.0376 | 187.41 | 187.45 | 1435856.0 |
| 2024-02-12 14:30:00 | AAPL | Stock | 187.445 | 187.5 | 186.92 | 186.99 | 1542842.0 |
| 2024-02-12 15:00:00 | AAPL | Stock | 186.98 | 187.22 | 186.79 | 187.11 | 1524885.0 |
| 2024-02-12 15:30:00 | AAPL | Stock | 187.1089 | 187.45 | 186.88 | 187.18 | 3954924.0 |
| 2024-02-12 16:00:00 | AAPL | Stock | 187.19 | 187.21 | 186.6 | 186.6 | 6499289.0 |
| 2024-02-12 16:30:00 | AAPL | Stock | 186.58 | 187.15 | 186.58 | 187.0 | 73527.0 |
| 2024-02-12 17:00:00 | AAPL | Stock | 187.0 | 187.0 | 186.8001 | 186.81 | 8534.0 |
| 2024-02-12 17:30:00 | AAPL | Stock | 186.82 | 186.88 | 186.74 | 186.7556 | 6543.0 |
| 2024-02-12 18:00:00 | AAPL | Stock | 186.86 | 186.87 | 186.6819 | 186.6819 | 6503.0 |
| 2024-02-12 18:30:00 | AAPL | Stock | 186.79 | 186.92 | 186.66 | 186.92 | 11228.0 |
| 2024-02-12 19:00:00 | AAPL | Stock | 186.92 | 186.99 | 186.7 | 186.7 | 5346.0 |
| 2024-02-12 19:30:00 | AAPL | Stock | 186.7 | 186.75 | 186.6 | 186.68 | 5737.0 |
| 2024-02-12 04:00:00 | MSFT | Stock | 421.0 | 421.02 | 418.75 | 420.23 | 10117.0 |
| 2024-02-12 04:30:00 | MSFT | Stock | 420.37 | 421.33 | 420.37 | 420.72 | 7148.0 |
| 2024-02-12 05:00:00 | MSFT | Stock | 420.99 | 420.99 | 420.69 | 420.71 | 1538.0 |
| 2024-02-12 05:30:00 | MSFT | Stock | 421.26 | 421.26 | 420.0 | 420.05 | 11981.0 |
| 2024-02-12 06:00:00 | MSFT | Stock | 420.61 | 421.0 | 420.61 | 420.83 | 1271.0 |
| 2024-02-12 06:30:00 | MSFT | Stock | 420.8 | 420.8 | 420.69 | 420.69 | 630.0 |
| 2024-02-12 07:00:00 | MSFT | Stock | 420.75 | 421.18 | 420.75 | 421.04 | 4511.0 |
| 2024-02-12 07:30:00 | MSFT | Stock | 420.8 | 421.0 | 420.65 | 420.65 | 2282.0 |
| 2024-02-12 08:00:00 | MSFT | Stock | 421.0 | 421.2099 | 420.52 | 420.79 | 29043.0 |
| 2024-02-12 08:30:00 | MSFT | Stock | 420.79 | 420.79 | 420.08 | 420.31 | 21988.0 |
| 2024-02-12 09:00:00 | MSFT | Stock | 420.12 | 420.65 | 420.01 | 420.51 | 15578.0 |
| 2024-02-12 09:30:00 | MSFT | Stock | 420.46 | 420.74 | 417.12 | 417.13 | 1855125.0 |
| 2024-02-12 10:00:00 | MSFT | Stock | 417.15 | 417.92 | 416.77 | 417.5886 | 1236922.0 |
| 2024-02-12 10:30:00 | MSFT | Stock | 417.6038 | 419.23 | 417.41 | 419.0696 | 764186.0 |
| 2024-02-12 11:00:00 | MSFT | Stock | 419.0576 | 419.25 | 418.03 | 418.794 | 555691.0 |
| 2024-02-12 11:30:00 | MSFT | Stock | 418.8058 | 419.69 | 418.71 | 419.176 | 463164.0 |
| 2024-02-12 12:00:00 | MSFT | Stock | 419.2 | 419.36 | 418.27 | 418.635 | 375675.0 |
| 2024-02-12 12:30:00 | MSFT | Stock | 418.635 | 419.14 | 418.47 | 419.12 | 274510.0 |
> showing 50 of 101,131 rows — these rows as CSV