PREVIEW / etf_30min / 2024-03-14
file: by_date/etf_30min/2024/2024-03-14.parquet size: 786 KB rows: 31,494
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-14 04:00:00 | SPY | ETF | 517.0 | 518.0 | 517.0 | 517.96 | 37448.0 |
| 2024-03-14 04:30:00 | SPY | ETF | 517.85 | 517.95 | 517.7 | 517.7 | 5251.0 |
| 2024-03-14 05:00:00 | SPY | ETF | 517.91 | 518.0 | 517.77 | 517.91 | 5129.0 |
| 2024-03-14 05:30:00 | SPY | ETF | 518.0 | 518.12 | 517.87 | 517.88 | 5146.0 |
| 2024-03-14 06:00:00 | SPY | ETF | 518.0 | 518.05 | 517.8 | 518.02 | 7382.0 |
| 2024-03-14 06:30:00 | SPY | ETF | 518.0 | 518.0 | 517.73 | 517.96 | 1416.0 |
| 2024-03-14 07:00:00 | SPY | ETF | 517.94 | 518.32 | 517.82 | 518.03 | 57716.0 |
| 2024-03-14 07:30:00 | SPY | ETF | 517.971 | 517.98 | 517.78 | 517.85 | 49367.0 |
| 2024-03-14 08:00:00 | SPY | ETF | 517.87 | 518.31 | 516.71 | 517.92 | 138705.0 |
| 2024-03-14 08:30:00 | SPY | ETF | 518.07 | 518.13 | 516.87 | 517.15 | 532450.0 |
| 2024-03-14 09:00:00 | SPY | ETF | 517.15 | 517.55 | 516.58 | 516.95 | 327073.0 |
| 2024-03-14 09:30:00 | SPY | ETF | 516.97 | 517.125 | 513.95 | 513.98 | 6970967.0 |
| 2024-03-14 10:00:00 | SPY | ETF | 513.99 | 515.305 | 513.35 | 515.0501 | 5732841.0 |
| 2024-03-14 10:30:00 | SPY | ETF | 515.06 | 515.61 | 514.115 | 514.64 | 3770441.0 |
| 2024-03-14 11:00:00 | SPY | ETF | 514.64 | 515.41 | 514.06 | 514.39 | 3668452.0 |
| 2024-03-14 11:30:00 | SPY | ETF | 514.39 | 515.05 | 514.08 | 514.99 | 2620211.0 |
| 2024-03-14 12:00:00 | SPY | ETF | 514.99 | 515.15 | 513.84 | 514.7 | 2903456.0 |
| 2024-03-14 12:30:00 | SPY | ETF | 514.71 | 514.98 | 513.86 | 513.9 | 2200006.0 |
| 2024-03-14 13:00:00 | SPY | ETF | 513.9 | 514.08 | 513.05 | 513.18 | 2839282.0 |
| 2024-03-14 13:30:00 | SPY | ETF | 513.19 | 514.6 | 512.76 | 514.53 | 3040833.0 |
| 2024-03-14 14:00:00 | SPY | ETF | 514.54 | 515.19 | 514.515 | 514.655 | 3400937.0 |
| 2024-03-14 14:30:00 | SPY | ETF | 514.67 | 514.89 | 513.84 | 513.8916 | 3481921.0 |
| 2024-03-14 15:00:00 | SPY | ETF | 513.89 | 513.89 | 512.18 | 512.63 | 6291479.0 |
| 2024-03-14 15:30:00 | SPY | ETF | 512.64 | 514.98 | 511.82 | 514.95 | 20910965.0 |
| 2024-03-14 16:00:00 | SPY | ETF | 514.94 | 515.16 | 514.2145 | 514.76 | 4030638.0 |
| 2024-03-14 16:30:00 | SPY | ETF | 514.77 | 515.06 | 514.553 | 514.74 | 1165503.0 |
| 2024-03-14 17:00:00 | SPY | ETF | 514.76 | 514.95 | 514.52 | 514.54 | 68496.0 |
| 2024-03-14 17:30:00 | SPY | ETF | 514.5413 | 514.95 | 514.31 | 514.42 | 56017.0 |
| 2024-03-14 18:00:00 | SPY | ETF | 514.4 | 514.66 | 514.4 | 514.66 | 73868.0 |
| 2024-03-14 18:30:00 | SPY | ETF | 514.65 | 514.67 | 514.43 | 514.43 | 35222.0 |
| 2024-03-14 19:00:00 | SPY | ETF | 514.44 | 514.44 | 514.04 | 514.04 | 17924.0 |
| 2024-03-14 19:30:00 | SPY | ETF | 514.05 | 514.25 | 513.93 | 514.25 | 24590.0 |
| 2024-03-14 04:00:00 | QQQ | ETF | 442.05 | 442.76 | 442.0 | 442.45 | 70363.0 |
| 2024-03-14 04:30:00 | QQQ | ETF | 442.45 | 442.55 | 442.2 | 442.5 | 12551.0 |
| 2024-03-14 05:00:00 | QQQ | ETF | 442.42 | 442.71 | 442.4 | 442.5 | 14023.0 |
| 2024-03-14 05:30:00 | QQQ | ETF | 442.56 | 442.66 | 442.37 | 442.5 | 9062.0 |
| 2024-03-14 06:00:00 | QQQ | ETF | 442.51 | 442.62 | 442.33 | 442.54 | 14890.0 |
| 2024-03-14 06:30:00 | QQQ | ETF | 442.5 | 442.52 | 442.16 | 442.31 | 29525.0 |
| 2024-03-14 07:00:00 | QQQ | ETF | 442.35 | 442.61 | 442.08 | 442.3 | 68476.0 |
| 2024-03-14 07:30:00 | QQQ | ETF | 442.32 | 442.32 | 441.87 | 441.97 | 107916.0 |
| 2024-03-14 08:00:00 | QQQ | ETF | 442.0 | 442.6199 | 440.58 | 442.42 | 119393.0 |
| 2024-03-14 08:30:00 | QQQ | ETF | 442.34 | 442.46 | 440.94 | 441.38 | 369361.0 |
| 2024-03-14 09:00:00 | QQQ | ETF | 441.31 | 441.82 | 440.72 | 441.46 | 202177.0 |
| 2024-03-14 09:30:00 | QQQ | ETF | 441.5 | 442.03 | 438.02 | 438.29 | 5532536.0 |
| 2024-03-14 10:00:00 | QQQ | ETF | 438.24 | 440.13 | 437.39 | 440.055 | 3489891.0 |
| 2024-03-14 10:30:00 | QQQ | ETF | 440.03 | 440.73 | 439.15 | 439.71 | 3122632.0 |
| 2024-03-14 11:00:00 | QQQ | ETF | 439.76 | 440.62 | 438.875 | 439.2 | 2475366.0 |
| 2024-03-14 11:30:00 | QQQ | ETF | 439.23 | 439.94 | 438.85 | 439.77 | 1561702.0 |
| 2024-03-14 12:00:00 | QQQ | ETF | 439.77 | 440.04 | 438.34 | 439.24 | 1881066.0 |
| 2024-03-14 12:30:00 | QQQ | ETF | 439.2253 | 439.82 | 438.48 | 438.5701 | 1698174.0 |
> showing 50 of 31,494 rows — these rows as CSV