PREVIEW / stock_30min / 2024-07-26
file: by_date/stock_30min/2024/2024-07-26.parquet size: 2.0 MB rows: 96,687 symbols: 884
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-26 04:00:00 | AAPL | Stock | 218.9 | 219.35 | 218.81 | 219.28 | 12588.0 |
| 2024-07-26 04:30:00 | AAPL | Stock | 219.18 | 220.0 | 219.15 | 220.0 | 7814.0 |
| 2024-07-26 05:00:00 | AAPL | Stock | 220.25 | 220.25 | 219.51 | 219.6 | 5053.0 |
| 2024-07-26 05:30:00 | AAPL | Stock | 219.56 | 219.72 | 219.5 | 219.63 | 2080.0 |
| 2024-07-26 06:00:00 | AAPL | Stock | 219.63 | 220.0 | 219.24 | 219.24 | 7224.0 |
| 2024-07-26 06:30:00 | AAPL | Stock | 219.38 | 219.57 | 219.2 | 219.2 | 5549.0 |
| 2024-07-26 07:00:00 | AAPL | Stock | 219.2 | 220.0 | 219.06 | 219.75 | 20987.0 |
| 2024-07-26 07:30:00 | AAPL | Stock | 219.86 | 220.0 | 219.78 | 219.87 | 13995.0 |
| 2024-07-26 08:00:00 | AAPL | Stock | 219.4 | 220.0 | 218.51 | 219.8 | 87358.0 |
| 2024-07-26 08:30:00 | AAPL | Stock | 219.84 | 220.0 | 219.2 | 219.45 | 67824.0 |
| 2024-07-26 09:00:00 | AAPL | Stock | 219.4919 | 219.6 | 218.44 | 218.62 | 63029.0 |
| 2024-07-26 09:30:00 | AAPL | Stock | 218.69 | 219.1499 | 216.28 | 217.68 | 5008611.0 |
| 2024-07-26 10:00:00 | AAPL | Stock | 217.664 | 217.95 | 216.01 | 217.4 | 3043581.0 |
| 2024-07-26 10:30:00 | AAPL | Stock | 217.395 | 217.61 | 216.4559 | 217.515 | 1887874.0 |
| 2024-07-26 11:00:00 | AAPL | Stock | 217.51 | 218.16 | 217.3901 | 217.9554 | 1581686.0 |
| 2024-07-26 11:30:00 | AAPL | Stock | 217.97 | 218.88 | 217.51 | 218.5 | 1910850.0 |
| 2024-07-26 12:00:00 | AAPL | Stock | 218.5 | 219.03 | 218.431 | 218.7 | 1458471.0 |
| 2024-07-26 12:30:00 | AAPL | Stock | 218.71 | 219.49 | 218.71 | 219.26 | 1256357.0 |
| 2024-07-26 13:00:00 | AAPL | Stock | 219.27 | 219.395 | 218.78 | 219.3045 | 1079264.0 |
| 2024-07-26 13:30:00 | AAPL | Stock | 219.305 | 219.33 | 217.68 | 218.0762 | 1635957.0 |
| 2024-07-26 14:00:00 | AAPL | Stock | 218.06 | 218.49 | 217.8 | 218.15 | 1123027.0 |
| 2024-07-26 14:30:00 | AAPL | Stock | 218.16 | 218.47 | 217.56 | 217.7801 | 1150216.0 |
| 2024-07-26 15:00:00 | AAPL | Stock | 217.78 | 218.76 | 217.69 | 218.605 | 1387641.0 |
| 2024-07-26 15:30:00 | AAPL | Stock | 218.605 | 218.62 | 217.13 | 218.1 | 3518521.0 |
| 2024-07-26 16:00:00 | AAPL | Stock | 217.96 | 218.13 | 217.75 | 217.98 | 5337533.0 |
| 2024-07-26 16:30:00 | AAPL | Stock | 218.0 | 218.09 | 217.87 | 217.87 | 30290.0 |
| 2024-07-26 17:00:00 | AAPL | Stock | 217.87 | 217.88 | 217.8 | 217.85 | 10716.0 |
| 2024-07-26 17:30:00 | AAPL | Stock | 217.84 | 217.85 | 217.79 | 217.81 | 4118.0 |
| 2024-07-26 18:00:00 | AAPL | Stock | 217.82 | 217.95 | 217.8 | 217.82 | 6522.0 |
| 2024-07-26 18:30:00 | AAPL | Stock | 217.8 | 217.82 | 217.8 | 217.82 | 4054.0 |
| 2024-07-26 19:00:00 | AAPL | Stock | 217.81 | 217.82 | 217.81 | 217.82 | 1532.0 |
| 2024-07-26 19:30:00 | AAPL | Stock | 217.82 | 217.98 | 217.8 | 217.9 | 4541.0 |
| 2024-07-26 04:00:00 | MSFT | Stock | 420.03 | 421.5 | 418.99 | 421.19 | 12150.0 |
| 2024-07-26 04:30:00 | MSFT | Stock | 420.69 | 421.0 | 420.5 | 421.0 | 4959.0 |
| 2024-07-26 05:00:00 | MSFT | Stock | 421.21 | 421.51 | 421.1 | 421.1 | 1936.0 |
| 2024-07-26 05:30:00 | MSFT | Stock | 421.5 | 421.59 | 421.11 | 421.5 | 1536.0 |
| 2024-07-26 06:00:00 | MSFT | Stock | 421.62 | 421.77 | 421.5 | 421.6 | 3876.0 |
| 2024-07-26 06:30:00 | MSFT | Stock | 421.6 | 422.21 | 421.6 | 422.1 | 3968.0 |
| 2024-07-26 07:00:00 | MSFT | Stock | 421.99 | 422.24 | 421.5 | 422.0 | 10709.0 |
| 2024-07-26 07:30:00 | MSFT | Stock | 422.02 | 422.19 | 421.1 | 421.5 | 8907.0 |
| 2024-07-26 08:00:00 | MSFT | Stock | 422.0 | 422.23 | 420.0 | 421.0 | 46844.0 |
| 2024-07-26 08:30:00 | MSFT | Stock | 421.0 | 421.1 | 418.71 | 419.29 | 61315.0 |
| 2024-07-26 09:00:00 | MSFT | Stock | 419.3 | 419.65 | 417.92 | 418.18 | 41154.0 |
| 2024-07-26 09:30:00 | MSFT | Stock | 418.17 | 421.91 | 417.27 | 419.995 | 2071509.0 |
| 2024-07-26 10:00:00 | MSFT | Stock | 419.96 | 424.27 | 419.5 | 422.98 | 1218920.0 |
| 2024-07-26 10:30:00 | MSFT | Stock | 423.03 | 423.22 | 420.16 | 422.47 | 766533.0 |
| 2024-07-26 11:00:00 | MSFT | Stock | 422.56 | 424.26 | 422.34 | 423.39 | 587540.0 |
| 2024-07-26 11:30:00 | MSFT | Stock | 423.44 | 426.2 | 422.94 | 425.95 | 767218.0 |
| 2024-07-26 12:00:00 | MSFT | Stock | 426.02 | 427.7 | 425.97 | 427.16 | 798471.0 |
| 2024-07-26 12:30:00 | MSFT | Stock | 427.18 | 428.32 | 426.95 | 428.0 | 601024.0 |
> showing 50 of 96,687 rows — these rows as CSV