PREVIEW / etf_30min / 2005-05-09
file: by_date/etf_30min/2005/2005-05-09.parquet size: 42 KB rows: 1,466
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-05-09 04:00:00 | SPY | ETF | 117.29 | 117.34 | 117.29 | 117.34 | 27700.0 |
| 2005-05-09 04:30:00 | SPY | ETF | 117.32 | 117.32 | 117.32 | 117.32 | 1500.0 |
| 2005-05-09 06:00:00 | SPY | ETF | 117.27 | 117.27 | 117.27 | 117.27 | 2400.0 |
| 2005-05-09 06:30:00 | SPY | ETF | 117.3 | 117.35 | 117.3 | 117.35 | 10000.0 |
| 2005-05-09 07:00:00 | SPY | ETF | 117.28 | 117.28 | 117.26 | 117.26 | 99600.0 |
| 2005-05-09 07:30:00 | SPY | ETF | 117.27 | 117.29 | 117.26 | 117.29 | 85200.0 |
| 2005-05-09 08:00:00 | SPY | ETF | 117.27 | 117.31 | 117.27 | 117.3 | 146500.0 |
| 2005-05-09 08:30:00 | SPY | ETF | 117.31 | 117.33 | 117.25 | 117.25 | 118600.0 |
| 2005-05-09 09:00:00 | SPY | ETF | 117.25 | 117.28 | 117.21 | 117.23 | 54100.0 |
| 2005-05-09 09:30:00 | SPY | ETF | 117.21 | 117.37 | 117.14 | 117.33 | 4096100.0 |
| 2005-05-09 10:00:00 | SPY | ETF | 117.33 | 117.42 | 117.05 | 117.23 | 4578900.0 |
| 2005-05-09 10:30:00 | SPY | ETF | 117.23 | 117.36 | 117.15 | 117.26 | 1669100.0 |
| 2005-05-09 11:00:00 | SPY | ETF | 117.23 | 117.5 | 117.16 | 117.45 | 3297800.0 |
| 2005-05-09 11:30:00 | SPY | ETF | 117.46 | 117.74 | 117.45 | 117.61 | 3759500.0 |
| 2005-05-09 12:00:00 | SPY | ETF | 117.61 | 117.85 | 117.57 | 117.74 | 3178900.0 |
| 2005-05-09 12:30:00 | SPY | ETF | 117.74 | 117.84 | 117.71 | 117.75 | 2200700.0 |
| 2005-05-09 13:00:00 | SPY | ETF | 117.75 | 117.78 | 117.65 | 117.74 | 1061800.0 |
| 2005-05-09 13:30:00 | SPY | ETF | 117.74 | 117.95 | 117.74 | 117.92 | 3479200.0 |
| 2005-05-09 14:00:00 | SPY | ETF | 117.92 | 117.94 | 117.6 | 117.66 | 3287700.0 |
| 2005-05-09 14:30:00 | SPY | ETF | 117.68 | 117.79 | 117.62 | 117.72 | 1635800.0 |
| 2005-05-09 15:00:00 | SPY | ETF | 117.72 | 117.86 | 117.49 | 117.63 | 2876900.0 |
| 2005-05-09 15:30:00 | SPY | ETF | 117.63 | 118.03 | 117.63 | 118.01 | 5432400.0 |
| 2005-05-09 16:00:00 | SPY | ETF | 118.03 | 118.07 | 117.77 | 117.82 | 912300.0 |
| 2005-05-09 16:30:00 | SPY | ETF | 117.81 | 117.99 | 117.77 | 117.84 | 189000.0 |
| 2005-05-09 17:00:00 | SPY | ETF | 117.83 | 117.84 | 117.8 | 117.8 | 10500.0 |
| 2005-05-09 17:30:00 | SPY | ETF | 117.83 | 117.84 | 117.83 | 117.83 | 1900.0 |
| 2005-05-09 18:00:00 | SPY | ETF | 117.82 | 117.83 | 117.82 | 117.83 | 1200.0 |
| 2005-05-09 18:30:00 | SPY | ETF | 117.82 | 117.82 | 117.8 | 117.8 | 3800.0 |
| 2005-05-09 19:30:00 | SPY | ETF | 117.8 | 117.8 | 117.79 | 117.79 | 1100.0 |
| 2005-05-09 09:30:00 | QQQ | ETF | 35.88 | 35.9 | 35.76 | 35.83 | 9964500.0 |
| 2005-05-09 10:00:00 | QQQ | ETF | 35.83 | 35.85 | 35.69 | 35.73 | 7096600.0 |
| 2005-05-09 10:30:00 | QQQ | ETF | 35.73 | 35.78 | 35.66 | 35.72 | 3809400.0 |
| 2005-05-09 11:00:00 | QQQ | ETF | 35.72 | 35.85 | 35.7 | 35.82 | 5067400.0 |
| 2005-05-09 11:30:00 | QQQ | ETF | 35.82 | 35.97 | 35.82 | 35.91 | 6379200.0 |
| 2005-05-09 12:00:00 | QQQ | ETF | 35.91 | 36.0 | 35.9 | 35.97 | 4354700.0 |
| 2005-05-09 12:30:00 | QQQ | ETF | 35.97 | 36.0 | 35.93 | 35.98 | 1750700.0 |
| 2005-05-09 13:00:00 | QQQ | ETF | 35.98 | 35.98 | 35.93 | 35.95 | 1478400.0 |
| 2005-05-09 13:30:00 | QQQ | ETF | 35.95 | 36.05 | 35.94 | 36.05 | 4145600.0 |
| 2005-05-09 14:00:00 | QQQ | ETF | 36.04 | 36.05 | 35.93 | 35.95 | 4044100.0 |
| 2005-05-09 14:30:00 | QQQ | ETF | 35.95 | 35.97 | 35.92 | 35.94 | 2642500.0 |
| 2005-05-09 15:00:00 | QQQ | ETF | 35.95 | 35.97 | 35.87 | 35.92 | 3049500.0 |
| 2005-05-09 15:30:00 | QQQ | ETF | 35.92 | 36.06 | 35.92 | 36.03 | 7409100.0 |
| 2005-05-09 08:30:00 | IWM | ETF | 59.385 | 59.385 | 59.385 | 59.385 | 2000.0 |
| 2005-05-09 09:00:00 | IWM | ETF | 59.34 | 59.34 | 59.33 | 59.33 | 3600.0 |
| 2005-05-09 09:30:00 | IWM | ETF | 59.33 | 59.5 | 59.175 | 59.265 | 1616800.0 |
| 2005-05-09 10:00:00 | IWM | ETF | 59.275 | 59.35 | 59.035 | 59.205 | 1919800.0 |
| 2005-05-09 10:30:00 | IWM | ETF | 59.2 | 59.38 | 59.045 | 59.285 | 1419200.0 |
| 2005-05-09 11:00:00 | IWM | ETF | 59.295 | 59.535 | 59.245 | 59.48 | 1319200.0 |
| 2005-05-09 11:30:00 | IWM | ETF | 59.475 | 59.645 | 59.475 | 59.565 | 1123400.0 |
| 2005-05-09 12:00:00 | IWM | ETF | 59.55 | 59.74 | 59.545 | 59.645 | 1019800.0 |
> showing 50 of 1,466 rows — these rows as CSV