PREVIEW / etf_1hour / 2024-01-18
file: by_date/etf_1hour/2024/2024-01-18.parquet size: 524 KB rows: 19,265
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-18 04:00:00 | SPY | ETF | 472.64 | 473.14 | 472.62 | 472.85 | 18940.0 |
| 2024-01-18 05:00:00 | SPY | ETF | 472.83 | 473.46 | 472.62 | 473.43 | 19980.0 |
| 2024-01-18 06:00:00 | SPY | ETF | 473.5 | 474.21 | 473.5 | 474.15 | 157480.0 |
| 2024-01-18 07:00:00 | SPY | ETF | 474.13 | 474.67 | 474.0 | 474.34 | 201486.0 |
| 2024-01-18 08:00:00 | SPY | ETF | 474.34 | 475.16 | 472.04 | 473.72 | 650773.0 |
| 2024-01-18 09:00:00 | SPY | ETF | 473.76 | 474.63 | 473.39 | 473.87 | 6520007.0 |
| 2024-01-18 10:00:00 | SPY | ETF | 473.875 | 474.88 | 473.395 | 474.2701 | 8163644.0 |
| 2024-01-18 11:00:00 | SPY | ETF | 474.28 | 475.03 | 473.66 | 474.4687 | 6470640.0 |
| 2024-01-18 12:00:00 | SPY | ETF | 474.47 | 474.5521 | 473.0 | 473.18 | 6977111.0 |
| 2024-01-18 13:00:00 | SPY | ETF | 473.19 | 474.1299 | 472.42 | 473.9801 | 6522071.0 |
| 2024-01-18 14:00:00 | SPY | ETF | 473.98 | 475.9499 | 473.975 | 475.74 | 9006361.0 |
| 2024-01-18 15:00:00 | SPY | ETF | 475.75 | 477.06 | 475.59 | 476.46 | 15484243.0 |
| 2024-01-18 16:00:00 | SPY | ETF | 476.46 | 476.68 | 474.2002 | 476.5 | 4445241.0 |
| 2024-01-18 17:00:00 | SPY | ETF | 476.5 | 476.6 | 476.49 | 476.6 | 50866.0 |
| 2024-01-18 18:00:00 | SPY | ETF | 476.52 | 476.88 | 476.31 | 476.88 | 123976.0 |
| 2024-01-18 19:00:00 | SPY | ETF | 476.84 | 476.87 | 476.57 | 476.74 | 62533.0 |
| 2024-01-18 04:00:00 | QQQ | ETF | 407.24 | 409.0 | 407.24 | 408.64 | 70475.0 |
| 2024-01-18 05:00:00 | QQQ | ETF | 408.6 | 409.18 | 408.47 | 409.18 | 26665.0 |
| 2024-01-18 06:00:00 | QQQ | ETF | 409.21 | 410.51 | 409.14 | 410.38 | 130993.0 |
| 2024-01-18 07:00:00 | QQQ | ETF | 410.38 | 411.17 | 410.3 | 410.72 | 274489.0 |
| 2024-01-18 08:00:00 | QQQ | ETF | 410.3802 | 411.61 | 406.86 | 410.16 | 734612.0 |
| 2024-01-18 09:00:00 | QQQ | ETF | 410.2 | 411.86 | 410.2 | 411.2199 | 6140187.0 |
| 2024-01-18 10:00:00 | QQQ | ETF | 411.22 | 412.46 | 410.22 | 411.89 | 7341292.0 |
| 2024-01-18 11:00:00 | QQQ | ETF | 411.92 | 412.9881 | 411.18 | 412.4219 | 5239641.0 |
| 2024-01-18 12:00:00 | QQQ | ETF | 412.42 | 412.505 | 410.32 | 410.57 | 5647818.0 |
| 2024-01-18 13:00:00 | QQQ | ETF | 410.58 | 411.07 | 409.1601 | 410.9299 | 4983824.0 |
| 2024-01-18 14:00:00 | QQQ | ETF | 410.93 | 413.19 | 410.925 | 412.92 | 5740731.0 |
| 2024-01-18 15:00:00 | QQQ | ETF | 412.93 | 413.575 | 412.55 | 413.19 | 7035445.0 |
| 2024-01-18 16:00:00 | QQQ | ETF | 413.17 | 413.51 | 412.78 | 413.37 | 1505970.0 |
| 2024-01-18 17:00:00 | QQQ | ETF | 413.32 | 413.47 | 413.29 | 413.33 | 24781.0 |
| 2024-01-18 18:00:00 | QQQ | ETF | 413.33 | 414.22 | 413.17 | 414.13 | 65668.0 |
| 2024-01-18 19:00:00 | QQQ | ETF | 414.11 | 414.37 | 413.83 | 414.24 | 70649.0 |
| 2024-01-18 04:00:00 | IWM | ETF | 189.48 | 189.83 | 189.42 | 189.68 | 49341.0 |
| 2024-01-18 05:00:00 | IWM | ETF | 189.67 | 190.01 | 189.6 | 190.0 | 23868.0 |
| 2024-01-18 06:00:00 | IWM | ETF | 190.08 | 191.05 | 190.05 | 190.8 | 83194.0 |
| 2024-01-18 07:00:00 | IWM | ETF | 190.77 | 191.08 | 190.6 | 190.6 | 193474.0 |
| 2024-01-18 08:00:00 | IWM | ETF | 190.6 | 191.2 | 189.36 | 190.3 | 423198.0 |
| 2024-01-18 09:00:00 | IWM | ETF | 190.35 | 191.17 | 189.19 | 189.95 | 5316963.0 |
| 2024-01-18 10:00:00 | IWM | ETF | 189.95 | 190.595 | 189.285 | 189.455 | 4814866.0 |
| 2024-01-18 11:00:00 | IWM | ETF | 189.45 | 190.01 | 189.01 | 189.2701 | 3477935.0 |
| 2024-01-18 12:00:00 | IWM | ETF | 189.28 | 189.3 | 188.43 | 188.71 | 3375607.0 |
| 2024-01-18 13:00:00 | IWM | ETF | 188.72 | 189.24 | 188.21 | 189.11 | 3360273.0 |
| 2024-01-18 14:00:00 | IWM | ETF | 189.11 | 190.14 | 189.1 | 190.07 | 4108732.0 |
| 2024-01-18 15:00:00 | IWM | ETF | 190.08 | 190.695 | 189.92 | 190.63 | 6235225.0 |
| 2024-01-18 16:00:00 | IWM | ETF | 190.64 | 190.86 | 190.39 | 190.76 | 1991437.0 |
| 2024-01-18 17:00:00 | IWM | ETF | 190.74 | 190.8 | 190.6 | 190.73 | 3734.0 |
| 2024-01-18 18:00:00 | IWM | ETF | 190.73 | 190.9901 | 190.68 | 190.9901 | 46308.0 |
| 2024-01-18 19:00:00 | IWM | ETF | 191.0 | 191.0 | 190.76 | 190.9 | 31146.0 |
| 2024-01-18 04:00:00 | DIA | ETF | 372.8 | 372.8 | 372.7 | 372.78 | 819.0 |
| 2024-01-18 05:00:00 | DIA | ETF | 372.77 | 373.25 | 372.77 | 373.25 | 550.0 |
> showing 50 of 19,265 rows — these rows as CSV