PREVIEW / etf_30min / 2005-01-25
file: by_date/etf_30min/2005/2005-01-25.parquet size: 41 KB rows: 1,405
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-01-25 08:00:00 | SPY | ETF | 116.97 | 117.0 | 116.94 | 116.99 | 45400.0 |
| 2005-01-25 08:30:00 | SPY | ETF | 117.0 | 117.01 | 116.96 | 116.98 | 17900.0 |
| 2005-01-25 09:00:00 | SPY | ETF | 116.95 | 116.98 | 116.9 | 116.9 | 60800.0 |
| 2005-01-25 09:30:00 | SPY | ETF | 116.91 | 117.39 | 116.84 | 117.21 | 18365400.0 |
| 2005-01-25 10:00:00 | SPY | ETF | 117.23 | 117.4 | 117.14 | 117.34 | 7314100.0 |
| 2005-01-25 10:30:00 | SPY | ETF | 117.35 | 117.47 | 117.19 | 117.28 | 4326200.0 |
| 2005-01-25 11:00:00 | SPY | ETF | 117.27 | 117.45 | 117.21 | 117.37 | 2993800.0 |
| 2005-01-25 11:30:00 | SPY | ETF | 117.37 | 117.38 | 117.11 | 117.2 | 2532900.0 |
| 2005-01-25 12:00:00 | SPY | ETF | 117.21 | 117.25 | 117.07 | 117.19 | 2927800.0 |
| 2005-01-25 12:30:00 | SPY | ETF | 117.19 | 117.3 | 117.15 | 117.16 | 1884400.0 |
| 2005-01-25 13:00:00 | SPY | ETF | 117.16 | 117.46 | 117.15 | 117.43 | 3556000.0 |
| 2005-01-25 13:30:00 | SPY | ETF | 117.42 | 117.44 | 117.23 | 117.23 | 1630100.0 |
| 2005-01-25 14:00:00 | SPY | ETF | 117.26 | 117.31 | 116.95 | 116.97 | 2759800.0 |
| 2005-01-25 14:30:00 | SPY | ETF | 116.97 | 117.15 | 116.9615 | 117.15 | 4107500.0 |
| 2005-01-25 15:00:00 | SPY | ETF | 117.13 | 117.18 | 116.82 | 116.9 | 4751200.0 |
| 2005-01-25 15:30:00 | SPY | ETF | 116.9 | 116.98 | 116.72 | 116.87 | 6775900.0 |
| 2005-01-25 16:00:00 | SPY | ETF | 116.91 | 117.04 | 116.83 | 116.94 | 1376900.0 |
| 2005-01-25 16:30:00 | SPY | ETF | 116.94 | 117.05 | 116.84 | 117.04 | 1182300.0 |
| 2005-01-25 17:00:00 | SPY | ETF | 117.06 | 117.11 | 117.03 | 117.03 | 55900.0 |
| 2005-01-25 17:30:00 | SPY | ETF | 117.02 | 117.06 | 116.99 | 117.01 | 28800.0 |
| 2005-01-25 18:00:00 | SPY | ETF | 117.01 | 117.04 | 116.99 | 117.0 | 36000.0 |
| 2005-01-25 18:30:00 | SPY | ETF | 117.03 | 117.05 | 117.03 | 117.05 | 1000.0 |
| 2005-01-25 19:00:00 | SPY | ETF | 117.07 | 117.07 | 117.05 | 117.05 | 1200.0 |
| 2005-01-25 19:30:00 | SPY | ETF | 117.05 | 117.05 | 117.05 | 117.05 | 1000.0 |
| 2005-01-25 09:30:00 | QQQ | ETF | 36.77 | 36.97 | 36.75 | 36.92 | 18762300.0 |
| 2005-01-25 10:00:00 | QQQ | ETF | 36.92 | 37.06 | 36.89 | 37.05 | 12886800.0 |
| 2005-01-25 10:30:00 | QQQ | ETF | 37.05 | 37.09 | 36.97 | 37.01 | 7079400.0 |
| 2005-01-25 11:00:00 | QQQ | ETF | 37.01 | 37.05 | 36.99 | 37.05 | 5274800.0 |
| 2005-01-25 11:30:00 | QQQ | ETF | 37.04 | 37.06 | 36.86 | 36.91 | 7787500.0 |
| 2005-01-25 12:00:00 | QQQ | ETF | 36.91 | 36.91 | 36.81 | 36.89 | 6087400.0 |
| 2005-01-25 12:30:00 | QQQ | ETF | 36.89 | 36.94 | 36.86 | 36.86 | 5661300.0 |
| 2005-01-25 13:00:00 | QQQ | ETF | 36.87 | 37.01 | 36.86 | 36.98 | 5040100.0 |
| 2005-01-25 13:30:00 | QQQ | ETF | 36.98 | 37.0 | 36.84 | 36.92 | 3095300.0 |
| 2005-01-25 14:00:00 | QQQ | ETF | 36.92 | 36.94 | 36.72 | 36.72 | 7843200.0 |
| 2005-01-25 14:30:00 | QQQ | ETF | 36.73 | 36.83 | 36.73 | 36.82 | 7630100.0 |
| 2005-01-25 15:00:00 | QQQ | ETF | 36.83 | 36.91 | 36.68 | 36.72 | 10795200.0 |
| 2005-01-25 15:30:00 | QQQ | ETF | 36.72 | 36.78 | 36.66 | 36.71 | 10652200.0 |
| 2005-01-25 08:00:00 | IWM | ETF | 60.64 | 60.64 | 60.58 | 60.58 | 800.0 |
| 2005-01-25 08:30:00 | IWM | ETF | 60.6 | 60.65 | 60.6 | 60.64 | 3800.0 |
| 2005-01-25 09:00:00 | IWM | ETF | 60.63 | 60.66 | 60.56 | 60.565 | 27600.0 |
| 2005-01-25 09:30:00 | IWM | ETF | 60.58 | 60.935 | 60.525 | 60.82 | 5368800.0 |
| 2005-01-25 10:00:00 | IWM | ETF | 60.815 | 60.96 | 60.77 | 60.95 | 1876200.0 |
| 2005-01-25 10:30:00 | IWM | ETF | 60.93 | 61.1 | 60.835 | 60.885 | 838200.0 |
| 2005-01-25 11:00:00 | IWM | ETF | 60.88 | 60.9 | 60.68 | 60.745 | 1712400.0 |
| 2005-01-25 11:30:00 | IWM | ETF | 60.745 | 60.775 | 60.365 | 60.405 | 2585200.0 |
| 2005-01-25 12:00:00 | IWM | ETF | 60.405 | 60.745 | 60.23 | 60.37 | 1556600.0 |
| 2005-01-25 12:30:00 | IWM | ETF | 60.37 | 60.46 | 60.355 | 60.37 | 433800.0 |
| 2005-01-25 13:00:00 | IWM | ETF | 60.375 | 60.635 | 60.375 | 60.585 | 652400.0 |
| 2005-01-25 13:30:00 | IWM | ETF | 60.595 | 60.6 | 60.485 | 60.49 | 388400.0 |
| 2005-01-25 14:00:00 | IWM | ETF | 60.495 | 60.525 | 60.37 | 60.4 | 904600.0 |
> showing 50 of 1,405 rows — these rows as CSV