PREVIEW / etf_1hour / 2024-01-24
file: by_date/etf_1hour/2024/2024-01-24.parquet size: 545 KB rows: 20,050
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-01-24 04:00:00 | SPY | ETF | 486.86 | 487.15 | 486.81 | 487.15 | 21684.0 |
| 2024-01-24 05:00:00 | SPY | ETF | 487.15 | 487.26 | 486.76 | 486.92 | 37357.0 |
| 2024-01-24 06:00:00 | SPY | ETF | 487.07 | 487.2 | 487.0 | 487.03 | 47875.0 |
| 2024-01-24 07:00:00 | SPY | ETF | 487.07 | 487.26 | 486.81 | 487.13 | 127580.0 |
| 2024-01-24 08:00:00 | SPY | ETF | 487.0406 | 487.92 | 486.08 | 487.46 | 333655.0 |
| 2024-01-24 09:00:00 | SPY | ETF | 487.45 | 487.83 | 486.95 | 487.09 | 5798222.0 |
| 2024-01-24 10:00:00 | SPY | ETF | 487.09 | 488.61 | 486.4099 | 487.95 | 9989154.0 |
| 2024-01-24 11:00:00 | SPY | ETF | 487.96 | 488.4 | 487.48 | 488.32 | 5913930.0 |
| 2024-01-24 12:00:00 | SPY | ETF | 488.31 | 488.77 | 487.82 | 488.7105 | 4468048.0 |
| 2024-01-24 13:00:00 | SPY | ETF | 488.7101 | 488.735 | 486.92 | 487.3103 | 8510334.0 |
| 2024-01-24 14:00:00 | SPY | ETF | 487.32 | 487.38 | 485.9695 | 486.55 | 7684241.0 |
| 2024-01-24 15:00:00 | SPY | ETF | 486.55 | 486.89 | 485.01 | 485.32 | 17498444.0 |
| 2024-01-24 16:00:00 | SPY | ETF | 485.32 | 487.9175 | 484.41 | 485.61 | 4310400.0 |
| 2024-01-24 17:00:00 | SPY | ETF | 485.55 | 485.69 | 485.38 | 485.4 | 72782.0 |
| 2024-01-24 18:00:00 | SPY | ETF | 485.44 | 485.48 | 485.22 | 485.43 | 225366.0 |
| 2024-01-24 19:00:00 | SPY | ETF | 485.42 | 485.47 | 485.13 | 485.47 | 41250.0 |
| 2024-01-24 04:00:00 | QQQ | ETF | 425.62 | 426.84 | 425.59 | 426.73 | 71206.0 |
| 2024-01-24 05:00:00 | QQQ | ETF | 426.71 | 426.81 | 426.32 | 426.49 | 29679.0 |
| 2024-01-24 06:00:00 | QQQ | ETF | 426.5 | 426.66 | 426.09 | 426.33 | 51578.0 |
| 2024-01-24 07:00:00 | QQQ | ETF | 426.31 | 426.91 | 426.23 | 426.77 | 106048.0 |
| 2024-01-24 08:00:00 | QQQ | ETF | 426.25 | 427.43 | 423.797 | 426.85 | 387136.0 |
| 2024-01-24 09:00:00 | QQQ | ETF | 426.76 | 427.54 | 426.12 | 426.91 | 4642020.0 |
| 2024-01-24 10:00:00 | QQQ | ETF | 426.92 | 429.22 | 426.17 | 428.49 | 6424066.0 |
| 2024-01-24 11:00:00 | QQQ | ETF | 428.52 | 428.92 | 427.3631 | 428.83 | 3649412.0 |
| 2024-01-24 12:00:00 | QQQ | ETF | 428.83 | 429.85 | 428.49 | 429.66 | 3434293.0 |
| 2024-01-24 13:00:00 | QQQ | ETF | 429.67 | 429.67 | 427.54 | 427.99 | 4417348.0 |
| 2024-01-24 14:00:00 | QQQ | ETF | 427.98 | 428.08 | 426.0 | 426.77 | 5017047.0 |
| 2024-01-24 15:00:00 | QQQ | ETF | 426.78 | 427.24 | 425.33 | 425.79 | 6901977.0 |
| 2024-01-24 16:00:00 | QQQ | ETF | 425.8 | 427.8713 | 424.51 | 425.94 | 1839796.0 |
| 2024-01-24 17:00:00 | QQQ | ETF | 425.92 | 426.02 | 425.59 | 425.59 | 88475.0 |
| 2024-01-24 18:00:00 | QQQ | ETF | 425.65 | 425.85 | 425.3905 | 425.6199 | 65972.0 |
| 2024-01-24 19:00:00 | QQQ | ETF | 425.6 | 425.86 | 425.22 | 425.73 | 78260.0 |
| 2024-01-24 04:00:00 | IWM | ETF | 197.2 | 197.79 | 196.8 | 197.79 | 45860.0 |
| 2024-01-24 05:00:00 | IWM | ETF | 197.81 | 197.9 | 197.15 | 197.34 | 38359.0 |
| 2024-01-24 06:00:00 | IWM | ETF | 197.39 | 197.59 | 197.22 | 197.22 | 29754.0 |
| 2024-01-24 07:00:00 | IWM | ETF | 197.21 | 197.86 | 197.21 | 197.65 | 143998.0 |
| 2024-01-24 08:00:00 | IWM | ETF | 197.4992 | 198.62 | 196.6 | 198.56 | 362941.0 |
| 2024-01-24 09:00:00 | IWM | ETF | 198.55 | 198.56 | 196.38 | 196.48 | 5252613.0 |
| 2024-01-24 10:00:00 | IWM | ETF | 196.48 | 197.315 | 195.525 | 196.6 | 6808946.0 |
| 2024-01-24 11:00:00 | IWM | ETF | 196.6 | 196.9501 | 196.29 | 196.53 | 2722018.0 |
| 2024-01-24 12:00:00 | IWM | ETF | 196.53 | 196.5941 | 195.93 | 196.58 | 1869235.0 |
| 2024-01-24 13:00:00 | IWM | ETF | 196.59 | 196.61 | 194.79 | 195.15 | 4263171.0 |
| 2024-01-24 14:00:00 | IWM | ETF | 195.13 | 195.185 | 194.28 | 194.87 | 4625114.0 |
| 2024-01-24 15:00:00 | IWM | ETF | 194.87 | 195.18 | 194.12 | 194.31 | 6821222.0 |
| 2024-01-24 16:00:00 | IWM | ETF | 194.31 | 194.44 | 193.88 | 194.32 | 1138632.0 |
| 2024-01-24 17:00:00 | IWM | ETF | 194.29 | 194.3 | 194.0 | 194.12 | 95177.0 |
| 2024-01-24 18:00:00 | IWM | ETF | 194.16 | 194.39 | 194.16 | 194.33 | 68533.0 |
| 2024-01-24 19:00:00 | IWM | ETF | 194.31 | 194.41 | 194.13 | 194.41 | 40133.0 |
| 2024-01-24 04:00:00 | DIA | ETF | 379.58 | 379.62 | 379.51 | 379.58 | 2850.0 |
| 2024-01-24 06:00:00 | DIA | ETF | 379.98 | 380.0 | 379.98 | 380.0 | 395.0 |
> showing 50 of 20,050 rows — these rows as CSV