PREVIEW / stock_30min / 2024-02-08
file: by_date/stock_30min/2024/2024-02-08.parquet size: 2.1 MB rows: 99,043 symbols: 1,148
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-08 04:00:00 | AAPL | Stock | 189.41 | 189.5 | 189.41 | 189.42 | 3112.0 |
| 2024-02-08 04:30:00 | AAPL | Stock | 189.43 | 189.45 | 189.39 | 189.45 | 1319.0 |
| 2024-02-08 05:00:00 | AAPL | Stock | 189.5 | 189.6 | 189.5 | 189.6 | 2589.0 |
| 2024-02-08 05:30:00 | AAPL | Stock | 189.61 | 189.61 | 189.55 | 189.57 | 1683.0 |
| 2024-02-08 06:00:00 | AAPL | Stock | 189.59 | 189.59 | 189.5 | 189.5 | 3300.0 |
| 2024-02-08 06:30:00 | AAPL | Stock | 189.47 | 189.51 | 189.33 | 189.41 | 2378.0 |
| 2024-02-08 07:00:00 | AAPL | Stock | 189.28 | 189.3 | 189.02 | 189.26 | 9293.0 |
| 2024-02-08 07:30:00 | AAPL | Stock | 189.28 | 189.31 | 189.15 | 189.17 | 1991.0 |
| 2024-02-08 08:00:00 | AAPL | Stock | 189.2 | 189.64 | 189.02 | 189.13 | 28134.0 |
| 2024-02-08 08:30:00 | AAPL | Stock | 189.1 | 189.41 | 189.0723 | 189.39 | 18257.0 |
| 2024-02-08 09:00:00 | AAPL | Stock | 189.39 | 189.41 | 189.16 | 189.29 | 65482.0 |
| 2024-02-08 09:30:00 | AAPL | Stock | 189.35 | 189.535 | 188.7 | 188.95 | 4099301.0 |
| 2024-02-08 10:00:00 | AAPL | Stock | 188.95 | 188.96 | 187.77 | 187.7964 | 3442506.0 |
| 2024-02-08 10:30:00 | AAPL | Stock | 187.8 | 188.12 | 187.35 | 188.115 | 2995653.0 |
| 2024-02-08 11:00:00 | AAPL | Stock | 188.11 | 188.22 | 187.8301 | 188.005 | 1974811.0 |
| 2024-02-08 11:30:00 | AAPL | Stock | 187.9907 | 188.41 | 187.935 | 188.4 | 1654102.0 |
| 2024-02-08 12:00:00 | AAPL | Stock | 188.4 | 188.7199 | 188.22 | 188.7 | 1378184.0 |
| 2024-02-08 12:30:00 | AAPL | Stock | 188.709 | 188.75 | 188.06 | 188.085 | 1300103.0 |
| 2024-02-08 13:00:00 | AAPL | Stock | 188.085 | 188.36 | 188.0 | 188.23 | 1490068.0 |
| 2024-02-08 13:30:00 | AAPL | Stock | 188.23 | 188.35 | 188.07 | 188.14 | 1121028.0 |
| 2024-02-08 14:00:00 | AAPL | Stock | 188.15 | 188.3 | 187.99 | 188.02 | 1380457.0 |
| 2024-02-08 14:30:00 | AAPL | Stock | 188.015 | 188.22 | 187.99 | 188.1799 | 1098023.0 |
| 2024-02-08 15:00:00 | AAPL | Stock | 188.1768 | 188.445 | 188.135 | 188.34 | 1474685.0 |
| 2024-02-08 15:30:00 | AAPL | Stock | 188.355 | 188.42 | 188.07 | 188.34 | 3698624.0 |
| 2024-02-08 16:00:00 | AAPL | Stock | 188.25 | 188.32 | 188.14 | 188.14 | 4823013.0 |
| 2024-02-08 16:30:00 | AAPL | Stock | 188.15 | 188.2 | 188.13 | 188.2 | 11383.0 |
| 2024-02-08 17:00:00 | AAPL | Stock | 188.2 | 188.2 | 188.12 | 188.19 | 12751.0 |
| 2024-02-08 17:30:00 | AAPL | Stock | 188.2 | 188.32 | 188.13 | 188.15 | 28411.0 |
| 2024-02-08 18:00:00 | AAPL | Stock | 188.13 | 188.1913 | 188.13 | 188.17 | 2856.0 |
| 2024-02-08 18:30:00 | AAPL | Stock | 188.17 | 188.24 | 188.15 | 188.2 | 3594.0 |
| 2024-02-08 19:00:00 | AAPL | Stock | 188.23 | 188.29 | 188.15 | 188.2 | 10012.0 |
| 2024-02-08 19:30:00 | AAPL | Stock | 188.15 | 188.2 | 188.15 | 188.2 | 8251.0 |
| 2024-02-08 04:00:00 | MSFT | Stock | 414.13 | 414.43 | 413.95 | 414.2 | 2362.0 |
| 2024-02-08 04:30:00 | MSFT | Stock | 414.08 | 414.09 | 413.31 | 413.31 | 2762.0 |
| 2024-02-08 05:00:00 | MSFT | Stock | 413.25 | 413.35 | 412.93 | 412.93 | 985.0 |
| 2024-02-08 05:30:00 | MSFT | Stock | 412.61 | 412.61 | 411.88 | 412.2 | 2878.0 |
| 2024-02-08 06:00:00 | MSFT | Stock | 412.39 | 412.71 | 412.39 | 412.48 | 4270.0 |
| 2024-02-08 06:30:00 | MSFT | Stock | 412.75 | 412.87 | 412.67 | 412.67 | 1149.0 |
| 2024-02-08 07:00:00 | MSFT | Stock | 412.77 | 413.29 | 412.77 | 412.99 | 9302.0 |
| 2024-02-08 07:30:00 | MSFT | Stock | 413.09 | 415.0 | 412.85 | 412.85 | 5319.0 |
| 2024-02-08 08:00:00 | MSFT | Stock | 412.92 | 415.79 | 412.5219 | 412.9999 | 42011.0 |
| 2024-02-08 08:30:00 | MSFT | Stock | 412.7 | 414.05 | 412.6 | 413.21 | 22117.0 |
| 2024-02-08 09:00:00 | MSFT | Stock | 413.12 | 414.1 | 413.12 | 414.05 | 23147.0 |
| 2024-02-08 09:30:00 | MSFT | Stock | 414.09 | 415.56 | 413.34 | 413.96 | 1977309.0 |
| 2024-02-08 10:00:00 | MSFT | Stock | 413.99 | 414.41 | 413.1 | 413.675 | 645635.0 |
| 2024-02-08 10:30:00 | MSFT | Stock | 413.7 | 414.9 | 413.45 | 414.559 | 559435.0 |
| 2024-02-08 11:00:00 | MSFT | Stock | 414.54 | 414.57 | 412.61 | 412.7001 | 768709.0 |
| 2024-02-08 11:30:00 | MSFT | Stock | 412.68 | 413.46 | 412.65 | 413.38 | 514667.0 |
| 2024-02-08 12:00:00 | MSFT | Stock | 413.37 | 413.45 | 412.84 | 413.21 | 385194.0 |
| 2024-02-08 12:30:00 | MSFT | Stock | 413.2 | 413.3 | 412.76 | 413.285 | 330446.0 |
> showing 50 of 99,043 rows — these rows as CSV