PREVIEW / etf_1hour / 2024-12-23
file: by_date/etf_1hour/2024/2024-12-23.parquet size: 614 KB rows: 23,706
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-23 04:00:00 | SPY | ETF | 593.58 | 593.58 | 592.46 | 592.74 | 47736.0 |
| 2024-12-23 05:00:00 | SPY | ETF | 592.7 | 592.9 | 591.47 | 591.73 | 20190.0 |
| 2024-12-23 06:00:00 | SPY | ETF | 591.35 | 591.35 | 590.16 | 590.41 | 48547.0 |
| 2024-12-23 07:00:00 | SPY | ETF | 590.46 | 591.92 | 590.46 | 591.78 | 176144.0 |
| 2024-12-23 08:00:00 | SPY | ETF | 590.68 | 594.0 | 589.34 | 589.88 | 394993.0 |
| 2024-12-23 09:00:00 | SPY | ETF | 589.85 | 591.77 | 589.18 | 590.45 | 3635074.0 |
| 2024-12-23 10:00:00 | SPY | ETF | 590.42 | 590.6099 | 587.661 | 589.08 | 3413949.0 |
| 2024-12-23 11:00:00 | SPY | ETF | 589.06 | 592.5699 | 588.96 | 592.51 | 3332237.0 |
| 2024-12-23 12:00:00 | SPY | ETF | 592.51 | 593.12 | 591.3401 | 592.5995 | 1841262.0 |
| 2024-12-23 13:00:00 | SPY | ETF | 592.595 | 593.93 | 592.41 | 593.67 | 2346705.0 |
| 2024-12-23 14:00:00 | SPY | ETF | 593.67 | 594.31 | 592.92 | 592.98 | 2696269.0 |
| 2024-12-23 15:00:00 | SPY | ETF | 592.93 | 595.3 | 592.25 | 594.78 | 10103039.0 |
| 2024-12-23 16:00:00 | SPY | ETF | 594.8 | 595.17 | 594.12 | 594.61 | 8051187.0 |
| 2024-12-23 17:00:00 | SPY | ETF | 594.6008 | 594.8 | 594.51 | 594.76 | 11252.0 |
| 2024-12-23 18:00:00 | SPY | ETF | 594.88 | 595.24 | 594.61 | 594.72 | 46701.0 |
| 2024-12-23 19:00:00 | SPY | ETF | 594.66 | 594.67 | 594.15 | 594.65 | 19347.0 |
| 2024-12-23 04:00:00 | QQQ | ETF | 520.9 | 521.15 | 520.23 | 520.43 | 138987.0 |
| 2024-12-23 05:00:00 | QQQ | ETF | 520.53 | 520.8 | 519.28 | 519.75 | 59406.0 |
| 2024-12-23 06:00:00 | QQQ | ETF | 519.63 | 519.63 | 518.3 | 518.72 | 88983.0 |
| 2024-12-23 07:00:00 | QQQ | ETF | 518.82 | 520.7 | 518.76 | 520.67 | 167018.0 |
| 2024-12-23 08:00:00 | QQQ | ETF | 518.91 | 522.37 | 517.73 | 518.26 | 317405.0 |
| 2024-12-23 09:00:00 | QQQ | ETF | 518.27 | 520.83 | 517.95 | 519.85 | 3029250.0 |
| 2024-12-23 10:00:00 | QQQ | ETF | 519.78 | 520.1 | 516.13 | 518.19 | 2613251.0 |
| 2024-12-23 11:00:00 | QQQ | ETF | 518.07 | 521.42 | 518.06 | 521.37 | 1866105.0 |
| 2024-12-23 12:00:00 | QQQ | ETF | 521.35 | 522.12 | 520.13 | 521.34 | 1611331.0 |
| 2024-12-23 13:00:00 | QQQ | ETF | 521.34 | 522.76 | 521.12 | 522.53 | 1691578.0 |
| 2024-12-23 14:00:00 | QQQ | ETF | 522.48 | 523.25 | 521.65 | 521.66 | 1933954.0 |
| 2024-12-23 15:00:00 | QQQ | ETF | 521.65 | 523.19 | 520.6837 | 522.92 | 4397808.0 |
| 2024-12-23 16:00:00 | QQQ | ETF | 522.93 | 523.2 | 520.512 | 522.51 | 1638524.0 |
| 2024-12-23 17:00:00 | QQQ | ETF | 522.45 | 522.75 | 522.41 | 522.7 | 10596.0 |
| 2024-12-23 18:00:00 | QQQ | ETF | 522.75 | 523.0 | 522.12 | 522.53 | 44612.0 |
| 2024-12-23 19:00:00 | QQQ | ETF | 522.33 | 522.49 | 521.87 | 522.41 | 60138.0 |
| 2024-12-23 04:00:00 | IWM | ETF | 222.72 | 222.72 | 222.26 | 222.55 | 43251.0 |
| 2024-12-23 05:00:00 | IWM | ETF | 222.51 | 222.58 | 221.9 | 221.92 | 17861.0 |
| 2024-12-23 06:00:00 | IWM | ETF | 221.74 | 221.8 | 221.0 | 221.25 | 29405.0 |
| 2024-12-23 07:00:00 | IWM | ETF | 221.49 | 222.09 | 221.46 | 221.991 | 42565.0 |
| 2024-12-23 08:00:00 | IWM | ETF | 221.68 | 223.62 | 221.01 | 221.4 | 171808.0 |
| 2024-12-23 09:00:00 | IWM | ETF | 221.29 | 222.4 | 220.35 | 220.665 | 2516496.0 |
| 2024-12-23 10:00:00 | IWM | ETF | 220.725 | 220.95 | 219.38 | 220.02 | 2995817.0 |
| 2024-12-23 11:00:00 | IWM | ETF | 220.0 | 221.36 | 219.93 | 221.36 | 2573018.0 |
| 2024-12-23 12:00:00 | IWM | ETF | 221.35 | 221.59 | 220.9 | 221.09 | 1306449.0 |
| 2024-12-23 13:00:00 | IWM | ETF | 221.06 | 221.385 | 220.61 | 221.04 | 2089268.0 |
| 2024-12-23 14:00:00 | IWM | ETF | 221.035 | 221.33 | 220.77 | 220.83 | 2163128.0 |
| 2024-12-23 15:00:00 | IWM | ETF | 220.83 | 221.6399 | 220.48 | 221.37 | 5450838.0 |
| 2024-12-23 16:00:00 | IWM | ETF | 221.41 | 221.71 | 221.18 | 221.41 | 1272636.0 |
| 2024-12-23 17:00:00 | IWM | ETF | 221.41 | 221.49 | 221.41 | 221.46 | 10349.0 |
| 2024-12-23 18:00:00 | IWM | ETF | 221.49 | 221.6 | 221.2966 | 221.36 | 27862.0 |
| 2024-12-23 19:00:00 | IWM | ETF | 221.33 | 221.46 | 221.13 | 221.46 | 10603.0 |
| 2024-12-23 04:00:00 | DIA | ETF | 429.03 | 429.21 | 428.89 | 429.07 | 1565.0 |
| 2024-12-23 05:00:00 | DIA | ETF | 428.97 | 428.97 | 428.39 | 428.39 | 3741.0 |
> showing 50 of 23,706 rows — these rows as CSV