PREVIEW / etf_30min / 2005-12-22
file: by_date/etf_30min/2005/2005-12-22.parquet size: 55 KB rows: 2,009
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-12-22 07:00:00 | SPY | ETF | 126.21 | 126.21 | 126.17 | 126.17 | 57400.0 |
| 2005-12-22 07:30:00 | SPY | ETF | 126.16 | 126.17 | 126.12 | 126.14 | 133100.0 |
| 2005-12-22 08:00:00 | SPY | ETF | 126.13 | 126.21 | 126.12 | 126.2 | 97000.0 |
| 2005-12-22 08:30:00 | SPY | ETF | 126.21 | 126.34 | 126.15 | 126.34 | 274900.0 |
| 2005-12-22 09:00:00 | SPY | ETF | 126.36 | 126.47 | 126.04 | 126.32 | 724500.0 |
| 2005-12-22 09:30:00 | SPY | ETF | 126.31 | 126.43 | 126.16 | 126.29 | 4046900.0 |
| 2005-12-22 10:00:00 | SPY | ETF | 126.29 | 126.35 | 126.08 | 126.19 | 3178800.0 |
| 2005-12-22 10:30:00 | SPY | ETF | 126.18 | 126.39 | 126.09 | 126.35 | 2381400.0 |
| 2005-12-22 11:00:00 | SPY | ETF | 126.32 | 126.49 | 126.19 | 126.45 | 2849500.0 |
| 2005-12-22 11:30:00 | SPY | ETF | 126.45 | 126.49 | 126.33 | 126.38 | 2135600.0 |
| 2005-12-22 12:00:00 | SPY | ETF | 126.39 | 126.42 | 126.26 | 126.3599 | 1235600.0 |
| 2005-12-22 12:30:00 | SPY | ETF | 126.37 | 126.39 | 126.23 | 126.37 | 1436700.0 |
| 2005-12-22 13:00:00 | SPY | ETF | 126.36 | 126.45 | 126.22 | 126.35 | 871300.0 |
| 2005-12-22 13:30:00 | SPY | ETF | 126.35 | 126.51 | 126.33 | 126.45 | 1964600.0 |
| 2005-12-22 14:00:00 | SPY | ETF | 126.46 | 126.55 | 126.39 | 126.41 | 1380100.0 |
| 2005-12-22 14:30:00 | SPY | ETF | 126.42 | 126.57 | 126.35 | 126.53 | 1581200.0 |
| 2005-12-22 15:00:00 | SPY | ETF | 126.53 | 126.62 | 126.45 | 126.58 | 1859100.0 |
| 2005-12-22 15:30:00 | SPY | ETF | 126.58 | 126.66 | 126.52 | 126.65 | 4368200.0 |
| 2005-12-22 16:00:00 | SPY | ETF | 126.64 | 126.69 | 126.54 | 126.69 | 755400.0 |
| 2005-12-22 16:30:00 | SPY | ETF | 126.66 | 126.7 | 126.66 | 126.67 | 160300.0 |
| 2005-12-22 17:00:00 | SPY | ETF | 126.67 | 126.72 | 126.67 | 126.72 | 2100.0 |
| 2005-12-22 17:30:00 | SPY | ETF | 126.69 | 126.73 | 126.69 | 126.7 | 2200.0 |
| 2005-12-22 18:00:00 | SPY | ETF | 126.69 | 126.69 | 126.67 | 126.67 | 2100.0 |
| 2005-12-22 19:30:00 | SPY | ETF | 126.68 | 126.68 | 126.68 | 126.68 | 100.0 |
| 2005-12-22 09:30:00 | QQQ | ETF | 41.12 | 41.22 | 41.1 | 41.15 | 6090600.0 |
| 2005-12-22 10:00:00 | QQQ | ETF | 41.16 | 41.21 | 40.98 | 41.18 | 4818700.0 |
| 2005-12-22 10:30:00 | QQQ | ETF | 41.18 | 41.25 | 41.14 | 41.22 | 3470300.0 |
| 2005-12-22 11:00:00 | QQQ | ETF | 41.22 | 41.26 | 41.17 | 41.23 | 3539500.0 |
| 2005-12-22 11:30:00 | QQQ | ETF | 41.24 | 41.27 | 41.2 | 41.25 | 3851000.0 |
| 2005-12-22 12:00:00 | QQQ | ETF | 41.25 | 42.23 | 41.21 | 41.23 | 1559900.0 |
| 2005-12-22 12:30:00 | QQQ | ETF | 41.22 | 41.23 | 41.17 | 41.2 | 1968800.0 |
| 2005-12-22 13:00:00 | QQQ | ETF | 41.2 | 41.23 | 41.19 | 41.22 | 1174400.0 |
| 2005-12-22 13:30:00 | QQQ | ETF | 41.22 | 41.28 | 41.21 | 41.25 | 3381400.0 |
| 2005-12-22 14:00:00 | QQQ | ETF | 41.25 | 41.28 | 41.23 | 41.25 | 1444300.0 |
| 2005-12-22 14:30:00 | QQQ | ETF | 41.25 | 41.3 | 41.23 | 41.3 | 2347400.0 |
| 2005-12-22 15:00:00 | QQQ | ETF | 41.3 | 41.37 | 41.29 | 41.36 | 4885900.0 |
| 2005-12-22 15:30:00 | QQQ | ETF | 41.36 | 41.46 | 41.35 | 41.39 | 7420500.0 |
| 2005-12-22 07:00:00 | IWM | ETF | 67.67 | 67.68 | 67.67 | 67.68 | 6000.0 |
| 2005-12-22 07:30:00 | IWM | ETF | 67.68 | 67.68 | 67.66 | 67.67 | 34000.0 |
| 2005-12-22 08:00:00 | IWM | ETF | 67.69 | 67.69 | 67.65 | 67.67 | 11100.0 |
| 2005-12-22 08:30:00 | IWM | ETF | 67.67 | 67.72 | 67.64 | 67.71 | 23100.0 |
| 2005-12-22 09:00:00 | IWM | ETF | 67.75 | 67.82 | 67.71 | 67.73 | 118400.0 |
| 2005-12-22 09:30:00 | IWM | ETF | 67.75 | 67.89 | 67.61 | 67.64 | 1603600.0 |
| 2005-12-22 10:00:00 | IWM | ETF | 67.64 | 67.73 | 67.46 | 67.53 | 2401200.0 |
| 2005-12-22 10:30:00 | IWM | ETF | 67.53 | 67.63 | 67.39 | 67.57 | 999500.0 |
| 2005-12-22 11:00:00 | IWM | ETF | 67.57 | 67.74 | 67.48 | 67.7 | 1592400.0 |
| 2005-12-22 11:30:00 | IWM | ETF | 67.7 | 67.8 | 67.67 | 67.77 | 1012200.0 |
| 2005-12-22 12:00:00 | IWM | ETF | 67.77 | 67.78 | 67.61 | 67.699 | 741400.0 |
| 2005-12-22 12:30:00 | IWM | ETF | 67.69 | 67.73 | 67.57 | 67.71 | 725100.0 |
| 2005-12-22 13:00:00 | IWM | ETF | 67.72 | 67.75 | 67.55 | 67.57 | 912700.0 |
> showing 50 of 2,009 rows — these rows as CSV