PREVIEW / etf_30min / 2005-09-22
file: by_date/etf_30min/2005/2005-09-22.parquet size: 50 KB rows: 1,750
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-22 04:00:00 | SPY | ETF | 120.97 | 120.97 | 120.97 | 120.97 | 21400.0 |
| 2005-09-22 07:00:00 | SPY | ETF | 120.84 | 120.84 | 120.7 | 120.7 | 74700.0 |
| 2005-09-22 07:30:00 | SPY | ETF | 120.69 | 120.71 | 120.63 | 120.69 | 65400.0 |
| 2005-09-22 08:00:00 | SPY | ETF | 120.7 | 120.85 | 120.6 | 120.66 | 1862600.0 |
| 2005-09-22 08:30:00 | SPY | ETF | 120.67 | 120.9 | 120.65 | 120.85 | 611500.0 |
| 2005-09-22 09:00:00 | SPY | ETF | 120.86 | 120.96 | 120.76 | 120.96 | 489000.0 |
| 2005-09-22 09:30:00 | SPY | ETF | 120.95 | 121.06 | 120.5 | 121.03 | 8158900.0 |
| 2005-09-22 10:00:00 | SPY | ETF | 121.02 | 121.37 | 120.97 | 121.05 | 12418300.0 |
| 2005-09-22 10:30:00 | SPY | ETF | 121.06 | 121.23 | 120.87 | 120.9 | 4143000.0 |
| 2005-09-22 11:00:00 | SPY | ETF | 120.91 | 121.12 | 120.88 | 120.94 | 3512100.0 |
| 2005-09-22 11:30:00 | SPY | ETF | 120.91 | 120.96 | 120.73 | 120.89 | 2793900.0 |
| 2005-09-22 12:00:00 | SPY | ETF | 120.9 | 120.9 | 120.44 | 120.67 | 6773600.0 |
| 2005-09-22 12:30:00 | SPY | ETF | 120.71 | 120.92 | 120.49 | 120.87 | 3195400.0 |
| 2005-09-22 13:00:00 | SPY | ETF | 120.88 | 121.22 | 120.76 | 121.03 | 5742800.0 |
| 2005-09-22 13:30:00 | SPY | ETF | 121.03 | 121.57 | 120.98 | 121.29 | 9967300.0 |
| 2005-09-22 14:00:00 | SPY | ETF | 121.3 | 121.45 | 121.05 | 121.16 | 5437900.0 |
| 2005-09-22 14:30:00 | SPY | ETF | 121.17 | 121.55 | 121.08 | 121.24 | 2339400.0 |
| 2005-09-22 15:00:00 | SPY | ETF | 121.24 | 121.66 | 121.08 | 121.58 | 5479300.0 |
| 2005-09-22 15:30:00 | SPY | ETF | 121.58 | 121.65 | 121.41 | 121.45 | 4445800.0 |
| 2005-09-22 16:00:00 | SPY | ETF | 121.45 | 121.45 | 120.85 | 121.39 | 399000.0 |
| 2005-09-22 16:30:00 | SPY | ETF | 121.35 | 121.38 | 121.29 | 121.31 | 257500.0 |
| 2005-09-22 17:00:00 | SPY | ETF | 121.35 | 121.35 | 121.24 | 121.24 | 618000.0 |
| 2005-09-22 17:30:00 | SPY | ETF | 120.62 | 121.57 | 120.45 | 121.27 | 600900.0 |
| 2005-09-22 18:00:00 | SPY | ETF | 121.28 | 121.28 | 121.26 | 121.26 | 2800.0 |
| 2005-09-22 18:30:00 | SPY | ETF | 121.28 | 121.28 | 121.27 | 121.27 | 700.0 |
| 2005-09-22 19:00:00 | SPY | ETF | 121.27 | 121.27 | 121.24 | 121.24 | 2900.0 |
| 2005-09-22 19:30:00 | SPY | ETF | 121.27 | 121.27 | 121.26 | 121.26 | 1300.0 |
| 2005-09-22 09:30:00 | QQQ | ETF | 38.44 | 38.49 | 38.24 | 38.48 | 15268000.0 |
| 2005-09-22 10:00:00 | QQQ | ETF | 38.49 | 38.69 | 38.46 | 38.49 | 14205500.0 |
| 2005-09-22 10:30:00 | QQQ | ETF | 38.49 | 38.59 | 38.38 | 38.39 | 6051000.0 |
| 2005-09-22 11:00:00 | QQQ | ETF | 38.39 | 38.53 | 38.38 | 38.43 | 5974500.0 |
| 2005-09-22 11:30:00 | QQQ | ETF | 38.43 | 38.44 | 38.31 | 38.37 | 4163500.0 |
| 2005-09-22 12:00:00 | QQQ | ETF | 38.37 | 38.38 | 38.26 | 38.3 | 4566800.0 |
| 2005-09-22 12:30:00 | QQQ | ETF | 38.3 | 38.48 | 38.24 | 38.48 | 7454800.0 |
| 2005-09-22 13:00:00 | QQQ | ETF | 38.48 | 38.61 | 38.44 | 38.48 | 8467000.0 |
| 2005-09-22 13:30:00 | QQQ | ETF | 38.48 | 38.73 | 38.46 | 38.63 | 12801100.0 |
| 2005-09-22 14:00:00 | QQQ | ETF | 38.62 | 38.68 | 38.53 | 38.58 | 3300700.0 |
| 2005-09-22 14:30:00 | QQQ | ETF | 38.58 | 38.63 | 38.53 | 38.59 | 3362800.0 |
| 2005-09-22 15:00:00 | QQQ | ETF | 38.59 | 38.71 | 38.5 | 38.66 | 6085200.0 |
| 2005-09-22 15:30:00 | QQQ | ETF | 38.66 | 38.7 | 38.62 | 38.64 | 7286600.0 |
| 2005-09-22 08:00:00 | IWM | ETF | 64.44 | 64.44 | 64.44 | 64.44 | 300.0 |
| 2005-09-22 08:30:00 | IWM | ETF | 64.55 | 64.58 | 64.48 | 64.58 | 400.0 |
| 2005-09-22 09:00:00 | IWM | ETF | 64.58 | 64.65 | 64.55 | 64.65 | 111400.0 |
| 2005-09-22 09:30:00 | IWM | ETF | 64.67 | 64.74 | 64.1 | 64.45 | 2323800.0 |
| 2005-09-22 10:00:00 | IWM | ETF | 64.46 | 64.83 | 64.43 | 64.63 | 5246700.0 |
| 2005-09-22 10:30:00 | IWM | ETF | 64.63 | 64.84 | 64.53 | 64.54 | 3375600.0 |
| 2005-09-22 11:00:00 | IWM | ETF | 64.54 | 64.7 | 64.52 | 64.59 | 2335100.0 |
| 2005-09-22 11:30:00 | IWM | ETF | 64.59 | 64.6 | 64.44 | 64.51 | 989900.0 |
| 2005-09-22 12:00:00 | IWM | ETF | 64.51 | 64.52 | 64.23 | 64.29 | 2563200.0 |
| 2005-09-22 12:30:00 | IWM | ETF | 64.29 | 64.54 | 64.29 | 64.52 | 657100.0 |
> showing 50 of 1,750 rows — these rows as CSV