PREVIEW / stock_30min / 2024-07-25
file: by_date/stock_30min/2024/2024-07-25.parquet size: 2.0 MB rows: 98,953 symbols: 882
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-07-25 04:00:00 | AAPL | Stock | 217.4 | 217.4 | 215.94 | 216.64 | 37828.0 |
| 2024-07-25 04:30:00 | AAPL | Stock | 216.68 | 217.16 | 216.36 | 217.14 | 11686.0 |
| 2024-07-25 05:00:00 | AAPL | Stock | 217.1 | 217.7 | 216.3 | 216.72 | 19535.0 |
| 2024-07-25 05:30:00 | AAPL | Stock | 216.92 | 217.05 | 216.36 | 216.46 | 5403.0 |
| 2024-07-25 06:00:00 | AAPL | Stock | 216.5 | 216.69 | 216.1 | 216.34 | 10097.0 |
| 2024-07-25 06:30:00 | AAPL | Stock | 216.35 | 217.3 | 216.25 | 217.2 | 23584.0 |
| 2024-07-25 07:00:00 | AAPL | Stock | 217.06 | 217.76 | 216.85 | 217.0 | 37972.0 |
| 2024-07-25 07:30:00 | AAPL | Stock | 217.05 | 217.25 | 216.85 | 217.0 | 54702.0 |
| 2024-07-25 08:00:00 | AAPL | Stock | 217.24 | 217.7273 | 216.85 | 217.3 | 97196.0 |
| 2024-07-25 08:30:00 | AAPL | Stock | 217.03 | 218.34 | 216.9 | 218.16 | 94294.0 |
| 2024-07-25 09:00:00 | AAPL | Stock | 218.14 | 218.96 | 217.6 | 218.9 | 113731.0 |
| 2024-07-25 09:30:00 | AAPL | Stock | 218.87 | 219.85 | 215.06 | 215.56 | 5630458.0 |
| 2024-07-25 10:00:00 | AAPL | Stock | 215.55 | 216.1499 | 214.62 | 215.81 | 5222745.0 |
| 2024-07-25 10:30:00 | AAPL | Stock | 215.82 | 218.57 | 215.4401 | 218.5599 | 3231474.0 |
| 2024-07-25 11:00:00 | AAPL | Stock | 218.54 | 219.4 | 217.76 | 218.68 | 2605288.0 |
| 2024-07-25 11:30:00 | AAPL | Stock | 218.684 | 219.3549 | 218.11 | 219.3549 | 1796394.0 |
| 2024-07-25 12:00:00 | AAPL | Stock | 219.36 | 220.54 | 218.8085 | 220.192 | 2545205.0 |
| 2024-07-25 12:30:00 | AAPL | Stock | 220.2 | 220.85 | 219.925 | 220.2089 | 1486791.0 |
| 2024-07-25 13:00:00 | AAPL | Stock | 220.2 | 220.78 | 219.27 | 219.42 | 1292917.0 |
| 2024-07-25 13:30:00 | AAPL | Stock | 219.43 | 220.48 | 219.3573 | 220.348 | 1328000.0 |
| 2024-07-25 14:00:00 | AAPL | Stock | 220.35 | 220.43 | 219.54 | 219.88 | 1245344.0 |
| 2024-07-25 14:30:00 | AAPL | Stock | 219.86 | 220.34 | 218.6399 | 218.64 | 1606738.0 |
| 2024-07-25 15:00:00 | AAPL | Stock | 218.62 | 220.42 | 218.617 | 220.125 | 1499909.0 |
| 2024-07-25 15:30:00 | AAPL | Stock | 220.1 | 220.27 | 217.33 | 217.49 | 4574617.0 |
| 2024-07-25 16:00:00 | AAPL | Stock | 217.49 | 217.99 | 217.14 | 217.9133 | 6182511.0 |
| 2024-07-25 16:30:00 | AAPL | Stock | 217.85 | 218.07 | 217.49 | 218.06 | 47347.0 |
| 2024-07-25 17:00:00 | AAPL | Stock | 218.1 | 218.1 | 217.8 | 217.87 | 7497.0 |
| 2024-07-25 17:30:00 | AAPL | Stock | 217.8 | 217.9792 | 217.49 | 217.8501 | 27045.0 |
| 2024-07-25 18:00:00 | AAPL | Stock | 217.85 | 218.5 | 217.8 | 218.0 | 48676.0 |
| 2024-07-25 18:30:00 | AAPL | Stock | 218.06 | 218.1 | 217.7 | 217.7 | 4391.0 |
| 2024-07-25 19:00:00 | AAPL | Stock | 217.7 | 218.0 | 217.7 | 217.9899 | 10355.0 |
| 2024-07-25 19:30:00 | AAPL | Stock | 217.9201 | 218.09 | 217.89 | 217.91 | 18123.0 |
| 2024-07-25 04:00:00 | MSFT | Stock | 428.86 | 429.7 | 425.47 | 426.98 | 8764.0 |
| 2024-07-25 04:30:00 | MSFT | Stock | 427.0 | 427.9 | 427.0 | 427.9 | 1822.0 |
| 2024-07-25 05:00:00 | MSFT | Stock | 428.04 | 428.48 | 427.97 | 427.97 | 314.0 |
| 2024-07-25 05:30:00 | MSFT | Stock | 427.96 | 428.0 | 426.85 | 426.95 | 3877.0 |
| 2024-07-25 06:00:00 | MSFT | Stock | 427.06 | 427.33 | 426.3 | 427.11 | 6569.0 |
| 2024-07-25 06:30:00 | MSFT | Stock | 427.0 | 427.4 | 426.36 | 427.4 | 3641.0 |
| 2024-07-25 07:00:00 | MSFT | Stock | 427.37 | 428.97 | 427.37 | 428.42 | 5921.0 |
| 2024-07-25 07:30:00 | MSFT | Stock | 427.6 | 428.02 | 426.9 | 426.9 | 2926.0 |
| 2024-07-25 08:00:00 | MSFT | Stock | 427.56 | 429.37 | 425.8728 | 426.88 | 28224.0 |
| 2024-07-25 08:30:00 | MSFT | Stock | 427.0 | 430.3 | 426.2 | 430.3 | 22981.0 |
| 2024-07-25 09:00:00 | MSFT | Stock | 430.49 | 430.49 | 428.0 | 428.55 | 20185.0 |
| 2024-07-25 09:30:00 | MSFT | Stock | 428.8 | 429.8 | 421.84 | 422.12 | 2492058.0 |
| 2024-07-25 10:00:00 | MSFT | Stock | 422.02 | 422.52 | 417.51 | 421.145 | 2763938.0 |
| 2024-07-25 10:30:00 | MSFT | Stock | 421.08 | 424.8 | 420.5 | 423.98 | 1596257.0 |
| 2024-07-25 11:00:00 | MSFT | Stock | 423.99 | 425.39 | 423.2 | 423.77 | 1124633.0 |
| 2024-07-25 11:30:00 | MSFT | Stock | 423.75 | 423.78 | 420.98 | 422.9 | 844664.0 |
| 2024-07-25 12:00:00 | MSFT | Stock | 422.89 | 425.94 | 422.0 | 425.05 | 908010.0 |
| 2024-07-25 12:30:00 | MSFT | Stock | 425.07 | 426.085 | 424.355 | 425.61 | 556126.0 |
> showing 50 of 98,953 rows — these rows as CSV