PREVIEW / etf_1hour / 2024-11-13
file: by_date/etf_1hour/2024/2024-11-13.parquet size: 608 KB rows: 22,654
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-13 04:00:00 | SPY | ETF | 596.4 | 596.71 | 596.29 | 596.56 | 21749.0 |
| 2024-11-13 05:00:00 | SPY | ETF | 596.69 | 596.69 | 595.98 | 596.0 | 5868.0 |
| 2024-11-13 06:00:00 | SPY | ETF | 595.78 | 595.99 | 595.42 | 595.5 | 35587.0 |
| 2024-11-13 07:00:00 | SPY | ETF | 595.42 | 596.23 | 595.39 | 595.85 | 127406.0 |
| 2024-11-13 08:00:00 | SPY | ETF | 595.5001 | 598.731 | 595.23 | 597.15 | 950648.0 |
| 2024-11-13 09:00:00 | SPY | ETF | 597.13 | 597.72 | 596.3404 | 597.1 | 2854179.0 |
| 2024-11-13 10:00:00 | SPY | ETF | 597.1399 | 597.38 | 594.96 | 597.15 | 3672181.0 |
| 2024-11-13 11:00:00 | SPY | ETF | 597.17 | 598.33 | 596.66 | 598.07 | 2415235.0 |
| 2024-11-13 12:00:00 | SPY | ETF | 598.07 | 599.18 | 597.93 | 599.13 | 2508056.0 |
| 2024-11-13 13:00:00 | SPY | ETF | 599.13 | 599.23 | 598.3443 | 598.91 | 2113503.0 |
| 2024-11-13 14:00:00 | SPY | ETF | 598.9 | 598.934 | 597.02 | 597.21 | 2857818.0 |
| 2024-11-13 15:00:00 | SPY | ETF | 597.21 | 598.54 | 596.48 | 597.17 | 10084038.0 |
| 2024-11-13 16:00:00 | SPY | ETF | 597.19 | 597.9 | 596.93 | 597.41 | 2686334.0 |
| 2024-11-13 17:00:00 | SPY | ETF | 597.4 | 597.53 | 597.26 | 597.42 | 107042.0 |
| 2024-11-13 18:00:00 | SPY | ETF | 597.42 | 597.8 | 596.9284 | 597.67 | 405580.0 |
| 2024-11-13 19:00:00 | SPY | ETF | 597.76 | 597.8199 | 597.07 | 597.42 | 44081.0 |
| 2024-11-13 04:00:00 | QQQ | ETF | 512.82 | 512.9 | 512.51 | 512.68 | 28078.0 |
| 2024-11-13 05:00:00 | QQQ | ETF | 512.87 | 512.92 | 512.21 | 512.34 | 39466.0 |
| 2024-11-13 06:00:00 | QQQ | ETF | 512.17 | 512.19 | 511.62 | 511.67 | 29782.0 |
| 2024-11-13 07:00:00 | QQQ | ETF | 511.66 | 512.35 | 511.42 | 511.76 | 79454.0 |
| 2024-11-13 08:00:00 | QQQ | ETF | 511.72 | 514.45 | 511.15 | 512.8 | 507867.0 |
| 2024-11-13 09:00:00 | QQQ | ETF | 512.79 | 513.35 | 511.51 | 511.96 | 1892117.0 |
| 2024-11-13 10:00:00 | QQQ | ETF | 511.89 | 511.93 | 509.95 | 511.36 | 2411779.0 |
| 2024-11-13 11:00:00 | QQQ | ETF | 511.37 | 512.79 | 510.77 | 512.52 | 1504803.0 |
| 2024-11-13 12:00:00 | QQQ | ETF | 512.52 | 514.11 | 512.35 | 514.015 | 1927535.0 |
| 2024-11-13 13:00:00 | QQQ | ETF | 514.04 | 514.98 | 513.58 | 514.7 | 1579877.0 |
| 2024-11-13 14:00:00 | QQQ | ETF | 514.72 | 514.72 | 512.542 | 512.88 | 2061150.0 |
| 2024-11-13 15:00:00 | QQQ | ETF | 512.84 | 513.78 | 511.45 | 512.27 | 3574159.0 |
| 2024-11-13 16:00:00 | QQQ | ETF | 512.26 | 513.46 | 512.14 | 512.48 | 993795.0 |
| 2024-11-13 17:00:00 | QQQ | ETF | 512.4 | 512.43 | 512.21 | 512.23 | 79369.0 |
| 2024-11-13 18:00:00 | QQQ | ETF | 512.25 | 512.63 | 512.0 | 512.47 | 42932.0 |
| 2024-11-13 19:00:00 | QQQ | ETF | 512.5501 | 512.59 | 511.85 | 512.17 | 37766.0 |
| 2024-11-13 04:00:00 | IWM | ETF | 237.0 | 237.6 | 236.9 | 237.45 | 26530.0 |
| 2024-11-13 05:00:00 | IWM | ETF | 237.45 | 237.48 | 237.09 | 237.1 | 12712.0 |
| 2024-11-13 06:00:00 | IWM | ETF | 237.07 | 237.19 | 236.85 | 236.85 | 26288.0 |
| 2024-11-13 07:00:00 | IWM | ETF | 236.72 | 237.23 | 236.68 | 236.8 | 119530.0 |
| 2024-11-13 08:00:00 | IWM | ETF | 236.97 | 240.37 | 236.31 | 239.17 | 1348684.0 |
| 2024-11-13 09:00:00 | IWM | ETF | 239.13 | 239.88 | 238.48 | 239.56 | 3299495.0 |
| 2024-11-13 10:00:00 | IWM | ETF | 239.58 | 239.72 | 237.61 | 239.42 | 2993932.0 |
| 2024-11-13 11:00:00 | IWM | ETF | 239.41 | 239.52 | 238.365 | 238.59 | 1351029.0 |
| 2024-11-13 12:00:00 | IWM | ETF | 238.58 | 238.87 | 237.95 | 238.39 | 1123501.0 |
| 2024-11-13 13:00:00 | IWM | ETF | 238.39 | 238.41 | 237.39 | 237.42 | 1167601.0 |
| 2024-11-13 14:00:00 | IWM | ETF | 237.44 | 237.62 | 235.7001 | 235.78 | 2502592.0 |
| 2024-11-13 15:00:00 | IWM | ETF | 235.76 | 236.43 | 234.833 | 235.14 | 4680151.0 |
| 2024-11-13 16:00:00 | IWM | ETF | 235.11 | 235.62 | 235.06 | 235.37 | 1601872.0 |
| 2024-11-13 17:00:00 | IWM | ETF | 235.38 | 235.4891 | 235.28 | 235.46 | 12797.0 |
| 2024-11-13 18:00:00 | IWM | ETF | 235.46 | 235.63 | 235.24 | 235.46 | 11833.0 |
| 2024-11-13 19:00:00 | IWM | ETF | 235.51 | 235.56 | 235.19 | 235.28 | 67439.0 |
| 2024-11-13 04:00:00 | DIA | ETF | 438.43 | 438.68 | 438.43 | 438.61 | 3162.0 |
| 2024-11-13 05:00:00 | DIA | ETF | 438.85 | 438.93 | 438.61 | 438.61 | 1598.0 |
> showing 50 of 22,654 rows — these rows as CSV