PREVIEW / etf_30min / 2004-07-13
file: by_date/etf_30min/2004/2004-07-13.parquet size: 32 KB rows: 1,102
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-07-13 08:00:00 | SPY | ETF | 111.89 | 111.94 | 111.84 | 111.89 | 8700.0 |
| 2004-07-13 08:30:00 | SPY | ETF | 111.89 | 111.96 | 111.89 | 111.94 | 9000.0 |
| 2004-07-13 09:00:00 | SPY | ETF | 111.95 | 111.97 | 111.9 | 111.9 | 16000.0 |
| 2004-07-13 09:30:00 | SPY | ETF | 111.92 | 112.0 | 111.83 | 111.97 | 2494500.0 |
| 2004-07-13 10:00:00 | SPY | ETF | 111.96 | 112.02 | 111.74 | 111.87 | 2223600.0 |
| 2004-07-13 10:30:00 | SPY | ETF | 111.87 | 111.96 | 111.75 | 111.8 | 1493000.0 |
| 2004-07-13 11:00:00 | SPY | ETF | 111.8 | 111.85 | 111.75 | 111.83 | 1079900.0 |
| 2004-07-13 11:30:00 | SPY | ETF | 111.84 | 111.87 | 111.65 | 111.7 | 1562200.0 |
| 2004-07-13 12:00:00 | SPY | ETF | 111.71 | 111.77 | 111.63 | 111.7 | 1258300.0 |
| 2004-07-13 12:30:00 | SPY | ETF | 111.69 | 111.95 | 111.69 | 111.89 | 1557900.0 |
| 2004-07-13 13:00:00 | SPY | ETF | 111.89 | 111.92 | 111.66 | 111.8 | 2292800.0 |
| 2004-07-13 13:30:00 | SPY | ETF | 111.8 | 111.93 | 111.66 | 111.86 | 1273300.0 |
| 2004-07-13 14:00:00 | SPY | ETF | 111.86 | 112.0 | 111.79 | 111.84 | 1236700.0 |
| 2004-07-13 14:30:00 | SPY | ETF | 111.84 | 111.97 | 111.79 | 111.84 | 1413300.0 |
| 2004-07-13 15:00:00 | SPY | ETF | 111.85 | 112.0 | 111.82 | 111.89 | 1323900.0 |
| 2004-07-13 15:30:00 | SPY | ETF | 111.86 | 112.0 | 111.85 | 111.89 | 2227300.0 |
| 2004-07-13 16:00:00 | SPY | ETF | 111.89 | 112.15 | 111.65 | 111.65 | 1843800.0 |
| 2004-07-13 16:30:00 | SPY | ETF | 111.64 | 111.7 | 111.34 | 111.45 | 568500.0 |
| 2004-07-13 17:00:00 | SPY | ETF | 111.45 | 111.5 | 111.4 | 111.5 | 37600.0 |
| 2004-07-13 17:30:00 | SPY | ETF | 111.5 | 111.52 | 111.48 | 111.48 | 55100.0 |
| 2004-07-13 18:00:00 | SPY | ETF | 111.48 | 111.48 | 111.45 | 111.45 | 2300.0 |
| 2004-07-13 19:00:00 | SPY | ETF | 111.52 | 111.52 | 111.52 | 111.52 | 600.0 |
| 2004-07-13 19:30:00 | SPY | ETF | 111.53 | 111.53 | 111.51 | 111.51 | 1100.0 |
| 2004-07-13 08:00:00 | QQQ | ETF | 35.65 | 35.68 | 35.65 | 35.65 | 15900.0 |
| 2004-07-13 08:30:00 | QQQ | ETF | 35.67 | 35.72 | 35.66 | 35.71 | 85600.0 |
| 2004-07-13 09:00:00 | QQQ | ETF | 35.71 | 35.72 | 35.69 | 35.69 | 42000.0 |
| 2004-07-13 09:30:00 | QQQ | ETF | 35.68 | 35.81 | 35.67 | 35.78 | 7193900.0 |
| 2004-07-13 10:00:00 | QQQ | ETF | 35.78 | 35.796 | 35.62 | 35.69 | 6709100.0 |
| 2004-07-13 10:30:00 | QQQ | ETF | 35.7 | 35.73 | 35.62 | 35.65 | 3200900.0 |
| 2004-07-13 11:00:00 | QQQ | ETF | 35.649 | 35.67 | 35.581 | 35.626 | 3144500.0 |
| 2004-07-13 11:30:00 | QQQ | ETF | 35.625 | 35.64 | 35.52 | 35.55 | 3804300.0 |
| 2004-07-13 12:00:00 | QQQ | ETF | 35.561 | 35.59 | 35.51 | 35.55 | 2001700.0 |
| 2004-07-13 12:30:00 | QQQ | ETF | 35.55 | 35.7 | 35.54 | 35.651 | 3520900.0 |
| 2004-07-13 13:00:00 | QQQ | ETF | 35.654 | 35.673 | 35.43 | 35.55 | 7014400.0 |
| 2004-07-13 13:30:00 | QQQ | ETF | 35.549 | 35.57 | 35.441 | 35.541 | 5569700.0 |
| 2004-07-13 14:00:00 | QQQ | ETF | 35.54 | 35.64 | 35.49 | 35.51 | 5778400.0 |
| 2004-07-13 14:30:00 | QQQ | ETF | 35.51 | 35.607 | 35.49 | 35.51 | 4236200.0 |
| 2004-07-13 15:00:00 | QQQ | ETF | 35.52 | 35.55 | 35.46 | 35.493 | 3249900.0 |
| 2004-07-13 15:30:00 | QQQ | ETF | 35.49 | 35.58 | 35.46 | 35.53 | 9173800.0 |
| 2004-07-13 16:00:00 | QQQ | ETF | 35.539 | 35.8 | 35.35 | 35.35 | 3986600.0 |
| 2004-07-13 16:30:00 | QQQ | ETF | 35.349 | 35.4 | 35.19 | 35.284 | 3143700.0 |
| 2004-07-13 17:00:00 | QQQ | ETF | 35.28 | 35.29 | 35.247 | 35.26 | 751500.0 |
| 2004-07-13 17:30:00 | QQQ | ETF | 35.27 | 35.29 | 35.25 | 35.28 | 297000.0 |
| 2004-07-13 18:00:00 | QQQ | ETF | 35.27 | 35.3 | 35.25 | 35.27 | 114900.0 |
| 2004-07-13 18:30:00 | QQQ | ETF | 35.28 | 35.3 | 35.28 | 35.3 | 3000.0 |
| 2004-07-13 19:00:00 | QQQ | ETF | 35.28 | 35.28 | 35.28 | 35.28 | 800.0 |
| 2004-07-13 19:30:00 | QQQ | ETF | 35.3 | 35.33 | 35.3 | 35.3 | 7600.0 |
| 2004-07-13 09:00:00 | IWM | ETF | 56.175 | 56.2 | 56.175 | 56.2 | 1200.0 |
| 2004-07-13 09:30:00 | IWM | ETF | 56.165 | 56.35 | 56.135 | 56.295 | 808600.0 |
| 2004-07-13 10:00:00 | IWM | ETF | 56.305 | 56.315 | 56.165 | 56.205 | 789200.0 |
> showing 50 of 1,102 rows — these rows as CSV