PREVIEW / etf_1hour / 2024-11-29
file: by_date/etf_1hour/2024/2024-11-29.parquet size: 400 KB rows: 14,061
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-29 04:00:00 | SPY | ETF | 599.88 | 600.88 | 599.88 | 600.75 | 13175.0 |
| 2024-11-29 05:00:00 | SPY | ETF | 600.74 | 600.94 | 600.56 | 600.72 | 13671.0 |
| 2024-11-29 06:00:00 | SPY | ETF | 600.52 | 600.85 | 600.46 | 600.84 | 5371.0 |
| 2024-11-29 07:00:00 | SPY | ETF | 600.71 | 600.8 | 600.15 | 600.38 | 96124.0 |
| 2024-11-29 08:00:00 | SPY | ETF | 600.72 | 600.8 | 599.34 | 599.7 | 142424.0 |
| 2024-11-29 09:00:00 | SPY | ETF | 599.85 | 600.7199 | 599.3805 | 600.71 | 2407827.0 |
| 2024-11-29 10:00:00 | SPY | ETF | 600.71 | 601.89 | 600.695 | 601.81 | 3058215.0 |
| 2024-11-29 11:00:00 | SPY | ETF | 601.81 | 602.89 | 601.8 | 602.69 | 2501347.0 |
| 2024-11-29 12:00:00 | SPY | ETF | 602.7 | 603.35 | 602.3 | 602.45 | 8622162.0 |
| 2024-11-29 13:00:00 | SPY | ETF | 602.46 | 602.8091 | 602.0928 | 602.66 | 3383218.0 |
| 2024-11-29 14:00:00 | SPY | ETF | 602.64 | 602.7 | 602.35 | 602.6 | 113322.0 |
| 2024-11-29 15:00:00 | SPY | ETF | 602.6 | 602.9 | 602.58 | 602.9 | 46482.0 |
| 2024-11-29 16:00:00 | SPY | ETF | 602.78 | 603.14 | 602.61 | 603.12 | 72034.0 |
| 2024-11-29 04:00:00 | QQQ | ETF | 507.0 | 507.8 | 507.0 | 507.56 | 40913.0 |
| 2024-11-29 05:00:00 | QQQ | ETF | 507.46 | 507.72 | 507.14 | 507.54 | 12004.0 |
| 2024-11-29 06:00:00 | QQQ | ETF | 507.42 | 507.47 | 507.1 | 507.32 | 14731.0 |
| 2024-11-29 07:00:00 | QQQ | ETF | 507.18 | 507.23 | 506.25 | 506.57 | 52026.0 |
| 2024-11-29 08:00:00 | QQQ | ETF | 507.08 | 508.33 | 505.48 | 505.83 | 208068.0 |
| 2024-11-29 09:00:00 | QQQ | ETF | 505.92 | 508.0 | 505.31 | 507.94 | 2148663.0 |
| 2024-11-29 10:00:00 | QQQ | ETF | 507.95 | 509.51 | 507.69 | 508.8899 | 2850810.0 |
| 2024-11-29 11:00:00 | QQQ | ETF | 508.89 | 510.08 | 508.88 | 509.83 | 2106044.0 |
| 2024-11-29 12:00:00 | QQQ | ETF | 509.83 | 510.34 | 509.4201 | 509.71 | 2882189.0 |
| 2024-11-29 13:00:00 | QQQ | ETF | 509.71 | 509.85 | 505.3 | 509.62 | 673638.0 |
| 2024-11-29 14:00:00 | QQQ | ETF | 509.61 | 509.98 | 509.55 | 509.98 | 44315.0 |
| 2024-11-29 15:00:00 | QQQ | ETF | 509.98 | 509.98 | 509.67 | 509.85 | 11124.0 |
| 2024-11-29 16:00:00 | QQQ | ETF | 509.85 | 510.19 | 509.76 | 510.19 | 24887.0 |
| 2024-11-29 04:00:00 | IWM | ETF | 243.35 | 243.5 | 243.1 | 243.15 | 16941.0 |
| 2024-11-29 05:00:00 | IWM | ETF | 243.19 | 243.3 | 242.88 | 243.0 | 6278.0 |
| 2024-11-29 06:00:00 | IWM | ETF | 242.93 | 243.48 | 242.93 | 243.45 | 15976.0 |
| 2024-11-29 07:00:00 | IWM | ETF | 243.39 | 243.589 | 243.11 | 243.15 | 59652.0 |
| 2024-11-29 08:00:00 | IWM | ETF | 243.371 | 243.57 | 242.25 | 242.5 | 103576.0 |
| 2024-11-29 09:00:00 | IWM | ETF | 242.57 | 243.475 | 241.76 | 241.79 | 1787059.0 |
| 2024-11-29 10:00:00 | IWM | ETF | 241.82 | 242.54 | 241.63 | 242.27 | 1978849.0 |
| 2024-11-29 11:00:00 | IWM | ETF | 242.29 | 242.43 | 241.61 | 241.68 | 1205487.0 |
| 2024-11-29 12:00:00 | IWM | ETF | 241.6872 | 242.76 | 241.54 | 241.97 | 3650724.0 |
| 2024-11-29 13:00:00 | IWM | ETF | 241.87 | 242.38 | 241.2273 | 241.79 | 1814500.0 |
| 2024-11-29 14:00:00 | IWM | ETF | 241.79 | 241.83 | 241.59 | 241.76 | 24084.0 |
| 2024-11-29 15:00:00 | IWM | ETF | 241.83 | 241.97 | 241.77 | 241.86 | 3172.0 |
| 2024-11-29 16:00:00 | IWM | ETF | 241.87 | 241.99 | 241.76 | 241.99 | 13310.0 |
| 2024-11-29 04:00:00 | DIA | ETF | 449.02 | 449.36 | 449.02 | 449.36 | 2238.0 |
| 2024-11-29 05:00:00 | DIA | ETF | 449.44 | 449.5 | 449.35 | 449.35 | 425.0 |
| 2024-11-29 06:00:00 | DIA | ETF | 449.12 | 449.64 | 449.12 | 449.64 | 530.0 |
| 2024-11-29 07:00:00 | DIA | ETF | 449.61 | 449.67 | 449.14 | 449.14 | 1926.0 |
| 2024-11-29 08:00:00 | DIA | ETF | 449.64 | 449.64 | 448.71 | 448.73 | 2011.0 |
| 2024-11-29 09:00:00 | DIA | ETF | 448.92 | 449.58 | 448.18 | 448.79 | 470238.0 |
| 2024-11-29 10:00:00 | DIA | ETF | 448.79 | 449.84 | 448.74 | 449.78 | 687074.0 |
| 2024-11-29 11:00:00 | DIA | ETF | 449.76 | 450.85 | 449.67 | 450.64 | 915675.0 |
| 2024-11-29 12:00:00 | DIA | ETF | 450.67 | 451.28 | 449.9 | 450.05 | 553601.0 |
| 2024-11-29 13:00:00 | DIA | ETF | 450.12 | 450.28 | 449.89 | 450.05 | 186081.0 |
| 2024-11-29 14:00:00 | DIA | ETF | 450.4 | 450.4 | 450.0 | 450.31 | 4274.0 |
> showing 50 of 14,061 rows — these rows as CSV