PREVIEW / etf_1hour / 2024-01-11
file: by_date/etf_1hour/2024/2024-01-11.parquet size: 532 KB rows: 19,473
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-01-11 04:00:00 | SPY | ETF | 478.46 | 478.47 | 477.5 | 477.72 | 27752.0 |
| 2024-01-11 05:00:00 | SPY | ETF | 477.61 | 477.7 | 477.24 | 477.25 | 18375.0 |
| 2024-01-11 06:00:00 | SPY | ETF | 477.53 | 477.71 | 477.3 | 477.45 | 61707.0 |
| 2024-01-11 07:00:00 | SPY | ETF | 477.47 | 477.77 | 477.04 | 477.47 | 186519.0 |
| 2024-01-11 08:00:00 | SPY | ETF | 477.5199 | 478.5 | 475.2 | 475.61 | 2197479.0 |
| 2024-01-11 09:00:00 | SPY | ETF | 475.68 | 478.12 | 475.57 | 476.32 | 7757513.0 |
| 2024-01-11 10:00:00 | SPY | ETF | 476.32 | 476.38 | 473.57 | 473.99 | 10051559.0 |
| 2024-01-11 11:00:00 | SPY | ETF | 474.0 | 474.28 | 472.26 | 472.6133 | 8241481.0 |
| 2024-01-11 12:00:00 | SPY | ETF | 472.63 | 474.355 | 472.55 | 473.96 | 5546363.0 |
| 2024-01-11 13:00:00 | SPY | ETF | 473.95 | 475.82 | 473.88 | 475.7588 | 6650366.0 |
| 2024-01-11 14:00:00 | SPY | ETF | 475.76 | 476.979 | 475.32 | 476.81 | 6815338.0 |
| 2024-01-11 15:00:00 | SPY | ETF | 476.83 | 476.92 | 475.465 | 476.32 | 11812366.0 |
| 2024-01-11 16:00:00 | SPY | ETF | 476.32 | 476.4 | 475.98 | 476.07 | 3642579.0 |
| 2024-01-11 17:00:00 | SPY | ETF | 476.1 | 476.3 | 475.92 | 476.04 | 80846.0 |
| 2024-01-11 18:00:00 | SPY | ETF | 475.97 | 476.25 | 475.79 | 476.03 | 59243.0 |
| 2024-01-11 19:00:00 | SPY | ETF | 476.07 | 476.19 | 475.39 | 475.46 | 58040.0 |
| 2024-01-11 04:00:00 | QQQ | ETF | 410.64 | 411.19 | 410.1 | 410.3 | 97945.0 |
| 2024-01-11 05:00:00 | QQQ | ETF | 410.25 | 410.37 | 410.02 | 410.3 | 29247.0 |
| 2024-01-11 06:00:00 | QQQ | ETF | 410.31 | 410.72 | 410.15 | 410.4 | 45041.0 |
| 2024-01-11 07:00:00 | QQQ | ETF | 410.37 | 410.6 | 410.22 | 410.29 | 104192.0 |
| 2024-01-11 08:00:00 | QQQ | ETF | 410.3701 | 411.36 | 407.6 | 407.87 | 1652747.0 |
| 2024-01-11 09:00:00 | QQQ | ETF | 407.94 | 411.2004 | 407.84 | 409.15 | 6128265.0 |
| 2024-01-11 10:00:00 | QQQ | ETF | 409.19 | 409.255 | 405.96 | 406.697 | 8235879.0 |
| 2024-01-11 11:00:00 | QQQ | ETF | 406.7 | 406.96 | 404.242 | 404.73 | 6735083.0 |
| 2024-01-11 12:00:00 | QQQ | ETF | 404.73 | 406.765 | 404.69 | 406.31 | 3862915.0 |
| 2024-01-11 13:00:00 | QQQ | ETF | 406.28 | 408.65 | 406.22 | 408.58 | 3602780.0 |
| 2024-01-11 14:00:00 | QQQ | ETF | 408.585 | 409.78 | 408.13 | 409.555 | 3514154.0 |
| 2024-01-11 15:00:00 | QQQ | ETF | 409.5974 | 409.65 | 408.38 | 409.34 | 5413459.0 |
| 2024-01-11 16:00:00 | QQQ | ETF | 409.34 | 409.43 | 407.7416 | 409.18 | 1258224.0 |
| 2024-01-11 17:00:00 | QQQ | ETF | 409.2 | 409.25 | 409.0 | 409.04 | 42369.0 |
| 2024-01-11 18:00:00 | QQQ | ETF | 409.09 | 409.28 | 408.8 | 409.02 | 55612.0 |
| 2024-01-11 19:00:00 | QQQ | ETF | 408.99 | 409.3 | 408.49 | 408.55 | 86105.0 |
| 2024-01-11 04:00:00 | IWM | ETF | 196.28 | 196.33 | 195.51 | 195.51 | 32149.0 |
| 2024-01-11 05:00:00 | IWM | ETF | 195.49 | 195.55 | 195.26 | 195.26 | 16598.0 |
| 2024-01-11 06:00:00 | IWM | ETF | 195.38 | 195.64 | 195.3 | 195.54 | 100814.0 |
| 2024-01-11 07:00:00 | IWM | ETF | 195.58 | 196.37 | 195.5 | 196.0 | 412102.0 |
| 2024-01-11 08:00:00 | IWM | ETF | 196.0 | 197.09 | 193.35 | 193.67 | 2619436.0 |
| 2024-01-11 09:00:00 | IWM | ETF | 193.67 | 194.74 | 193.44 | 193.51 | 4675736.0 |
| 2024-01-11 10:00:00 | IWM | ETF | 193.52 | 193.53 | 191.35 | 192.04 | 8262897.0 |
| 2024-01-11 11:00:00 | IWM | ETF | 192.03 | 192.2 | 191.3 | 191.51 | 4467346.0 |
| 2024-01-11 12:00:00 | IWM | ETF | 191.505 | 192.67 | 191.49 | 192.45 | 4170711.0 |
| 2024-01-11 13:00:00 | IWM | ETF | 192.44 | 193.355 | 192.42 | 193.32 | 4168677.0 |
| 2024-01-11 14:00:00 | IWM | ETF | 193.32 | 193.82 | 192.905 | 193.785 | 3014919.0 |
| 2024-01-11 15:00:00 | IWM | ETF | 193.79 | 193.855 | 193.04 | 193.62 | 4782299.0 |
| 2024-01-11 16:00:00 | IWM | ETF | 193.62 | 193.67 | 193.27 | 193.4 | 1113038.0 |
| 2024-01-11 17:00:00 | IWM | ETF | 193.38 | 193.38 | 193.07 | 193.1 | 73812.0 |
| 2024-01-11 18:00:00 | IWM | ETF | 193.21 | 193.43 | 193.17 | 193.39 | 63539.0 |
| 2024-01-11 19:00:00 | IWM | ETF | 193.41 | 193.53 | 193.01 | 193.01 | 47349.0 |
| 2024-01-11 04:00:00 | DIA | ETF | 378.12 | 378.12 | 377.52 | 377.52 | 332.0 |
| 2024-01-11 06:00:00 | DIA | ETF | 377.32 | 377.32 | 377.1 | 377.1 | 8061.0 |
> showing 50 of 19,473 rows — these rows as CSV