PREVIEW / etf_1hour / 2024-11-18
file: by_date/etf_1hour/2024/2024-11-18.parquet size: 602 KB rows: 22,951
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-18 04:00:00 | SPY | ETF | 587.66 | 587.66 | 585.71 | 585.96 | 63647.0 |
| 2024-11-18 05:00:00 | SPY | ETF | 586.03 | 586.58 | 585.86 | 586.58 | 8914.0 |
| 2024-11-18 06:00:00 | SPY | ETF | 586.58 | 586.58 | 585.81 | 586.04 | 35455.0 |
| 2024-11-18 07:00:00 | SPY | ETF | 586.15 | 586.55 | 585.94 | 586.27 | 112410.0 |
| 2024-11-18 08:00:00 | SPY | ETF | 586.1483 | 587.75 | 584.79 | 586.15 | 268859.0 |
| 2024-11-18 09:00:00 | SPY | ETF | 586.24 | 586.73 | 585.34 | 585.72 | 2484204.0 |
| 2024-11-18 10:00:00 | SPY | ETF | 585.75 | 588.35 | 585.59 | 588.21 | 3456796.0 |
| 2024-11-18 11:00:00 | SPY | ETF | 588.23 | 589.49 | 587.9301 | 588.2805 | 2817516.0 |
| 2024-11-18 12:00:00 | SPY | ETF | 588.29 | 588.68 | 587.75 | 588.65 | 1709698.0 |
| 2024-11-18 13:00:00 | SPY | ETF | 588.65 | 588.65 | 587.02 | 588.36 | 1696482.0 |
| 2024-11-18 14:00:00 | SPY | ETF | 588.35 | 588.39 | 587.08 | 588.095 | 2106081.0 |
| 2024-11-18 15:00:00 | SPY | ETF | 588.08 | 588.41 | 587.5143 | 588.14 | 7014504.0 |
| 2024-11-18 16:00:00 | SPY | ETF | 588.15 | 588.32 | 587.77 | 588.03 | 1886901.0 |
| 2024-11-18 17:00:00 | SPY | ETF | 588.0 | 588.1 | 587.95 | 588.1 | 47809.0 |
| 2024-11-18 18:00:00 | SPY | ETF | 588.08 | 588.08 | 587.43 | 587.88 | 63111.0 |
| 2024-11-18 19:00:00 | SPY | ETF | 587.88 | 588.44 | 587.759 | 588.04 | 44722.0 |
| 2024-11-18 04:00:00 | QQQ | ETF | 500.04 | 500.04 | 497.89 | 498.17 | 112588.0 |
| 2024-11-18 05:00:00 | QQQ | ETF | 498.22 | 498.9 | 498.09 | 498.88 | 49525.0 |
| 2024-11-18 06:00:00 | QQQ | ETF | 498.94 | 498.94 | 498.1 | 498.47 | 43640.0 |
| 2024-11-18 07:00:00 | QQQ | ETF | 498.46 | 498.75 | 497.95 | 498.23 | 138367.0 |
| 2024-11-18 08:00:00 | QQQ | ETF | 498.4 | 500.4 | 496.3444 | 498.02 | 553988.0 |
| 2024-11-18 09:00:00 | QQQ | ETF | 498.08 | 498.88 | 496.73 | 497.44 | 3042857.0 |
| 2024-11-18 10:00:00 | QQQ | ETF | 497.45 | 501.45 | 497.27 | 501.1064 | 3226366.0 |
| 2024-11-18 11:00:00 | QQQ | ETF | 501.12 | 502.14 | 500.13 | 500.71 | 2717990.0 |
| 2024-11-18 12:00:00 | QQQ | ETF | 500.7151 | 500.89 | 499.61 | 500.68 | 1693971.0 |
| 2024-11-18 13:00:00 | QQQ | ETF | 500.66 | 500.85 | 499.125 | 500.6899 | 1818330.0 |
| 2024-11-18 14:00:00 | QQQ | ETF | 500.67 | 500.68 | 499.0 | 500.17 | 1822809.0 |
| 2024-11-18 15:00:00 | QQQ | ETF | 500.15 | 500.539 | 499.5 | 500.01 | 3261850.0 |
| 2024-11-18 16:00:00 | QQQ | ETF | 500.01 | 500.41 | 499.75 | 499.94 | 957556.0 |
| 2024-11-18 17:00:00 | QQQ | ETF | 499.99 | 500.16 | 499.86 | 500.02 | 91469.0 |
| 2024-11-18 18:00:00 | QQQ | ETF | 500.11 | 500.12 | 499.4 | 499.8 | 58655.0 |
| 2024-11-18 19:00:00 | QQQ | ETF | 499.8 | 500.48 | 499.64 | 499.92 | 75455.0 |
| 2024-11-18 04:00:00 | IWM | ETF | 229.01 | 229.42 | 228.82 | 229.23 | 24780.0 |
| 2024-11-18 05:00:00 | IWM | ETF | 229.21 | 229.95 | 229.16 | 229.9 | 24493.0 |
| 2024-11-18 06:00:00 | IWM | ETF | 229.88 | 229.92 | 228.97 | 229.23 | 18826.0 |
| 2024-11-18 07:00:00 | IWM | ETF | 229.25 | 229.57 | 229.1 | 229.3 | 47594.0 |
| 2024-11-18 08:00:00 | IWM | ETF | 229.5009 | 229.8304 | 228.69 | 229.2101 | 119576.0 |
| 2024-11-18 09:00:00 | IWM | ETF | 229.22 | 229.87 | 228.13 | 228.32 | 3737027.0 |
| 2024-11-18 10:00:00 | IWM | ETF | 228.34 | 230.52 | 228.25 | 230.0 | 2518123.0 |
| 2024-11-18 11:00:00 | IWM | ETF | 229.99 | 230.6 | 229.77 | 229.875 | 1960676.0 |
| 2024-11-18 12:00:00 | IWM | ETF | 229.88 | 230.135 | 229.53 | 229.85 | 1329758.0 |
| 2024-11-18 13:00:00 | IWM | ETF | 229.845 | 229.845 | 228.65 | 229.2691 | 1257926.0 |
| 2024-11-18 14:00:00 | IWM | ETF | 229.24 | 229.245 | 228.3 | 228.97 | 1639651.0 |
| 2024-11-18 15:00:00 | IWM | ETF | 228.95 | 229.52 | 228.825 | 228.95 | 3289800.0 |
| 2024-11-18 16:00:00 | IWM | ETF | 228.96 | 229.23 | 228.7407 | 229.15 | 914755.0 |
| 2024-11-18 17:00:00 | IWM | ETF | 229.16 | 229.33 | 229.12 | 229.16 | 15621.0 |
| 2024-11-18 18:00:00 | IWM | ETF | 229.16 | 229.16 | 228.57 | 229.02 | 46034.0 |
| 2024-11-18 19:00:00 | IWM | ETF | 229.03 | 229.4 | 228.9801 | 229.1396 | 12156.0 |
| 2024-11-18 04:00:00 | DIA | ETF | 433.48 | 433.91 | 433.3 | 433.68 | 5060.0 |
| 2024-11-18 05:00:00 | DIA | ETF | 433.45 | 433.73 | 433.4 | 433.67 | 1297.0 |
> showing 50 of 22,951 rows — these rows as CSV