PREVIEW / etf_1hour / 2024-03-01
file: by_date/etf_1hour/2024/2024-03-01.parquet size: 541 KB rows: 20,158
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-01 04:00:00 | SPY | ETF | 509.0 | 509.64 | 509.0 | 509.25 | 34303.0 |
| 2024-03-01 05:00:00 | SPY | ETF | 509.2 | 509.2 | 507.39 | 507.93 | 109864.0 |
| 2024-03-01 06:00:00 | SPY | ETF | 507.95 | 508.5 | 507.95 | 508.45 | 64065.0 |
| 2024-03-01 07:00:00 | SPY | ETF | 508.48 | 508.82 | 508.17 | 508.54 | 193601.0 |
| 2024-03-01 08:00:00 | SPY | ETF | 508.4982 | 509.96 | 507.8904 | 508.68 | 333126.0 |
| 2024-03-01 09:00:00 | SPY | ETF | 508.66 | 509.56 | 508.48 | 509.08 | 4005652.0 |
| 2024-03-01 10:00:00 | SPY | ETF | 509.085 | 510.84 | 508.67 | 510.66 | 8696905.0 |
| 2024-03-01 11:00:00 | SPY | ETF | 510.65 | 511.38 | 510.16 | 511.1408 | 6796377.0 |
| 2024-03-01 12:00:00 | SPY | ETF | 511.15 | 512.06 | 510.71 | 511.81 | 4580670.0 |
| 2024-03-01 13:00:00 | SPY | ETF | 511.82 | 512.695 | 511.68 | 512.615 | 5297805.0 |
| 2024-03-01 14:00:00 | SPY | ETF | 512.62 | 513.29 | 512.56 | 513.0999 | 6338433.0 |
| 2024-03-01 15:00:00 | SPY | ETF | 513.09 | 513.14 | 512.315 | 512.84 | 12008673.0 |
| 2024-03-01 16:00:00 | SPY | ETF | 512.84 | 512.86 | 512.22 | 512.22 | 2561752.0 |
| 2024-03-01 17:00:00 | SPY | ETF | 512.23 | 512.45 | 511.81 | 511.94 | 160581.0 |
| 2024-03-01 18:00:00 | SPY | ETF | 511.93 | 512.1 | 511.85 | 512.0506 | 13338.0 |
| 2024-03-01 19:00:00 | SPY | ETF | 512.1 | 512.23 | 512.0 | 512.01 | 22724.0 |
| 2024-03-01 04:00:00 | QQQ | ETF | 440.49 | 441.09 | 440.45 | 440.69 | 49848.0 |
| 2024-03-01 05:00:00 | QQQ | ETF | 440.61 | 440.61 | 438.3 | 439.14 | 121160.0 |
| 2024-03-01 06:00:00 | QQQ | ETF | 439.06 | 439.84 | 439.04 | 439.74 | 35773.0 |
| 2024-03-01 07:00:00 | QQQ | ETF | 439.77 | 440.04 | 439.38 | 439.8 | 84795.0 |
| 2024-03-01 08:00:00 | QQQ | ETF | 439.766 | 441.4 | 438.5696 | 439.729 | 338993.0 |
| 2024-03-01 09:00:00 | QQQ | ETF | 439.69 | 441.07 | 439.54 | 440.81 | 3361342.0 |
| 2024-03-01 10:00:00 | QQQ | ETF | 440.83 | 442.49 | 440.51 | 442.21 | 5580143.0 |
| 2024-03-01 11:00:00 | QQQ | ETF | 442.2 | 443.57 | 442.13 | 443.35 | 3415149.0 |
| 2024-03-01 12:00:00 | QQQ | ETF | 443.35 | 444.61 | 442.93 | 444.47 | 3016777.0 |
| 2024-03-01 13:00:00 | QQQ | ETF | 444.48 | 445.98 | 444.36 | 445.91 | 3599117.0 |
| 2024-03-01 14:00:00 | QQQ | ETF | 445.91 | 446.58 | 445.615 | 446.43 | 4299715.0 |
| 2024-03-01 15:00:00 | QQQ | ETF | 446.43 | 446.43 | 445.33 | 445.67 | 6354239.0 |
| 2024-03-01 16:00:00 | QQQ | ETF | 445.68 | 445.7 | 445.2 | 445.34 | 1434879.0 |
| 2024-03-01 17:00:00 | QQQ | ETF | 445.36 | 445.4 | 445.0191 | 445.16 | 44380.0 |
| 2024-03-01 18:00:00 | QQQ | ETF | 445.14 | 445.35 | 445.11 | 445.21 | 20159.0 |
| 2024-03-01 19:00:00 | QQQ | ETF | 445.32 | 445.4 | 445.1 | 445.1 | 21310.0 |
| 2024-03-01 04:00:00 | IWM | ETF | 203.87 | 203.97 | 203.45 | 203.61 | 19243.0 |
| 2024-03-01 05:00:00 | IWM | ETF | 203.53 | 203.65 | 202.69 | 203.38 | 131384.0 |
| 2024-03-01 06:00:00 | IWM | ETF | 203.35 | 203.57 | 203.09 | 203.46 | 85989.0 |
| 2024-03-01 07:00:00 | IWM | ETF | 203.54 | 203.81 | 203.43 | 203.78 | 51260.0 |
| 2024-03-01 08:00:00 | IWM | ETF | 203.5295 | 204.31 | 202.9204 | 204.24 | 297353.0 |
| 2024-03-01 09:00:00 | IWM | ETF | 204.22 | 204.81 | 203.14 | 203.79 | 3387679.0 |
| 2024-03-01 10:00:00 | IWM | ETF | 203.81 | 205.99 | 203.8 | 205.87 | 6432425.0 |
| 2024-03-01 11:00:00 | IWM | ETF | 205.86 | 206.325 | 205.32 | 205.81 | 4113676.0 |
| 2024-03-01 12:00:00 | IWM | ETF | 205.81 | 206.15 | 205.6 | 205.89 | 2230288.0 |
| 2024-03-01 13:00:00 | IWM | ETF | 205.89 | 206.05 | 205.63 | 206.0299 | 2505642.0 |
| 2024-03-01 14:00:00 | IWM | ETF | 206.04 | 206.22 | 205.81 | 206.16 | 2764001.0 |
| 2024-03-01 15:00:00 | IWM | ETF | 206.16 | 206.18 | 205.46 | 205.89 | 6265183.0 |
| 2024-03-01 16:00:00 | IWM | ETF | 205.89 | 205.89 | 205.32 | 205.34 | 2238130.0 |
| 2024-03-01 17:00:00 | IWM | ETF | 205.38 | 205.57 | 205.355 | 205.44 | 15832.0 |
| 2024-03-01 18:00:00 | IWM | ETF | 205.44 | 205.48 | 205.36 | 205.4167 | 7188.0 |
| 2024-03-01 19:00:00 | IWM | ETF | 205.44 | 205.66 | 205.44 | 205.48 | 7917.0 |
| 2024-03-01 04:00:00 | DIA | ETF | 390.2 | 390.37 | 390.2 | 390.37 | 1000.0 |
| 2024-03-01 05:00:00 | DIA | ETF | 390.03 | 390.03 | 389.4 | 389.41 | 1200.0 |
> showing 50 of 20,158 rows — these rows as CSV