PREVIEW / etf_30min / 2005-12-13
file: by_date/etf_30min/2005/2005-12-13.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-13 07:30:00 | SPY | ETF | 126.61 | 126.64 | 126.6 | 126.64 | 4400.0 |
| 2005-12-13 08:00:00 | SPY | ETF | 126.6 | 126.62 | 126.5 | 126.6 | 359000.0 |
| 2005-12-13 08:30:00 | SPY | ETF | 126.55 | 126.55 | 126.38 | 126.42 | 320900.0 |
| 2005-12-13 09:00:00 | SPY | ETF | 126.42 | 126.46 | 126.39 | 126.42 | 398900.0 |
| 2005-12-13 09:30:00 | SPY | ETF | 126.4 | 126.48 | 126.29 | 126.4 | 3296500.0 |
| 2005-12-13 10:00:00 | SPY | ETF | 126.4 | 126.61 | 126.39 | 126.47 | 3841500.0 |
| 2005-12-13 10:30:00 | SPY | ETF | 126.47 | 126.54 | 126.42 | 126.52 | 1634700.0 |
| 2005-12-13 11:00:00 | SPY | ETF | 126.52 | 126.61 | 126.49 | 126.55 | 1078900.0 |
| 2005-12-13 11:30:00 | SPY | ETF | 126.55 | 126.72 | 126.53 | 126.68 | 2146300.0 |
| 2005-12-13 12:00:00 | SPY | ETF | 126.68 | 126.69 | 126.505 | 126.6 | 1591100.0 |
| 2005-12-13 12:30:00 | SPY | ETF | 126.6 | 126.66 | 126.57 | 126.58 | 974400.0 |
| 2005-12-13 13:00:00 | SPY | ETF | 126.59 | 126.65 | 126.55 | 126.64 | 1784000.0 |
| 2005-12-13 13:30:00 | SPY | ETF | 126.65 | 126.69 | 126.56 | 126.57 | 2110100.0 |
| 2005-12-13 14:00:00 | SPY | ETF | 126.57 | 127.54 | 126.53 | 127.23 | 22869700.0 |
| 2005-12-13 14:30:00 | SPY | ETF | 127.23 | 127.7 | 126.84 | 127.57 | 18902400.0 |
| 2005-12-13 15:00:00 | SPY | ETF | 127.57 | 127.6 | 127.08 | 127.12 | 11008400.0 |
| 2005-12-13 15:30:00 | SPY | ETF | 127.13 | 127.44 | 127.04 | 127.19 | 10776100.0 |
| 2005-12-13 16:00:00 | SPY | ETF | 127.18 | 127.35 | 127.14 | 127.34 | 3248800.0 |
| 2005-12-13 16:30:00 | SPY | ETF | 127.31 | 127.4 | 127.3 | 127.4 | 66300.0 |
| 2005-12-13 17:00:00 | SPY | ETF | 127.35 | 127.41 | 127.33 | 127.37 | 136500.0 |
| 2005-12-13 17:30:00 | SPY | ETF | 127.35 | 127.35 | 127.28 | 127.28 | 10000.0 |
| 2005-12-13 18:00:00 | SPY | ETF | 127.38 | 127.42 | 127.38 | 127.42 | 4500.0 |
| 2005-12-13 18:30:00 | SPY | ETF | 127.45 | 127.5 | 127.45 | 127.47 | 12000.0 |
| 2005-12-13 19:00:00 | SPY | ETF | 127.46 | 127.46 | 127.46 | 127.46 | 500.0 |
| 2005-12-13 19:30:00 | SPY | ETF | 127.44 | 127.44 | 127.4 | 127.41 | 6100.0 |
| 2005-12-13 09:30:00 | QQQ | ETF | 41.83 | 41.86 | 41.76 | 41.81 | 6442000.0 |
| 2005-12-13 10:00:00 | QQQ | ETF | 41.81 | 41.89 | 41.81 | 41.83 | 3803300.0 |
| 2005-12-13 10:30:00 | QQQ | ETF | 41.84 | 41.86 | 41.78 | 41.82 | 1821500.0 |
| 2005-12-13 11:00:00 | QQQ | ETF | 41.82 | 41.85 | 41.81 | 41.83 | 1693200.0 |
| 2005-12-13 11:30:00 | QQQ | ETF | 41.84 | 41.88 | 41.82 | 41.86 | 2079300.0 |
| 2005-12-13 12:00:00 | QQQ | ETF | 41.86 | 41.88 | 41.83 | 41.84 | 622900.0 |
| 2005-12-13 12:30:00 | QQQ | ETF | 41.83 | 41.86 | 41.81 | 41.82 | 999800.0 |
| 2005-12-13 13:00:00 | QQQ | ETF | 41.82 | 41.92 | 41.82 | 41.91 | 2106000.0 |
| 2005-12-13 13:30:00 | QQQ | ETF | 41.91 | 41.93 | 41.85 | 41.85 | 1764600.0 |
| 2005-12-13 14:00:00 | QQQ | ETF | 41.85 | 42.21 | 41.84 | 42.07 | 18122800.0 |
| 2005-12-13 14:30:00 | QQQ | ETF | 42.08 | 42.2 | 42.01 | 42.17 | 13359000.0 |
| 2005-12-13 15:00:00 | QQQ | ETF | 42.17 | 42.18 | 42.0 | 42.02 | 7041600.0 |
| 2005-12-13 15:30:00 | QQQ | ETF | 42.02 | 42.1 | 41.97 | 42.04 | 8708500.0 |
| 2005-12-13 08:00:00 | IWM | ETF | 68.76 | 68.76 | 68.76 | 68.76 | 100.0 |
| 2005-12-13 08:30:00 | IWM | ETF | 68.76 | 68.76 | 68.76 | 68.76 | 200.0 |
| 2005-12-13 09:00:00 | IWM | ETF | 68.68 | 68.74 | 68.66 | 68.66 | 12100.0 |
| 2005-12-13 09:30:00 | IWM | ETF | 68.67 | 68.7 | 68.52 | 68.59 | 1420800.0 |
| 2005-12-13 10:00:00 | IWM | ETF | 68.59 | 68.69 | 68.51 | 68.59 | 3069100.0 |
| 2005-12-13 10:30:00 | IWM | ETF | 68.59 | 68.63 | 68.51 | 68.58 | 928500.0 |
| 2005-12-13 11:00:00 | IWM | ETF | 68.58 | 68.65 | 68.57 | 68.61 | 931500.0 |
| 2005-12-13 11:30:00 | IWM | ETF | 68.62 | 68.7 | 68.58 | 68.65 | 1085900.0 |
| 2005-12-13 12:00:00 | IWM | ETF | 68.66 | 68.67 | 68.56 | 68.58 | 396700.0 |
| 2005-12-13 12:30:00 | IWM | ETF | 68.57 | 68.58 | 68.52 | 68.53 | 220100.0 |
| 2005-12-13 13:00:00 | IWM | ETF | 68.52 | 68.57 | 68.46 | 68.53 | 609800.0 |
| 2005-12-13 13:30:00 | IWM | ETF | 68.53 | 68.57 | 68.36 | 68.36 | 1148400.0 |
> showing 50 of 2,016 rows — these rows as CSV