PREVIEW / etf_1hour / 2024-04-01
file: by_date/etf_1hour/2024/2024-04-01.parquet size: 552 KB rows: 20,789
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-04-01 04:00:00 | SPY | ETF | 525.57 | 525.59 | 525.12 | 525.5 | 18893.0 |
| 2024-04-01 05:00:00 | SPY | ETF | 525.54 | 525.54 | 525.25 | 525.31 | 4162.0 |
| 2024-04-01 06:00:00 | SPY | ETF | 525.41 | 525.55 | 525.35 | 525.46 | 65617.0 |
| 2024-04-01 07:00:00 | SPY | ETF | 525.48 | 525.48 | 524.34 | 524.92 | 162688.0 |
| 2024-04-01 08:00:00 | SPY | ETF | 525.19 | 526.09 | 523.72 | 524.14 | 249247.0 |
| 2024-04-01 09:00:00 | SPY | ETF | 524.15 | 524.38 | 523.45 | 524.095 | 3863567.0 |
| 2024-04-01 10:00:00 | SPY | ETF | 524.09 | 524.18 | 522.08 | 522.315 | 6489043.0 |
| 2024-04-01 11:00:00 | SPY | ETF | 522.31 | 522.42 | 521.07 | 521.1088 | 5013125.0 |
| 2024-04-01 12:00:00 | SPY | ETF | 521.1 | 522.225 | 520.97 | 521.905 | 3999029.0 |
| 2024-04-01 13:00:00 | SPY | ETF | 521.91 | 521.91 | 521.06 | 521.74 | 2792857.0 |
| 2024-04-01 14:00:00 | SPY | ETF | 521.73 | 522.15 | 521.47 | 521.86 | 2611476.0 |
| 2024-04-01 15:00:00 | SPY | ETF | 521.86 | 522.8 | 521.61 | 522.22 | 8514203.0 |
| 2024-04-01 16:00:00 | SPY | ETF | 522.22 | 522.4362 | 521.8997 | 522.1 | 4308741.0 |
| 2024-04-01 17:00:00 | SPY | ETF | 522.16 | 522.4362 | 522.15 | 522.19 | 422946.0 |
| 2024-04-01 18:00:00 | SPY | ETF | 522.19 | 522.19 | 521.66 | 521.66 | 53438.0 |
| 2024-04-01 19:00:00 | SPY | ETF | 521.68 | 521.82 | 521.4201 | 521.67 | 28336.0 |
| 2024-04-01 04:00:00 | QQQ | ETF | 447.31 | 447.31 | 446.0 | 446.79 | 89947.0 |
| 2024-04-01 05:00:00 | QQQ | ETF | 446.76 | 446.8 | 446.43 | 446.66 | 35754.0 |
| 2024-04-01 06:00:00 | QQQ | ETF | 446.67 | 446.93 | 446.6 | 446.77 | 22007.0 |
| 2024-04-01 07:00:00 | QQQ | ETF | 446.88 | 446.88 | 445.64 | 445.95 | 92016.0 |
| 2024-04-01 08:00:00 | QQQ | ETF | 446.75 | 447.3 | 444.83 | 445.34 | 241266.0 |
| 2024-04-01 09:00:00 | QQQ | ETF | 445.25 | 447.53 | 444.45 | 447.04 | 4827923.0 |
| 2024-04-01 10:00:00 | QQQ | ETF | 447.03 | 447.4694 | 444.235 | 444.63 | 6742039.0 |
| 2024-04-01 11:00:00 | QQQ | ETF | 444.62 | 444.77 | 443.18 | 443.259 | 5122915.0 |
| 2024-04-01 12:00:00 | QQQ | ETF | 443.27 | 444.84 | 443.02 | 444.315 | 2955390.0 |
| 2024-04-01 13:00:00 | QQQ | ETF | 444.315 | 444.4 | 443.28 | 444.2 | 2690844.0 |
| 2024-04-01 14:00:00 | QQQ | ETF | 444.185 | 444.629 | 443.88 | 444.31 | 2164459.0 |
| 2024-04-01 15:00:00 | QQQ | ETF | 444.3 | 445.39 | 444.02 | 444.99 | 5636032.0 |
| 2024-04-01 16:00:00 | QQQ | ETF | 444.99 | 445.22 | 444.83 | 445.03 | 624154.0 |
| 2024-04-01 17:00:00 | QQQ | ETF | 445.0317 | 445.07 | 444.95 | 444.95 | 43436.0 |
| 2024-04-01 18:00:00 | QQQ | ETF | 444.98 | 444.98 | 444.46 | 444.53 | 36849.0 |
| 2024-04-01 19:00:00 | QQQ | ETF | 444.5597 | 444.68 | 444.13 | 444.38 | 50310.0 |
| 2024-04-01 04:00:00 | IWM | ETF | 211.92 | 212.15 | 211.88 | 212.05 | 21018.0 |
| 2024-04-01 05:00:00 | IWM | ETF | 212.09 | 212.09 | 211.84 | 211.88 | 6175.0 |
| 2024-04-01 06:00:00 | IWM | ETF | 211.85 | 212.06 | 211.74 | 211.86 | 87397.0 |
| 2024-04-01 07:00:00 | IWM | ETF | 211.86 | 211.86 | 211.41 | 211.57 | 61014.0 |
| 2024-04-01 08:00:00 | IWM | ETF | 211.81 | 212.05 | 210.9899 | 211.22 | 147306.0 |
| 2024-04-01 09:00:00 | IWM | ETF | 211.2 | 211.229 | 209.06 | 210.01 | 3183497.0 |
| 2024-04-01 10:00:00 | IWM | ETF | 210.0 | 210.0 | 208.3 | 209.05 | 4450874.0 |
| 2024-04-01 11:00:00 | IWM | ETF | 209.07 | 209.235 | 208.12 | 208.12 | 2585779.0 |
| 2024-04-01 12:00:00 | IWM | ETF | 208.12 | 208.65 | 207.96 | 208.345 | 1890249.0 |
| 2024-04-01 13:00:00 | IWM | ETF | 208.345 | 208.675 | 207.96 | 208.57 | 2078876.0 |
| 2024-04-01 14:00:00 | IWM | ETF | 208.56 | 208.565 | 208.27 | 208.36 | 1039465.0 |
| 2024-04-01 15:00:00 | IWM | ETF | 208.36 | 208.61 | 208.16 | 208.29 | 3394248.0 |
| 2024-04-01 16:00:00 | IWM | ETF | 208.32 | 208.69 | 208.26 | 208.67 | 553522.0 |
| 2024-04-01 17:00:00 | IWM | ETF | 208.66 | 208.66 | 208.42 | 208.47 | 14983.0 |
| 2024-04-01 18:00:00 | IWM | ETF | 208.6 | 208.63 | 208.36 | 208.36 | 26551.0 |
| 2024-04-01 19:00:00 | IWM | ETF | 208.4 | 208.61 | 208.25 | 208.45 | 45685.0 |
| 2024-04-01 04:00:00 | DIA | ETF | 399.11 | 399.26 | 399.11 | 399.23 | 1917.0 |
| 2024-04-01 05:00:00 | DIA | ETF | 399.13 | 399.21 | 399.12 | 399.12 | 700.0 |
> showing 50 of 20,789 rows — these rows as CSV