PREVIEW / stock_30min / 2024-10-07
file: by_date/stock_30min/2024/2024-10-07.parquet size: 2.1 MB rows: 101,564 symbols: 760
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-10-07 04:00:00 | AAPL | Stock | 224.88 | 224.88 | 223.7 | 224.52 | 38753.0 |
| 2024-10-07 04:30:00 | AAPL | Stock | 224.53 | 224.92 | 224.0 | 224.0 | 16483.0 |
| 2024-10-07 05:00:00 | AAPL | Stock | 224.0 | 224.0 | 223.0 | 223.37 | 25548.0 |
| 2024-10-07 05:30:00 | AAPL | Stock | 223.31 | 223.7 | 223.31 | 223.7 | 13205.0 |
| 2024-10-07 06:00:00 | AAPL | Stock | 223.6 | 223.65 | 223.41 | 223.49 | 9782.0 |
| 2024-10-07 06:30:00 | AAPL | Stock | 223.49 | 223.68 | 223.48 | 223.62 | 16635.0 |
| 2024-10-07 07:00:00 | AAPL | Stock | 223.65 | 224.1 | 223.49 | 223.95 | 63712.0 |
| 2024-10-07 07:30:00 | AAPL | Stock | 223.84 | 224.29 | 223.84 | 224.17 | 24841.0 |
| 2024-10-07 08:00:00 | AAPL | Stock | 223.85 | 226.233 | 223.58 | 224.66 | 124451.0 |
| 2024-10-07 08:30:00 | AAPL | Stock | 224.72 | 225.0 | 224.3333 | 224.65 | 57811.0 |
| 2024-10-07 09:00:00 | AAPL | Stock | 224.64 | 225.68 | 224.33 | 224.49 | 148358.0 |
| 2024-10-07 09:30:00 | AAPL | Stock | 224.5 | 225.41 | 224.05 | 225.065 | 3452342.0 |
| 2024-10-07 10:00:00 | AAPL | Stock | 225.03 | 225.54 | 224.42 | 225.32 | 2194368.0 |
| 2024-10-07 10:30:00 | AAPL | Stock | 225.315 | 225.69 | 225.04 | 225.31 | 1089696.0 |
| 2024-10-07 11:00:00 | AAPL | Stock | 225.31 | 225.31 | 224.48 | 225.08 | 1159260.0 |
| 2024-10-07 11:30:00 | AAPL | Stock | 225.071 | 225.28 | 224.71 | 224.89 | 803675.0 |
| 2024-10-07 12:00:00 | AAPL | Stock | 224.89 | 224.93 | 224.07 | 224.26 | 1156471.0 |
| 2024-10-07 12:30:00 | AAPL | Stock | 224.25 | 224.42 | 223.892 | 223.9575 | 987198.0 |
| 2024-10-07 13:00:00 | AAPL | Stock | 223.96 | 224.57 | 223.81 | 223.81 | 948928.0 |
| 2024-10-07 13:30:00 | AAPL | Stock | 223.82 | 224.06 | 223.4 | 223.8598 | 1013150.0 |
| 2024-10-07 14:00:00 | AAPL | Stock | 223.86 | 223.985 | 223.55 | 223.7499 | 760271.0 |
| 2024-10-07 14:30:00 | AAPL | Stock | 223.73 | 223.73 | 222.23 | 222.33 | 2105572.0 |
| 2024-10-07 15:00:00 | AAPL | Stock | 222.32 | 222.785 | 222.22 | 222.565 | 1214710.0 |
| 2024-10-07 15:30:00 | AAPL | Stock | 222.564 | 222.63 | 221.33 | 221.72 | 3603528.0 |
| 2024-10-07 16:00:00 | AAPL | Stock | 221.69 | 221.98 | 221.61 | 221.89 | 7296025.0 |
| 2024-10-07 16:30:00 | AAPL | Stock | 221.84 | 222.03 | 221.69 | 221.84 | 83325.0 |
| 2024-10-07 17:00:00 | AAPL | Stock | 221.69 | 222.01 | 221.69 | 222.009 | 70398.0 |
| 2024-10-07 17:30:00 | AAPL | Stock | 221.97 | 222.0044 | 221.93 | 221.99 | 3052.0 |
| 2024-10-07 18:00:00 | AAPL | Stock | 222.0 | 222.06 | 221.88 | 221.948 | 6606.0 |
| 2024-10-07 18:30:00 | AAPL | Stock | 221.91 | 221.98 | 221.22 | 221.47 | 37930.0 |
| 2024-10-07 19:00:00 | AAPL | Stock | 221.38 | 222.05 | 221.38 | 221.75 | 13285.0 |
| 2024-10-07 19:30:00 | AAPL | Stock | 221.6535 | 221.94 | 221.6535 | 221.8 | 10372.0 |
| 2024-10-07 04:00:00 | MSFT | Stock | 415.8 | 416.1 | 415.7 | 415.86 | 3120.0 |
| 2024-10-07 04:30:00 | MSFT | Stock | 415.85 | 415.87 | 415.46 | 415.46 | 1413.0 |
| 2024-10-07 05:00:00 | MSFT | Stock | 415.11 | 415.2 | 414.76 | 414.76 | 2352.0 |
| 2024-10-07 05:30:00 | MSFT | Stock | 414.6 | 414.88 | 414.0 | 414.88 | 4169.0 |
| 2024-10-07 06:00:00 | MSFT | Stock | 414.8 | 414.85 | 414.8 | 414.85 | 394.0 |
| 2024-10-07 06:30:00 | MSFT | Stock | 414.9 | 414.9 | 414.89 | 414.89 | 300.0 |
| 2024-10-07 07:00:00 | MSFT | Stock | 414.81 | 415.0 | 414.45 | 414.45 | 11493.0 |
| 2024-10-07 07:30:00 | MSFT | Stock | 414.45 | 414.46 | 414.16 | 414.35 | 9030.0 |
| 2024-10-07 08:00:00 | MSFT | Stock | 414.8 | 416.15 | 414.16 | 414.35 | 29326.0 |
| 2024-10-07 08:30:00 | MSFT | Stock | 414.41 | 414.88 | 414.35 | 414.35 | 9024.0 |
| 2024-10-07 09:00:00 | MSFT | Stock | 414.44 | 416.5 | 414.35 | 415.99 | 33107.0 |
| 2024-10-07 09:30:00 | MSFT | Stock | 416.0 | 417.11 | 414.2 | 414.67 | 1920507.0 |
| 2024-10-07 10:00:00 | MSFT | Stock | 414.7 | 416.19 | 414.66 | 415.82 | 889122.0 |
| 2024-10-07 10:30:00 | MSFT | Stock | 415.83 | 416.37 | 415.44 | 415.7 | 590866.0 |
| 2024-10-07 11:00:00 | MSFT | Stock | 415.6694 | 415.91 | 414.69 | 415.4 | 567625.0 |
| 2024-10-07 11:30:00 | MSFT | Stock | 415.415 | 415.62 | 414.86 | 415.03 | 286628.0 |
| 2024-10-07 12:00:00 | MSFT | Stock | 415.03 | 415.05 | 413.96 | 414.425 | 476372.0 |
| 2024-10-07 12:30:00 | MSFT | Stock | 414.43 | 414.46 | 413.0814 | 413.24 | 587545.0 |
> showing 50 of 101,564 rows — these rows as CSV