PREVIEW / etf_1hour / 2022-02-11
file: by_date/etf_1hour/2022/2022-02-11.parquet size: 459 KB rows: 16,459
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 |
|---|---|---|---|---|---|---|---|
| 2022-02-11 04:00:00 | SPY | ETF | 446.72 | 447.73 | 446.38 | 446.79 | 47018.0 |
| 2022-02-11 05:00:00 | SPY | ETF | 446.75 | 447.39 | 446.75 | 447.39 | 14610.0 |
| 2022-02-11 06:00:00 | SPY | ETF | 447.1 | 447.18 | 446.56 | 446.93 | 36822.0 |
| 2022-02-11 07:00:00 | SPY | ETF | 446.91 | 449.3 | 446.91 | 448.35 | 330259.0 |
| 2022-02-11 08:00:00 | SPY | ETF | 448.35 | 450.24 | 445.41 | 449.86 | 764084.0 |
| 2022-02-11 09:00:00 | SPY | ETF | 449.87 | 451.605 | 448.79 | 449.1883 | 8982957.0 |
| 2022-02-11 10:00:00 | SPY | ETF | 449.16 | 450.82 | 448.28 | 449.0 | 10754443.0 |
| 2022-02-11 11:00:00 | SPY | ETF | 449.03 | 450.143 | 446.82 | 447.92 | 9917578.0 |
| 2022-02-11 12:00:00 | SPY | ETF | 447.91 | 448.67 | 446.39 | 446.685 | 6258123.0 |
| 2022-02-11 13:00:00 | SPY | ETF | 446.68 | 447.7 | 441.0 | 441.76 | 19515997.0 |
| 2022-02-11 14:00:00 | SPY | ETF | 441.72 | 443.9 | 439.43 | 440.94 | 27338930.0 |
| 2022-02-11 15:00:00 | SPY | ETF | 440.95 | 442.79 | 438.94 | 440.51 | 29597985.0 |
| 2022-02-11 16:00:00 | SPY | ETF | 440.51 | 442.0 | 439.95 | 441.47 | 8235515.0 |
| 2022-02-11 17:00:00 | SPY | ETF | 441.44 | 441.7 | 440.46 | 441.4 | 91556.0 |
| 2022-02-11 18:00:00 | SPY | ETF | 441.41 | 441.64 | 440.46 | 440.8 | 71349.0 |
| 2022-02-11 19:00:00 | SPY | ETF | 440.88 | 440.89 | 440.4 | 440.5 | 82966.0 |
| 2022-02-11 04:00:00 | QQQ | ETF | 356.58 | 357.02 | 355.4 | 355.7 | 92685.0 |
| 2022-02-11 05:00:00 | QQQ | ETF | 355.63 | 356.33 | 355.63 | 356.25 | 27331.0 |
| 2022-02-11 06:00:00 | QQQ | ETF | 356.34 | 356.35 | 355.41 | 356.0 | 68523.0 |
| 2022-02-11 07:00:00 | QQQ | ETF | 356.08 | 358.47 | 356.0 | 357.7 | 555075.0 |
| 2022-02-11 08:00:00 | QQQ | ETF | 356.2128 | 359.38 | 354.5 | 358.93 | 1006120.0 |
| 2022-02-11 09:00:00 | QQQ | ETF | 358.95 | 360.07 | 356.62 | 356.95 | 8621771.0 |
| 2022-02-11 10:00:00 | QQQ | ETF | 356.95 | 359.04 | 355.7611 | 356.47 | 11050779.0 |
| 2022-02-11 11:00:00 | QQQ | ETF | 356.48 | 357.7499 | 354.16 | 355.1 | 9435265.0 |
| 2022-02-11 12:00:00 | QQQ | ETF | 355.05 | 355.96 | 353.69 | 353.8 | 5341252.0 |
| 2022-02-11 13:00:00 | QQQ | ETF | 353.79 | 354.71 | 348.95 | 349.27 | 13272322.0 |
| 2022-02-11 14:00:00 | QQQ | ETF | 349.26 | 350.91 | 346.475 | 347.85 | 14796246.0 |
| 2022-02-11 15:00:00 | QQQ | ETF | 347.84 | 349.69 | 345.8 | 347.16 | 14176626.0 |
| 2022-02-11 16:00:00 | QQQ | ETF | 347.21 | 348.4 | 346.49 | 347.71 | 2909918.0 |
| 2022-02-11 17:00:00 | QQQ | ETF | 347.65 | 347.9 | 347.06 | 347.6 | 407690.0 |
| 2022-02-11 18:00:00 | QQQ | ETF | 347.53 | 347.6 | 347.1 | 347.13 | 32099.0 |
| 2022-02-11 19:00:00 | QQQ | ETF | 347.2 | 347.2 | 346.68 | 346.78 | 53723.0 |
| 2022-02-11 04:00:00 | IWM | ETF | 202.04 | 202.54 | 201.77 | 202.0 | 19669.0 |
| 2022-02-11 05:00:00 | IWM | ETF | 202.21 | 202.66 | 202.08 | 202.53 | 14238.0 |
| 2022-02-11 06:00:00 | IWM | ETF | 202.54 | 202.6 | 202.19 | 202.39 | 39908.0 |
| 2022-02-11 07:00:00 | IWM | ETF | 202.37 | 203.69 | 202.25 | 203.21 | 94619.0 |
| 2022-02-11 08:00:00 | IWM | ETF | 203.0201 | 204.34 | 201.5 | 204.04 | 136934.0 |
| 2022-02-11 09:00:00 | IWM | ETF | 204.06 | 205.06 | 203.31 | 203.76 | 2915316.0 |
| 2022-02-11 10:00:00 | IWM | ETF | 203.78 | 206.06 | 203.78 | 205.32 | 3507306.0 |
| 2022-02-11 11:00:00 | IWM | ETF | 205.32 | 206.03 | 203.87 | 204.28 | 3247398.0 |
| 2022-02-11 12:00:00 | IWM | ETF | 204.24 | 204.85 | 203.7 | 203.9 | 1906429.0 |
| 2022-02-11 13:00:00 | IWM | ETF | 203.91 | 204.45 | 200.68 | 200.99 | 5629402.0 |
| 2022-02-11 14:00:00 | IWM | ETF | 200.97 | 202.41 | 199.69 | 200.66 | 6387830.0 |
| 2022-02-11 15:00:00 | IWM | ETF | 200.67 | 202.05 | 200.28 | 201.27 | 7096407.0 |
| 2022-02-11 16:00:00 | IWM | ETF | 201.265 | 202.1 | 200.95 | 201.8 | 1025964.0 |
| 2022-02-11 17:00:00 | IWM | ETF | 201.8 | 201.8 | 201.43 | 201.69 | 21924.0 |
| 2022-02-11 18:00:00 | IWM | ETF | 201.69 | 201.69 | 201.16 | 201.4 | 19170.0 |
| 2022-02-11 19:00:00 | IWM | ETF | 201.31 | 201.38 | 200.8 | 201.0 | 17611.0 |
| 2022-02-11 04:00:00 | DIA | ETF | 350.88 | 350.88 | 350.8 | 350.8 | 200.0 |
| 2022-02-11 05:00:00 | DIA | ETF | 351.05 | 351.05 | 351.05 | 351.05 | 150.0 |
> showing 50 of 16,459 rows — these rows as CSV