PREVIEW / etf_30min / 2004-06-14
file: by_date/etf_30min/2004/2004-06-14.parquet size: 35 KB rows: 1,188
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-06-14 08:00:00 | SPY | ETF | 113.77 | 113.77 | 113.72 | 113.76 | 17300.0 |
| 2004-06-14 08:30:00 | SPY | ETF | 113.78 | 113.81 | 113.74 | 113.81 | 16600.0 |
| 2004-06-14 09:00:00 | SPY | ETF | 113.81 | 113.83 | 113.73 | 113.82 | 47800.0 |
| 2004-06-14 09:30:00 | SPY | ETF | 113.82 | 113.84 | 113.51 | 113.6 | 4432300.0 |
| 2004-06-14 10:00:00 | SPY | ETF | 113.61 | 113.67 | 113.46 | 113.61 | 2483200.0 |
| 2004-06-14 10:30:00 | SPY | ETF | 113.61 | 113.64 | 113.38 | 113.39 | 2124100.0 |
| 2004-06-14 11:00:00 | SPY | ETF | 113.39 | 113.46 | 113.3 | 113.39 | 1412900.0 |
| 2004-06-14 11:30:00 | SPY | ETF | 113.39 | 113.44 | 113.3 | 113.34 | 1939900.0 |
| 2004-06-14 12:00:00 | SPY | ETF | 113.31 | 113.35 | 113.13 | 113.25 | 2154500.0 |
| 2004-06-14 12:30:00 | SPY | ETF | 113.25 | 113.38 | 113.17 | 113.36 | 1260500.0 |
| 2004-06-14 13:00:00 | SPY | ETF | 113.36 | 113.45 | 113.1 | 113.15 | 1363700.0 |
| 2004-06-14 13:30:00 | SPY | ETF | 113.14 | 113.28 | 113.1 | 113.26 | 1411400.0 |
| 2004-06-14 14:00:00 | SPY | ETF | 113.26 | 113.35 | 113.2 | 113.2216 | 2267100.0 |
| 2004-06-14 14:30:00 | SPY | ETF | 113.22 | 113.23 | 112.97 | 113.01 | 2068200.0 |
| 2004-06-14 15:00:00 | SPY | ETF | 113.01 | 113.13 | 112.87 | 113.07 | 2248300.0 |
| 2004-06-14 15:30:00 | SPY | ETF | 113.06 | 113.26 | 113.03 | 113.19 | 3941000.0 |
| 2004-06-14 16:00:00 | SPY | ETF | 113.17 | 113.28 | 113.1 | 113.23 | 1122500.0 |
| 2004-06-14 16:30:00 | SPY | ETF | 113.22 | 113.31 | 113.22 | 113.27 | 534800.0 |
| 2004-06-14 17:00:00 | SPY | ETF | 113.3 | 113.3 | 113.27 | 113.3 | 6000.0 |
| 2004-06-14 17:30:00 | SPY | ETF | 113.22 | 113.25 | 113.22 | 113.25 | 300.0 |
| 2004-06-14 18:00:00 | SPY | ETF | 113.33 | 113.36 | 113.33 | 113.36 | 1400.0 |
| 2004-06-14 18:30:00 | SPY | ETF | 113.36 | 113.37 | 113.36 | 113.37 | 1800.0 |
| 2004-06-14 19:00:00 | SPY | ETF | 113.35 | 113.35 | 113.35 | 113.35 | 1000.0 |
| 2004-06-14 19:30:00 | SPY | ETF | 113.35 | 113.35 | 113.3 | 113.3 | 1400.0 |
| 2004-06-14 08:00:00 | QQQ | ETF | 36.55 | 36.56 | 36.54 | 36.56 | 56500.0 |
| 2004-06-14 08:30:00 | QQQ | ETF | 36.55 | 36.58 | 36.53 | 36.53 | 82300.0 |
| 2004-06-14 09:00:00 | QQQ | ETF | 36.55 | 36.6 | 36.53 | 36.59 | 86500.0 |
| 2004-06-14 09:30:00 | QQQ | ETF | 36.61 | 36.61 | 36.44 | 36.494 | 8036100.0 |
| 2004-06-14 10:00:00 | QQQ | ETF | 36.49 | 36.56 | 36.42 | 36.543 | 6145400.0 |
| 2004-06-14 10:30:00 | QQQ | ETF | 36.55 | 36.556 | 36.348 | 36.35 | 6368300.0 |
| 2004-06-14 11:00:00 | QQQ | ETF | 36.37 | 36.384 | 36.3 | 36.34 | 5247700.0 |
| 2004-06-14 11:30:00 | QQQ | ETF | 36.33 | 36.38 | 36.3 | 36.35 | 3038400.0 |
| 2004-06-14 12:00:00 | QQQ | ETF | 36.331 | 36.36 | 36.21 | 36.251 | 5421900.0 |
| 2004-06-14 12:30:00 | QQQ | ETF | 36.253 | 36.33 | 36.22 | 36.3 | 3941200.0 |
| 2004-06-14 13:00:00 | QQQ | ETF | 36.3 | 36.338 | 36.21 | 36.21 | 3028100.0 |
| 2004-06-14 13:30:00 | QQQ | ETF | 36.217 | 36.32 | 36.21 | 36.271 | 3024300.0 |
| 2004-06-14 14:00:00 | QQQ | ETF | 36.27 | 36.33 | 36.24 | 36.255 | 2910300.0 |
| 2004-06-14 14:30:00 | QQQ | ETF | 36.25 | 36.26 | 36.12 | 36.16 | 5251300.0 |
| 2004-06-14 15:00:00 | QQQ | ETF | 36.156 | 36.25 | 36.1 | 36.209 | 6088000.0 |
| 2004-06-14 15:30:00 | QQQ | ETF | 36.2 | 36.3 | 36.18 | 36.24 | 10374000.0 |
| 2004-06-14 16:00:00 | QQQ | ETF | 36.25 | 36.8267 | 36.23 | 36.29 | 5575400.0 |
| 2004-06-14 16:30:00 | QQQ | ETF | 36.3 | 36.37 | 36.28 | 36.347 | 2852200.0 |
| 2004-06-14 17:00:00 | QQQ | ETF | 36.35 | 36.36 | 36.31 | 36.34 | 129700.0 |
| 2004-06-14 17:30:00 | QQQ | ETF | 36.22 | 36.36 | 36.22 | 36.35 | 356900.0 |
| 2004-06-14 18:00:00 | QQQ | ETF | 36.329 | 36.34 | 36.313 | 36.33 | 41800.0 |
| 2004-06-14 18:30:00 | QQQ | ETF | 36.33 | 36.35 | 36.32 | 36.32 | 6400.0 |
| 2004-06-14 19:30:00 | QQQ | ETF | 36.32 | 36.35 | 36.32 | 36.35 | 2800.0 |
| 2004-06-14 08:30:00 | IWM | ETF | 56.49 | 56.49 | 56.49 | 56.49 | 1000.0 |
| 2004-06-14 09:00:00 | IWM | ETF | 56.48 | 56.48 | 56.435 | 56.465 | 7800.0 |
| 2004-06-14 09:30:00 | IWM | ETF | 56.46 | 56.55 | 56.185 | 56.215 | 1389600.0 |
> showing 50 of 1,188 rows — these rows as CSV