PREVIEW / etf_30min / 2004-11-18
file: by_date/etf_30min/2004/2004-11-18.parquet size: 38 KB rows: 1,334
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-18 08:00:00 | SPY | ETF | 118.48 | 118.64 | 118.44 | 118.64 | 60400.0 |
| 2004-11-18 08:30:00 | SPY | ETF | 118.6 | 118.6 | 118.55 | 118.56 | 4800.0 |
| 2004-11-18 09:00:00 | SPY | ETF | 118.56 | 118.56 | 118.5 | 118.54 | 22100.0 |
| 2004-11-18 09:30:00 | SPY | ETF | 118.53 | 118.68 | 118.38 | 118.43 | 3528600.0 |
| 2004-11-18 10:00:00 | SPY | ETF | 118.43 | 118.46 | 118.23 | 118.34 | 3910100.0 |
| 2004-11-18 10:30:00 | SPY | ETF | 118.34 | 118.72 | 118.28 | 118.62 | 3170100.0 |
| 2004-11-18 11:00:00 | SPY | ETF | 118.63 | 118.66 | 118.52 | 118.55 | 1758500.0 |
| 2004-11-18 11:30:00 | SPY | ETF | 118.56 | 118.68 | 118.52 | 118.57 | 1543200.0 |
| 2004-11-18 12:00:00 | SPY | ETF | 118.57 | 118.67 | 118.44 | 118.59 | 2091500.0 |
| 2004-11-18 12:30:00 | SPY | ETF | 118.59 | 118.6 | 118.44 | 118.44 | 1777500.0 |
| 2004-11-18 13:00:00 | SPY | ETF | 118.45 | 118.48 | 118.36 | 118.46 | 1422100.0 |
| 2004-11-18 13:30:00 | SPY | ETF | 118.46 | 118.6 | 118.35 | 118.6 | 1370600.0 |
| 2004-11-18 14:00:00 | SPY | ETF | 118.6 | 118.6 | 118.36 | 118.45 | 1283700.0 |
| 2004-11-18 14:30:00 | SPY | ETF | 118.44 | 118.77 | 118.38 | 118.72 | 2198100.0 |
| 2004-11-18 15:00:00 | SPY | ETF | 118.71 | 118.8 | 118.54 | 118.65 | 3274400.0 |
| 2004-11-18 15:30:00 | SPY | ETF | 118.63 | 118.77 | 118.61 | 118.68 | 2126700.0 |
| 2004-11-18 16:00:00 | SPY | ETF | 118.68 | 118.75 | 118.62 | 118.71 | 1160200.0 |
| 2004-11-18 16:30:00 | SPY | ETF | 118.71 | 118.75 | 118.7 | 118.73 | 41400.0 |
| 2004-11-18 17:00:00 | SPY | ETF | 118.73 | 118.77 | 118.72 | 118.72 | 58400.0 |
| 2004-11-18 17:30:00 | SPY | ETF | 118.73 | 118.73 | 118.69 | 118.69 | 300.0 |
| 2004-11-18 18:00:00 | SPY | ETF | 118.7 | 118.7 | 118.62 | 118.62 | 15800.0 |
| 2004-11-18 08:00:00 | QQQ | ETF | 38.99 | 38.99 | 38.89 | 38.93 | 136400.0 |
| 2004-11-18 08:30:00 | QQQ | ETF | 38.93 | 38.97 | 38.93 | 38.97 | 186900.0 |
| 2004-11-18 09:00:00 | QQQ | ETF | 38.97 | 38.99 | 38.94 | 38.98 | 167100.0 |
| 2004-11-18 09:30:00 | QQQ | ETF | 38.98 | 39.12 | 38.94 | 38.98 | 13052200.0 |
| 2004-11-18 10:00:00 | QQQ | ETF | 38.98 | 39.05 | 38.887 | 38.97 | 9258000.0 |
| 2004-11-18 10:30:00 | QQQ | ETF | 38.97 | 39.22 | 38.94 | 39.19 | 7835500.0 |
| 2004-11-18 11:00:00 | QQQ | ETF | 39.19 | 39.23 | 39.127 | 39.15 | 9574900.0 |
| 2004-11-18 11:30:00 | QQQ | ETF | 39.15 | 39.22 | 39.13 | 39.16 | 3954500.0 |
| 2004-11-18 12:00:00 | QQQ | ETF | 39.16 | 39.22 | 39.11 | 39.18 | 6299900.0 |
| 2004-11-18 12:30:00 | QQQ | ETF | 39.174 | 39.21 | 39.12 | 39.125 | 4826700.0 |
| 2004-11-18 13:00:00 | QQQ | ETF | 39.126 | 39.14 | 39.069 | 39.121 | 5688600.0 |
| 2004-11-18 13:30:00 | QQQ | ETF | 39.12 | 39.19 | 39.08 | 39.18 | 3011000.0 |
| 2004-11-18 14:00:00 | QQQ | ETF | 39.185 | 39.2 | 39.1 | 39.147 | 3460600.0 |
| 2004-11-18 14:30:00 | QQQ | ETF | 39.15 | 39.34 | 39.14 | 39.31 | 7600700.0 |
| 2004-11-18 15:00:00 | QQQ | ETF | 39.31 | 39.34 | 39.23 | 39.262 | 7249700.0 |
| 2004-11-18 15:30:00 | QQQ | ETF | 39.26 | 39.36 | 39.256 | 39.29 | 9610700.0 |
| 2004-11-18 16:00:00 | QQQ | ETF | 39.3 | 39.33 | 39.27 | 39.28 | 1841500.0 |
| 2004-11-18 16:30:00 | QQQ | ETF | 39.29 | 39.315 | 39.29 | 39.294 | 155200.0 |
| 2004-11-18 17:00:00 | QQQ | ETF | 39.29 | 39.32 | 39.28 | 39.3 | 116300.0 |
| 2004-11-18 17:30:00 | QQQ | ETF | 39.3 | 39.32 | 39.3 | 39.31 | 9500.0 |
| 2004-11-18 18:00:00 | QQQ | ETF | 39.31 | 39.31 | 39.29 | 39.291 | 20600.0 |
| 2004-11-18 18:30:00 | QQQ | ETF | 39.3 | 39.31 | 39.27 | 39.27 | 19500.0 |
| 2004-11-18 19:00:00 | QQQ | ETF | 39.27 | 39.29 | 39.27 | 39.28 | 3700.0 |
| 2004-11-18 19:30:00 | QQQ | ETF | 39.28 | 39.28 | 39.26 | 39.27 | 11100.0 |
| 2004-11-18 08:00:00 | IWM | ETF | 62.05 | 62.05 | 62.05 | 62.05 | 2000.0 |
| 2004-11-18 08:30:00 | IWM | ETF | 62.05 | 62.07 | 62.045 | 62.07 | 6600.0 |
| 2004-11-18 09:00:00 | IWM | ETF | 62.01 | 62.085 | 62.01 | 62.085 | 5600.0 |
| 2004-11-18 09:30:00 | IWM | ETF | 62.07 | 62.18 | 61.93 | 61.94 | 1401400.0 |
| 2004-11-18 10:00:00 | IWM | ETF | 61.915 | 61.965 | 61.63 | 61.675 | 1178000.0 |
> showing 50 of 1,334 rows — these rows as CSV