PREVIEW / stock_30min / 2024-04-01
file: by_date/stock_30min/2024/2024-04-01.parquet size: 2.1 MB rows: 101,996 symbols: 1,049
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-04-01 04:00:00 | AAPL | Stock | 172.02 | 172.02 | 171.42 | 171.71 | 5376.0 |
| 2024-04-01 04:30:00 | AAPL | Stock | 171.72 | 171.75 | 171.65 | 171.7 | 3343.0 |
| 2024-04-01 05:00:00 | AAPL | Stock | 171.71 | 171.85 | 171.71 | 171.85 | 3617.0 |
| 2024-04-01 05:30:00 | AAPL | Stock | 171.9 | 171.9 | 171.75 | 171.75 | 1237.0 |
| 2024-04-01 06:00:00 | AAPL | Stock | 171.83 | 171.83 | 171.79 | 171.79 | 880.0 |
| 2024-04-01 06:30:00 | AAPL | Stock | 171.7 | 171.7 | 171.5 | 171.5 | 3417.0 |
| 2024-04-01 07:00:00 | AAPL | Stock | 171.5 | 171.61 | 171.4 | 171.48 | 16380.0 |
| 2024-04-01 07:30:00 | AAPL | Stock | 171.45 | 171.58 | 171.38 | 171.58 | 8321.0 |
| 2024-04-01 08:00:00 | AAPL | Stock | 171.57 | 171.99 | 171.37 | 171.48 | 67890.0 |
| 2024-04-01 08:30:00 | AAPL | Stock | 171.44 | 171.7 | 171.36 | 171.5005 | 26270.0 |
| 2024-04-01 09:00:00 | AAPL | Stock | 171.49 | 171.49 | 170.8 | 171.09 | 92440.0 |
| 2024-04-01 09:30:00 | AAPL | Stock | 171.14 | 171.25 | 170.05 | 170.135 | 5689746.0 |
| 2024-04-01 10:00:00 | AAPL | Stock | 170.135 | 170.4521 | 169.835 | 170.0899 | 4083604.0 |
| 2024-04-01 10:30:00 | AAPL | Stock | 170.08 | 170.16 | 169.82 | 169.88 | 2152968.0 |
| 2024-04-01 11:00:00 | AAPL | Stock | 169.885 | 169.89 | 169.475 | 169.845 | 2386645.0 |
| 2024-04-01 11:30:00 | AAPL | Stock | 169.84 | 170.08 | 169.605 | 169.6431 | 1697069.0 |
| 2024-04-01 12:00:00 | AAPL | Stock | 169.65 | 170.0 | 169.5803 | 169.895 | 1388399.0 |
| 2024-04-01 12:30:00 | AAPL | Stock | 169.895 | 169.995 | 169.8 | 169.835 | 1020734.0 |
| 2024-04-01 13:00:00 | AAPL | Stock | 169.835 | 170.02 | 169.76 | 169.9157 | 1324573.0 |
| 2024-04-01 13:30:00 | AAPL | Stock | 169.915 | 170.09 | 169.88 | 169.9968 | 1194255.0 |
| 2024-04-01 14:00:00 | AAPL | Stock | 169.995 | 170.08 | 169.93 | 169.995 | 963720.0 |
| 2024-04-01 14:30:00 | AAPL | Stock | 169.99 | 170.06 | 169.86 | 170.01 | 1327660.0 |
| 2024-04-01 15:00:00 | AAPL | Stock | 170.015 | 170.24 | 169.85 | 169.935 | 1789613.0 |
| 2024-04-01 15:30:00 | AAPL | Stock | 169.935 | 170.14 | 169.87 | 170.01 | 5041060.0 |
| 2024-04-01 16:00:00 | AAPL | Stock | 170.0 | 170.05 | 169.8 | 169.8 | 5917293.0 |
| 2024-04-01 16:30:00 | AAPL | Stock | 169.8 | 170.03 | 169.8 | 169.86 | 58349.0 |
| 2024-04-01 17:00:00 | AAPL | Stock | 169.87 | 170.03 | 169.75 | 169.75 | 24094.0 |
| 2024-04-01 17:30:00 | AAPL | Stock | 169.79 | 169.85 | 169.76 | 169.84 | 9513.0 |
| 2024-04-01 18:00:00 | AAPL | Stock | 169.83 | 169.84 | 169.65 | 169.65 | 27713.0 |
| 2024-04-01 18:30:00 | AAPL | Stock | 169.65 | 169.7 | 169.6 | 169.6874 | 18692.0 |
| 2024-04-01 19:00:00 | AAPL | Stock | 169.67 | 169.69 | 169.55 | 169.55 | 10806.0 |
| 2024-04-01 19:30:00 | AAPL | Stock | 169.57 | 169.6 | 169.5 | 169.5 | 29379.0 |
| 2024-04-01 04:00:00 | MSFT | Stock | 423.0 | 424.97 | 423.0 | 424.97 | 10917.0 |
| 2024-04-01 04:30:00 | MSFT | Stock | 424.92 | 425.14 | 423.0 | 423.66 | 3827.0 |
| 2024-04-01 05:00:00 | MSFT | Stock | 423.66 | 423.99 | 423.5 | 423.5 | 1980.0 |
| 2024-04-01 05:30:00 | MSFT | Stock | 423.1 | 424.68 | 423.1 | 424.68 | 2854.0 |
| 2024-04-01 06:00:00 | MSFT | Stock | 424.68 | 424.83 | 424.68 | 424.83 | 301.0 |
| 2024-04-01 06:30:00 | MSFT | Stock | 424.43 | 424.43 | 424.43 | 424.43 | 100.0 |
| 2024-04-01 07:00:00 | MSFT | Stock | 424.0 | 424.01 | 422.8 | 422.8 | 5964.0 |
| 2024-04-01 07:30:00 | MSFT | Stock | 422.7 | 423.5 | 422.7 | 423.46 | 2933.0 |
| 2024-04-01 08:00:00 | MSFT | Stock | 423.87 | 424.2 | 422.63 | 423.5 | 18048.0 |
| 2024-04-01 08:30:00 | MSFT | Stock | 423.36 | 423.8254 | 420.72 | 423.5 | 12059.0 |
| 2024-04-01 09:00:00 | MSFT | Stock | 423.65 | 424.0 | 422.6 | 424.0 | 18318.0 |
| 2024-04-01 09:30:00 | MSFT | Stock | 423.95 | 427.89 | 422.47 | 424.285 | 2283800.0 |
| 2024-04-01 10:00:00 | MSFT | Stock | 424.25 | 426.07 | 423.98 | 424.81 | 897125.0 |
| 2024-04-01 10:30:00 | MSFT | Stock | 424.84 | 425.36 | 423.71 | 424.06 | 645735.0 |
| 2024-04-01 11:00:00 | MSFT | Stock | 424.01 | 424.835 | 422.64 | 423.94 | 538692.0 |
| 2024-04-01 11:30:00 | MSFT | Stock | 423.93 | 424.3637 | 423.13 | 423.17 | 297337.0 |
| 2024-04-01 12:00:00 | MSFT | Stock | 423.25 | 424.89 | 423.11 | 423.74 | 327721.0 |
| 2024-04-01 12:30:00 | MSFT | Stock | 423.75 | 423.98 | 423.165 | 423.25 | 244001.0 |
> showing 50 of 101,996 rows — these rows as CSV