PREVIEW / stock_30min / 2024-07-11
file: by_date/stock_30min/2024/2024-07-11.parquet size: 2.1 MB rows: 101,790 symbols: 902
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-11 04:00:00 | AAPL | Stock | 232.81 | 232.84 | 232.37 | 232.55 | 9197.0 |
| 2024-07-11 04:30:00 | AAPL | Stock | 232.55 | 232.8 | 232.55 | 232.7 | 9618.0 |
| 2024-07-11 05:00:00 | AAPL | Stock | 232.68 | 232.8 | 232.68 | 232.72 | 7164.0 |
| 2024-07-11 05:30:00 | AAPL | Stock | 232.69 | 232.7 | 232.69 | 232.7 | 2226.0 |
| 2024-07-11 06:00:00 | AAPL | Stock | 232.69 | 232.69 | 232.64 | 232.66 | 3364.0 |
| 2024-07-11 06:30:00 | AAPL | Stock | 232.64 | 232.64 | 232.59 | 232.63 | 2158.0 |
| 2024-07-11 07:00:00 | AAPL | Stock | 232.62 | 232.7 | 232.25 | 232.39 | 22457.0 |
| 2024-07-11 07:30:00 | AAPL | Stock | 232.44 | 232.44 | 232.14 | 232.14 | 12967.0 |
| 2024-07-11 08:00:00 | AAPL | Stock | 232.58 | 232.99 | 231.8881 | 232.25 | 123782.0 |
| 2024-07-11 08:30:00 | AAPL | Stock | 232.31 | 233.48 | 231.75 | 232.06 | 414509.0 |
| 2024-07-11 09:00:00 | AAPL | Stock | 232.0 | 232.98 | 231.16 | 231.21 | 236037.0 |
| 2024-07-11 09:30:00 | AAPL | Stock | 231.21 | 232.39 | 230.14 | 231.83 | 6905592.0 |
| 2024-07-11 10:00:00 | AAPL | Stock | 231.83 | 232.15 | 228.53 | 228.9 | 5543350.0 |
| 2024-07-11 10:30:00 | AAPL | Stock | 228.88 | 229.64 | 226.64 | 226.66 | 4575340.0 |
| 2024-07-11 11:00:00 | AAPL | Stock | 226.66 | 227.7 | 226.27 | 226.64 | 4156258.0 |
| 2024-07-11 11:30:00 | AAPL | Stock | 226.62 | 227.07 | 225.77 | 226.86 | 3204539.0 |
| 2024-07-11 12:00:00 | AAPL | Stock | 226.864 | 227.84 | 226.7 | 227.7658 | 2311679.0 |
| 2024-07-11 12:30:00 | AAPL | Stock | 227.76 | 228.72 | 227.65 | 227.72 | 2796818.0 |
| 2024-07-11 13:00:00 | AAPL | Stock | 227.72 | 228.2646 | 227.26 | 227.98 | 1422439.0 |
| 2024-07-11 13:30:00 | AAPL | Stock | 227.97 | 227.975 | 226.58 | 226.82 | 1307911.0 |
| 2024-07-11 14:00:00 | AAPL | Stock | 226.82 | 227.53 | 226.74 | 227.265 | 1291213.0 |
| 2024-07-11 14:30:00 | AAPL | Stock | 227.27 | 228.02 | 227.21 | 227.87 | 1415632.0 |
| 2024-07-11 15:00:00 | AAPL | Stock | 227.88 | 228.56 | 227.67 | 227.71 | 1851009.0 |
| 2024-07-11 15:30:00 | AAPL | Stock | 227.72 | 228.7 | 227.55 | 227.55 | 4970088.0 |
| 2024-07-11 16:00:00 | AAPL | Stock | 227.58 | 228.22 | 227.25 | 227.83 | 8896303.0 |
| 2024-07-11 16:30:00 | AAPL | Stock | 227.8 | 227.88 | 227.57 | 227.71 | 128582.0 |
| 2024-07-11 17:00:00 | AAPL | Stock | 227.7 | 227.8 | 227.57 | 227.7 | 24609.0 |
| 2024-07-11 17:30:00 | AAPL | Stock | 227.74 | 228.0 | 227.69 | 227.9 | 27350.0 |
| 2024-07-11 18:00:00 | AAPL | Stock | 227.85 | 228.23 | 227.8 | 228.0 | 32581.0 |
| 2024-07-11 18:30:00 | AAPL | Stock | 228.14 | 228.5841 | 228.01 | 228.34 | 38553.0 |
| 2024-07-11 19:00:00 | AAPL | Stock | 228.42 | 229.0 | 228.41 | 228.94 | 60941.0 |
| 2024-07-11 19:30:00 | AAPL | Stock | 228.9 | 228.95 | 227.82 | 228.05 | 43559.0 |
| 2024-07-11 04:00:00 | MSFT | Stock | 465.96 | 466.06 | 465.96 | 466.0 | 1252.0 |
| 2024-07-11 04:30:00 | MSFT | Stock | 466.1 | 466.1 | 466.06 | 466.06 | 307.0 |
| 2024-07-11 05:00:00 | MSFT | Stock | 465.34 | 465.8 | 465.23 | 465.8 | 525.0 |
| 2024-07-11 05:30:00 | MSFT | Stock | 465.8 | 465.8 | 465.77 | 465.77 | 600.0 |
| 2024-07-11 06:00:00 | MSFT | Stock | 465.81 | 465.81 | 465.81 | 465.81 | 107.0 |
| 2024-07-11 06:30:00 | MSFT | Stock | 465.58 | 465.72 | 465.58 | 465.72 | 300.0 |
| 2024-07-11 07:00:00 | MSFT | Stock | 466.0 | 466.11 | 465.75 | 465.79 | 1219.0 |
| 2024-07-11 07:30:00 | MSFT | Stock | 465.9 | 465.9 | 465.9 | 465.9 | 150.0 |
| 2024-07-11 08:00:00 | MSFT | Stock | 465.8 | 466.03 | 465.27 | 465.9 | 18146.0 |
| 2024-07-11 08:30:00 | MSFT | Stock | 466.5 | 467.75 | 465.0 | 465.18 | 50510.0 |
| 2024-07-11 09:00:00 | MSFT | Stock | 465.19 | 466.25 | 462.25 | 462.66 | 36371.0 |
| 2024-07-11 09:30:00 | MSFT | Stock | 462.66 | 464.78 | 460.9 | 461.16 | 1408972.0 |
| 2024-07-11 10:00:00 | MSFT | Stock | 461.24 | 461.9 | 455.58 | 455.89 | 1555355.0 |
| 2024-07-11 10:30:00 | MSFT | Stock | 455.81 | 456.76 | 453.3 | 454.945 | 1455323.0 |
| 2024-07-11 11:00:00 | MSFT | Stock | 454.98 | 455.46 | 451.9 | 452.58 | 1072651.0 |
| 2024-07-11 11:30:00 | MSFT | Stock | 452.525 | 453.92 | 451.55 | 453.23 | 825855.0 |
| 2024-07-11 12:00:00 | MSFT | Stock | 453.24 | 454.65 | 452.79 | 454.43 | 641501.0 |
| 2024-07-11 12:30:00 | MSFT | Stock | 454.44 | 456.28 | 454.11 | 454.53 | 593038.0 |
> showing 50 of 101,790 rows — these rows as CSV