PREVIEW / etf_1hour / 2024-09-18
file: by_date/etf_1hour/2024/2024-09-18.parquet size: 549 KB rows: 20,651
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-09-18 04:00:00 | SPY | ETF | 563.27 | 563.37 | 562.91 | 563.37 | 33401.0 |
| 2024-09-18 05:00:00 | SPY | ETF | 563.36 | 563.92 | 563.31 | 563.92 | 2385.0 |
| 2024-09-18 06:00:00 | SPY | ETF | 563.85 | 563.97 | 563.66 | 563.84 | 22676.0 |
| 2024-09-18 07:00:00 | SPY | ETF | 563.84 | 563.95 | 563.45 | 563.45 | 57164.0 |
| 2024-09-18 08:00:00 | SPY | ETF | 563.86 | 564.1 | 562.94 | 563.75 | 132032.0 |
| 2024-09-18 09:00:00 | SPY | ETF | 563.97 | 564.01 | 562.53 | 563.0 | 2283124.0 |
| 2024-09-18 10:00:00 | SPY | ETF | 563.02 | 563.35 | 562.13 | 562.8 | 2712951.0 |
| 2024-09-18 11:00:00 | SPY | ETF | 562.79 | 563.16 | 561.55 | 561.6406 | 1991955.0 |
| 2024-09-18 12:00:00 | SPY | ETF | 561.63 | 563.715 | 561.34 | 563.62 | 1680416.0 |
| 2024-09-18 13:00:00 | SPY | ETF | 563.63 | 564.275 | 562.85 | 563.15 | 2199075.0 |
| 2024-09-18 14:00:00 | SPY | ETF | 563.14 | 568.69 | 561.8 | 563.79 | 14389472.0 |
| 2024-09-18 15:00:00 | SPY | ETF | 563.81 | 565.86 | 560.83 | 561.33 | 11505911.0 |
| 2024-09-18 16:00:00 | SPY | ETF | 561.31 | 562.86 | 561.05 | 562.2835 | 4006073.0 |
| 2024-09-18 17:00:00 | SPY | ETF | 562.2 | 562.59 | 561.4 | 561.4 | 128873.0 |
| 2024-09-18 18:00:00 | SPY | ETF | 562.48 | 563.4676 | 562.44 | 563.0314 | 159372.0 |
| 2024-09-18 19:00:00 | SPY | ETF | 563.24 | 565.13 | 562.6 | 565.0 | 137760.0 |
| 2024-09-18 04:00:00 | QQQ | ETF | 473.98 | 473.99 | 473.01 | 473.65 | 41334.0 |
| 2024-09-18 05:00:00 | QQQ | ETF | 473.61 | 474.25 | 473.61 | 474.25 | 11626.0 |
| 2024-09-18 06:00:00 | QQQ | ETF | 474.32 | 474.33 | 473.99 | 474.3 | 60700.0 |
| 2024-09-18 07:00:00 | QQQ | ETF | 474.3 | 474.68 | 474.06 | 474.12 | 45941.0 |
| 2024-09-18 08:00:00 | QQQ | ETF | 474.34 | 474.73 | 473.13 | 474.61 | 209100.0 |
| 2024-09-18 09:00:00 | QQQ | ETF | 474.64 | 474.84 | 473.19 | 474.2 | 1857753.0 |
| 2024-09-18 10:00:00 | QQQ | ETF | 474.22 | 474.57 | 472.74 | 473.76 | 2189622.0 |
| 2024-09-18 11:00:00 | QQQ | ETF | 473.76 | 474.1896 | 471.31 | 471.5762 | 1915100.0 |
| 2024-09-18 12:00:00 | QQQ | ETF | 471.55 | 474.28 | 471.25 | 474.13 | 1667478.0 |
| 2024-09-18 13:00:00 | QQQ | ETF | 474.14 | 474.73 | 473.37 | 473.82 | 1820034.0 |
| 2024-09-18 14:00:00 | QQQ | ETF | 473.71 | 478.83 | 472.6 | 474.66 | 10467694.0 |
| 2024-09-18 15:00:00 | QQQ | ETF | 474.645 | 475.85 | 470.83 | 471.33 | 8861305.0 |
| 2024-09-18 16:00:00 | QQQ | ETF | 471.33 | 473.24 | 470.97 | 472.53 | 1337554.0 |
| 2024-09-18 17:00:00 | QQQ | ETF | 472.4998 | 472.62 | 471.44 | 471.44 | 85360.0 |
| 2024-09-18 18:00:00 | QQQ | ETF | 472.63 | 473.8 | 472.61 | 473.3 | 144595.0 |
| 2024-09-18 19:00:00 | QQQ | ETF | 473.36 | 475.989 | 472.78 | 475.55 | 152776.0 |
| 2024-09-18 04:00:00 | IWM | ETF | 219.5 | 219.6 | 219.38 | 219.6 | 10223.0 |
| 2024-09-18 05:00:00 | IWM | ETF | 219.42 | 219.57 | 219.42 | 219.54 | 1425.0 |
| 2024-09-18 06:00:00 | IWM | ETF | 219.63 | 219.91 | 219.54 | 219.54 | 30443.0 |
| 2024-09-18 07:00:00 | IWM | ETF | 219.6 | 219.6 | 219.33 | 219.39 | 21077.0 |
| 2024-09-18 08:00:00 | IWM | ETF | 219.5797 | 219.96 | 218.91 | 219.1 | 98759.0 |
| 2024-09-18 09:00:00 | IWM | ETF | 219.1 | 220.335 | 218.9725 | 219.51 | 2160393.0 |
| 2024-09-18 10:00:00 | IWM | ETF | 219.53 | 219.62 | 218.53 | 219.62 | 3029172.0 |
| 2024-09-18 11:00:00 | IWM | ETF | 219.62 | 219.86 | 218.37 | 218.52 | 1739960.0 |
| 2024-09-18 12:00:00 | IWM | ETF | 218.51 | 219.07 | 218.25 | 219.0 | 1567151.0 |
| 2024-09-18 13:00:00 | IWM | ETF | 219.0 | 219.735 | 218.72 | 219.121 | 2158999.0 |
| 2024-09-18 14:00:00 | IWM | ETF | 219.25 | 224.94 | 218.5 | 221.94 | 19882164.0 |
| 2024-09-18 15:00:00 | IWM | ETF | 221.92 | 222.57 | 219.1299 | 219.4 | 12142278.0 |
| 2024-09-18 16:00:00 | IWM | ETF | 219.45 | 220.13 | 219.35 | 219.88 | 1213970.0 |
| 2024-09-18 17:00:00 | IWM | ETF | 219.863 | 220.22 | 219.7 | 220.2 | 43319.0 |
| 2024-09-18 18:00:00 | IWM | ETF | 220.15 | 220.54 | 219.95 | 220.29 | 66419.0 |
| 2024-09-18 19:00:00 | IWM | ETF | 220.45 | 221.08 | 219.95 | 221.0 | 93131.0 |
| 2024-09-18 04:00:00 | DIA | ETF | 417.56 | 417.56 | 417.56 | 417.56 | 100.0 |
| 2024-09-18 07:00:00 | DIA | ETF | 417.8 | 417.8 | 417.8 | 417.8 | 125.0 |
> showing 50 of 20,651 rows — these rows as CSV