PREVIEW / etf_30min / 2024-09-23
file: by_date/etf_30min/2024/2024-09-23.parquet size: 834 KB rows: 33,732
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-09-23 04:00:00 | SPY | ETF | 569.19 | 569.19 | 568.04 | 568.66 | 103982.0 |
| 2024-09-23 04:30:00 | SPY | ETF | 568.59 | 568.68 | 567.86 | 568.55 | 9179.0 |
| 2024-09-23 05:00:00 | SPY | ETF | 568.55 | 568.67 | 567.92 | 568.66 | 48978.0 |
| 2024-09-23 05:30:00 | SPY | ETF | 568.72 | 569.16 | 568.52 | 569.06 | 22763.0 |
| 2024-09-23 06:00:00 | SPY | ETF | 569.18 | 569.26 | 568.95 | 569.2 | 12873.0 |
| 2024-09-23 06:30:00 | SPY | ETF | 569.1 | 569.25 | 568.85 | 568.85 | 6666.0 |
| 2024-09-23 07:00:00 | SPY | ETF | 568.83 | 568.98 | 568.26 | 568.5 | 125521.0 |
| 2024-09-23 07:30:00 | SPY | ETF | 568.63 | 569.15 | 568.48 | 569.07 | 49762.0 |
| 2024-09-23 08:00:00 | SPY | ETF | 569.04 | 569.94 | 567.0 | 569.1 | 50662.0 |
| 2024-09-23 08:30:00 | SPY | ETF | 569.01 | 569.41 | 568.8 | 569.25 | 77568.0 |
| 2024-09-23 09:00:00 | SPY | ETF | 569.31 | 569.62 | 568.99 | 569.38 | 123385.0 |
| 2024-09-23 09:30:00 | SPY | ETF | 569.34 | 569.42 | 568.25 | 568.8 | 3199423.0 |
| 2024-09-23 10:00:00 | SPY | ETF | 568.78 | 570.3325 | 568.4001 | 569.79 | 1745870.0 |
| 2024-09-23 10:30:00 | SPY | ETF | 569.8 | 570.09 | 568.86 | 569.85 | 1508065.0 |
| 2024-09-23 11:00:00 | SPY | ETF | 569.86 | 569.87 | 568.73 | 569.735 | 1232734.0 |
| 2024-09-23 11:30:00 | SPY | ETF | 569.74 | 570.15 | 569.39 | 569.5995 | 1053646.0 |
| 2024-09-23 12:00:00 | SPY | ETF | 569.59 | 569.65 | 568.36 | 568.94 | 1288260.0 |
| 2024-09-23 12:30:00 | SPY | ETF | 568.94 | 569.2 | 568.25 | 568.63 | 1094610.0 |
| 2024-09-23 13:00:00 | SPY | ETF | 568.6399 | 568.96 | 568.1 | 568.7799 | 1142674.0 |
| 2024-09-23 13:30:00 | SPY | ETF | 568.78 | 569.34 | 568.58 | 569.295 | 956135.0 |
| 2024-09-23 14:00:00 | SPY | ETF | 569.29 | 569.5 | 568.83 | 569.24 | 770409.0 |
| 2024-09-23 14:30:00 | SPY | ETF | 569.28 | 569.54 | 569.14 | 569.46 | 637313.0 |
| 2024-09-23 15:00:00 | SPY | ETF | 569.47 | 569.59 | 569.0524 | 569.51 | 1271152.0 |
| 2024-09-23 15:30:00 | SPY | ETF | 569.51 | 569.91 | 569.13 | 569.6 | 3921369.0 |
| 2024-09-23 16:00:00 | SPY | ETF | 569.61 | 569.79 | 569.32 | 569.33 | 5159630.0 |
| 2024-09-23 16:30:00 | SPY | ETF | 569.34 | 569.67 | 569.3299 | 569.52 | 214238.0 |
| 2024-09-23 17:00:00 | SPY | ETF | 569.52 | 569.54 | 569.41 | 569.4168 | 6128.0 |
| 2024-09-23 17:30:00 | SPY | ETF | 569.47 | 569.47 | 569.4 | 569.4392 | 7182.0 |
| 2024-09-23 18:00:00 | SPY | ETF | 569.35 | 569.35 | 569.04 | 569.22 | 9747.0 |
| 2024-09-23 18:30:00 | SPY | ETF | 569.16 | 569.16 | 569.07 | 569.07 | 1953.0 |
| 2024-09-23 19:00:00 | SPY | ETF | 569.05 | 569.1 | 569.0 | 569.04 | 3746.0 |
| 2024-09-23 19:30:00 | SPY | ETF | 569.25 | 569.37 | 569.09 | 569.3 | 4820.0 |
| 2024-09-23 04:00:00 | QQQ | ETF | 482.48 | 482.87 | 481.88 | 482.51 | 93489.0 |
| 2024-09-23 04:30:00 | QQQ | ETF | 482.6 | 482.6 | 481.61 | 482.21 | 15600.0 |
| 2024-09-23 05:00:00 | QQQ | ETF | 482.26 | 482.56 | 481.84 | 482.55 | 39257.0 |
| 2024-09-23 05:30:00 | QQQ | ETF | 482.47 | 483.15 | 482.47 | 483.02 | 49409.0 |
| 2024-09-23 06:00:00 | QQQ | ETF | 483.18 | 483.25 | 482.85 | 483.03 | 17363.0 |
| 2024-09-23 06:30:00 | QQQ | ETF | 483.01 | 483.31 | 482.82 | 482.82 | 9949.0 |
| 2024-09-23 07:00:00 | QQQ | ETF | 482.9 | 482.93 | 482.2 | 482.5 | 56136.0 |
| 2024-09-23 07:30:00 | QQQ | ETF | 482.57 | 483.11 | 482.4 | 483.0 | 35714.0 |
| 2024-09-23 08:00:00 | QQQ | ETF | 482.96 | 484.82 | 480.15 | 483.1 | 91583.0 |
| 2024-09-23 08:30:00 | QQQ | ETF | 483.12 | 483.37 | 482.78 | 483.1699 | 68088.0 |
| 2024-09-23 09:00:00 | QQQ | ETF | 483.2 | 483.45 | 482.48 | 482.93 | 126204.0 |
| 2024-09-23 09:30:00 | QQQ | ETF | 482.95 | 483.67 | 481.87 | 482.72 | 2479578.0 |
| 2024-09-23 10:00:00 | QQQ | ETF | 482.73 | 483.99 | 482.21 | 483.545 | 2173205.0 |
| 2024-09-23 10:30:00 | QQQ | ETF | 483.54 | 484.14 | 482.51 | 483.44 | 1758536.0 |
| 2024-09-23 11:00:00 | QQQ | ETF | 483.44 | 483.44 | 482.28 | 483.36 | 1074475.0 |
| 2024-09-23 11:30:00 | QQQ | ETF | 483.35 | 484.09 | 483.3 | 483.66 | 751372.0 |
| 2024-09-23 12:00:00 | QQQ | ETF | 483.64 | 483.67 | 482.08 | 482.7 | 929400.0 |
| 2024-09-23 12:30:00 | QQQ | ETF | 482.71 | 482.97 | 482.01 | 482.26 | 610999.0 |
> showing 50 of 33,732 rows — these rows as CSV