PREVIEW / etf_30min / 2006-11-13
file: by_date/etf_30min/2006/2006-11-13.parquet size: 86 KB rows: 3,062
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-13 06:00:00 | SPY | ETF | 138.31 | 138.32 | 138.31 | 138.32 | 20000.0 |
| 2006-11-13 07:00:00 | SPY | ETF | 138.23 | 138.23 | 138.23 | 138.23 | 500.0 |
| 2006-11-13 07:30:00 | SPY | ETF | 138.19 | 138.22 | 138.16 | 138.22 | 14500.0 |
| 2006-11-13 08:00:00 | SPY | ETF | 138.22 | 138.28 | 138.11 | 138.11 | 358700.0 |
| 2006-11-13 08:30:00 | SPY | ETF | 138.11 | 138.21 | 138.11 | 138.14 | 68900.0 |
| 2006-11-13 09:00:00 | SPY | ETF | 138.14 | 138.25 | 138.14 | 138.17 | 273200.0 |
| 2006-11-13 09:30:00 | SPY | ETF | 138.18 | 138.73 | 138.07 | 138.71 | 9256000.0 |
| 2006-11-13 10:00:00 | SPY | ETF | 138.71 | 139.04 | 138.68 | 138.94 | 9411400.0 |
| 2006-11-13 10:30:00 | SPY | ETF | 138.93 | 138.97 | 138.8 | 138.87 | 3362200.0 |
| 2006-11-13 11:00:00 | SPY | ETF | 138.87 | 138.97 | 138.8 | 138.8 | 3362900.0 |
| 2006-11-13 11:30:00 | SPY | ETF | 138.8 | 138.87 | 138.7 | 138.83 | 4708800.0 |
| 2006-11-13 12:00:00 | SPY | ETF | 138.83 | 138.94 | 138.72 | 138.9 | 2005200.0 |
| 2006-11-13 12:30:00 | SPY | ETF | 138.92 | 138.93 | 138.56 | 138.58 | 2611100.0 |
| 2006-11-13 13:00:00 | SPY | ETF | 138.58 | 138.72 | 138.56 | 138.64 | 1336300.0 |
| 2006-11-13 13:30:00 | SPY | ETF | 138.64 | 138.83 | 138.52 | 138.72 | 2636000.0 |
| 2006-11-13 14:00:00 | SPY | ETF | 138.72 | 138.81 | 138.65 | 138.79 | 2360800.0 |
| 2006-11-13 14:30:00 | SPY | ETF | 138.79 | 138.91 | 138.73 | 138.86 | 2773800.0 |
| 2006-11-13 15:00:00 | SPY | ETF | 138.85 | 138.85 | 138.7 | 138.7 | 2006600.0 |
| 2006-11-13 15:30:00 | SPY | ETF | 138.7 | 138.79 | 138.64 | 138.7 | 3622700.0 |
| 2006-11-13 16:00:00 | SPY | ETF | 138.7 | 138.7 | 138.58 | 138.6 | 1539600.0 |
| 2006-11-13 16:30:00 | SPY | ETF | 138.6 | 138.6 | 138.56 | 138.56 | 119700.0 |
| 2006-11-13 17:00:00 | SPY | ETF | 138.6 | 138.61 | 138.6 | 138.61 | 600.0 |
| 2006-11-13 17:30:00 | SPY | ETF | 138.61 | 138.61 | 138.61 | 138.61 | 100.0 |
| 2006-11-13 18:00:00 | SPY | ETF | 138.61 | 138.61 | 138.55 | 138.55 | 5300.0 |
| 2006-11-13 18:30:00 | SPY | ETF | 138.58 | 138.63 | 138.57 | 138.63 | 10300.0 |
| 2006-11-13 19:00:00 | SPY | ETF | 138.65 | 138.65 | 138.65 | 138.65 | 300.0 |
| 2006-11-13 19:30:00 | SPY | ETF | 138.62 | 138.62 | 138.62 | 138.62 | 500.0 |
| 2006-11-13 09:30:00 | QQQ | ETF | 43.05 | 43.41 | 43.0 | 43.39 | 14803000.0 |
| 2006-11-13 10:00:00 | QQQ | ETF | 43.39 | 43.54 | 42.42 | 43.45 | 16094100.0 |
| 2006-11-13 10:30:00 | QQQ | ETF | 43.45 | 43.47 | 43.39 | 43.41 | 4582300.0 |
| 2006-11-13 11:00:00 | QQQ | ETF | 43.4 | 43.47 | 43.39 | 43.39 | 3252400.0 |
| 2006-11-13 11:30:00 | QQQ | ETF | 43.39 | 43.44 | 43.3 | 43.4 | 5512600.0 |
| 2006-11-13 12:00:00 | QQQ | ETF | 43.4 | 43.46 | 43.36 | 43.45 | 2023900.0 |
| 2006-11-13 12:30:00 | QQQ | ETF | 43.45 | 43.45 | 43.3 | 43.3 | 4710800.0 |
| 2006-11-13 13:00:00 | QQQ | ETF | 43.3 | 43.38 | 43.29 | 43.34 | 2543900.0 |
| 2006-11-13 13:30:00 | QQQ | ETF | 43.34 | 43.41 | 43.28 | 43.37 | 4316400.0 |
| 2006-11-13 14:00:00 | QQQ | ETF | 43.37 | 43.42 | 43.32 | 43.42 | 2018500.0 |
| 2006-11-13 14:30:00 | QQQ | ETF | 43.42 | 43.47 | 43.4 | 43.44 | 3094700.0 |
| 2006-11-13 15:00:00 | QQQ | ETF | 43.45 | 43.5 | 43.35 | 43.38 | 6779100.0 |
| 2006-11-13 15:30:00 | QQQ | ETF | 43.39 | 43.47 | 43.37 | 43.47 | 7017900.0 |
| 2006-11-13 07:00:00 | IWM | ETF | 76.5 | 76.5 | 76.5 | 76.5 | 100.0 |
| 2006-11-13 08:00:00 | IWM | ETF | 76.45 | 76.45 | 76.45 | 76.45 | 300.0 |
| 2006-11-13 08:30:00 | IWM | ETF | 76.48 | 76.5 | 76.35 | 76.4 | 12900.0 |
| 2006-11-13 09:00:00 | IWM | ETF | 76.39 | 76.46 | 76.39 | 76.4 | 24500.0 |
| 2006-11-13 09:30:00 | IWM | ETF | 76.43 | 76.81 | 76.2 | 76.77 | 3819100.0 |
| 2006-11-13 10:00:00 | IWM | ETF | 76.78 | 76.95 | 76.71 | 76.86 | 4624600.0 |
| 2006-11-13 10:30:00 | IWM | ETF | 76.86 | 76.99 | 76.75 | 76.77 | 3752200.0 |
| 2006-11-13 11:00:00 | IWM | ETF | 76.77 | 76.9 | 76.64 | 76.64 | 3847100.0 |
| 2006-11-13 11:30:00 | IWM | ETF | 76.65 | 76.71 | 76.47 | 76.64 | 4086300.0 |
| 2006-11-13 12:00:00 | IWM | ETF | 76.63 | 76.81 | 76.58 | 76.81 | 969600.0 |
> showing 50 of 3,062 rows — these rows as CSV