PREVIEW / etf_1hour / 2024-01-16
file: by_date/etf_1hour/2024/2024-01-16.parquet size: 543 KB rows: 20,225
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-16 04:00:00 | SPY | ETF | 474.25 | 474.88 | 474.0 | 474.4 | 18342.0 |
| 2024-01-16 05:00:00 | SPY | ETF | 474.11 | 474.15 | 473.69 | 473.91 | 8351.0 |
| 2024-01-16 06:00:00 | SPY | ETF | 474.01 | 474.92 | 473.93 | 474.81 | 21374.0 |
| 2024-01-16 07:00:00 | SPY | ETF | 474.84 | 475.48 | 474.46 | 475.38 | 218187.0 |
| 2024-01-16 08:00:00 | SPY | ETF | 474.8304 | 475.55 | 473.85 | 474.61 | 383667.0 |
| 2024-01-16 09:00:00 | SPY | ETF | 474.71 | 475.61 | 473.47 | 474.5 | 7025442.0 |
| 2024-01-16 10:00:00 | SPY | ETF | 474.49 | 476.59 | 474.145 | 476.19 | 10186046.0 |
| 2024-01-16 11:00:00 | SPY | ETF | 476.21 | 476.6098 | 474.61 | 475.23 | 9155669.0 |
| 2024-01-16 12:00:00 | SPY | ETF | 475.23 | 475.39 | 473.92 | 473.94 | 5598506.0 |
| 2024-01-16 13:00:00 | SPY | ETF | 473.96 | 475.21 | 473.78 | 474.0606 | 5823196.0 |
| 2024-01-16 14:00:00 | SPY | ETF | 474.07 | 474.37 | 473.06 | 474.29 | 6728984.0 |
| 2024-01-16 15:00:00 | SPY | ETF | 474.28 | 475.06 | 473.775 | 474.95 | 14210126.0 |
| 2024-01-16 16:00:00 | SPY | ETF | 474.95 | 475.15 | 473.9066 | 475.03 | 2915149.0 |
| 2024-01-16 17:00:00 | SPY | ETF | 475.03 | 475.07 | 474.93 | 474.99 | 39646.0 |
| 2024-01-16 18:00:00 | SPY | ETF | 475.03 | 475.1 | 474.9 | 475.1 | 42181.0 |
| 2024-01-16 19:00:00 | SPY | ETF | 475.08 | 475.09 | 474.61 | 474.75 | 53492.0 |
| 2024-01-16 04:00:00 | QQQ | ETF | 406.42 | 407.38 | 406.42 | 406.8 | 65629.0 |
| 2024-01-16 05:00:00 | QQQ | ETF | 406.6 | 406.75 | 406.15 | 406.55 | 27263.0 |
| 2024-01-16 06:00:00 | QQQ | ETF | 406.74 | 407.58 | 406.61 | 407.39 | 39759.0 |
| 2024-01-16 07:00:00 | QQQ | ETF | 407.45 | 408.3 | 407.26 | 408.18 | 110793.0 |
| 2024-01-16 08:00:00 | QQQ | ETF | 407.36 | 408.6 | 406.0 | 407.76 | 392497.0 |
| 2024-01-16 09:00:00 | QQQ | ETF | 407.8 | 409.02 | 406.83 | 408.25 | 5964566.0 |
| 2024-01-16 10:00:00 | QQQ | ETF | 408.245 | 411.12 | 407.7248 | 410.615 | 6452233.0 |
| 2024-01-16 11:00:00 | QQQ | ETF | 410.63 | 410.86 | 408.77 | 409.11 | 6604786.0 |
| 2024-01-16 12:00:00 | QQQ | ETF | 409.105 | 409.37 | 407.77 | 407.86 | 3417519.0 |
| 2024-01-16 13:00:00 | QQQ | ETF | 407.87 | 409.0899 | 407.71 | 407.98 | 3325310.0 |
| 2024-01-16 14:00:00 | QQQ | ETF | 407.99 | 408.67 | 407.02 | 408.59 | 2773772.0 |
| 2024-01-16 15:00:00 | QQQ | ETF | 408.5799 | 409.58 | 408.43 | 409.53 | 4556128.0 |
| 2024-01-16 16:00:00 | QQQ | ETF | 409.53 | 409.86 | 409.38 | 409.7986 | 789136.0 |
| 2024-01-16 17:00:00 | QQQ | ETF | 409.78 | 409.84 | 409.66 | 409.72 | 29735.0 |
| 2024-01-16 18:00:00 | QQQ | ETF | 409.69 | 409.8 | 409.52 | 409.77 | 40514.0 |
| 2024-01-16 19:00:00 | QQQ | ETF | 409.8 | 409.83 | 409.28 | 409.33 | 60233.0 |
| 2024-01-16 04:00:00 | IWM | ETF | 192.03 | 192.03 | 191.37 | 191.58 | 35837.0 |
| 2024-01-16 05:00:00 | IWM | ETF | 191.59 | 191.72 | 191.33 | 191.43 | 17449.0 |
| 2024-01-16 06:00:00 | IWM | ETF | 191.57 | 192.03 | 191.42 | 191.89 | 29766.0 |
| 2024-01-16 07:00:00 | IWM | ETF | 191.92 | 192.23 | 191.7 | 192.08 | 197475.0 |
| 2024-01-16 08:00:00 | IWM | ETF | 191.921 | 192.37 | 191.24 | 191.4 | 207388.0 |
| 2024-01-16 09:00:00 | IWM | ETF | 191.41 | 192.15 | 190.49 | 191.115 | 5027173.0 |
| 2024-01-16 10:00:00 | IWM | ETF | 191.12 | 192.31 | 190.82 | 191.81 | 4891621.0 |
| 2024-01-16 11:00:00 | IWM | ETF | 191.81 | 192.13 | 190.92 | 191.68 | 6270734.0 |
| 2024-01-16 12:00:00 | IWM | ETF | 191.665 | 191.715 | 190.9 | 191.04 | 3054563.0 |
| 2024-01-16 13:00:00 | IWM | ETF | 191.05 | 191.55 | 190.63 | 190.74 | 3196503.0 |
| 2024-01-16 14:00:00 | IWM | ETF | 190.75 | 190.83 | 190.11 | 190.73 | 3854944.0 |
| 2024-01-16 15:00:00 | IWM | ETF | 190.73 | 190.98 | 190.46 | 190.91 | 5251270.0 |
| 2024-01-16 16:00:00 | IWM | ETF | 190.84 | 191.08 | 190.84 | 190.99 | 1451472.0 |
| 2024-01-16 17:00:00 | IWM | ETF | 190.98 | 190.99 | 190.85 | 190.9104 | 11880.0 |
| 2024-01-16 18:00:00 | IWM | ETF | 190.94 | 191.09 | 190.88 | 191.09 | 27801.0 |
| 2024-01-16 19:00:00 | IWM | ETF | 191.08 | 191.09 | 190.73 | 190.85 | 48083.0 |
| 2024-01-16 04:00:00 | DIA | ETF | 374.45 | 374.55 | 374.31 | 374.31 | 1000.0 |
| 2024-01-16 05:00:00 | DIA | ETF | 374.14 | 374.19 | 373.93 | 374.19 | 2057.0 |
> showing 50 of 20,225 rows — these rows as CSV