PREVIEW / etf_30min / 2005-11-23
file: by_date/etf_30min/2005/2005-11-23.parquet size: 52 KB rows: 1,850
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-11-23 07:30:00 | SPY | ETF | 126.35 | 126.4 | 126.35 | 126.4 | 3800.0 |
| 2005-11-23 08:00:00 | SPY | ETF | 126.42 | 126.43 | 126.35 | 126.36 | 625400.0 |
| 2005-11-23 08:30:00 | SPY | ETF | 126.35 | 126.36 | 126.28 | 126.3 | 442000.0 |
| 2005-11-23 09:00:00 | SPY | ETF | 126.3 | 126.33 | 126.22 | 126.22 | 266100.0 |
| 2005-11-23 09:30:00 | SPY | ETF | 126.25 | 126.51 | 126.21 | 126.49 | 3980600.0 |
| 2005-11-23 10:00:00 | SPY | ETF | 126.48 | 126.57 | 126.4 | 126.5 | 3522300.0 |
| 2005-11-23 10:30:00 | SPY | ETF | 126.51 | 126.67 | 126.46 | 126.6 | 2831700.0 |
| 2005-11-23 11:00:00 | SPY | ETF | 126.61 | 126.84 | 126.52 | 126.8 | 2758800.0 |
| 2005-11-23 11:30:00 | SPY | ETF | 126.81 | 126.93 | 126.67 | 126.87 | 3744100.0 |
| 2005-11-23 12:00:00 | SPY | ETF | 126.89 | 126.91 | 126.81 | 126.91 | 1733900.0 |
| 2005-11-23 12:30:00 | SPY | ETF | 126.92 | 127.24 | 126.92 | 127.11 | 6999800.0 |
| 2005-11-23 13:00:00 | SPY | ETF | 127.11 | 127.17 | 127.05 | 127.15 | 1699300.0 |
| 2005-11-23 13:30:00 | SPY | ETF | 127.15 | 127.22 | 127.08 | 127.16 | 3168900.0 |
| 2005-11-23 14:00:00 | SPY | ETF | 127.16 | 127.41 | 127.15 | 127.35 | 2349500.0 |
| 2005-11-23 14:30:00 | SPY | ETF | 127.36 | 127.39 | 127.17 | 127.17 | 4097300.0 |
| 2005-11-23 15:00:00 | SPY | ETF | 127.17 | 127.31 | 126.82 | 126.97 | 5512600.0 |
| 2005-11-23 15:30:00 | SPY | ETF | 126.97 | 127.06 | 126.8 | 126.88 | 3157800.0 |
| 2005-11-23 16:00:00 | SPY | ETF | 126.86 | 127.03 | 126.83 | 126.99 | 527300.0 |
| 2005-11-23 16:30:00 | SPY | ETF | 126.95 | 126.95 | 126.9 | 126.9 | 18100.0 |
| 2005-11-23 17:00:00 | SPY | ETF | 126.89 | 126.94 | 126.89 | 126.94 | 400.0 |
| 2005-11-23 17:30:00 | SPY | ETF | 126.93 | 126.93 | 126.93 | 126.93 | 500.0 |
| 2005-11-23 18:00:00 | SPY | ETF | 126.93 | 126.94 | 126.91 | 126.93 | 2400.0 |
| 2005-11-23 19:30:00 | SPY | ETF | 126.93 | 126.95 | 126.93 | 126.95 | 2100.0 |
| 2005-11-23 09:30:00 | QQQ | ETF | 41.72 | 41.84 | 41.71 | 41.79 | 8224000.0 |
| 2005-11-23 10:00:00 | QQQ | ETF | 41.8 | 41.84 | 41.78 | 41.83 | 4280800.0 |
| 2005-11-23 10:30:00 | QQQ | ETF | 41.83 | 41.87 | 41.81 | 41.85 | 3296500.0 |
| 2005-11-23 11:00:00 | QQQ | ETF | 41.85 | 41.88 | 41.81 | 41.88 | 2587000.0 |
| 2005-11-23 11:30:00 | QQQ | ETF | 41.88 | 41.89 | 41.82 | 41.85 | 2380300.0 |
| 2005-11-23 12:00:00 | QQQ | ETF | 41.86 | 41.87 | 41.83 | 41.86 | 1435500.0 |
| 2005-11-23 12:30:00 | QQQ | ETF | 41.86 | 41.97 | 41.86 | 41.94 | 4221200.0 |
| 2005-11-23 13:00:00 | QQQ | ETF | 41.94 | 41.95 | 41.91 | 41.94 | 1438700.0 |
| 2005-11-23 13:30:00 | QQQ | ETF | 41.94 | 41.95 | 41.9 | 41.94 | 1374700.0 |
| 2005-11-23 14:00:00 | QQQ | ETF | 41.93 | 42.0 | 41.93 | 41.99 | 4575200.0 |
| 2005-11-23 14:30:00 | QQQ | ETF | 41.99 | 42.02 | 41.89 | 41.9 | 6385800.0 |
| 2005-11-23 15:00:00 | QQQ | ETF | 41.9 | 41.9 | 41.73 | 41.77 | 8336500.0 |
| 2005-11-23 15:30:00 | QQQ | ETF | 41.78 | 41.82 | 41.73 | 41.81 | 8870400.0 |
| 2005-11-23 09:00:00 | IWM | ETF | 67.87 | 67.87 | 67.79 | 67.79 | 10800.0 |
| 2005-11-23 09:30:00 | IWM | ETF | 67.8 | 68.04 | 67.7699 | 67.95 | 3912900.0 |
| 2005-11-23 10:00:00 | IWM | ETF | 67.96 | 67.9999 | 67.8 | 67.969 | 2248800.0 |
| 2005-11-23 10:30:00 | IWM | ETF | 67.96 | 68.06 | 67.88 | 68.04 | 1320700.0 |
| 2005-11-23 11:00:00 | IWM | ETF | 68.05 | 68.09 | 67.95 | 68.07 | 1044800.0 |
| 2005-11-23 11:30:00 | IWM | ETF | 68.09 | 68.15 | 68.04 | 68.1 | 1439800.0 |
| 2005-11-23 12:00:00 | IWM | ETF | 68.1099 | 68.11 | 68.0 | 68.08 | 711500.0 |
| 2005-11-23 12:30:00 | IWM | ETF | 68.09 | 68.22 | 68.06 | 68.18 | 426300.0 |
| 2005-11-23 13:00:00 | IWM | ETF | 68.18 | 68.19 | 68.14 | 68.19 | 626400.0 |
| 2005-11-23 13:30:00 | IWM | ETF | 68.17 | 68.23 | 68.15 | 68.19 | 718700.0 |
| 2005-11-23 14:00:00 | IWM | ETF | 68.2 | 68.35 | 68.19 | 68.3099 | 2237100.0 |
| 2005-11-23 14:30:00 | IWM | ETF | 68.31 | 68.33 | 68.11 | 68.11 | 1131600.0 |
| 2005-11-23 15:00:00 | IWM | ETF | 68.11 | 68.11 | 67.84 | 67.96 | 2531600.0 |
| 2005-11-23 15:30:00 | IWM | ETF | 67.96 | 68.04 | 67.88 | 67.97 | 2084100.0 |
> showing 50 of 1,850 rows — these rows as CSV