PREVIEW / etf_30min / 2005-03-04
file: by_date/etf_30min/2005/2005-03-04.parquet size: 44 KB rows: 1,512
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-03-04 08:00:00 | SPY | ETF | 121.38 | 121.68 | 121.38 | 121.58 | 350600.0 |
| 2005-03-04 08:30:00 | SPY | ETF | 121.63 | 122.16 | 121.62 | 122.08 | 1306100.0 |
| 2005-03-04 09:00:00 | SPY | ETF | 122.06 | 122.1 | 121.98 | 122.05 | 250900.0 |
| 2005-03-04 09:30:00 | SPY | ETF | 122.05 | 122.18 | 121.8 | 122.06 | 6694100.0 |
| 2005-03-04 10:00:00 | SPY | ETF | 122.06 | 122.55 | 122.0 | 122.36 | 11780600.0 |
| 2005-03-04 10:30:00 | SPY | ETF | 122.37 | 122.39 | 122.11 | 122.16 | 3909700.0 |
| 2005-03-04 11:00:00 | SPY | ETF | 122.16 | 122.39 | 122.04 | 122.39 | 2785900.0 |
| 2005-03-04 11:30:00 | SPY | ETF | 122.39 | 122.43 | 122.25 | 122.29 | 1643900.0 |
| 2005-03-04 12:00:00 | SPY | ETF | 122.28 | 122.46 | 122.24 | 122.35 | 2384100.0 |
| 2005-03-04 12:30:00 | SPY | ETF | 122.35 | 122.55 | 122.31 | 122.46 | 2749900.0 |
| 2005-03-04 13:00:00 | SPY | ETF | 122.46 | 122.57 | 122.35 | 122.37 | 1962900.0 |
| 2005-03-04 13:30:00 | SPY | ETF | 122.37 | 122.74 | 122.34 | 122.7 | 2946000.0 |
| 2005-03-04 14:00:00 | SPY | ETF | 122.72 | 122.83 | 122.51 | 122.63 | 5313300.0 |
| 2005-03-04 14:30:00 | SPY | ETF | 122.62 | 122.72 | 122.58 | 122.65 | 1736600.0 |
| 2005-03-04 15:00:00 | SPY | ETF | 122.62 | 122.76 | 122.6 | 122.73 | 2483000.0 |
| 2005-03-04 15:30:00 | SPY | ETF | 122.73 | 122.74 | 122.47 | 122.55 | 3733600.0 |
| 2005-03-04 16:00:00 | SPY | ETF | 122.56 | 122.89 | 121.58 | 122.8 | 1662000.0 |
| 2005-03-04 16:30:00 | SPY | ETF | 122.81 | 122.9 | 122.68 | 122.77 | 336800.0 |
| 2005-03-04 17:00:00 | SPY | ETF | 122.8 | 122.83 | 122.77 | 122.83 | 2000.0 |
| 2005-03-04 17:30:00 | SPY | ETF | 122.77 | 122.83 | 122.77 | 122.8 | 1700.0 |
| 2005-03-04 18:00:00 | SPY | ETF | 122.8 | 122.83 | 122.8 | 122.82 | 1500.0 |
| 2005-03-04 18:30:00 | SPY | ETF | 122.84 | 122.84 | 122.8 | 122.8 | 5900.0 |
| 2005-03-04 19:00:00 | SPY | ETF | 122.84 | 122.84 | 122.79 | 122.79 | 800.0 |
| 2005-03-04 19:30:00 | SPY | ETF | 122.78 | 122.8 | 122.75 | 122.8 | 500.0 |
| 2005-03-04 09:30:00 | QQQ | ETF | 37.6 | 37.65 | 37.4 | 37.59 | 17466900.0 |
| 2005-03-04 10:00:00 | QQQ | ETF | 37.58 | 37.75 | 37.56 | 37.65 | 15468800.0 |
| 2005-03-04 10:30:00 | QQQ | ETF | 37.66 | 37.67 | 37.51 | 37.53 | 6445300.0 |
| 2005-03-04 11:00:00 | QQQ | ETF | 37.53 | 37.57 | 37.46 | 37.57 | 4240500.0 |
| 2005-03-04 11:30:00 | QQQ | ETF | 37.57 | 37.59 | 37.51 | 37.53 | 3649200.0 |
| 2005-03-04 12:00:00 | QQQ | ETF | 37.52 | 37.6 | 37.46 | 37.54 | 3184900.0 |
| 2005-03-04 12:30:00 | QQQ | ETF | 37.54 | 37.62 | 37.53 | 37.57 | 2461100.0 |
| 2005-03-04 13:00:00 | QQQ | ETF | 37.57 | 37.62 | 37.51 | 37.53 | 2301200.0 |
| 2005-03-04 13:30:00 | QQQ | ETF | 37.52 | 37.66 | 37.48 | 37.65 | 4235000.0 |
| 2005-03-04 14:00:00 | QQQ | ETF | 37.65 | 37.68 | 37.57 | 37.59 | 3792400.0 |
| 2005-03-04 14:30:00 | QQQ | ETF | 37.58 | 37.64 | 37.56 | 37.59 | 2973900.0 |
| 2005-03-04 15:00:00 | QQQ | ETF | 37.59 | 37.65 | 37.57 | 37.62 | 2278100.0 |
| 2005-03-04 15:30:00 | QQQ | ETF | 37.62 | 37.62 | 37.49 | 37.52 | 5304900.0 |
| 2005-03-04 08:00:00 | IWM | ETF | 63.75 | 63.75 | 63.75 | 63.75 | 3600.0 |
| 2005-03-04 08:30:00 | IWM | ETF | 63.76 | 64.15 | 63.65 | 64.15 | 55200.0 |
| 2005-03-04 09:00:00 | IWM | ETF | 64.095 | 64.11 | 64.02 | 64.06 | 43000.0 |
| 2005-03-04 09:30:00 | IWM | ETF | 64.075 | 64.175 | 63.76 | 63.99 | 3188400.0 |
| 2005-03-04 10:00:00 | IWM | ETF | 64.0 | 64.255 | 63.95 | 64.075 | 2771800.0 |
| 2005-03-04 10:30:00 | IWM | ETF | 64.09 | 64.175 | 63.865 | 63.915 | 1672000.0 |
| 2005-03-04 11:00:00 | IWM | ETF | 63.925 | 64.065 | 63.88 | 64.065 | 659000.0 |
| 2005-03-04 11:30:00 | IWM | ETF | 64.065 | 64.17 | 63.97 | 64.075 | 688200.0 |
| 2005-03-04 12:00:00 | IWM | ETF | 64.09 | 64.17 | 64.04 | 64.07 | 548400.0 |
| 2005-03-04 12:30:00 | IWM | ETF | 64.065 | 64.285 | 64.06 | 64.24 | 341200.0 |
| 2005-03-04 13:00:00 | IWM | ETF | 64.235 | 64.325 | 64.185 | 64.1905 | 1586800.0 |
| 2005-03-04 13:30:00 | IWM | ETF | 64.195 | 64.425 | 64.185 | 64.41 | 558800.0 |
| 2005-03-04 14:00:00 | IWM | ETF | 64.41 | 64.455 | 64.265 | 64.27 | 1249200.0 |
> showing 50 of 1,512 rows — these rows as CSV