PREVIEW / etf_1hour / 2024-02-21
file: by_date/etf_1hour/2024/2024-02-21.parquet size: 526 KB rows: 19,629
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-02-21 04:00:00 | SPY | ETF | 495.33 | 495.74 | 495.33 | 495.54 | 14036.0 |
| 2024-02-21 05:00:00 | SPY | ETF | 495.59 | 495.94 | 495.57 | 495.9 | 7172.0 |
| 2024-02-21 06:00:00 | SPY | ETF | 495.9 | 495.9 | 495.41 | 495.7 | 31781.0 |
| 2024-02-21 07:00:00 | SPY | ETF | 495.62 | 496.0 | 495.07 | 495.07 | 232193.0 |
| 2024-02-21 08:00:00 | SPY | ETF | 495.16 | 496.31 | 494.9 | 495.43 | 190852.0 |
| 2024-02-21 09:00:00 | SPY | ETF | 495.45 | 495.6803 | 494.91 | 495.26 | 4117334.0 |
| 2024-02-21 10:00:00 | SPY | ETF | 495.26 | 496.06 | 495.05 | 495.285 | 4563359.0 |
| 2024-02-21 11:00:00 | SPY | ETF | 495.3 | 496.305 | 495.2703 | 495.98 | 3206351.0 |
| 2024-02-21 12:00:00 | SPY | ETF | 495.99 | 496.045 | 494.615 | 495.5599 | 3822540.0 |
| 2024-02-21 13:00:00 | SPY | ETF | 495.56 | 495.75 | 494.41 | 495.34 | 3833008.0 |
| 2024-02-21 14:00:00 | SPY | ETF | 495.33 | 496.09 | 493.905 | 494.58 | 6484061.0 |
| 2024-02-21 15:00:00 | SPY | ETF | 494.6 | 497.37 | 493.56 | 497.17 | 13240786.0 |
| 2024-02-21 16:00:00 | SPY | ETF | 497.16 | 499.56 | 494.96 | 499.5 | 4179807.0 |
| 2024-02-21 17:00:00 | SPY | ETF | 499.5 | 499.79 | 499.1 | 499.53 | 250045.0 |
| 2024-02-21 18:00:00 | SPY | ETF | 499.39 | 499.75 | 499.17 | 499.68 | 169578.0 |
| 2024-02-21 19:00:00 | SPY | ETF | 499.75 | 501.16 | 499.69 | 500.9 | 204914.0 |
| 2024-02-21 04:00:00 | QQQ | ETF | 425.17 | 425.61 | 425.15 | 425.45 | 38084.0 |
| 2024-02-21 05:00:00 | QQQ | ETF | 425.34 | 425.96 | 425.34 | 425.73 | 42568.0 |
| 2024-02-21 06:00:00 | QQQ | ETF | 425.6 | 425.67 | 425.08 | 425.39 | 26243.0 |
| 2024-02-21 07:00:00 | QQQ | ETF | 425.4 | 425.56 | 424.33 | 424.4 | 128293.0 |
| 2024-02-21 08:00:00 | QQQ | ETF | 424.6383 | 426.7 | 424.23 | 424.75 | 315287.0 |
| 2024-02-21 09:00:00 | QQQ | ETF | 424.79 | 425.03 | 423.445 | 424.06 | 4005881.0 |
| 2024-02-21 10:00:00 | QQQ | ETF | 424.04 | 425.2999 | 423.58 | 423.92 | 3991936.0 |
| 2024-02-21 11:00:00 | QQQ | ETF | 423.94 | 425.13 | 423.89 | 424.829 | 2830930.0 |
| 2024-02-21 12:00:00 | QQQ | ETF | 424.84 | 424.88 | 423.13 | 424.145 | 3294066.0 |
| 2024-02-21 13:00:00 | QQQ | ETF | 424.16 | 424.33 | 422.95 | 423.54 | 2909530.0 |
| 2024-02-21 14:00:00 | QQQ | ETF | 423.54 | 424.36 | 421.63 | 422.4501 | 4840947.0 |
| 2024-02-21 15:00:00 | QQQ | ETF | 422.43 | 425.7 | 421.86 | 425.61 | 6875639.0 |
| 2024-02-21 16:00:00 | QQQ | ETF | 425.59 | 429.93 | 422.59 | 429.87 | 2939243.0 |
| 2024-02-21 17:00:00 | QQQ | ETF | 429.87 | 430.19 | 429.0422 | 429.62 | 410209.0 |
| 2024-02-21 18:00:00 | QQQ | ETF | 429.64 | 429.76 | 429.0 | 429.6 | 334629.0 |
| 2024-02-21 19:00:00 | QQQ | ETF | 429.7 | 431.61 | 429.64 | 431.29 | 238775.0 |
| 2024-02-21 04:00:00 | IWM | ETF | 198.14 | 198.4 | 198.1 | 198.18 | 9665.0 |
| 2024-02-21 05:00:00 | IWM | ETF | 198.19 | 198.5 | 198.19 | 198.4 | 8834.0 |
| 2024-02-21 06:00:00 | IWM | ETF | 198.4 | 198.4 | 198.0 | 198.31 | 44675.0 |
| 2024-02-21 07:00:00 | IWM | ETF | 198.29 | 198.48 | 197.77 | 197.86 | 68727.0 |
| 2024-02-21 08:00:00 | IWM | ETF | 197.87 | 199.17 | 197.76 | 198.11 | 122496.0 |
| 2024-02-21 09:00:00 | IWM | ETF | 198.09 | 198.35 | 197.38 | 197.9 | 2622458.0 |
| 2024-02-21 10:00:00 | IWM | ETF | 197.88 | 198.2002 | 197.33 | 197.72 | 2500157.0 |
| 2024-02-21 11:00:00 | IWM | ETF | 197.73 | 198.11 | 197.09 | 197.53 | 2449568.0 |
| 2024-02-21 12:00:00 | IWM | ETF | 197.54 | 197.59 | 197.03 | 197.5 | 1872916.0 |
| 2024-02-21 13:00:00 | IWM | ETF | 197.51 | 197.72 | 196.85 | 197.65 | 2173631.0 |
| 2024-02-21 14:00:00 | IWM | ETF | 197.65 | 198.03 | 196.68 | 196.97 | 3113407.0 |
| 2024-02-21 15:00:00 | IWM | ETF | 196.96 | 197.95 | 196.39 | 197.94 | 5581108.0 |
| 2024-02-21 16:00:00 | IWM | ETF | 197.94 | 198.35 | 197.0 | 198.08 | 1390131.0 |
| 2024-02-21 17:00:00 | IWM | ETF | 198.13 | 198.67 | 197.94 | 198.5 | 204617.0 |
| 2024-02-21 18:00:00 | IWM | ETF | 198.5 | 198.63 | 198.22 | 198.44 | 77109.0 |
| 2024-02-21 19:00:00 | IWM | ETF | 198.47 | 199.29 | 198.46 | 199.24 | 116557.0 |
| 2024-02-21 07:00:00 | DIA | ETF | 385.05 | 385.29 | 385.05 | 385.29 | 611.0 |
| 2024-02-21 08:00:00 | DIA | ETF | 385.05 | 385.07 | 384.9 | 384.98 | 1918.0 |
> showing 50 of 19,629 rows — these rows as CSV