PREVIEW / stock_30min / 2024-03-15
file: by_date/stock_30min/2024/2024-03-15.parquet size: 2.1 MB rows: 100,400 symbols: 1,066
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-15 04:00:00 | AAPL | Stock | 173.41 | 173.61 | 173.21 | 173.55 | 5969.0 |
| 2024-03-15 04:30:00 | AAPL | Stock | 173.64 | 173.64 | 173.47 | 173.49 | 2093.0 |
| 2024-03-15 05:00:00 | AAPL | Stock | 173.49 | 173.73 | 173.49 | 173.68 | 4174.0 |
| 2024-03-15 05:30:00 | AAPL | Stock | 173.72 | 174.21 | 173.72 | 174.18 | 17156.0 |
| 2024-03-15 06:00:00 | AAPL | Stock | 174.15 | 174.25 | 174.11 | 174.11 | 4710.0 |
| 2024-03-15 06:30:00 | AAPL | Stock | 174.04 | 174.09 | 173.85 | 173.85 | 4267.0 |
| 2024-03-15 07:00:00 | AAPL | Stock | 173.82 | 173.88 | 173.65 | 173.7 | 14973.0 |
| 2024-03-15 07:30:00 | AAPL | Stock | 173.67 | 173.92 | 173.4 | 173.4 | 18954.0 |
| 2024-03-15 08:00:00 | AAPL | Stock | 173.86 | 173.94 | 173.37 | 173.64 | 70995.0 |
| 2024-03-15 08:30:00 | AAPL | Stock | 173.63 | 173.8085 | 173.42 | 173.68 | 39275.0 |
| 2024-03-15 09:00:00 | AAPL | Stock | 173.65 | 173.66 | 170.05 | 171.52 | 1290784.0 |
| 2024-03-15 09:30:00 | AAPL | Stock | 171.17 | 172.48 | 171.0 | 171.45 | 16270734.0 |
| 2024-03-15 10:00:00 | AAPL | Stock | 171.44 | 171.605 | 170.564 | 170.6101 | 3881519.0 |
| 2024-03-15 10:30:00 | AAPL | Stock | 170.6181 | 170.98 | 170.285 | 170.7 | 3632026.0 |
| 2024-03-15 11:00:00 | AAPL | Stock | 170.7 | 171.17 | 170.6111 | 170.955 | 3085612.0 |
| 2024-03-15 11:30:00 | AAPL | Stock | 170.955 | 171.11 | 170.73 | 170.985 | 2261869.0 |
| 2024-03-15 12:00:00 | AAPL | Stock | 170.98 | 171.48 | 170.855 | 171.315 | 2317603.0 |
| 2024-03-15 12:30:00 | AAPL | Stock | 171.31 | 171.515 | 170.66 | 170.7073 | 2001974.0 |
| 2024-03-15 13:00:00 | AAPL | Stock | 170.705 | 170.89 | 170.6 | 170.695 | 1943939.0 |
| 2024-03-15 13:30:00 | AAPL | Stock | 170.7 | 171.14 | 170.52 | 171.1274 | 2202807.0 |
| 2024-03-15 14:00:00 | AAPL | Stock | 171.125 | 171.25 | 170.8 | 171.215 | 2505168.0 |
| 2024-03-15 14:30:00 | AAPL | Stock | 171.215 | 171.52 | 171.0899 | 171.52 | 3097398.0 |
| 2024-03-15 15:00:00 | AAPL | Stock | 171.5256 | 171.99 | 171.47 | 171.865 | 2632853.0 |
| 2024-03-15 15:30:00 | AAPL | Stock | 171.856 | 172.6 | 171.478 | 172.56 | 7370837.0 |
| 2024-03-15 16:00:00 | AAPL | Stock | 172.57 | 172.65 | 172.4 | 172.5 | 37326365.0 |
| 2024-03-15 16:30:00 | AAPL | Stock | 172.49 | 172.51 | 172.27 | 172.49 | 99410.0 |
| 2024-03-15 17:00:00 | AAPL | Stock | 172.51 | 172.62 | 172.42 | 172.42 | 61908.0 |
| 2024-03-15 17:30:00 | AAPL | Stock | 172.39 | 172.62 | 172.29 | 172.29 | 12377.0 |
| 2024-03-15 18:00:00 | AAPL | Stock | 172.3 | 172.39 | 172.25 | 172.3 | 17888.0 |
| 2024-03-15 18:30:00 | AAPL | Stock | 172.4 | 172.6 | 172.35 | 172.59 | 28128.0 |
| 2024-03-15 19:00:00 | AAPL | Stock | 172.59 | 172.74 | 172.59 | 172.65 | 19865.0 |
| 2024-03-15 19:30:00 | AAPL | Stock | 172.63 | 172.7 | 172.63 | 172.63 | 10277.0 |
| 2024-03-15 04:00:00 | MSFT | Stock | 426.33 | 427.58 | 426.0 | 427.4 | 2988.0 |
| 2024-03-15 04:30:00 | MSFT | Stock | 427.51 | 427.78 | 427.24 | 427.3 | 2371.0 |
| 2024-03-15 05:00:00 | MSFT | Stock | 427.38 | 427.92 | 427.3 | 427.84 | 7530.0 |
| 2024-03-15 05:30:00 | MSFT | Stock | 427.96 | 428.79 | 427.96 | 428.5 | 1462.0 |
| 2024-03-15 06:00:00 | MSFT | Stock | 428.5 | 428.9 | 428.5 | 428.75 | 5783.0 |
| 2024-03-15 06:30:00 | MSFT | Stock | 428.71 | 428.95 | 428.59 | 428.73 | 2151.0 |
| 2024-03-15 07:00:00 | MSFT | Stock | 428.5 | 428.55 | 428.05 | 428.05 | 6518.0 |
| 2024-03-15 07:30:00 | MSFT | Stock | 428.0 | 428.01 | 427.2 | 427.25 | 9225.0 |
| 2024-03-15 08:00:00 | MSFT | Stock | 428.39 | 428.78 | 426.27 | 427.15 | 40211.0 |
| 2024-03-15 08:30:00 | MSFT | Stock | 427.2 | 427.9 | 426.7468 | 427.25 | 22394.0 |
| 2024-03-15 09:00:00 | MSFT | Stock | 427.013 | 427.013 | 417.0 | 419.28 | 740023.0 |
| 2024-03-15 09:30:00 | MSFT | Stock | 419.29 | 422.6 | 417.0 | 418.4194 | 8156661.0 |
| 2024-03-15 10:00:00 | MSFT | Stock | 418.45 | 419.19 | 415.76 | 417.5301 | 1588147.0 |
| 2024-03-15 10:30:00 | MSFT | Stock | 417.59 | 419.3 | 416.4046 | 418.08 | 1125548.0 |
| 2024-03-15 11:00:00 | MSFT | Stock | 418.14 | 418.39 | 416.13 | 416.84 | 713430.0 |
| 2024-03-15 11:30:00 | MSFT | Stock | 416.82 | 417.0 | 415.08 | 415.235 | 843000.0 |
| 2024-03-15 12:00:00 | MSFT | Stock | 415.25 | 415.83 | 413.83 | 414.0888 | 888670.0 |
| 2024-03-15 12:30:00 | MSFT | Stock | 414.0697 | 414.66 | 412.79 | 413.2076 | 899100.0 |
> showing 50 of 100,400 rows — these rows as CSV