PREVIEW / etf_30min / 2005-09-27
file: by_date/etf_30min/2005/2005-09-27.parquet size: 48 KB rows: 1,693
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-09-27 07:00:00 | SPY | ETF | 121.51 | 121.57 | 121.51 | 121.57 | 12100.0 |
| 2005-09-27 07:30:00 | SPY | ETF | 121.58 | 121.58 | 121.52 | 121.52 | 2900.0 |
| 2005-09-27 08:00:00 | SPY | ETF | 121.55 | 121.58 | 121.49 | 121.55 | 82300.0 |
| 2005-09-27 08:30:00 | SPY | ETF | 121.56 | 121.58 | 121.51 | 121.51 | 993800.0 |
| 2005-09-27 09:00:00 | SPY | ETF | 121.5 | 121.61 | 121.49 | 121.54 | 435000.0 |
| 2005-09-27 09:30:00 | SPY | ETF | 121.52 | 121.66 | 121.39 | 121.63 | 4152700.0 |
| 2005-09-27 10:00:00 | SPY | ETF | 121.62 | 121.64 | 121.18 | 121.35 | 7547500.0 |
| 2005-09-27 10:30:00 | SPY | ETF | 121.34 | 121.43 | 121.02 | 121.16 | 8270100.0 |
| 2005-09-27 11:00:00 | SPY | ETF | 121.16 | 121.33 | 121.11 | 121.22 | 3797100.0 |
| 2005-09-27 11:30:00 | SPY | ETF | 121.23 | 121.27 | 121.07 | 121.23 | 2715800.0 |
| 2005-09-27 12:00:00 | SPY | ETF | 121.23 | 121.37 | 121.14 | 121.19 | 2971800.0 |
| 2005-09-27 12:30:00 | SPY | ETF | 121.21 | 121.38 | 121.15 | 121.26 | 1072700.0 |
| 2005-09-27 13:00:00 | SPY | ETF | 121.26 | 121.32 | 121.04 | 121.27 | 2908100.0 |
| 2005-09-27 13:30:00 | SPY | ETF | 121.29 | 121.47 | 121.2 | 121.43 | 4105100.0 |
| 2005-09-27 14:00:00 | SPY | ETF | 121.43 | 121.59 | 121.33 | 121.47 | 4233800.0 |
| 2005-09-27 14:30:00 | SPY | ETF | 121.46 | 121.9 | 121.43 | 121.85 | 6795700.0 |
| 2005-09-27 15:00:00 | SPY | ETF | 121.83 | 121.99 | 121.77 | 121.8 | 6055000.0 |
| 2005-09-27 15:30:00 | SPY | ETF | 121.81 | 121.83 | 121.47 | 121.5 | 5412300.0 |
| 2005-09-27 16:00:00 | SPY | ETF | 121.49 | 121.62 | 121.49 | 121.57 | 1767200.0 |
| 2005-09-27 16:30:00 | SPY | ETF | 121.56 | 121.58 | 121.52 | 121.55 | 284800.0 |
| 2005-09-27 17:00:00 | SPY | ETF | 121.55 | 121.57 | 121.55 | 121.55 | 3400.0 |
| 2005-09-27 17:30:00 | SPY | ETF | 121.57 | 121.6 | 121.57 | 121.6 | 1100.0 |
| 2005-09-27 18:00:00 | SPY | ETF | 121.53 | 121.53 | 121.52 | 121.52 | 600.0 |
| 2005-09-27 18:30:00 | SPY | ETF | 121.5 | 121.5 | 121.5 | 121.5 | 5100.0 |
| 2005-09-27 19:30:00 | SPY | ETF | 121.53 | 121.53 | 121.53 | 121.53 | 100.0 |
| 2005-09-27 09:30:00 | QQQ | ETF | 38.8 | 38.85 | 38.75 | 38.84 | 7952900.0 |
| 2005-09-27 10:00:00 | QQQ | ETF | 38.83 | 38.83 | 38.67 | 38.75 | 6731900.0 |
| 2005-09-27 10:30:00 | QQQ | ETF | 38.74 | 38.78 | 38.62 | 38.66 | 5123700.0 |
| 2005-09-27 11:00:00 | QQQ | ETF | 38.66 | 38.69 | 38.63 | 38.66 | 2870500.0 |
| 2005-09-27 11:30:00 | QQQ | ETF | 38.67 | 38.72 | 38.63 | 38.7 | 2575900.0 |
| 2005-09-27 12:00:00 | QQQ | ETF | 38.71 | 38.74 | 38.67 | 38.68 | 1974600.0 |
| 2005-09-27 12:30:00 | QQQ | ETF | 38.68 | 38.75 | 38.65 | 38.68 | 1544000.0 |
| 2005-09-27 13:00:00 | QQQ | ETF | 38.68 | 38.69 | 38.51 | 38.62 | 4929600.0 |
| 2005-09-27 13:30:00 | QQQ | ETF | 38.62 | 38.7 | 38.58 | 38.7 | 4530800.0 |
| 2005-09-27 14:00:00 | QQQ | ETF | 38.7 | 38.76 | 38.65 | 38.7 | 4388600.0 |
| 2005-09-27 14:30:00 | QQQ | ETF | 38.7 | 38.85 | 38.66 | 38.81 | 5515900.0 |
| 2005-09-27 15:00:00 | QQQ | ETF | 38.81 | 38.9 | 38.8 | 38.82 | 5748200.0 |
| 2005-09-27 15:30:00 | QQQ | ETF | 38.82 | 38.82 | 38.65 | 38.67 | 7074100.0 |
| 2005-09-27 08:00:00 | IWM | ETF | 65.55 | 65.56 | 65.51 | 65.51 | 562000.0 |
| 2005-09-27 08:30:00 | IWM | ETF | 65.52 | 65.52 | 65.51 | 65.52 | 45800.0 |
| 2005-09-27 09:00:00 | IWM | ETF | 65.52 | 65.53 | 65.51 | 65.53 | 36800.0 |
| 2005-09-27 09:30:00 | IWM | ETF | 65.52 | 65.59 | 65.31 | 65.4 | 2273300.0 |
| 2005-09-27 10:00:00 | IWM | ETF | 65.37 | 65.39 | 65.1 | 65.22 | 3134400.0 |
| 2005-09-27 10:30:00 | IWM | ETF | 65.21 | 65.29 | 65.03 | 65.04 | 2871900.0 |
| 2005-09-27 11:00:00 | IWM | ETF | 65.04 | 65.16 | 64.9724 | 65.09 | 2303700.0 |
| 2005-09-27 11:30:00 | IWM | ETF | 65.1 | 65.15 | 65.03 | 65.14 | 665500.0 |
| 2005-09-27 12:00:00 | IWM | ETF | 65.14 | 65.24 | 65.09 | 65.14 | 720300.0 |
| 2005-09-27 12:30:00 | IWM | ETF | 65.13 | 65.22 | 65.062 | 65.13 | 750700.0 |
| 2005-09-27 13:00:00 | IWM | ETF | 65.14 | 65.17 | 64.96 | 65.02 | 1553200.0 |
| 2005-09-27 13:30:00 | IWM | ETF | 65.02 | 65.27 | 65.0 | 65.18 | 2028400.0 |
> showing 50 of 1,693 rows — these rows as CSV