PREVIEW / etf_30min / 2005-12-28
file: by_date/etf_30min/2005/2005-12-28.parquet size: 55 KB rows: 2,020
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-28 05:30:00 | SPY | ETF | 125.85 | 125.85 | 125.85 | 125.85 | 600.0 |
| 2005-12-28 07:00:00 | SPY | ETF | 125.89 | 125.92 | 125.89 | 125.89 | 64700.0 |
| 2005-12-28 07:30:00 | SPY | ETF | 125.9 | 125.9 | 125.86 | 125.87 | 6100.0 |
| 2005-12-28 08:00:00 | SPY | ETF | 125.84 | 125.91 | 125.81 | 125.82 | 239500.0 |
| 2005-12-28 08:30:00 | SPY | ETF | 125.82 | 125.85 | 125.77 | 125.8 | 180100.0 |
| 2005-12-28 09:00:00 | SPY | ETF | 125.79 | 125.8 | 125.73 | 125.74 | 210500.0 |
| 2005-12-28 09:30:00 | SPY | ETF | 125.74 | 125.85 | 125.63 | 125.77 | 3130300.0 |
| 2005-12-28 10:00:00 | SPY | ETF | 125.77 | 125.95 | 125.69 | 125.73 | 3126500.0 |
| 2005-12-28 10:30:00 | SPY | ETF | 125.73 | 125.79 | 125.5 | 125.62 | 3621900.0 |
| 2005-12-28 11:00:00 | SPY | ETF | 125.62 | 125.81 | 125.62 | 125.78 | 1580900.0 |
| 2005-12-28 11:30:00 | SPY | ETF | 125.78 | 125.87 | 125.7 | 125.73 | 1369400.0 |
| 2005-12-28 12:00:00 | SPY | ETF | 125.73 | 125.8 | 125.64 | 125.74 | 1175400.0 |
| 2005-12-28 12:30:00 | SPY | ETF | 125.75 | 125.8 | 125.59 | 125.7 | 1152100.0 |
| 2005-12-28 13:00:00 | SPY | ETF | 125.701 | 125.76 | 125.63 | 125.65 | 767800.0 |
| 2005-12-28 13:30:00 | SPY | ETF | 125.65 | 125.83 | 125.64 | 125.78 | 1706300.0 |
| 2005-12-28 14:00:00 | SPY | ETF | 125.78 | 125.92 | 125.75 | 125.9 | 2182600.0 |
| 2005-12-28 14:30:00 | SPY | ETF | 125.89 | 125.99 | 125.82 | 125.87 | 2168100.0 |
| 2005-12-28 15:00:00 | SPY | ETF | 125.86 | 125.95 | 125.75 | 125.92 | 1357400.0 |
| 2005-12-28 15:30:00 | SPY | ETF | 125.92 | 125.93 | 125.6 | 125.61 | 2884400.0 |
| 2005-12-28 16:00:00 | SPY | ETF | 125.61 | 125.75 | 125.61 | 125.75 | 896100.0 |
| 2005-12-28 16:30:00 | SPY | ETF | 125.68 | 125.69 | 125.66 | 125.66 | 24600.0 |
| 2005-12-28 17:00:00 | SPY | ETF | 125.66 | 125.69 | 125.63 | 125.63 | 12300.0 |
| 2005-12-28 17:30:00 | SPY | ETF | 125.7 | 125.7 | 125.7 | 125.7 | 100.0 |
| 2005-12-28 19:00:00 | SPY | ETF | 125.67 | 125.67 | 125.67 | 125.67 | 500.0 |
| 2005-12-28 09:30:00 | QQQ | ETF | 41.06 | 41.18 | 41.06 | 41.12 | 7778600.0 |
| 2005-12-28 10:00:00 | QQQ | ETF | 41.12 | 41.23 | 41.05 | 41.07 | 4371200.0 |
| 2005-12-28 10:30:00 | QQQ | ETF | 41.07 | 41.11 | 40.87 | 40.95 | 6957400.0 |
| 2005-12-28 11:00:00 | QQQ | ETF | 40.95 | 41.04 | 40.95 | 41.02 | 4191100.0 |
| 2005-12-28 11:30:00 | QQQ | ETF | 41.03 | 41.07 | 40.96 | 40.97 | 2255300.0 |
| 2005-12-28 12:00:00 | QQQ | ETF | 40.98 | 41.01 | 40.93 | 41.0 | 1543400.0 |
| 2005-12-28 12:30:00 | QQQ | ETF | 41.0 | 41.02 | 40.93 | 40.99 | 1828700.0 |
| 2005-12-28 13:00:00 | QQQ | ETF | 40.99 | 41.01 | 40.94 | 40.94 | 1640900.0 |
| 2005-12-28 13:30:00 | QQQ | ETF | 40.94 | 41.05 | 40.94 | 41.03 | 2984700.0 |
| 2005-12-28 14:00:00 | QQQ | ETF | 41.03 | 41.13 | 41.0 | 41.12 | 2589200.0 |
| 2005-12-28 14:30:00 | QQQ | ETF | 41.12 | 41.15 | 41.08 | 41.11 | 3009400.0 |
| 2005-12-28 15:00:00 | QQQ | ETF | 41.1 | 41.15 | 41.05 | 41.15 | 2524300.0 |
| 2005-12-28 15:30:00 | QQQ | ETF | 41.15 | 41.15 | 40.99 | 40.99 | 5780100.0 |
| 2005-12-28 08:00:00 | IWM | ETF | 67.36 | 67.36 | 67.34 | 67.34 | 3600.0 |
| 2005-12-28 08:30:00 | IWM | ETF | 67.38 | 67.4 | 67.38 | 67.4 | 6500.0 |
| 2005-12-28 09:00:00 | IWM | ETF | 67.37 | 67.37 | 67.32 | 67.33 | 54800.0 |
| 2005-12-28 09:30:00 | IWM | ETF | 67.34 | 67.47 | 67.16 | 67.29 | 2524300.0 |
| 2005-12-28 10:00:00 | IWM | ETF | 67.29 | 67.41 | 67.12 | 67.13 | 2346900.0 |
| 2005-12-28 10:30:00 | IWM | ETF | 67.13 | 67.22 | 66.96 | 67.01 | 2488700.0 |
| 2005-12-28 11:00:00 | IWM | ETF | 67.01 | 67.19 | 67.0 | 67.17 | 2178200.0 |
| 2005-12-28 11:30:00 | IWM | ETF | 67.17 | 67.26 | 67.13 | 67.17 | 1574900.0 |
| 2005-12-28 12:00:00 | IWM | ETF | 67.17 | 67.2 | 67.1 | 67.18 | 956800.0 |
| 2005-12-28 12:30:00 | IWM | ETF | 67.18 | 67.19 | 67.11 | 67.17 | 650500.0 |
| 2005-12-28 13:00:00 | IWM | ETF | 67.17 | 67.26 | 67.14 | 67.19 | 553400.0 |
| 2005-12-28 13:30:00 | IWM | ETF | 67.2 | 67.44 | 67.2 | 67.38 | 1146000.0 |
| 2005-12-28 14:00:00 | IWM | ETF | 67.38 | 67.56 | 67.37 | 67.54 | 1179500.0 |
> showing 50 of 2,020 rows — these rows as CSV