PREVIEW / etf_30min / 2005-12-06
file: by_date/etf_30min/2005/2005-12-06.parquet size: 57 KB rows: 2,055
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-06 07:00:00 | SPY | ETF | 126.8 | 126.88 | 126.77 | 126.88 | 6600.0 |
| 2005-12-06 07:30:00 | SPY | ETF | 126.84 | 126.84 | 126.84 | 126.84 | 700.0 |
| 2005-12-06 08:00:00 | SPY | ETF | 126.65 | 126.87 | 126.65 | 126.82 | 160100.0 |
| 2005-12-06 08:30:00 | SPY | ETF | 126.82 | 127.08 | 126.82 | 127.03 | 520000.0 |
| 2005-12-06 09:00:00 | SPY | ETF | 127.03 | 127.16 | 127.03 | 127.05 | 742600.0 |
| 2005-12-06 09:30:00 | SPY | ETF | 127.05 | 127.17 | 126.88 | 127.01 | 4525400.0 |
| 2005-12-06 10:00:00 | SPY | ETF | 127.0 | 127.34 | 126.82 | 127.3 | 5999100.0 |
| 2005-12-06 10:30:00 | SPY | ETF | 127.3 | 127.33 | 127.15 | 127.3 | 4298500.0 |
| 2005-12-06 11:00:00 | SPY | ETF | 127.28 | 127.32 | 127.01 | 127.13 | 2599400.0 |
| 2005-12-06 11:30:00 | SPY | ETF | 127.14 | 127.4 | 127.12 | 127.31 | 2915800.0 |
| 2005-12-06 12:00:00 | SPY | ETF | 127.31 | 127.74 | 127.27 | 127.649 | 5882300.0 |
| 2005-12-06 12:30:00 | SPY | ETF | 127.65 | 127.68 | 127.5 | 127.52 | 1900300.0 |
| 2005-12-06 13:00:00 | SPY | ETF | 127.5 | 127.63 | 127.47 | 127.56 | 1711200.0 |
| 2005-12-06 13:30:00 | SPY | ETF | 127.56 | 127.68 | 127.53 | 127.61 | 3515700.0 |
| 2005-12-06 14:00:00 | SPY | ETF | 127.62 | 127.65 | 127.45 | 127.54 | 1711400.0 |
| 2005-12-06 14:30:00 | SPY | ETF | 127.53 | 127.56 | 127.46 | 127.5 | 1695100.0 |
| 2005-12-06 15:00:00 | SPY | ETF | 127.54 | 127.58 | 126.95 | 126.98 | 7149500.0 |
| 2005-12-06 15:30:00 | SPY | ETF | 126.98 | 127.08 | 126.63 | 126.73 | 8463700.0 |
| 2005-12-06 16:00:00 | SPY | ETF | 126.73 | 127.2559 | 126.68 | 126.83 | 1135100.0 |
| 2005-12-06 16:30:00 | SPY | ETF | 126.84 | 126.87 | 126.78 | 126.82 | 1716100.0 |
| 2005-12-06 17:00:00 | SPY | ETF | 126.81 | 126.81 | 126.8 | 126.8 | 85100.0 |
| 2005-12-06 17:30:00 | SPY | ETF | 126.82 | 126.82 | 126.81 | 126.81 | 300.0 |
| 2005-12-06 18:00:00 | SPY | ETF | 126.81 | 126.82 | 126.79 | 126.82 | 2600.0 |
| 2005-12-06 18:30:00 | SPY | ETF | 126.82 | 126.82 | 126.82 | 126.82 | 600.0 |
| 2005-12-06 19:00:00 | SPY | ETF | 126.85 | 126.85 | 126.85 | 126.85 | 500.0 |
| 2005-12-06 09:30:00 | QQQ | ETF | 42.05 | 42.1 | 41.99 | 42.04 | 8365600.0 |
| 2005-12-06 10:00:00 | QQQ | ETF | 42.04 | 42.2 | 41.99 | 42.18 | 7843800.0 |
| 2005-12-06 10:30:00 | QQQ | ETF | 42.18 | 42.19 | 42.12 | 42.17 | 4079400.0 |
| 2005-12-06 11:00:00 | QQQ | ETF | 42.16 | 42.18 | 42.04 | 42.09 | 4733800.0 |
| 2005-12-06 11:30:00 | QQQ | ETF | 42.09 | 42.19 | 42.08 | 42.16 | 4216600.0 |
| 2005-12-06 12:00:00 | QQQ | ETF | 42.15 | 42.31 | 42.15 | 42.3 | 9088200.0 |
| 2005-12-06 12:30:00 | QQQ | ETF | 42.3 | 42.3 | 42.24 | 42.26 | 3178800.0 |
| 2005-12-06 13:00:00 | QQQ | ETF | 42.25 | 42.3 | 42.24 | 42.26 | 2226800.0 |
| 2005-12-06 13:30:00 | QQQ | ETF | 42.26 | 42.31 | 42.25 | 42.3 | 3785400.0 |
| 2005-12-06 14:00:00 | QQQ | ETF | 42.29 | 42.3 | 42.21 | 42.25 | 2497300.0 |
| 2005-12-06 14:30:00 | QQQ | ETF | 42.25 | 42.33 | 42.21 | 42.23 | 4872800.0 |
| 2005-12-06 15:00:00 | QQQ | ETF | 42.24 | 42.26 | 42.03 | 42.05 | 10548100.0 |
| 2005-12-06 15:30:00 | QQQ | ETF | 42.05 | 42.1 | 41.9 | 41.94 | 10912500.0 |
| 2005-12-06 08:00:00 | IWM | ETF | 68.42 | 68.42 | 68.4 | 68.4 | 18200.0 |
| 2005-12-06 08:30:00 | IWM | ETF | 68.47 | 68.59 | 68.47 | 68.57 | 26100.0 |
| 2005-12-06 09:00:00 | IWM | ETF | 68.57 | 68.63 | 68.34 | 68.61 | 28800.0 |
| 2005-12-06 09:30:00 | IWM | ETF | 68.61 | 68.86 | 68.61 | 68.7 | 3007400.0 |
| 2005-12-06 10:00:00 | IWM | ETF | 68.7 | 68.74 | 68.51 | 68.71 | 2405300.0 |
| 2005-12-06 10:30:00 | IWM | ETF | 68.71 | 68.74 | 68.61 | 68.73 | 1452200.0 |
| 2005-12-06 11:00:00 | IWM | ETF | 68.74 | 68.79 | 68.53 | 68.58 | 899600.0 |
| 2005-12-06 11:30:00 | IWM | ETF | 68.58 | 68.73 | 68.55 | 68.7 | 907400.0 |
| 2005-12-06 12:00:00 | IWM | ETF | 68.7 | 68.95 | 68.66 | 68.91 | 2532100.0 |
| 2005-12-06 12:30:00 | IWM | ETF | 68.92 | 69.0 | 68.86 | 68.92 | 3395600.0 |
| 2005-12-06 13:00:00 | IWM | ETF | 68.93 | 69.04 | 68.93 | 68.97 | 1367600.0 |
| 2005-12-06 13:30:00 | IWM | ETF | 68.98 | 69.08 | 68.95 | 69.04 | 576800.0 |
> showing 50 of 2,055 rows — these rows as CSV