PREVIEW / etf_30min / 2004-09-29
file: by_date/etf_30min/2004/2004-09-29.parquet size: 34 KB rows: 1,150
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-09-29 08:00:00 | SPY | ETF | 111.24 | 111.28 | 111.23 | 111.24 | 52700.0 |
| 2004-09-29 08:30:00 | SPY | ETF | 111.28 | 111.34 | 111.22 | 111.22 | 28700.0 |
| 2004-09-29 09:00:00 | SPY | ETF | 111.22 | 111.27 | 111.17 | 111.19 | 35800.0 |
| 2004-09-29 09:30:00 | SPY | ETF | 111.21 | 111.31 | 111.05 | 111.28 | 4176300.0 |
| 2004-09-29 10:00:00 | SPY | ETF | 111.28 | 111.29 | 111.0 | 111.08 | 3216900.0 |
| 2004-09-29 10:30:00 | SPY | ETF | 111.09 | 111.49 | 111.04 | 111.37 | 6097300.0 |
| 2004-09-29 11:00:00 | SPY | ETF | 111.37 | 111.46 | 111.29 | 111.32 | 1623600.0 |
| 2004-09-29 11:30:00 | SPY | ETF | 111.29 | 111.36 | 111.2 | 111.29 | 1364500.0 |
| 2004-09-29 12:00:00 | SPY | ETF | 111.29 | 111.31 | 111.18 | 111.3 | 902400.0 |
| 2004-09-29 12:30:00 | SPY | ETF | 111.3 | 111.59 | 111.29 | 111.5 | 2457800.0 |
| 2004-09-29 13:00:00 | SPY | ETF | 111.5 | 111.54 | 111.37 | 111.42 | 1235800.0 |
| 2004-09-29 13:30:00 | SPY | ETF | 111.4 | 111.5 | 111.33 | 111.4 | 2001900.0 |
| 2004-09-29 14:00:00 | SPY | ETF | 111.4 | 111.47 | 111.2 | 111.31 | 1526100.0 |
| 2004-09-29 14:30:00 | SPY | ETF | 111.32 | 111.53 | 111.3 | 111.47 | 1800200.0 |
| 2004-09-29 15:00:00 | SPY | ETF | 111.47 | 111.64 | 111.45 | 111.52 | 1606100.0 |
| 2004-09-29 15:30:00 | SPY | ETF | 111.52 | 111.79 | 111.47 | 111.74 | 2571100.0 |
| 2004-09-29 16:00:00 | SPY | ETF | 111.74 | 111.88 | 111.67 | 111.82 | 1650900.0 |
| 2004-09-29 16:30:00 | SPY | ETF | 111.82 | 111.85 | 111.8 | 111.84 | 233300.0 |
| 2004-09-29 17:00:00 | SPY | ETF | 111.81 | 111.85 | 111.79 | 111.84 | 335400.0 |
| 2004-09-29 17:30:00 | SPY | ETF | 111.83 | 111.85 | 111.81 | 111.82 | 201600.0 |
| 2004-09-29 18:00:00 | SPY | ETF | 111.84 | 111.85 | 111.78 | 111.78 | 2600.0 |
| 2004-09-29 18:30:00 | SPY | ETF | 111.79 | 111.79 | 111.78 | 111.78 | 1400.0 |
| 2004-09-29 19:30:00 | SPY | ETF | 111.83 | 111.83 | 111.83 | 111.83 | 100.0 |
| 2004-09-29 08:00:00 | QQQ | ETF | 34.56 | 34.59 | 34.56 | 34.56 | 60700.0 |
| 2004-09-29 08:30:00 | QQQ | ETF | 34.58 | 34.62 | 34.57 | 34.57 | 223500.0 |
| 2004-09-29 09:00:00 | QQQ | ETF | 34.56 | 34.57 | 34.52 | 34.54 | 329300.0 |
| 2004-09-29 09:30:00 | QQQ | ETF | 34.543 | 34.76 | 34.53 | 34.75 | 14320900.0 |
| 2004-09-29 10:00:00 | QQQ | ETF | 34.75 | 34.82 | 34.65 | 34.75 | 10680200.0 |
| 2004-09-29 10:30:00 | QQQ | ETF | 34.76 | 35.03 | 34.75 | 34.97 | 13438600.0 |
| 2004-09-29 11:00:00 | QQQ | ETF | 34.97 | 35.03 | 34.95 | 34.95 | 7031000.0 |
| 2004-09-29 11:30:00 | QQQ | ETF | 34.956 | 34.98 | 34.88 | 34.95 | 4188100.0 |
| 2004-09-29 12:00:00 | QQQ | ETF | 34.96 | 34.98 | 34.9 | 34.97 | 3344600.0 |
| 2004-09-29 12:30:00 | QQQ | ETF | 34.97 | 35.12 | 34.96 | 35.08 | 6582100.0 |
| 2004-09-29 13:00:00 | QQQ | ETF | 35.08 | 35.09 | 35.0 | 35.02 | 3353900.0 |
| 2004-09-29 13:30:00 | QQQ | ETF | 35.03 | 35.07 | 35.0 | 35.05 | 3361300.0 |
| 2004-09-29 14:00:00 | QQQ | ETF | 35.045 | 35.06 | 34.96 | 35.0 | 5741200.0 |
| 2004-09-29 14:30:00 | QQQ | ETF | 35.0 | 35.05 | 34.96 | 35.03 | 4207100.0 |
| 2004-09-29 15:00:00 | QQQ | ETF | 35.023 | 35.09 | 35.01 | 35.023 | 6420000.0 |
| 2004-09-29 15:30:00 | QQQ | ETF | 35.02 | 35.11 | 34.97 | 35.089 | 7978300.0 |
| 2004-09-29 16:00:00 | QQQ | ETF | 35.09 | 35.12 | 35.06 | 35.09 | 2697800.0 |
| 2004-09-29 16:30:00 | QQQ | ETF | 35.08 | 35.09 | 35.062 | 35.07 | 194100.0 |
| 2004-09-29 17:00:00 | QQQ | ETF | 35.08 | 35.088 | 35.06 | 35.087 | 676800.0 |
| 2004-09-29 17:30:00 | QQQ | ETF | 35.08 | 35.1 | 35.072 | 35.09 | 50200.0 |
| 2004-09-29 18:00:00 | QQQ | ETF | 35.08 | 35.08 | 35.05 | 35.06 | 106200.0 |
| 2004-09-29 18:30:00 | QQQ | ETF | 35.07 | 35.07 | 35.07 | 35.07 | 9100.0 |
| 2004-09-29 19:00:00 | QQQ | ETF | 35.06 | 35.06 | 35.06 | 35.06 | 100.0 |
| 2004-09-29 19:30:00 | QQQ | ETF | 35.06 | 35.08 | 35.06 | 35.06 | 10400.0 |
| 2004-09-29 08:30:00 | IWM | ETF | 56.355 | 56.36 | 56.35 | 56.35 | 35800.0 |
| 2004-09-29 09:00:00 | IWM | ETF | 56.33 | 56.355 | 56.28 | 56.28 | 36400.0 |
| 2004-09-29 09:30:00 | IWM | ETF | 56.28 | 56.605 | 56.235 | 56.605 | 2471000.0 |
> showing 50 of 1,150 rows — these rows as CSV