PREVIEW / etf_1hour / 2024-12-18
file: by_date/etf_1hour/2024/2024-12-18.parquet size: 626 KB rows: 24,289
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-12-18 04:00:00 | SPY | ETF | 604.89 | 605.42 | 604.87 | 605.31 | 11386.0 |
| 2024-12-18 05:00:00 | SPY | ETF | 605.52 | 605.95 | 605.52 | 605.88 | 15056.0 |
| 2024-12-18 06:00:00 | SPY | ETF | 605.9 | 606.02 | 605.74 | 605.74 | 16526.0 |
| 2024-12-18 07:00:00 | SPY | ETF | 605.74 | 606.15 | 605.56 | 606.13 | 127161.0 |
| 2024-12-18 08:00:00 | SPY | ETF | 606.11 | 606.15 | 604.71 | 604.73 | 243800.0 |
| 2024-12-18 09:00:00 | SPY | ETF | 604.72 | 604.74 | 603.47 | 604.6099 | 2620438.0 |
| 2024-12-18 10:00:00 | SPY | ETF | 604.61 | 606.405 | 604.49 | 605.96 | 2755928.0 |
| 2024-12-18 11:00:00 | SPY | ETF | 605.9604 | 606.255 | 604.63 | 605.76 | 2912727.0 |
| 2024-12-18 12:00:00 | SPY | ETF | 605.765 | 606.31 | 605.22 | 605.57 | 2593689.0 |
| 2024-12-18 13:00:00 | SPY | ETF | 605.5136 | 605.67 | 605.1311 | 605.47 | 2140033.0 |
| 2024-12-18 14:00:00 | SPY | ETF | 605.54 | 605.54 | 596.09 | 596.44 | 11472861.0 |
| 2024-12-18 15:00:00 | SPY | ETF | 596.455 | 596.91 | 585.89 | 586.3 | 29923477.0 |
| 2024-12-18 16:00:00 | SPY | ETF | 586.32 | 586.8 | 583.161 | 586.28 | 13228673.0 |
| 2024-12-18 17:00:00 | SPY | ETF | 586.37 | 587.29 | 586.21 | 587.1 | 453544.0 |
| 2024-12-18 18:00:00 | SPY | ETF | 587.19 | 588.06 | 586.44 | 586.7784 | 430493.0 |
| 2024-12-18 19:00:00 | SPY | ETF | 586.9 | 587.92 | 586.74 | 587.82 | 209015.0 |
| 2024-12-18 04:00:00 | QQQ | ETF | 536.8 | 536.88 | 535.92 | 536.77 | 40631.0 |
| 2024-12-18 05:00:00 | QQQ | ETF | 536.73 | 537.33 | 536.67 | 537.18 | 21516.0 |
| 2024-12-18 06:00:00 | QQQ | ETF | 537.2 | 537.5 | 536.99 | 537.12 | 34325.0 |
| 2024-12-18 07:00:00 | QQQ | ETF | 537.18 | 537.66 | 537.04 | 537.46 | 251698.0 |
| 2024-12-18 08:00:00 | QQQ | ETF | 537.05 | 537.65 | 535.25 | 535.27 | 169654.0 |
| 2024-12-18 09:00:00 | QQQ | ETF | 535.3088 | 535.68 | 533.46 | 535.32 | 1991697.0 |
| 2024-12-18 10:00:00 | QQQ | ETF | 535.37 | 536.8799 | 534.98 | 536.13 | 1531118.0 |
| 2024-12-18 11:00:00 | QQQ | ETF | 536.12 | 536.61 | 534.5 | 535.8199 | 1654293.0 |
| 2024-12-18 12:00:00 | QQQ | ETF | 535.7 | 536.2 | 535.13 | 535.69 | 785795.0 |
| 2024-12-18 13:00:00 | QQQ | ETF | 535.68 | 535.97 | 535.0725 | 535.45 | 853241.0 |
| 2024-12-18 14:00:00 | QQQ | ETF | 535.5678 | 535.5678 | 526.34 | 526.6 | 7766289.0 |
| 2024-12-18 15:00:00 | QQQ | ETF | 526.6 | 527.0802 | 515.01 | 516.53 | 18640065.0 |
| 2024-12-18 16:00:00 | QQQ | ETF | 516.52 | 516.98 | 512.08 | 515.55 | 4482049.0 |
| 2024-12-18 17:00:00 | QQQ | ETF | 515.64 | 517.28 | 515.58 | 517.16 | 457979.0 |
| 2024-12-18 18:00:00 | QQQ | ETF | 517.1 | 518.0 | 515.84 | 516.2 | 252432.0 |
| 2024-12-18 19:00:00 | QQQ | ETF | 516.3 | 517.8 | 516.16 | 517.79 | 146947.0 |
| 2024-12-18 04:00:00 | IWM | ETF | 231.49 | 231.66 | 231.25 | 231.66 | 11643.0 |
| 2024-12-18 05:00:00 | IWM | ETF | 231.65 | 232.17 | 231.65 | 232.17 | 11161.0 |
| 2024-12-18 06:00:00 | IWM | ETF | 232.41 | 232.41 | 232.15 | 232.26 | 14104.0 |
| 2024-12-18 07:00:00 | IWM | ETF | 232.28 | 233.27 | 232.23 | 233.2 | 65937.0 |
| 2024-12-18 08:00:00 | IWM | ETF | 233.21 | 233.23 | 231.41 | 232.99 | 123448.0 |
| 2024-12-18 09:00:00 | IWM | ETF | 232.88 | 233.04 | 231.78 | 232.0899 | 2156188.0 |
| 2024-12-18 10:00:00 | IWM | ETF | 232.08 | 232.39 | 231.4001 | 232.2334 | 2327322.0 |
| 2024-12-18 11:00:00 | IWM | ETF | 232.22 | 232.465 | 231.43 | 231.7999 | 1814540.0 |
| 2024-12-18 12:00:00 | IWM | ETF | 231.78 | 232.1206 | 231.38 | 231.95 | 1105955.0 |
| 2024-12-18 13:00:00 | IWM | ETF | 231.955 | 233.076 | 231.9501 | 232.86 | 1793918.0 |
| 2024-12-18 14:00:00 | IWM | ETF | 232.82 | 232.9794 | 224.4806 | 224.83 | 10817554.0 |
| 2024-12-18 15:00:00 | IWM | ETF | 224.79 | 225.28 | 218.92 | 220.9211 | 15658850.0 |
| 2024-12-18 16:00:00 | IWM | ETF | 220.9211 | 221.29 | 219.18 | 220.61 | 2519591.0 |
| 2024-12-18 17:00:00 | IWM | ETF | 220.75 | 221.07 | 220.6728 | 220.9993 | 105699.0 |
| 2024-12-18 18:00:00 | IWM | ETF | 220.96 | 221.3099 | 220.14 | 220.35 | 130013.0 |
| 2024-12-18 19:00:00 | IWM | ETF | 220.53 | 221.2299 | 220.37 | 221.09 | 84543.0 |
| 2024-12-18 04:00:00 | DIA | ETF | 436.21 | 436.34 | 436.18 | 436.19 | 5540.0 |
| 2024-12-18 05:00:00 | DIA | ETF | 436.36 | 436.67 | 436.35 | 436.64 | 2732.0 |
> showing 50 of 24,289 rows — these rows as CSV