PREVIEW / stock_30min / 2024-03-25
file: by_date/stock_30min/2024/2024-03-25.parquet size: 2.1 MB rows: 99,876 symbols: 1,058
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-25 04:00:00 | AAPL | Stock | 172.2 | 172.2 | 172.0 | 172.19 | 3823.0 |
| 2024-03-25 04:30:00 | AAPL | Stock | 172.18 | 172.2 | 172.18 | 172.18 | 397.0 |
| 2024-03-25 05:00:00 | AAPL | Stock | 172.17 | 172.17 | 171.72 | 171.72 | 11370.0 |
| 2024-03-25 05:30:00 | AAPL | Stock | 171.81 | 171.81 | 171.68 | 171.71 | 4941.0 |
| 2024-03-25 06:00:00 | AAPL | Stock | 171.7 | 171.85 | 171.5 | 171.5 | 9129.0 |
| 2024-03-25 06:30:00 | AAPL | Stock | 171.36 | 171.38 | 171.3 | 171.3 | 2741.0 |
| 2024-03-25 07:00:00 | AAPL | Stock | 171.39 | 171.41 | 171.07 | 171.2 | 44677.0 |
| 2024-03-25 07:30:00 | AAPL | Stock | 171.19 | 171.2 | 171.08 | 171.19 | 15434.0 |
| 2024-03-25 08:00:00 | AAPL | Stock | 171.4 | 172.27 | 171.0 | 171.08 | 110521.0 |
| 2024-03-25 08:30:00 | AAPL | Stock | 171.08 | 171.24 | 170.9 | 171.0 | 47963.0 |
| 2024-03-25 09:00:00 | AAPL | Stock | 171.02 | 171.1 | 170.36 | 170.51 | 141351.0 |
| 2024-03-25 09:30:00 | AAPL | Stock | 170.57 | 170.69 | 169.45 | 170.18 | 7688253.0 |
| 2024-03-25 10:00:00 | AAPL | Stock | 170.18 | 170.25 | 169.77 | 170.04 | 3105886.0 |
| 2024-03-25 10:30:00 | AAPL | Stock | 170.04 | 170.61 | 169.96 | 170.55 | 3194794.0 |
| 2024-03-25 11:00:00 | AAPL | Stock | 170.54 | 170.73 | 170.09 | 170.12 | 2221725.0 |
| 2024-03-25 11:30:00 | AAPL | Stock | 170.12 | 170.765 | 170.09 | 170.62 | 1874186.0 |
| 2024-03-25 12:00:00 | AAPL | Stock | 170.62 | 170.82 | 170.38 | 170.7379 | 1912742.0 |
| 2024-03-25 12:30:00 | AAPL | Stock | 170.735 | 171.15 | 170.64 | 170.99 | 1808918.0 |
| 2024-03-25 13:00:00 | AAPL | Stock | 171.0 | 171.47 | 170.985 | 171.365 | 2158829.0 |
| 2024-03-25 13:30:00 | AAPL | Stock | 171.36 | 171.52 | 171.15 | 171.468 | 1547851.0 |
| 2024-03-25 14:00:00 | AAPL | Stock | 171.465 | 171.61 | 171.3101 | 171.33 | 1635314.0 |
| 2024-03-25 14:30:00 | AAPL | Stock | 171.325 | 171.54 | 171.235 | 171.448 | 1533322.0 |
| 2024-03-25 15:00:00 | AAPL | Stock | 171.45 | 171.63 | 171.34 | 171.558 | 1463287.0 |
| 2024-03-25 15:30:00 | AAPL | Stock | 171.56 | 171.94 | 170.79 | 170.85 | 6014863.0 |
| 2024-03-25 16:00:00 | AAPL | Stock | 170.86 | 171.1496 | 170.78 | 170.87 | 8115777.0 |
| 2024-03-25 16:30:00 | AAPL | Stock | 170.85 | 170.89 | 170.75 | 170.85 | 76551.0 |
| 2024-03-25 17:00:00 | AAPL | Stock | 170.9078 | 170.93 | 170.75 | 170.93 | 18483.0 |
| 2024-03-25 17:30:00 | AAPL | Stock | 170.88 | 170.88 | 170.05 | 170.88 | 5375.0 |
| 2024-03-25 18:00:00 | AAPL | Stock | 170.8301 | 170.95 | 170.83 | 170.94 | 13066.0 |
| 2024-03-25 18:30:00 | AAPL | Stock | 170.93 | 170.9999 | 170.86 | 170.93 | 11951.0 |
| 2024-03-25 19:00:00 | AAPL | Stock | 170.9 | 170.94 | 170.83 | 170.88 | 5770.0 |
| 2024-03-25 19:30:00 | AAPL | Stock | 170.8797 | 170.98 | 170.86 | 170.92 | 7699.0 |
| 2024-03-25 04:00:00 | MSFT | Stock | 427.61 | 427.61 | 425.27 | 425.92 | 2446.0 |
| 2024-03-25 04:30:00 | MSFT | Stock | 426.01 | 426.66 | 426.01 | 426.6 | 1195.0 |
| 2024-03-25 05:00:00 | MSFT | Stock | 426.66 | 426.66 | 426.36 | 426.52 | 784.0 |
| 2024-03-25 05:30:00 | MSFT | Stock | 426.57 | 426.9 | 426.57 | 426.61 | 1990.0 |
| 2024-03-25 06:00:00 | MSFT | Stock | 426.48 | 426.48 | 425.0 | 425.89 | 1644.0 |
| 2024-03-25 06:30:00 | MSFT | Stock | 426.02 | 426.09 | 425.77 | 425.86 | 3637.0 |
| 2024-03-25 07:00:00 | MSFT | Stock | 426.1 | 426.1 | 425.09 | 425.57 | 6013.0 |
| 2024-03-25 07:30:00 | MSFT | Stock | 425.35 | 425.52 | 425.35 | 425.51 | 1863.0 |
| 2024-03-25 08:00:00 | MSFT | Stock | 426.07 | 428.74 | 425.14 | 426.0 | 20210.0 |
| 2024-03-25 08:30:00 | MSFT | Stock | 426.22 | 426.22 | 425.84 | 426.19 | 9495.0 |
| 2024-03-25 09:00:00 | MSFT | Stock | 426.3 | 427.36 | 425.0 | 425.51 | 21912.0 |
| 2024-03-25 09:30:00 | MSFT | Stock | 425.39 | 427.41 | 421.61 | 423.2815 | 1980725.0 |
| 2024-03-25 10:00:00 | MSFT | Stock | 423.25 | 424.65 | 422.44 | 424.34 | 850373.0 |
| 2024-03-25 10:30:00 | MSFT | Stock | 424.37 | 425.32 | 424.19 | 425.05 | 537784.0 |
| 2024-03-25 11:00:00 | MSFT | Stock | 425.05 | 425.14 | 424.11 | 424.6369 | 442545.0 |
| 2024-03-25 11:30:00 | MSFT | Stock | 424.6294 | 425.17 | 424.41 | 424.555 | 356290.0 |
| 2024-03-25 12:00:00 | MSFT | Stock | 424.56 | 425.22 | 424.26 | 424.53 | 343437.0 |
| 2024-03-25 12:30:00 | MSFT | Stock | 424.51 | 424.6199 | 424.13 | 424.36 | 247128.0 |
> showing 50 of 99,876 rows — these rows as CSV