PREVIEW / etf_30min / 2024-03-12
file: by_date/etf_30min/2024/2024-03-12.parquet size: 803 KB rows: 31,925
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-12 04:00:00 | SPY | ETF | 513.39 | 513.61 | 512.79 | 512.79 | 9734.0 |
| 2024-03-12 04:30:00 | SPY | ETF | 512.22 | 512.69 | 512.22 | 512.54 | 4275.0 |
| 2024-03-12 05:00:00 | SPY | ETF | 512.53 | 512.6 | 512.28 | 512.6 | 5048.0 |
| 2024-03-12 05:30:00 | SPY | ETF | 512.58 | 512.71 | 512.19 | 512.23 | 5593.0 |
| 2024-03-12 06:00:00 | SPY | ETF | 512.22 | 512.69 | 512.22 | 512.65 | 3665.0 |
| 2024-03-12 06:30:00 | SPY | ETF | 512.61 | 512.92 | 512.54 | 512.81 | 6330.0 |
| 2024-03-12 07:00:00 | SPY | ETF | 512.65 | 512.7 | 512.2 | 512.47 | 74461.0 |
| 2024-03-12 07:30:00 | SPY | ETF | 512.47 | 512.68 | 512.41 | 512.48 | 36373.0 |
| 2024-03-12 08:00:00 | SPY | ETF | 512.46 | 513.64 | 512.19 | 512.74 | 260465.0 |
| 2024-03-12 08:30:00 | SPY | ETF | 512.25 | 514.85 | 510.1 | 513.56 | 2105374.0 |
| 2024-03-12 09:00:00 | SPY | ETF | 513.58 | 513.7 | 512.43 | 513.49 | 653842.0 |
| 2024-03-12 09:30:00 | SPY | ETF | 513.45 | 513.8 | 510.86 | 513.44 | 7644958.0 |
| 2024-03-12 10:00:00 | SPY | ETF | 513.44 | 515.11 | 513.0 | 515.03 | 5279777.0 |
| 2024-03-12 10:30:00 | SPY | ETF | 515.06 | 516.485 | 515.052 | 515.94 | 5498445.0 |
| 2024-03-12 11:00:00 | SPY | ETF | 515.93 | 516.535 | 515.42 | 516.18 | 3156791.0 |
| 2024-03-12 11:30:00 | SPY | ETF | 516.18 | 516.3 | 515.18 | 515.88 | 3052045.0 |
| 2024-03-12 12:00:00 | SPY | ETF | 515.87 | 515.955 | 514.94 | 515.09 | 2076079.0 |
| 2024-03-12 12:30:00 | SPY | ETF | 515.095 | 515.17 | 513.55 | 514.4 | 3250784.0 |
| 2024-03-12 13:00:00 | SPY | ETF | 514.41 | 515.43 | 513.62 | 514.9182 | 2679332.0 |
| 2024-03-12 13:30:00 | SPY | ETF | 514.9298 | 515.8 | 514.89 | 515.6 | 1587689.0 |
| 2024-03-12 14:00:00 | SPY | ETF | 515.61 | 516.45 | 515.51 | 516.4304 | 2354227.0 |
| 2024-03-12 14:30:00 | SPY | ETF | 516.44 | 517.12 | 515.58 | 516.75 | 3492347.0 |
| 2024-03-12 15:00:00 | SPY | ETF | 516.7423 | 517.2 | 516.41 | 517.11 | 2929985.0 |
| 2024-03-12 15:30:00 | SPY | ETF | 517.12 | 517.38 | 516.525 | 516.81 | 7644641.0 |
| 2024-03-12 16:00:00 | SPY | ETF | 516.81 | 517.11 | 516.68 | 517.0 | 2573566.0 |
| 2024-03-12 16:30:00 | SPY | ETF | 517.0 | 517.05 | 516.66 | 516.66 | 418089.0 |
| 2024-03-12 17:00:00 | SPY | ETF | 516.7 | 516.8 | 516.68 | 516.77 | 29255.0 |
| 2024-03-12 17:30:00 | SPY | ETF | 516.77 | 516.77 | 516.62 | 516.67 | 14461.0 |
| 2024-03-12 18:00:00 | SPY | ETF | 516.62 | 516.95 | 516.49 | 516.95 | 131419.0 |
| 2024-03-12 18:30:00 | SPY | ETF | 516.951 | 517.02 | 516.87 | 516.87 | 12274.0 |
| 2024-03-12 19:00:00 | SPY | ETF | 516.84 | 517.18 | 516.84 | 517.12 | 8124.0 |
| 2024-03-12 19:30:00 | SPY | ETF | 517.1 | 517.16 | 516.92 | 517.01 | 35435.0 |
| 2024-03-12 04:00:00 | QQQ | ETF | 440.06 | 440.43 | 439.44 | 439.5 | 25264.0 |
| 2024-03-12 04:30:00 | QQQ | ETF | 439.4 | 439.52 | 438.92 | 439.17 | 28050.0 |
| 2024-03-12 05:00:00 | QQQ | ETF | 439.17 | 439.2 | 438.96 | 439.12 | 6517.0 |
| 2024-03-12 05:30:00 | QQQ | ETF | 439.41 | 439.41 | 438.97 | 438.97 | 7807.0 |
| 2024-03-12 06:00:00 | QQQ | ETF | 438.94 | 439.5 | 438.94 | 439.4 | 17349.0 |
| 2024-03-12 06:30:00 | QQQ | ETF | 439.29 | 439.65 | 439.29 | 439.52 | 22621.0 |
| 2024-03-12 07:00:00 | QQQ | ETF | 439.37 | 439.46 | 438.94 | 439.41 | 20472.0 |
| 2024-03-12 07:30:00 | QQQ | ETF | 439.37 | 439.59 | 439.3 | 439.36 | 52623.0 |
| 2024-03-12 08:00:00 | QQQ | ETF | 439.34 | 440.4996 | 437.062 | 439.23 | 198037.0 |
| 2024-03-12 08:30:00 | QQQ | ETF | 439.0 | 441.33 | 437.0 | 439.79 | 1084649.0 |
| 2024-03-12 09:00:00 | QQQ | ETF | 439.9 | 440.02 | 438.8 | 439.72 | 571685.0 |
| 2024-03-12 09:30:00 | QQQ | ETF | 439.74 | 440.4 | 436.46 | 439.335 | 5817460.0 |
| 2024-03-12 10:00:00 | QQQ | ETF | 439.315 | 441.05 | 438.87 | 440.99 | 4219201.0 |
| 2024-03-12 10:30:00 | QQQ | ETF | 441.0 | 442.95 | 441.0 | 442.32 | 4349482.0 |
| 2024-03-12 11:00:00 | QQQ | ETF | 442.36 | 443.2 | 441.81 | 443.15 | 2079457.0 |
| 2024-03-12 11:30:00 | QQQ | ETF | 443.17 | 443.1921 | 441.59 | 442.34 | 2006200.0 |
| 2024-03-12 12:00:00 | QQQ | ETF | 442.35 | 442.45 | 441.24 | 441.4801 | 1839258.0 |
| 2024-03-12 12:30:00 | QQQ | ETF | 441.485 | 441.6 | 440.07 | 440.81 | 2499538.0 |
> showing 50 of 31,925 rows — these rows as CSV