PREVIEW / etf_30min / 2004-06-17
file: by_date/etf_30min/2004/2004-06-17.parquet size: 34 KB rows: 1,126
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-17 08:00:00 | SPY | ETF | 114.02 | 114.1 | 114.0 | 114.1 | 28000.0 |
| 2004-06-17 08:30:00 | SPY | ETF | 114.02 | 114.02 | 113.9 | 113.92 | 147400.0 |
| 2004-06-17 09:00:00 | SPY | ETF | 113.91 | 113.93 | 113.85 | 113.87 | 33200.0 |
| 2004-06-17 09:30:00 | SPY | ETF | 113.85 | 113.88 | 113.48 | 113.53 | 4198300.0 |
| 2004-06-17 10:00:00 | SPY | ETF | 113.53 | 113.57 | 113.33 | 113.46 | 3212900.0 |
| 2004-06-17 10:30:00 | SPY | ETF | 113.45 | 113.62 | 113.36 | 113.57 | 2515800.0 |
| 2004-06-17 11:00:00 | SPY | ETF | 113.58 | 113.67 | 113.48 | 113.61 | 1630300.0 |
| 2004-06-17 11:30:00 | SPY | ETF | 113.62 | 113.85 | 113.58 | 113.71 | 2265000.0 |
| 2004-06-17 12:00:00 | SPY | ETF | 113.72 | 113.82 | 113.67 | 113.7 | 1310300.0 |
| 2004-06-17 12:30:00 | SPY | ETF | 113.7 | 113.75 | 113.645 | 113.71 | 774800.0 |
| 2004-06-17 13:00:00 | SPY | ETF | 113.71 | 113.98 | 113.67 | 113.93 | 1554800.0 |
| 2004-06-17 13:30:00 | SPY | ETF | 113.93 | 113.94 | 113.8 | 113.87 | 1046500.0 |
| 2004-06-17 14:00:00 | SPY | ETF | 113.88 | 114.07 | 113.79 | 113.84 | 2329900.0 |
| 2004-06-17 14:30:00 | SPY | ETF | 113.84 | 113.88 | 113.68 | 113.73 | 1304300.0 |
| 2004-06-17 15:00:00 | SPY | ETF | 113.72 | 113.95 | 113.71 | 113.85 | 1290600.0 |
| 2004-06-17 15:30:00 | SPY | ETF | 113.86 | 113.99 | 113.8 | 113.85 | 1786000.0 |
| 2004-06-17 16:00:00 | SPY | ETF | 113.86 | 113.91 | 113.75 | 113.78 | 1407400.0 |
| 2004-06-17 16:30:00 | SPY | ETF | 113.8 | 113.8 | 113.43 | 113.77 | 160000.0 |
| 2004-06-17 17:00:00 | SPY | ETF | 113.75 | 113.76 | 113.72 | 113.76 | 101400.0 |
| 2004-06-17 17:30:00 | SPY | ETF | 113.72 | 113.72 | 113.71 | 113.71 | 2900.0 |
| 2004-06-17 18:00:00 | SPY | ETF | 113.77 | 113.8 | 113.74 | 113.74 | 67800.0 |
| 2004-06-17 18:30:00 | SPY | ETF | 113.74 | 113.78 | 113.74 | 113.78 | 1000.0 |
| 2004-06-17 19:00:00 | SPY | ETF | 113.73 | 113.73 | 113.73 | 113.73 | 200.0 |
| 2004-06-17 08:00:00 | QQQ | ETF | 36.7 | 36.72 | 36.68 | 36.72 | 86300.0 |
| 2004-06-17 08:30:00 | QQQ | ETF | 36.64 | 36.68 | 36.62 | 36.66 | 144500.0 |
| 2004-06-17 09:00:00 | QQQ | ETF | 36.65 | 36.67 | 36.65 | 36.67 | 164200.0 |
| 2004-06-17 09:30:00 | QQQ | ETF | 36.65 | 36.656 | 36.38 | 36.42 | 15186600.0 |
| 2004-06-17 10:00:00 | QQQ | ETF | 36.41 | 36.42 | 36.25 | 36.32 | 11440000.0 |
| 2004-06-17 10:30:00 | QQQ | ETF | 36.32 | 36.4 | 36.29 | 36.39 | 4975600.0 |
| 2004-06-17 11:00:00 | QQQ | ETF | 36.387 | 36.41 | 36.34 | 36.37 | 4075400.0 |
| 2004-06-17 11:30:00 | QQQ | ETF | 36.376 | 36.48 | 36.36 | 36.4 | 5859900.0 |
| 2004-06-17 12:00:00 | QQQ | ETF | 36.4 | 36.45 | 36.36 | 36.387 | 3072000.0 |
| 2004-06-17 12:30:00 | QQQ | ETF | 36.392 | 36.392 | 36.328 | 36.38 | 2520400.0 |
| 2004-06-17 13:00:00 | QQQ | ETF | 36.39 | 36.46 | 36.35 | 36.442 | 3061500.0 |
| 2004-06-17 13:30:00 | QQQ | ETF | 36.442 | 36.45 | 36.38 | 36.4077 | 4166600.0 |
| 2004-06-17 14:00:00 | QQQ | ETF | 36.4 | 36.48 | 36.38 | 36.4 | 4606700.0 |
| 2004-06-17 14:30:00 | QQQ | ETF | 36.399 | 36.41 | 36.32 | 36.33 | 5473600.0 |
| 2004-06-17 15:00:00 | QQQ | ETF | 36.33 | 36.42 | 36.32 | 36.37 | 4199000.0 |
| 2004-06-17 15:30:00 | QQQ | ETF | 36.37 | 36.42 | 36.35 | 36.4 | 5256900.0 |
| 2004-06-17 16:00:00 | QQQ | ETF | 36.4 | 36.42 | 36.37 | 36.39 | 2284900.0 |
| 2004-06-17 16:30:00 | QQQ | ETF | 36.39 | 36.425 | 36.35 | 36.38 | 103200.0 |
| 2004-06-17 17:00:00 | QQQ | ETF | 36.37 | 36.42 | 36.355 | 36.39 | 288200.0 |
| 2004-06-17 17:30:00 | QQQ | ETF | 36.39 | 36.419 | 36.39 | 36.4 | 22300.0 |
| 2004-06-17 18:00:00 | QQQ | ETF | 36.4 | 36.4 | 36.39 | 36.4 | 6900.0 |
| 2004-06-17 18:30:00 | QQQ | ETF | 36.39 | 36.39 | 36.39 | 36.39 | 3300.0 |
| 2004-06-17 19:00:00 | QQQ | ETF | 36.39 | 36.41 | 36.39 | 36.41 | 1300.0 |
| 2004-06-17 19:30:00 | QQQ | ETF | 36.41 | 36.41 | 36.41 | 36.41 | 400.0 |
| 2004-06-17 08:30:00 | IWM | ETF | 56.8 | 56.8 | 56.8 | 56.8 | 1000.0 |
| 2004-06-17 09:00:00 | IWM | ETF | 56.775 | 56.775 | 56.77 | 56.77 | 1200.0 |
| 2004-06-17 09:30:00 | IWM | ETF | 56.76 | 56.85 | 56.34 | 56.4 | 805200.0 |
> showing 50 of 1,126 rows — these rows as CSV