PREVIEW / etf_30min / 2005-11-22
file: by_date/etf_30min/2005/2005-11-22.parquet size: 53 KB rows: 1,853
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-11-22 07:00:00 | SPY | ETF | 125.63 | 125.63 | 125.6 | 125.61 | 3600.0 |
| 2005-11-22 07:30:00 | SPY | ETF | 125.59 | 125.59 | 125.57 | 125.58 | 3700.0 |
| 2005-11-22 08:00:00 | SPY | ETF | 125.58 | 125.63 | 125.52 | 125.57 | 330400.0 |
| 2005-11-22 08:30:00 | SPY | ETF | 125.55 | 125.6 | 125.5 | 125.56 | 24900.0 |
| 2005-11-22 09:00:00 | SPY | ETF | 125.57 | 125.63 | 125.54 | 125.56 | 210800.0 |
| 2005-11-22 09:30:00 | SPY | ETF | 125.56 | 125.6 | 125.42 | 125.45 | 7037700.0 |
| 2005-11-22 10:00:00 | SPY | ETF | 125.45 | 125.68 | 125.42 | 125.61 | 5719900.0 |
| 2005-11-22 10:30:00 | SPY | ETF | 125.61 | 125.76 | 125.54 | 125.68 | 2621500.0 |
| 2005-11-22 11:00:00 | SPY | ETF | 125.68 | 125.8 | 125.57 | 125.65 | 2301700.0 |
| 2005-11-22 11:30:00 | SPY | ETF | 125.65 | 125.74 | 125.62 | 125.68 | 1246300.0 |
| 2005-11-22 12:00:00 | SPY | ETF | 125.68 | 125.75 | 125.62 | 125.68 | 1076200.0 |
| 2005-11-22 12:30:00 | SPY | ETF | 125.7 | 125.72 | 125.63 | 125.66 | 539500.0 |
| 2005-11-22 13:00:00 | SPY | ETF | 125.65 | 125.89 | 125.65 | 125.76 | 2204200.0 |
| 2005-11-22 13:30:00 | SPY | ETF | 125.77 | 125.77 | 125.66 | 125.67 | 2111600.0 |
| 2005-11-22 14:00:00 | SPY | ETF | 125.67 | 126.28 | 125.64 | 126.09 | 23196600.0 |
| 2005-11-22 14:30:00 | SPY | ETF | 126.08 | 126.35 | 125.99 | 126.34 | 4048800.0 |
| 2005-11-22 15:00:00 | SPY | ETF | 126.35 | 126.52 | 126.25 | 126.34 | 4080600.0 |
| 2005-11-22 15:30:00 | SPY | ETF | 126.36 | 126.52 | 126.26 | 126.37 | 4960900.0 |
| 2005-11-22 16:00:00 | SPY | ETF | 126.36 | 126.42 | 125.92 | 126.3 | 796400.0 |
| 2005-11-22 16:30:00 | SPY | ETF | 126.29 | 126.29 | 126.23 | 126.25 | 85300.0 |
| 2005-11-22 17:00:00 | SPY | ETF | 126.26 | 126.31 | 126.26 | 126.3 | 10700.0 |
| 2005-11-22 17:30:00 | SPY | ETF | 126.28 | 126.28 | 126.27 | 126.27 | 200.0 |
| 2005-11-22 18:00:00 | SPY | ETF | 126.27 | 126.27 | 126.27 | 126.27 | 1000.0 |
| 2005-11-22 09:30:00 | QQQ | ETF | 41.46 | 41.48 | 41.36 | 41.43 | 8798000.0 |
| 2005-11-22 10:00:00 | QQQ | ETF | 41.43 | 41.58 | 41.41 | 41.55 | 7370200.0 |
| 2005-11-22 10:30:00 | QQQ | ETF | 41.55 | 41.6 | 41.52 | 41.55 | 5704300.0 |
| 2005-11-22 11:00:00 | QQQ | ETF | 41.55 | 41.59 | 41.47 | 41.51 | 3186500.0 |
| 2005-11-22 11:30:00 | QQQ | ETF | 41.52 | 41.58 | 41.51 | 41.56 | 2114300.0 |
| 2005-11-22 12:00:00 | QQQ | ETF | 41.56 | 41.59 | 41.53 | 41.56 | 2407000.0 |
| 2005-11-22 12:30:00 | QQQ | ETF | 41.56 | 41.58 | 41.53 | 41.53 | 1544300.0 |
| 2005-11-22 13:00:00 | QQQ | ETF | 41.53 | 41.63 | 41.53 | 41.6 | 3638900.0 |
| 2005-11-22 13:30:00 | QQQ | ETF | 41.59 | 41.6 | 41.51 | 41.52 | 2563100.0 |
| 2005-11-22 14:00:00 | QQQ | ETF | 41.51 | 41.78 | 41.51 | 41.7 | 18231600.0 |
| 2005-11-22 14:30:00 | QQQ | ETF | 41.7 | 41.8 | 41.66 | 41.79 | 6527000.0 |
| 2005-11-22 15:00:00 | QQQ | ETF | 41.79 | 41.87 | 41.75 | 41.77 | 7245500.0 |
| 2005-11-22 15:30:00 | QQQ | ETF | 41.77 | 41.81 | 41.7 | 41.71 | 8413200.0 |
| 2005-11-22 08:00:00 | IWM | ETF | 67.45 | 67.48 | 67.43 | 67.43 | 44100.0 |
| 2005-11-22 08:30:00 | IWM | ETF | 67.43 | 67.48 | 67.41 | 67.43 | 23100.0 |
| 2005-11-22 09:00:00 | IWM | ETF | 67.43 | 67.47 | 67.42 | 67.45 | 11500.0 |
| 2005-11-22 09:30:00 | IWM | ETF | 67.46 | 67.57 | 67.29 | 67.33 | 2572800.0 |
| 2005-11-22 10:00:00 | IWM | ETF | 67.33 | 67.55 | 67.3 | 67.47 | 815000.0 |
| 2005-11-22 10:30:00 | IWM | ETF | 67.49 | 67.59 | 67.43 | 67.53 | 1577800.0 |
| 2005-11-22 11:00:00 | IWM | ETF | 67.54 | 67.59 | 67.44 | 67.5412 | 773300.0 |
| 2005-11-22 11:30:00 | IWM | ETF | 67.54 | 67.63 | 67.52 | 67.62 | 763700.0 |
| 2005-11-22 12:00:00 | IWM | ETF | 67.63 | 67.65 | 67.49 | 67.54 | 1324700.0 |
| 2005-11-22 12:30:00 | IWM | ETF | 67.55 | 67.62 | 67.49 | 67.56 | 2672900.0 |
| 2005-11-22 13:00:00 | IWM | ETF | 67.57 | 67.72 | 67.56 | 67.59 | 1677400.0 |
| 2005-11-22 13:30:00 | IWM | ETF | 67.6 | 67.63 | 67.51 | 67.54 | 596100.0 |
| 2005-11-22 14:00:00 | IWM | ETF | 67.55 | 67.95 | 67.55 | 67.86 | 2884700.0 |
| 2005-11-22 14:30:00 | IWM | ETF | 67.85 | 68.04 | 67.81 | 68.0 | 1540800.0 |
> showing 50 of 1,853 rows — these rows as CSV