PREVIEW / etf_30min / 2006-11-22
file: by_date/etf_30min/2006/2006-11-22.parquet size: 86 KB rows: 3,056
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-22 07:00:00 | SPY | ETF | 140.9 | 140.95 | 140.89 | 140.9 | 22200.0 |
| 2006-11-22 07:30:00 | SPY | ETF | 140.87 | 140.88 | 140.82 | 140.86 | 14100.0 |
| 2006-11-22 08:00:00 | SPY | ETF | 140.95 | 140.95 | 140.8 | 140.81 | 938700.0 |
| 2006-11-22 08:30:00 | SPY | ETF | 140.81 | 140.85 | 140.68 | 140.69 | 204000.0 |
| 2006-11-22 09:00:00 | SPY | ETF | 140.7 | 140.78 | 140.7 | 140.74 | 144800.0 |
| 2006-11-22 09:30:00 | SPY | ETF | 140.75 | 141.16 | 140.65 | 140.89 | 8208400.0 |
| 2006-11-22 10:00:00 | SPY | ETF | 140.89 | 140.94 | 140.5 | 140.65 | 10694100.0 |
| 2006-11-22 10:30:00 | SPY | ETF | 140.65 | 140.74 | 140.53 | 140.58 | 3534300.0 |
| 2006-11-22 11:00:00 | SPY | ETF | 140.58 | 140.78 | 140.58 | 140.67 | 2922500.0 |
| 2006-11-22 11:30:00 | SPY | ETF | 140.7 | 140.78 | 140.65 | 140.66 | 1231300.0 |
| 2006-11-22 12:00:00 | SPY | ETF | 140.66 | 140.7 | 140.59 | 140.65 | 1200700.0 |
| 2006-11-22 12:30:00 | SPY | ETF | 140.65 | 140.75 | 140.6 | 140.6725 | 1626000.0 |
| 2006-11-22 13:00:00 | SPY | ETF | 140.68 | 140.71 | 140.65 | 140.71 | 860900.0 |
| 2006-11-22 13:30:00 | SPY | ETF | 140.71 | 140.74 | 140.67 | 140.69 | 796900.0 |
| 2006-11-22 14:00:00 | SPY | ETF | 140.69 | 140.74 | 140.67 | 140.72 | 2790500.0 |
| 2006-11-22 14:30:00 | SPY | ETF | 140.73 | 140.95 | 140.71 | 140.8699 | 1643000.0 |
| 2006-11-22 15:00:00 | SPY | ETF | 140.87 | 140.91 | 140.79 | 140.83 | 1205800.0 |
| 2006-11-22 15:30:00 | SPY | ETF | 140.83 | 140.95 | 140.81 | 140.92 | 2728300.0 |
| 2006-11-22 16:00:00 | SPY | ETF | 140.93 | 141.0 | 140.89 | 140.93 | 694000.0 |
| 2006-11-22 16:30:00 | SPY | ETF | 140.93 | 140.93 | 140.8 | 140.81 | 1576900.0 |
| 2006-11-22 17:00:00 | SPY | ETF | 140.81 | 140.85 | 140.81 | 140.83 | 6400.0 |
| 2006-11-22 17:30:00 | SPY | ETF | 140.83 | 140.83 | 140.77 | 140.78 | 22600.0 |
| 2006-11-22 18:00:00 | SPY | ETF | 140.84 | 140.84 | 140.78 | 140.78 | 3400.0 |
| 2006-11-22 19:30:00 | SPY | ETF | 140.83 | 140.83 | 140.83 | 140.83 | 100.0 |
| 2006-11-22 09:30:00 | QQQ | ETF | 44.58 | 44.7 | 44.46 | 44.51 | 15573700.0 |
| 2006-11-22 10:00:00 | QQQ | ETF | 44.51 | 44.54 | 44.26 | 44.39 | 12670600.0 |
| 2006-11-22 10:30:00 | QQQ | ETF | 44.39 | 44.48 | 44.34 | 44.46 | 5419200.0 |
| 2006-11-22 11:00:00 | QQQ | ETF | 44.46 | 44.56 | 44.46 | 44.56 | 2773800.0 |
| 2006-11-22 11:30:00 | QQQ | ETF | 44.56 | 44.64 | 44.55 | 44.59 | 3112700.0 |
| 2006-11-22 12:00:00 | QQQ | ETF | 44.59 | 44.61 | 44.55 | 44.57 | 1698000.0 |
| 2006-11-22 12:30:00 | QQQ | ETF | 44.57 | 44.62 | 44.41 | 44.59 | 1246800.0 |
| 2006-11-22 13:00:00 | QQQ | ETF | 44.59 | 44.61 | 44.56 | 44.59 | 1009100.0 |
| 2006-11-22 13:30:00 | QQQ | ETF | 44.6 | 44.63 | 44.58 | 44.61 | 739600.0 |
| 2006-11-22 14:00:00 | QQQ | ETF | 44.61 | 44.64 | 44.6 | 44.63 | 1509600.0 |
| 2006-11-22 14:30:00 | QQQ | ETF | 44.63 | 44.74 | 44.63 | 44.71 | 3151100.0 |
| 2006-11-22 15:00:00 | QQQ | ETF | 44.71 | 44.75 | 44.7 | 44.71 | 2503100.0 |
| 2006-11-22 15:30:00 | QQQ | ETF | 44.71 | 44.75 | 44.71 | 44.73 | 4402600.0 |
| 2006-11-22 07:30:00 | IWM | ETF | 79.0 | 79.0 | 79.0 | 79.0 | 200.0 |
| 2006-11-22 08:00:00 | IWM | ETF | 79.01 | 79.08 | 79.01 | 79.04 | 58100.0 |
| 2006-11-22 08:30:00 | IWM | ETF | 79.07 | 79.09 | 78.94 | 78.95 | 142600.0 |
| 2006-11-22 09:00:00 | IWM | ETF | 78.95 | 78.98 | 78.93 | 78.98 | 264300.0 |
| 2006-11-22 09:30:00 | IWM | ETF | 78.97 | 79.11 | 78.85 | 79.0 | 4221000.0 |
| 2006-11-22 10:00:00 | IWM | ETF | 78.99 | 79.04 | 78.56 | 78.74 | 4409200.0 |
| 2006-11-22 10:30:00 | IWM | ETF | 78.73 | 79.01 | 78.65 | 78.78 | 1743500.0 |
| 2006-11-22 11:00:00 | IWM | ETF | 78.78 | 78.86 | 78.77 | 78.83 | 1689700.0 |
| 2006-11-22 11:30:00 | IWM | ETF | 78.8375 | 78.88 | 78.63 | 78.66 | 5563600.0 |
| 2006-11-22 12:00:00 | IWM | ETF | 78.65 | 78.77 | 78.62 | 78.74 | 2343000.0 |
| 2006-11-22 12:30:00 | IWM | ETF | 78.7325 | 78.75 | 78.65 | 78.7 | 1902900.0 |
| 2006-11-22 13:00:00 | IWM | ETF | 78.7 | 78.79 | 78.69 | 78.79 | 710500.0 |
| 2006-11-22 13:30:00 | IWM | ETF | 78.78 | 78.84 | 78.78 | 78.8 | 788200.0 |
> showing 50 of 3,056 rows — these rows as CSV