PREVIEW / etf_30min / 2024-05-30
file: by_date/etf_30min/2024/2024-05-30.parquet size: 794 KB rows: 31,941
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-05-30 04:00:00 | SPY | ETF | 523.5 | 523.63 | 523.31 | 523.48 | 8315.0 |
| 2024-05-30 04:30:00 | SPY | ETF | 523.55 | 523.89 | 523.55 | 523.89 | 5009.0 |
| 2024-05-30 05:00:00 | SPY | ETF | 523.89 | 523.95 | 523.7 | 523.7 | 2332.0 |
| 2024-05-30 05:30:00 | SPY | ETF | 523.67 | 523.75 | 523.55 | 523.68 | 1849.0 |
| 2024-05-30 06:00:00 | SPY | ETF | 523.6 | 523.66 | 523.36 | 523.62 | 3540.0 |
| 2024-05-30 06:30:00 | SPY | ETF | 523.65 | 524.07 | 523.65 | 524.03 | 38738.0 |
| 2024-05-30 07:00:00 | SPY | ETF | 523.96 | 524.05 | 523.8 | 524.02 | 42498.0 |
| 2024-05-30 07:30:00 | SPY | ETF | 524.03 | 524.18 | 523.81 | 523.88 | 101277.0 |
| 2024-05-30 08:00:00 | SPY | ETF | 523.91 | 524.15 | 522.7 | 524.02 | 289036.0 |
| 2024-05-30 08:30:00 | SPY | ETF | 524.04 | 524.8 | 524.04 | 524.34 | 276115.0 |
| 2024-05-30 09:00:00 | SPY | ETF | 524.329 | 524.55 | 524.08 | 524.39 | 161507.0 |
| 2024-05-30 09:30:00 | SPY | ETF | 524.52 | 524.99 | 523.92 | 524.59 | 3080785.0 |
| 2024-05-30 10:00:00 | SPY | ETF | 524.61 | 524.82 | 523.37 | 524.0 | 2331803.0 |
| 2024-05-30 10:30:00 | SPY | ETF | 523.98 | 524.08 | 523.06 | 523.41 | 1627030.0 |
| 2024-05-30 11:00:00 | SPY | ETF | 523.38 | 524.0 | 522.89 | 523.95 | 1407200.0 |
| 2024-05-30 11:30:00 | SPY | ETF | 523.945 | 524.38 | 523.69 | 523.7 | 1406262.0 |
| 2024-05-30 12:00:00 | SPY | ETF | 523.715 | 524.54 | 523.695 | 524.04 | 1091485.0 |
| 2024-05-30 12:30:00 | SPY | ETF | 524.04 | 524.715 | 523.94 | 524.669 | 1030765.0 |
| 2024-05-30 13:00:00 | SPY | ETF | 524.67 | 525.14 | 524.5099 | 524.965 | 1351368.0 |
| 2024-05-30 13:30:00 | SPY | ETF | 524.96 | 525.2 | 524.535 | 524.78 | 943359.0 |
| 2024-05-30 14:00:00 | SPY | ETF | 524.78 | 524.83 | 523.6 | 524.19 | 1448657.0 |
| 2024-05-30 14:30:00 | SPY | ETF | 524.18 | 524.45 | 523.75 | 524.07 | 1409094.0 |
| 2024-05-30 15:00:00 | SPY | ETF | 524.07 | 524.22 | 522.85 | 523.3805 | 2366256.0 |
| 2024-05-30 15:30:00 | SPY | ETF | 523.38 | 523.57 | 521.33 | 522.63 | 8154541.0 |
| 2024-05-30 16:00:00 | SPY | ETF | 522.64 | 522.6773 | 521.78 | 522.45 | 3307334.0 |
| 2024-05-30 16:30:00 | SPY | ETF | 522.51 | 522.55 | 522.22 | 522.54 | 244125.0 |
| 2024-05-30 17:00:00 | SPY | ETF | 522.44 | 522.6 | 521.99 | 522.31 | 152702.0 |
| 2024-05-30 17:30:00 | SPY | ETF | 522.31 | 522.4 | 522.02 | 522.31 | 43746.0 |
| 2024-05-30 18:00:00 | SPY | ETF | 522.46 | 522.53 | 521.9 | 521.99 | 81250.0 |
| 2024-05-30 18:30:00 | SPY | ETF | 522.0 | 522.27 | 522.0 | 522.1 | 15983.0 |
| 2024-05-30 19:00:00 | SPY | ETF | 522.07 | 522.11 | 521.9 | 521.97 | 11159.0 |
| 2024-05-30 19:30:00 | SPY | ETF | 522.02 | 522.15 | 521.79 | 521.82 | 18929.0 |
| 2024-05-30 04:00:00 | QQQ | ETF | 453.93 | 454.34 | 453.93 | 454.25 | 9830.0 |
| 2024-05-30 04:30:00 | QQQ | ETF | 454.26 | 454.89 | 454.26 | 454.85 | 12285.0 |
| 2024-05-30 05:00:00 | QQQ | ETF | 454.82 | 454.85 | 454.56 | 454.66 | 3368.0 |
| 2024-05-30 05:30:00 | QQQ | ETF | 454.58 | 454.77 | 454.45 | 454.68 | 8479.0 |
| 2024-05-30 06:00:00 | QQQ | ETF | 454.62 | 454.7 | 454.34 | 454.6 | 10209.0 |
| 2024-05-30 06:30:00 | QQQ | ETF | 454.59 | 455.3 | 454.56 | 455.3 | 101122.0 |
| 2024-05-30 07:00:00 | QQQ | ETF | 455.25 | 455.25 | 454.95 | 455.18 | 67938.0 |
| 2024-05-30 07:30:00 | QQQ | ETF | 455.24 | 455.429 | 454.98 | 455.04 | 32599.0 |
| 2024-05-30 08:00:00 | QQQ | ETF | 455.2502 | 455.39 | 453.0 | 455.21 | 72242.0 |
| 2024-05-30 08:30:00 | QQQ | ETF | 455.1797 | 456.03 | 455.1797 | 455.51 | 198521.0 |
| 2024-05-30 09:00:00 | QQQ | ETF | 455.43 | 455.6992 | 455.06 | 455.48 | 129690.0 |
| 2024-05-30 09:30:00 | QQQ | ETF | 455.51 | 455.64 | 453.9016 | 454.85 | 2446848.0 |
| 2024-05-30 10:00:00 | QQQ | ETF | 454.92 | 455.2199 | 453.56 | 454.3917 | 2116149.0 |
| 2024-05-30 10:30:00 | QQQ | ETF | 454.35 | 454.5 | 452.62 | 452.9401 | 1601980.0 |
| 2024-05-30 11:00:00 | QQQ | ETF | 452.92 | 453.3675 | 452.1 | 453.3 | 1067135.0 |
| 2024-05-30 11:30:00 | QQQ | ETF | 453.29 | 453.88 | 453.14 | 453.1602 | 928147.0 |
| 2024-05-30 12:00:00 | QQQ | ETF | 453.18 | 454.07 | 453.18 | 453.59 | 627571.0 |
| 2024-05-30 12:30:00 | QQQ | ETF | 453.6099 | 454.03 | 453.49 | 453.84 | 542237.0 |
> showing 50 of 31,941 rows — these rows as CSV