PREVIEW / etf_1hour / 2024-11-12
file: by_date/etf_1hour/2024/2024-11-12.parquet size: 614 KB rows: 22,850
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-11-12 04:00:00 | SPY | ETF | 598.57 | 598.71 | 597.64 | 597.64 | 27820.0 |
| 2024-11-12 05:00:00 | SPY | ETF | 597.65 | 597.69 | 596.91 | 597.5 | 68040.0 |
| 2024-11-12 06:00:00 | SPY | ETF | 597.44 | 598.02 | 597.44 | 597.79 | 32701.0 |
| 2024-11-12 07:00:00 | SPY | ETF | 597.79 | 598.34 | 597.75 | 598.0 | 161431.0 |
| 2024-11-12 08:00:00 | SPY | ETF | 598.12 | 598.74 | 597.75 | 598.64 | 167646.0 |
| 2024-11-12 09:00:00 | SPY | ETF | 598.69 | 599.29 | 598.25 | 598.95 | 2817580.0 |
| 2024-11-12 10:00:00 | SPY | ETF | 598.95 | 599.015 | 597.2 | 597.23 | 3232785.0 |
| 2024-11-12 11:00:00 | SPY | ETF | 597.2299 | 597.578 | 596.324 | 596.445 | 2394719.0 |
| 2024-11-12 12:00:00 | SPY | ETF | 596.435 | 596.7176 | 594.57 | 594.67 | 2289117.0 |
| 2024-11-12 13:00:00 | SPY | ETF | 594.67 | 597.78 | 594.37 | 597.425 | 3116718.0 |
| 2024-11-12 14:00:00 | SPY | ETF | 597.41 | 598.4 | 597.3315 | 598.01 | 2982807.0 |
| 2024-11-12 15:00:00 | SPY | ETF | 598.015 | 598.2 | 596.51 | 596.87 | 6630689.0 |
| 2024-11-12 16:00:00 | SPY | ETF | 596.87 | 597.5 | 596.77 | 596.9 | 2289765.0 |
| 2024-11-12 17:00:00 | SPY | ETF | 596.84 | 597.05 | 596.71 | 596.79 | 162351.0 |
| 2024-11-12 18:00:00 | SPY | ETF | 596.83 | 596.9 | 596.04 | 596.44 | 98125.0 |
| 2024-11-12 19:00:00 | SPY | ETF | 596.39 | 596.45 | 595.94 | 596.1152 | 28635.0 |
| 2024-11-12 04:00:00 | QQQ | ETF | 514.12 | 514.12 | 513.0 | 513.05 | 64689.0 |
| 2024-11-12 05:00:00 | QQQ | ETF | 512.92 | 512.93 | 511.76 | 512.68 | 160491.0 |
| 2024-11-12 06:00:00 | QQQ | ETF | 512.66 | 513.17 | 512.57 | 512.77 | 103371.0 |
| 2024-11-12 07:00:00 | QQQ | ETF | 512.78 | 513.65 | 512.78 | 513.191 | 121967.0 |
| 2024-11-12 08:00:00 | QQQ | ETF | 513.2496 | 514.18 | 511.7796 | 513.91 | 185149.0 |
| 2024-11-12 09:00:00 | QQQ | ETF | 513.95 | 514.66 | 512.93 | 514.29 | 1689958.0 |
| 2024-11-12 10:00:00 | QQQ | ETF | 514.28 | 514.42 | 512.8238 | 512.9799 | 2439590.0 |
| 2024-11-12 11:00:00 | QQQ | ETF | 512.96 | 513.47 | 511.98 | 512.245 | 1946351.0 |
| 2024-11-12 12:00:00 | QQQ | ETF | 512.23 | 512.6 | 510.1 | 510.1 | 1934823.0 |
| 2024-11-12 13:00:00 | QQQ | ETF | 510.08 | 513.275 | 509.83 | 512.88 | 2632210.0 |
| 2024-11-12 14:00:00 | QQQ | ETF | 512.87 | 513.58 | 512.74 | 513.0 | 1622354.0 |
| 2024-11-12 15:00:00 | QQQ | ETF | 513.02 | 513.44 | 512.5107 | 512.91 | 3499201.0 |
| 2024-11-12 16:00:00 | QQQ | ETF | 512.91 | 513.28 | 512.76 | 512.76 | 916237.0 |
| 2024-11-12 17:00:00 | QQQ | ETF | 512.81 | 513.08 | 512.69 | 512.75 | 57651.0 |
| 2024-11-12 18:00:00 | QQQ | ETF | 512.69 | 512.69 | 511.97 | 512.38 | 99881.0 |
| 2024-11-12 19:00:00 | QQQ | ETF | 512.3698 | 512.3698 | 511.86 | 512.0095 | 30690.0 |
| 2024-11-12 04:00:00 | IWM | ETF | 241.17 | 241.27 | 240.46 | 240.54 | 57758.0 |
| 2024-11-12 05:00:00 | IWM | ETF | 240.52 | 240.53 | 239.44 | 239.45 | 105320.0 |
| 2024-11-12 06:00:00 | IWM | ETF | 239.51 | 240.14 | 239.51 | 240.14 | 69984.0 |
| 2024-11-12 07:00:00 | IWM | ETF | 239.98 | 240.6 | 239.98 | 240.37 | 54751.0 |
| 2024-11-12 08:00:00 | IWM | ETF | 240.2881 | 241.35 | 239.6 | 240.25 | 228067.0 |
| 2024-11-12 09:00:00 | IWM | ETF | 240.39 | 241.79 | 239.95 | 240.93 | 2430562.0 |
| 2024-11-12 10:00:00 | IWM | ETF | 240.89 | 241.16 | 239.18 | 239.1946 | 3392624.0 |
| 2024-11-12 11:00:00 | IWM | ETF | 239.2 | 239.31 | 237.72 | 237.76 | 3876531.0 |
| 2024-11-12 12:00:00 | IWM | ETF | 237.76 | 238.15 | 236.6 | 236.715 | 2372784.0 |
| 2024-11-12 13:00:00 | IWM | ETF | 236.71 | 238.09 | 236.56 | 237.97 | 2324826.0 |
| 2024-11-12 14:00:00 | IWM | ETF | 237.96 | 238.28 | 237.506 | 237.62 | 1516358.0 |
| 2024-11-12 15:00:00 | IWM | ETF | 237.6 | 237.73 | 236.955 | 237.42 | 5018653.0 |
| 2024-11-12 16:00:00 | IWM | ETF | 237.46 | 237.81 | 237.15 | 237.42 | 1286449.0 |
| 2024-11-12 17:00:00 | IWM | ETF | 237.56 | 237.68 | 237.41 | 237.6 | 27297.0 |
| 2024-11-12 18:00:00 | IWM | ETF | 237.5 | 237.57 | 237.23 | 237.35 | 39511.0 |
| 2024-11-12 19:00:00 | IWM | ETF | 237.34 | 237.39 | 236.93 | 237.03 | 65817.0 |
| 2024-11-12 04:00:00 | DIA | ETF | 442.89 | 442.89 | 442.89 | 442.89 | 183.0 |
| 2024-11-12 05:00:00 | DIA | ETF | 442.2 | 442.45 | 442.2 | 442.45 | 1402.0 |
> showing 50 of 22,850 rows — these rows as CSV