PREVIEW / etf_30min / 2024-11-19
file: by_date/etf_30min/2024/2024-11-19.parquet size: 905 KB rows: 36,300
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-11-19 04:00:00 | SPY | ETF | 588.4 | 588.4 | 585.05 | 585.3 | 37392.0 |
| 2024-11-19 04:30:00 | SPY | ETF | 585.23 | 585.91 | 584.63 | 585.43 | 43576.0 |
| 2024-11-19 05:00:00 | SPY | ETF | 585.7 | 586.32 | 585.2 | 585.62 | 20091.0 |
| 2024-11-19 05:30:00 | SPY | ETF | 585.5 | 586.4 | 585.49 | 585.93 | 7982.0 |
| 2024-11-19 06:00:00 | SPY | ETF | 586.01 | 586.22 | 585.59 | 585.59 | 34585.0 |
| 2024-11-19 06:30:00 | SPY | ETF | 585.59 | 586.13 | 585.35 | 585.81 | 20931.0 |
| 2024-11-19 07:00:00 | SPY | ETF | 586.03 | 587.06 | 585.93 | 586.92 | 72663.0 |
| 2024-11-19 07:30:00 | SPY | ETF | 586.84 | 587.05 | 586.5 | 587.04 | 25180.0 |
| 2024-11-19 08:00:00 | SPY | ETF | 587.0 | 589.35 | 584.6396 | 586.08 | 127318.0 |
| 2024-11-19 08:30:00 | SPY | ETF | 586.0 | 586.1 | 582.45 | 582.59 | 497478.0 |
| 2024-11-19 09:00:00 | SPY | ETF | 582.6 | 584.756 | 581.901 | 584.756 | 604262.0 |
| 2024-11-19 09:30:00 | SPY | ETF | 584.71 | 585.7996 | 584.03 | 585.2501 | 3497430.0 |
| 2024-11-19 10:00:00 | SPY | ETF | 585.25 | 586.48 | 584.645 | 586.46 | 1974198.0 |
| 2024-11-19 10:30:00 | SPY | ETF | 586.45 | 588.09 | 586.09 | 587.73 | 1956461.0 |
| 2024-11-19 11:00:00 | SPY | ETF | 587.73 | 589.01 | 587.65 | 588.8999 | 1442989.0 |
| 2024-11-19 11:30:00 | SPY | ETF | 588.89 | 589.24 | 588.46 | 588.829 | 1493594.0 |
| 2024-11-19 12:00:00 | SPY | ETF | 588.83 | 589.07 | 588.03 | 588.98 | 1036534.0 |
| 2024-11-19 12:30:00 | SPY | ETF | 588.97 | 589.5399 | 588.83 | 589.17 | 984827.0 |
| 2024-11-19 13:00:00 | SPY | ETF | 589.18 | 589.63 | 588.76 | 589.5507 | 842333.0 |
| 2024-11-19 13:30:00 | SPY | ETF | 589.56 | 591.045 | 589.4 | 590.9 | 1679076.0 |
| 2024-11-19 14:00:00 | SPY | ETF | 590.9 | 590.98 | 589.5 | 590.13 | 1564378.0 |
| 2024-11-19 14:30:00 | SPY | ETF | 590.14 | 590.36 | 589.09 | 589.63 | 2284914.0 |
| 2024-11-19 15:00:00 | SPY | ETF | 589.63 | 589.95 | 589.365 | 589.88 | 1418298.0 |
| 2024-11-19 15:30:00 | SPY | ETF | 589.88 | 590.6 | 589.68 | 590.29 | 4025311.0 |
| 2024-11-19 16:00:00 | SPY | ETF | 590.28 | 590.8 | 590.21 | 590.46 | 2259493.0 |
| 2024-11-19 16:30:00 | SPY | ETF | 590.43 | 590.45 | 590.2 | 590.24 | 67881.0 |
| 2024-11-19 17:00:00 | SPY | ETF | 590.15 | 590.2199 | 590.01 | 590.04 | 25022.0 |
| 2024-11-19 17:30:00 | SPY | ETF | 590.09 | 590.14 | 590.0 | 590.12 | 29666.0 |
| 2024-11-19 18:00:00 | SPY | ETF | 590.12 | 590.8 | 590.1 | 590.63 | 41262.0 |
| 2024-11-19 18:30:00 | SPY | ETF | 590.6 | 590.91 | 590.53 | 590.869 | 9535.0 |
| 2024-11-19 19:00:00 | SPY | ETF | 590.91 | 591.74 | 590.89 | 591.5996 | 21698.0 |
| 2024-11-19 19:30:00 | SPY | ETF | 591.61 | 591.68 | 591.35 | 591.39 | 21106.0 |
| 2024-11-19 04:00:00 | QQQ | ETF | 499.98 | 500.45 | 497.21 | 497.44 | 67426.0 |
| 2024-11-19 04:30:00 | QQQ | ETF | 497.43 | 498.29 | 496.75 | 497.88 | 84237.0 |
| 2024-11-19 05:00:00 | QQQ | ETF | 498.0 | 498.98 | 497.66 | 498.73 | 28087.0 |
| 2024-11-19 05:30:00 | QQQ | ETF | 498.1 | 499.09 | 498.1 | 498.85 | 23606.0 |
| 2024-11-19 06:00:00 | QQQ | ETF | 498.83 | 498.97 | 498.2 | 498.2 | 11970.0 |
| 2024-11-19 06:30:00 | QQQ | ETF | 498.13 | 498.92 | 497.82 | 498.86 | 34571.0 |
| 2024-11-19 07:00:00 | QQQ | ETF | 498.86 | 499.88 | 498.76 | 499.55 | 95636.0 |
| 2024-11-19 07:30:00 | QQQ | ETF | 499.59 | 499.74 | 499.059 | 499.69 | 41861.0 |
| 2024-11-19 08:00:00 | QQQ | ETF | 499.78 | 501.2 | 497.1096 | 498.5514 | 110306.0 |
| 2024-11-19 08:30:00 | QQQ | ETF | 498.43 | 498.53 | 494.9 | 495.04 | 334425.0 |
| 2024-11-19 09:00:00 | QQQ | ETF | 494.98 | 497.37 | 494.11 | 497.37 | 621842.0 |
| 2024-11-19 09:30:00 | QQQ | ETF | 497.42 | 499.0 | 497.08 | 498.2301 | 2206244.0 |
| 2024-11-19 10:00:00 | QQQ | ETF | 498.19 | 499.44 | 497.52 | 499.42 | 912814.0 |
| 2024-11-19 10:30:00 | QQQ | ETF | 499.39 | 500.7 | 498.91 | 500.2593 | 1354252.0 |
| 2024-11-19 11:00:00 | QQQ | ETF | 500.25 | 501.45 | 500.22 | 501.34 | 1083209.0 |
| 2024-11-19 11:30:00 | QQQ | ETF | 501.34 | 501.74 | 500.84 | 501.019 | 1138031.0 |
| 2024-11-19 12:00:00 | QQQ | ETF | 501.02 | 501.45 | 500.39 | 501.3921 | 627089.0 |
| 2024-11-19 12:30:00 | QQQ | ETF | 501.38 | 501.9499 | 501.25 | 501.62 | 583802.0 |
> showing 50 of 36,300 rows — these rows as CSV