PREVIEW / stock_30min / 2024-10-25
file: by_date/stock_30min/2024/2024-10-25.parquet size: 2.1 MB rows: 99,741 symbols: 738
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-25 04:00:00 | AAPL | Stock | 229.13 | 229.13 | 227.3 | 227.98 | 79389.0 |
| 2024-10-25 04:30:00 | AAPL | Stock | 228.01 | 228.42 | 228.0 | 228.05 | 14957.0 |
| 2024-10-25 05:00:00 | AAPL | Stock | 228.18 | 228.75 | 228.18 | 228.75 | 6316.0 |
| 2024-10-25 05:30:00 | AAPL | Stock | 228.79 | 228.94 | 228.5 | 228.61 | 15471.0 |
| 2024-10-25 06:00:00 | AAPL | Stock | 228.64 | 228.84 | 228.6 | 228.77 | 6545.0 |
| 2024-10-25 06:30:00 | AAPL | Stock | 228.71 | 228.72 | 228.35 | 228.45 | 9485.0 |
| 2024-10-25 07:00:00 | AAPL | Stock | 228.4 | 228.5 | 228.01 | 228.4 | 44124.0 |
| 2024-10-25 07:30:00 | AAPL | Stock | 228.4 | 228.88 | 228.4 | 228.68 | 20721.0 |
| 2024-10-25 08:00:00 | AAPL | Stock | 228.25 | 229.6 | 228.1 | 229.1 | 140406.0 |
| 2024-10-25 08:30:00 | AAPL | Stock | 229.22 | 229.85 | 229.14 | 229.76 | 77012.0 |
| 2024-10-25 09:00:00 | AAPL | Stock | 229.74 | 229.97 | 229.33 | 229.74 | 124053.0 |
| 2024-10-25 09:30:00 | AAPL | Stock | 229.74 | 232.09 | 229.57 | 231.9 | 3938438.0 |
| 2024-10-25 10:00:00 | AAPL | Stock | 231.96 | 232.4299 | 231.7202 | 232.13 | 1831686.0 |
| 2024-10-25 10:30:00 | AAPL | Stock | 232.12 | 232.91 | 232.12 | 232.8446 | 1445977.0 |
| 2024-10-25 11:00:00 | AAPL | Stock | 232.86 | 233.22 | 232.16 | 232.23 | 1486198.0 |
| 2024-10-25 11:30:00 | AAPL | Stock | 232.23 | 232.45 | 231.76 | 232.05 | 1204223.0 |
| 2024-10-25 12:00:00 | AAPL | Stock | 232.03 | 232.735 | 231.9429 | 232.71 | 954066.0 |
| 2024-10-25 12:30:00 | AAPL | Stock | 232.73 | 232.95 | 232.46 | 232.775 | 809728.0 |
| 2024-10-25 13:00:00 | AAPL | Stock | 232.775 | 232.775 | 231.53 | 231.8575 | 873265.0 |
| 2024-10-25 13:30:00 | AAPL | Stock | 231.83 | 231.9715 | 231.13 | 231.48 | 1151517.0 |
| 2024-10-25 14:00:00 | AAPL | Stock | 231.49 | 231.94 | 231.07 | 231.84 | 997297.0 |
| 2024-10-25 14:30:00 | AAPL | Stock | 231.8469 | 232.2 | 231.66 | 232.14 | 777250.0 |
| 2024-10-25 15:00:00 | AAPL | Stock | 232.12 | 232.16 | 231.37 | 231.62 | 934752.0 |
| 2024-10-25 15:30:00 | AAPL | Stock | 231.63 | 231.88 | 231.11 | 231.41 | 2901411.0 |
| 2024-10-25 16:00:00 | AAPL | Stock | 231.13 | 232.0 | 231.13 | 231.31 | 9062183.0 |
| 2024-10-25 16:30:00 | AAPL | Stock | 231.31 | 231.31 | 231.25 | 231.31 | 16774.0 |
| 2024-10-25 17:00:00 | AAPL | Stock | 231.31 | 231.41 | 231.23 | 231.25 | 45537.0 |
| 2024-10-25 17:30:00 | AAPL | Stock | 231.4 | 231.6 | 231.32 | 231.49 | 23906.0 |
| 2024-10-25 18:00:00 | AAPL | Stock | 231.57 | 231.57 | 231.24 | 231.28 | 2914.0 |
| 2024-10-25 18:30:00 | AAPL | Stock | 231.22 | 231.4 | 231.22 | 231.25 | 2100.0 |
| 2024-10-25 19:00:00 | AAPL | Stock | 231.3 | 231.39 | 231.1065 | 231.2 | 5797.0 |
| 2024-10-25 19:30:00 | AAPL | Stock | 231.0301 | 231.0301 | 230.8 | 230.86 | 5734.0 |
| 2024-10-25 04:00:00 | MSFT | Stock | 425.25 | 426.38 | 425.25 | 426.18 | 2520.0 |
| 2024-10-25 04:30:00 | MSFT | Stock | 426.15 | 426.5 | 426.13 | 426.5 | 1592.0 |
| 2024-10-25 05:00:00 | MSFT | Stock | 426.99 | 427.2 | 426.86 | 426.86 | 3231.0 |
| 2024-10-25 05:30:00 | MSFT | Stock | 426.9 | 427.08 | 426.9 | 427.08 | 1903.0 |
| 2024-10-25 06:00:00 | MSFT | Stock | 426.9 | 426.92 | 426.9 | 426.9 | 576.0 |
| 2024-10-25 06:30:00 | MSFT | Stock | 427.0 | 427.0 | 426.9 | 426.9 | 400.0 |
| 2024-10-25 07:00:00 | MSFT | Stock | 426.82 | 426.9 | 426.11 | 426.23 | 5115.0 |
| 2024-10-25 07:30:00 | MSFT | Stock | 426.45 | 426.68 | 426.34 | 426.5 | 1712.0 |
| 2024-10-25 08:00:00 | MSFT | Stock | 426.66 | 426.96 | 424.94 | 426.35 | 19705.0 |
| 2024-10-25 08:30:00 | MSFT | Stock | 426.5 | 426.98 | 426.2806 | 426.98 | 6139.0 |
| 2024-10-25 09:00:00 | MSFT | Stock | 426.98 | 427.8 | 426.19 | 426.4 | 44765.0 |
| 2024-10-25 09:30:00 | MSFT | Stock | 426.76 | 432.52 | 426.565 | 431.47 | 1945168.0 |
| 2024-10-25 10:00:00 | MSFT | Stock | 431.5 | 432.1999 | 430.13 | 431.0001 | 800856.0 |
| 2024-10-25 10:30:00 | MSFT | Stock | 431.0 | 431.46 | 430.26 | 430.8218 | 474314.0 |
| 2024-10-25 11:00:00 | MSFT | Stock | 430.92 | 431.81 | 430.5 | 430.795 | 452178.0 |
| 2024-10-25 11:30:00 | MSFT | Stock | 430.819 | 430.97 | 429.4772 | 429.94 | 463421.0 |
| 2024-10-25 12:00:00 | MSFT | Stock | 429.84 | 430.6838 | 429.55 | 430.6838 | 264016.0 |
| 2024-10-25 12:30:00 | MSFT | Stock | 430.68 | 430.785 | 430.09 | 430.41 | 243199.0 |
> showing 50 of 99,741 rows — these rows as CSV