PREVIEW / etf_1hour / 2024-09-09
file: by_date/etf_1hour/2024/2024-09-09.parquet size: 550 KB rows: 20,621
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-09-09 04:00:00 | SPY | ETF | 542.72 | 543.84 | 542.22 | 543.57 | 47559.0 |
| 2024-09-09 05:00:00 | SPY | ETF | 543.57 | 544.35 | 543.52 | 544.33 | 16708.0 |
| 2024-09-09 06:00:00 | SPY | ETF | 544.26 | 544.76 | 543.94 | 543.98 | 35942.0 |
| 2024-09-09 07:00:00 | SPY | ETF | 544.1 | 544.81 | 543.6 | 543.97 | 500074.0 |
| 2024-09-09 08:00:00 | SPY | ETF | 544.07 | 544.7 | 541.97 | 544.06 | 257112.0 |
| 2024-09-09 09:00:00 | SPY | ETF | 544.06 | 545.49 | 543.88 | 545.3 | 4184551.0 |
| 2024-09-09 10:00:00 | SPY | ETF | 545.3 | 546.39 | 543.31 | 543.31 | 4196341.0 |
| 2024-09-09 11:00:00 | SPY | ETF | 543.33 | 545.99 | 542.68 | 545.99 | 2400428.0 |
| 2024-09-09 12:00:00 | SPY | ETF | 545.98 | 547.68 | 545.76 | 547.49 | 2503372.0 |
| 2024-09-09 13:00:00 | SPY | ETF | 547.485 | 547.71 | 545.575 | 545.7401 | 2427141.0 |
| 2024-09-09 14:00:00 | SPY | ETF | 545.74 | 545.85 | 544.18 | 545.11 | 3441281.0 |
| 2024-09-09 15:00:00 | SPY | ETF | 545.07 | 546.51 | 544.46 | 546.42 | 6807562.0 |
| 2024-09-09 16:00:00 | SPY | ETF | 546.39 | 547.43 | 546.21 | 547.13 | 3566926.0 |
| 2024-09-09 17:00:00 | SPY | ETF | 547.18 | 547.36 | 547.12 | 547.27 | 32999.0 |
| 2024-09-09 18:00:00 | SPY | ETF | 547.27 | 547.52 | 546.85 | 546.87 | 112634.0 |
| 2024-09-09 19:00:00 | SPY | ETF | 546.84 | 547.35 | 546.82 | 547.13 | 48327.0 |
| 2024-09-09 04:00:00 | QQQ | ETF | 451.12 | 452.87 | 451.12 | 452.46 | 114540.0 |
| 2024-09-09 05:00:00 | QQQ | ETF | 452.53 | 453.18 | 452.4 | 452.9 | 34834.0 |
| 2024-09-09 06:00:00 | QQQ | ETF | 453.1 | 453.38 | 452.25 | 452.44 | 88714.0 |
| 2024-09-09 07:00:00 | QQQ | ETF | 452.53 | 453.18 | 452.04 | 452.25 | 297659.0 |
| 2024-09-09 08:00:00 | QQQ | ETF | 452.485 | 453.097 | 450.83 | 452.41 | 337314.0 |
| 2024-09-09 09:00:00 | QQQ | ETF | 452.41 | 454.65 | 452.17 | 454.45 | 3890796.0 |
| 2024-09-09 10:00:00 | QQQ | ETF | 454.46 | 455.24 | 450.32 | 450.34 | 4728679.0 |
| 2024-09-09 11:00:00 | QQQ | ETF | 450.34 | 453.41 | 449.8234 | 453.39 | 2593626.0 |
| 2024-09-09 12:00:00 | QQQ | ETF | 453.39 | 455.19 | 453.12 | 455.0205 | 2428852.0 |
| 2024-09-09 13:00:00 | QQQ | ETF | 455.01 | 455.46 | 453.07 | 453.275 | 2444108.0 |
| 2024-09-09 14:00:00 | QQQ | ETF | 453.22 | 453.3499 | 451.56 | 452.47 | 2610850.0 |
| 2024-09-09 15:00:00 | QQQ | ETF | 452.46 | 454.72 | 451.9 | 454.51 | 3369686.0 |
| 2024-09-09 16:00:00 | QQQ | ETF | 454.5 | 455.59 | 454.29 | 455.3 | 1375454.0 |
| 2024-09-09 17:00:00 | QQQ | ETF | 455.34 | 455.6 | 455.33 | 455.54 | 38319.0 |
| 2024-09-09 18:00:00 | QQQ | ETF | 455.5 | 455.73 | 454.75 | 454.76 | 100684.0 |
| 2024-09-09 19:00:00 | QQQ | ETF | 454.76 | 455.39 | 454.75 | 455.12 | 68258.0 |
| 2024-09-09 04:00:00 | IWM | ETF | 208.28 | 208.72 | 208.18 | 208.35 | 28640.0 |
| 2024-09-09 05:00:00 | IWM | ETF | 208.35 | 208.7 | 208.28 | 208.29 | 15688.0 |
| 2024-09-09 06:00:00 | IWM | ETF | 208.36 | 208.44 | 208.14 | 208.35 | 21521.0 |
| 2024-09-09 07:00:00 | IWM | ETF | 208.22 | 208.75 | 208.2 | 208.5 | 126858.0 |
| 2024-09-09 08:00:00 | IWM | ETF | 208.2212 | 208.63 | 207.95 | 208.34 | 120825.0 |
| 2024-09-09 09:00:00 | IWM | ETF | 208.31 | 208.97 | 207.52 | 208.7 | 3191177.0 |
| 2024-09-09 10:00:00 | IWM | ETF | 208.7 | 210.08 | 208.7 | 208.82 | 2989811.0 |
| 2024-09-09 11:00:00 | IWM | ETF | 208.82 | 209.885 | 208.4 | 209.74 | 1806291.0 |
| 2024-09-09 12:00:00 | IWM | ETF | 209.7499 | 210.255 | 209.6338 | 210.1 | 1496894.0 |
| 2024-09-09 13:00:00 | IWM | ETF | 210.09 | 210.205 | 208.83 | 208.89 | 1265337.0 |
| 2024-09-09 14:00:00 | IWM | ETF | 208.88 | 209.125 | 208.41 | 208.535 | 1720481.0 |
| 2024-09-09 15:00:00 | IWM | ETF | 208.535 | 209.02 | 208.3 | 208.48 | 3385100.0 |
| 2024-09-09 16:00:00 | IWM | ETF | 208.47 | 208.85 | 208.46 | 208.84 | 1286510.0 |
| 2024-09-09 17:00:00 | IWM | ETF | 208.83 | 208.99 | 208.75 | 208.95 | 10855.0 |
| 2024-09-09 18:00:00 | IWM | ETF | 208.81 | 208.95 | 208.65 | 208.65 | 24234.0 |
| 2024-09-09 19:00:00 | IWM | ETF | 208.64 | 208.83 | 208.62 | 208.69 | 22972.0 |
| 2024-09-09 04:00:00 | DIA | ETF | 406.51 | 406.52 | 406.05 | 406.25 | 1655.0 |
| 2024-09-09 05:00:00 | DIA | ETF | 406.39 | 406.82 | 406.39 | 406.82 | 410.0 |
> showing 50 of 20,621 rows — these rows as CSV