PREVIEW / etf_1hour / 2024-02-02
file: by_date/etf_1hour/2024/2024-02-02.parquet size: 542 KB rows: 20,106
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-02 04:00:00 | SPY | ETF | 491.95 | 492.36 | 491.56 | 491.8 | 52621.0 |
| 2024-02-02 05:00:00 | SPY | ETF | 491.83 | 492.04 | 491.83 | 491.92 | 25734.0 |
| 2024-02-02 06:00:00 | SPY | ETF | 491.89 | 492.24 | 491.76 | 492.22 | 24731.0 |
| 2024-02-02 07:00:00 | SPY | ETF | 492.23 | 492.66 | 492.0 | 492.55 | 126716.0 |
| 2024-02-02 08:00:00 | SPY | ETF | 492.2103 | 492.71 | 489.11 | 489.31 | 2266284.0 |
| 2024-02-02 09:00:00 | SPY | ETF | 489.29 | 490.95 | 488.95 | 490.49 | 7823878.0 |
| 2024-02-02 10:00:00 | SPY | ETF | 490.43 | 492.42 | 490.0 | 492.18 | 10652950.0 |
| 2024-02-02 11:00:00 | SPY | ETF | 492.19 | 494.04 | 491.635 | 493.57 | 8777060.0 |
| 2024-02-02 12:00:00 | SPY | ETF | 493.57 | 494.66 | 492.25 | 493.64 | 9331147.0 |
| 2024-02-02 13:00:00 | SPY | ETF | 493.67 | 494.545 | 493.314 | 494.275 | 6117952.0 |
| 2024-02-02 14:00:00 | SPY | ETF | 494.3 | 495.75 | 494.3 | 495.67 | 8352768.0 |
| 2024-02-02 15:00:00 | SPY | ETF | 495.68 | 496.05 | 494.26 | 494.27 | 15701725.0 |
| 2024-02-02 16:00:00 | SPY | ETF | 494.26 | 494.7103 | 492.2469 | 493.63 | 4725332.0 |
| 2024-02-02 17:00:00 | SPY | ETF | 493.76 | 494.3706 | 493.51 | 494.3 | 1957617.0 |
| 2024-02-02 18:00:00 | SPY | ETF | 494.3 | 494.39 | 494.19 | 494.19 | 24582.0 |
| 2024-02-02 19:00:00 | SPY | ETF | 494.19 | 494.19 | 493.1 | 493.61 | 63925.0 |
| 2024-02-02 04:00:00 | QQQ | ETF | 426.44 | 426.86 | 426.03 | 426.17 | 85183.0 |
| 2024-02-02 05:00:00 | QQQ | ETF | 426.29 | 426.66 | 426.01 | 426.34 | 27319.0 |
| 2024-02-02 06:00:00 | QQQ | ETF | 426.22 | 426.47 | 426.11 | 426.45 | 61310.0 |
| 2024-02-02 07:00:00 | QQQ | ETF | 426.46 | 427.06 | 426.14 | 426.62 | 292996.0 |
| 2024-02-02 08:00:00 | QQQ | ETF | 426.5 | 427.05 | 421.564 | 423.53 | 1946695.0 |
| 2024-02-02 09:00:00 | QQQ | ETF | 423.53 | 426.62 | 422.79 | 425.84 | 7704303.0 |
| 2024-02-02 10:00:00 | QQQ | ETF | 425.8 | 427.61 | 424.8 | 426.96 | 7338476.0 |
| 2024-02-02 11:00:00 | QQQ | ETF | 426.98 | 428.85 | 426.18 | 428.4801 | 5162038.0 |
| 2024-02-02 12:00:00 | QQQ | ETF | 428.5 | 429.79 | 427.55 | 428.67 | 5685576.0 |
| 2024-02-02 13:00:00 | QQQ | ETF | 428.68 | 429.36 | 427.98 | 429.12 | 3842845.0 |
| 2024-02-02 14:00:00 | QQQ | ETF | 429.14 | 430.24 | 429.11 | 429.93 | 4311718.0 |
| 2024-02-02 15:00:00 | QQQ | ETF | 429.93 | 430.22 | 429.13 | 429.145 | 7384108.0 |
| 2024-02-02 16:00:00 | QQQ | ETF | 429.16 | 429.17 | 427.8375 | 428.14 | 2387917.0 |
| 2024-02-02 17:00:00 | QQQ | ETF | 428.13 | 429.01 | 428.13 | 428.55 | 401258.0 |
| 2024-02-02 18:00:00 | QQQ | ETF | 428.5944 | 428.66 | 428.35 | 428.44 | 31366.0 |
| 2024-02-02 19:00:00 | QQQ | ETF | 428.54 | 428.54 | 428.15 | 428.16 | 10410.0 |
| 2024-02-02 04:00:00 | IWM | ETF | 195.85 | 195.85 | 195.5 | 195.59 | 25356.0 |
| 2024-02-02 05:00:00 | IWM | ETF | 195.61 | 195.97 | 195.57 | 195.75 | 12449.0 |
| 2024-02-02 06:00:00 | IWM | ETF | 195.72 | 195.73 | 195.54 | 195.61 | 11076.0 |
| 2024-02-02 07:00:00 | IWM | ETF | 195.65 | 196.0 | 195.53 | 195.86 | 62046.0 |
| 2024-02-02 08:00:00 | IWM | ETF | 195.88 | 196.12 | 193.11 | 193.62 | 2092341.0 |
| 2024-02-02 09:00:00 | IWM | ETF | 193.47 | 193.81 | 192.42 | 193.3 | 6763938.0 |
| 2024-02-02 10:00:00 | IWM | ETF | 193.27 | 194.23 | 192.39 | 193.72 | 7277648.0 |
| 2024-02-02 11:00:00 | IWM | ETF | 193.72 | 194.405 | 193.41 | 193.94 | 5863223.0 |
| 2024-02-02 12:00:00 | IWM | ETF | 193.92 | 194.47 | 192.94 | 193.61 | 4941578.0 |
| 2024-02-02 13:00:00 | IWM | ETF | 193.61 | 194.25 | 193.34 | 193.9 | 3071920.0 |
| 2024-02-02 14:00:00 | IWM | ETF | 193.91 | 195.24 | 193.9 | 194.89 | 5471022.0 |
| 2024-02-02 15:00:00 | IWM | ETF | 194.89 | 195.5 | 194.4 | 194.45 | 6867435.0 |
| 2024-02-02 16:00:00 | IWM | ETF | 194.41 | 194.44 | 193.89 | 193.95 | 758156.0 |
| 2024-02-02 17:00:00 | IWM | ETF | 193.96 | 194.33 | 193.96 | 194.15 | 24723.0 |
| 2024-02-02 18:00:00 | IWM | ETF | 194.25 | 194.25 | 194.05 | 194.13 | 12684.0 |
| 2024-02-02 19:00:00 | IWM | ETF | 194.19 | 194.19 | 194.01 | 194.01 | 11543.0 |
| 2024-02-02 04:00:00 | DIA | ETF | 385.28 | 385.28 | 384.98 | 384.98 | 4550.0 |
| 2024-02-02 05:00:00 | DIA | ETF | 385.16 | 385.19 | 385.16 | 385.16 | 550.0 |
> showing 50 of 20,106 rows — these rows as CSV