PREVIEW / etf_30min / 2005-10-17
file: by_date/etf_30min/2005/2005-10-17.parquet size: 48 KB rows: 1,711
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-10-17 06:30:00 | SPY | ETF | 118.4 | 118.4 | 118.4 | 118.4 | 25000.0 |
| 2005-10-17 07:00:00 | SPY | ETF | 118.41 | 118.45 | 118.39 | 118.45 | 4400.0 |
| 2005-10-17 07:30:00 | SPY | ETF | 118.47 | 118.48 | 118.45 | 118.48 | 80800.0 |
| 2005-10-17 08:00:00 | SPY | ETF | 118.48 | 118.66 | 118.39 | 118.6 | 896000.0 |
| 2005-10-17 08:30:00 | SPY | ETF | 118.6 | 118.72 | 118.36 | 118.72 | 1750500.0 |
| 2005-10-17 09:00:00 | SPY | ETF | 118.71 | 118.85 | 118.66 | 118.78 | 936100.0 |
| 2005-10-17 09:30:00 | SPY | ETF | 118.77 | 119.01 | 118.74 | 118.89 | 10341900.0 |
| 2005-10-17 10:00:00 | SPY | ETF | 118.89 | 119.27 | 118.86 | 119.086 | 7640000.0 |
| 2005-10-17 10:30:00 | SPY | ETF | 119.07 | 119.14 | 118.8 | 118.91 | 5601200.0 |
| 2005-10-17 11:00:00 | SPY | ETF | 118.92 | 119.19 | 118.87 | 118.92 | 2534800.0 |
| 2005-10-17 11:30:00 | SPY | ETF | 118.91 | 119.1 | 118.86 | 119.07 | 1828200.0 |
| 2005-10-17 12:00:00 | SPY | ETF | 119.05 | 119.09 | 118.78 | 118.92 | 3548100.0 |
| 2005-10-17 12:30:00 | SPY | ETF | 118.91 | 118.92 | 118.47 | 118.62 | 4592500.0 |
| 2005-10-17 13:00:00 | SPY | ETF | 118.61 | 118.75 | 118.45 | 118.68 | 2469100.0 |
| 2005-10-17 13:30:00 | SPY | ETF | 118.71 | 118.88 | 118.62 | 118.8 | 1961200.0 |
| 2005-10-17 14:00:00 | SPY | ETF | 118.81 | 118.81 | 118.56 | 118.62 | 2013100.0 |
| 2005-10-17 14:30:00 | SPY | ETF | 118.63 | 118.82 | 118.56 | 118.73 | 1942900.0 |
| 2005-10-17 15:00:00 | SPY | ETF | 118.73 | 118.99 | 118.67 | 118.95 | 3476700.0 |
| 2005-10-17 15:30:00 | SPY | ETF | 118.95 | 119.17 | 118.94 | 119.07 | 7923600.0 |
| 2005-10-17 16:00:00 | SPY | ETF | 119.07 | 119.14 | 118.82 | 119.12 | 681000.0 |
| 2005-10-17 16:30:00 | SPY | ETF | 119.12 | 119.18 | 119.09 | 119.11 | 81800.0 |
| 2005-10-17 17:00:00 | SPY | ETF | 119.1 | 119.1 | 119.03 | 119.06 | 45000.0 |
| 2005-10-17 17:30:00 | SPY | ETF | 119.1 | 119.1 | 119.1 | 119.1 | 2800.0 |
| 2005-10-17 18:00:00 | SPY | ETF | 119.08 | 119.12 | 119.07 | 119.12 | 857700.0 |
| 2005-10-17 18:30:00 | SPY | ETF | 119.11 | 119.11 | 119.09 | 119.09 | 2000.0 |
| 2005-10-17 19:00:00 | SPY | ETF | 119.09 | 119.09 | 119.07 | 119.07 | 3000.0 |
| 2005-10-17 19:30:00 | SPY | ETF | 119.08 | 119.08 | 119.08 | 119.08 | 500.0 |
| 2005-10-17 09:30:00 | QQQ | ETF | 38.05 | 38.1 | 37.97 | 38.08 | 8248000.0 |
| 2005-10-17 10:00:00 | QQQ | ETF | 38.08 | 38.13 | 38.03 | 38.08 | 6594400.0 |
| 2005-10-17 10:30:00 | QQQ | ETF | 38.08 | 38.1 | 38.0 | 38.03 | 4518300.0 |
| 2005-10-17 11:00:00 | QQQ | ETF | 38.04 | 38.07 | 38.02 | 38.05 | 3201500.0 |
| 2005-10-17 11:30:00 | QQQ | ETF | 38.04 | 38.06 | 38.01 | 38.06 | 2375400.0 |
| 2005-10-17 12:00:00 | QQQ | ETF | 38.06 | 38.06 | 37.9 | 37.99 | 5471900.0 |
| 2005-10-17 12:30:00 | QQQ | ETF | 37.98 | 37.99 | 37.82 | 37.89 | 6741800.0 |
| 2005-10-17 13:00:00 | QQQ | ETF | 37.89 | 37.98 | 37.86 | 37.97 | 2515400.0 |
| 2005-10-17 13:30:00 | QQQ | ETF | 37.97 | 38.05 | 37.95 | 38.03 | 3488000.0 |
| 2005-10-17 14:00:00 | QQQ | ETF | 38.03 | 38.03 | 37.95 | 37.97 | 2082400.0 |
| 2005-10-17 14:30:00 | QQQ | ETF | 37.97 | 38.04 | 37.94 | 38.03 | 2560000.0 |
| 2005-10-17 15:00:00 | QQQ | ETF | 38.03 | 38.16 | 38.02 | 38.15 | 4869400.0 |
| 2005-10-17 15:30:00 | QQQ | ETF | 38.15 | 38.19 | 38.12 | 38.18 | 5699100.0 |
| 2005-10-17 07:30:00 | IWM | ETF | 62.7 | 62.7 | 62.69 | 62.69 | 200.0 |
| 2005-10-17 08:00:00 | IWM | ETF | 62.7 | 62.8 | 62.69 | 62.71 | 58700.0 |
| 2005-10-17 08:30:00 | IWM | ETF | 62.64 | 62.78 | 62.64 | 62.77 | 25700.0 |
| 2005-10-17 09:00:00 | IWM | ETF | 62.8 | 62.9 | 62.78 | 62.88 | 810700.0 |
| 2005-10-17 09:30:00 | IWM | ETF | 62.86 | 63.18 | 62.8 | 62.96 | 5363900.0 |
| 2005-10-17 10:00:00 | IWM | ETF | 62.97 | 63.33 | 62.89 | 62.96 | 3410600.0 |
| 2005-10-17 10:30:00 | IWM | ETF | 62.95 | 62.96 | 62.59 | 62.69 | 2416700.0 |
| 2005-10-17 11:00:00 | IWM | ETF | 62.69 | 62.84 | 62.66 | 62.693 | 1947600.0 |
| 2005-10-17 11:30:00 | IWM | ETF | 62.69 | 62.83 | 62.58 | 62.82 | 1376800.0 |
| 2005-10-17 12:00:00 | IWM | ETF | 62.83 | 62.84 | 62.44 | 62.52 | 2705000.0 |
> showing 50 of 1,711 rows — these rows as CSV