PREVIEW / etf_30min / 2005-12-02
file: by_date/etf_30min/2005/2005-12-02.parquet size: 55 KB rows: 2,016
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-02 07:00:00 | SPY | ETF | 126.78 | 126.88 | 126.78 | 126.88 | 4000.0 |
| 2005-12-02 07:30:00 | SPY | ETF | 126.85 | 126.85 | 126.76 | 126.78 | 47100.0 |
| 2005-12-02 08:00:00 | SPY | ETF | 126.77 | 126.93 | 126.75 | 126.82 | 159300.0 |
| 2005-12-02 08:30:00 | SPY | ETF | 126.93 | 127.02 | 126.81 | 126.91 | 1208900.0 |
| 2005-12-02 09:00:00 | SPY | ETF | 126.91 | 126.95 | 126.77 | 126.77 | 1446800.0 |
| 2005-12-02 09:30:00 | SPY | ETF | 126.77 | 126.78 | 126.61 | 126.66 | 5629800.0 |
| 2005-12-02 10:00:00 | SPY | ETF | 126.67 | 127.06 | 126.65 | 127.04 | 4157300.0 |
| 2005-12-02 10:30:00 | SPY | ETF | 127.04 | 127.08 | 126.68 | 126.74 | 5003600.0 |
| 2005-12-02 11:00:00 | SPY | ETF | 126.74 | 126.93 | 126.65 | 126.88 | 2943500.0 |
| 2005-12-02 11:30:00 | SPY | ETF | 126.88 | 126.95 | 126.79 | 126.8588 | 2967100.0 |
| 2005-12-02 12:00:00 | SPY | ETF | 126.85 | 126.95 | 126.68 | 126.7 | 2515600.0 |
| 2005-12-02 12:30:00 | SPY | ETF | 126.7 | 126.82 | 126.5 | 126.56 | 3739400.0 |
| 2005-12-02 13:00:00 | SPY | ETF | 126.56 | 126.72 | 126.51 | 126.68 | 2153600.0 |
| 2005-12-02 13:30:00 | SPY | ETF | 126.68 | 126.76 | 126.6 | 126.75 | 1135200.0 |
| 2005-12-02 14:00:00 | SPY | ETF | 126.74 | 126.82 | 126.61 | 126.8 | 1484700.0 |
| 2005-12-02 14:30:00 | SPY | ETF | 126.82 | 126.87 | 126.67 | 126.73 | 1386200.0 |
| 2005-12-02 15:00:00 | SPY | ETF | 126.73 | 126.92 | 126.66 | 126.91 | 3107900.0 |
| 2005-12-02 15:30:00 | SPY | ETF | 126.91 | 127.03 | 126.81 | 126.87 | 3348000.0 |
| 2005-12-02 16:00:00 | SPY | ETF | 126.86 | 126.9 | 126.79 | 126.83 | 2553800.0 |
| 2005-12-02 16:30:00 | SPY | ETF | 126.84 | 126.9 | 126.83 | 126.88 | 139400.0 |
| 2005-12-02 17:00:00 | SPY | ETF | 126.85 | 126.85 | 126.75 | 126.85 | 17700.0 |
| 2005-12-02 17:30:00 | SPY | ETF | 126.8 | 126.83 | 126.77 | 126.83 | 5900.0 |
| 2005-12-02 18:00:00 | SPY | ETF | 126.83 | 126.84 | 126.83 | 126.84 | 1700.0 |
| 2005-12-02 09:30:00 | QQQ | ETF | 41.93 | 42.0 | 41.87 | 41.92 | 11268600.0 |
| 2005-12-02 10:00:00 | QQQ | ETF | 41.92 | 42.1 | 41.91 | 42.1 | 10850200.0 |
| 2005-12-02 10:30:00 | QQQ | ETF | 42.1 | 42.13 | 41.95 | 41.98 | 10477600.0 |
| 2005-12-02 11:00:00 | QQQ | ETF | 41.98 | 42.05 | 41.95 | 42.03 | 3517200.0 |
| 2005-12-02 11:30:00 | QQQ | ETF | 42.03 | 42.08 | 41.99 | 42.01 | 3322800.0 |
| 2005-12-02 12:00:00 | QQQ | ETF | 42.0 | 42.05 | 41.95 | 41.97 | 2635800.0 |
| 2005-12-02 12:30:00 | QQQ | ETF | 41.96 | 41.97 | 41.9 | 41.94 | 3241400.0 |
| 2005-12-02 13:00:00 | QQQ | ETF | 41.94 | 41.99 | 41.91 | 41.98 | 3077200.0 |
| 2005-12-02 13:30:00 | QQQ | ETF | 41.98 | 42.01 | 41.96 | 42.01 | 1559100.0 |
| 2005-12-02 14:00:00 | QQQ | ETF | 42.01 | 42.05 | 41.96 | 42.05 | 2713700.0 |
| 2005-12-02 14:30:00 | QQQ | ETF | 42.04 | 42.05 | 41.96 | 41.97 | 1884200.0 |
| 2005-12-02 15:00:00 | QQQ | ETF | 41.96 | 42.05 | 41.95 | 42.05 | 4387100.0 |
| 2005-12-02 15:30:00 | QQQ | ETF | 42.05 | 42.12 | 42.04 | 42.11 | 5539500.0 |
| 2005-12-02 07:30:00 | IWM | ETF | 68.68 | 68.68 | 68.67 | 68.67 | 24400.0 |
| 2005-12-02 08:00:00 | IWM | ETF | 68.67 | 68.71 | 68.67 | 68.7 | 8000.0 |
| 2005-12-02 08:30:00 | IWM | ETF | 68.72 | 68.76 | 68.68 | 68.75 | 31200.0 |
| 2005-12-02 09:00:00 | IWM | ETF | 68.71 | 68.72 | 68.67 | 68.67 | 55800.0 |
| 2005-12-02 09:30:00 | IWM | ETF | 68.6 | 68.62 | 68.38 | 68.42 | 3253700.0 |
| 2005-12-02 10:00:00 | IWM | ETF | 68.42 | 68.72 | 68.41 | 68.71 | 1924400.0 |
| 2005-12-02 10:30:00 | IWM | ETF | 68.72 | 68.8 | 68.43 | 68.49 | 2054200.0 |
| 2005-12-02 11:00:00 | IWM | ETF | 68.5 | 68.65 | 68.39 | 68.6 | 1496400.0 |
| 2005-12-02 11:30:00 | IWM | ETF | 68.58 | 68.68 | 68.56 | 68.58 | 1543400.0 |
| 2005-12-02 12:00:00 | IWM | ETF | 68.58 | 68.64 | 68.35 | 68.37 | 2246200.0 |
| 2005-12-02 12:30:00 | IWM | ETF | 68.36 | 68.36 | 68.12 | 68.22 | 3230700.0 |
| 2005-12-02 13:00:00 | IWM | ETF | 68.22 | 68.61 | 68.14 | 68.29 | 886200.0 |
| 2005-12-02 13:30:00 | IWM | ETF | 68.3 | 68.39 | 68.22 | 68.39 | 425100.0 |
| 2005-12-02 14:00:00 | IWM | ETF | 68.4 | 68.48 | 68.25 | 68.47 | 646900.0 |
> showing 50 of 2,016 rows — these rows as CSV