PREVIEW / etf_1hour / 2024-10-02
file: by_date/etf_1hour/2024/2024-10-02.parquet size: 576 KB rows: 21,449
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-10-02 04:00:00 | SPY | ETF | 567.59 | 568.35 | 567.59 | 567.95 | 33846.0 |
| 2024-10-02 05:00:00 | SPY | ETF | 567.68 | 567.68 | 566.64 | 567.0 | 18507.0 |
| 2024-10-02 06:00:00 | SPY | ETF | 566.91 | 568.13 | 566.37 | 567.84 | 28021.0 |
| 2024-10-02 07:00:00 | SPY | ETF | 567.89 | 568.06 | 567.04 | 567.15 | 82389.0 |
| 2024-10-02 08:00:00 | SPY | ETF | 567.11 | 568.7 | 566.98 | 567.94 | 266449.0 |
| 2024-10-02 09:00:00 | SPY | ETF | 567.96 | 568.08 | 565.27 | 567.08 | 4163481.0 |
| 2024-10-02 10:00:00 | SPY | ETF | 567.07 | 569.71 | 566.89 | 568.3 | 4151583.0 |
| 2024-10-02 11:00:00 | SPY | ETF | 568.31 | 569.9 | 568.11 | 569.51 | 2665469.0 |
| 2024-10-02 12:00:00 | SPY | ETF | 569.52 | 569.79 | 567.84 | 567.8609 | 2152442.0 |
| 2024-10-02 13:00:00 | SPY | ETF | 567.865 | 569.15 | 567.57 | 569.06 | 2384042.0 |
| 2024-10-02 14:00:00 | SPY | ETF | 569.06 | 569.37 | 567.74 | 568.89 | 2457951.0 |
| 2024-10-02 15:00:00 | SPY | ETF | 568.89 | 569.46 | 568.7 | 568.85 | 5113833.0 |
| 2024-10-02 16:00:00 | SPY | ETF | 568.82 | 570.1 | 568.64 | 569.77 | 1856898.0 |
| 2024-10-02 17:00:00 | SPY | ETF | 569.84 | 569.93 | 569.6 | 569.623 | 19320.0 |
| 2024-10-02 18:00:00 | SPY | ETF | 569.68 | 570.0 | 569.52 | 569.63 | 66721.0 |
| 2024-10-02 19:00:00 | SPY | ETF | 569.63 | 569.8 | 569.37 | 569.75 | 32205.0 |
| 2024-10-02 04:00:00 | QQQ | ETF | 480.42 | 480.9 | 480.2 | 480.37 | 49789.0 |
| 2024-10-02 05:00:00 | QQQ | ETF | 480.46 | 480.46 | 479.31 | 479.51 | 43074.0 |
| 2024-10-02 06:00:00 | QQQ | ETF | 479.57 | 481.05 | 478.82 | 480.8 | 43970.0 |
| 2024-10-02 07:00:00 | QQQ | ETF | 480.69 | 481.15 | 479.95 | 480.14 | 98224.0 |
| 2024-10-02 08:00:00 | QQQ | ETF | 480.14 | 481.99 | 479.0 | 481.33 | 269471.0 |
| 2024-10-02 09:00:00 | QQQ | ETF | 481.31 | 481.38 | 477.72 | 479.68 | 3398052.0 |
| 2024-10-02 10:00:00 | QQQ | ETF | 479.75 | 483.1 | 479.4605 | 481.66 | 3378741.0 |
| 2024-10-02 11:00:00 | QQQ | ETF | 481.67 | 483.88 | 481.54 | 483.17 | 2460375.0 |
| 2024-10-02 12:00:00 | QQQ | ETF | 483.19 | 483.77 | 481.23 | 481.279 | 1721687.0 |
| 2024-10-02 13:00:00 | QQQ | ETF | 481.29 | 482.9 | 481.01 | 482.83 | 1798153.0 |
| 2024-10-02 14:00:00 | QQQ | ETF | 482.81 | 483.13 | 481.4301 | 482.3443 | 1352172.0 |
| 2024-10-02 15:00:00 | QQQ | ETF | 482.33 | 483.13 | 481.835 | 481.94 | 2385436.0 |
| 2024-10-02 16:00:00 | QQQ | ETF | 481.97 | 483.46 | 481.85 | 483.16 | 992158.0 |
| 2024-10-02 17:00:00 | QQQ | ETF | 483.12 | 483.29 | 483.0002 | 483.0006 | 40243.0 |
| 2024-10-02 18:00:00 | QQQ | ETF | 483.06 | 483.32 | 482.8 | 482.82 | 56340.0 |
| 2024-10-02 19:00:00 | QQQ | ETF | 482.83 | 483.13 | 482.55 | 483.1 | 62647.0 |
| 2024-10-02 04:00:00 | IWM | ETF | 217.08 | 217.37 | 216.77 | 216.77 | 20485.0 |
| 2024-10-02 05:00:00 | IWM | ETF | 216.67 | 216.73 | 216.16 | 216.41 | 19231.0 |
| 2024-10-02 06:00:00 | IWM | ETF | 216.35 | 216.84 | 216.0 | 216.5 | 40566.0 |
| 2024-10-02 07:00:00 | IWM | ETF | 216.53 | 216.56 | 216.03 | 216.03 | 69902.0 |
| 2024-10-02 08:00:00 | IWM | ETF | 216.12 | 217.3 | 216.06 | 216.92 | 123536.0 |
| 2024-10-02 09:00:00 | IWM | ETF | 216.94 | 217.78 | 216.21 | 217.3 | 3006649.0 |
| 2024-10-02 10:00:00 | IWM | ETF | 217.305 | 218.75 | 217.24 | 217.54 | 2096619.0 |
| 2024-10-02 11:00:00 | IWM | ETF | 217.53 | 218.28 | 217.31 | 218.218 | 1052032.0 |
| 2024-10-02 12:00:00 | IWM | ETF | 218.2 | 218.34 | 217.32 | 217.345 | 689088.0 |
| 2024-10-02 13:00:00 | IWM | ETF | 217.3401 | 218.01 | 217.03 | 217.95 | 861108.0 |
| 2024-10-02 14:00:00 | IWM | ETF | 217.93 | 218.03 | 217.27 | 217.67 | 459882.0 |
| 2024-10-02 15:00:00 | IWM | ETF | 217.665 | 217.76 | 217.325 | 217.57 | 1778390.0 |
| 2024-10-02 16:00:00 | IWM | ETF | 217.57 | 218.0 | 217.44 | 217.9 | 604401.0 |
| 2024-10-02 17:00:00 | IWM | ETF | 217.84 | 218.09 | 217.82 | 217.85 | 11278.0 |
| 2024-10-02 18:00:00 | IWM | ETF | 217.89 | 218.0 | 217.75 | 217.84 | 11638.0 |
| 2024-10-02 19:00:00 | IWM | ETF | 217.81 | 217.89 | 217.72 | 217.78 | 5393.0 |
| 2024-10-02 04:00:00 | DIA | ETF | 420.32 | 420.36 | 420.32 | 420.36 | 200.0 |
| 2024-10-02 05:00:00 | DIA | ETF | 420.1 | 420.1 | 419.62 | 419.85 | 1065.0 |
> showing 50 of 21,449 rows — these rows as CSV