PREVIEW / etf_1hour / 2024-11-14
file: by_date/etf_1hour/2024/2024-11-14.parquet size: 598 KB rows: 22,370
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-11-14 04:00:00 | SPY | ETF | 597.74 | 598.17 | 597.55 | 597.68 | 19223.0 |
| 2024-11-14 05:00:00 | SPY | ETF | 597.61 | 598.07 | 597.57 | 597.66 | 22997.0 |
| 2024-11-14 06:00:00 | SPY | ETF | 597.78 | 598.2 | 597.66 | 598.15 | 45756.0 |
| 2024-11-14 07:00:00 | SPY | ETF | 598.14 | 598.26 | 597.56 | 597.65 | 165703.0 |
| 2024-11-14 08:00:00 | SPY | ETF | 597.93 | 598.25 | 596.27 | 597.16 | 310447.0 |
| 2024-11-14 09:00:00 | SPY | ETF | 597.07 | 597.81 | 595.7901 | 596.41 | 2870419.0 |
| 2024-11-14 10:00:00 | SPY | ETF | 596.415 | 596.94 | 595.1248 | 596.1401 | 2959235.0 |
| 2024-11-14 11:00:00 | SPY | ETF | 596.165 | 596.93 | 595.5001 | 595.6601 | 1663450.0 |
| 2024-11-14 12:00:00 | SPY | ETF | 595.67 | 595.86 | 593.75 | 595.0548 | 3005032.0 |
| 2024-11-14 13:00:00 | SPY | ETF | 595.03 | 595.7201 | 593.77 | 593.9 | 1957530.0 |
| 2024-11-14 14:00:00 | SPY | ETF | 593.88 | 595.79 | 593.8698 | 595.295 | 2203815.0 |
| 2024-11-14 15:00:00 | SPY | ETF | 595.28 | 595.31 | 592.65 | 593.37 | 8981188.0 |
| 2024-11-14 16:00:00 | SPY | ETF | 593.39 | 593.48 | 592.12 | 593.1 | 3555083.0 |
| 2024-11-14 17:00:00 | SPY | ETF | 593.1 | 593.35 | 592.66 | 592.9 | 65326.0 |
| 2024-11-14 18:00:00 | SPY | ETF | 592.96 | 593.1 | 592.24 | 592.421 | 72062.0 |
| 2024-11-14 19:00:00 | SPY | ETF | 592.36 | 592.48 | 591.7 | 591.93 | 81903.0 |
| 2024-11-14 04:00:00 | QQQ | ETF | 512.51 | 513.1 | 512.28 | 512.36 | 49022.0 |
| 2024-11-14 05:00:00 | QQQ | ETF | 512.27 | 512.91 | 512.2 | 512.43 | 19207.0 |
| 2024-11-14 06:00:00 | QQQ | ETF | 512.55 | 512.89 | 512.51 | 512.89 | 41215.0 |
| 2024-11-14 07:00:00 | QQQ | ETF | 512.93 | 512.98 | 512.27 | 512.35 | 33541.0 |
| 2024-11-14 08:00:00 | QQQ | ETF | 512.36 | 512.94 | 510.94 | 511.86 | 410001.0 |
| 2024-11-14 09:00:00 | QQQ | ETF | 511.79 | 512.79 | 510.1397 | 510.81 | 2341091.0 |
| 2024-11-14 10:00:00 | QQQ | ETF | 510.75 | 511.91 | 509.56 | 510.78 | 2199436.0 |
| 2024-11-14 11:00:00 | QQQ | ETF | 510.75 | 511.95 | 510.67 | 510.99 | 1165878.0 |
| 2024-11-14 12:00:00 | QQQ | ETF | 511.0 | 511.2499 | 508.96 | 510.55 | 2236054.0 |
| 2024-11-14 13:00:00 | QQQ | ETF | 510.53 | 511.45 | 509.1 | 509.22 | 2041045.0 |
| 2024-11-14 14:00:00 | QQQ | ETF | 509.21 | 510.69 | 509.18 | 510.17 | 2305838.0 |
| 2024-11-14 15:00:00 | QQQ | ETF | 510.16 | 510.17 | 507.77 | 508.67 | 5149725.0 |
| 2024-11-14 16:00:00 | QQQ | ETF | 508.67 | 508.8 | 507.31 | 507.9321 | 1312802.0 |
| 2024-11-14 17:00:00 | QQQ | ETF | 508.0 | 508.69 | 507.6052 | 507.79 | 30686.0 |
| 2024-11-14 18:00:00 | QQQ | ETF | 507.86 | 507.88 | 507.0 | 507.27 | 57178.0 |
| 2024-11-14 19:00:00 | QQQ | ETF | 507.22 | 507.41 | 506.44 | 506.67 | 104786.0 |
| 2024-11-14 04:00:00 | IWM | ETF | 235.79 | 236.79 | 235.79 | 236.79 | 39618.0 |
| 2024-11-14 05:00:00 | IWM | ETF | 236.65 | 237.01 | 236.53 | 236.58 | 34569.0 |
| 2024-11-14 06:00:00 | IWM | ETF | 236.53 | 237.05 | 236.36 | 236.86 | 28968.0 |
| 2024-11-14 07:00:00 | IWM | ETF | 236.79 | 236.9 | 236.18 | 236.2 | 49481.0 |
| 2024-11-14 08:00:00 | IWM | ETF | 236.51 | 236.8496 | 234.65 | 235.0 | 387796.0 |
| 2024-11-14 09:00:00 | IWM | ETF | 235.0 | 236.43 | 234.2101 | 234.32 | 2542027.0 |
| 2024-11-14 10:00:00 | IWM | ETF | 234.37 | 234.69 | 233.7201 | 234.19 | 2126340.0 |
| 2024-11-14 11:00:00 | IWM | ETF | 234.17 | 234.57 | 233.27 | 233.615 | 1369385.0 |
| 2024-11-14 12:00:00 | IWM | ETF | 233.61 | 233.62 | 231.88 | 232.49 | 2572471.0 |
| 2024-11-14 13:00:00 | IWM | ETF | 232.48 | 232.71 | 232.12 | 232.14 | 1317650.0 |
| 2024-11-14 14:00:00 | IWM | ETF | 232.115 | 233.25 | 232.115 | 233.049 | 1459863.0 |
| 2024-11-14 15:00:00 | IWM | ETF | 233.06 | 233.08 | 231.21 | 231.97 | 6761622.0 |
| 2024-11-14 16:00:00 | IWM | ETF | 231.94 | 232.11 | 231.62 | 231.99 | 2772611.0 |
| 2024-11-14 17:00:00 | IWM | ETF | 232.07 | 232.1 | 231.94 | 232.03 | 34112.0 |
| 2024-11-14 18:00:00 | IWM | ETF | 232.02 | 232.02 | 231.5 | 231.68 | 44908.0 |
| 2024-11-14 19:00:00 | IWM | ETF | 231.61 | 231.7 | 231.15 | 231.17 | 38570.0 |
| 2024-11-14 04:00:00 | DIA | ETF | 440.17 | 440.38 | 440.17 | 440.3 | 1829.0 |
| 2024-11-14 06:00:00 | DIA | ETF | 440.1 | 440.84 | 440.1 | 440.84 | 504.0 |
> showing 50 of 22,370 rows — these rows as CSV