PREVIEW / stock_30min / 2024-07-10
file: by_date/stock_30min/2024/2024-07-10.parquet size: 2.0 MB rows: 98,881 symbols: 894
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-10 04:00:00 | AAPL | Stock | 229.11 | 229.11 | 228.65 | 229.03 | 8001.0 |
| 2024-07-10 04:30:00 | AAPL | Stock | 229.06 | 229.11 | 229.01 | 229.11 | 2244.0 |
| 2024-07-10 05:00:00 | AAPL | Stock | 229.21 | 229.35 | 229.21 | 229.31 | 1321.0 |
| 2024-07-10 05:30:00 | AAPL | Stock | 229.34 | 229.35 | 229.08 | 229.12 | 3836.0 |
| 2024-07-10 06:00:00 | AAPL | Stock | 229.13 | 230.0 | 229.12 | 229.89 | 19503.0 |
| 2024-07-10 06:30:00 | AAPL | Stock | 229.85 | 229.9 | 229.55 | 229.55 | 5958.0 |
| 2024-07-10 07:00:00 | AAPL | Stock | 229.42 | 229.8 | 229.4 | 229.74 | 8421.0 |
| 2024-07-10 07:30:00 | AAPL | Stock | 229.73 | 229.9 | 229.66 | 229.7 | 10388.0 |
| 2024-07-10 08:00:00 | AAPL | Stock | 229.57 | 229.88 | 228.83 | 229.45 | 165478.0 |
| 2024-07-10 08:30:00 | AAPL | Stock | 229.5 | 229.58 | 229.45 | 229.55 | 33070.0 |
| 2024-07-10 09:00:00 | AAPL | Stock | 229.56 | 229.58 | 229.0 | 229.26 | 92329.0 |
| 2024-07-10 09:30:00 | AAPL | Stock | 229.27 | 231.38 | 229.25 | 231.3013 | 7520742.0 |
| 2024-07-10 10:00:00 | AAPL | Stock | 231.31 | 231.722 | 230.794 | 231.1 | 4296176.0 |
| 2024-07-10 10:30:00 | AAPL | Stock | 231.11 | 231.155 | 230.17 | 230.2872 | 2946212.0 |
| 2024-07-10 11:00:00 | AAPL | Stock | 230.29 | 231.05 | 230.105 | 230.995 | 2033201.0 |
| 2024-07-10 11:30:00 | AAPL | Stock | 231.0 | 231.395 | 230.955 | 231.28 | 1780812.0 |
| 2024-07-10 12:00:00 | AAPL | Stock | 231.29 | 232.74 | 231.044 | 232.195 | 6282018.0 |
| 2024-07-10 12:30:00 | AAPL | Stock | 232.2 | 232.42 | 230.93 | 231.324 | 3213396.0 |
| 2024-07-10 13:00:00 | AAPL | Stock | 231.32 | 231.69 | 230.71 | 231.56 | 2696842.0 |
| 2024-07-10 13:30:00 | AAPL | Stock | 231.57 | 232.15 | 231.52 | 231.96 | 2103964.0 |
| 2024-07-10 14:00:00 | AAPL | Stock | 231.965 | 232.13 | 231.6101 | 232.1 | 1425181.0 |
| 2024-07-10 14:30:00 | AAPL | Stock | 232.1 | 232.19 | 231.88 | 232.155 | 1521726.0 |
| 2024-07-10 15:00:00 | AAPL | Stock | 232.145 | 232.145 | 231.63 | 231.76 | 1915840.0 |
| 2024-07-10 15:30:00 | AAPL | Stock | 231.76 | 233.08 | 231.705 | 232.91 | 6045541.0 |
| 2024-07-10 16:00:00 | AAPL | Stock | 232.98 | 233.0 | 232.71 | 232.73 | 7574026.0 |
| 2024-07-10 16:30:00 | AAPL | Stock | 232.7165 | 232.98 | 232.53 | 232.55 | 79645.0 |
| 2024-07-10 17:00:00 | AAPL | Stock | 232.54 | 232.98 | 232.5 | 232.69 | 70103.0 |
| 2024-07-10 17:30:00 | AAPL | Stock | 232.68 | 232.98 | 232.66 | 232.6742 | 18232.0 |
| 2024-07-10 18:00:00 | AAPL | Stock | 232.6802 | 232.83 | 232.68 | 232.75 | 14860.0 |
| 2024-07-10 18:30:00 | AAPL | Stock | 232.73 | 232.77 | 232.32 | 232.5018 | 14436.0 |
| 2024-07-10 19:00:00 | AAPL | Stock | 232.5 | 232.55 | 232.41 | 232.41 | 9601.0 |
| 2024-07-10 19:30:00 | AAPL | Stock | 232.42 | 232.4618 | 232.31 | 232.37 | 15410.0 |
| 2024-07-10 04:00:00 | MSFT | Stock | 461.0 | 461.65 | 461.0 | 461.65 | 1198.0 |
| 2024-07-10 04:30:00 | MSFT | Stock | 462.02 | 462.3 | 462.0 | 462.29 | 2139.0 |
| 2024-07-10 05:00:00 | MSFT | Stock | 462.31 | 462.31 | 461.8 | 461.8 | 3272.0 |
| 2024-07-10 06:00:00 | MSFT | Stock | 461.58 | 461.65 | 461.58 | 461.65 | 459.0 |
| 2024-07-10 06:30:00 | MSFT | Stock | 461.6 | 461.6 | 461.6 | 461.6 | 405.0 |
| 2024-07-10 07:00:00 | MSFT | Stock | 461.51 | 461.65 | 460.61 | 460.65 | 6271.0 |
| 2024-07-10 07:30:00 | MSFT | Stock | 460.91 | 461.5 | 460.91 | 461.2 | 1572.0 |
| 2024-07-10 08:00:00 | MSFT | Stock | 461.6 | 462.21 | 460.7 | 461.1699 | 24632.0 |
| 2024-07-10 08:30:00 | MSFT | Stock | 461.06 | 461.28 | 461.02 | 461.24 | 5020.0 |
| 2024-07-10 09:00:00 | MSFT | Stock | 461.2 | 461.38 | 460.78 | 461.26 | 18778.0 |
| 2024-07-10 09:30:00 | MSFT | Stock | 461.22 | 462.5 | 458.855 | 462.5 | 1281542.0 |
| 2024-07-10 10:00:00 | MSFT | Stock | 462.545 | 463.2899 | 461.81 | 462.98 | 820542.0 |
| 2024-07-10 10:30:00 | MSFT | Stock | 463.04 | 463.62 | 459.6 | 460.73 | 805352.0 |
| 2024-07-10 11:00:00 | MSFT | Stock | 460.815 | 461.3783 | 459.6701 | 461.05 | 465197.0 |
| 2024-07-10 11:30:00 | MSFT | Stock | 461.07 | 461.87 | 460.16 | 460.6 | 427929.0 |
| 2024-07-10 12:00:00 | MSFT | Stock | 460.55 | 461.77 | 459.91 | 461.535 | 410007.0 |
| 2024-07-10 12:30:00 | MSFT | Stock | 461.56 | 464.126 | 461.42 | 464.07 | 503718.0 |
| 2024-07-10 13:00:00 | MSFT | Stock | 464.03 | 465.1 | 462.85 | 463.02 | 525962.0 |
> showing 50 of 98,881 rows — these rows as CSV