PREVIEW / etf_30min / 2004-11-29
file: by_date/etf_30min/2004/2004-11-29.parquet size: 41 KB rows: 1,375
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-29 08:00:00 | SPY | ETF | 118.97 | 119.06 | 118.96 | 119.06 | 48200.0 |
| 2004-11-29 08:30:00 | SPY | ETF | 119.01 | 119.01 | 118.78 | 118.86 | 87900.0 |
| 2004-11-29 09:00:00 | SPY | ETF | 118.87 | 118.87 | 118.75 | 118.79 | 219200.0 |
| 2004-11-29 09:30:00 | SPY | ETF | 118.79 | 119.01 | 118.64 | 118.64 | 4917700.0 |
| 2004-11-29 10:00:00 | SPY | ETF | 118.64 | 118.65 | 118.42 | 118.54 | 4317600.0 |
| 2004-11-29 10:30:00 | SPY | ETF | 118.53 | 118.64 | 118.39 | 118.43 | 3100900.0 |
| 2004-11-29 11:00:00 | SPY | ETF | 118.44 | 118.5 | 117.71 | 117.82 | 7282600.0 |
| 2004-11-29 11:30:00 | SPY | ETF | 117.82 | 117.87 | 117.48 | 117.71 | 3986400.0 |
| 2004-11-29 12:00:00 | SPY | ETF | 117.71 | 117.82 | 117.66 | 117.74 | 1775100.0 |
| 2004-11-29 12:30:00 | SPY | ETF | 117.74 | 117.8 | 117.72 | 117.76 | 1804500.0 |
| 2004-11-29 13:00:00 | SPY | ETF | 117.76 | 118.01 | 117.74 | 117.98 | 2651700.0 |
| 2004-11-29 13:30:00 | SPY | ETF | 117.98 | 118.23 | 117.96 | 118.13 | 3206600.0 |
| 2004-11-29 14:00:00 | SPY | ETF | 118.13 | 118.17 | 117.96 | 118.02 | 1919500.0 |
| 2004-11-29 14:30:00 | SPY | ETF | 118.02 | 118.68 | 117.98 | 118.48 | 6111100.0 |
| 2004-11-29 15:00:00 | SPY | ETF | 118.48 | 118.59 | 118.24 | 118.33 | 3310000.0 |
| 2004-11-29 15:30:00 | SPY | ETF | 118.33 | 118.47 | 118.07 | 118.13 | 5918400.0 |
| 2004-11-29 16:00:00 | SPY | ETF | 118.12 | 118.245 | 117.58 | 117.9 | 3066800.0 |
| 2004-11-29 16:30:00 | SPY | ETF | 117.89 | 117.95 | 117.73 | 117.74 | 65400.0 |
| 2004-11-29 17:00:00 | SPY | ETF | 117.74 | 117.81 | 117.74 | 117.79 | 63100.0 |
| 2004-11-29 17:30:00 | SPY | ETF | 117.76 | 117.85 | 117.76 | 117.82 | 100400.0 |
| 2004-11-29 18:00:00 | SPY | ETF | 117.81 | 118.16 | 117.79 | 118.16 | 190600.0 |
| 2004-11-29 18:30:00 | SPY | ETF | 117.8 | 117.8 | 117.8 | 117.8 | 200.0 |
| 2004-11-29 19:30:00 | SPY | ETF | 117.78 | 117.78 | 117.78 | 117.78 | 2000.0 |
| 2004-11-29 08:00:00 | QQQ | ETF | 39.56 | 39.58 | 39.55 | 39.58 | 368000.0 |
| 2004-11-29 08:30:00 | QQQ | ETF | 39.58 | 39.59 | 39.46 | 39.49 | 192500.0 |
| 2004-11-29 09:00:00 | QQQ | ETF | 39.5 | 39.51 | 39.44 | 39.46 | 495400.0 |
| 2004-11-29 09:30:00 | QQQ | ETF | 39.46 | 39.64 | 39.45 | 39.462 | 11934000.0 |
| 2004-11-29 10:00:00 | QQQ | ETF | 39.462 | 39.51 | 39.37 | 39.47 | 9118100.0 |
| 2004-11-29 10:30:00 | QQQ | ETF | 39.47 | 39.52 | 39.35 | 39.36 | 5564500.0 |
| 2004-11-29 11:00:00 | QQQ | ETF | 39.365 | 39.43 | 39.1 | 39.1 | 10097100.0 |
| 2004-11-29 11:30:00 | QQQ | ETF | 39.109 | 39.13 | 38.97 | 39.08 | 8032800.0 |
| 2004-11-29 12:00:00 | QQQ | ETF | 39.08 | 39.12 | 39.06 | 39.09 | 3020400.0 |
| 2004-11-29 12:30:00 | QQQ | ETF | 39.09 | 39.13 | 39.06 | 39.08 | 3168900.0 |
| 2004-11-29 13:00:00 | QQQ | ETF | 39.08 | 39.18 | 39.08 | 39.15 | 3562300.0 |
| 2004-11-29 13:30:00 | QQQ | ETF | 39.15 | 39.28 | 39.14 | 39.22 | 5551800.0 |
| 2004-11-29 14:00:00 | QQQ | ETF | 39.221 | 39.26 | 39.14 | 39.19 | 2758300.0 |
| 2004-11-29 14:30:00 | QQQ | ETF | 39.19 | 39.411 | 39.17 | 39.35 | 9519200.0 |
| 2004-11-29 15:00:00 | QQQ | ETF | 39.35 | 39.42 | 39.24 | 39.284 | 6826900.0 |
| 2004-11-29 15:30:00 | QQQ | ETF | 39.28 | 39.37 | 39.21 | 39.3 | 10940400.0 |
| 2004-11-29 16:00:00 | QQQ | ETF | 39.3 | 39.31 | 39.19 | 39.21 | 1810100.0 |
| 2004-11-29 16:30:00 | QQQ | ETF | 39.205 | 39.22 | 39.151 | 39.151 | 316100.0 |
| 2004-11-29 17:00:00 | QQQ | ETF | 39.153 | 39.19 | 39.153 | 39.189 | 248400.0 |
| 2004-11-29 17:30:00 | QQQ | ETF | 39.2 | 39.2 | 39.18 | 39.18 | 7800.0 |
| 2004-11-29 18:00:00 | QQQ | ETF | 39.177 | 39.19 | 39.17 | 39.19 | 13700.0 |
| 2004-11-29 18:30:00 | QQQ | ETF | 39.2 | 39.2 | 39.18 | 39.18 | 1700.0 |
| 2004-11-29 19:00:00 | QQQ | ETF | 39.18 | 39.18 | 39.18 | 39.18 | 2900.0 |
| 2004-11-29 19:30:00 | QQQ | ETF | 39.18 | 39.18 | 39.18 | 39.18 | 2600.0 |
| 2004-11-29 09:00:00 | IWM | ETF | 63.225 | 63.225 | 63.175 | 63.175 | 22600.0 |
| 2004-11-29 09:30:00 | IWM | ETF | 63.21 | 63.375 | 63.14 | 63.14 | 1833400.0 |
| 2004-11-29 10:00:00 | IWM | ETF | 63.135 | 63.135 | 62.88 | 63.08 | 813200.0 |
> showing 50 of 1,375 rows — these rows as CSV