PREVIEW / stock_30min / 2025-04-15
file: by_date/stock_30min/2025/2025-04-15.parquet size: 2.1 MB rows: 101,753 symbols: 443
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 |
|---|---|---|---|---|---|---|---|
| 2025-04-15 04:00:00 | AAPL | Stock | 202.22 | 203.74 | 201.0 | 203.06 | 30558.0 |
| 2025-04-15 04:30:00 | AAPL | Stock | 203.09 | 203.5 | 202.74 | 203.23 | 20438.0 |
| 2025-04-15 05:00:00 | AAPL | Stock | 203.2 | 203.48 | 203.01 | 203.35 | 6412.0 |
| 2025-04-15 05:30:00 | AAPL | Stock | 203.5 | 203.5 | 203.0 | 203.01 | 5357.0 |
| 2025-04-15 06:00:00 | AAPL | Stock | 203.12 | 203.2 | 202.91 | 203.08 | 7535.0 |
| 2025-04-15 06:30:00 | AAPL | Stock | 203.09 | 203.09 | 201.8 | 201.96 | 33146.0 |
| 2025-04-15 07:00:00 | AAPL | Stock | 202.0 | 202.0 | 201.0 | 201.48 | 39177.0 |
| 2025-04-15 07:30:00 | AAPL | Stock | 201.48 | 201.63 | 199.51 | 199.82 | 91519.0 |
| 2025-04-15 08:00:00 | AAPL | Stock | 201.61 | 204.0 | 199.5 | 200.0 | 172862.0 |
| 2025-04-15 08:30:00 | AAPL | Stock | 200.08 | 200.97 | 200.0 | 200.7399 | 103273.0 |
| 2025-04-15 09:00:00 | AAPL | Stock | 200.75 | 202.1 | 200.55 | 201.76 | 198391.0 |
| 2025-04-15 09:30:00 | AAPL | Stock | 201.76 | 203.51 | 201.14 | 202.935 | 5642094.0 |
| 2025-04-15 10:00:00 | AAPL | Stock | 202.935 | 203.06 | 199.8 | 200.8 | 4140924.0 |
| 2025-04-15 10:30:00 | AAPL | Stock | 200.79 | 202.67 | 200.686 | 201.7812 | 2679542.0 |
| 2025-04-15 11:00:00 | AAPL | Stock | 201.82 | 203.09 | 201.25 | 202.13 | 2037784.0 |
| 2025-04-15 11:30:00 | AAPL | Stock | 202.13 | 203.3 | 201.96 | 202.8871 | 1573312.0 |
| 2025-04-15 12:00:00 | AAPL | Stock | 202.875 | 203.35 | 202.3001 | 203.04 | 1345372.0 |
| 2025-04-15 12:30:00 | AAPL | Stock | 203.05 | 203.284 | 201.3112 | 201.49 | 1259222.0 |
| 2025-04-15 13:00:00 | AAPL | Stock | 201.485 | 202.49 | 201.115 | 201.6044 | 1745984.0 |
| 2025-04-15 13:30:00 | AAPL | Stock | 201.585 | 202.7769 | 201.55 | 202.35 | 1256311.0 |
| 2025-04-15 14:00:00 | AAPL | Stock | 202.385 | 202.67 | 201.305 | 201.765 | 1392972.0 |
| 2025-04-15 14:30:00 | AAPL | Stock | 201.73 | 202.65 | 201.64 | 202.45 | 1180245.0 |
| 2025-04-15 15:00:00 | AAPL | Stock | 202.46 | 203.29 | 202.13 | 202.81 | 1699887.0 |
| 2025-04-15 15:30:00 | AAPL | Stock | 202.83 | 202.959 | 201.92 | 202.13 | 3401584.0 |
| 2025-04-15 16:00:00 | AAPL | Stock | 202.06 | 202.66 | 202.0 | 202.2 | 4329168.0 |
| 2025-04-15 16:30:00 | AAPL | Stock | 202.2 | 202.47 | 202.14 | 202.14 | 18100.0 |
| 2025-04-15 17:00:00 | AAPL | Stock | 202.18 | 202.28 | 201.94 | 201.94 | 14783.0 |
| 2025-04-15 17:30:00 | AAPL | Stock | 201.94 | 202.2293 | 200.19 | 200.38 | 76761.0 |
| 2025-04-15 18:00:00 | AAPL | Stock | 200.5 | 200.7 | 199.48 | 200.2718 | 105709.0 |
| 2025-04-15 18:30:00 | AAPL | Stock | 200.19 | 200.42 | 199.83 | 200.0 | 30261.0 |
| 2025-04-15 19:00:00 | AAPL | Stock | 199.96 | 200.15 | 199.2906 | 199.4 | 44582.0 |
| 2025-04-15 19:30:00 | AAPL | Stock | 199.4 | 200.11 | 199.0 | 199.81 | 61674.0 |
| 2025-04-15 04:00:00 | MSFT | Stock | 389.27 | 389.56 | 388.49 | 388.8 | 2706.0 |
| 2025-04-15 04:30:00 | MSFT | Stock | 388.91 | 388.91 | 388.76 | 388.76 | 325.0 |
| 2025-04-15 05:00:00 | MSFT | Stock | 388.8 | 388.99 | 388.8 | 388.99 | 700.0 |
| 2025-04-15 05:30:00 | MSFT | Stock | 389.4 | 389.4 | 388.8 | 388.81 | 548.0 |
| 2025-04-15 06:00:00 | MSFT | Stock | 389.12 | 389.12 | 389.12 | 389.12 | 129.0 |
| 2025-04-15 06:30:00 | MSFT | Stock | 389.2 | 389.2 | 388.5 | 388.78 | 987.0 |
| 2025-04-15 07:00:00 | MSFT | Stock | 388.76 | 388.94 | 388.53 | 388.61 | 2598.0 |
| 2025-04-15 07:30:00 | MSFT | Stock | 388.81 | 388.81 | 387.01 | 387.51 | 2270.0 |
| 2025-04-15 08:00:00 | MSFT | Stock | 388.88 | 388.9999 | 386.77 | 386.77 | 13695.0 |
| 2025-04-15 08:30:00 | MSFT | Stock | 387.2 | 388.5 | 387.0 | 388.5 | 6120.0 |
| 2025-04-15 09:00:00 | MSFT | Stock | 388.81 | 390.77 | 388.0 | 388.5 | 14993.0 |
| 2025-04-15 09:30:00 | MSFT | Stock | 388.16 | 391.89 | 388.06 | 389.695 | 1337059.0 |
| 2025-04-15 10:00:00 | MSFT | Stock | 389.705 | 389.985 | 385.9 | 386.88 | 1316295.0 |
| 2025-04-15 10:30:00 | MSFT | Stock | 387.0 | 389.37 | 386.82 | 388.73 | 861792.0 |
| 2025-04-15 11:00:00 | MSFT | Stock | 388.8048 | 389.57 | 387.8 | 387.825 | 604783.0 |
| 2025-04-15 11:30:00 | MSFT | Stock | 387.825 | 388.79 | 386.35 | 387.49 | 543548.0 |
| 2025-04-15 12:00:00 | MSFT | Stock | 387.5 | 388.6 | 387.1354 | 388.39 | 370671.0 |
| 2025-04-15 12:30:00 | MSFT | Stock | 388.345 | 388.56 | 385.34 | 385.68 | 424332.0 |
> showing 50 of 101,753 rows — these rows as CSV