PREVIEW / etf_1hour / 2024-04-22
file: by_date/etf_1hour/2024/2024-04-22.parquet size: 537 KB rows: 20,077
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-04-22 04:00:00 | SPY | ETF | 496.7 | 497.18 | 496.51 | 497.0 | 19470.0 |
| 2024-04-22 05:00:00 | SPY | ETF | 496.97 | 498.13 | 496.97 | 497.83 | 45303.0 |
| 2024-04-22 06:00:00 | SPY | ETF | 497.9 | 498.28 | 497.61 | 497.72 | 47827.0 |
| 2024-04-22 07:00:00 | SPY | ETF | 497.74 | 498.4 | 496.64 | 498.07 | 313045.0 |
| 2024-04-22 08:00:00 | SPY | ETF | 498.31 | 498.34 | 496.34 | 498.0594 | 383705.0 |
| 2024-04-22 09:00:00 | SPY | ETF | 498.06 | 498.29 | 496.74 | 497.59 | 5507886.0 |
| 2024-04-22 10:00:00 | SPY | ETF | 497.5801 | 498.22 | 495.95 | 496.215 | 6353767.0 |
| 2024-04-22 11:00:00 | SPY | ETF | 496.21 | 497.41 | 495.43 | 497.39 | 6196501.0 |
| 2024-04-22 12:00:00 | SPY | ETF | 497.4 | 498.51 | 497.2701 | 498.41 | 4714243.0 |
| 2024-04-22 13:00:00 | SPY | ETF | 498.4176 | 501.905 | 498.24 | 501.43 | 7303761.0 |
| 2024-04-22 14:00:00 | SPY | ETF | 501.43 | 502.38 | 500.625 | 501.33 | 6752574.0 |
| 2024-04-22 15:00:00 | SPY | ETF | 501.34 | 501.36 | 498.905 | 499.63 | 13458320.0 |
| 2024-04-22 16:00:00 | SPY | ETF | 499.64 | 499.75 | 498.97 | 499.65 | 5412269.0 |
| 2024-04-22 17:00:00 | SPY | ETF | 499.7 | 500.0 | 499.68 | 499.9 | 84337.0 |
| 2024-04-22 18:00:00 | SPY | ETF | 499.9 | 500.16 | 499.38 | 499.6 | 175619.0 |
| 2024-04-22 19:00:00 | SPY | ETF | 499.59 | 499.65 | 498.67 | 499.35 | 86208.0 |
| 2024-04-22 04:00:00 | QQQ | ETF | 416.57 | 416.91 | 416.03 | 416.69 | 64500.0 |
| 2024-04-22 05:00:00 | QQQ | ETF | 416.68 | 417.58 | 416.66 | 417.45 | 48018.0 |
| 2024-04-22 06:00:00 | QQQ | ETF | 417.52 | 417.95 | 417.01 | 417.1 | 66913.0 |
| 2024-04-22 07:00:00 | QQQ | ETF | 417.1 | 417.58 | 416.56 | 417.1 | 350525.0 |
| 2024-04-22 08:00:00 | QQQ | ETF | 416.88 | 417.8604 | 414.96 | 417.49 | 527899.0 |
| 2024-04-22 09:00:00 | QQQ | ETF | 417.539 | 418.33 | 416.71 | 417.16 | 4661579.0 |
| 2024-04-22 10:00:00 | QQQ | ETF | 417.16 | 417.9099 | 414.34 | 414.825 | 5557752.0 |
| 2024-04-22 11:00:00 | QQQ | ETF | 414.79 | 416.48 | 413.94 | 416.41 | 3797097.0 |
| 2024-04-22 12:00:00 | QQQ | ETF | 416.4247 | 417.4899 | 416.0251 | 416.97 | 3231648.0 |
| 2024-04-22 13:00:00 | QQQ | ETF | 416.98 | 420.37 | 416.81 | 419.95 | 3753638.0 |
| 2024-04-22 14:00:00 | QQQ | ETF | 419.95 | 421.18 | 419.57 | 420.285 | 4448202.0 |
| 2024-04-22 15:00:00 | QQQ | ETF | 420.28 | 420.47 | 418.23 | 418.85 | 5700381.0 |
| 2024-04-22 16:00:00 | QQQ | ETF | 418.84 | 418.94 | 418.2 | 418.67 | 1916133.0 |
| 2024-04-22 17:00:00 | QQQ | ETF | 418.66 | 419.17 | 418.65 | 418.99 | 140625.0 |
| 2024-04-22 18:00:00 | QQQ | ETF | 418.96 | 419.32 | 418.35 | 418.5 | 101285.0 |
| 2024-04-22 19:00:00 | QQQ | ETF | 418.58 | 418.63 | 417.37 | 418.1 | 74726.0 |
| 2024-04-22 04:00:00 | IWM | ETF | 194.19 | 194.46 | 194.1 | 194.27 | 28121.0 |
| 2024-04-22 05:00:00 | IWM | ETF | 194.23 | 194.66 | 194.2 | 194.51 | 13607.0 |
| 2024-04-22 06:00:00 | IWM | ETF | 194.47 | 194.51 | 194.06 | 194.06 | 17135.0 |
| 2024-04-22 07:00:00 | IWM | ETF | 194.08 | 194.59 | 193.97 | 194.57 | 193577.0 |
| 2024-04-22 08:00:00 | IWM | ETF | 194.081 | 194.53 | 193.14 | 194.26 | 242004.0 |
| 2024-04-22 09:00:00 | IWM | ETF | 194.26 | 194.6 | 192.9 | 193.94 | 3414595.0 |
| 2024-04-22 10:00:00 | IWM | ETF | 193.94 | 194.4 | 193.68 | 193.73 | 2494831.0 |
| 2024-04-22 11:00:00 | IWM | ETF | 193.73 | 194.07 | 193.24 | 194.04 | 2568173.0 |
| 2024-04-22 12:00:00 | IWM | ETF | 194.04 | 194.86 | 193.88 | 194.84 | 2384906.0 |
| 2024-04-22 13:00:00 | IWM | ETF | 194.85 | 196.17 | 194.72 | 195.845 | 2512064.0 |
| 2024-04-22 14:00:00 | IWM | ETF | 195.85 | 196.295 | 195.56 | 195.92 | 2790658.0 |
| 2024-04-22 15:00:00 | IWM | ETF | 195.93 | 195.995 | 194.98 | 195.23 | 5266552.0 |
| 2024-04-22 16:00:00 | IWM | ETF | 195.3 | 195.4901 | 194.96 | 195.48 | 1528916.0 |
| 2024-04-22 17:00:00 | IWM | ETF | 195.44 | 195.58 | 195.37 | 195.4 | 12522.0 |
| 2024-04-22 18:00:00 | IWM | ETF | 195.47 | 195.6 | 195.11 | 195.33 | 13915.0 |
| 2024-04-22 19:00:00 | IWM | ETF | 195.28 | 195.35 | 195.02 | 195.32 | 30761.0 |
| 2024-04-22 04:00:00 | DIA | ETF | 381.03 | 381.03 | 381.0 | 381.0 | 300.0 |
| 2024-04-22 05:00:00 | DIA | ETF | 381.4 | 381.52 | 381.4 | 381.52 | 624.0 |
> showing 50 of 20,077 rows — these rows as CSV