PREVIEW / etf_1hour / 2024-05-28
file: by_date/etf_1hour/2024/2024-05-28.parquet size: 550 KB rows: 20,517
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-05-28 04:00:00 | SPY | ETF | 530.28 | 531.24 | 530.27 | 531.13 | 25163.0 |
| 2024-05-28 05:00:00 | SPY | ETF | 531.16 | 531.24 | 531.01 | 531.17 | 12027.0 |
| 2024-05-28 06:00:00 | SPY | ETF | 531.05 | 531.06 | 529.9 | 530.05 | 34815.0 |
| 2024-05-28 07:00:00 | SPY | ETF | 529.93 | 530.36 | 529.93 | 530.22 | 126453.0 |
| 2024-05-28 08:00:00 | SPY | ETF | 530.1 | 530.57 | 529.86 | 530.26 | 126934.0 |
| 2024-05-28 09:00:00 | SPY | ETF | 530.26 | 530.51 | 529.12 | 529.355 | 3384767.0 |
| 2024-05-28 10:00:00 | SPY | ETF | 529.35 | 530.16 | 529.0 | 529.9179 | 3004171.0 |
| 2024-05-28 11:00:00 | SPY | ETF | 529.91 | 530.1 | 529.361 | 530.0004 | 1593513.0 |
| 2024-05-28 12:00:00 | SPY | ETF | 530.0 | 530.295 | 529.64 | 529.7375 | 1527928.0 |
| 2024-05-28 13:00:00 | SPY | ETF | 529.7574 | 529.93 | 528.51 | 528.79 | 2636520.0 |
| 2024-05-28 14:00:00 | SPY | ETF | 528.78 | 529.35 | 527.11 | 528.29 | 4301559.0 |
| 2024-05-28 15:00:00 | SPY | ETF | 528.29 | 529.9 | 528.06 | 529.87 | 6738025.0 |
| 2024-05-28 16:00:00 | SPY | ETF | 529.87 | 530.38 | 529.57 | 529.74 | 3100759.0 |
| 2024-05-28 17:00:00 | SPY | ETF | 529.72 | 529.8 | 529.6 | 529.66 | 41928.0 |
| 2024-05-28 18:00:00 | SPY | ETF | 529.65 | 529.67 | 529.35 | 529.5 | 31216.0 |
| 2024-05-28 19:00:00 | SPY | ETF | 529.5 | 529.54 | 529.17 | 529.27 | 19245.0 |
| 2024-05-28 04:00:00 | QQQ | ETF | 459.09 | 460.57 | 459.09 | 460.52 | 74936.0 |
| 2024-05-28 05:00:00 | QQQ | ETF | 460.54 | 460.54 | 460.21 | 460.35 | 27560.0 |
| 2024-05-28 06:00:00 | QQQ | ETF | 460.32 | 460.38 | 459.04 | 459.16 | 122385.0 |
| 2024-05-28 07:00:00 | QQQ | ETF | 459.11 | 459.46 | 458.92 | 459.28 | 129300.0 |
| 2024-05-28 08:00:00 | QQQ | ETF | 459.005 | 460.3404 | 458.293 | 459.09 | 167955.0 |
| 2024-05-28 09:00:00 | QQQ | ETF | 459.09 | 459.56 | 457.09 | 457.8 | 2966092.0 |
| 2024-05-28 10:00:00 | QQQ | ETF | 457.77 | 459.37 | 457.25 | 459.23 | 2752141.0 |
| 2024-05-28 11:00:00 | QQQ | ETF | 459.24 | 459.54 | 458.6 | 459.18 | 1623790.0 |
| 2024-05-28 12:00:00 | QQQ | ETF | 459.18 | 459.67 | 458.87 | 459.15 | 1609721.0 |
| 2024-05-28 13:00:00 | QQQ | ETF | 459.16 | 459.71 | 458.25 | 458.7 | 1962109.0 |
| 2024-05-28 14:00:00 | QQQ | ETF | 458.66 | 459.29 | 456.69 | 457.87 | 3538547.0 |
| 2024-05-28 15:00:00 | QQQ | ETF | 457.87 | 459.74 | 457.741 | 459.68 | 4282491.0 |
| 2024-05-28 16:00:00 | QQQ | ETF | 459.67 | 460.22 | 459.66 | 459.85 | 816874.0 |
| 2024-05-28 17:00:00 | QQQ | ETF | 459.78 | 459.85 | 459.7 | 459.79 | 20516.0 |
| 2024-05-28 18:00:00 | QQQ | ETF | 459.79 | 459.8 | 459.52 | 459.63 | 31997.0 |
| 2024-05-28 19:00:00 | QQQ | ETF | 459.63 | 459.79 | 459.3 | 459.38 | 24258.0 |
| 2024-05-28 04:00:00 | IWM | ETF | 206.0 | 206.53 | 206.0 | 206.51 | 39313.0 |
| 2024-05-28 05:00:00 | IWM | ETF | 206.5 | 206.5 | 206.32 | 206.35 | 6773.0 |
| 2024-05-28 06:00:00 | IWM | ETF | 206.33 | 206.34 | 205.94 | 206.21 | 10483.0 |
| 2024-05-28 07:00:00 | IWM | ETF | 206.26 | 206.52 | 206.15 | 206.4 | 54391.0 |
| 2024-05-28 08:00:00 | IWM | ETF | 206.2987 | 206.86 | 206.0 | 206.68 | 160693.0 |
| 2024-05-28 09:00:00 | IWM | ETF | 206.63 | 207.09 | 205.82 | 205.92 | 2202742.0 |
| 2024-05-28 10:00:00 | IWM | ETF | 205.96 | 206.14 | 205.22 | 205.82 | 2365527.0 |
| 2024-05-28 11:00:00 | IWM | ETF | 205.83 | 206.305 | 205.455 | 206.23 | 1445056.0 |
| 2024-05-28 12:00:00 | IWM | ETF | 206.22 | 206.31 | 205.79 | 205.83 | 1084525.0 |
| 2024-05-28 13:00:00 | IWM | ETF | 205.831 | 205.88 | 204.831 | 205.02 | 1640183.0 |
| 2024-05-28 14:00:00 | IWM | ETF | 205.01 | 205.19 | 203.965 | 204.5 | 3016395.0 |
| 2024-05-28 15:00:00 | IWM | ETF | 204.51 | 205.22 | 204.445 | 205.18 | 2733685.0 |
| 2024-05-28 16:00:00 | IWM | ETF | 205.16 | 205.43 | 204.92 | 205.0 | 721997.0 |
| 2024-05-28 17:00:00 | IWM | ETF | 205.01 | 205.14 | 204.84 | 204.94 | 87940.0 |
| 2024-05-28 18:00:00 | IWM | ETF | 204.89 | 204.96 | 204.67 | 204.8 | 83784.0 |
| 2024-05-28 19:00:00 | IWM | ETF | 204.84 | 204.84 | 204.54 | 204.54 | 10512.0 |
| 2024-05-28 04:00:00 | DIA | ETF | 390.92 | 390.98 | 390.91 | 390.98 | 419.0 |
| 2024-05-28 05:00:00 | DIA | ETF | 390.96 | 390.99 | 390.94 | 390.97 | 1268.0 |
> showing 50 of 20,517 rows — these rows as CSV