PREVIEW / etf_30min / 2004-04-27
file: by_date/etf_30min/2004/2004-04-27.parquet size: 35 KB rows: 1,181
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-27 08:00:00 | SPY | ETF | 114.25 | 114.3 | 114.2 | 114.3 | 13900.0 |
| 2004-04-27 08:30:00 | SPY | ETF | 114.3 | 114.31 | 114.25 | 114.31 | 8500.0 |
| 2004-04-27 09:00:00 | SPY | ETF | 114.31 | 114.35 | 114.23 | 114.23 | 35900.0 |
| 2004-04-27 09:30:00 | SPY | ETF | 114.23 | 114.4 | 114.13 | 114.3 | 2745900.0 |
| 2004-04-27 10:00:00 | SPY | ETF | 114.29 | 115.12 | 114.27 | 114.8 | 7039100.0 |
| 2004-04-27 10:30:00 | SPY | ETF | 114.82 | 114.89 | 114.47 | 114.64 | 3491900.0 |
| 2004-04-27 11:00:00 | SPY | ETF | 114.64 | 114.78 | 114.52 | 114.62 | 1098600.0 |
| 2004-04-27 11:30:00 | SPY | ETF | 114.61 | 114.85 | 114.51 | 114.8 | 2175500.0 |
| 2004-04-27 12:00:00 | SPY | ETF | 114.81 | 114.85 | 114.72 | 114.78 | 552700.0 |
| 2004-04-27 12:30:00 | SPY | ETF | 114.77 | 114.9 | 114.72 | 114.85 | 1419000.0 |
| 2004-04-27 13:00:00 | SPY | ETF | 114.84 | 114.94 | 114.69 | 114.78 | 1151800.0 |
| 2004-04-27 13:30:00 | SPY | ETF | 114.77 | 114.94 | 114.76 | 114.89 | 962400.0 |
| 2004-04-27 14:00:00 | SPY | ETF | 114.86 | 114.92 | 114.41 | 114.45 | 2681800.0 |
| 2004-04-27 14:30:00 | SPY | ETF | 114.45 | 114.6 | 113.96 | 114.26 | 6102200.0 |
| 2004-04-27 15:00:00 | SPY | ETF | 114.26 | 114.39 | 114.15 | 114.29 | 3018700.0 |
| 2004-04-27 15:30:00 | SPY | ETF | 114.28 | 114.3 | 114.02 | 114.22 | 3014100.0 |
| 2004-04-27 16:00:00 | SPY | ETF | 114.25 | 114.37 | 114.13 | 114.22 | 759400.0 |
| 2004-04-27 16:30:00 | SPY | ETF | 114.27 | 114.28 | 114.19 | 114.22 | 8400.0 |
| 2004-04-27 17:00:00 | SPY | ETF | 114.23 | 114.25 | 114.2 | 114.25 | 7000.0 |
| 2004-04-27 18:00:00 | SPY | ETF | 114.25 | 114.25 | 114.21 | 114.21 | 1100.0 |
| 2004-04-27 18:30:00 | SPY | ETF | 114.22 | 114.22 | 114.22 | 114.22 | 2400.0 |
| 2004-04-27 19:00:00 | SPY | ETF | 114.19 | 114.2 | 114.19 | 114.2 | 300.0 |
| 2004-04-27 08:00:00 | QQQ | ETF | 36.93 | 37.0 | 36.92 | 37.0 | 19200.0 |
| 2004-04-27 08:30:00 | QQQ | ETF | 36.97 | 37.0 | 36.96 | 36.99 | 161300.0 |
| 2004-04-27 09:00:00 | QQQ | ETF | 36.99 | 37.0 | 36.95 | 36.96 | 113300.0 |
| 2004-04-27 09:30:00 | QQQ | ETF | 36.946 | 37.01 | 36.85 | 36.9 | 7453200.0 |
| 2004-04-27 10:00:00 | QQQ | ETF | 36.9 | 37.19 | 36.88 | 37.09 | 12196700.0 |
| 2004-04-27 10:30:00 | QQQ | ETF | 37.09 | 37.13 | 36.89 | 37.0 | 7115000.0 |
| 2004-04-27 11:00:00 | QQQ | ETF | 37.0 | 37.07 | 36.936 | 36.971 | 4824700.0 |
| 2004-04-27 11:30:00 | QQQ | ETF | 36.97 | 37.06 | 36.91 | 37.04 | 4335600.0 |
| 2004-04-27 12:00:00 | QQQ | ETF | 37.04 | 37.07 | 36.98 | 36.99 | 2353600.0 |
| 2004-04-27 12:30:00 | QQQ | ETF | 36.99 | 37.09 | 36.98 | 37.07 | 2263200.0 |
| 2004-04-27 13:00:00 | QQQ | ETF | 37.059 | 37.116 | 36.982 | 37.05 | 3147600.0 |
| 2004-04-27 13:30:00 | QQQ | ETF | 37.05 | 37.14 | 37.04 | 37.12 | 3362200.0 |
| 2004-04-27 14:00:00 | QQQ | ETF | 37.12 | 37.14 | 36.9 | 36.91 | 5347500.0 |
| 2004-04-27 14:30:00 | QQQ | ETF | 36.91 | 36.97 | 36.71 | 36.807 | 9835500.0 |
| 2004-04-27 15:00:00 | QQQ | ETF | 36.79 | 36.89 | 36.77 | 36.8 | 5322900.0 |
| 2004-04-27 15:30:00 | QQQ | ETF | 36.81 | 36.87 | 36.69 | 36.814 | 8074000.0 |
| 2004-04-27 16:00:00 | QQQ | ETF | 36.81 | 36.893 | 36.77 | 36.85 | 2166700.0 |
| 2004-04-27 16:30:00 | QQQ | ETF | 36.858 | 36.89 | 36.796 | 36.81 | 1282300.0 |
| 2004-04-27 17:00:00 | QQQ | ETF | 36.81 | 36.83 | 36.79 | 36.8 | 70700.0 |
| 2004-04-27 17:30:00 | QQQ | ETF | 36.81 | 36.86 | 36.795 | 36.84 | 49200.0 |
| 2004-04-27 18:00:00 | QQQ | ETF | 36.84 | 36.84 | 36.82 | 36.82 | 39300.0 |
| 2004-04-27 18:30:00 | QQQ | ETF | 36.84 | 36.84 | 36.84 | 36.84 | 1400.0 |
| 2004-04-27 19:00:00 | QQQ | ETF | 36.85 | 36.85 | 36.83 | 36.85 | 5300.0 |
| 2004-04-27 19:30:00 | QQQ | ETF | 36.82 | 36.84 | 36.81 | 36.84 | 24300.0 |
| 2004-04-27 08:30:00 | IWM | ETF | 58.97 | 58.97 | 58.97 | 58.97 | 2000.0 |
| 2004-04-27 09:30:00 | IWM | ETF | 59.0 | 59.085 | 58.75 | 58.86 | 863200.0 |
| 2004-04-27 10:00:00 | IWM | ETF | 58.83 | 59.355 | 58.825 | 59.13 | 794400.0 |
| 2004-04-27 10:30:00 | IWM | ETF | 59.105 | 59.175 | 58.85 | 58.975 | 279800.0 |
> showing 50 of 1,181 rows — these rows as CSV