PREVIEW / etf_1hour / 2024-03-20
file: by_date/etf_1hour/2024/2024-03-20.parquet size: 531 KB rows: 19,930
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-03-20 04:00:00 | SPY | ETF | 515.52 | 515.61 | 515.04 | 515.3 | 26014.0 |
| 2024-03-20 05:00:00 | SPY | ETF | 515.31 | 515.46 | 515.06 | 515.44 | 5948.0 |
| 2024-03-20 06:00:00 | SPY | ETF | 515.48 | 515.74 | 515.33 | 515.73 | 5703.0 |
| 2024-03-20 07:00:00 | SPY | ETF | 515.71 | 516.26 | 515.71 | 516.16 | 66731.0 |
| 2024-03-20 08:00:00 | SPY | ETF | 515.7109 | 516.28 | 515.17 | 515.39 | 117536.0 |
| 2024-03-20 09:00:00 | SPY | ETF | 515.45 | 515.99 | 515.21 | 515.43 | 3417099.0 |
| 2024-03-20 10:00:00 | SPY | ETF | 515.43 | 516.44 | 515.3401 | 515.87 | 4002139.0 |
| 2024-03-20 11:00:00 | SPY | ETF | 515.88 | 516.34 | 515.58 | 515.93 | 3115606.0 |
| 2024-03-20 12:00:00 | SPY | ETF | 515.91 | 516.15 | 515.3901 | 516.14 | 3540075.0 |
| 2024-03-20 13:00:00 | SPY | ETF | 516.14 | 516.14 | 515.08 | 515.48 | 3360042.0 |
| 2024-03-20 14:00:00 | SPY | ETF | 515.5 | 519.55 | 515.48 | 518.91 | 14118156.0 |
| 2024-03-20 15:00:00 | SPY | ETF | 518.95 | 520.62 | 518.84 | 520.42 | 16624009.0 |
| 2024-03-20 16:00:00 | SPY | ETF | 520.41 | 521.4 | 520.17 | 521.2 | 3349635.0 |
| 2024-03-20 17:00:00 | SPY | ETF | 521.18 | 521.18 | 520.7 | 520.97 | 127701.0 |
| 2024-03-20 18:00:00 | SPY | ETF | 521.0 | 521.55 | 520.98 | 521.52 | 148662.0 |
| 2024-03-20 19:00:00 | SPY | ETF | 521.48 | 522.05 | 521.48 | 521.8804 | 166028.0 |
| 2024-03-20 04:00:00 | QQQ | ETF | 437.74 | 438.78 | 437.74 | 438.01 | 46344.0 |
| 2024-03-20 05:00:00 | QQQ | ETF | 438.11 | 438.68 | 437.82 | 438.68 | 18139.0 |
| 2024-03-20 06:00:00 | QQQ | ETF | 438.67 | 439.14 | 438.36 | 439.01 | 79226.0 |
| 2024-03-20 07:00:00 | QQQ | ETF | 439.0 | 440.05 | 438.97 | 439.86 | 89517.0 |
| 2024-03-20 08:00:00 | QQQ | ETF | 439.28 | 440.059 | 437.75 | 439.31 | 246330.0 |
| 2024-03-20 09:00:00 | QQQ | ETF | 439.32 | 440.16 | 438.06 | 438.388 | 3063099.0 |
| 2024-03-20 10:00:00 | QQQ | ETF | 438.41 | 439.48 | 438.165 | 438.47 | 2367915.0 |
| 2024-03-20 11:00:00 | QQQ | ETF | 438.465 | 439.25 | 438.295 | 438.89 | 1626437.0 |
| 2024-03-20 12:00:00 | QQQ | ETF | 438.86 | 439.14 | 438.26 | 439.14 | 1822874.0 |
| 2024-03-20 13:00:00 | QQQ | ETF | 439.15 | 439.17 | 438.08 | 438.75 | 1909309.0 |
| 2024-03-20 14:00:00 | QQQ | ETF | 438.74 | 443.04 | 438.74 | 442.21 | 10143197.0 |
| 2024-03-20 15:00:00 | QQQ | ETF | 442.21 | 444.11 | 442.08 | 443.81 | 8630435.0 |
| 2024-03-20 16:00:00 | QQQ | ETF | 443.84 | 445.24 | 443.4176 | 445.14 | 2183308.0 |
| 2024-03-20 17:00:00 | QQQ | ETF | 445.13 | 445.13 | 444.46 | 444.88 | 169318.0 |
| 2024-03-20 18:00:00 | QQQ | ETF | 444.95 | 445.64 | 444.78 | 445.55 | 100938.0 |
| 2024-03-20 19:00:00 | QQQ | ETF | 445.57 | 446.26 | 445.51 | 446.07 | 111965.0 |
| 2024-03-20 04:00:00 | IWM | ETF | 201.64 | 201.64 | 201.15 | 201.37 | 17401.0 |
| 2024-03-20 05:00:00 | IWM | ETF | 201.27 | 201.35 | 201.03 | 201.23 | 6523.0 |
| 2024-03-20 06:00:00 | IWM | ETF | 201.26 | 201.47 | 201.22 | 201.47 | 5144.0 |
| 2024-03-20 07:00:00 | IWM | ETF | 201.4 | 201.6 | 201.4 | 201.57 | 25947.0 |
| 2024-03-20 08:00:00 | IWM | ETF | 201.55 | 201.94 | 201.1996 | 201.69 | 91053.0 |
| 2024-03-20 09:00:00 | IWM | ETF | 201.68 | 201.96 | 201.11 | 201.5 | 2050923.0 |
| 2024-03-20 10:00:00 | IWM | ETF | 201.5 | 202.57 | 201.215 | 202.51 | 3028878.0 |
| 2024-03-20 11:00:00 | IWM | ETF | 202.505 | 202.705 | 202.025 | 202.2 | 2537188.0 |
| 2024-03-20 12:00:00 | IWM | ETF | 202.19 | 202.425 | 201.96 | 202.225 | 1421190.0 |
| 2024-03-20 13:00:00 | IWM | ETF | 202.22 | 202.24 | 201.82 | 202.1 | 1898618.0 |
| 2024-03-20 14:00:00 | IWM | ETF | 202.08 | 205.68 | 202.06 | 205.21 | 13976070.0 |
| 2024-03-20 15:00:00 | IWM | ETF | 205.23 | 206.99 | 204.87 | 206.03 | 11011659.0 |
| 2024-03-20 16:00:00 | IWM | ETF | 206.04 | 206.62 | 206.0 | 206.43 | 2629107.0 |
| 2024-03-20 17:00:00 | IWM | ETF | 206.44 | 206.6 | 206.28 | 206.6 | 20409.0 |
| 2024-03-20 18:00:00 | IWM | ETF | 206.41 | 207.1 | 206.4 | 207.1 | 86993.0 |
| 2024-03-20 19:00:00 | IWM | ETF | 207.1 | 207.31 | 207.03 | 207.08 | 135766.0 |
| 2024-03-20 04:00:00 | DIA | ETF | 390.73 | 390.73 | 390.66 | 390.66 | 2804.0 |
| 2024-03-20 05:00:00 | DIA | ETF | 390.82 | 390.87 | 390.71 | 390.71 | 1250.0 |
> showing 50 of 19,930 rows — these rows as CSV