PREVIEW / etf_1hour / 2024-01-19
file: by_date/etf_1hour/2024/2024-01-19.parquet size: 537 KB rows: 19,580
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-19 04:00:00 | SPY | ETF | 477.84 | 478.58 | 477.2 | 478.42 | 69390.0 |
| 2024-01-19 05:00:00 | SPY | ETF | 478.36 | 478.65 | 478.16 | 478.62 | 22754.0 |
| 2024-01-19 06:00:00 | SPY | ETF | 478.5 | 478.99 | 478.46 | 478.83 | 34129.0 |
| 2024-01-19 07:00:00 | SPY | ETF | 478.88 | 478.97 | 477.92 | 478.91 | 395580.0 |
| 2024-01-19 08:00:00 | SPY | ETF | 478.8805 | 479.47 | 476.49 | 478.51 | 479828.0 |
| 2024-01-19 09:00:00 | SPY | ETF | 478.51 | 478.63 | 476.94 | 477.92 | 6878616.0 |
| 2024-01-19 10:00:00 | SPY | ETF | 477.91 | 478.56 | 476.9901 | 478.2803 | 9291751.0 |
| 2024-01-19 11:00:00 | SPY | ETF | 478.3 | 479.28 | 478.01 | 478.87 | 7494526.0 |
| 2024-01-19 12:00:00 | SPY | ETF | 478.88 | 480.2 | 478.28 | 480.195 | 7338043.0 |
| 2024-01-19 13:00:00 | SPY | ETF | 480.2 | 481.71 | 479.73 | 481.6694 | 8147437.0 |
| 2024-01-19 14:00:00 | SPY | ETF | 481.67 | 482.72 | 481.33 | 482.21 | 10692601.0 |
| 2024-01-19 15:00:00 | SPY | ETF | 482.21 | 482.55 | 481.79 | 482.42 | 14399797.0 |
| 2024-01-19 16:00:00 | SPY | ETF | 482.43 | 482.75 | 478.4765 | 482.38 | 6230321.0 |
| 2024-01-19 17:00:00 | SPY | ETF | 482.43 | 482.5 | 482.31 | 482.37 | 94342.0 |
| 2024-01-19 18:00:00 | SPY | ETF | 482.37 | 482.52 | 482.36 | 482.48 | 260321.0 |
| 2024-01-19 19:00:00 | SPY | ETF | 482.48 | 482.65 | 482.46 | 482.64 | 43180.0 |
| 2024-01-19 04:00:00 | QQQ | ETF | 414.75 | 416.3 | 414.75 | 416.1 | 109351.0 |
| 2024-01-19 05:00:00 | QQQ | ETF | 416.05 | 416.5 | 415.78 | 416.34 | 62710.0 |
| 2024-01-19 06:00:00 | QQQ | ETF | 416.26 | 416.69 | 416.17 | 416.61 | 73474.0 |
| 2024-01-19 07:00:00 | QQQ | ETF | 416.55 | 416.61 | 415.67 | 416.35 | 367929.0 |
| 2024-01-19 08:00:00 | QQQ | ETF | 416.51 | 416.71 | 414.31 | 415.93 | 454967.0 |
| 2024-01-19 09:00:00 | QQQ | ETF | 415.91 | 416.07 | 414.625 | 415.71 | 6576025.0 |
| 2024-01-19 10:00:00 | QQQ | ETF | 415.73 | 416.44 | 414.6906 | 416.0612 | 5619675.0 |
| 2024-01-19 11:00:00 | QQQ | ETF | 416.08 | 417.12 | 415.74 | 416.9808 | 5030756.0 |
| 2024-01-19 12:00:00 | QQQ | ETF | 416.98 | 418.41 | 416.2799 | 418.405 | 5458058.0 |
| 2024-01-19 13:00:00 | QQQ | ETF | 418.4 | 420.1 | 417.95 | 420.08 | 5236171.0 |
| 2024-01-19 14:00:00 | QQQ | ETF | 420.09 | 421.11 | 419.82 | 420.89 | 6753708.0 |
| 2024-01-19 15:00:00 | QQQ | ETF | 420.885 | 421.34 | 420.57 | 421.24 | 8223717.0 |
| 2024-01-19 16:00:00 | QQQ | ETF | 421.24 | 421.92 | 418.134 | 421.7 | 3288147.0 |
| 2024-01-19 17:00:00 | QQQ | ETF | 421.7 | 421.79 | 421.6 | 421.6455 | 83079.0 |
| 2024-01-19 18:00:00 | QQQ | ETF | 421.62 | 421.7 | 421.18 | 421.65 | 200010.0 |
| 2024-01-19 19:00:00 | QQQ | ETF | 421.68 | 421.97 | 421.66 | 421.96 | 22864.0 |
| 2024-01-19 04:00:00 | IWM | ETF | 191.2 | 191.47 | 190.95 | 191.15 | 43865.0 |
| 2024-01-19 05:00:00 | IWM | ETF | 191.21 | 191.34 | 190.96 | 191.11 | 16183.0 |
| 2024-01-19 06:00:00 | IWM | ETF | 191.0 | 191.34 | 190.99 | 191.23 | 14383.0 |
| 2024-01-19 07:00:00 | IWM | ETF | 191.28 | 191.35 | 190.86 | 191.25 | 240654.0 |
| 2024-01-19 08:00:00 | IWM | ETF | 191.33 | 191.93 | 190.59 | 191.2 | 272555.0 |
| 2024-01-19 09:00:00 | IWM | ETF | 191.22 | 191.45 | 189.29 | 190.22 | 5894962.0 |
| 2024-01-19 10:00:00 | IWM | ETF | 190.23 | 191.18 | 189.225 | 189.935 | 6099460.0 |
| 2024-01-19 11:00:00 | IWM | ETF | 189.945 | 190.6 | 189.44 | 189.85 | 3980461.0 |
| 2024-01-19 12:00:00 | IWM | ETF | 189.85 | 190.74 | 189.505 | 190.72 | 4262218.0 |
| 2024-01-19 13:00:00 | IWM | ETF | 190.73 | 191.94 | 190.38 | 191.905 | 6140916.0 |
| 2024-01-19 14:00:00 | IWM | ETF | 191.905 | 192.85 | 191.82 | 192.405 | 5161226.0 |
| 2024-01-19 15:00:00 | IWM | ETF | 192.41 | 192.61 | 191.99 | 192.53 | 7618632.0 |
| 2024-01-19 16:00:00 | IWM | ETF | 192.52 | 192.75 | 192.41 | 192.52 | 2926949.0 |
| 2024-01-19 17:00:00 | IWM | ETF | 192.55 | 192.85 | 192.55 | 192.85 | 79419.0 |
| 2024-01-19 18:00:00 | IWM | ETF | 192.85 | 192.92 | 192.43 | 192.92 | 1446318.0 |
| 2024-01-19 19:00:00 | IWM | ETF | 192.92 | 192.98 | 192.8 | 192.96 | 27301.0 |
| 2024-01-19 04:00:00 | DIA | ETF | 375.15 | 375.37 | 375.15 | 375.35 | 811.0 |
| 2024-01-19 05:00:00 | DIA | ETF | 375.32 | 375.45 | 375.3 | 375.45 | 2175.0 |
> showing 50 of 19,580 rows — these rows as CSV