PREVIEW / etf_30min / 2004-06-28
file: by_date/etf_30min/2004/2004-06-28.parquet size: 36 KB rows: 1,194
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-28 08:00:00 | SPY | ETF | 114.78 | 114.78 | 114.65 | 114.65 | 80800.0 |
| 2004-06-28 08:30:00 | SPY | ETF | 114.63 | 114.63 | 114.46 | 114.59 | 149800.0 |
| 2004-06-28 09:00:00 | SPY | ETF | 114.6 | 114.62 | 114.51 | 114.51 | 28300.0 |
| 2004-06-28 09:30:00 | SPY | ETF | 114.52 | 114.56 | 114.29 | 114.39 | 5495300.0 |
| 2004-06-28 10:00:00 | SPY | ETF | 114.38 | 114.61 | 114.33 | 114.46 | 4078600.0 |
| 2004-06-28 10:30:00 | SPY | ETF | 114.46 | 114.49 | 114.31 | 114.4 | 1870100.0 |
| 2004-06-28 11:00:00 | SPY | ETF | 114.41 | 114.4285 | 114.26 | 114.41 | 1423100.0 |
| 2004-06-28 11:30:00 | SPY | ETF | 114.39 | 114.49 | 114.25 | 114.44 | 1290800.0 |
| 2004-06-28 12:00:00 | SPY | ETF | 114.44 | 114.59 | 114.36 | 114.51 | 920900.0 |
| 2004-06-28 12:30:00 | SPY | ETF | 114.51 | 114.52 | 114.4 | 114.41 | 744700.0 |
| 2004-06-28 13:00:00 | SPY | ETF | 114.43 | 114.57 | 114.41 | 114.49 | 543300.0 |
| 2004-06-28 13:30:00 | SPY | ETF | 114.49 | 114.5 | 114.25 | 114.29 | 1440600.0 |
| 2004-06-28 14:00:00 | SPY | ETF | 114.29 | 114.37 | 113.76 | 113.8 | 4534800.0 |
| 2004-06-28 14:30:00 | SPY | ETF | 113.85 | 113.92 | 113.5 | 113.66 | 7546000.0 |
| 2004-06-28 15:00:00 | SPY | ETF | 113.65 | 113.68 | 113.43 | 113.6 | 2520700.0 |
| 2004-06-28 15:30:00 | SPY | ETF | 113.64 | 113.8 | 113.5 | 113.68 | 4111500.0 |
| 2004-06-28 16:00:00 | SPY | ETF | 113.68 | 113.72 | 113.4 | 113.56 | 1546300.0 |
| 2004-06-28 16:30:00 | SPY | ETF | 113.5 | 113.52 | 113.31 | 113.32 | 427700.0 |
| 2004-06-28 17:00:00 | SPY | ETF | 113.32 | 113.32 | 113.15 | 113.16 | 384600.0 |
| 2004-06-28 17:30:00 | SPY | ETF | 113.17 | 113.18 | 113.12 | 113.18 | 66300.0 |
| 2004-06-28 18:00:00 | SPY | ETF | 113.17 | 113.24 | 113.12 | 113.24 | 44500.0 |
| 2004-06-28 18:30:00 | SPY | ETF | 113.19 | 113.29 | 113.17 | 113.29 | 24500.0 |
| 2004-06-28 19:00:00 | SPY | ETF | 113.29 | 113.29 | 113.29 | 113.29 | 500.0 |
| 2004-06-28 19:30:00 | SPY | ETF | 113.29 | 113.31 | 113.29 | 113.3 | 3200.0 |
| 2004-06-28 08:00:00 | QQQ | ETF | 37.55 | 37.62 | 37.55 | 37.55 | 117900.0 |
| 2004-06-28 08:30:00 | QQQ | ETF | 37.55 | 37.55 | 37.48 | 37.55 | 512200.0 |
| 2004-06-28 09:00:00 | QQQ | ETF | 37.55 | 37.55 | 37.45 | 37.46 | 139400.0 |
| 2004-06-28 09:30:00 | QQQ | ETF | 37.49 | 37.52 | 37.37 | 37.41 | 12161100.0 |
| 2004-06-28 10:00:00 | QQQ | ETF | 37.41 | 37.52 | 37.356 | 37.39 | 8231900.0 |
| 2004-06-28 10:30:00 | QQQ | ETF | 37.39 | 37.48 | 37.35 | 37.444 | 5722400.0 |
| 2004-06-28 11:00:00 | QQQ | ETF | 37.44 | 37.46 | 37.37 | 37.41 | 2871400.0 |
| 2004-06-28 11:30:00 | QQQ | ETF | 37.41 | 37.46 | 37.32 | 37.432 | 4505200.0 |
| 2004-06-28 12:00:00 | QQQ | ETF | 37.43 | 37.5 | 37.4 | 37.47 | 2511800.0 |
| 2004-06-28 12:30:00 | QQQ | ETF | 37.471 | 37.48 | 37.41 | 37.42 | 2774500.0 |
| 2004-06-28 13:00:00 | QQQ | ETF | 37.42 | 37.519 | 37.41 | 37.48 | 2386100.0 |
| 2004-06-28 13:30:00 | QQQ | ETF | 37.47 | 37.48 | 37.36 | 37.37 | 4058800.0 |
| 2004-06-28 14:00:00 | QQQ | ETF | 37.378 | 37.39 | 37.1 | 37.14 | 13681900.0 |
| 2004-06-28 14:30:00 | QQQ | ETF | 37.13 | 37.19 | 37.01 | 37.034 | 9394300.0 |
| 2004-06-28 15:00:00 | QQQ | ETF | 37.04 | 37.063 | 36.9 | 37.063 | 12049700.0 |
| 2004-06-28 15:30:00 | QQQ | ETF | 37.063 | 37.13 | 36.98 | 37.11 | 9328600.0 |
| 2004-06-28 16:00:00 | QQQ | ETF | 37.1 | 37.13 | 37.0 | 37.011 | 2158000.0 |
| 2004-06-28 16:30:00 | QQQ | ETF | 37.01 | 37.04 | 37.0 | 37.0 | 211200.0 |
| 2004-06-28 17:00:00 | QQQ | ETF | 37.0 | 37.02 | 36.94 | 36.94 | 93900.0 |
| 2004-06-28 17:30:00 | QQQ | ETF | 36.98 | 36.98 | 36.84 | 36.93 | 133700.0 |
| 2004-06-28 18:00:00 | QQQ | ETF | 36.92 | 36.95 | 36.92 | 36.94 | 52400.0 |
| 2004-06-28 18:30:00 | QQQ | ETF | 36.95 | 36.96 | 36.94 | 36.96 | 9700.0 |
| 2004-06-28 19:00:00 | QQQ | ETF | 36.94 | 36.94 | 36.92 | 36.92 | 3700.0 |
| 2004-06-28 08:00:00 | IWM | ETF | 58.56 | 58.56 | 58.555 | 58.555 | 14000.0 |
| 2004-06-28 08:30:00 | IWM | ETF | 58.52 | 58.52 | 58.485 | 58.485 | 2400.0 |
| 2004-06-28 09:00:00 | IWM | ETF | 58.535 | 58.555 | 58.34 | 58.375 | 134400.0 |
> showing 50 of 1,194 rows — these rows as CSV