PREVIEW / stock_30min / 2024-11-07
file: by_date/stock_30min/2024/2024-11-07.parquet size: 2.2 MB rows: 105,931 symbols: 716
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-11-07 04:00:00 | AAPL | Stock | 223.14 | 223.51 | 222.82 | 223.3 | 7972.0 |
| 2024-11-07 04:30:00 | AAPL | Stock | 223.4 | 223.4 | 223.28 | 223.32 | 2590.0 |
| 2024-11-07 05:00:00 | AAPL | Stock | 223.34 | 223.34 | 223.17 | 223.17 | 4085.0 |
| 2024-11-07 05:30:00 | AAPL | Stock | 223.18 | 223.2 | 223.1 | 223.15 | 2548.0 |
| 2024-11-07 06:00:00 | AAPL | Stock | 223.1 | 223.13 | 222.87 | 223.13 | 6046.0 |
| 2024-11-07 06:30:00 | AAPL | Stock | 223.01 | 223.01 | 222.93 | 223.0 | 2577.0 |
| 2024-11-07 07:00:00 | AAPL | Stock | 222.94 | 223.42 | 222.94 | 223.42 | 18369.0 |
| 2024-11-07 07:30:00 | AAPL | Stock | 223.38 | 223.55 | 223.36 | 223.42 | 13422.0 |
| 2024-11-07 08:00:00 | AAPL | Stock | 223.08 | 223.735 | 222.7814 | 223.66 | 80576.0 |
| 2024-11-07 08:30:00 | AAPL | Stock | 223.69 | 223.9392 | 223.42 | 223.78 | 51632.0 |
| 2024-11-07 09:00:00 | AAPL | Stock | 223.75 | 224.72 | 223.72 | 224.64 | 104975.0 |
| 2024-11-07 09:30:00 | AAPL | Stock | 224.63 | 226.55 | 224.57 | 226.3 | 5003136.0 |
| 2024-11-07 10:00:00 | AAPL | Stock | 226.3 | 226.35 | 225.36 | 225.72 | 2073463.0 |
| 2024-11-07 10:30:00 | AAPL | Stock | 225.75 | 226.23 | 225.35 | 226.23 | 1466253.0 |
| 2024-11-07 11:00:00 | AAPL | Stock | 226.23 | 226.42 | 225.78 | 226.305 | 1168674.0 |
| 2024-11-07 11:30:00 | AAPL | Stock | 226.3 | 227.1 | 226.17 | 227.07 | 1347611.0 |
| 2024-11-07 12:00:00 | AAPL | Stock | 227.062 | 227.42 | 226.76 | 227.215 | 1069793.0 |
| 2024-11-07 12:30:00 | AAPL | Stock | 227.21 | 227.49 | 227.12 | 227.2 | 861810.0 |
| 2024-11-07 13:00:00 | AAPL | Stock | 227.205 | 227.23 | 226.77 | 227.1033 | 944918.0 |
| 2024-11-07 13:30:00 | AAPL | Stock | 227.1 | 227.26 | 226.745 | 227.0989 | 692317.0 |
| 2024-11-07 14:00:00 | AAPL | Stock | 227.0999 | 227.39 | 226.79 | 227.1 | 814322.0 |
| 2024-11-07 14:30:00 | AAPL | Stock | 227.11 | 227.51 | 226.85 | 227.505 | 1055476.0 |
| 2024-11-07 15:00:00 | AAPL | Stock | 227.5 | 227.76 | 227.26 | 227.53 | 1338662.0 |
| 2024-11-07 15:30:00 | AAPL | Stock | 227.535 | 227.875 | 226.75 | 227.69 | 3970791.0 |
| 2024-11-07 16:00:00 | AAPL | Stock | 227.4917 | 227.95 | 227.39 | 227.7149 | 8265222.0 |
| 2024-11-07 16:30:00 | AAPL | Stock | 227.71 | 227.81 | 227.48 | 227.77 | 115974.0 |
| 2024-11-07 17:00:00 | AAPL | Stock | 227.71 | 227.75 | 227.48 | 227.55 | 378164.0 |
| 2024-11-07 17:30:00 | AAPL | Stock | 227.5201 | 227.6 | 227.5 | 227.6 | 10217.0 |
| 2024-11-07 18:00:00 | AAPL | Stock | 227.5 | 227.62 | 227.45 | 227.52 | 5693.0 |
| 2024-11-07 18:30:00 | AAPL | Stock | 227.54 | 227.72 | 227.45 | 227.4801 | 7134.0 |
| 2024-11-07 19:00:00 | AAPL | Stock | 227.52 | 227.7198 | 227.52 | 227.62 | 3499.0 |
| 2024-11-07 19:30:00 | AAPL | Stock | 227.61 | 227.69 | 227.5 | 227.6 | 9644.0 |
| 2024-11-07 04:00:00 | MSFT | Stock | 420.06 | 420.95 | 420.06 | 420.76 | 3856.0 |
| 2024-11-07 04:30:00 | MSFT | Stock | 420.94 | 420.94 | 420.63 | 420.65 | 1629.0 |
| 2024-11-07 05:00:00 | MSFT | Stock | 420.75 | 420.87 | 420.7 | 420.85 | 2389.0 |
| 2024-11-07 05:30:00 | MSFT | Stock | 420.83 | 421.3 | 420.8 | 421.3 | 3505.0 |
| 2024-11-07 06:00:00 | MSFT | Stock | 421.25 | 421.25 | 420.9 | 421.0 | 1100.0 |
| 2024-11-07 06:30:00 | MSFT | Stock | 420.9 | 421.0 | 420.75 | 421.0 | 1334.0 |
| 2024-11-07 07:00:00 | MSFT | Stock | 421.0 | 421.18 | 420.76 | 421.15 | 10553.0 |
| 2024-11-07 07:30:00 | MSFT | Stock | 421.2 | 421.24 | 421.0 | 421.22 | 2532.0 |
| 2024-11-07 08:00:00 | MSFT | Stock | 420.89 | 421.75 | 419.55 | 421.44 | 27020.0 |
| 2024-11-07 08:30:00 | MSFT | Stock | 421.4 | 421.54 | 421.0 | 421.52 | 12509.0 |
| 2024-11-07 09:00:00 | MSFT | Stock | 421.51 | 421.99 | 420.91 | 421.0 | 25872.0 |
| 2024-11-07 09:30:00 | MSFT | Stock | 421.28 | 422.45 | 419.88 | 421.895 | 1842934.0 |
| 2024-11-07 10:00:00 | MSFT | Stock | 421.99 | 423.18 | 421.64 | 422.7801 | 813408.0 |
| 2024-11-07 10:30:00 | MSFT | Stock | 422.815 | 424.43 | 421.68 | 423.73 | 693157.0 |
| 2024-11-07 11:00:00 | MSFT | Stock | 423.74 | 425.6282 | 423.67 | 425.54 | 757167.0 |
| 2024-11-07 11:30:00 | MSFT | Stock | 425.5599 | 426.42 | 425.1 | 425.54 | 533462.0 |
| 2024-11-07 12:00:00 | MSFT | Stock | 425.5799 | 425.59 | 424.0801 | 424.61 | 379236.0 |
| 2024-11-07 12:30:00 | MSFT | Stock | 424.61 | 424.795 | 423.77 | 424.355 | 343807.0 |
> showing 50 of 105,931 rows — these rows as CSV