PREVIEW / etf_30min / 2006-11-30
file: by_date/etf_30min/2006/2006-11-30.parquet size: 91 KB rows: 3,126
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-11-30 07:00:00 | SPY | ETF | 140.65 | 140.69 | 140.65 | 140.67 | 15700.0 |
| 2006-11-30 07:30:00 | SPY | ETF | 140.69 | 140.71 | 140.68 | 140.7 | 12700.0 |
| 2006-11-30 08:00:00 | SPY | ETF | 140.7 | 140.82 | 140.66 | 140.74 | 217600.0 |
| 2006-11-30 08:30:00 | SPY | ETF | 140.74 | 140.74 | 140.43 | 140.51 | 1806500.0 |
| 2006-11-30 09:00:00 | SPY | ETF | 140.52 | 140.53 | 140.4 | 140.43 | 371600.0 |
| 2006-11-30 09:30:00 | SPY | ETF | 140.44 | 140.69 | 140.25 | 140.49 | 8934000.0 |
| 2006-11-30 10:00:00 | SPY | ETF | 140.49 | 140.67 | 139.76 | 139.99 | 13282300.0 |
| 2006-11-30 10:30:00 | SPY | ETF | 140.02 | 140.32 | 139.9 | 140.15 | 6426400.0 |
| 2006-11-30 11:00:00 | SPY | ETF | 140.14 | 140.24 | 139.82 | 140.02 | 6016700.0 |
| 2006-11-30 11:30:00 | SPY | ETF | 140.02 | 140.03 | 139.8 | 139.94 | 3673400.0 |
| 2006-11-30 12:00:00 | SPY | ETF | 139.95 | 140.2 | 139.94 | 140.2 | 2986000.0 |
| 2006-11-30 12:30:00 | SPY | ETF | 140.2 | 140.3 | 140.14 | 140.17 | 2537400.0 |
| 2006-11-30 13:00:00 | SPY | ETF | 140.17 | 140.67 | 140.16 | 140.65 | 5666100.0 |
| 2006-11-30 13:30:00 | SPY | ETF | 140.66 | 140.67 | 140.24 | 140.25 | 6274500.0 |
| 2006-11-30 14:00:00 | SPY | ETF | 140.26 | 140.57 | 140.25 | 140.56 | 2617600.0 |
| 2006-11-30 14:30:00 | SPY | ETF | 140.56 | 140.97 | 140.35 | 140.9 | 7763400.0 |
| 2006-11-30 15:00:00 | SPY | ETF | 140.9 | 141.04 | 140.76 | 141.01 | 3423000.0 |
| 2006-11-30 15:30:00 | SPY | ETF | 141.0 | 141.05 | 140.45 | 140.45 | 7663100.0 |
| 2006-11-30 16:00:00 | SPY | ETF | 140.45 | 140.56 | 140.42 | 140.51 | 1592400.0 |
| 2006-11-30 16:30:00 | SPY | ETF | 140.51 | 140.51 | 140.45 | 140.46 | 618500.0 |
| 2006-11-30 17:00:00 | SPY | ETF | 140.45 | 140.48 | 140.4 | 140.45 | 283500.0 |
| 2006-11-30 17:30:00 | SPY | ETF | 140.45 | 140.45 | 140.36 | 140.39 | 8700.0 |
| 2006-11-30 18:00:00 | SPY | ETF | 140.4 | 140.45 | 140.4 | 140.45 | 1300.0 |
| 2006-11-30 18:30:00 | SPY | ETF | 140.45 | 140.45 | 140.45 | 140.45 | 1800.0 |
| 2006-11-30 19:00:00 | SPY | ETF | 140.47 | 140.47 | 140.47 | 140.47 | 100.0 |
| 2006-11-30 19:30:00 | SPY | ETF | 140.45 | 140.47 | 140.45 | 140.47 | 300.0 |
| 2006-11-30 09:30:00 | QQQ | ETF | 44.05 | 44.17 | 43.94 | 44.13 | 17758700.0 |
| 2006-11-30 10:00:00 | QQQ | ETF | 44.08 | 44.13 | 43.79 | 43.88 | 19918900.0 |
| 2006-11-30 10:30:00 | QQQ | ETF | 43.88 | 44.1 | 43.81 | 43.98 | 9178900.0 |
| 2006-11-30 11:00:00 | QQQ | ETF | 43.98 | 44.08 | 43.85 | 43.98 | 9387100.0 |
| 2006-11-30 11:30:00 | QQQ | ETF | 43.98 | 44.01 | 43.88 | 43.94 | 5593600.0 |
| 2006-11-30 12:00:00 | QQQ | ETF | 43.95 | 44.04 | 43.93 | 44.04 | 4812400.0 |
| 2006-11-30 12:30:00 | QQQ | ETF | 44.03 | 44.08 | 43.99 | 44.0 | 3421300.0 |
| 2006-11-30 13:00:00 | QQQ | ETF | 44.0 | 44.25 | 43.99 | 44.24 | 6637500.0 |
| 2006-11-30 13:30:00 | QQQ | ETF | 44.25 | 44.28 | 44.06 | 44.07 | 7071700.0 |
| 2006-11-30 14:00:00 | QQQ | ETF | 44.07 | 44.17 | 44.06 | 44.15 | 3589200.0 |
| 2006-11-30 14:30:00 | QQQ | ETF | 44.15 | 44.25 | 44.12 | 44.22 | 5095200.0 |
| 2006-11-30 15:00:00 | QQQ | ETF | 44.22 | 44.26 | 44.16 | 44.26 | 4374800.0 |
| 2006-11-30 15:30:00 | QQQ | ETF | 44.25 | 44.26 | 44.02 | 44.05 | 14768300.0 |
| 2006-11-30 07:30:00 | IWM | ETF | 78.15 | 78.15 | 78.15 | 78.15 | 100.0 |
| 2006-11-30 08:00:00 | IWM | ETF | 78.34 | 78.35 | 78.24 | 78.35 | 23000.0 |
| 2006-11-30 08:30:00 | IWM | ETF | 78.34 | 78.34 | 77.94 | 78.0 | 1436300.0 |
| 2006-11-30 09:00:00 | IWM | ETF | 78.01 | 78.04 | 77.87 | 77.9 | 356200.0 |
| 2006-11-30 09:30:00 | IWM | ETF | 77.9 | 78.32 | 77.81 | 78.18 | 5199100.0 |
| 2006-11-30 10:00:00 | IWM | ETF | 78.19 | 78.19 | 77.5 | 77.75 | 10090400.0 |
| 2006-11-30 10:30:00 | IWM | ETF | 77.75 | 78.05 | 77.55 | 77.93 | 4633100.0 |
| 2006-11-30 11:00:00 | IWM | ETF | 77.93 | 78.02 | 77.68 | 77.85 | 3427200.0 |
| 2006-11-30 11:30:00 | IWM | ETF | 77.84 | 77.95 | 77.77 | 77.9 | 1472600.0 |
| 2006-11-30 12:00:00 | IWM | ETF | 77.9 | 78.14 | 77.9 | 78.14 | 2681300.0 |
| 2006-11-30 12:30:00 | IWM | ETF | 78.14 | 78.21 | 78.06 | 78.11 | 2158300.0 |
> showing 50 of 3,126 rows — these rows as CSV