PREVIEW / etf_30min / 2005-01-13
file: by_date/etf_30min/2005/2005-01-13.parquet size: 42 KB rows: 1,407
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-01-13 08:00:00 | SPY | ETF | 118.52 | 118.59 | 118.51 | 118.54 | 45400.0 |
| 2005-01-13 08:30:00 | SPY | ETF | 118.48 | 118.63 | 118.48 | 118.63 | 49100.0 |
| 2005-01-13 09:00:00 | SPY | ETF | 118.62 | 118.7 | 118.57 | 118.63 | 36100.0 |
| 2005-01-13 09:30:00 | SPY | ETF | 118.64 | 118.73 | 118.38 | 118.57 | 5811400.0 |
| 2005-01-13 10:00:00 | SPY | ETF | 118.57 | 118.73 | 118.42 | 118.64 | 4257300.0 |
| 2005-01-13 10:30:00 | SPY | ETF | 118.64 | 118.73 | 118.4 | 118.451 | 4284500.0 |
| 2005-01-13 11:00:00 | SPY | ETF | 118.45 | 118.63 | 118.4 | 118.58 | 2629700.0 |
| 2005-01-13 11:30:00 | SPY | ETF | 118.58 | 118.61 | 118.25 | 118.36 | 5032400.0 |
| 2005-01-13 12:00:00 | SPY | ETF | 118.36 | 118.45 | 118.31 | 118.43 | 1732600.0 |
| 2005-01-13 12:30:00 | SPY | ETF | 118.43 | 118.54 | 118.39 | 118.5 | 1353400.0 |
| 2005-01-13 13:00:00 | SPY | ETF | 118.5 | 118.58 | 118.42 | 118.43 | 2019000.0 |
| 2005-01-13 13:30:00 | SPY | ETF | 118.44 | 118.65 | 118.36 | 118.65 | 1186200.0 |
| 2005-01-13 14:00:00 | SPY | ETF | 118.64 | 118.69 | 118.53 | 118.68 | 1895400.0 |
| 2005-01-13 14:30:00 | SPY | ETF | 118.67 | 118.7 | 118.4 | 118.43 | 2768900.0 |
| 2005-01-13 15:00:00 | SPY | ETF | 118.43 | 118.56 | 117.83 | 117.86 | 5538700.0 |
| 2005-01-13 15:30:00 | SPY | ETF | 117.86 | 117.94 | 117.5 | 117.69 | 12236100.0 |
| 2005-01-13 16:00:00 | SPY | ETF | 117.7 | 117.74 | 117.61 | 117.67 | 1266200.0 |
| 2005-01-13 16:30:00 | SPY | ETF | 117.68 | 117.73 | 117.63 | 117.66 | 755800.0 |
| 2005-01-13 17:00:00 | SPY | ETF | 117.66 | 117.67 | 117.56 | 117.58 | 211000.0 |
| 2005-01-13 17:30:00 | SPY | ETF | 117.56 | 117.59 | 117.52 | 117.54 | 14600.0 |
| 2005-01-13 18:00:00 | SPY | ETF | 117.54 | 117.66 | 117.54 | 117.66 | 16800.0 |
| 2005-01-13 19:00:00 | SPY | ETF | 117.63 | 117.63 | 117.63 | 117.63 | 2400.0 |
| 2005-01-13 19:30:00 | SPY | ETF | 117.66 | 117.66 | 117.61 | 117.61 | 3400.0 |
| 2005-01-13 09:30:00 | QQQ | ETF | 38.59 | 38.62 | 38.41 | 38.51 | 10980200.0 |
| 2005-01-13 10:00:00 | QQQ | ETF | 38.5 | 38.62 | 37.58 | 38.55 | 7536200.0 |
| 2005-01-13 10:30:00 | QQQ | ETF | 38.55 | 38.62 | 38.39 | 38.43 | 7893500.0 |
| 2005-01-13 11:00:00 | QQQ | ETF | 38.43 | 38.51 | 38.4 | 38.47 | 3927100.0 |
| 2005-01-13 11:30:00 | QQQ | ETF | 38.47 | 38.48 | 38.31 | 38.38 | 7942700.0 |
| 2005-01-13 12:00:00 | QQQ | ETF | 38.37 | 38.43 | 38.36 | 38.42 | 2713600.0 |
| 2005-01-13 12:30:00 | QQQ | ETF | 38.41 | 38.46 | 38.41 | 38.44 | 2052600.0 |
| 2005-01-13 13:00:00 | QQQ | ETF | 38.44 | 38.49 | 38.38 | 38.39 | 3793500.0 |
| 2005-01-13 13:30:00 | QQQ | ETF | 38.4 | 38.52 | 38.38 | 38.51 | 3451300.0 |
| 2005-01-13 14:00:00 | QQQ | ETF | 38.51 | 38.54 | 38.46 | 38.53 | 3086700.0 |
| 2005-01-13 14:30:00 | QQQ | ETF | 38.53 | 38.56 | 38.39 | 38.4 | 5815300.0 |
| 2005-01-13 15:00:00 | QQQ | ETF | 38.4 | 38.42 | 38.17 | 38.18 | 9279100.0 |
| 2005-01-13 15:30:00 | QQQ | ETF | 38.18 | 38.18 | 38.01 | 38.07 | 21599100.0 |
| 2005-01-13 08:30:00 | IWM | ETF | 61.025 | 61.025 | 61.025 | 61.025 | 400.0 |
| 2005-01-13 09:00:00 | IWM | ETF | 61.09 | 61.135 | 61.09 | 61.135 | 5800.0 |
| 2005-01-13 09:30:00 | IWM | ETF | 61.145 | 61.27 | 60.755 | 60.96 | 2208400.0 |
| 2005-01-13 10:00:00 | IWM | ETF | 60.96 | 61.105 | 60.855 | 60.96 | 1725600.0 |
| 2005-01-13 10:30:00 | IWM | ETF | 60.96 | 61.15 | 60.905 | 60.965 | 1504400.0 |
| 2005-01-13 11:00:00 | IWM | ETF | 60.985 | 61.17 | 60.94 | 61.115 | 1171600.0 |
| 2005-01-13 11:30:00 | IWM | ETF | 61.135 | 61.145 | 60.875 | 60.94 | 1162600.0 |
| 2005-01-13 12:00:00 | IWM | ETF | 60.935 | 61.02 | 60.895 | 60.985 | 230000.0 |
| 2005-01-13 12:30:00 | IWM | ETF | 60.995 | 61.14 | 60.995 | 61.075 | 351400.0 |
| 2005-01-13 13:00:00 | IWM | ETF | 61.085 | 61.175 | 61.035 | 61.045 | 377400.0 |
| 2005-01-13 13:30:00 | IWM | ETF | 61.05 | 61.4 | 61.04 | 61.4 | 996800.0 |
| 2005-01-13 14:00:00 | IWM | ETF | 61.4 | 61.435 | 61.295 | 61.405 | 975800.0 |
| 2005-01-13 14:30:00 | IWM | ETF | 61.405 | 61.425 | 61.095 | 61.17 | 1514600.0 |
| 2005-01-13 15:00:00 | IWM | ETF | 61.175 | 61.225 | 60.77 | 60.775 | 1677000.0 |
> showing 50 of 1,407 rows — these rows as CSV