PREVIEW / etf_30min / 2004-09-20
file: by_date/etf_30min/2004/2004-09-20.parquet size: 35 KB rows: 1,179
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-20 08:00:00 | SPY | ETF | 112.78 | 112.78 | 112.7 | 112.7 | 11400.0 |
| 2004-09-20 08:30:00 | SPY | ETF | 112.71 | 112.75 | 112.71 | 112.71 | 4600.0 |
| 2004-09-20 09:00:00 | SPY | ETF | 112.7 | 112.76 | 112.69 | 112.69 | 36700.0 |
| 2004-09-20 09:30:00 | SPY | ETF | 112.67 | 112.79 | 112.4 | 112.41 | 4735700.0 |
| 2004-09-20 10:00:00 | SPY | ETF | 112.41 | 112.87 | 112.36 | 112.72 | 4445800.0 |
| 2004-09-20 10:30:00 | SPY | ETF | 112.72 | 112.99 | 112.71 | 112.81 | 4038700.0 |
| 2004-09-20 11:00:00 | SPY | ETF | 112.82 | 112.89 | 112.71 | 112.74 | 2275400.0 |
| 2004-09-20 11:30:00 | SPY | ETF | 112.75 | 112.78 | 112.6 | 112.71 | 1310900.0 |
| 2004-09-20 12:00:00 | SPY | ETF | 112.71 | 112.8 | 112.69 | 112.77 | 448900.0 |
| 2004-09-20 12:30:00 | SPY | ETF | 112.79 | 112.85 | 112.48 | 112.48 | 728400.0 |
| 2004-09-20 13:00:00 | SPY | ETF | 112.5 | 112.62 | 112.43 | 112.57 | 2395500.0 |
| 2004-09-20 13:30:00 | SPY | ETF | 112.57 | 112.72 | 112.38 | 112.49 | 2363700.0 |
| 2004-09-20 14:00:00 | SPY | ETF | 112.49 | 112.57 | 112.28 | 112.42 | 2307500.0 |
| 2004-09-20 14:30:00 | SPY | ETF | 112.42 | 112.53 | 112.32 | 112.39 | 2469700.0 |
| 2004-09-20 15:00:00 | SPY | ETF | 112.37 | 112.63 | 112.31 | 112.6 | 2262100.0 |
| 2004-09-20 15:30:00 | SPY | ETF | 112.6 | 112.62 | 112.4 | 112.52 | 2407600.0 |
| 2004-09-20 16:00:00 | SPY | ETF | 112.52 | 112.52 | 112.42 | 112.48 | 811600.0 |
| 2004-09-20 16:30:00 | SPY | ETF | 112.49 | 112.52 | 112.45 | 112.5 | 1292800.0 |
| 2004-09-20 17:00:00 | SPY | ETF | 112.47 | 112.47 | 112.44 | 112.44 | 29900.0 |
| 2004-09-20 17:30:00 | SPY | ETF | 112.45 | 112.45 | 112.39 | 112.4 | 6900.0 |
| 2004-09-20 18:00:00 | SPY | ETF | 112.4 | 112.41 | 112.4 | 112.41 | 1700.0 |
| 2004-09-20 18:30:00 | SPY | ETF | 112.42 | 112.42 | 112.42 | 112.42 | 200.0 |
| 2004-09-20 08:00:00 | QQQ | ETF | 35.3 | 35.32 | 35.26 | 35.27 | 75700.0 |
| 2004-09-20 08:30:00 | QQQ | ETF | 35.27 | 35.3 | 35.26 | 35.29 | 57600.0 |
| 2004-09-20 09:00:00 | QQQ | ETF | 35.29 | 35.31 | 35.28 | 35.29 | 159800.0 |
| 2004-09-20 09:30:00 | QQQ | ETF | 35.29 | 35.35 | 35.2 | 35.23 | 14309200.0 |
| 2004-09-20 10:00:00 | QQQ | ETF | 35.22 | 35.57 | 35.22 | 35.51 | 12855100.0 |
| 2004-09-20 10:30:00 | QQQ | ETF | 35.515 | 35.7 | 35.49 | 35.64 | 11937400.0 |
| 2004-09-20 11:00:00 | QQQ | ETF | 35.64 | 35.77 | 35.63 | 35.65 | 9084700.0 |
| 2004-09-20 11:30:00 | QQQ | ETF | 35.66 | 35.67 | 35.56 | 35.64 | 4980200.0 |
| 2004-09-20 12:00:00 | QQQ | ETF | 35.64 | 35.67 | 35.62 | 35.63 | 2356900.0 |
| 2004-09-20 12:30:00 | QQQ | ETF | 35.63 | 35.66 | 35.42 | 35.44 | 3585100.0 |
| 2004-09-20 13:00:00 | QQQ | ETF | 35.44 | 35.45 | 35.3 | 35.42 | 3971600.0 |
| 2004-09-20 13:30:00 | QQQ | ETF | 35.43 | 35.48 | 35.319 | 35.38 | 5889700.0 |
| 2004-09-20 14:00:00 | QQQ | ETF | 35.372 | 35.44 | 35.26 | 35.35 | 8179500.0 |
| 2004-09-20 14:30:00 | QQQ | ETF | 35.355 | 35.47 | 35.33 | 35.362 | 7052100.0 |
| 2004-09-20 15:00:00 | QQQ | ETF | 35.37 | 35.49 | 35.33 | 35.458 | 5201900.0 |
| 2004-09-20 15:30:00 | QQQ | ETF | 35.458 | 35.47 | 35.374 | 35.43 | 7092100.0 |
| 2004-09-20 16:00:00 | QQQ | ETF | 35.438 | 35.53 | 35.4 | 35.52 | 3167400.0 |
| 2004-09-20 16:30:00 | QQQ | ETF | 35.53 | 35.53 | 35.43 | 35.53 | 918000.0 |
| 2004-09-20 17:00:00 | QQQ | ETF | 35.526 | 35.535 | 35.47 | 35.48 | 248600.0 |
| 2004-09-20 17:30:00 | QQQ | ETF | 35.47 | 35.48 | 35.44 | 35.46 | 217500.0 |
| 2004-09-20 18:00:00 | QQQ | ETF | 35.44 | 35.47 | 35.44 | 35.45 | 201400.0 |
| 2004-09-20 18:30:00 | QQQ | ETF | 35.46 | 35.46 | 35.44 | 35.45 | 24200.0 |
| 2004-09-20 19:00:00 | QQQ | ETF | 35.44 | 35.46 | 35.43 | 35.43 | 2700.0 |
| 2004-09-20 19:30:00 | QQQ | ETF | 35.44 | 35.44 | 35.43 | 35.43 | 13600.0 |
| 2004-09-20 08:30:00 | IWM | ETF | 56.83 | 56.955 | 56.83 | 56.905 | 2600.0 |
| 2004-09-20 09:00:00 | IWM | ETF | 56.885 | 56.97 | 56.885 | 56.945 | 10200.0 |
| 2004-09-20 09:30:00 | IWM | ETF | 56.955 | 57.16 | 56.9 | 56.925 | 923400.0 |
| 2004-09-20 10:00:00 | IWM | ETF | 56.91 | 57.145 | 56.875 | 57.05 | 1506400.0 |
> showing 50 of 1,179 rows — these rows as CSV