PREVIEW / etf_30min / 2024-02-21
file: by_date/etf_30min/2024/2024-02-21.parquet size: 788 KB rows: 31,604
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-02-21 04:00:00 | SPY | ETF | 495.33 | 495.74 | 495.33 | 495.46 | 4679.0 |
| 2024-02-21 04:30:00 | SPY | ETF | 495.64 | 495.74 | 495.5 | 495.54 | 9357.0 |
| 2024-02-21 05:00:00 | SPY | ETF | 495.59 | 495.93 | 495.57 | 495.93 | 3779.0 |
| 2024-02-21 05:30:00 | SPY | ETF | 495.86 | 495.94 | 495.68 | 495.9 | 3393.0 |
| 2024-02-21 06:00:00 | SPY | ETF | 495.9 | 495.9 | 495.44 | 495.56 | 7421.0 |
| 2024-02-21 06:30:00 | SPY | ETF | 495.61 | 495.7 | 495.41 | 495.7 | 24360.0 |
| 2024-02-21 07:00:00 | SPY | ETF | 495.62 | 496.0 | 495.37 | 495.89 | 45806.0 |
| 2024-02-21 07:30:00 | SPY | ETF | 495.79 | 495.81 | 495.07 | 495.07 | 186387.0 |
| 2024-02-21 08:00:00 | SPY | ETF | 495.16 | 496.31 | 495.03 | 495.06 | 100737.0 |
| 2024-02-21 08:30:00 | SPY | ETF | 495.04 | 495.43 | 494.9 | 495.43 | 90115.0 |
| 2024-02-21 09:00:00 | SPY | ETF | 495.45 | 495.66 | 495.23 | 495.44 | 138774.0 |
| 2024-02-21 09:30:00 | SPY | ETF | 495.42 | 495.6803 | 494.91 | 495.26 | 3978560.0 |
| 2024-02-21 10:00:00 | SPY | ETF | 495.26 | 496.06 | 495.18 | 495.38 | 2382658.0 |
| 2024-02-21 10:30:00 | SPY | ETF | 495.37 | 495.54 | 495.05 | 495.285 | 2180701.0 |
| 2024-02-21 11:00:00 | SPY | ETF | 495.3 | 496.305 | 495.2703 | 495.7999 | 1760132.0 |
| 2024-02-21 11:30:00 | SPY | ETF | 495.81 | 496.14 | 495.51 | 495.98 | 1446219.0 |
| 2024-02-21 12:00:00 | SPY | ETF | 495.99 | 496.045 | 494.89 | 495.08 | 2184774.0 |
| 2024-02-21 12:30:00 | SPY | ETF | 495.09 | 495.645 | 494.615 | 495.5599 | 1637766.0 |
| 2024-02-21 13:00:00 | SPY | ETF | 495.56 | 495.75 | 494.41 | 495.29 | 2479858.0 |
| 2024-02-21 13:30:00 | SPY | ETF | 495.295 | 495.56 | 495.1 | 495.34 | 1353150.0 |
| 2024-02-21 14:00:00 | SPY | ETF | 495.33 | 496.09 | 494.24 | 494.68 | 3546738.0 |
| 2024-02-21 14:30:00 | SPY | ETF | 494.7 | 494.78 | 493.905 | 494.58 | 2937323.0 |
| 2024-02-21 15:00:00 | SPY | ETF | 494.6 | 494.655 | 493.56 | 494.43 | 3647409.0 |
| 2024-02-21 15:30:00 | SPY | ETF | 494.43 | 497.37 | 494.41 | 497.17 | 9593377.0 |
| 2024-02-21 16:00:00 | SPY | ETF | 497.16 | 499.07 | 494.96 | 498.94 | 3227161.0 |
| 2024-02-21 16:30:00 | SPY | ETF | 498.96 | 499.56 | 498.41 | 499.5 | 952646.0 |
| 2024-02-21 17:00:00 | SPY | ETF | 499.5 | 499.79 | 499.1 | 499.21 | 168846.0 |
| 2024-02-21 17:30:00 | SPY | ETF | 499.29 | 499.65 | 499.28 | 499.53 | 81199.0 |
| 2024-02-21 18:00:00 | SPY | ETF | 499.39 | 499.75 | 499.23 | 499.51 | 127947.0 |
| 2024-02-21 18:30:00 | SPY | ETF | 499.5 | 499.69 | 499.17 | 499.68 | 41631.0 |
| 2024-02-21 19:00:00 | SPY | ETF | 499.75 | 500.44 | 499.69 | 500.38 | 71294.0 |
| 2024-02-21 19:30:00 | SPY | ETF | 500.28 | 501.16 | 500.25 | 500.9 | 133620.0 |
| 2024-02-21 04:00:00 | QQQ | ETF | 425.17 | 425.61 | 425.15 | 425.27 | 31171.0 |
| 2024-02-21 04:30:00 | QQQ | ETF | 425.3 | 425.61 | 425.29 | 425.45 | 6913.0 |
| 2024-02-21 05:00:00 | QQQ | ETF | 425.34 | 425.96 | 425.34 | 425.89 | 30892.0 |
| 2024-02-21 05:30:00 | QQQ | ETF | 425.78 | 425.86 | 425.42 | 425.73 | 11676.0 |
| 2024-02-21 06:00:00 | QQQ | ETF | 425.6 | 425.67 | 425.15 | 425.32 | 15042.0 |
| 2024-02-21 06:30:00 | QQQ | ETF | 425.26 | 425.44 | 425.08 | 425.39 | 11201.0 |
| 2024-02-21 07:00:00 | QQQ | ETF | 425.4 | 425.56 | 424.58 | 425.4 | 67678.0 |
| 2024-02-21 07:30:00 | QQQ | ETF | 425.3 | 425.3 | 424.33 | 424.4 | 60615.0 |
| 2024-02-21 08:00:00 | QQQ | ETF | 424.6383 | 426.7 | 424.34 | 424.54 | 191515.0 |
| 2024-02-21 08:30:00 | QQQ | ETF | 424.52 | 424.83 | 424.23 | 424.75 | 123772.0 |
| 2024-02-21 09:00:00 | QQQ | ETF | 424.79 | 425.03 | 424.38 | 424.55 | 160132.0 |
| 2024-02-21 09:30:00 | QQQ | ETF | 424.55 | 424.96 | 423.445 | 424.06 | 3845749.0 |
| 2024-02-21 10:00:00 | QQQ | ETF | 424.04 | 425.2999 | 423.78 | 424.05 | 2394842.0 |
| 2024-02-21 10:30:00 | QQQ | ETF | 424.05 | 424.36 | 423.58 | 423.92 | 1597094.0 |
| 2024-02-21 11:00:00 | QQQ | ETF | 423.94 | 425.13 | 423.89 | 424.445 | 1534394.0 |
| 2024-02-21 11:30:00 | QQQ | ETF | 424.46 | 424.995 | 424.07 | 424.829 | 1296536.0 |
| 2024-02-21 12:00:00 | QQQ | ETF | 424.84 | 424.88 | 423.175 | 423.3701 | 1782601.0 |
| 2024-02-21 12:30:00 | QQQ | ETF | 423.39 | 424.28 | 423.13 | 424.145 | 1511465.0 |
> showing 50 of 31,604 rows — these rows as CSV