PREVIEW / etf_1hour / 2024-12-30
file: by_date/etf_1hour/2024/2024-12-30.parquet size: 630 KB rows: 24,323
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-30 04:00:00 | SPY | ETF | 593.45 | 593.69 | 593.34 | 593.54 | 20639.0 |
| 2024-12-30 05:00:00 | SPY | ETF | 593.41 | 593.69 | 593.41 | 593.54 | 6758.0 |
| 2024-12-30 06:00:00 | SPY | ETF | 593.56 | 593.85 | 593.51 | 593.51 | 12649.0 |
| 2024-12-30 07:00:00 | SPY | ETF | 593.6 | 593.61 | 588.71 | 589.42 | 340148.0 |
| 2024-12-30 08:00:00 | SPY | ETF | 589.41 | 593.95 | 586.91 | 587.35 | 588668.0 |
| 2024-12-30 09:00:00 | SPY | ETF | 587.42 | 588.33 | 585.19 | 585.22 | 4748540.0 |
| 2024-12-30 10:00:00 | SPY | ETF | 585.21 | 587.4 | 584.41 | 587.11 | 5883503.0 |
| 2024-12-30 11:00:00 | SPY | ETF | 587.08 | 589.63 | 586.41 | 589.295 | 3084516.0 |
| 2024-12-30 12:00:00 | SPY | ETF | 589.28 | 591.47 | 589.1501 | 591.09 | 2534389.0 |
| 2024-12-30 13:00:00 | SPY | ETF | 591.05 | 591.74 | 589.97 | 591.1 | 1592622.0 |
| 2024-12-30 14:00:00 | SPY | ETF | 591.12 | 591.27 | 589.42 | 590.92 | 2595267.0 |
| 2024-12-30 15:00:00 | SPY | ETF | 590.9 | 591.21 | 588.07 | 588.23 | 7277301.0 |
| 2024-12-30 16:00:00 | SPY | ETF | 588.25 | 588.44 | 587.35 | 588.05 | 2349182.0 |
| 2024-12-30 17:00:00 | SPY | ETF | 588.03 | 588.2549 | 587.82 | 587.85 | 910139.0 |
| 2024-12-30 18:00:00 | SPY | ETF | 587.85 | 587.9 | 587.08 | 587.85 | 66550.0 |
| 2024-12-30 19:00:00 | SPY | ETF | 587.86 | 587.94 | 587.27 | 587.3 | 43410.0 |
| 2024-12-30 04:00:00 | QQQ | ETF | 521.45 | 521.57 | 520.7 | 521.35 | 45252.0 |
| 2024-12-30 05:00:00 | QQQ | ETF | 521.14 | 521.62 | 521.11 | 521.41 | 18735.0 |
| 2024-12-30 06:00:00 | QQQ | ETF | 521.39 | 521.69 | 521.13 | 521.26 | 26556.0 |
| 2024-12-30 07:00:00 | QQQ | ETF | 521.26 | 521.32 | 516.42 | 517.25 | 241596.0 |
| 2024-12-30 08:00:00 | QQQ | ETF | 520.98 | 522.2 | 514.38 | 514.86 | 543010.0 |
| 2024-12-30 09:00:00 | QQQ | ETF | 514.86 | 515.94 | 512.54 | 512.64 | 3678765.0 |
| 2024-12-30 10:00:00 | QQQ | ETF | 512.62 | 515.4 | 511.83 | 514.74 | 3120876.0 |
| 2024-12-30 11:00:00 | QQQ | ETF | 514.69 | 517.0 | 513.9579 | 516.79 | 2302424.0 |
| 2024-12-30 12:00:00 | QQQ | ETF | 516.76 | 519.3 | 516.485 | 518.9401 | 2628280.0 |
| 2024-12-30 13:00:00 | QQQ | ETF | 518.94 | 519.36 | 517.4 | 518.72 | 2128191.0 |
| 2024-12-30 14:00:00 | QQQ | ETF | 518.71 | 518.85 | 517.13 | 518.41 | 2237423.0 |
| 2024-12-30 15:00:00 | QQQ | ETF | 518.41 | 518.76 | 515.47 | 515.57 | 4593980.0 |
| 2024-12-30 16:00:00 | QQQ | ETF | 515.58 | 515.75 | 514.18 | 515.0 | 1787008.0 |
| 2024-12-30 17:00:00 | QQQ | ETF | 515.04 | 515.61 | 514.7 | 514.81 | 444882.0 |
| 2024-12-30 18:00:00 | QQQ | ETF | 514.83 | 515.13 | 514.02 | 515.101 | 98503.0 |
| 2024-12-30 19:00:00 | QQQ | ETF | 515.13 | 515.36 | 514.52 | 514.56 | 102850.0 |
| 2024-12-30 04:00:00 | IWM | ETF | 220.0 | 222.25 | 220.0 | 222.1 | 62903.0 |
| 2024-12-30 05:00:00 | IWM | ETF | 222.11 | 222.38 | 222.08 | 222.2 | 7617.0 |
| 2024-12-30 06:00:00 | IWM | ETF | 222.29 | 222.5 | 222.25 | 222.37 | 11995.0 |
| 2024-12-30 07:00:00 | IWM | ETF | 222.4 | 222.52 | 220.66 | 221.02 | 135464.0 |
| 2024-12-30 08:00:00 | IWM | ETF | 222.3414 | 222.45 | 219.97 | 220.13 | 223662.0 |
| 2024-12-30 09:00:00 | IWM | ETF | 220.14 | 220.68 | 218.02 | 218.14 | 2320556.0 |
| 2024-12-30 10:00:00 | IWM | ETF | 218.13 | 219.37 | 217.85 | 219.3475 | 2846418.0 |
| 2024-12-30 11:00:00 | IWM | ETF | 219.335 | 220.6201 | 219.08 | 220.43 | 2892145.0 |
| 2024-12-30 12:00:00 | IWM | ETF | 220.42 | 221.37 | 220.34 | 221.22 | 2042151.0 |
| 2024-12-30 13:00:00 | IWM | ETF | 221.24 | 221.78 | 220.88 | 221.57 | 1756325.0 |
| 2024-12-30 14:00:00 | IWM | ETF | 221.58 | 221.81 | 220.83 | 221.23 | 1616514.0 |
| 2024-12-30 15:00:00 | IWM | ETF | 221.22 | 221.75 | 220.6 | 220.67 | 2586037.0 |
| 2024-12-30 16:00:00 | IWM | ETF | 220.68 | 220.76 | 220.39 | 220.6101 | 900882.0 |
| 2024-12-30 17:00:00 | IWM | ETF | 220.62 | 220.75 | 220.46 | 220.6 | 105379.0 |
| 2024-12-30 18:00:00 | IWM | ETF | 220.6 | 220.6499 | 220.1625 | 220.58 | 6623.0 |
| 2024-12-30 19:00:00 | IWM | ETF | 220.62 | 220.63 | 220.25 | 220.26 | 31691.0 |
| 2024-12-30 04:00:00 | DIA | ETF | 428.94 | 429.33 | 428.93 | 429.28 | 2053.0 |
| 2024-12-30 05:00:00 | DIA | ETF | 429.11 | 429.21 | 429.11 | 429.21 | 226.0 |
> showing 50 of 24,323 rows — these rows as CSV