PREVIEW / etf_1hour / 2024-05-21
file: by_date/etf_1hour/2024/2024-05-21.parquet size: 531 KB rows: 19,502
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-05-21 04:00:00 | SPY | ETF | 530.12 | 530.3 | 529.89 | 529.96 | 10559.0 |
| 2024-05-21 05:00:00 | SPY | ETF | 529.92 | 530.06 | 529.82 | 529.82 | 3917.0 |
| 2024-05-21 06:00:00 | SPY | ETF | 529.94 | 530.18 | 529.89 | 530.14 | 6486.0 |
| 2024-05-21 07:00:00 | SPY | ETF | 530.16 | 530.27 | 530.09 | 530.15 | 27328.0 |
| 2024-05-21 08:00:00 | SPY | ETF | 530.22 | 530.3 | 529.51 | 529.61 | 138082.0 |
| 2024-05-21 09:00:00 | SPY | ETF | 529.63 | 529.7809 | 529.07 | 529.52 | 2440859.0 |
| 2024-05-21 10:00:00 | SPY | ETF | 529.53 | 530.59 | 529.52 | 530.36 | 2437296.0 |
| 2024-05-21 11:00:00 | SPY | ETF | 530.35 | 530.73 | 529.82 | 529.97 | 2244966.0 |
| 2024-05-21 12:00:00 | SPY | ETF | 529.97 | 530.3 | 529.8 | 529.95 | 2734845.0 |
| 2024-05-21 13:00:00 | SPY | ETF | 529.945 | 530.78 | 529.64 | 530.76 | 1885248.0 |
| 2024-05-21 14:00:00 | SPY | ETF | 530.77 | 530.79 | 530.1658 | 530.4099 | 1901145.0 |
| 2024-05-21 15:00:00 | SPY | ETF | 530.4 | 531.52 | 530.24 | 531.32 | 6725067.0 |
| 2024-05-21 16:00:00 | SPY | ETF | 531.33 | 531.43 | 531.03 | 531.15 | 2178787.0 |
| 2024-05-21 17:00:00 | SPY | ETF | 531.23 | 531.25 | 531.14 | 531.2 | 21045.0 |
| 2024-05-21 18:00:00 | SPY | ETF | 531.16 | 531.4 | 531.15 | 531.37 | 33601.0 |
| 2024-05-21 19:00:00 | SPY | ETF | 531.41 | 531.46 | 531.34 | 531.4 | 14032.0 |
| 2024-05-21 04:00:00 | QQQ | ETF | 454.61 | 454.73 | 454.28 | 454.4 | 15864.0 |
| 2024-05-21 05:00:00 | QQQ | ETF | 454.4 | 454.4 | 454.16 | 454.3 | 7800.0 |
| 2024-05-21 06:00:00 | QQQ | ETF | 454.44 | 454.67 | 454.35 | 454.62 | 9103.0 |
| 2024-05-21 07:00:00 | QQQ | ETF | 454.67 | 454.83 | 454.55 | 454.6 | 263952.0 |
| 2024-05-21 08:00:00 | QQQ | ETF | 454.8283 | 454.8283 | 453.78 | 453.81 | 245554.0 |
| 2024-05-21 09:00:00 | QQQ | ETF | 453.77 | 453.87 | 452.84 | 453.558 | 2886558.0 |
| 2024-05-21 10:00:00 | QQQ | ETF | 453.55 | 454.785 | 453.44 | 454.71 | 2388613.0 |
| 2024-05-21 11:00:00 | QQQ | ETF | 454.71 | 454.92 | 454.14 | 454.47 | 1424793.0 |
| 2024-05-21 12:00:00 | QQQ | ETF | 454.46 | 455.11 | 454.31 | 454.51 | 1241696.0 |
| 2024-05-21 13:00:00 | QQQ | ETF | 454.5 | 455.2073 | 454.2 | 455.2 | 1302132.0 |
| 2024-05-21 14:00:00 | QQQ | ETF | 455.21 | 455.31 | 454.71 | 455.05 | 1476419.0 |
| 2024-05-21 15:00:00 | QQQ | ETF | 455.04 | 455.99 | 454.91 | 455.8 | 3648519.0 |
| 2024-05-21 16:00:00 | QQQ | ETF | 455.8 | 455.96 | 455.55 | 455.75 | 986720.0 |
| 2024-05-21 17:00:00 | QQQ | ETF | 455.74 | 455.78 | 455.65 | 455.7 | 17487.0 |
| 2024-05-21 18:00:00 | QQQ | ETF | 455.75 | 456.06 | 455.7 | 456.05 | 28301.0 |
| 2024-05-21 19:00:00 | QQQ | ETF | 456.03 | 456.13 | 456.0 | 456.12 | 34077.0 |
| 2024-05-21 04:00:00 | IWM | ETF | 208.63 | 208.63 | 208.33 | 208.39 | 12952.0 |
| 2024-05-21 05:00:00 | IWM | ETF | 208.39 | 208.5 | 208.17 | 208.27 | 4767.0 |
| 2024-05-21 06:00:00 | IWM | ETF | 208.24 | 208.31 | 208.15 | 208.27 | 5642.0 |
| 2024-05-21 07:00:00 | IWM | ETF | 208.34 | 208.35 | 208.15 | 208.25 | 17573.0 |
| 2024-05-21 08:00:00 | IWM | ETF | 208.28 | 208.87 | 207.55 | 207.56 | 116041.0 |
| 2024-05-21 09:00:00 | IWM | ETF | 207.52 | 208.58 | 207.09 | 207.975 | 1934805.0 |
| 2024-05-21 10:00:00 | IWM | ETF | 207.97 | 208.68 | 207.96 | 208.49 | 1365290.0 |
| 2024-05-21 11:00:00 | IWM | ETF | 208.49 | 208.69 | 208.01 | 208.025 | 1004963.0 |
| 2024-05-21 12:00:00 | IWM | ETF | 208.015 | 208.3298 | 207.94 | 208.28 | 935397.0 |
| 2024-05-21 13:00:00 | IWM | ETF | 208.28 | 208.39 | 208.07 | 208.32 | 851750.0 |
| 2024-05-21 14:00:00 | IWM | ETF | 208.315 | 208.33 | 207.985 | 208.14 | 761683.0 |
| 2024-05-21 15:00:00 | IWM | ETF | 208.14 | 208.405 | 208.035 | 208.34 | 2047683.0 |
| 2024-05-21 16:00:00 | IWM | ETF | 208.34 | 208.38 | 208.1959 | 208.27 | 465404.0 |
| 2024-05-21 17:00:00 | IWM | ETF | 208.31 | 208.34 | 208.16 | 208.19 | 7716.0 |
| 2024-05-21 18:00:00 | IWM | ETF | 208.19 | 208.44 | 208.17 | 208.4 | 7190.0 |
| 2024-05-21 19:00:00 | IWM | ETF | 208.41 | 208.52 | 208.41 | 208.43 | 6630.0 |
| 2024-05-21 05:00:00 | DIA | ETF | 398.2 | 398.2 | 398.03 | 398.03 | 500.0 |
| 2024-05-21 07:00:00 | DIA | ETF | 398.27 | 398.27 | 398.1 | 398.21 | 1631.0 |
> showing 50 of 19,502 rows — these rows as CSV