PREVIEW / etf_30min / 2024-11-21
file: by_date/etf_30min/2024/2024-11-21.parquet size: 918 KB rows: 36,402
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-21 04:00:00 | SPY | ETF | 588.85 | 588.86 | 587.23 | 587.49 | 19763.0 |
| 2024-11-21 04:30:00 | SPY | ETF | 587.38 | 588.43 | 587.35 | 588.37 | 11768.0 |
| 2024-11-21 05:00:00 | SPY | ETF | 588.04 | 588.75 | 588.04 | 588.62 | 4308.0 |
| 2024-11-21 05:30:00 | SPY | ETF | 588.63 | 589.17 | 588.63 | 588.87 | 9916.0 |
| 2024-11-21 06:00:00 | SPY | ETF | 589.06 | 590.5 | 589.06 | 590.5 | 13630.0 |
| 2024-11-21 06:30:00 | SPY | ETF | 590.53 | 590.9 | 590.11 | 590.86 | 99945.0 |
| 2024-11-21 07:00:00 | SPY | ETF | 590.74 | 592.57 | 590.67 | 592.15 | 147845.0 |
| 2024-11-21 07:30:00 | SPY | ETF | 592.27 | 592.65 | 591.42 | 591.6 | 131122.0 |
| 2024-11-21 08:00:00 | SPY | ETF | 591.18 | 592.809 | 588.0 | 592.73 | 143668.0 |
| 2024-11-21 08:30:00 | SPY | ETF | 592.77 | 593.86 | 592.76 | 592.91 | 259657.0 |
| 2024-11-21 09:00:00 | SPY | ETF | 592.92 | 593.8 | 592.92 | 593.4 | 196067.0 |
| 2024-11-21 09:30:00 | SPY | ETF | 593.4 | 593.57 | 588.56 | 589.78 | 4852145.0 |
| 2024-11-21 10:00:00 | SPY | ETF | 589.74 | 591.2 | 587.54 | 587.7392 | 2668298.0 |
| 2024-11-21 10:30:00 | SPY | ETF | 587.69 | 591.85 | 587.45 | 591.68 | 2451489.0 |
| 2024-11-21 11:00:00 | SPY | ETF | 591.72 | 592.75 | 591.04 | 592.725 | 1780994.0 |
| 2024-11-21 11:30:00 | SPY | ETF | 592.75 | 593.15 | 591.1601 | 591.89 | 1488712.0 |
| 2024-11-21 12:00:00 | SPY | ETF | 591.89 | 593.28 | 591.08 | 593.0 | 1569359.0 |
| 2024-11-21 12:30:00 | SPY | ETF | 593.01 | 594.17 | 592.8802 | 593.71 | 1652409.0 |
| 2024-11-21 13:00:00 | SPY | ETF | 593.72 | 594.68 | 593.6368 | 594.43 | 1186414.0 |
| 2024-11-21 13:30:00 | SPY | ETF | 594.45 | 594.8 | 593.91 | 594.43 | 1248579.0 |
| 2024-11-21 14:00:00 | SPY | ETF | 594.41 | 594.67 | 593.52 | 594.42 | 1711989.0 |
| 2024-11-21 14:30:00 | SPY | ETF | 594.43 | 594.68 | 593.86 | 594.59 | 1821232.0 |
| 2024-11-21 15:00:00 | SPY | ETF | 594.58 | 595.12 | 594.45 | 594.9 | 1787047.0 |
| 2024-11-21 15:30:00 | SPY | ETF | 594.9 | 595.0 | 593.56 | 593.61 | 4579446.0 |
| 2024-11-21 16:00:00 | SPY | ETF | 593.61 | 593.81 | 593.2 | 593.26 | 2185847.0 |
| 2024-11-21 16:30:00 | SPY | ETF | 593.3 | 593.5 | 593.19 | 593.24 | 115870.0 |
| 2024-11-21 17:00:00 | SPY | ETF | 593.25 | 593.27 | 593.06 | 593.26 | 39924.0 |
| 2024-11-21 17:30:00 | SPY | ETF | 593.26 | 593.6215 | 593.09 | 593.1 | 78492.0 |
| 2024-11-21 18:00:00 | SPY | ETF | 593.1 | 593.27 | 592.71 | 593.27 | 73722.0 |
| 2024-11-21 18:30:00 | SPY | ETF | 593.25 | 593.41 | 592.8 | 593.05 | 14208.0 |
| 2024-11-21 19:00:00 | SPY | ETF | 592.97 | 593.45 | 592.89 | 593.34 | 10946.0 |
| 2024-11-21 19:30:00 | SPY | ETF | 593.23 | 593.23 | 592.83 | 592.97 | 26800.0 |
| 2024-11-21 04:00:00 | QQQ | ETF | 501.4 | 501.46 | 499.55 | 499.73 | 44952.0 |
| 2024-11-21 04:30:00 | QQQ | ETF | 499.73 | 501.07 | 499.62 | 500.79 | 55322.0 |
| 2024-11-21 05:00:00 | QQQ | ETF | 500.67 | 501.19 | 500.4 | 500.98 | 9195.0 |
| 2024-11-21 05:30:00 | QQQ | ETF | 500.97 | 501.65 | 500.97 | 501.56 | 56048.0 |
| 2024-11-21 06:00:00 | QQQ | ETF | 501.54 | 502.98 | 501.54 | 502.65 | 91905.0 |
| 2024-11-21 06:30:00 | QQQ | ETF | 502.98 | 503.0 | 502.06 | 502.81 | 160868.0 |
| 2024-11-21 07:00:00 | QQQ | ETF | 502.75 | 504.58 | 502.6 | 504.15 | 200238.0 |
| 2024-11-21 07:30:00 | QQQ | ETF | 504.15 | 504.6 | 503.28 | 503.5 | 137147.0 |
| 2024-11-21 08:00:00 | QQQ | ETF | 502.61 | 505.04 | 500.0 | 504.99 | 259845.0 |
| 2024-11-21 08:30:00 | QQQ | ETF | 505.0 | 506.18 | 505.0 | 505.48 | 234280.0 |
| 2024-11-21 09:00:00 | QQQ | ETF | 505.54 | 506.55 | 505.54 | 506.26 | 170507.0 |
| 2024-11-21 09:30:00 | QQQ | ETF | 506.24 | 506.96 | 500.31 | 501.31 | 4648684.0 |
| 2024-11-21 10:00:00 | QQQ | ETF | 501.31 | 502.4199 | 497.77 | 497.91 | 3283412.0 |
| 2024-11-21 10:30:00 | QQQ | ETF | 497.91 | 502.242 | 497.56 | 502.2 | 2753411.0 |
| 2024-11-21 11:00:00 | QQQ | ETF | 502.22 | 503.9399 | 501.76 | 503.9399 | 1584211.0 |
| 2024-11-21 11:30:00 | QQQ | ETF | 503.92 | 504.2 | 501.935 | 502.77 | 1342075.0 |
| 2024-11-21 12:00:00 | QQQ | ETF | 502.8 | 504.67 | 501.95 | 504.29 | 1146806.0 |
| 2024-11-21 12:30:00 | QQQ | ETF | 504.285 | 505.77 | 504.2 | 504.8301 | 1562747.0 |
> showing 50 of 36,402 rows — these rows as CSV