PREVIEW / etf_30min / 2006-09-07
file: by_date/etf_30min/2006/2006-09-07.parquet size: 80 KB rows: 2,790
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 |
|---|---|---|---|---|---|---|---|
| 2006-09-07 04:00:00 | SPY | ETF | 130.04 | 130.04 | 130.04 | 130.04 | 500.0 |
| 2006-09-07 06:30:00 | SPY | ETF | 130.13 | 130.13 | 130.13 | 130.13 | 2000.0 |
| 2006-09-07 07:00:00 | SPY | ETF | 130.14 | 130.16 | 130.05 | 130.1 | 223300.0 |
| 2006-09-07 07:30:00 | SPY | ETF | 130.15 | 130.16 | 130.1 | 130.1 | 55300.0 |
| 2006-09-07 08:00:00 | SPY | ETF | 130.14 | 130.16 | 130.03 | 130.09 | 2170300.0 |
| 2006-09-07 08:30:00 | SPY | ETF | 130.1 | 130.12 | 130.02 | 130.08 | 818000.0 |
| 2006-09-07 09:00:00 | SPY | ETF | 130.09 | 130.18 | 130.05 | 130.05 | 306500.0 |
| 2006-09-07 09:30:00 | SPY | ETF | 130.06 | 130.2 | 129.98 | 130.06 | 5789300.0 |
| 2006-09-07 10:00:00 | SPY | ETF | 130.1 | 130.1 | 129.71 | 129.81 | 7063600.0 |
| 2006-09-07 10:30:00 | SPY | ETF | 129.81 | 129.95 | 129.35 | 129.8 | 9121200.0 |
| 2006-09-07 11:00:00 | SPY | ETF | 129.8 | 129.99 | 129.75 | 129.84 | 5248000.0 |
| 2006-09-07 11:30:00 | SPY | ETF | 129.84 | 130.16 | 129.82 | 130.12 | 5856200.0 |
| 2006-09-07 12:00:00 | SPY | ETF | 130.12 | 130.23 | 130.02 | 130.07 | 6491800.0 |
| 2006-09-07 12:30:00 | SPY | ETF | 130.06 | 130.16 | 129.94 | 129.98 | 3350600.0 |
| 2006-09-07 13:00:00 | SPY | ETF | 129.98 | 130.12 | 129.9 | 130.02 | 2912200.0 |
| 2006-09-07 13:30:00 | SPY | ETF | 130.01 | 130.57 | 129.97 | 130.42 | 9758200.0 |
| 2006-09-07 14:00:00 | SPY | ETF | 130.42 | 130.45 | 130.16 | 130.2 | 6016300.0 |
| 2006-09-07 14:30:00 | SPY | ETF | 130.2 | 130.27 | 130.0 | 130.24 | 4767600.0 |
| 2006-09-07 15:00:00 | SPY | ETF | 130.21 | 130.26 | 129.88 | 130.03 | 6047700.0 |
| 2006-09-07 15:30:00 | SPY | ETF | 130.02 | 130.04 | 129.71 | 129.82 | 7508500.0 |
| 2006-09-07 16:00:00 | SPY | ETF | 129.85 | 129.99 | 129.81 | 129.85 | 423000.0 |
| 2006-09-07 16:30:00 | SPY | ETF | 129.85 | 129.98 | 129.85 | 129.91 | 1644200.0 |
| 2006-09-07 17:00:00 | SPY | ETF | 129.97 | 129.98 | 129.94 | 129.96 | 3100.0 |
| 2006-09-07 17:30:00 | SPY | ETF | 129.94 | 130.02 | 129.9 | 129.95 | 12100.0 |
| 2006-09-07 18:00:00 | SPY | ETF | 129.95 | 129.99 | 129.94 | 129.99 | 23200.0 |
| 2006-09-07 18:30:00 | SPY | ETF | 130.0 | 130.03 | 130.0 | 130.03 | 4400.0 |
| 2006-09-07 19:00:00 | SPY | ETF | 130.01 | 130.04 | 130.01 | 130.04 | 1400.0 |
| 2006-09-07 19:30:00 | SPY | ETF | 130.01 | 130.01 | 130.01 | 130.01 | 300.0 |
| 2006-09-07 09:30:00 | QQQ | ETF | 38.57 | 38.61 | 38.45 | 38.51 | 15106100.0 |
| 2006-09-07 10:00:00 | QQQ | ETF | 38.51 | 38.52 | 38.36 | 38.44 | 10392900.0 |
| 2006-09-07 10:30:00 | QQQ | ETF | 38.45 | 38.55 | 38.39 | 38.48 | 8922400.0 |
| 2006-09-07 11:00:00 | QQQ | ETF | 38.47 | 38.61 | 38.47 | 38.57 | 14295000.0 |
| 2006-09-07 11:30:00 | QQQ | ETF | 38.58 | 38.75 | 38.57 | 38.72 | 9770600.0 |
| 2006-09-07 12:00:00 | QQQ | ETF | 38.72 | 38.84 | 38.7 | 38.73 | 8715700.0 |
| 2006-09-07 12:30:00 | QQQ | ETF | 38.73 | 38.76 | 38.61 | 38.65 | 4555400.0 |
| 2006-09-07 13:00:00 | QQQ | ETF | 38.65 | 38.73 | 38.6 | 38.67 | 3869500.0 |
| 2006-09-07 13:30:00 | QQQ | ETF | 38.67 | 38.9 | 38.66 | 38.81 | 8622000.0 |
| 2006-09-07 14:00:00 | QQQ | ETF | 38.82 | 38.85 | 38.73 | 38.75 | 5409300.0 |
| 2006-09-07 14:30:00 | QQQ | ETF | 38.75 | 38.8 | 38.66 | 38.74 | 5869800.0 |
| 2006-09-07 15:00:00 | QQQ | ETF | 38.74 | 38.74 | 38.52 | 38.6 | 7465800.0 |
| 2006-09-07 15:30:00 | QQQ | ETF | 38.6 | 38.61 | 38.47 | 38.48 | 7423700.0 |
| 2006-09-07 07:30:00 | IWM | ETF | 70.74 | 70.74 | 70.63 | 70.63 | 8500.0 |
| 2006-09-07 08:00:00 | IWM | ETF | 70.63 | 70.67 | 70.63 | 70.65 | 29500.0 |
| 2006-09-07 08:30:00 | IWM | ETF | 70.68 | 70.69 | 70.55 | 70.6 | 84100.0 |
| 2006-09-07 09:00:00 | IWM | ETF | 70.57 | 70.6 | 70.53 | 70.53 | 137600.0 |
| 2006-09-07 09:30:00 | IWM | ETF | 70.53 | 70.61 | 70.36 | 70.42 | 3683600.0 |
| 2006-09-07 10:00:00 | IWM | ETF | 70.43 | 70.43 | 70.06 | 70.19 | 4560200.0 |
| 2006-09-07 10:30:00 | IWM | ETF | 70.19 | 70.41 | 70.14 | 70.33 | 3452800.0 |
| 2006-09-07 11:00:00 | IWM | ETF | 70.33 | 70.54 | 70.33 | 70.46 | 1889500.0 |
| 2006-09-07 11:30:00 | IWM | ETF | 70.46 | 70.79 | 70.46 | 70.77 | 1809800.0 |
> showing 50 of 2,790 rows — these rows as CSV