PREVIEW / etf_1hour / 2024-04-18
file: by_date/etf_1hour/2024/2024-04-18.parquet size: 528 KB rows: 19,510
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-18 04:00:00 | SPY | ETF | 502.68 | 502.7 | 501.82 | 501.99 | 12764.0 |
| 2024-04-18 05:00:00 | SPY | ETF | 502.04 | 502.19 | 501.1 | 501.81 | 18286.0 |
| 2024-04-18 06:00:00 | SPY | ETF | 501.7 | 502.33 | 501.42 | 502.04 | 41622.0 |
| 2024-04-18 07:00:00 | SPY | ETF | 501.99 | 502.52 | 501.4 | 502.24 | 271738.0 |
| 2024-04-18 08:00:00 | SPY | ETF | 502.19 | 502.86 | 501.04 | 501.58 | 371693.0 |
| 2024-04-18 09:00:00 | SPY | ETF | 501.7 | 502.32 | 499.73 | 501.18 | 6275001.0 |
| 2024-04-18 10:00:00 | SPY | ETF | 501.17 | 503.82 | 500.35 | 503.39 | 7772759.0 |
| 2024-04-18 11:00:00 | SPY | ETF | 503.385 | 504.13 | 502.63 | 502.885 | 5317034.0 |
| 2024-04-18 12:00:00 | SPY | ETF | 502.88 | 503.34 | 500.62 | 500.79 | 5071470.0 |
| 2024-04-18 13:00:00 | SPY | ETF | 500.78 | 501.14 | 498.8701 | 499.62 | 7760811.0 |
| 2024-04-18 14:00:00 | SPY | ETF | 499.61 | 500.44 | 498.56 | 498.96 | 7113948.0 |
| 2024-04-18 15:00:00 | SPY | ETF | 498.96 | 500.83 | 498.96 | 499.48 | 11592264.0 |
| 2024-04-18 16:00:00 | SPY | ETF | 499.48 | 500.15 | 499.01 | 499.45 | 2869999.0 |
| 2024-04-18 17:00:00 | SPY | ETF | 499.45 | 499.46 | 499.21 | 499.36 | 85389.0 |
| 2024-04-18 18:00:00 | SPY | ETF | 499.38 | 499.76 | 499.35 | 499.37 | 85134.0 |
| 2024-04-18 19:00:00 | SPY | ETF | 499.38 | 499.41 | 498.38 | 498.68 | 71527.0 |
| 2024-04-18 04:00:00 | QQQ | ETF | 428.31 | 428.7 | 427.5 | 427.71 | 57108.0 |
| 2024-04-18 05:00:00 | QQQ | ETF | 427.66 | 427.89 | 426.65 | 427.35 | 47979.0 |
| 2024-04-18 06:00:00 | QQQ | ETF | 427.29 | 427.63 | 426.83 | 427.44 | 55783.0 |
| 2024-04-18 07:00:00 | QQQ | ETF | 427.38 | 427.73 | 427.07 | 427.37 | 145951.0 |
| 2024-04-18 08:00:00 | QQQ | ETF | 428.23 | 428.9 | 426.29 | 426.61 | 599742.0 |
| 2024-04-18 09:00:00 | QQQ | ETF | 426.75 | 427.0104 | 423.53 | 424.98 | 6076756.0 |
| 2024-04-18 10:00:00 | QQQ | ETF | 424.96 | 427.88 | 424.3 | 427.41 | 5182988.0 |
| 2024-04-18 11:00:00 | QQQ | ETF | 427.41 | 428.24 | 426.74 | 426.96 | 3671779.0 |
| 2024-04-18 12:00:00 | QQQ | ETF | 426.96 | 427.425 | 424.78 | 424.965 | 3415366.0 |
| 2024-04-18 13:00:00 | QQQ | ETF | 424.98 | 425.31 | 423.2 | 423.8 | 4347703.0 |
| 2024-04-18 14:00:00 | QQQ | ETF | 423.77 | 424.62 | 422.83 | 423.1 | 3481764.0 |
| 2024-04-18 15:00:00 | QQQ | ETF | 423.12 | 424.54 | 423.01 | 423.36 | 6162981.0 |
| 2024-04-18 16:00:00 | QQQ | ETF | 423.36 | 424.8 | 422.52 | 423.0 | 1760076.0 |
| 2024-04-18 17:00:00 | QQQ | ETF | 422.98 | 423.0496 | 422.8 | 422.96 | 70916.0 |
| 2024-04-18 18:00:00 | QQQ | ETF | 422.99 | 423.41 | 422.8 | 422.8699 | 58539.0 |
| 2024-04-18 19:00:00 | QQQ | ETF | 422.84 | 422.85 | 421.77 | 422.02 | 83628.0 |
| 2024-04-18 04:00:00 | IWM | ETF | 193.6 | 193.63 | 193.3 | 193.42 | 22409.0 |
| 2024-04-18 05:00:00 | IWM | ETF | 193.4 | 193.46 | 192.97 | 193.26 | 10248.0 |
| 2024-04-18 06:00:00 | IWM | ETF | 193.23 | 193.6 | 193.17 | 193.48 | 25381.0 |
| 2024-04-18 07:00:00 | IWM | ETF | 193.47 | 193.87 | 193.15 | 193.85 | 68097.0 |
| 2024-04-18 08:00:00 | IWM | ETF | 193.4792 | 194.18 | 192.99 | 193.56 | 147157.0 |
| 2024-04-18 09:00:00 | IWM | ETF | 193.68 | 194.5 | 192.6 | 193.71 | 3202619.0 |
| 2024-04-18 10:00:00 | IWM | ETF | 193.71 | 195.27 | 193.125 | 195.1125 | 3879716.0 |
| 2024-04-18 11:00:00 | IWM | ETF | 195.12 | 195.655 | 194.655 | 194.81 | 2764996.0 |
| 2024-04-18 12:00:00 | IWM | ETF | 194.81 | 195.11 | 193.76 | 194.0 | 2935419.0 |
| 2024-04-18 13:00:00 | IWM | ETF | 194.0 | 194.15 | 192.93 | 193.33 | 4212087.0 |
| 2024-04-18 14:00:00 | IWM | ETF | 193.32 | 193.32 | 192.15 | 192.59 | 4464643.0 |
| 2024-04-18 15:00:00 | IWM | ETF | 192.58 | 193.29 | 192.55 | 192.78 | 5339459.0 |
| 2024-04-18 16:00:00 | IWM | ETF | 192.84 | 193.0 | 192.53 | 192.8 | 1760532.0 |
| 2024-04-18 17:00:00 | IWM | ETF | 192.8 | 192.84 | 192.6 | 192.77 | 15114.0 |
| 2024-04-18 18:00:00 | IWM | ETF | 192.84 | 193.02 | 192.7 | 192.7 | 173152.0 |
| 2024-04-18 19:00:00 | IWM | ETF | 192.66 | 192.69 | 192.16 | 192.32 | 22671.0 |
| 2024-04-18 04:00:00 | DIA | ETF | 378.52 | 378.52 | 378.17 | 378.17 | 450.0 |
| 2024-04-18 05:00:00 | DIA | ETF | 377.7 | 377.7 | 377.7 | 377.7 | 100.0 |
> showing 50 of 19,510 rows — these rows as CSV