PREVIEW / etf_30min / 2003-01-29
file: by_date/etf_30min/2003/2003-01-29.parquet size: 23 KB rows: 651
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 |
|---|---|---|---|---|---|---|---|
| 2003-01-29 08:00:00 | SPY | ETF | 85.05 | 85.25 | 85.05 | 85.25 | 42300.0 |
| 2003-01-29 08:30:00 | SPY | ETF | 85.25 | 85.34 | 85.14 | 85.2 | 28800.0 |
| 2003-01-29 09:00:00 | SPY | ETF | 85.2 | 85.75 | 85.13 | 85.43 | 79500.0 |
| 2003-01-29 09:30:00 | SPY | ETF | 85.44 | 85.58 | 84.78 | 85.1 | 6211100.0 |
| 2003-01-29 10:00:00 | SPY | ETF | 85.09 | 85.8 | 84.99 | 85.51 | 4432300.0 |
| 2003-01-29 10:30:00 | SPY | ETF | 85.53 | 85.6 | 84.92 | 85.11 | 3032100.0 |
| 2003-01-29 11:00:00 | SPY | ETF | 85.11 | 85.45 | 85.06 | 85.42 | 1812300.0 |
| 2003-01-29 11:30:00 | SPY | ETF | 85.42 | 85.78 | 85.37 | 85.67 | 2876400.0 |
| 2003-01-29 12:00:00 | SPY | ETF | 85.66 | 85.9 | 85.43 | 85.88 | 1726700.0 |
| 2003-01-29 12:30:00 | SPY | ETF | 85.85 | 86.36 | 85.81 | 86.19 | 4173100.0 |
| 2003-01-29 13:00:00 | SPY | ETF | 86.19 | 86.6 | 86.15 | 86.3 | 3801700.0 |
| 2003-01-29 13:30:00 | SPY | ETF | 86.33 | 86.49 | 86.06 | 86.23 | 1962700.0 |
| 2003-01-29 14:00:00 | SPY | ETF | 86.25 | 86.47 | 85.92 | 86.12 | 2529200.0 |
| 2003-01-29 14:30:00 | SPY | ETF | 86.12 | 86.77 | 86.12 | 86.72 | 4998900.0 |
| 2003-01-29 15:00:00 | SPY | ETF | 86.7 | 87.12 | 86.54 | 87.1 | 2432200.0 |
| 2003-01-29 15:30:00 | SPY | ETF | 87.09 | 87.18 | 86.72 | 86.75 | 3494600.0 |
| 2003-01-29 16:00:00 | SPY | ETF | 86.78 | 86.8 | 86.42 | 86.49 | 1555400.0 |
| 2003-01-29 16:30:00 | SPY | ETF | 86.51 | 86.6 | 86.45 | 86.55 | 153200.0 |
| 2003-01-29 17:00:00 | SPY | ETF | 86.55 | 86.55 | 85.63 | 86.5 | 230600.0 |
| 2003-01-29 17:30:00 | SPY | ETF | 86.48 | 86.48 | 86.4 | 86.46 | 44200.0 |
| 2003-01-29 18:00:00 | SPY | ETF | 86.46 | 86.47 | 86.43 | 86.47 | 16600.0 |
| 2003-01-29 18:30:00 | SPY | ETF | 86.49 | 86.5 | 86.45 | 86.5 | 1700.0 |
| 2003-01-29 19:00:00 | SPY | ETF | 86.48 | 86.5 | 86.48 | 86.5 | 200.0 |
| 2003-01-29 19:30:00 | SPY | ETF | 86.55 | 86.55 | 86.51 | 86.51 | 400.0 |
| 2003-01-29 08:00:00 | QQQ | ETF | 24.62 | 24.7 | 24.62 | 24.67 | 50800.0 |
| 2003-01-29 08:30:00 | QQQ | ETF | 24.68 | 24.75 | 24.64 | 24.7 | 95200.0 |
| 2003-01-29 09:00:00 | QQQ | ETF | 24.7 | 24.75 | 24.67 | 24.74 | 36600.0 |
| 2003-01-29 09:30:00 | QQQ | ETF | 24.76 | 24.79 | 24.34 | 24.56 | 12694900.0 |
| 2003-01-29 10:00:00 | QQQ | ETF | 24.52 | 24.76 | 24.5 | 24.66 | 8792900.0 |
| 2003-01-29 10:30:00 | QQQ | ETF | 24.65 | 24.68 | 24.42 | 24.46 | 10646500.0 |
| 2003-01-29 11:00:00 | QQQ | ETF | 24.47 | 24.62 | 24.43 | 24.61 | 3111900.0 |
| 2003-01-29 11:30:00 | QQQ | ETF | 24.62 | 24.71 | 24.56 | 24.66 | 3697100.0 |
| 2003-01-29 12:00:00 | QQQ | ETF | 24.67 | 24.83 | 24.6 | 24.79 | 2851600.0 |
| 2003-01-29 12:30:00 | QQQ | ETF | 24.79 | 25.15 | 24.77 | 25.03 | 12496900.0 |
| 2003-01-29 13:00:00 | QQQ | ETF | 25.04 | 25.2 | 25.02 | 25.07 | 5800400.0 |
| 2003-01-29 13:30:00 | QQQ | ETF | 25.08 | 25.14 | 24.99 | 25.04 | 2421500.0 |
| 2003-01-29 14:00:00 | QQQ | ETF | 25.03 | 25.15 | 24.91 | 24.92 | 4086500.0 |
| 2003-01-29 14:30:00 | QQQ | ETF | 25.02 | 25.29 | 24.95 | 25.25 | 5742300.0 |
| 2003-01-29 15:00:00 | QQQ | ETF | 25.26 | 25.39 | 25.19 | 25.36 | 4943000.0 |
| 2003-01-29 15:30:00 | QQQ | ETF | 25.37 | 25.45 | 25.25 | 25.29 | 5945700.0 |
| 2003-01-29 16:00:00 | QQQ | ETF | 25.3 | 25.34 | 25.14 | 25.22 | 2221500.0 |
| 2003-01-29 16:30:00 | QQQ | ETF | 25.21 | 25.22 | 25.16 | 25.18 | 533100.0 |
| 2003-01-29 17:00:00 | QQQ | ETF | 25.18 | 25.19 | 25.11 | 25.15 | 318700.0 |
| 2003-01-29 17:30:00 | QQQ | ETF | 25.15 | 25.15 | 25.08 | 25.11 | 69300.0 |
| 2003-01-29 18:00:00 | QQQ | ETF | 25.11 | 25.15 | 25.1 | 25.13 | 39100.0 |
| 2003-01-29 18:30:00 | QQQ | ETF | 25.15 | 25.16 | 25.14 | 25.15 | 2200.0 |
| 2003-01-29 19:00:00 | QQQ | ETF | 25.15 | 25.15 | 25.13 | 25.13 | 8300.0 |
| 2003-01-29 19:30:00 | QQQ | ETF | 25.11 | 25.14 | 25.11 | 25.14 | 3800.0 |
| 2003-01-29 09:30:00 | IWM | ETF | 36.77 | 36.79 | 36.63 | 36.74 | 534200.0 |
| 2003-01-29 10:00:00 | IWM | ETF | 36.705 | 36.86 | 36.665 | 36.74 | 214600.0 |
> showing 50 of 651 rows — these rows as CSV