PREVIEW / etf_30min / 2006-09-26
file: by_date/etf_30min/2006/2006-09-26.parquet size: 83 KB rows: 2,921
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 |
|---|---|---|---|---|---|---|---|
| 2006-09-26 07:00:00 | SPY | ETF | 132.45 | 132.49 | 132.45 | 132.49 | 1300.0 |
| 2006-09-26 07:30:00 | SPY | ETF | 132.46 | 132.46 | 132.4 | 132.46 | 41100.0 |
| 2006-09-26 08:00:00 | SPY | ETF | 132.43 | 132.59 | 132.41 | 132.57 | 265800.0 |
| 2006-09-26 08:30:00 | SPY | ETF | 132.56 | 132.62 | 132.56 | 132.59 | 115600.0 |
| 2006-09-26 09:00:00 | SPY | ETF | 132.59 | 132.6 | 132.42 | 132.47 | 349900.0 |
| 2006-09-26 09:30:00 | SPY | ETF | 132.5 | 132.64 | 132.4 | 132.59 | 5049800.0 |
| 2006-09-26 10:00:00 | SPY | ETF | 132.6 | 133.24 | 132.56 | 133.17 | 13432000.0 |
| 2006-09-26 10:30:00 | SPY | ETF | 133.17 | 133.2 | 132.83 | 132.95 | 7312600.0 |
| 2006-09-26 11:00:00 | SPY | ETF | 132.94 | 133.21 | 132.91 | 132.96 | 3175800.0 |
| 2006-09-26 11:30:00 | SPY | ETF | 132.96 | 133.07 | 132.71 | 132.71 | 4669800.0 |
| 2006-09-26 12:00:00 | SPY | ETF | 132.7 | 133.15 | 132.69 | 133.13 | 3794900.0 |
| 2006-09-26 12:30:00 | SPY | ETF | 133.14 | 133.18 | 132.84 | 133.02 | 3987600.0 |
| 2006-09-26 13:00:00 | SPY | ETF | 133.01 | 133.16 | 132.89 | 133.11 | 2884500.0 |
| 2006-09-26 13:30:00 | SPY | ETF | 133.11 | 133.35 | 133.02 | 133.25 | 3604500.0 |
| 2006-09-26 14:00:00 | SPY | ETF | 133.25 | 133.34 | 133.01 | 133.17 | 4434900.0 |
| 2006-09-26 14:30:00 | SPY | ETF | 133.18 | 133.43 | 133.17 | 133.35 | 3482500.0 |
| 2006-09-26 15:00:00 | SPY | ETF | 133.35 | 133.45 | 133.23 | 133.44 | 4429300.0 |
| 2006-09-26 15:30:00 | SPY | ETF | 133.44 | 133.59 | 133.42 | 133.54 | 6107000.0 |
| 2006-09-26 16:00:00 | SPY | ETF | 133.53 | 133.61 | 133.48 | 133.58 | 959200.0 |
| 2006-09-26 16:30:00 | SPY | ETF | 133.58 | 133.58 | 133.44 | 133.47 | 693900.0 |
| 2006-09-26 17:00:00 | SPY | ETF | 133.45 | 133.55 | 133.45 | 133.48 | 450300.0 |
| 2006-09-26 17:30:00 | SPY | ETF | 133.48 | 133.57 | 133.48 | 133.57 | 101500.0 |
| 2006-09-26 18:00:00 | SPY | ETF | 133.53 | 133.53 | 133.45 | 133.45 | 4300.0 |
| 2006-09-26 18:30:00 | SPY | ETF | 133.46 | 133.46 | 133.46 | 133.46 | 100.0 |
| 2006-09-26 19:00:00 | SPY | ETF | 133.5 | 133.5 | 133.49 | 133.5 | 1000.0 |
| 2006-09-26 19:30:00 | SPY | ETF | 133.51 | 133.51 | 133.47 | 133.47 | 2000.0 |
| 2006-09-26 09:30:00 | QQQ | ETF | 40.51 | 40.59 | 40.43 | 40.56 | 10904900.0 |
| 2006-09-26 10:00:00 | QQQ | ETF | 40.56 | 40.8 | 40.56 | 40.68 | 19251500.0 |
| 2006-09-26 10:30:00 | QQQ | ETF | 40.67 | 40.71 | 40.51 | 40.58 | 9543100.0 |
| 2006-09-26 11:00:00 | QQQ | ETF | 40.58 | 40.66 | 40.51 | 40.55 | 5681800.0 |
| 2006-09-26 11:30:00 | QQQ | ETF | 40.54 | 40.62 | 40.41 | 40.41 | 9203900.0 |
| 2006-09-26 12:00:00 | QQQ | ETF | 40.41 | 40.59 | 40.4 | 40.55 | 6037200.0 |
| 2006-09-26 12:30:00 | QQQ | ETF | 40.56 | 40.56 | 40.43 | 40.53 | 3976800.0 |
| 2006-09-26 13:00:00 | QQQ | ETF | 40.52 | 40.62 | 40.47 | 40.61 | 3931600.0 |
| 2006-09-26 13:30:00 | QQQ | ETF | 40.61 | 40.73 | 40.56 | 40.67 | 6266100.0 |
| 2006-09-26 14:00:00 | QQQ | ETF | 40.67 | 40.72 | 40.56 | 40.61 | 8073400.0 |
| 2006-09-26 14:30:00 | QQQ | ETF | 40.63 | 40.77 | 40.62 | 40.72 | 7576500.0 |
| 2006-09-26 15:00:00 | QQQ | ETF | 40.72 | 40.76 | 40.66 | 40.75 | 5437900.0 |
| 2006-09-26 15:30:00 | QQQ | ETF | 40.74 | 40.79 | 40.72 | 40.76 | 8159600.0 |
| 2006-09-26 07:30:00 | IWM | ETF | 72.2 | 72.2 | 72.2 | 72.2 | 2000.0 |
| 2006-09-26 08:00:00 | IWM | ETF | 72.21 | 72.31 | 72.21 | 72.31 | 64700.0 |
| 2006-09-26 08:30:00 | IWM | ETF | 72.31 | 72.31 | 72.3 | 72.3 | 13400.0 |
| 2006-09-26 09:00:00 | IWM | ETF | 72.27 | 72.27 | 72.08 | 72.1 | 76800.0 |
| 2006-09-26 09:30:00 | IWM | ETF | 72.14 | 72.37 | 71.96 | 72.13 | 3397100.0 |
| 2006-09-26 10:00:00 | IWM | ETF | 72.13 | 72.75 | 72.13 | 72.62 | 8875700.0 |
| 2006-09-26 10:30:00 | IWM | ETF | 72.63 | 72.69 | 72.26 | 72.36 | 5302100.0 |
| 2006-09-26 11:00:00 | IWM | ETF | 72.36 | 72.56 | 72.28 | 72.29 | 1885900.0 |
| 2006-09-26 11:30:00 | IWM | ETF | 72.3 | 72.45 | 72.04 | 72.04 | 2514100.0 |
| 2006-09-26 12:00:00 | IWM | ETF | 72.02 | 72.28 | 71.98 | 72.25 | 3125700.0 |
| 2006-09-26 12:30:00 | IWM | ETF | 72.25 | 72.26 | 72.02 | 72.19 | 1113300.0 |
> showing 50 of 2,921 rows — these rows as CSV