PREVIEW / etf_30min / 2004-06-24
file: by_date/etf_30min/2004/2004-06-24.parquet size: 35 KB rows: 1,171
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-24 08:00:00 | SPY | ETF | 114.73 | 114.76 | 114.61 | 114.61 | 21100.0 |
| 2004-06-24 08:30:00 | SPY | ETF | 114.57 | 114.7 | 114.51 | 114.51 | 98500.0 |
| 2004-06-24 09:00:00 | SPY | ETF | 114.5 | 114.58 | 114.49 | 114.55 | 36600.0 |
| 2004-06-24 09:30:00 | SPY | ETF | 114.56 | 114.78 | 114.46 | 114.73 | 5296200.0 |
| 2004-06-24 10:00:00 | SPY | ETF | 114.74 | 114.84 | 114.6 | 114.67 | 3010500.0 |
| 2004-06-24 10:30:00 | SPY | ETF | 114.71 | 114.8 | 114.6 | 114.72 | 2346600.0 |
| 2004-06-24 11:00:00 | SPY | ETF | 114.72 | 114.86 | 114.69 | 114.84 | 3269000.0 |
| 2004-06-24 11:30:00 | SPY | ETF | 114.83 | 114.93 | 114.74 | 114.75 | 2720200.0 |
| 2004-06-24 12:00:00 | SPY | ETF | 114.75 | 114.84 | 114.71 | 114.78 | 990200.0 |
| 2004-06-24 12:30:00 | SPY | ETF | 114.79 | 114.88 | 114.77 | 114.8 | 1788700.0 |
| 2004-06-24 13:00:00 | SPY | ETF | 114.81 | 114.84 | 114.69 | 114.77 | 1054600.0 |
| 2004-06-24 13:30:00 | SPY | ETF | 114.76 | 114.82 | 114.54 | 114.6 | 1946800.0 |
| 2004-06-24 14:00:00 | SPY | ETF | 114.61 | 114.63 | 114.38 | 114.46 | 2638300.0 |
| 2004-06-24 14:30:00 | SPY | ETF | 114.47 | 114.7 | 114.35 | 114.37 | 1714900.0 |
| 2004-06-24 15:00:00 | SPY | ETF | 114.37 | 114.57 | 114.28 | 114.5 | 2894300.0 |
| 2004-06-24 15:30:00 | SPY | ETF | 114.51 | 114.52 | 114.26 | 114.42 | 2303800.0 |
| 2004-06-24 16:00:00 | SPY | ETF | 114.42 | 114.6318 | 114.33 | 114.44 | 2023700.0 |
| 2004-06-24 16:30:00 | SPY | ETF | 114.45 | 114.54 | 114.45 | 114.46 | 39100.0 |
| 2004-06-24 17:00:00 | SPY | ETF | 114.46 | 114.46 | 114.44 | 114.44 | 15200.0 |
| 2004-06-24 17:30:00 | SPY | ETF | 114.43 | 114.48 | 113.0 | 114.47 | 4118200.0 |
| 2004-06-24 18:00:00 | SPY | ETF | 114.45 | 114.45 | 114.45 | 114.45 | 5100.0 |
| 2004-06-24 19:00:00 | SPY | ETF | 114.5 | 114.5 | 114.5 | 114.5 | 500.0 |
| 2004-06-24 19:30:00 | SPY | ETF | 114.42 | 114.42 | 114.42 | 114.42 | 100.0 |
| 2004-06-24 08:00:00 | QQQ | ETF | 37.12 | 37.14 | 37.06 | 37.06 | 50900.0 |
| 2004-06-24 08:30:00 | QQQ | ETF | 37.04 | 37.1 | 37.02 | 37.02 | 314800.0 |
| 2004-06-24 09:00:00 | QQQ | ETF | 37.02 | 37.03 | 36.99 | 37.02 | 133800.0 |
| 2004-06-24 09:30:00 | QQQ | ETF | 37.02 | 37.21 | 37.01 | 37.14 | 11800800.0 |
| 2004-06-24 10:00:00 | QQQ | ETF | 37.146 | 37.23 | 37.06 | 37.12 | 7411800.0 |
| 2004-06-24 10:30:00 | QQQ | ETF | 37.13 | 37.214 | 37.08 | 37.18 | 4726000.0 |
| 2004-06-24 11:00:00 | QQQ | ETF | 37.178 | 37.25 | 37.17 | 37.23 | 5335700.0 |
| 2004-06-24 11:30:00 | QQQ | ETF | 37.239 | 37.35 | 37.21 | 37.26 | 7270000.0 |
| 2004-06-24 12:00:00 | QQQ | ETF | 37.27 | 37.3 | 37.216 | 37.259 | 4024300.0 |
| 2004-06-24 12:30:00 | QQQ | ETF | 37.258 | 37.32 | 37.246 | 37.269 | 3649600.0 |
| 2004-06-24 13:00:00 | QQQ | ETF | 37.26 | 37.3 | 37.213 | 37.24 | 3801900.0 |
| 2004-06-24 13:30:00 | QQQ | ETF | 37.234 | 37.24 | 37.12 | 37.133 | 8249100.0 |
| 2004-06-24 14:00:00 | QQQ | ETF | 37.134 | 37.14 | 36.97 | 37.01 | 7340400.0 |
| 2004-06-24 14:30:00 | QQQ | ETF | 37.01 | 37.12 | 36.98 | 36.992 | 6322600.0 |
| 2004-06-24 15:00:00 | QQQ | ETF | 36.992 | 37.12 | 36.92 | 37.09 | 7982300.0 |
| 2004-06-24 15:30:00 | QQQ | ETF | 37.084 | 37.11 | 36.94 | 37.024 | 8732000.0 |
| 2004-06-24 16:00:00 | QQQ | ETF | 37.024 | 37.09 | 37.0 | 37.07 | 3489000.0 |
| 2004-06-24 16:30:00 | QQQ | ETF | 37.07 | 37.07 | 37.03 | 37.04 | 151600.0 |
| 2004-06-24 17:00:00 | QQQ | ETF | 37.04 | 37.05 | 37.04 | 37.05 | 28200.0 |
| 2004-06-24 17:30:00 | QQQ | ETF | 37.05 | 37.06 | 37.04 | 37.05 | 23800.0 |
| 2004-06-24 18:00:00 | QQQ | ETF | 37.05 | 37.08 | 37.046 | 37.08 | 14400.0 |
| 2004-06-24 19:00:00 | QQQ | ETF | 37.06 | 37.07 | 37.06 | 37.07 | 1500.0 |
| 2004-06-24 19:30:00 | QQQ | ETF | 37.06 | 37.07 | 37.06 | 37.07 | 6600.0 |
| 2004-06-24 08:30:00 | IWM | ETF | 57.99 | 58.0 | 57.99 | 57.99 | 12800.0 |
| 2004-06-24 09:00:00 | IWM | ETF | 57.94 | 57.97 | 57.93 | 57.93 | 9200.0 |
| 2004-06-24 09:30:00 | IWM | ETF | 57.98 | 58.3 | 57.95 | 58.215 | 1436000.0 |
| 2004-06-24 10:00:00 | IWM | ETF | 58.22 | 58.24 | 58.075 | 58.125 | 825400.0 |
> showing 50 of 1,171 rows — these rows as CSV