PREVIEW / etf_30min / 2004-05-06
file: by_date/etf_30min/2004/2004-05-06.parquet size: 36 KB rows: 1,195
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-05-06 08:00:00 | SPY | ETF | 112.17 | 112.18 | 112.02 | 112.04 | 42900.0 |
| 2004-05-06 08:30:00 | SPY | ETF | 112.04 | 112.14 | 111.99 | 112.11 | 30900.0 |
| 2004-05-06 09:00:00 | SPY | ETF | 112.12 | 112.14 | 111.98 | 112.01 | 52900.0 |
| 2004-05-06 09:30:00 | SPY | ETF | 111.98 | 112.23 | 111.93 | 112.06 | 6351300.0 |
| 2004-05-06 10:00:00 | SPY | ETF | 112.08 | 112.4 | 111.86 | 111.95 | 3858700.0 |
| 2004-05-06 10:30:00 | SPY | ETF | 111.94 | 111.97 | 111.43 | 111.55 | 4746100.0 |
| 2004-05-06 11:00:00 | SPY | ETF | 111.55 | 111.67 | 111.38 | 111.58 | 4700900.0 |
| 2004-05-06 11:30:00 | SPY | ETF | 111.59 | 111.68 | 111.48 | 111.52 | 2881700.0 |
| 2004-05-06 12:00:00 | SPY | ETF | 111.53 | 111.64 | 111.22 | 111.3 | 2053500.0 |
| 2004-05-06 12:30:00 | SPY | ETF | 111.29 | 111.35 | 111.0 | 111.3 | 4509400.0 |
| 2004-05-06 13:00:00 | SPY | ETF | 111.31 | 111.48 | 111.24 | 111.43 | 1940000.0 |
| 2004-05-06 13:30:00 | SPY | ETF | 111.43 | 111.49 | 111.23 | 111.42 | 1354800.0 |
| 2004-05-06 14:00:00 | SPY | ETF | 111.41 | 111.58 | 111.22 | 111.46 | 2654700.0 |
| 2004-05-06 14:30:00 | SPY | ETF | 111.46 | 111.65 | 111.34 | 111.6 | 2135900.0 |
| 2004-05-06 15:00:00 | SPY | ETF | 111.6 | 111.85 | 111.45 | 111.82 | 2779700.0 |
| 2004-05-06 15:30:00 | SPY | ETF | 111.84 | 112.09 | 111.8 | 111.85 | 5316400.0 |
| 2004-05-06 16:00:00 | SPY | ETF | 111.84 | 111.95 | 111.8 | 111.85 | 2092800.0 |
| 2004-05-06 16:30:00 | SPY | ETF | 111.85 | 111.86 | 111.72 | 111.84 | 156600.0 |
| 2004-05-06 17:00:00 | SPY | ETF | 111.77 | 111.83 | 111.72 | 111.79 | 34600.0 |
| 2004-05-06 17:30:00 | SPY | ETF | 111.8 | 111.8 | 111.73 | 111.78 | 11800.0 |
| 2004-05-06 18:00:00 | SPY | ETF | 111.81 | 111.81 | 111.81 | 111.81 | 400.0 |
| 2004-05-06 18:30:00 | SPY | ETF | 111.81 | 111.81 | 111.81 | 111.81 | 100.0 |
| 2004-05-06 19:00:00 | SPY | ETF | 111.87 | 111.87 | 111.87 | 111.87 | 2200.0 |
| 2004-05-06 19:30:00 | SPY | ETF | 111.86 | 111.86 | 111.86 | 111.86 | 2000.0 |
| 2004-05-06 08:00:00 | QQQ | ETF | 35.5 | 35.5 | 35.27 | 35.3 | 74500.0 |
| 2004-05-06 08:30:00 | QQQ | ETF | 35.3 | 35.32 | 35.24 | 35.27 | 279400.0 |
| 2004-05-06 09:00:00 | QQQ | ETF | 35.27 | 35.27 | 35.23 | 35.25 | 242500.0 |
| 2004-05-06 09:30:00 | QQQ | ETF | 35.239 | 35.35 | 35.17 | 35.326 | 10805500.0 |
| 2004-05-06 10:00:00 | QQQ | ETF | 35.33 | 35.44 | 35.225 | 35.24 | 8604000.0 |
| 2004-05-06 10:30:00 | QQQ | ETF | 35.254 | 35.27 | 34.93 | 35.04 | 16217700.0 |
| 2004-05-06 11:00:00 | QQQ | ETF | 35.04 | 35.08 | 34.92 | 35.047 | 9480900.0 |
| 2004-05-06 11:30:00 | QQQ | ETF | 35.05 | 35.11 | 35.01 | 35.036 | 4299500.0 |
| 2004-05-06 12:00:00 | QQQ | ETF | 35.04 | 35.1 | 34.95 | 34.97 | 4486400.0 |
| 2004-05-06 12:30:00 | QQQ | ETF | 34.972 | 35.01 | 34.85 | 34.95 | 7340700.0 |
| 2004-05-06 13:00:00 | QQQ | ETF | 34.95 | 35.03 | 34.94 | 35.01 | 3520200.0 |
| 2004-05-06 13:30:00 | QQQ | ETF | 35.01 | 35.05 | 34.95 | 35.023 | 3183400.0 |
| 2004-05-06 14:00:00 | QQQ | ETF | 35.024 | 35.11 | 34.93 | 35.07 | 5061100.0 |
| 2004-05-06 14:30:00 | QQQ | ETF | 35.07 | 35.16 | 35.0 | 35.123 | 4881700.0 |
| 2004-05-06 15:00:00 | QQQ | ETF | 35.123 | 35.25 | 35.08 | 35.23 | 5626600.0 |
| 2004-05-06 15:30:00 | QQQ | ETF | 35.23 | 35.36 | 35.19 | 35.233 | 11607800.0 |
| 2004-05-06 16:00:00 | QQQ | ETF | 35.24 | 35.29 | 35.17 | 35.26 | 2627500.0 |
| 2004-05-06 16:30:00 | QQQ | ETF | 35.27 | 35.27 | 35.23 | 35.26 | 264000.0 |
| 2004-05-06 17:00:00 | QQQ | ETF | 35.25 | 35.26 | 35.23 | 35.23 | 71500.0 |
| 2004-05-06 17:30:00 | QQQ | ETF | 35.24 | 35.25 | 35.22 | 35.22 | 40800.0 |
| 2004-05-06 18:00:00 | QQQ | ETF | 35.22 | 35.24 | 35.22 | 35.23 | 14700.0 |
| 2004-05-06 18:30:00 | QQQ | ETF | 35.23 | 35.23 | 35.21 | 35.23 | 10800.0 |
| 2004-05-06 19:00:00 | QQQ | ETF | 35.23 | 35.26 | 35.23 | 35.24 | 5900.0 |
| 2004-05-06 19:30:00 | QQQ | ETF | 35.25 | 35.26 | 35.21 | 35.25 | 24700.0 |
| 2004-05-06 08:00:00 | IWM | ETF | 56.5 | 56.5 | 56.5 | 56.5 | 200.0 |
| 2004-05-06 08:30:00 | IWM | ETF | 56.45 | 56.54 | 56.45 | 56.54 | 14800.0 |
> showing 50 of 1,195 rows — these rows as CSV