PREVIEW / etf_1hour / 2024-03-06
file: by_date/etf_1hour/2024/2024-03-06.parquet size: 539 KB rows: 20,210
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-06 04:00:00 | SPY | ETF | 508.58 | 509.21 | 508.0 | 509.1 | 50261.0 |
| 2024-03-06 05:00:00 | SPY | ETF | 509.2 | 509.32 | 508.84 | 508.85 | 39000.0 |
| 2024-03-06 06:00:00 | SPY | ETF | 508.85 | 509.1 | 508.71 | 508.86 | 16904.0 |
| 2024-03-06 07:00:00 | SPY | ETF | 508.9 | 509.52 | 508.82 | 509.45 | 143132.0 |
| 2024-03-06 08:00:00 | SPY | ETF | 508.8511 | 510.34 | 507.51 | 510.31 | 616994.0 |
| 2024-03-06 09:00:00 | SPY | ETF | 510.3 | 510.8504 | 509.63 | 509.91 | 5820220.0 |
| 2024-03-06 10:00:00 | SPY | ETF | 509.9 | 510.58 | 508.42 | 510.455 | 6268612.0 |
| 2024-03-06 11:00:00 | SPY | ETF | 510.47 | 511.64 | 510.47 | 511.2159 | 5930072.0 |
| 2024-03-06 12:00:00 | SPY | ETF | 511.22 | 512.069 | 511.05 | 511.33 | 5045266.0 |
| 2024-03-06 13:00:00 | SPY | ETF | 511.33 | 511.95 | 509.12 | 510.15 | 7450329.0 |
| 2024-03-06 14:00:00 | SPY | ETF | 510.16 | 510.43 | 508.52 | 509.24 | 8205095.0 |
| 2024-03-06 15:00:00 | SPY | ETF | 509.24 | 510.27 | 508.57 | 509.8 | 11722437.0 |
| 2024-03-06 16:00:00 | SPY | ETF | 509.8 | 510.1701 | 509.69 | 509.93 | 3128078.0 |
| 2024-03-06 17:00:00 | SPY | ETF | 509.95 | 510.04 | 509.75 | 509.99 | 188885.0 |
| 2024-03-06 18:00:00 | SPY | ETF | 509.95 | 509.96 | 509.55 | 509.55 | 28522.0 |
| 2024-03-06 19:00:00 | SPY | ETF | 509.6 | 509.69 | 508.64 | 508.93 | 145006.0 |
| 2024-03-06 04:00:00 | QQQ | ETF | 437.62 | 439.36 | 437.62 | 439.13 | 77143.0 |
| 2024-03-06 05:00:00 | QQQ | ETF | 439.23 | 439.6 | 439.06 | 439.06 | 46168.0 |
| 2024-03-06 06:00:00 | QQQ | ETF | 439.04 | 439.34 | 438.66 | 438.8 | 50952.0 |
| 2024-03-06 07:00:00 | QQQ | ETF | 438.82 | 439.58 | 438.6 | 439.44 | 198414.0 |
| 2024-03-06 08:00:00 | QQQ | ETF | 438.69 | 440.14 | 435.723 | 440.14 | 685196.0 |
| 2024-03-06 09:00:00 | QQQ | ETF | 440.14 | 440.83 | 438.59 | 438.94 | 5950003.0 |
| 2024-03-06 10:00:00 | QQQ | ETF | 438.94 | 439.86 | 436.89 | 439.6501 | 6153125.0 |
| 2024-03-06 11:00:00 | QQQ | ETF | 439.64 | 440.94 | 439.26 | 440.735 | 4138032.0 |
| 2024-03-06 12:00:00 | QQQ | ETF | 440.74 | 441.99 | 440.61 | 440.99 | 3178505.0 |
| 2024-03-06 13:00:00 | QQQ | ETF | 440.99 | 441.68 | 438.53 | 439.69 | 5354819.0 |
| 2024-03-06 14:00:00 | QQQ | ETF | 439.66 | 440.0 | 437.84 | 438.47 | 4900382.0 |
| 2024-03-06 15:00:00 | QQQ | ETF | 438.46 | 439.31 | 437.4 | 438.86 | 5916135.0 |
| 2024-03-06 16:00:00 | QQQ | ETF | 438.84 | 439.9832 | 438.46 | 438.73 | 1539639.0 |
| 2024-03-06 17:00:00 | QQQ | ETF | 438.7396 | 438.89 | 438.6 | 438.79 | 343212.0 |
| 2024-03-06 18:00:00 | QQQ | ETF | 438.83 | 438.91 | 438.2792 | 438.2792 | 41645.0 |
| 2024-03-06 19:00:00 | QQQ | ETF | 438.2499 | 438.44 | 437.18 | 437.64 | 171461.0 |
| 2024-03-06 04:00:00 | IWM | ETF | 204.36 | 204.79 | 204.26 | 204.78 | 16708.0 |
| 2024-03-06 05:00:00 | IWM | ETF | 204.82 | 205.1 | 204.7 | 204.79 | 21625.0 |
| 2024-03-06 06:00:00 | IWM | ETF | 204.79 | 204.91 | 204.52 | 204.57 | 16625.0 |
| 2024-03-06 07:00:00 | IWM | ETF | 204.53 | 204.93 | 204.53 | 204.59 | 56782.0 |
| 2024-03-06 08:00:00 | IWM | ETF | 204.6 | 205.5 | 203.98 | 205.47 | 238934.0 |
| 2024-03-06 09:00:00 | IWM | ETF | 205.48 | 206.08 | 204.56 | 205.05 | 2951487.0 |
| 2024-03-06 10:00:00 | IWM | ETF | 205.03 | 205.44 | 204.08 | 205.33 | 3842269.0 |
| 2024-03-06 11:00:00 | IWM | ETF | 205.33 | 206.015 | 205.24 | 205.3 | 3134783.0 |
| 2024-03-06 12:00:00 | IWM | ETF | 205.31 | 206.0399 | 205.06 | 205.73 | 2143021.0 |
| 2024-03-06 13:00:00 | IWM | ETF | 205.73 | 205.94 | 204.49 | 205.07 | 2586644.0 |
| 2024-03-06 14:00:00 | IWM | ETF | 205.06 | 205.75 | 204.55 | 205.185 | 4306174.0 |
| 2024-03-06 15:00:00 | IWM | ETF | 205.17 | 205.6 | 204.41 | 205.19 | 5170066.0 |
| 2024-03-06 16:00:00 | IWM | ETF | 205.25 | 205.35 | 205.0 | 205.24 | 1221925.0 |
| 2024-03-06 17:00:00 | IWM | ETF | 205.25 | 205.32 | 205.12 | 205.13 | 817285.0 |
| 2024-03-06 18:00:00 | IWM | ETF | 205.22 | 205.25 | 204.72 | 204.72 | 28247.0 |
| 2024-03-06 19:00:00 | IWM | ETF | 204.7 | 204.85 | 204.46 | 204.52 | 39063.0 |
| 2024-03-06 05:00:00 | DIA | ETF | 387.02 | 387.02 | 387.02 | 387.02 | 500.0 |
| 2024-03-06 07:00:00 | DIA | ETF | 387.19 | 387.31 | 387.12 | 387.31 | 1736.0 |
> showing 50 of 20,210 rows — these rows as CSV