PREVIEW / stock_30min / 2024-04-24
file: by_date/stock_30min/2024/2024-04-24.parquet size: 2.0 MB rows: 96,568 symbols: 993
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-24 04:00:00 | AAPL | Stock | 167.19 | 167.77 | 167.15 | 167.2 | 14932.0 |
| 2024-04-24 04:30:00 | AAPL | Stock | 167.15 | 167.33 | 167.15 | 167.28 | 7446.0 |
| 2024-04-24 05:00:00 | AAPL | Stock | 167.19 | 167.36 | 167.19 | 167.23 | 5139.0 |
| 2024-04-24 05:30:00 | AAPL | Stock | 167.3 | 167.3 | 167.06 | 167.25 | 4682.0 |
| 2024-04-24 06:00:00 | AAPL | Stock | 167.2 | 167.23 | 167.12 | 167.2 | 6997.0 |
| 2024-04-24 06:30:00 | AAPL | Stock | 167.12 | 167.12 | 166.92 | 166.95 | 7048.0 |
| 2024-04-24 07:00:00 | AAPL | Stock | 167.01 | 167.03 | 166.32 | 166.58 | 42867.0 |
| 2024-04-24 07:30:00 | AAPL | Stock | 166.55 | 166.8 | 166.39 | 166.8 | 31167.0 |
| 2024-04-24 08:00:00 | AAPL | Stock | 166.96 | 167.72 | 166.48 | 166.78 | 64510.0 |
| 2024-04-24 08:30:00 | AAPL | Stock | 166.77 | 166.9 | 166.49 | 166.58 | 40470.0 |
| 2024-04-24 09:00:00 | AAPL | Stock | 166.55 | 166.65 | 166.13 | 166.52 | 70370.0 |
| 2024-04-24 09:30:00 | AAPL | Stock | 166.54 | 167.93 | 166.21 | 167.53 | 4701215.0 |
| 2024-04-24 10:00:00 | AAPL | Stock | 167.54 | 168.3 | 167.519 | 167.995 | 2760936.0 |
| 2024-04-24 10:30:00 | AAPL | Stock | 167.995 | 168.28 | 167.52 | 167.73 | 2091415.0 |
| 2024-04-24 11:00:00 | AAPL | Stock | 167.72 | 168.19 | 167.715 | 167.92 | 2000177.0 |
| 2024-04-24 11:30:00 | AAPL | Stock | 167.925 | 168.73 | 167.91 | 168.59 | 2637424.0 |
| 2024-04-24 12:00:00 | AAPL | Stock | 168.5903 | 169.28 | 168.25 | 168.725 | 2796031.0 |
| 2024-04-24 12:30:00 | AAPL | Stock | 168.725 | 168.85 | 168.11 | 168.355 | 1965832.0 |
| 2024-04-24 13:00:00 | AAPL | Stock | 168.3599 | 168.64 | 168.25 | 168.4617 | 1117075.0 |
| 2024-04-24 13:30:00 | AAPL | Stock | 168.47 | 169.29 | 168.46 | 169.1085 | 1732931.0 |
| 2024-04-24 14:00:00 | AAPL | Stock | 169.105 | 169.12 | 168.6901 | 168.75 | 1480370.0 |
| 2024-04-24 14:30:00 | AAPL | Stock | 168.75 | 168.755 | 168.28 | 168.45 | 1382072.0 |
| 2024-04-24 15:00:00 | AAPL | Stock | 168.45 | 169.09 | 168.3413 | 169.055 | 1710409.0 |
| 2024-04-24 15:30:00 | AAPL | Stock | 169.0541 | 169.3 | 168.62 | 168.95 | 4728204.0 |
| 2024-04-24 16:00:00 | AAPL | Stock | 169.02 | 169.24 | 168.03 | 168.7 | 7303288.0 |
| 2024-04-24 16:30:00 | AAPL | Stock | 168.66 | 169.26 | 168.59 | 168.91 | 197708.0 |
| 2024-04-24 17:00:00 | AAPL | Stock | 168.91 | 169.34 | 168.8005 | 169.02 | 240811.0 |
| 2024-04-24 17:30:00 | AAPL | Stock | 169.1 | 169.14 | 168.61 | 169.07 | 48405.0 |
| 2024-04-24 18:00:00 | AAPL | Stock | 169.16 | 169.5 | 169.05 | 169.42 | 29754.0 |
| 2024-04-24 18:30:00 | AAPL | Stock | 169.34 | 169.5 | 169.02 | 169.14 | 35376.0 |
| 2024-04-24 19:00:00 | AAPL | Stock | 169.11 | 169.34 | 169.05 | 169.34 | 30654.0 |
| 2024-04-24 19:30:00 | AAPL | Stock | 169.21 | 169.34 | 169.05 | 169.1 | 15792.0 |
| 2024-04-24 04:00:00 | MSFT | Stock | 410.13 | 410.13 | 409.05 | 409.61 | 12900.0 |
| 2024-04-24 04:30:00 | MSFT | Stock | 409.77 | 409.77 | 409.1 | 409.1 | 3930.0 |
| 2024-04-24 05:00:00 | MSFT | Stock | 409.1 | 409.21 | 409.1 | 409.21 | 393.0 |
| 2024-04-24 05:30:00 | MSFT | Stock | 409.24 | 409.51 | 408.74 | 408.75 | 4728.0 |
| 2024-04-24 06:00:00 | MSFT | Stock | 408.75 | 409.18 | 408.75 | 409.14 | 1020.0 |
| 2024-04-24 06:30:00 | MSFT | Stock | 409.43 | 409.8 | 409.33 | 409.66 | 5930.0 |
| 2024-04-24 07:00:00 | MSFT | Stock | 409.73 | 410.15 | 409.5 | 409.66 | 26621.0 |
| 2024-04-24 07:30:00 | MSFT | Stock | 409.74 | 409.94 | 409.13 | 409.47 | 7109.0 |
| 2024-04-24 08:00:00 | MSFT | Stock | 409.85 | 411.94 | 409.0043 | 410.4 | 34907.0 |
| 2024-04-24 08:30:00 | MSFT | Stock | 410.45 | 411.0 | 409.7 | 409.9 | 16556.0 |
| 2024-04-24 09:00:00 | MSFT | Stock | 409.8 | 410.78 | 409.21 | 409.3 | 18440.0 |
| 2024-04-24 09:30:00 | MSFT | Stock | 409.56 | 412.47 | 408.7 | 409.44 | 1459902.0 |
| 2024-04-24 10:00:00 | MSFT | Stock | 409.48 | 410.81 | 408.72 | 408.865 | 689025.0 |
| 2024-04-24 10:30:00 | MSFT | Stock | 408.89 | 409.645 | 408.76 | 409.0 | 552244.0 |
| 2024-04-24 11:00:00 | MSFT | Stock | 409.0 | 409.295 | 408.07 | 408.11 | 443714.0 |
| 2024-04-24 11:30:00 | MSFT | Stock | 408.18 | 408.62 | 407.07 | 407.185 | 333886.0 |
| 2024-04-24 12:00:00 | MSFT | Stock | 407.14 | 407.89 | 406.88 | 407.62 | 364642.0 |
| 2024-04-24 12:30:00 | MSFT | Stock | 407.57 | 408.09 | 406.78 | 407.925 | 331215.0 |
> showing 50 of 96,568 rows — these rows as CSV