PREVIEW / etf_30min / 2025-02-19
file: by_date/etf_30min/2025/2025-02-19.parquet size: 962 KB rows: 38,677
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 |
|---|---|---|---|---|---|---|---|
| 2025-02-19 04:00:00 | SPY | ETF | 611.75 | 611.96 | 611.72 | 611.96 | 4896.0 |
| 2025-02-19 04:30:00 | SPY | ETF | 611.94 | 611.94 | 611.49 | 611.54 | 7450.0 |
| 2025-02-19 05:00:00 | SPY | ETF | 611.57 | 611.57 | 610.87 | 610.91 | 10693.0 |
| 2025-02-19 05:30:00 | SPY | ETF | 610.86 | 610.91 | 610.61 | 610.84 | 7342.0 |
| 2025-02-19 06:00:00 | SPY | ETF | 610.69 | 610.75 | 610.45 | 610.47 | 27591.0 |
| 2025-02-19 06:30:00 | SPY | ETF | 610.52 | 610.52 | 610.19 | 610.52 | 12555.0 |
| 2025-02-19 07:00:00 | SPY | ETF | 610.54 | 611.14 | 610.5 | 611.0 | 33507.0 |
| 2025-02-19 07:30:00 | SPY | ETF | 610.99 | 611.23 | 610.73 | 610.73 | 29848.0 |
| 2025-02-19 08:00:00 | SPY | ETF | 610.5199 | 611.98 | 609.89 | 610.27 | 86345.0 |
| 2025-02-19 08:30:00 | SPY | ETF | 610.23 | 610.25 | 609.83 | 610.14 | 45024.0 |
| 2025-02-19 09:00:00 | SPY | ETF | 610.14 | 610.48 | 609.72 | 610.05 | 99661.0 |
| 2025-02-19 09:30:00 | SPY | ETF | 610.08 | 610.27 | 609.6845 | 609.92 | 1789296.0 |
| 2025-02-19 10:00:00 | SPY | ETF | 609.92 | 610.235 | 609.56 | 610.06 | 949895.0 |
| 2025-02-19 10:30:00 | SPY | ETF | 610.06 | 610.89 | 609.82 | 610.14 | 1229854.0 |
| 2025-02-19 11:00:00 | SPY | ETF | 610.14 | 611.26 | 610.14 | 611.18 | 938068.0 |
| 2025-02-19 11:30:00 | SPY | ETF | 611.17 | 611.77 | 610.98 | 611.7 | 787929.0 |
| 2025-02-19 12:00:00 | SPY | ETF | 611.66 | 611.96 | 611.01 | 611.05 | 719330.0 |
| 2025-02-19 12:30:00 | SPY | ETF | 611.06 | 611.82 | 610.86 | 611.56 | 647894.0 |
| 2025-02-19 13:00:00 | SPY | ETF | 611.56 | 611.7 | 610.65 | 611.66 | 684644.0 |
| 2025-02-19 13:30:00 | SPY | ETF | 611.67 | 612.04 | 611.48 | 611.49 | 773813.0 |
| 2025-02-19 14:00:00 | SPY | ETF | 611.52 | 613.08 | 611.4 | 612.8202 | 1685772.0 |
| 2025-02-19 14:30:00 | SPY | ETF | 612.82 | 613.23 | 612.6203 | 613.11 | 1014619.0 |
| 2025-02-19 15:00:00 | SPY | ETF | 613.08 | 613.1 | 611.8 | 612.0999 | 1426765.0 |
| 2025-02-19 15:30:00 | SPY | ETF | 612.11 | 613.06 | 612.08 | 612.9 | 3908652.0 |
| 2025-02-19 16:00:00 | SPY | ETF | 612.91 | 612.93 | 611.6841 | 612.05 | 1864844.0 |
| 2025-02-19 16:30:00 | SPY | ETF | 612.03 | 612.93 | 611.99 | 612.14 | 108428.0 |
| 2025-02-19 17:00:00 | SPY | ETF | 612.14 | 612.17 | 612.04 | 612.15 | 9764.0 |
| 2025-02-19 17:30:00 | SPY | ETF | 612.15 | 612.18 | 612.1 | 612.1 | 36318.0 |
| 2025-02-19 18:00:00 | SPY | ETF | 612.1 | 612.36 | 612.05 | 612.1 | 130041.0 |
| 2025-02-19 18:30:00 | SPY | ETF | 612.12 | 612.16 | 611.87 | 612.15 | 26742.0 |
| 2025-02-19 19:00:00 | SPY | ETF | 612.01 | 612.2 | 611.81 | 611.9088 | 4861.0 |
| 2025-02-19 19:30:00 | SPY | ETF | 611.9 | 612.3 | 611.81 | 612.3 | 5025.0 |
| 2025-02-19 04:00:00 | QQQ | ETF | 539.9 | 540.1 | 539.64 | 540.08 | 18753.0 |
| 2025-02-19 04:30:00 | QQQ | ETF | 540.0 | 540.0 | 539.5 | 539.6 | 3126.0 |
| 2025-02-19 05:00:00 | QQQ | ETF | 539.6 | 539.61 | 538.77 | 538.77 | 9404.0 |
| 2025-02-19 05:30:00 | QQQ | ETF | 538.87 | 539.0 | 538.6 | 538.9 | 7217.0 |
| 2025-02-19 06:00:00 | QQQ | ETF | 538.86 | 539.0 | 538.61 | 538.73 | 11490.0 |
| 2025-02-19 06:30:00 | QQQ | ETF | 538.81 | 538.85 | 538.38 | 538.71 | 14013.0 |
| 2025-02-19 07:00:00 | QQQ | ETF | 538.71 | 539.6 | 538.65 | 539.57 | 76041.0 |
| 2025-02-19 07:30:00 | QQQ | ETF | 539.37 | 539.77 | 539.15 | 539.15 | 26932.0 |
| 2025-02-19 08:00:00 | QQQ | ETF | 539.5 | 540.16 | 537.97 | 538.37 | 103178.0 |
| 2025-02-19 08:30:00 | QQQ | ETF | 538.34 | 538.67 | 538.0 | 538.55 | 71897.0 |
| 2025-02-19 09:00:00 | QQQ | ETF | 538.54 | 538.85 | 538.13 | 538.57 | 64701.0 |
| 2025-02-19 09:30:00 | QQQ | ETF | 538.57 | 538.94 | 537.33 | 537.6477 | 1418657.0 |
| 2025-02-19 10:00:00 | QQQ | ETF | 537.64 | 537.905 | 536.46 | 537.2 | 924797.0 |
| 2025-02-19 10:30:00 | QQQ | ETF | 537.21 | 538.61 | 537.12 | 537.5 | 1027765.0 |
| 2025-02-19 11:00:00 | QQQ | ETF | 537.49 | 538.99 | 537.47 | 538.84 | 911777.0 |
| 2025-02-19 11:30:00 | QQQ | ETF | 538.83 | 539.43 | 538.59 | 539.355 | 625780.0 |
| 2025-02-19 12:00:00 | QQQ | ETF | 539.34 | 539.71 | 538.68 | 538.895 | 784291.0 |
| 2025-02-19 12:30:00 | QQQ | ETF | 538.9 | 539.76 | 538.64 | 539.5 | 590475.0 |
> showing 50 of 38,677 rows — these rows as CSV