PREVIEW / etf_1hour / 2024-04-02
file: by_date/etf_1hour/2024/2024-04-02.parquet size: 550 KB rows: 20,417
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-04-02 04:00:00 | SPY | ETF | 521.79 | 522.36 | 521.57 | 521.74 | 11136.0 |
| 2024-04-02 05:00:00 | SPY | ETF | 521.78 | 522.05 | 521.67 | 521.67 | 4423.0 |
| 2024-04-02 06:00:00 | SPY | ETF | 521.5 | 521.5 | 520.8 | 521.2 | 29060.0 |
| 2024-04-02 07:00:00 | SPY | ETF | 521.17 | 521.22 | 520.24 | 520.25 | 141430.0 |
| 2024-04-02 08:00:00 | SPY | ETF | 521.68 | 522.3996 | 518.8 | 518.89 | 472964.0 |
| 2024-04-02 09:00:00 | SPY | ETF | 518.9 | 518.99 | 516.85 | 517.6 | 7683522.0 |
| 2024-04-02 10:00:00 | SPY | ETF | 517.61 | 518.01 | 516.48 | 516.965 | 8638048.0 |
| 2024-04-02 11:00:00 | SPY | ETF | 516.96 | 517.865 | 516.86 | 517.1276 | 4315426.0 |
| 2024-04-02 12:00:00 | SPY | ETF | 517.125 | 518.0 | 516.9 | 517.97 | 4177306.0 |
| 2024-04-02 13:00:00 | SPY | ETF | 517.98 | 518.12 | 517.35 | 517.75 | 4052500.0 |
| 2024-04-02 14:00:00 | SPY | ETF | 517.76 | 518.14 | 517.64 | 517.79 | 3708773.0 |
| 2024-04-02 15:00:00 | SPY | ETF | 517.79 | 518.98 | 517.73 | 518.85 | 16217409.0 |
| 2024-04-02 16:00:00 | SPY | ETF | 518.85 | 519.12 | 518.167 | 519.011 | 3265285.0 |
| 2024-04-02 17:00:00 | SPY | ETF | 519.0 | 519.14 | 518.84 | 519.12 | 79624.0 |
| 2024-04-02 18:00:00 | SPY | ETF | 519.07 | 519.09 | 518.73 | 518.73 | 80412.0 |
| 2024-04-02 19:00:00 | SPY | ETF | 518.76 | 518.83 | 518.7 | 518.72 | 27467.0 |
| 2024-04-02 04:00:00 | QQQ | ETF | 444.62 | 445.32 | 444.4 | 444.51 | 25453.0 |
| 2024-04-02 05:00:00 | QQQ | ETF | 444.65 | 444.79 | 444.23 | 444.23 | 16755.0 |
| 2024-04-02 06:00:00 | QQQ | ETF | 444.0 | 444.18 | 443.23 | 443.75 | 44261.0 |
| 2024-04-02 07:00:00 | QQQ | ETF | 443.65 | 443.784 | 442.73 | 442.8 | 114681.0 |
| 2024-04-02 08:00:00 | QQQ | ETF | 442.84 | 445.3704 | 441.09 | 441.3 | 394731.0 |
| 2024-04-02 09:00:00 | QQQ | ETF | 441.27 | 441.3 | 438.55 | 439.33 | 6032793.0 |
| 2024-04-02 10:00:00 | QQQ | ETF | 439.32 | 439.79 | 438.03 | 438.3851 | 6438020.0 |
| 2024-04-02 11:00:00 | QQQ | ETF | 438.39 | 440.02 | 438.3 | 438.78 | 3878834.0 |
| 2024-04-02 12:00:00 | QQQ | ETF | 438.77 | 440.15 | 438.74 | 440.13 | 2727492.0 |
| 2024-04-02 13:00:00 | QQQ | ETF | 440.15 | 440.37 | 439.635 | 439.8151 | 3056892.0 |
| 2024-04-02 14:00:00 | QQQ | ETF | 439.82 | 440.28 | 439.59 | 439.84 | 2076763.0 |
| 2024-04-02 15:00:00 | QQQ | ETF | 439.83 | 441.43 | 439.79 | 441.07 | 7468103.0 |
| 2024-04-02 16:00:00 | QQQ | ETF | 441.07 | 441.46 | 441.01 | 441.4 | 1222506.0 |
| 2024-04-02 17:00:00 | QQQ | ETF | 441.4 | 441.43 | 441.32 | 441.38 | 31994.0 |
| 2024-04-02 18:00:00 | QQQ | ETF | 441.34 | 441.34 | 440.96 | 440.97 | 46167.0 |
| 2024-04-02 19:00:00 | QQQ | ETF | 440.99 | 441.12 | 440.95 | 441.0 | 27499.0 |
| 2024-04-02 04:00:00 | IWM | ETF | 208.63 | 208.99 | 208.3 | 208.35 | 21492.0 |
| 2024-04-02 05:00:00 | IWM | ETF | 208.36 | 208.52 | 207.9 | 207.93 | 10257.0 |
| 2024-04-02 06:00:00 | IWM | ETF | 207.86 | 207.86 | 207.29 | 207.6 | 56989.0 |
| 2024-04-02 07:00:00 | IWM | ETF | 207.55 | 207.55 | 206.95 | 206.96 | 105592.0 |
| 2024-04-02 08:00:00 | IWM | ETF | 207.55 | 208.454 | 206.17 | 206.19 | 299649.0 |
| 2024-04-02 09:00:00 | IWM | ETF | 206.2 | 206.27 | 204.58 | 205.2 | 4268763.0 |
| 2024-04-02 10:00:00 | IWM | ETF | 205.21 | 205.58 | 204.27 | 204.35 | 4559036.0 |
| 2024-04-02 11:00:00 | IWM | ETF | 204.36 | 204.73 | 203.995 | 204.04 | 2892202.0 |
| 2024-04-02 12:00:00 | IWM | ETF | 204.04 | 204.1276 | 203.73 | 204.08 | 2345843.0 |
| 2024-04-02 13:00:00 | IWM | ETF | 204.09 | 204.11 | 203.4 | 203.59 | 2163420.0 |
| 2024-04-02 14:00:00 | IWM | ETF | 203.59 | 204.055 | 203.58 | 203.9 | 1504934.0 |
| 2024-04-02 15:00:00 | IWM | ETF | 203.9 | 204.69 | 203.76 | 204.54 | 6342513.0 |
| 2024-04-02 16:00:00 | IWM | ETF | 204.49 | 204.92 | 204.49 | 204.78 | 1476134.0 |
| 2024-04-02 17:00:00 | IWM | ETF | 204.8 | 204.85 | 204.7 | 204.79 | 11889.0 |
| 2024-04-02 18:00:00 | IWM | ETF | 204.89 | 204.89 | 204.73 | 204.77 | 11714.0 |
| 2024-04-02 19:00:00 | IWM | ETF | 204.74 | 204.8 | 204.63 | 204.63 | 35707.0 |
| 2024-04-02 07:00:00 | DIA | ETF | 393.99 | 394.0 | 393.47 | 393.48 | 3289.0 |
| 2024-04-02 08:00:00 | DIA | ETF | 394.01 | 394.01 | 392.3 | 392.33 | 6286.0 |
> showing 50 of 20,417 rows — these rows as CSV