PREVIEW / etf_1hour / 2024-05-06
file: by_date/etf_1hour/2024/2024-05-06.parquet size: 538 KB rows: 20,055
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-05-06 04:00:00 | SPY | ETF | 511.93 | 512.47 | 511.85 | 512.29 | 15508.0 |
| 2024-05-06 05:00:00 | SPY | ETF | 512.38 | 512.73 | 512.38 | 512.72 | 11181.0 |
| 2024-05-06 06:00:00 | SPY | ETF | 512.72 | 513.35 | 512.72 | 513.27 | 41084.0 |
| 2024-05-06 07:00:00 | SPY | ETF | 513.23 | 513.23 | 512.65 | 513.11 | 133341.0 |
| 2024-05-06 08:00:00 | SPY | ETF | 513.02 | 513.67 | 511.68 | 513.43 | 260313.0 |
| 2024-05-06 09:00:00 | SPY | ETF | 513.4298 | 514.36 | 513.26 | 514.205 | 5022739.0 |
| 2024-05-06 10:00:00 | SPY | ETF | 514.21 | 514.64 | 514.04 | 514.29 | 4505124.0 |
| 2024-05-06 11:00:00 | SPY | ETF | 514.29 | 514.54 | 513.8401 | 514.36 | 2870087.0 |
| 2024-05-06 12:00:00 | SPY | ETF | 514.36 | 514.73 | 513.7 | 514.68 | 3700587.0 |
| 2024-05-06 13:00:00 | SPY | ETF | 514.68 | 515.04 | 514.245 | 514.89 | 2826614.0 |
| 2024-05-06 14:00:00 | SPY | ETF | 514.885 | 515.77 | 514.82 | 515.41 | 3888007.0 |
| 2024-05-06 15:00:00 | SPY | ETF | 515.4 | 516.61 | 514.88 | 516.6 | 9609247.0 |
| 2024-05-06 16:00:00 | SPY | ETF | 516.6 | 516.63 | 516.17 | 516.37 | 2663921.0 |
| 2024-05-06 17:00:00 | SPY | ETF | 516.47 | 516.5 | 516.34 | 516.44 | 31006.0 |
| 2024-05-06 18:00:00 | SPY | ETF | 516.4 | 516.57 | 516.19 | 516.53 | 36903.0 |
| 2024-05-06 19:00:00 | SPY | ETF | 516.54 | 516.6 | 516.3 | 516.45 | 79251.0 |
| 2024-05-06 04:00:00 | QQQ | ETF | 435.53 | 436.39 | 435.53 | 436.23 | 34912.0 |
| 2024-05-06 05:00:00 | QQQ | ETF | 436.16 | 436.59 | 436.15 | 436.56 | 14727.0 |
| 2024-05-06 06:00:00 | QQQ | ETF | 436.64 | 436.93 | 436.55 | 436.9 | 50462.0 |
| 2024-05-06 07:00:00 | QQQ | ETF | 436.74 | 436.75 | 436.46 | 436.54 | 53764.0 |
| 2024-05-06 08:00:00 | QQQ | ETF | 436.7001 | 437.24 | 435.2 | 436.93 | 149069.0 |
| 2024-05-06 09:00:00 | QQQ | ETF | 436.9 | 438.16 | 436.52 | 438.145 | 3463670.0 |
| 2024-05-06 10:00:00 | QQQ | ETF | 438.16 | 438.32 | 437.43 | 437.88 | 3569939.0 |
| 2024-05-06 11:00:00 | QQQ | ETF | 437.88 | 438.5 | 437.41 | 438.215 | 2132607.0 |
| 2024-05-06 12:00:00 | QQQ | ETF | 438.22 | 438.39 | 437.17 | 438.35 | 2394001.0 |
| 2024-05-06 13:00:00 | QQQ | ETF | 438.36 | 438.71 | 437.79 | 438.635 | 2114993.0 |
| 2024-05-06 14:00:00 | QQQ | ETF | 438.63 | 439.28 | 438.5199 | 439.045 | 2827078.0 |
| 2024-05-06 15:00:00 | QQQ | ETF | 439.04 | 440.34 | 438.66 | 440.325 | 5383756.0 |
| 2024-05-06 16:00:00 | QQQ | ETF | 440.325 | 440.37 | 438.4 | 440.0 | 1320239.0 |
| 2024-05-06 17:00:00 | QQQ | ETF | 440.02 | 440.11 | 439.93 | 439.95 | 62547.0 |
| 2024-05-06 18:00:00 | QQQ | ETF | 439.93 | 440.169 | 439.82 | 440.169 | 27862.0 |
| 2024-05-06 19:00:00 | QQQ | ETF | 440.18 | 440.28 | 439.9 | 439.97 | 67973.0 |
| 2024-05-06 04:00:00 | IWM | ETF | 202.82 | 203.22 | 202.72 | 203.14 | 16163.0 |
| 2024-05-06 05:00:00 | IWM | ETF | 203.19 | 203.4 | 203.17 | 203.4 | 12522.0 |
| 2024-05-06 06:00:00 | IWM | ETF | 203.35 | 203.91 | 203.34 | 203.87 | 28302.0 |
| 2024-05-06 07:00:00 | IWM | ETF | 203.87 | 203.87 | 203.44 | 203.57 | 38511.0 |
| 2024-05-06 08:00:00 | IWM | ETF | 203.48 | 203.84 | 202.5 | 203.48 | 185533.0 |
| 2024-05-06 09:00:00 | IWM | ETF | 203.46 | 204.45 | 203.16 | 204.44 | 2354076.0 |
| 2024-05-06 10:00:00 | IWM | ETF | 204.45 | 204.78 | 204.21 | 204.24 | 3617566.0 |
| 2024-05-06 11:00:00 | IWM | ETF | 204.24 | 204.6 | 203.84 | 204.535 | 1857235.0 |
| 2024-05-06 12:00:00 | IWM | ETF | 204.53 | 204.5301 | 204.07 | 204.39 | 1254225.0 |
| 2024-05-06 13:00:00 | IWM | ETF | 204.385 | 204.67 | 204.275 | 204.535 | 1445195.0 |
| 2024-05-06 14:00:00 | IWM | ETF | 204.535 | 204.73 | 204.35 | 204.45 | 1321951.0 |
| 2024-05-06 15:00:00 | IWM | ETF | 204.44 | 204.45 | 204.02 | 204.44 | 3795370.0 |
| 2024-05-06 16:00:00 | IWM | ETF | 204.51 | 204.51 | 204.12 | 204.4 | 1103619.0 |
| 2024-05-06 17:00:00 | IWM | ETF | 204.39 | 204.51 | 204.25 | 204.31 | 26591.0 |
| 2024-05-06 18:00:00 | IWM | ETF | 204.36 | 204.59 | 204.32 | 204.53 | 28566.0 |
| 2024-05-06 19:00:00 | IWM | ETF | 204.51 | 204.57 | 204.41 | 204.48 | 37041.0 |
| 2024-05-06 04:00:00 | DIA | ETF | 387.18 | 387.37 | 387.18 | 387.37 | 425.0 |
| 2024-05-06 05:00:00 | DIA | ETF | 387.42 | 387.68 | 387.42 | 387.68 | 490.0 |
> showing 50 of 20,055 rows — these rows as CSV