PREVIEW / etf_1hour / 2024-06-25
file: by_date/etf_1hour/2024/2024-06-25.parquet size: 541 KB rows: 20,045
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-25 04:00:00 | SPY | ETF | 542.69 | 543.6 | 542.46 | 543.59 | 38310.0 |
| 2024-06-25 05:00:00 | SPY | ETF | 543.62 | 544.0 | 543.51 | 544.0 | 21455.0 |
| 2024-06-25 06:00:00 | SPY | ETF | 544.0 | 544.03 | 543.72 | 543.96 | 9029.0 |
| 2024-06-25 07:00:00 | SPY | ETF | 543.89 | 544.15 | 543.37 | 543.92 | 207862.0 |
| 2024-06-25 08:00:00 | SPY | ETF | 543.9996 | 544.15 | 542.8 | 543.97 | 158687.0 |
| 2024-06-25 09:00:00 | SPY | ETF | 543.92 | 544.32 | 543.03 | 543.1 | 2785908.0 |
| 2024-06-25 10:00:00 | SPY | ETF | 543.12 | 544.26 | 543.03 | 543.665 | 2610886.0 |
| 2024-06-25 11:00:00 | SPY | ETF | 543.67 | 544.48 | 543.5389 | 544.35 | 2544425.0 |
| 2024-06-25 12:00:00 | SPY | ETF | 544.34 | 544.35 | 542.53 | 542.9502 | 2173384.0 |
| 2024-06-25 13:00:00 | SPY | ETF | 542.95 | 544.152 | 542.44 | 543.98 | 2103381.0 |
| 2024-06-25 14:00:00 | SPY | ETF | 543.99 | 544.87 | 543.8 | 544.425 | 3104934.0 |
| 2024-06-25 15:00:00 | SPY | ETF | 544.42 | 545.2 | 544.17 | 544.78 | 6204962.0 |
| 2024-06-25 16:00:00 | SPY | ETF | 544.77 | 544.83 | 544.44 | 544.77 | 3080561.0 |
| 2024-06-25 17:00:00 | SPY | ETF | 544.65 | 544.88 | 544.65 | 544.79 | 42765.0 |
| 2024-06-25 18:00:00 | SPY | ETF | 544.75 | 544.98 | 544.6 | 544.84 | 327894.0 |
| 2024-06-25 19:00:00 | SPY | ETF | 544.87 | 544.88 | 544.6898 | 544.6898 | 35121.0 |
| 2024-06-25 04:00:00 | QQQ | ETF | 473.88 | 475.82 | 473.71 | 475.78 | 65926.0 |
| 2024-06-25 05:00:00 | QQQ | ETF | 475.79 | 476.34 | 475.7 | 476.29 | 57957.0 |
| 2024-06-25 06:00:00 | QQQ | ETF | 476.34 | 476.43 | 475.93 | 476.21 | 35884.0 |
| 2024-06-25 07:00:00 | QQQ | ETF | 476.2 | 476.54 | 475.53 | 475.82 | 125242.0 |
| 2024-06-25 08:00:00 | QQQ | ETF | 476.2 | 476.53 | 474.06 | 476.13 | 155501.0 |
| 2024-06-25 09:00:00 | QQQ | ETF | 476.19 | 476.57 | 475.12 | 476.08 | 2413155.0 |
| 2024-06-25 10:00:00 | QQQ | ETF | 476.11 | 477.76 | 476.04 | 476.92 | 2550813.0 |
| 2024-06-25 11:00:00 | QQQ | ETF | 476.93 | 479.17 | 476.93 | 479.13 | 2439437.0 |
| 2024-06-25 12:00:00 | QQQ | ETF | 479.13 | 479.33 | 476.69 | 477.115 | 2057196.0 |
| 2024-06-25 13:00:00 | QQQ | ETF | 477.1 | 478.51 | 476.275 | 478.328 | 1591139.0 |
| 2024-06-25 14:00:00 | QQQ | ETF | 478.34 | 479.3 | 478.13 | 478.92 | 1919353.0 |
| 2024-06-25 15:00:00 | QQQ | ETF | 478.94 | 479.68 | 478.55 | 479.36 | 3165052.0 |
| 2024-06-25 16:00:00 | QQQ | ETF | 479.36 | 479.47 | 479.1 | 479.41 | 1917424.0 |
| 2024-06-25 17:00:00 | QQQ | ETF | 479.4008 | 479.72 | 479.4008 | 479.72 | 41015.0 |
| 2024-06-25 18:00:00 | QQQ | ETF | 479.69 | 479.83 | 479.37 | 479.5701 | 62535.0 |
| 2024-06-25 19:00:00 | QQQ | ETF | 479.59 | 479.59 | 479.33 | 479.35 | 36870.0 |
| 2024-06-25 04:00:00 | IWM | ETF | 201.6 | 201.77 | 201.22 | 201.36 | 8904.0 |
| 2024-06-25 05:00:00 | IWM | ETF | 201.35 | 201.35 | 201.17 | 201.21 | 3490.0 |
| 2024-06-25 06:00:00 | IWM | ETF | 201.21 | 201.26 | 201.1 | 201.24 | 16887.0 |
| 2024-06-25 07:00:00 | IWM | ETF | 201.2 | 201.38 | 201.0 | 201.33 | 26809.0 |
| 2024-06-25 08:00:00 | IWM | ETF | 201.22 | 201.97 | 200.6501 | 200.92 | 137251.0 |
| 2024-06-25 09:00:00 | IWM | ETF | 200.85 | 201.16 | 199.92 | 199.97 | 2224869.0 |
| 2024-06-25 10:00:00 | IWM | ETF | 199.955 | 200.915 | 199.87 | 200.49 | 2562391.0 |
| 2024-06-25 11:00:00 | IWM | ETF | 200.49 | 200.55 | 200.08 | 200.15 | 1292729.0 |
| 2024-06-25 12:00:00 | IWM | ETF | 200.155 | 200.205 | 199.82 | 200.05 | 1184427.0 |
| 2024-06-25 13:00:00 | IWM | ETF | 200.04 | 200.63 | 199.93 | 200.49 | 820368.0 |
| 2024-06-25 14:00:00 | IWM | ETF | 200.47 | 200.72 | 200.19 | 200.335 | 1201078.0 |
| 2024-06-25 15:00:00 | IWM | ETF | 200.34 | 200.655 | 200.19 | 200.51 | 2494446.0 |
| 2024-06-25 16:00:00 | IWM | ETF | 200.56 | 200.56 | 200.36 | 200.45 | 847409.0 |
| 2024-06-25 17:00:00 | IWM | ETF | 200.42 | 200.56 | 200.42 | 200.47 | 13590.0 |
| 2024-06-25 18:00:00 | IWM | ETF | 200.46 | 200.56 | 200.3 | 200.38 | 86848.0 |
| 2024-06-25 19:00:00 | IWM | ETF | 200.43 | 200.43 | 200.31 | 200.38 | 3794.0 |
| 2024-06-25 04:00:00 | DIA | ETF | 394.34 | 394.38 | 394.34 | 394.38 | 1080.0 |
| 2024-06-25 05:00:00 | DIA | ETF | 393.79 | 393.85 | 393.79 | 393.85 | 200.0 |
> showing 50 of 20,045 rows — these rows as CSV