PREVIEW / etf_30min / 2024-04-26
file: by_date/etf_30min/2024/2024-04-26.parquet size: 779 KB rows: 30,984
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-04-26 04:00:00 | SPY | ETF | 507.33 | 507.84 | 507.21 | 507.31 | 18166.0 |
| 2024-04-26 04:30:00 | SPY | ETF | 507.36 | 507.36 | 506.95 | 506.97 | 6763.0 |
| 2024-04-26 05:00:00 | SPY | ETF | 506.91 | 506.99 | 506.63 | 506.65 | 8377.0 |
| 2024-04-26 05:30:00 | SPY | ETF | 506.69 | 507.07 | 506.69 | 506.97 | 2638.0 |
| 2024-04-26 06:00:00 | SPY | ETF | 506.86 | 507.15 | 506.84 | 507.15 | 1900.0 |
| 2024-04-26 06:30:00 | SPY | ETF | 507.11 | 507.14 | 506.65 | 506.85 | 25324.0 |
| 2024-04-26 07:00:00 | SPY | ETF | 506.92 | 507.53 | 506.5 | 507.18 | 136128.0 |
| 2024-04-26 07:30:00 | SPY | ETF | 507.3 | 507.32 | 506.93 | 507.2 | 46907.0 |
| 2024-04-26 08:00:00 | SPY | ETF | 507.09 | 508.01 | 506.6704 | 507.02 | 188021.0 |
| 2024-04-26 08:30:00 | SPY | ETF | 507.11 | 509.2 | 506.409 | 507.19 | 990806.0 |
| 2024-04-26 09:00:00 | SPY | ETF | 507.18 | 507.67 | 505.91 | 506.37 | 341957.0 |
| 2024-04-26 09:30:00 | SPY | ETF | 506.35 | 508.24 | 505.7 | 507.84 | 5782717.0 |
| 2024-04-26 10:00:00 | SPY | ETF | 507.84 | 509.01 | 507.65 | 508.08 | 3736830.0 |
| 2024-04-26 10:30:00 | SPY | ETF | 508.08 | 508.9 | 507.73 | 508.78 | 2933865.0 |
| 2024-04-26 11:00:00 | SPY | ETF | 508.8 | 509.55 | 507.72 | 508.22 | 2704806.0 |
| 2024-04-26 11:30:00 | SPY | ETF | 508.21 | 509.008 | 508.0 | 508.625 | 2880075.0 |
| 2024-04-26 12:00:00 | SPY | ETF | 508.62 | 508.92 | 508.16 | 508.88 | 1721613.0 |
| 2024-04-26 12:30:00 | SPY | ETF | 508.8799 | 509.57 | 508.625 | 509.56 | 1900393.0 |
| 2024-04-26 13:00:00 | SPY | ETF | 509.56 | 509.81 | 509.3 | 509.59 | 1787349.0 |
| 2024-04-26 13:30:00 | SPY | ETF | 509.6 | 509.88 | 509.1 | 509.42 | 1873672.0 |
| 2024-04-26 14:00:00 | SPY | ETF | 509.425 | 509.49 | 508.785 | 508.96 | 1797822.0 |
| 2024-04-26 14:30:00 | SPY | ETF | 508.97 | 509.42 | 508.578 | 509.4 | 2025198.0 |
| 2024-04-26 15:00:00 | SPY | ETF | 509.4 | 509.65 | 509.07 | 509.64 | 1863741.0 |
| 2024-04-26 15:30:00 | SPY | ETF | 509.62 | 509.63 | 508.16 | 508.24 | 8475312.0 |
| 2024-04-26 16:00:00 | SPY | ETF | 508.23 | 508.6 | 508.17 | 508.33 | 5421076.0 |
| 2024-04-26 16:30:00 | SPY | ETF | 508.3 | 508.46 | 508.3 | 508.44 | 592914.0 |
| 2024-04-26 17:00:00 | SPY | ETF | 508.6 | 508.66 | 508.43 | 508.65 | 60684.0 |
| 2024-04-26 17:30:00 | SPY | ETF | 508.65 | 508.68 | 508.03 | 508.28 | 63653.0 |
| 2024-04-26 18:00:00 | SPY | ETF | 508.28 | 508.33 | 508.18 | 508.3087 | 12140.0 |
| 2024-04-26 18:30:00 | SPY | ETF | 508.33 | 508.38 | 508.29 | 508.38 | 3461.0 |
| 2024-04-26 19:00:00 | SPY | ETF | 508.44 | 508.65 | 508.44 | 508.62 | 2340.0 |
| 2024-04-26 19:30:00 | SPY | ETF | 508.5191 | 508.7 | 508.49 | 508.69 | 4618.0 |
| 2024-04-26 04:00:00 | QQQ | ETF | 429.11 | 429.39 | 428.86 | 429.06 | 105055.0 |
| 2024-04-26 04:30:00 | QQQ | ETF | 429.09 | 429.12 | 428.43 | 428.52 | 20994.0 |
| 2024-04-26 05:00:00 | QQQ | ETF | 428.46 | 428.53 | 428.0 | 428.18 | 45594.0 |
| 2024-04-26 05:30:00 | QQQ | ETF | 428.15 | 428.59 | 428.11 | 428.34 | 57701.0 |
| 2024-04-26 06:00:00 | QQQ | ETF | 428.4 | 428.75 | 428.3 | 428.7 | 13621.0 |
| 2024-04-26 06:30:00 | QQQ | ETF | 428.7 | 428.79 | 428.16 | 428.31 | 24303.0 |
| 2024-04-26 07:00:00 | QQQ | ETF | 428.36 | 429.2 | 428.36 | 428.95 | 77129.0 |
| 2024-04-26 07:30:00 | QQQ | ETF | 429.0 | 429.0 | 428.5 | 428.75 | 52517.0 |
| 2024-04-26 08:00:00 | QQQ | ETF | 429.09 | 429.9 | 427.9 | 428.4 | 295224.0 |
| 2024-04-26 08:30:00 | QQQ | ETF | 428.6 | 430.5 | 427.61 | 428.36 | 642092.0 |
| 2024-04-26 09:00:00 | QQQ | ETF | 428.41 | 428.9 | 427.21 | 427.64 | 428230.0 |
| 2024-04-26 09:30:00 | QQQ | ETF | 427.62 | 430.2 | 426.92 | 429.82 | 7870793.0 |
| 2024-04-26 10:00:00 | QQQ | ETF | 429.82 | 431.1 | 429.39 | 429.99 | 3500096.0 |
| 2024-04-26 10:30:00 | QQQ | ETF | 430.01 | 431.535 | 429.64 | 431.39 | 2361114.0 |
| 2024-04-26 11:00:00 | QQQ | ETF | 431.415 | 432.17 | 430.47 | 431.0 | 2092082.0 |
| 2024-04-26 11:30:00 | QQQ | ETF | 431.015 | 431.93 | 430.68 | 431.275 | 1438289.0 |
| 2024-04-26 12:00:00 | QQQ | ETF | 431.28 | 431.36 | 430.76 | 431.23 | 840587.0 |
| 2024-04-26 12:30:00 | QQQ | ETF | 431.25 | 432.09 | 430.96 | 432.09 | 952651.0 |
> showing 50 of 30,984 rows — these rows as CSV