PREVIEW / etf_30min / 2006-11-03
file: by_date/etf_30min/2006/2006-11-03.parquet size: 86 KB rows: 3,034
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-03 06:00:00 | SPY | ETF | 136.98 | 136.98 | 136.98 | 136.98 | 10000.0 |
| 2006-11-03 06:30:00 | SPY | ETF | 137.0 | 137.0 | 137.0 | 137.0 | 10000.0 |
| 2006-11-03 07:00:00 | SPY | ETF | 136.95 | 136.95 | 136.9 | 136.93 | 97400.0 |
| 2006-11-03 07:30:00 | SPY | ETF | 136.92 | 136.96 | 136.9 | 136.96 | 16800.0 |
| 2006-11-03 08:00:00 | SPY | ETF | 136.93 | 136.97 | 136.83 | 136.83 | 607300.0 |
| 2006-11-03 08:30:00 | SPY | ETF | 136.84 | 137.24 | 136.7 | 137.16 | 5602100.0 |
| 2006-11-03 09:00:00 | SPY | ETF | 137.18 | 137.32 | 137.18 | 137.26 | 4113200.0 |
| 2006-11-03 09:30:00 | SPY | ETF | 137.27 | 137.39 | 136.91 | 137.04 | 8846300.0 |
| 2006-11-03 10:00:00 | SPY | ETF | 137.03 | 137.23 | 136.92 | 136.94 | 10200200.0 |
| 2006-11-03 10:30:00 | SPY | ETF | 136.94 | 136.99 | 136.69 | 136.89 | 4742300.0 |
| 2006-11-03 11:00:00 | SPY | ETF | 136.88 | 137.08 | 136.46 | 136.55 | 4123900.0 |
| 2006-11-03 11:30:00 | SPY | ETF | 136.55 | 136.62 | 136.33 | 136.54 | 4014600.0 |
| 2006-11-03 12:00:00 | SPY | ETF | 136.52 | 136.6 | 136.33 | 136.46 | 2540400.0 |
| 2006-11-03 12:30:00 | SPY | ETF | 136.45 | 136.54 | 136.33 | 136.39 | 1684200.0 |
| 2006-11-03 13:00:00 | SPY | ETF | 136.39 | 136.62 | 136.2 | 136.53 | 4647400.0 |
| 2006-11-03 13:30:00 | SPY | ETF | 136.52 | 136.62 | 136.4 | 136.529 | 2173400.0 |
| 2006-11-03 14:00:00 | SPY | ETF | 136.53 | 136.73 | 136.38 | 136.66 | 3128700.0 |
| 2006-11-03 14:30:00 | SPY | ETF | 136.67 | 136.83 | 136.64 | 136.65 | 4196700.0 |
| 2006-11-03 15:00:00 | SPY | ETF | 136.66 | 136.7 | 136.46 | 136.55 | 3641900.0 |
| 2006-11-03 15:30:00 | SPY | ETF | 136.56 | 136.79 | 136.54 | 136.6 | 4411400.0 |
| 2006-11-03 16:00:00 | SPY | ETF | 136.59 | 136.6 | 136.43 | 136.44 | 683700.0 |
| 2006-11-03 16:30:00 | SPY | ETF | 136.44 | 136.5 | 136.42 | 136.46 | 160100.0 |
| 2006-11-03 17:00:00 | SPY | ETF | 136.46 | 136.46 | 136.41 | 136.42 | 7400.0 |
| 2006-11-03 17:30:00 | SPY | ETF | 136.45 | 136.45 | 136.44 | 136.44 | 500.0 |
| 2006-11-03 09:30:00 | QQQ | ETF | 42.1 | 42.19 | 41.95 | 42.0 | 13858400.0 |
| 2006-11-03 10:00:00 | QQQ | ETF | 42.0 | 42.12 | 41.94 | 41.95 | 8859700.0 |
| 2006-11-03 10:30:00 | QQQ | ETF | 41.95 | 41.96 | 41.79 | 41.87 | 9771100.0 |
| 2006-11-03 11:00:00 | QQQ | ETF | 41.86 | 42.7 | 41.64 | 41.7 | 8748400.0 |
| 2006-11-03 11:30:00 | QQQ | ETF | 41.69 | 41.73 | 41.62 | 41.71 | 6960100.0 |
| 2006-11-03 12:00:00 | QQQ | ETF | 41.71 | 41.74 | 41.64 | 41.7 | 4300000.0 |
| 2006-11-03 12:30:00 | QQQ | ETF | 41.7 | 41.72 | 41.65 | 41.67 | 1618900.0 |
| 2006-11-03 13:00:00 | QQQ | ETF | 41.67 | 41.83 | 41.61 | 41.78 | 6389800.0 |
| 2006-11-03 13:30:00 | QQQ | ETF | 41.78 | 41.82 | 41.74 | 41.8 | 2820400.0 |
| 2006-11-03 14:00:00 | QQQ | ETF | 41.8 | 41.91 | 41.73 | 41.86 | 5609200.0 |
| 2006-11-03 14:30:00 | QQQ | ETF | 41.87 | 41.93 | 41.84 | 41.88 | 4608200.0 |
| 2006-11-03 15:00:00 | QQQ | ETF | 41.87 | 41.88 | 41.78 | 41.82 | 4038800.0 |
| 2006-11-03 15:30:00 | QQQ | ETF | 41.82 | 41.94 | 41.82 | 41.92 | 8961200.0 |
| 2006-11-03 08:00:00 | IWM | ETF | 74.68 | 74.68 | 74.55 | 74.55 | 38700.0 |
| 2006-11-03 08:30:00 | IWM | ETF | 74.44 | 74.8 | 74.39 | 74.65 | 1110100.0 |
| 2006-11-03 09:00:00 | IWM | ETF | 74.72 | 74.85 | 74.71 | 74.81 | 370500.0 |
| 2006-11-03 09:30:00 | IWM | ETF | 74.82 | 75.24 | 74.82 | 74.93 | 6513900.0 |
| 2006-11-03 10:00:00 | IWM | ETF | 74.93 | 75.09 | 74.85 | 74.88 | 3611000.0 |
| 2006-11-03 10:30:00 | IWM | ETF | 74.87 | 74.91 | 74.54 | 74.71 | 3521700.0 |
| 2006-11-03 11:00:00 | IWM | ETF | 74.72 | 74.75 | 74.38 | 74.46 | 2041300.0 |
| 2006-11-03 11:30:00 | IWM | ETF | 74.45 | 74.54 | 74.24 | 74.37 | 4749100.0 |
| 2006-11-03 12:00:00 | IWM | ETF | 74.38 | 74.45 | 74.21 | 74.41 | 3864100.0 |
| 2006-11-03 12:30:00 | IWM | ETF | 74.41 | 74.51 | 74.31 | 74.34 | 1125200.0 |
| 2006-11-03 13:00:00 | IWM | ETF | 74.33 | 74.65 | 74.22 | 74.57 | 4238800.0 |
| 2006-11-03 13:30:00 | IWM | ETF | 74.58 | 74.7 | 74.54 | 74.69 | 2235900.0 |
| 2006-11-03 14:00:00 | IWM | ETF | 74.68 | 74.77 | 74.45 | 74.72 | 2817200.0 |
> showing 50 of 3,034 rows — these rows as CSV