PREVIEW / etf_30min / 2006-09-25
file: by_date/etf_30min/2006/2006-09-25.parquet size: 85 KB rows: 2,865
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-25 04:00:00 | SPY | ETF | 131.74 | 131.75 | 131.74 | 131.75 | 200.0 |
| 2006-09-25 07:00:00 | SPY | ETF | 131.8 | 131.82 | 131.78 | 131.78 | 7200.0 |
| 2006-09-25 07:30:00 | SPY | ETF | 131.82 | 131.83 | 131.79 | 131.81 | 41800.0 |
| 2006-09-25 08:00:00 | SPY | ETF | 131.84 | 131.94 | 131.77 | 131.94 | 2148200.0 |
| 2006-09-25 08:30:00 | SPY | ETF | 131.94 | 131.95 | 131.79 | 131.79 | 395700.0 |
| 2006-09-25 09:00:00 | SPY | ETF | 131.81 | 131.81 | 131.69 | 131.72 | 382200.0 |
| 2006-09-25 09:30:00 | SPY | ETF | 131.73 | 131.91 | 131.51 | 131.52 | 6339200.0 |
| 2006-09-25 10:00:00 | SPY | ETF | 131.52 | 131.67 | 131.22 | 131.24 | 9093800.0 |
| 2006-09-25 10:30:00 | SPY | ETF | 131.24 | 131.35 | 131.05 | 131.32 | 6522900.0 |
| 2006-09-25 11:00:00 | SPY | ETF | 131.33 | 131.63 | 131.31 | 131.56 | 5784300.0 |
| 2006-09-25 11:30:00 | SPY | ETF | 131.54 | 131.62 | 131.32 | 131.33 | 3675000.0 |
| 2006-09-25 12:00:00 | SPY | ETF | 131.32 | 131.73 | 131.24 | 131.68 | 4360100.0 |
| 2006-09-25 12:30:00 | SPY | ETF | 131.68 | 132.25 | 131.68 | 132.2201 | 10581800.0 |
| 2006-09-25 13:00:00 | SPY | ETF | 132.23 | 132.37 | 132.11 | 132.17 | 6302400.0 |
| 2006-09-25 13:30:00 | SPY | ETF | 132.16 | 132.3 | 132.06 | 132.11 | 4295400.0 |
| 2006-09-25 14:00:00 | SPY | ETF | 132.11 | 132.5 | 132.11 | 132.29 | 4415700.0 |
| 2006-09-25 14:30:00 | SPY | ETF | 132.29 | 132.77 | 132.28 | 132.69 | 6319400.0 |
| 2006-09-25 15:00:00 | SPY | ETF | 132.7 | 132.85 | 132.64 | 132.77 | 8746400.0 |
| 2006-09-25 15:30:00 | SPY | ETF | 132.77 | 132.79 | 132.52 | 132.53 | 7136200.0 |
| 2006-09-25 16:00:00 | SPY | ETF | 132.53 | 132.57 | 132.41 | 132.43 | 807900.0 |
| 2006-09-25 16:30:00 | SPY | ETF | 132.48 | 132.48 | 132.4 | 132.44 | 348800.0 |
| 2006-09-25 17:00:00 | SPY | ETF | 132.45 | 132.45 | 132.45 | 132.45 | 900.0 |
| 2006-09-25 17:30:00 | SPY | ETF | 132.41 | 132.41 | 132.4 | 132.4 | 600.0 |
| 2006-09-25 18:00:00 | SPY | ETF | 132.45 | 132.47 | 132.43 | 132.47 | 9800.0 |
| 2006-09-25 19:00:00 | SPY | ETF | 132.47 | 132.47 | 132.47 | 132.47 | 200.0 |
| 2006-09-25 19:30:00 | SPY | ETF | 132.47 | 132.47 | 132.45 | 132.45 | 600.0 |
| 2006-09-25 09:30:00 | QQQ | ETF | 40.04 | 40.17 | 39.94 | 39.94 | 12479600.0 |
| 2006-09-25 10:00:00 | QQQ | ETF | 39.94 | 40.03 | 39.71 | 39.74 | 13476700.0 |
| 2006-09-25 10:30:00 | QQQ | ETF | 39.73 | 39.85 | 39.68 | 39.85 | 6137100.0 |
| 2006-09-25 11:00:00 | QQQ | ETF | 39.84 | 40.08 | 39.84 | 40.06 | 13948100.0 |
| 2006-09-25 11:30:00 | QQQ | ETF | 40.06 | 40.1 | 39.97 | 39.98 | 4720500.0 |
| 2006-09-25 12:00:00 | QQQ | ETF | 39.98 | 40.26 | 39.92 | 40.24 | 11683900.0 |
| 2006-09-25 12:30:00 | QQQ | ETF | 40.24 | 40.44 | 40.23 | 40.43 | 12932300.0 |
| 2006-09-25 13:00:00 | QQQ | ETF | 40.43 | 40.52 | 40.32 | 40.34 | 10193900.0 |
| 2006-09-25 13:30:00 | QQQ | ETF | 40.35 | 40.4 | 40.27 | 40.28 | 5231700.0 |
| 2006-09-25 14:00:00 | QQQ | ETF | 40.29 | 40.44 | 40.28 | 40.33 | 6045900.0 |
| 2006-09-25 14:30:00 | QQQ | ETF | 40.34 | 40.52 | 40.34 | 40.49 | 5586000.0 |
| 2006-09-25 15:00:00 | QQQ | ETF | 40.49 | 40.66 | 40.45 | 40.64 | 16634700.0 |
| 2006-09-25 15:30:00 | QQQ | ETF | 40.64 | 40.65 | 40.5 | 40.56 | 10110700.0 |
| 2006-09-25 07:00:00 | IWM | ETF | 71.54 | 71.54 | 71.54 | 71.54 | 600.0 |
| 2006-09-25 07:30:00 | IWM | ETF | 71.73 | 71.8 | 71.73 | 71.8 | 9900.0 |
| 2006-09-25 08:00:00 | IWM | ETF | 71.62 | 71.86 | 71.62 | 71.86 | 249000.0 |
| 2006-09-25 08:30:00 | IWM | ETF | 71.55 | 71.9 | 71.55 | 71.8 | 1010800.0 |
| 2006-09-25 09:00:00 | IWM | ETF | 71.77 | 71.78 | 71.74 | 71.77 | 107200.0 |
| 2006-09-25 09:30:00 | IWM | ETF | 71.78 | 71.83 | 71.28 | 71.29 | 5463300.0 |
| 2006-09-25 10:00:00 | IWM | ETF | 71.28 | 71.48 | 71.17 | 71.28 | 4466500.0 |
| 2006-09-25 10:30:00 | IWM | ETF | 71.28 | 71.4 | 71.11 | 71.36 | 5954500.0 |
| 2006-09-25 11:00:00 | IWM | ETF | 71.36 | 71.72 | 71.36 | 71.65 | 6705200.0 |
| 2006-09-25 11:30:00 | IWM | ETF | 71.65 | 71.8 | 71.57 | 71.64 | 5085900.0 |
| 2006-09-25 12:00:00 | IWM | ETF | 71.65 | 71.94 | 71.52 | 71.87 | 2586200.0 |
> showing 50 of 2,865 rows — these rows as CSV