PREVIEW / stock_30min / 2024-10-22
file: by_date/stock_30min/2024/2024-10-22.parquet size: 2.1 MB rows: 100,795 symbols: 734
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-10-22 04:00:00 | AAPL | Stock | 235.61 | 235.97 | 235.41 | 235.8 | 7245.0 |
| 2024-10-22 04:30:00 | AAPL | Stock | 235.74 | 235.81 | 235.61 | 235.61 | 2785.0 |
| 2024-10-22 05:00:00 | AAPL | Stock | 235.6 | 235.61 | 235.06 | 235.2 | 7633.0 |
| 2024-10-22 05:30:00 | AAPL | Stock | 235.28 | 235.37 | 234.88 | 234.91 | 12387.0 |
| 2024-10-22 06:00:00 | AAPL | Stock | 234.88 | 235.09 | 234.83 | 235.0 | 8059.0 |
| 2024-10-22 06:30:00 | AAPL | Stock | 234.99 | 235.0 | 234.86 | 234.89 | 2399.0 |
| 2024-10-22 07:00:00 | AAPL | Stock | 234.96 | 235.39 | 234.96 | 235.35 | 27175.0 |
| 2024-10-22 07:30:00 | AAPL | Stock | 235.29 | 235.29 | 234.86 | 234.9 | 24517.0 |
| 2024-10-22 08:00:00 | AAPL | Stock | 235.1 | 236.01 | 234.34 | 234.5372 | 119870.0 |
| 2024-10-22 08:30:00 | AAPL | Stock | 234.5 | 234.51 | 233.7 | 234.1801 | 135693.0 |
| 2024-10-22 09:00:00 | AAPL | Stock | 234.2001 | 234.24 | 233.4 | 233.85 | 134002.0 |
| 2024-10-22 09:30:00 | AAPL | Stock | 233.88 | 234.2 | 232.6 | 233.16 | 4395871.0 |
| 2024-10-22 10:00:00 | AAPL | Stock | 233.1646 | 234.153 | 233.0 | 233.91 | 2035536.0 |
| 2024-10-22 10:30:00 | AAPL | Stock | 233.905 | 234.29 | 233.47 | 234.225 | 1362529.0 |
| 2024-10-22 11:00:00 | AAPL | Stock | 234.23 | 234.45 | 233.95 | 234.3995 | 879040.0 |
| 2024-10-22 11:30:00 | AAPL | Stock | 234.4007 | 234.9099 | 234.35 | 234.4903 | 1005946.0 |
| 2024-10-22 12:00:00 | AAPL | Stock | 234.495 | 234.65 | 234.13 | 234.17 | 656559.0 |
| 2024-10-22 12:30:00 | AAPL | Stock | 234.19 | 234.94 | 234.15 | 234.94 | 786968.0 |
| 2024-10-22 13:00:00 | AAPL | Stock | 234.935 | 235.08 | 234.74 | 234.85 | 1075827.0 |
| 2024-10-22 13:30:00 | AAPL | Stock | 234.85 | 235.7499 | 234.845 | 235.68 | 1151525.0 |
| 2024-10-22 14:00:00 | AAPL | Stock | 235.675 | 236.01 | 235.21 | 235.3132 | 1080011.0 |
| 2024-10-22 14:30:00 | AAPL | Stock | 235.32 | 235.57 | 235.18 | 235.37 | 657222.0 |
| 2024-10-22 15:00:00 | AAPL | Stock | 235.37 | 235.74 | 235.26 | 235.7 | 731398.0 |
| 2024-10-22 15:30:00 | AAPL | Stock | 235.7 | 236.22 | 235.7 | 235.86 | 2144262.0 |
| 2024-10-22 16:00:00 | AAPL | Stock | 235.83 | 236.08 | 235.6 | 236.0 | 6085367.0 |
| 2024-10-22 16:30:00 | AAPL | Stock | 236.01 | 236.05 | 235.86 | 235.89 | 22019.0 |
| 2024-10-22 17:00:00 | AAPL | Stock | 235.9 | 235.95 | 235.86 | 235.91 | 6376.0 |
| 2024-10-22 17:30:00 | AAPL | Stock | 235.9 | 235.9 | 235.6998 | 235.7 | 265901.0 |
| 2024-10-22 18:00:00 | AAPL | Stock | 235.66 | 235.79 | 235.51 | 235.56 | 6703.0 |
| 2024-10-22 18:30:00 | AAPL | Stock | 235.51 | 235.6 | 235.25 | 235.45 | 10343.0 |
| 2024-10-22 19:00:00 | AAPL | Stock | 235.45 | 235.66 | 235.45 | 235.56 | 4644.0 |
| 2024-10-22 19:30:00 | AAPL | Stock | 235.65 | 235.78 | 235.6 | 235.6 | 946.0 |
| 2024-10-22 04:00:00 | MSFT | Stock | 418.0 | 418.3 | 418.0 | 418.2 | 2104.0 |
| 2024-10-22 04:30:00 | MSFT | Stock | 417.83 | 417.83 | 417.59 | 417.67 | 950.0 |
| 2024-10-22 05:00:00 | MSFT | Stock | 417.42 | 417.42 | 416.64 | 416.64 | 614.0 |
| 2024-10-22 05:30:00 | MSFT | Stock | 416.99 | 417.17 | 416.41 | 416.41 | 1039.0 |
| 2024-10-22 06:00:00 | MSFT | Stock | 416.6 | 417.7 | 416.6 | 417.38 | 2871.0 |
| 2024-10-22 06:30:00 | MSFT | Stock | 416.98 | 416.98 | 416.98 | 416.98 | 100.0 |
| 2024-10-22 07:00:00 | MSFT | Stock | 417.25 | 417.94 | 417.25 | 417.77 | 3189.0 |
| 2024-10-22 07:30:00 | MSFT | Stock | 417.9 | 418.78 | 417.3 | 418.15 | 7906.0 |
| 2024-10-22 08:00:00 | MSFT | Stock | 417.99 | 419.33 | 417.2 | 418.46 | 19468.0 |
| 2024-10-22 08:30:00 | MSFT | Stock | 418.7 | 419.0 | 417.53 | 419.0 | 17889.0 |
| 2024-10-22 09:00:00 | MSFT | Stock | 419.0 | 420.1 | 417.5 | 418.35 | 93782.0 |
| 2024-10-22 09:30:00 | MSFT | Stock | 418.47 | 426.64 | 418.04 | 426.33 | 2623011.0 |
| 2024-10-22 10:00:00 | MSFT | Stock | 426.31 | 428.38 | 425.34 | 428.09 | 2043607.0 |
| 2024-10-22 10:30:00 | MSFT | Stock | 428.14 | 429.42 | 426.85 | 427.0475 | 1453755.0 |
| 2024-10-22 11:00:00 | MSFT | Stock | 427.08 | 427.4456 | 426.05 | 426.2 | 716772.0 |
| 2024-10-22 11:30:00 | MSFT | Stock | 426.2 | 427.54 | 426.05 | 426.835 | 414128.0 |
| 2024-10-22 12:00:00 | MSFT | Stock | 426.81 | 427.155 | 425.73 | 425.93 | 382989.0 |
| 2024-10-22 12:30:00 | MSFT | Stock | 425.93 | 427.73 | 425.76 | 427.52 | 444209.0 |
> showing 50 of 100,795 rows — these rows as CSV