PREVIEW / etf_1hour / 2024-01-05
file: by_date/etf_1hour/2024/2024-01-05.parquet size: 520 KB rows: 19,245
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-05 04:00:00 | SPY | ETF | 466.86 | 467.28 | 466.28 | 466.3 | 14188.0 |
| 2024-01-05 05:00:00 | SPY | ETF | 466.34 | 466.48 | 465.88 | 466.18 | 11520.0 |
| 2024-01-05 06:00:00 | SPY | ETF | 466.32 | 466.43 | 465.65 | 466.17 | 19733.0 |
| 2024-01-05 07:00:00 | SPY | ETF | 466.22 | 466.5 | 465.91 | 466.11 | 143509.0 |
| 2024-01-05 08:00:00 | SPY | ETF | 466.2191 | 467.52 | 464.61 | 466.37 | 2070270.0 |
| 2024-01-05 09:00:00 | SPY | ETF | 466.41 | 468.59 | 466.38 | 468.1699 | 7549289.0 |
| 2024-01-05 10:00:00 | SPY | ETF | 468.15 | 470.42 | 468.15 | 470.14 | 11553171.0 |
| 2024-01-05 11:00:00 | SPY | ETF | 470.14 | 470.44 | 468.59 | 468.79 | 7330402.0 |
| 2024-01-05 12:00:00 | SPY | ETF | 468.77 | 468.84 | 467.14 | 467.54 | 7232757.0 |
| 2024-01-05 13:00:00 | SPY | ETF | 467.525 | 468.69 | 466.68 | 468.35 | 5942976.0 |
| 2024-01-05 14:00:00 | SPY | ETF | 468.37 | 468.98 | 466.65 | 466.815 | 6836045.0 |
| 2024-01-05 15:00:00 | SPY | ETF | 466.82 | 468.29 | 466.43 | 467.96 | 12375742.0 |
| 2024-01-05 16:00:00 | SPY | ETF | 467.97 | 468.47 | 467.86 | 467.96 | 3265624.0 |
| 2024-01-05 17:00:00 | SPY | ETF | 467.96 | 468.45 | 467.95 | 468.37 | 58951.0 |
| 2024-01-05 18:00:00 | SPY | ETF | 468.3 | 468.46 | 468.3 | 468.37 | 26707.0 |
| 2024-01-05 19:00:00 | SPY | ETF | 468.38 | 468.47 | 468.29 | 468.45 | 19187.0 |
| 2024-01-05 04:00:00 | QQQ | ETF | 395.51 | 395.81 | 395.1 | 395.22 | 37864.0 |
| 2024-01-05 05:00:00 | QQQ | ETF | 395.24 | 395.35 | 394.61 | 394.92 | 48350.0 |
| 2024-01-05 06:00:00 | QQQ | ETF | 394.99 | 395.12 | 394.5 | 394.98 | 39609.0 |
| 2024-01-05 07:00:00 | QQQ | ETF | 395.0 | 395.32 | 394.81 | 395.04 | 196128.0 |
| 2024-01-05 08:00:00 | QQQ | ETF | 396.08 | 396.31 | 393.66 | 395.23 | 1548343.0 |
| 2024-01-05 09:00:00 | QQQ | ETF | 395.29 | 397.57 | 395.22 | 397.01 | 5883188.0 |
| 2024-01-05 10:00:00 | QQQ | ETF | 397.02 | 399.31 | 397.02 | 399.18 | 7567112.0 |
| 2024-01-05 11:00:00 | QQQ | ETF | 399.19 | 399.56 | 397.53 | 398.06 | 4772297.0 |
| 2024-01-05 12:00:00 | QQQ | ETF | 398.05 | 398.11 | 396.44 | 396.9391 | 3625291.0 |
| 2024-01-05 13:00:00 | QQQ | ETF | 396.915 | 397.78 | 396.02 | 397.38 | 3364176.0 |
| 2024-01-05 14:00:00 | QQQ | ETF | 397.39 | 397.88 | 395.7 | 395.83 | 3327481.0 |
| 2024-01-05 15:00:00 | QQQ | ETF | 395.84 | 396.99 | 395.34 | 396.77 | 6004842.0 |
| 2024-01-05 16:00:00 | QQQ | ETF | 396.78 | 396.9 | 396.61 | 396.81 | 799386.0 |
| 2024-01-05 17:00:00 | QQQ | ETF | 396.81 | 396.97 | 396.72 | 396.96 | 29498.0 |
| 2024-01-05 18:00:00 | QQQ | ETF | 396.9 | 396.9 | 396.7 | 396.87 | 16425.0 |
| 2024-01-05 19:00:00 | QQQ | ETF | 396.86 | 396.98 | 396.83 | 396.98 | 20182.0 |
| 2024-01-05 04:00:00 | IWM | ETF | 193.53 | 193.53 | 193.11 | 193.14 | 19010.0 |
| 2024-01-05 05:00:00 | IWM | ETF | 193.16 | 193.18 | 192.61 | 192.83 | 43871.0 |
| 2024-01-05 06:00:00 | IWM | ETF | 192.86 | 192.96 | 192.19 | 192.49 | 74167.0 |
| 2024-01-05 07:00:00 | IWM | ETF | 192.55 | 192.71 | 192.3 | 192.69 | 126890.0 |
| 2024-01-05 08:00:00 | IWM | ETF | 192.5498 | 194.21 | 190.57 | 192.39 | 2014486.0 |
| 2024-01-05 09:00:00 | IWM | ETF | 192.44 | 194.12 | 192.0 | 193.86 | 5340201.0 |
| 2024-01-05 10:00:00 | IWM | ETF | 193.88 | 195.46 | 193.88 | 194.88 | 6428654.0 |
| 2024-01-05 11:00:00 | IWM | ETF | 194.88 | 195.115 | 193.89 | 194.1 | 3444229.0 |
| 2024-01-05 12:00:00 | IWM | ETF | 194.11 | 194.18 | 193.11 | 193.53 | 3438387.0 |
| 2024-01-05 13:00:00 | IWM | ETF | 193.52 | 194.36 | 193.08 | 193.9 | 2377347.0 |
| 2024-01-05 14:00:00 | IWM | ETF | 193.91 | 194.4699 | 192.765 | 192.88 | 3107048.0 |
| 2024-01-05 15:00:00 | IWM | ETF | 192.875 | 193.66 | 192.755 | 193.28 | 5472323.0 |
| 2024-01-05 16:00:00 | IWM | ETF | 193.25 | 193.73 | 193.25 | 193.43 | 805615.0 |
| 2024-01-05 17:00:00 | IWM | ETF | 193.47 | 193.72 | 193.42 | 193.45 | 12616.0 |
| 2024-01-05 18:00:00 | IWM | ETF | 193.45 | 193.65 | 193.45 | 193.5 | 4437.0 |
| 2024-01-05 19:00:00 | IWM | ETF | 193.42 | 193.59 | 193.4 | 193.5 | 5887.0 |
| 2024-01-05 04:00:00 | DIA | ETF | 374.23 | 374.26 | 373.79 | 373.79 | 2830.0 |
| 2024-01-05 05:00:00 | DIA | ETF | 373.73 | 373.8 | 373.73 | 373.74 | 1250.0 |
> showing 50 of 19,245 rows — these rows as CSV