PREVIEW / stock_30min / 2024-09-25
file: by_date/stock_30min/2024/2024-09-25.parquet size: 2.1 MB rows: 98,826 symbols: 793
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-09-25 04:00:00 | AAPL | Stock | 226.98 | 226.98 | 225.51 | 226.1 | 17493.0 |
| 2024-09-25 04:30:00 | AAPL | Stock | 226.13 | 226.13 | 225.7 | 225.88 | 10592.0 |
| 2024-09-25 05:00:00 | AAPL | Stock | 225.98 | 225.98 | 225.78 | 225.78 | 5715.0 |
| 2024-09-25 05:30:00 | AAPL | Stock | 226.0 | 226.05 | 225.8 | 225.84 | 9102.0 |
| 2024-09-25 06:00:00 | AAPL | Stock | 225.97 | 226.18 | 225.8 | 225.98 | 26334.0 |
| 2024-09-25 06:30:00 | AAPL | Stock | 226.0 | 226.08 | 224.78 | 225.0 | 41290.0 |
| 2024-09-25 07:00:00 | AAPL | Stock | 225.0 | 225.4 | 224.99 | 225.2 | 52971.0 |
| 2024-09-25 07:30:00 | AAPL | Stock | 225.2 | 225.28 | 225.01 | 225.22 | 27615.0 |
| 2024-09-25 08:00:00 | AAPL | Stock | 225.05 | 227.31 | 224.85 | 225.18 | 118210.0 |
| 2024-09-25 08:30:00 | AAPL | Stock | 225.38 | 225.45 | 225.1 | 225.1 | 52076.0 |
| 2024-09-25 09:00:00 | AAPL | Stock | 225.17 | 225.75 | 224.85 | 225.01 | 198226.0 |
| 2024-09-25 09:30:00 | AAPL | Stock | 225.01 | 226.97 | 224.61 | 226.89 | 4014285.0 |
| 2024-09-25 10:00:00 | AAPL | Stock | 226.895 | 227.29 | 226.12 | 226.385 | 1937986.0 |
| 2024-09-25 10:30:00 | AAPL | Stock | 226.38 | 226.7999 | 226.2 | 226.371 | 1339230.0 |
| 2024-09-25 11:00:00 | AAPL | Stock | 226.3799 | 226.65 | 225.3 | 225.43 | 1482499.0 |
| 2024-09-25 11:30:00 | AAPL | Stock | 225.41 | 225.91 | 225.32 | 225.51 | 1181727.0 |
| 2024-09-25 12:00:00 | AAPL | Stock | 225.53 | 225.99 | 225.39 | 225.8701 | 858152.0 |
| 2024-09-25 12:30:00 | AAPL | Stock | 225.86 | 226.02 | 225.54 | 225.7999 | 692594.0 |
| 2024-09-25 13:00:00 | AAPL | Stock | 225.8 | 225.8817 | 225.27 | 225.36 | 1044567.0 |
| 2024-09-25 13:30:00 | AAPL | Stock | 225.35 | 225.4517 | 224.82 | 224.96 | 1406364.0 |
| 2024-09-25 14:00:00 | AAPL | Stock | 224.965 | 225.09 | 224.02 | 224.9 | 2245031.0 |
| 2024-09-25 14:30:00 | AAPL | Stock | 224.89 | 225.1 | 224.73 | 224.9355 | 1035628.0 |
| 2024-09-25 15:00:00 | AAPL | Stock | 224.93 | 225.32 | 224.91 | 225.2599 | 997963.0 |
| 2024-09-25 15:30:00 | AAPL | Stock | 225.25 | 226.45 | 225.19 | 226.31 | 3131855.0 |
| 2024-09-25 16:00:00 | AAPL | Stock | 226.37 | 226.4 | 224.8013 | 226.1 | 9528657.0 |
| 2024-09-25 16:30:00 | AAPL | Stock | 226.11 | 226.37 | 225.78 | 226.03 | 143188.0 |
| 2024-09-25 17:00:00 | AAPL | Stock | 226.03 | 226.1947 | 225.8325 | 226.1947 | 24410.0 |
| 2024-09-25 17:30:00 | AAPL | Stock | 226.0765 | 226.1725 | 226.03 | 226.11 | 9889.0 |
| 2024-09-25 18:00:00 | AAPL | Stock | 226.03 | 226.03 | 225.8259 | 225.86 | 21218.0 |
| 2024-09-25 18:30:00 | AAPL | Stock | 225.82 | 225.973 | 225.82 | 225.95 | 10285.0 |
| 2024-09-25 19:00:00 | AAPL | Stock | 225.94 | 225.99 | 225.71 | 225.85 | 5476.0 |
| 2024-09-25 19:30:00 | AAPL | Stock | 225.87 | 226.15 | 225.425 | 226.15 | 12691.0 |
| 2024-09-25 04:00:00 | MSFT | Stock | 429.21 | 429.8 | 429.19 | 429.35 | 1972.0 |
| 2024-09-25 04:30:00 | MSFT | Stock | 429.18 | 429.18 | 429.18 | 429.18 | 115.0 |
| 2024-09-25 05:30:00 | MSFT | Stock | 429.14 | 429.3 | 429.14 | 429.24 | 864.0 |
| 2024-09-25 06:00:00 | MSFT | Stock | 429.4 | 429.5 | 429.4 | 429.5 | 851.0 |
| 2024-09-25 06:30:00 | MSFT | Stock | 429.52 | 429.52 | 429.48 | 429.48 | 300.0 |
| 2024-09-25 07:00:00 | MSFT | Stock | 429.95 | 430.0 | 429.71 | 429.8 | 1254.0 |
| 2024-09-25 07:30:00 | MSFT | Stock | 429.55 | 429.61 | 429.55 | 429.61 | 1356.0 |
| 2024-09-25 08:00:00 | MSFT | Stock | 429.88 | 429.9992 | 429.25 | 429.5 | 6293.0 |
| 2024-09-25 08:30:00 | MSFT | Stock | 429.65 | 430.35 | 429.65 | 430.0 | 8083.0 |
| 2024-09-25 09:00:00 | MSFT | Stock | 429.92 | 430.5115 | 429.29 | 429.9 | 22088.0 |
| 2024-09-25 09:30:00 | MSFT | Stock | 430.0 | 431.68 | 428.57 | 430.4 | 1136558.0 |
| 2024-09-25 10:00:00 | MSFT | Stock | 430.305 | 431.32 | 430.3 | 430.52 | 590101.0 |
| 2024-09-25 10:30:00 | MSFT | Stock | 430.41 | 431.66 | 430.1818 | 431.47 | 504212.0 |
| 2024-09-25 11:00:00 | MSFT | Stock | 431.415 | 431.725 | 430.86 | 431.72 | 249610.0 |
| 2024-09-25 11:30:00 | MSFT | Stock | 431.71 | 433.119 | 431.5036 | 431.735 | 580200.0 |
| 2024-09-25 12:00:00 | MSFT | Stock | 431.735 | 431.93 | 431.18 | 431.9 | 252235.0 |
| 2024-09-25 12:30:00 | MSFT | Stock | 431.89 | 432.22 | 431.46 | 431.8 | 195263.0 |
| 2024-09-25 13:00:00 | MSFT | Stock | 431.84 | 432.3 | 430.71 | 432.15 | 264804.0 |
> showing 50 of 98,826 rows — these rows as CSV