PREVIEW / etf_1hour / 2024-06-26
file: by_date/etf_1hour/2024/2024-06-26.parquet size: 533 KB rows: 19,935
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-06-26 04:00:00 | SPY | ETF | 546.19 | 546.55 | 546.1 | 546.25 | 23871.0 |
| 2024-06-26 05:00:00 | SPY | ETF | 546.06 | 546.17 | 545.68 | 545.68 | 7289.0 |
| 2024-06-26 06:00:00 | SPY | ETF | 545.55 | 545.61 | 545.13 | 545.2 | 16188.0 |
| 2024-06-26 07:00:00 | SPY | ETF | 545.08 | 545.17 | 544.64 | 544.98 | 45243.0 |
| 2024-06-26 08:00:00 | SPY | ETF | 545.05 | 546.01 | 543.73 | 543.8 | 219780.0 |
| 2024-06-26 09:00:00 | SPY | ETF | 543.74 | 544.39 | 543.17 | 544.115 | 2657956.0 |
| 2024-06-26 10:00:00 | SPY | ETF | 544.11 | 544.8 | 543.62 | 544.21 | 3775708.0 |
| 2024-06-26 11:00:00 | SPY | ETF | 544.2 | 545.45 | 543.03 | 545.32 | 2758635.0 |
| 2024-06-26 12:00:00 | SPY | ETF | 545.32 | 545.42 | 544.26 | 544.76 | 2373768.0 |
| 2024-06-26 13:00:00 | SPY | ETF | 544.75 | 545.02 | 544.01 | 544.865 | 1533631.0 |
| 2024-06-26 14:00:00 | SPY | ETF | 544.87 | 545.115 | 544.3 | 544.545 | 1849212.0 |
| 2024-06-26 15:00:00 | SPY | ETF | 544.55 | 546.24 | 544.13 | 545.52 | 5976507.0 |
| 2024-06-26 16:00:00 | SPY | ETF | 545.52 | 545.649 | 544.33 | 544.82 | 3830400.0 |
| 2024-06-26 17:00:00 | SPY | ETF | 544.75 | 544.87 | 544.6 | 544.6 | 39611.0 |
| 2024-06-26 18:00:00 | SPY | ETF | 544.76 | 544.96 | 544.3 | 544.42 | 38539.0 |
| 2024-06-26 19:00:00 | SPY | ETF | 544.36 | 544.4 | 543.79 | 543.98 | 42771.0 |
| 2024-06-26 04:00:00 | QQQ | ETF | 480.52 | 481.95 | 480.51 | 481.4 | 64923.0 |
| 2024-06-26 05:00:00 | QQQ | ETF | 481.33 | 481.41 | 480.81 | 480.86 | 31008.0 |
| 2024-06-26 06:00:00 | QQQ | ETF | 480.76 | 480.84 | 480.14 | 480.14 | 29544.0 |
| 2024-06-26 07:00:00 | QQQ | ETF | 480.17 | 480.43 | 479.81 | 480.25 | 64236.0 |
| 2024-06-26 08:00:00 | QQQ | ETF | 480.37 | 481.71 | 478.6 | 478.67 | 216152.0 |
| 2024-06-26 09:00:00 | QQQ | ETF | 478.56 | 480.27 | 477.89 | 479.61 | 2361908.0 |
| 2024-06-26 10:00:00 | QQQ | ETF | 479.59 | 480.83 | 478.95 | 479.6385 | 2478159.0 |
| 2024-06-26 11:00:00 | QQQ | ETF | 479.66 | 480.88 | 478.13 | 480.66 | 2465516.0 |
| 2024-06-26 12:00:00 | QQQ | ETF | 480.67 | 480.73 | 478.93 | 479.66 | 1459630.0 |
| 2024-06-26 13:00:00 | QQQ | ETF | 479.63 | 480.04 | 478.72 | 479.9 | 1092944.0 |
| 2024-06-26 14:00:00 | QQQ | ETF | 479.9 | 479.925 | 479.04 | 479.11 | 1350057.0 |
| 2024-06-26 15:00:00 | QQQ | ETF | 479.1 | 480.92 | 478.535 | 480.39 | 2820453.0 |
| 2024-06-26 16:00:00 | QQQ | ETF | 480.37 | 480.42 | 477.6 | 479.14 | 1810453.0 |
| 2024-06-26 17:00:00 | QQQ | ETF | 479.14 | 480.37 | 478.92 | 479.0 | 173006.0 |
| 2024-06-26 18:00:00 | QQQ | ETF | 479.11 | 479.33 | 478.46 | 478.63 | 49944.0 |
| 2024-06-26 19:00:00 | QQQ | ETF | 478.59 | 478.59 | 478.05 | 478.29 | 59031.0 |
| 2024-06-26 04:00:00 | IWM | ETF | 200.67 | 200.76 | 200.64 | 200.71 | 15356.0 |
| 2024-06-26 05:00:00 | IWM | ETF | 200.61 | 200.76 | 200.34 | 200.45 | 14929.0 |
| 2024-06-26 06:00:00 | IWM | ETF | 200.43 | 200.43 | 199.98 | 199.98 | 19616.0 |
| 2024-06-26 07:00:00 | IWM | ETF | 199.99 | 199.99 | 199.63 | 199.85 | 61628.0 |
| 2024-06-26 08:00:00 | IWM | ETF | 199.82 | 200.6896 | 199.4 | 199.43 | 92285.0 |
| 2024-06-26 09:00:00 | IWM | ETF | 199.43 | 199.78 | 198.8101 | 199.63 | 1931591.0 |
| 2024-06-26 10:00:00 | IWM | ETF | 199.64 | 199.99 | 199.24 | 199.77 | 1754109.0 |
| 2024-06-26 11:00:00 | IWM | ETF | 199.8 | 200.58 | 199.23 | 200.365 | 1657318.0 |
| 2024-06-26 12:00:00 | IWM | ETF | 200.37 | 200.37 | 199.74 | 199.86 | 1545332.0 |
| 2024-06-26 13:00:00 | IWM | ETF | 199.86 | 199.93 | 199.365 | 199.55 | 1413412.0 |
| 2024-06-26 14:00:00 | IWM | ETF | 199.555 | 199.86 | 199.38 | 199.68 | 1590469.0 |
| 2024-06-26 15:00:00 | IWM | ETF | 199.67 | 200.225 | 199.5 | 200.07 | 3155649.0 |
| 2024-06-26 16:00:00 | IWM | ETF | 200.03 | 200.15 | 199.72 | 199.91 | 1030752.0 |
| 2024-06-26 17:00:00 | IWM | ETF | 200.03 | 200.03 | 199.58 | 199.7 | 210764.0 |
| 2024-06-26 18:00:00 | IWM | ETF | 199.86 | 200.03 | 199.5907 | 199.68 | 28281.0 |
| 2024-06-26 19:00:00 | IWM | ETF | 199.64 | 199.65 | 199.34 | 199.42 | 19556.0 |
| 2024-06-26 04:00:00 | DIA | ETF | 391.29 | 391.31 | 391.29 | 391.31 | 600.0 |
| 2024-06-26 05:00:00 | DIA | ETF | 390.97 | 390.97 | 390.89 | 390.89 | 200.0 |
> showing 50 of 19,935 rows — these rows as CSV