PREVIEW / stock_30min / 2024-03-11
file: by_date/stock_30min/2024/2024-03-11.parquet size: 2.1 MB rows: 101,472 symbols: 1,097
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-03-11 04:00:00 | AAPL | Stock | 171.0 | 171.67 | 170.92 | 171.67 | 12588.0 |
| 2024-03-11 04:30:00 | AAPL | Stock | 171.63 | 171.63 | 170.76 | 170.96 | 14195.0 |
| 2024-03-11 05:00:00 | AAPL | Stock | 171.01 | 171.5 | 171.0 | 171.5 | 26768.0 |
| 2024-03-11 05:30:00 | AAPL | Stock | 171.5 | 171.5 | 171.22 | 171.25 | 24210.0 |
| 2024-03-11 06:00:00 | AAPL | Stock | 171.29 | 171.37 | 170.94 | 170.94 | 5115.0 |
| 2024-03-11 06:30:00 | AAPL | Stock | 171.15 | 171.4 | 171.13 | 171.27 | 4528.0 |
| 2024-03-11 07:00:00 | AAPL | Stock | 171.19 | 171.75 | 171.0 | 171.69 | 39169.0 |
| 2024-03-11 07:30:00 | AAPL | Stock | 171.61 | 171.7 | 171.2 | 171.5 | 28715.0 |
| 2024-03-11 08:00:00 | AAPL | Stock | 171.01 | 172.0 | 170.91 | 171.45 | 130770.0 |
| 2024-03-11 08:30:00 | AAPL | Stock | 171.4 | 171.98 | 171.34 | 171.8976 | 125958.0 |
| 2024-03-11 09:00:00 | AAPL | Stock | 171.9 | 173.02 | 171.6311 | 173.02 | 269429.0 |
| 2024-03-11 09:30:00 | AAPL | Stock | 172.98 | 174.38 | 172.74 | 173.8 | 8694114.0 |
| 2024-03-11 10:00:00 | AAPL | Stock | 173.81 | 173.99 | 172.98 | 173.35 | 4684118.0 |
| 2024-03-11 10:30:00 | AAPL | Stock | 173.3489 | 173.64 | 172.29 | 172.48 | 3326704.0 |
| 2024-03-11 11:00:00 | AAPL | Stock | 172.47 | 172.89 | 172.295 | 172.6731 | 2670943.0 |
| 2024-03-11 11:30:00 | AAPL | Stock | 172.678 | 173.3296 | 172.54 | 173.06 | 2366673.0 |
| 2024-03-11 12:00:00 | AAPL | Stock | 173.06 | 173.15 | 172.6429 | 172.83 | 2006465.0 |
| 2024-03-11 12:30:00 | AAPL | Stock | 172.84 | 172.98 | 172.55 | 172.61 | 1434343.0 |
| 2024-03-11 13:00:00 | AAPL | Stock | 172.606 | 172.75 | 172.05 | 172.39 | 1764137.0 |
| 2024-03-11 13:30:00 | AAPL | Stock | 172.385 | 173.42 | 172.22 | 172.62 | 3199098.0 |
| 2024-03-11 14:00:00 | AAPL | Stock | 172.62 | 172.695 | 172.3649 | 172.625 | 1403382.0 |
| 2024-03-11 14:30:00 | AAPL | Stock | 172.63 | 172.9 | 172.53 | 172.87 | 1544825.0 |
| 2024-03-11 15:00:00 | AAPL | Stock | 172.87 | 172.94 | 172.435 | 172.7 | 1723805.0 |
| 2024-03-11 15:30:00 | AAPL | Stock | 172.71 | 173.0699 | 172.45 | 172.79 | 4912537.0 |
| 2024-03-11 16:00:00 | AAPL | Stock | 172.75 | 172.92 | 172.68 | 172.88 | 6819983.0 |
| 2024-03-11 16:30:00 | AAPL | Stock | 172.88 | 173.08 | 172.75 | 172.94 | 53655.0 |
| 2024-03-11 17:00:00 | AAPL | Stock | 172.94 | 173.0799 | 172.75 | 172.75 | 49772.0 |
| 2024-03-11 17:30:00 | AAPL | Stock | 173.0 | 173.08 | 173.0 | 173.01 | 10259.0 |
| 2024-03-11 18:00:00 | AAPL | Stock | 173.02 | 173.45 | 172.97 | 173.34 | 23095.0 |
| 2024-03-11 18:30:00 | AAPL | Stock | 173.22 | 173.3405 | 173.08 | 173.23 | 15292.0 |
| 2024-03-11 19:00:00 | AAPL | Stock | 173.23 | 173.35 | 173.23 | 173.33 | 4045.0 |
| 2024-03-11 19:30:00 | AAPL | Stock | 173.33 | 173.33 | 173.2 | 173.29 | 14458.0 |
| 2024-03-11 04:00:00 | MSFT | Stock | 405.01 | 405.44 | 404.0 | 405.12 | 1295.0 |
| 2024-03-11 04:30:00 | MSFT | Stock | 405.4 | 405.41 | 403.97 | 403.97 | 500.0 |
| 2024-03-11 05:00:00 | MSFT | Stock | 404.37 | 404.73 | 404.32 | 404.34 | 1397.0 |
| 2024-03-11 05:30:00 | MSFT | Stock | 404.0 | 404.0 | 402.52 | 403.2 | 4073.0 |
| 2024-03-11 06:00:00 | MSFT | Stock | 403.42 | 403.66 | 403.24 | 403.24 | 4094.0 |
| 2024-03-11 06:30:00 | MSFT | Stock | 403.5 | 404.02 | 403.5 | 403.97 | 1388.0 |
| 2024-03-11 07:00:00 | MSFT | Stock | 404.16 | 405.22 | 404.16 | 404.69 | 7929.0 |
| 2024-03-11 07:30:00 | MSFT | Stock | 404.6 | 404.62 | 404.0 | 404.2 | 1163.0 |
| 2024-03-11 08:00:00 | MSFT | Stock | 405.04 | 406.94 | 403.2 | 403.58 | 35151.0 |
| 2024-03-11 08:30:00 | MSFT | Stock | 403.5027 | 403.8 | 403.26 | 403.7 | 3703.0 |
| 2024-03-11 09:00:00 | MSFT | Stock | 403.98 | 404.5 | 403.59 | 403.73 | 8930.0 |
| 2024-03-11 09:30:00 | MSFT | Stock | 403.77 | 404.35 | 401.75 | 401.95 | 1586732.0 |
| 2024-03-11 10:00:00 | MSFT | Stock | 401.965 | 403.01 | 401.26 | 402.82 | 896208.0 |
| 2024-03-11 10:30:00 | MSFT | Stock | 402.85 | 404.59 | 402.74 | 403.82 | 643225.0 |
| 2024-03-11 11:00:00 | MSFT | Stock | 403.77 | 404.115 | 402.6 | 402.71 | 599580.0 |
| 2024-03-11 11:30:00 | MSFT | Stock | 402.76 | 404.02 | 402.09 | 403.88 | 473874.0 |
| 2024-03-11 12:00:00 | MSFT | Stock | 403.885 | 403.885 | 402.77 | 403.03 | 469263.0 |
| 2024-03-11 12:30:00 | MSFT | Stock | 403.06 | 404.29 | 402.9601 | 404.07 | 348320.0 |
> showing 50 of 101,472 rows — these rows as CSV