PREVIEW / etf_1hour / 2024-11-20
file: by_date/etf_1hour/2024/2024-11-20.parquet size: 594 KB rows: 22,164
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-11-20 04:00:00 | SPY | ETF | 591.57 | 592.01 | 591.21 | 591.42 | 41599.0 |
| 2024-11-20 05:00:00 | SPY | ETF | 591.44 | 591.44 | 590.45 | 590.75 | 19102.0 |
| 2024-11-20 06:00:00 | SPY | ETF | 590.78 | 591.29 | 590.63 | 591.03 | 34026.0 |
| 2024-11-20 07:00:00 | SPY | ETF | 591.0 | 591.72 | 590.95 | 591.66 | 43400.0 |
| 2024-11-20 08:00:00 | SPY | ETF | 591.11 | 592.03 | 590.84 | 591.0 | 199014.0 |
| 2024-11-20 09:00:00 | SPY | ETF | 590.96 | 590.96 | 587.4 | 587.43 | 3978078.0 |
| 2024-11-20 10:00:00 | SPY | ETF | 587.4 | 588.1566 | 584.63 | 587.41 | 5268136.0 |
| 2024-11-20 11:00:00 | SPY | ETF | 587.4 | 588.8 | 585.54 | 588.36 | 3208437.0 |
| 2024-11-20 12:00:00 | SPY | ETF | 588.34 | 588.69 | 586.1401 | 587.07 | 2350442.0 |
| 2024-11-20 13:00:00 | SPY | ETF | 587.06 | 587.72 | 586.15 | 586.8 | 1530442.0 |
| 2024-11-20 14:00:00 | SPY | ETF | 586.77 | 587.9 | 586.25 | 587.52 | 2653365.0 |
| 2024-11-20 15:00:00 | SPY | ETF | 587.48 | 590.79 | 587.23 | 590.51 | 8786423.0 |
| 2024-11-20 16:00:00 | SPY | ETF | 590.51 | 590.98 | 587.2893 | 590.57 | 2315471.0 |
| 2024-11-20 17:00:00 | SPY | ETF | 590.65 | 591.3 | 590.15 | 590.3703 | 156120.0 |
| 2024-11-20 18:00:00 | SPY | ETF | 590.37 | 590.85 | 589.49 | 590.6 | 80041.0 |
| 2024-11-20 19:00:00 | SPY | ETF | 590.63 | 590.69 | 588.47 | 588.51 | 62970.0 |
| 2024-11-20 04:00:00 | QQQ | ETF | 504.22 | 504.97 | 503.89 | 504.19 | 62699.0 |
| 2024-11-20 05:00:00 | QQQ | ETF | 503.96 | 504.21 | 503.25 | 503.78 | 32189.0 |
| 2024-11-20 06:00:00 | QQQ | ETF | 503.73 | 504.4 | 503.66 | 504.25 | 40253.0 |
| 2024-11-20 07:00:00 | QQQ | ETF | 504.17 | 504.84 | 504.08 | 504.78 | 67398.0 |
| 2024-11-20 08:00:00 | QQQ | ETF | 504.7 | 505.25 | 503.914 | 504.16 | 160935.0 |
| 2024-11-20 09:00:00 | QQQ | ETF | 504.04 | 504.12 | 499.8 | 499.83 | 3322822.0 |
| 2024-11-20 10:00:00 | QQQ | ETF | 499.9 | 500.58 | 496.555 | 500.14 | 4984040.0 |
| 2024-11-20 11:00:00 | QQQ | ETF | 500.13 | 502.09 | 498.24 | 501.63 | 2829350.0 |
| 2024-11-20 12:00:00 | QQQ | ETF | 501.62 | 502.05 | 499.01 | 499.68 | 1916504.0 |
| 2024-11-20 13:00:00 | QQQ | ETF | 499.69 | 500.26 | 498.47 | 499.275 | 1544361.0 |
| 2024-11-20 14:00:00 | QQQ | ETF | 499.222 | 500.2 | 498.5 | 499.75 | 1329341.0 |
| 2024-11-20 15:00:00 | QQQ | ETF | 499.6575 | 503.48 | 499.4 | 503.19 | 3287322.0 |
| 2024-11-20 16:00:00 | QQQ | ETF | 503.17 | 504.0 | 499.48 | 502.9 | 1561870.0 |
| 2024-11-20 17:00:00 | QQQ | ETF | 502.98 | 503.6313 | 502.13 | 502.86 | 236349.0 |
| 2024-11-20 18:00:00 | QQQ | ETF | 502.72 | 503.38 | 501.72 | 503.21 | 153539.0 |
| 2024-11-20 19:00:00 | QQQ | ETF | 503.27 | 503.28 | 500.73 | 500.73 | 113188.0 |
| 2024-11-20 04:00:00 | IWM | ETF | 231.21 | 231.48 | 230.71 | 230.74 | 22253.0 |
| 2024-11-20 05:00:00 | IWM | ETF | 230.78 | 230.9 | 230.29 | 230.46 | 19529.0 |
| 2024-11-20 06:00:00 | IWM | ETF | 230.55 | 230.6 | 230.2 | 230.42 | 35486.0 |
| 2024-11-20 07:00:00 | IWM | ETF | 230.39 | 231.0 | 230.29 | 230.98 | 47130.0 |
| 2024-11-20 08:00:00 | IWM | ETF | 230.4701 | 231.4696 | 230.31 | 230.43 | 112625.0 |
| 2024-11-20 09:00:00 | IWM | ETF | 230.48 | 230.63 | 228.96 | 229.32 | 2925279.0 |
| 2024-11-20 10:00:00 | IWM | ETF | 229.28 | 230.2805 | 228.04 | 230.18 | 3037224.0 |
| 2024-11-20 11:00:00 | IWM | ETF | 230.22 | 230.24 | 228.92 | 229.96 | 1530482.0 |
| 2024-11-20 12:00:00 | IWM | ETF | 229.95 | 230.07 | 229.029 | 229.52 | 1387995.0 |
| 2024-11-20 13:00:00 | IWM | ETF | 229.5 | 229.84 | 228.87 | 229.19 | 1193533.0 |
| 2024-11-20 14:00:00 | IWM | ETF | 229.19 | 229.7999 | 228.89 | 229.62 | 809887.0 |
| 2024-11-20 15:00:00 | IWM | ETF | 229.615 | 230.91 | 229.43 | 230.87 | 3655367.0 |
| 2024-11-20 16:00:00 | IWM | ETF | 230.87 | 231.22 | 230.56 | 231.02 | 1031315.0 |
| 2024-11-20 17:00:00 | IWM | ETF | 231.07 | 231.29 | 230.83 | 230.95 | 63813.0 |
| 2024-11-20 18:00:00 | IWM | ETF | 230.83 | 231.21 | 230.58 | 231.18 | 44001.0 |
| 2024-11-20 19:00:00 | IWM | ETF | 231.08 | 231.08 | 230.06 | 230.17 | 34990.0 |
| 2024-11-20 04:00:00 | DIA | ETF | 434.3 | 434.3 | 434.3 | 434.3 | 210.0 |
| 2024-11-20 05:00:00 | DIA | ETF | 433.45 | 433.45 | 433.45 | 433.45 | 300.0 |
> showing 50 of 22,164 rows — these rows as CSV