PREVIEW / stock_30min / 2025-03-10
file: by_date/stock_30min/2025/2025-03-10.parquet size: 2.2 MB rows: 107,593 symbols: 489
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-03-10 04:00:00 | AAPL | Stock | 237.49 | 238.08 | 236.63 | 236.94 | 26448.0 |
| 2025-03-10 04:30:00 | AAPL | Stock | 236.97 | 237.0 | 236.0 | 236.0 | 18612.0 |
| 2025-03-10 05:00:00 | AAPL | Stock | 236.01 | 236.1 | 235.64 | 235.99 | 25313.0 |
| 2025-03-10 05:30:00 | AAPL | Stock | 236.0 | 236.36 | 235.81 | 236.15 | 15349.0 |
| 2025-03-10 06:00:00 | AAPL | Stock | 236.19 | 236.19 | 235.56 | 235.63 | 13594.0 |
| 2025-03-10 06:30:00 | AAPL | Stock | 235.62 | 235.8 | 235.59 | 235.8 | 11090.0 |
| 2025-03-10 07:00:00 | AAPL | Stock | 235.97 | 236.11 | 235.5 | 235.9 | 16822.0 |
| 2025-03-10 07:30:00 | AAPL | Stock | 235.9 | 235.97 | 235.25 | 235.42 | 12654.0 |
| 2025-03-10 08:00:00 | AAPL | Stock | 236.0 | 238.473 | 235.25 | 235.65 | 96728.0 |
| 2025-03-10 08:30:00 | AAPL | Stock | 235.65 | 236.78 | 235.65 | 236.42 | 75430.0 |
| 2025-03-10 09:00:00 | AAPL | Stock | 236.5092 | 236.5092 | 235.0 | 235.5 | 124680.0 |
| 2025-03-10 09:30:00 | AAPL | Stock | 235.54 | 236.16 | 229.15 | 230.19 | 7801104.0 |
| 2025-03-10 10:00:00 | AAPL | Stock | 230.18 | 230.41 | 228.52 | 228.57 | 3547828.0 |
| 2025-03-10 10:30:00 | AAPL | Stock | 228.57 | 229.5 | 225.37 | 226.19 | 5338346.0 |
| 2025-03-10 11:00:00 | AAPL | Stock | 226.1759 | 226.72 | 225.29 | 226.5087 | 3742507.0 |
| 2025-03-10 11:30:00 | AAPL | Stock | 226.53 | 227.29 | 226.33 | 226.59 | 2286132.0 |
| 2025-03-10 12:00:00 | AAPL | Stock | 226.58 | 226.98 | 224.22 | 225.48 | 2577156.0 |
| 2025-03-10 12:30:00 | AAPL | Stock | 225.49 | 226.69 | 224.99 | 225.55 | 1789854.0 |
| 2025-03-10 13:00:00 | AAPL | Stock | 225.52 | 225.66 | 224.325 | 225.21 | 2045591.0 |
| 2025-03-10 13:30:00 | AAPL | Stock | 225.24 | 226.09 | 224.87 | 225.86 | 1709178.0 |
| 2025-03-10 14:00:00 | AAPL | Stock | 225.855 | 226.98 | 225.43 | 226.58 | 2129236.0 |
| 2025-03-10 14:30:00 | AAPL | Stock | 226.59 | 226.99 | 225.1064 | 225.28 | 1585719.0 |
| 2025-03-10 15:00:00 | AAPL | Stock | 225.29 | 227.515 | 224.42 | 226.975 | 3358429.0 |
| 2025-03-10 15:30:00 | AAPL | Stock | 226.99 | 228.66 | 226.5 | 227.541 | 5673448.0 |
| 2025-03-10 16:00:00 | AAPL | Stock | 227.48 | 227.5485 | 226.75 | 226.91 | 9537016.0 |
| 2025-03-10 16:30:00 | AAPL | Stock | 226.98 | 227.48 | 226.62 | 226.72 | 164415.0 |
| 2025-03-10 17:00:00 | AAPL | Stock | 226.78 | 226.78 | 226.1 | 226.49 | 23220.0 |
| 2025-03-10 17:30:00 | AAPL | Stock | 226.49 | 226.5 | 225.38 | 225.86 | 29020.0 |
| 2025-03-10 18:00:00 | AAPL | Stock | 225.98 | 226.6 | 225.02 | 226.031 | 61129.0 |
| 2025-03-10 18:30:00 | AAPL | Stock | 226.01 | 226.68 | 226.0 | 226.0 | 20692.0 |
| 2025-03-10 19:00:00 | AAPL | Stock | 226.0 | 226.1 | 224.8 | 224.949 | 32686.0 |
| 2025-03-10 19:30:00 | AAPL | Stock | 225.12 | 225.46 | 224.49 | 225.26 | 56669.0 |
| 2025-03-10 04:00:00 | MSFT | Stock | 391.74 | 392.0 | 389.45 | 390.22 | 1804.0 |
| 2025-03-10 04:30:00 | MSFT | Stock | 390.07 | 390.07 | 389.33 | 389.33 | 990.0 |
| 2025-03-10 05:00:00 | MSFT | Stock | 389.1 | 389.58 | 388.72 | 389.0 | 3179.0 |
| 2025-03-10 05:30:00 | MSFT | Stock | 389.57 | 389.79 | 389.2 | 389.55 | 1480.0 |
| 2025-03-10 06:00:00 | MSFT | Stock | 389.25 | 389.49 | 388.3 | 388.3 | 3574.0 |
| 2025-03-10 06:30:00 | MSFT | Stock | 387.85 | 388.63 | 387.85 | 388.62 | 1538.0 |
| 2025-03-10 07:00:00 | MSFT | Stock | 388.75 | 389.12 | 388.68 | 389.1 | 5600.0 |
| 2025-03-10 07:30:00 | MSFT | Stock | 389.2 | 389.56 | 388.38 | 388.5 | 4667.0 |
| 2025-03-10 08:00:00 | MSFT | Stock | 388.42 | 391.67 | 387.01 | 387.01 | 32230.0 |
| 2025-03-10 08:30:00 | MSFT | Stock | 387.37 | 387.5 | 386.6105 | 387.5 | 22426.0 |
| 2025-03-10 09:00:00 | MSFT | Stock | 387.5 | 387.5 | 385.23 | 385.71 | 30903.0 |
| 2025-03-10 09:30:00 | MSFT | Stock | 385.71 | 386.335 | 383.3 | 385.24 | 1973077.0 |
| 2025-03-10 10:00:00 | MSFT | Stock | 385.21 | 386.4 | 384.3136 | 384.95 | 1058233.0 |
| 2025-03-10 10:30:00 | MSFT | Stock | 384.89 | 385.6999 | 379.48 | 379.7678 | 1629123.0 |
| 2025-03-10 11:00:00 | MSFT | Stock | 379.745 | 381.84 | 378.91 | 380.68 | 1683077.0 |
| 2025-03-10 11:30:00 | MSFT | Stock | 380.73 | 382.2 | 380.215 | 380.878 | 1226087.0 |
| 2025-03-10 12:00:00 | MSFT | Stock | 380.81 | 382.41 | 380.66 | 381.9272 | 689650.0 |
| 2025-03-10 12:30:00 | MSFT | Stock | 381.99 | 382.64 | 380.15 | 380.93 | 750836.0 |
> showing 50 of 107,593 rows — these rows as CSV