PREVIEW / etf_30min / 2005-12-16
file: by_date/etf_30min/2005/2005-12-16.parquet size: 55 KB rows: 2,018
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-16 05:00:00 | SPY | ETF | 127.25 | 127.25 | 127.25 | 127.25 | 100.0 |
| 2005-12-16 05:30:00 | SPY | ETF | 127.31 | 127.32 | 127.31 | 127.32 | 300.0 |
| 2005-12-16 06:00:00 | SPY | ETF | 127.3 | 127.3 | 127.27 | 127.29 | 35900.0 |
| 2005-12-16 07:00:00 | SPY | ETF | 127.41 | 127.43 | 127.31 | 127.33 | 167400.0 |
| 2005-12-16 07:30:00 | SPY | ETF | 127.29 | 127.39 | 127.25 | 127.25 | 101800.0 |
| 2005-12-16 08:00:00 | SPY | ETF | 127.3 | 127.43 | 127.18 | 127.25 | 269300.0 |
| 2005-12-16 08:30:00 | SPY | ETF | 127.25 | 127.41 | 126.95 | 127.35 | 1122700.0 |
| 2005-12-16 09:00:00 | SPY | ETF | 127.35 | 127.4 | 127.24 | 127.24 | 1628100.0 |
| 2005-12-16 09:30:00 | SPY | ETF | 127.27 | 127.34 | 127.03 | 127.24 | 7840100.0 |
| 2005-12-16 10:00:00 | SPY | ETF | 127.22 | 127.28 | 127.08 | 127.22 | 2732600.0 |
| 2005-12-16 10:30:00 | SPY | ETF | 127.23 | 127.24 | 127.12 | 127.22 | 1660600.0 |
| 2005-12-16 11:00:00 | SPY | ETF | 127.2 | 127.38 | 127.15 | 127.17 | 2651800.0 |
| 2005-12-16 11:30:00 | SPY | ETF | 127.18 | 127.24 | 126.83 | 126.97 | 3899100.0 |
| 2005-12-16 12:00:00 | SPY | ETF | 126.98 | 127.14 | 126.92 | 126.95 | 3217800.0 |
| 2005-12-16 12:30:00 | SPY | ETF | 126.96 | 127.29 | 126.91 | 126.93 | 1354900.0 |
| 2005-12-16 13:00:00 | SPY | ETF | 126.92 | 126.99 | 126.77 | 126.86 | 2266700.0 |
| 2005-12-16 13:30:00 | SPY | ETF | 126.85 | 127.01 | 126.76 | 126.9899 | 1149100.0 |
| 2005-12-16 14:00:00 | SPY | ETF | 126.99 | 127.0 | 126.85 | 126.86 | 1081600.0 |
| 2005-12-16 14:30:00 | SPY | ETF | 126.86 | 126.9 | 126.62 | 126.64 | 2086700.0 |
| 2005-12-16 15:00:00 | SPY | ETF | 126.62 | 126.74 | 126.49 | 126.71 | 3316300.0 |
| 2005-12-16 15:30:00 | SPY | ETF | 126.71 | 128.57 | 126.51 | 126.6 | 3853400.0 |
| 2005-12-16 16:00:00 | SPY | ETF | 126.6 | 126.69 | 126.36 | 126.36 | 1097100.0 |
| 2005-12-16 16:30:00 | SPY | ETF | 126.38 | 126.45 | 126.3 | 126.35 | 1945800.0 |
| 2005-12-16 17:00:00 | SPY | ETF | 126.31 | 126.55 | 126.3 | 126.55 | 248300.0 |
| 2005-12-16 17:30:00 | SPY | ETF | 126.5 | 126.65 | 126.43 | 126.59 | 7100.0 |
| 2005-12-16 18:00:00 | SPY | ETF | 126.58 | 126.58 | 126.58 | 126.58 | 100.0 |
| 2005-12-16 19:30:00 | SPY | ETF | 126.5 | 126.5 | 126.5 | 126.5 | 200.0 |
| 2005-12-16 09:30:00 | QQQ | ETF | 41.87 | 41.94 | 41.66 | 41.8 | 11676800.0 |
| 2005-12-16 10:00:00 | QQQ | ETF | 41.81 | 41.83 | 41.71 | 41.75 | 4432200.0 |
| 2005-12-16 10:30:00 | QQQ | ETF | 41.75 | 41.8 | 41.73 | 41.77 | 1561500.0 |
| 2005-12-16 11:00:00 | QQQ | ETF | 41.77 | 41.94 | 41.76 | 41.86 | 3648200.0 |
| 2005-12-16 11:30:00 | QQQ | ETF | 41.86 | 41.87 | 41.74 | 41.78 | 2479700.0 |
| 2005-12-16 12:00:00 | QQQ | ETF | 41.77 | 41.81 | 41.75 | 41.78 | 1123900.0 |
| 2005-12-16 12:30:00 | QQQ | ETF | 41.79 | 41.81 | 41.73 | 41.73 | 1240700.0 |
| 2005-12-16 13:00:00 | QQQ | ETF | 41.74 | 41.75 | 41.7 | 41.74 | 1966700.0 |
| 2005-12-16 13:30:00 | QQQ | ETF | 41.74 | 41.79 | 41.73 | 41.77 | 1218600.0 |
| 2005-12-16 14:00:00 | QQQ | ETF | 41.78 | 41.78 | 41.73 | 41.73 | 2003800.0 |
| 2005-12-16 14:30:00 | QQQ | ETF | 41.73 | 41.74 | 41.61 | 41.61 | 3125100.0 |
| 2005-12-16 15:00:00 | QQQ | ETF | 41.62 | 41.66 | 41.55 | 41.64 | 5502800.0 |
| 2005-12-16 15:30:00 | QQQ | ETF | 41.65 | 41.75 | 41.55 | 41.59 | 8756700.0 |
| 2005-12-16 07:30:00 | IWM | ETF | 68.37 | 68.37 | 68.35 | 68.35 | 300.0 |
| 2005-12-16 08:00:00 | IWM | ETF | 68.33 | 68.33 | 68.28 | 68.28 | 3800.0 |
| 2005-12-16 09:00:00 | IWM | ETF | 68.35 | 68.6 | 68.35 | 68.49 | 37300.0 |
| 2005-12-16 09:30:00 | IWM | ETF | 68.44 | 68.55 | 68.17 | 68.24 | 2323000.0 |
| 2005-12-16 10:00:00 | IWM | ETF | 68.24 | 68.27 | 68.07 | 68.16 | 1652500.0 |
| 2005-12-16 10:30:00 | IWM | ETF | 68.18 | 68.24 | 68.11 | 68.2 | 626600.0 |
| 2005-12-16 11:00:00 | IWM | ETF | 68.19 | 68.44 | 68.19 | 68.37 | 2401000.0 |
| 2005-12-16 11:30:00 | IWM | ETF | 68.38 | 68.41 | 68.18 | 68.24 | 1738900.0 |
| 2005-12-16 12:00:00 | IWM | ETF | 68.24 | 68.33 | 68.2 | 68.23 | 1465600.0 |
| 2005-12-16 12:30:00 | IWM | ETF | 68.23 | 68.26 | 68.16 | 68.17 | 564500.0 |
> showing 50 of 2,018 rows — these rows as CSV