PREVIEW / etf_30min / 2004-04-05
file: by_date/etf_30min/2004/2004-04-05.parquet size: 36 KB rows: 1,263
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-04-05 08:00:00 | SPY | ETF | 114.43 | 114.55 | 114.43 | 114.54 | 20400.0 |
| 2004-04-05 08:30:00 | SPY | ETF | 114.45 | 114.5 | 114.43 | 114.46 | 16200.0 |
| 2004-04-05 09:00:00 | SPY | ETF | 114.41 | 114.49 | 114.41 | 114.46 | 13300.0 |
| 2004-04-05 09:30:00 | SPY | ETF | 114.46 | 114.74 | 114.45 | 114.58 | 3893200.0 |
| 2004-04-05 10:00:00 | SPY | ETF | 114.59 | 114.88 | 114.55 | 114.66 | 5965400.0 |
| 2004-04-05 10:30:00 | SPY | ETF | 114.66 | 114.71 | 114.47 | 114.48 | 3204200.0 |
| 2004-04-05 11:00:00 | SPY | ETF | 114.48 | 114.6 | 114.44 | 114.53 | 1774700.0 |
| 2004-04-05 11:30:00 | SPY | ETF | 114.53 | 114.63 | 114.5 | 114.57 | 703700.0 |
| 2004-04-05 12:00:00 | SPY | ETF | 114.56 | 114.69 | 114.51 | 114.66 | 810100.0 |
| 2004-04-05 12:30:00 | SPY | ETF | 114.66 | 114.81 | 114.64 | 114.73 | 2359900.0 |
| 2004-04-05 13:00:00 | SPY | ETF | 114.73 | 114.74 | 114.6 | 114.73 | 847900.0 |
| 2004-04-05 13:30:00 | SPY | ETF | 114.73 | 114.8 | 114.67 | 114.72 | 516700.0 |
| 2004-04-05 14:00:00 | SPY | ETF | 114.72 | 114.83 | 114.64 | 114.71 | 856100.0 |
| 2004-04-05 14:30:00 | SPY | ETF | 114.71 | 114.83 | 114.7 | 114.77 | 1153100.0 |
| 2004-04-05 15:00:00 | SPY | ETF | 114.77 | 115.11 | 114.74 | 115.11 | 2827100.0 |
| 2004-04-05 15:30:00 | SPY | ETF | 115.1 | 115.37 | 115.08 | 115.34 | 2777400.0 |
| 2004-04-05 16:00:00 | SPY | ETF | 115.33 | 115.38 | 115.2 | 115.23 | 1369600.0 |
| 2004-04-05 16:30:00 | SPY | ETF | 115.22 | 115.27 | 115.2 | 115.26 | 49900.0 |
| 2004-04-05 17:00:00 | SPY | ETF | 115.24 | 115.24 | 115.15 | 115.15 | 2700.0 |
| 2004-04-05 17:30:00 | SPY | ETF | 115.25 | 115.25 | 115.2 | 115.2 | 1100.0 |
| 2004-04-05 18:00:00 | SPY | ETF | 115.16 | 115.17 | 115.15 | 115.15 | 27400.0 |
| 2004-04-05 18:30:00 | SPY | ETF | 115.17 | 115.17 | 115.17 | 115.17 | 500.0 |
| 2004-04-05 19:30:00 | SPY | ETF | 115.21 | 115.21 | 115.21 | 115.21 | 300.0 |
| 2004-04-05 08:00:00 | QQQ | ETF | 37.04 | 37.12 | 37.02 | 37.06 | 142900.0 |
| 2004-04-05 08:30:00 | QQQ | ETF | 37.06 | 37.06 | 36.99 | 36.99 | 38800.0 |
| 2004-04-05 09:00:00 | QQQ | ETF | 36.98 | 37.01 | 36.97 | 37.01 | 46300.0 |
| 2004-04-05 09:30:00 | QQQ | ETF | 37.012 | 37.14 | 36.99 | 37.1 | 9008900.0 |
| 2004-04-05 10:00:00 | QQQ | ETF | 37.1 | 37.23 | 37.07 | 37.09 | 10211900.0 |
| 2004-04-05 10:30:00 | QQQ | ETF | 37.089 | 37.13 | 37.01 | 37.048 | 4618800.0 |
| 2004-04-05 11:00:00 | QQQ | ETF | 37.05 | 37.109 | 37.02 | 37.05 | 3105400.0 |
| 2004-04-05 11:30:00 | QQQ | ETF | 37.06 | 37.12 | 37.05 | 37.096 | 2122300.0 |
| 2004-04-05 12:00:00 | QQQ | ETF | 37.09 | 37.162 | 37.05 | 37.149 | 2655300.0 |
| 2004-04-05 12:30:00 | QQQ | ETF | 37.15 | 37.2 | 37.14 | 37.15 | 2148800.0 |
| 2004-04-05 13:00:00 | QQQ | ETF | 37.158 | 37.18 | 37.12 | 37.171 | 1827100.0 |
| 2004-04-05 13:30:00 | QQQ | ETF | 37.17 | 37.19 | 37.14 | 37.16 | 1398900.0 |
| 2004-04-05 14:00:00 | QQQ | ETF | 37.15 | 37.2 | 37.117 | 37.168 | 2691500.0 |
| 2004-04-05 14:30:00 | QQQ | ETF | 37.17 | 37.24 | 37.16 | 37.2 | 4645700.0 |
| 2004-04-05 15:00:00 | QQQ | ETF | 37.202 | 37.3 | 37.18 | 37.3 | 6099700.0 |
| 2004-04-05 15:30:00 | QQQ | ETF | 37.293 | 37.48 | 37.29 | 37.46 | 11238800.0 |
| 2004-04-05 16:00:00 | QQQ | ETF | 37.46 | 37.5 | 37.1669 | 37.44 | 3146200.0 |
| 2004-04-05 16:30:00 | QQQ | ETF | 37.44 | 37.44 | 37.41 | 37.43 | 152700.0 |
| 2004-04-05 17:00:00 | QQQ | ETF | 37.433 | 37.445 | 37.39 | 37.392 | 68100.0 |
| 2004-04-05 17:30:00 | QQQ | ETF | 37.4 | 37.41 | 37.36 | 37.4 | 14700.0 |
| 2004-04-05 18:00:00 | QQQ | ETF | 37.41 | 37.425 | 37.387 | 37.41 | 24200.0 |
| 2004-04-05 18:30:00 | QQQ | ETF | 37.4 | 37.43 | 37.39 | 37.39 | 8100.0 |
| 2004-04-05 19:00:00 | QQQ | ETF | 37.42 | 37.43 | 37.41 | 37.41 | 6400.0 |
| 2004-04-05 19:30:00 | QQQ | ETF | 37.41 | 37.44 | 37.4 | 37.43 | 4800.0 |
| 2004-04-05 09:00:00 | IWM | ETF | 60.165 | 60.175 | 60.145 | 60.145 | 7200.0 |
| 2004-04-05 09:30:00 | IWM | ETF | 60.235 | 60.34 | 60.105 | 60.2 | 846600.0 |
| 2004-04-05 10:00:00 | IWM | ETF | 60.195 | 60.39 | 60.16 | 60.175 | 1266200.0 |
> showing 50 of 1,263 rows — these rows as CSV