PREVIEW / etf_30min / 2004-11-16
file: by_date/etf_30min/2004/2004-11-16.parquet size: 37 KB rows: 1,349
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-16 08:00:00 | SPY | ETF | 118.53 | 118.53 | 118.41 | 118.41 | 33300.0 |
| 2004-11-16 08:30:00 | SPY | ETF | 118.36 | 118.38 | 118.27 | 118.38 | 215900.0 |
| 2004-11-16 09:00:00 | SPY | ETF | 118.4 | 118.4 | 118.34 | 118.37 | 51000.0 |
| 2004-11-16 09:30:00 | SPY | ETF | 118.36 | 118.41 | 118.1 | 118.11 | 4974500.0 |
| 2004-11-16 10:00:00 | SPY | ETF | 118.12 | 118.16 | 117.88 | 118.03 | 6598300.0 |
| 2004-11-16 10:30:00 | SPY | ETF | 118.04 | 118.12 | 117.86 | 118.05 | 4276800.0 |
| 2004-11-16 11:00:00 | SPY | ETF | 118.05 | 118.13 | 117.97 | 118.06 | 2461000.0 |
| 2004-11-16 11:30:00 | SPY | ETF | 118.06 | 118.06 | 117.85 | 117.91 | 1182900.0 |
| 2004-11-16 12:00:00 | SPY | ETF | 117.92 | 118.05 | 117.83 | 117.91 | 2145700.0 |
| 2004-11-16 12:30:00 | SPY | ETF | 117.9 | 118.0 | 117.85 | 117.92 | 1054100.0 |
| 2004-11-16 13:00:00 | SPY | ETF | 117.92 | 118.14 | 117.87 | 118.06 | 2506700.0 |
| 2004-11-16 13:30:00 | SPY | ETF | 118.06 | 118.16 | 117.92 | 117.95 | 2226000.0 |
| 2004-11-16 14:00:00 | SPY | ETF | 117.95 | 118.03 | 117.78 | 117.97 | 1644000.0 |
| 2004-11-16 14:30:00 | SPY | ETF | 117.96 | 117.98 | 117.77 | 117.9 | 1363400.0 |
| 2004-11-16 15:00:00 | SPY | ETF | 117.91 | 118.11 | 117.87 | 118.01 | 1337300.0 |
| 2004-11-16 15:30:00 | SPY | ETF | 118.0 | 118.08 | 117.73 | 117.76 | 4837200.0 |
| 2004-11-16 16:00:00 | SPY | ETF | 117.76 | 118.02 | 117.72 | 117.97 | 1444600.0 |
| 2004-11-16 16:30:00 | SPY | ETF | 117.97 | 118.03 | 117.86 | 118.01 | 487200.0 |
| 2004-11-16 17:00:00 | SPY | ETF | 118.02 | 118.02 | 117.95 | 117.95 | 14600.0 |
| 2004-11-16 17:30:00 | SPY | ETF | 117.88 | 118.02 | 117.88 | 118.0 | 102600.0 |
| 2004-11-16 18:00:00 | SPY | ETF | 117.98 | 118.02 | 117.98 | 118.0 | 2000.0 |
| 2004-11-16 18:30:00 | SPY | ETF | 117.98 | 118.0 | 117.98 | 118.0 | 1100.0 |
| 2004-11-16 19:30:00 | SPY | ETF | 117.97 | 117.98 | 117.97 | 117.98 | 1100.0 |
| 2004-11-16 08:00:00 | QQQ | ETF | 38.74 | 38.76 | 38.7 | 38.72 | 103200.0 |
| 2004-11-16 08:30:00 | QQQ | ETF | 38.72 | 38.72 | 38.63 | 38.66 | 296600.0 |
| 2004-11-16 09:00:00 | QQQ | ETF | 38.67 | 38.67 | 38.63 | 38.66 | 171800.0 |
| 2004-11-16 09:30:00 | QQQ | ETF | 38.66 | 38.68 | 38.515 | 38.519 | 11149500.0 |
| 2004-11-16 10:00:00 | QQQ | ETF | 38.52 | 38.53 | 38.32 | 38.44 | 14272500.0 |
| 2004-11-16 10:30:00 | QQQ | ETF | 38.43 | 38.49 | 38.35 | 38.47 | 8324600.0 |
| 2004-11-16 11:00:00 | QQQ | ETF | 38.45 | 38.5 | 38.44 | 38.47 | 6937800.0 |
| 2004-11-16 11:30:00 | QQQ | ETF | 38.479 | 38.48 | 38.39 | 38.43 | 3816600.0 |
| 2004-11-16 12:00:00 | QQQ | ETF | 38.43 | 38.5 | 38.4 | 38.45 | 4252600.0 |
| 2004-11-16 12:30:00 | QQQ | ETF | 38.45 | 38.5 | 38.45 | 38.49 | 2394700.0 |
| 2004-11-16 13:00:00 | QQQ | ETF | 38.49 | 38.59 | 38.48 | 38.58 | 5780900.0 |
| 2004-11-16 13:30:00 | QQQ | ETF | 38.57 | 38.68 | 38.56 | 38.605 | 7416800.0 |
| 2004-11-16 14:00:00 | QQQ | ETF | 38.608 | 38.65 | 38.51 | 38.6 | 6037400.0 |
| 2004-11-16 14:30:00 | QQQ | ETF | 38.58 | 38.6 | 38.46 | 38.502 | 6287600.0 |
| 2004-11-16 15:00:00 | QQQ | ETF | 38.504 | 38.65 | 38.49 | 38.56 | 5227700.0 |
| 2004-11-16 15:30:00 | QQQ | ETF | 38.56 | 38.62 | 38.46 | 38.51 | 8640000.0 |
| 2004-11-16 16:00:00 | QQQ | ETF | 38.51 | 38.67 | 38.51 | 38.65 | 2205400.0 |
| 2004-11-16 16:30:00 | QQQ | ETF | 38.65 | 38.73 | 38.64 | 38.728 | 483400.0 |
| 2004-11-16 17:00:00 | QQQ | ETF | 38.721 | 38.729 | 38.7 | 38.72 | 135100.0 |
| 2004-11-16 17:30:00 | QQQ | ETF | 38.72 | 38.74 | 38.69 | 38.74 | 82900.0 |
| 2004-11-16 18:00:00 | QQQ | ETF | 38.73 | 38.74 | 38.7 | 38.7 | 80100.0 |
| 2004-11-16 18:30:00 | QQQ | ETF | 38.7 | 38.71 | 38.7 | 38.71 | 20900.0 |
| 2004-11-16 19:00:00 | QQQ | ETF | 38.72 | 38.72 | 38.7 | 38.7 | 2600.0 |
| 2004-11-16 19:30:00 | QQQ | ETF | 38.71 | 38.74 | 38.71 | 38.74 | 8500.0 |
| 2004-11-16 08:00:00 | IWM | ETF | 62.13 | 62.16 | 62.11 | 62.11 | 2600.0 |
| 2004-11-16 08:30:00 | IWM | ETF | 62.02 | 62.05 | 62.01 | 62.05 | 8600.0 |
| 2004-11-16 09:00:00 | IWM | ETF | 62.05 | 62.05 | 62.02 | 62.05 | 3600.0 |
> showing 50 of 1,349 rows — these rows as CSV