PREVIEW / etf_30min / 2006-11-28
file: by_date/etf_30min/2006/2006-11-28.parquet size: 89 KB rows: 3,069
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-28 06:00:00 | SPY | ETF | 138.44 | 138.44 | 138.44 | 138.44 | 10000.0 |
| 2006-11-28 06:30:00 | SPY | ETF | 138.39 | 138.42 | 138.39 | 138.42 | 1100.0 |
| 2006-11-28 07:00:00 | SPY | ETF | 138.51 | 138.53 | 138.45 | 138.45 | 19400.0 |
| 2006-11-28 07:30:00 | SPY | ETF | 138.45 | 138.52 | 138.45 | 138.49 | 32100.0 |
| 2006-11-28 08:00:00 | SPY | ETF | 138.49 | 138.53 | 138.34 | 138.42 | 1106500.0 |
| 2006-11-28 08:30:00 | SPY | ETF | 138.42 | 138.52 | 137.96 | 138.05 | 3526100.0 |
| 2006-11-28 09:00:00 | SPY | ETF | 138.06 | 138.26 | 138.02 | 138.26 | 955500.0 |
| 2006-11-28 09:30:00 | SPY | ETF | 138.24 | 138.45 | 138.11 | 138.37 | 14268400.0 |
| 2006-11-28 10:00:00 | SPY | ETF | 138.38 | 138.89 | 138.17 | 138.85 | 17576300.0 |
| 2006-11-28 10:30:00 | SPY | ETF | 138.84 | 139.1 | 138.77 | 138.89 | 10273800.0 |
| 2006-11-28 11:00:00 | SPY | ETF | 138.89 | 139.0 | 138.79 | 138.86 | 4213400.0 |
| 2006-11-28 11:30:00 | SPY | ETF | 138.86 | 139.09 | 138.72 | 138.79 | 4117500.0 |
| 2006-11-28 12:00:00 | SPY | ETF | 138.79 | 138.96 | 138.71 | 138.87 | 2613000.0 |
| 2006-11-28 12:30:00 | SPY | ETF | 138.87 | 138.89 | 138.51 | 138.67 | 7103600.0 |
| 2006-11-28 13:00:00 | SPY | ETF | 138.67 | 139.03 | 138.44 | 138.56 | 7590200.0 |
| 2006-11-28 13:30:00 | SPY | ETF | 138.55 | 138.78 | 138.51 | 138.64 | 5503500.0 |
| 2006-11-28 14:00:00 | SPY | ETF | 138.64 | 138.89 | 138.58 | 138.84 | 3804100.0 |
| 2006-11-28 14:30:00 | SPY | ETF | 138.84 | 138.95 | 138.72 | 138.82 | 2853900.0 |
| 2006-11-28 15:00:00 | SPY | ETF | 138.83 | 139.14 | 138.74 | 139.02 | 6796600.0 |
| 2006-11-28 15:30:00 | SPY | ETF | 139.02 | 139.16 | 138.99 | 139.03 | 6917300.0 |
| 2006-11-28 16:00:00 | SPY | ETF | 139.02 | 139.04 | 138.8024 | 139.0 | 1288700.0 |
| 2006-11-28 16:30:00 | SPY | ETF | 139.0 | 139.11 | 138.98 | 139.08 | 599000.0 |
| 2006-11-28 17:00:00 | SPY | ETF | 139.1 | 139.1 | 137.6665 | 139.07 | 659500.0 |
| 2006-11-28 17:30:00 | SPY | ETF | 139.04 | 139.05 | 139.04 | 139.05 | 1500.0 |
| 2006-11-28 18:00:00 | SPY | ETF | 139.08 | 139.1 | 139.08 | 139.1 | 13800.0 |
| 2006-11-28 18:30:00 | SPY | ETF | 139.11 | 139.11 | 139.11 | 139.11 | 3200.0 |
| 2006-11-28 19:30:00 | SPY | ETF | 139.11 | 139.14 | 139.11 | 139.14 | 600.0 |
| 2006-11-28 09:30:00 | QQQ | ETF | 43.52 | 43.64 | 43.34 | 43.49 | 20353000.0 |
| 2006-11-28 10:00:00 | QQQ | ETF | 43.49 | 43.73 | 43.38 | 43.69 | 22070300.0 |
| 2006-11-28 10:30:00 | QQQ | ETF | 43.7 | 43.78 | 43.59 | 43.63 | 12995400.0 |
| 2006-11-28 11:00:00 | QQQ | ETF | 43.62 | 43.7 | 43.43 | 43.64 | 4055100.0 |
| 2006-11-28 11:30:00 | QQQ | ETF | 43.64 | 43.75 | 43.6 | 43.63 | 4735500.0 |
| 2006-11-28 12:00:00 | QQQ | ETF | 43.62 | 43.77 | 43.42 | 43.66 | 3775100.0 |
| 2006-11-28 12:30:00 | QQQ | ETF | 43.66 | 43.67 | 43.52 | 43.59 | 6664500.0 |
| 2006-11-28 13:00:00 | QQQ | ETF | 43.59 | 43.68 | 43.5 | 43.54 | 4344800.0 |
| 2006-11-28 13:30:00 | QQQ | ETF | 43.53 | 43.62 | 43.51 | 43.54 | 4066600.0 |
| 2006-11-28 14:00:00 | QQQ | ETF | 43.54 | 43.69 | 43.51 | 43.66 | 6092000.0 |
| 2006-11-28 14:30:00 | QQQ | ETF | 43.67 | 43.72 | 43.55 | 43.66 | 2205000.0 |
| 2006-11-28 15:00:00 | QQQ | ETF | 43.67 | 43.81 | 43.62 | 43.77 | 7435300.0 |
| 2006-11-28 15:30:00 | QQQ | ETF | 43.77 | 43.84 | 43.75 | 43.77 | 11640600.0 |
| 2006-11-28 07:30:00 | IWM | ETF | 76.65 | 76.8 | 76.65 | 76.8 | 300.0 |
| 2006-11-28 08:00:00 | IWM | ETF | 76.74 | 76.8 | 76.72 | 76.75 | 134600.0 |
| 2006-11-28 08:30:00 | IWM | ETF | 76.68 | 76.78 | 76.48 | 76.49 | 487500.0 |
| 2006-11-28 09:00:00 | IWM | ETF | 76.5 | 76.63 | 76.46 | 76.59 | 346400.0 |
| 2006-11-28 09:30:00 | IWM | ETF | 76.59 | 76.78 | 76.29 | 76.45 | 7178900.0 |
| 2006-11-28 10:00:00 | IWM | ETF | 76.45 | 76.87 | 76.42 | 76.76 | 10215800.0 |
| 2006-11-28 10:30:00 | IWM | ETF | 76.76 | 77.09 | 76.72 | 76.93 | 6602300.0 |
| 2006-11-28 11:00:00 | IWM | ETF | 76.93 | 77.02 | 76.83 | 76.86 | 4408100.0 |
| 2006-11-28 11:30:00 | IWM | ETF | 76.87 | 77.16 | 76.85 | 76.93 | 4922300.0 |
| 2006-11-28 12:00:00 | IWM | ETF | 76.92 | 76.96 | 76.8 | 76.89 | 2856200.0 |
> showing 50 of 3,069 rows — these rows as CSV