PREVIEW / etf_30min / 2006-08-11
file: by_date/etf_30min/2006/2006-08-11.parquet size: 72 KB rows: 2,613
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-08-11 06:30:00 | SPY | ETF | 127.35 | 127.37 | 127.35 | 127.37 | 3000.0 |
| 2006-08-11 07:00:00 | SPY | ETF | 127.29 | 127.37 | 127.29 | 127.37 | 7700.0 |
| 2006-08-11 07:30:00 | SPY | ETF | 127.37 | 127.38 | 127.3 | 127.3 | 68500.0 |
| 2006-08-11 08:00:00 | SPY | ETF | 127.29 | 127.36 | 127.28 | 127.3 | 111900.0 |
| 2006-08-11 08:30:00 | SPY | ETF | 127.32 | 127.43 | 126.26 | 127.28 | 1220100.0 |
| 2006-08-11 09:00:00 | SPY | ETF | 127.28 | 127.29 | 127.15 | 127.15 | 588200.0 |
| 2006-08-11 09:30:00 | SPY | ETF | 127.17 | 127.2 | 126.83 | 126.89 | 5744600.0 |
| 2006-08-11 10:00:00 | SPY | ETF | 126.89 | 127.03 | 126.74 | 126.96 | 6913400.0 |
| 2006-08-11 10:30:00 | SPY | ETF | 126.97 | 127.1 | 126.87 | 126.96 | 1682400.0 |
| 2006-08-11 11:00:00 | SPY | ETF | 126.97 | 127.04 | 126.84 | 126.91 | 2892400.0 |
| 2006-08-11 11:30:00 | SPY | ETF | 126.91 | 127.01 | 126.64 | 126.68 | 3051500.0 |
| 2006-08-11 12:00:00 | SPY | ETF | 126.69 | 126.8 | 126.62 | 126.8 | 1855700.0 |
| 2006-08-11 12:30:00 | SPY | ETF | 126.81 | 126.86 | 126.55 | 126.65 | 2265300.0 |
| 2006-08-11 13:00:00 | SPY | ETF | 126.6499 | 126.7 | 126.39 | 126.48 | 2879200.0 |
| 2006-08-11 13:30:00 | SPY | ETF | 126.47 | 126.77 | 126.45 | 126.7 | 3525500.0 |
| 2006-08-11 14:00:00 | SPY | ETF | 126.71 | 126.83 | 126.55 | 126.57 | 2441300.0 |
| 2006-08-11 14:30:00 | SPY | ETF | 126.6 | 126.78 | 126.49 | 126.7 | 1342800.0 |
| 2006-08-11 15:00:00 | SPY | ETF | 126.71 | 126.8 | 126.52 | 126.78 | 3053600.0 |
| 2006-08-11 15:30:00 | SPY | ETF | 126.78 | 127.0 | 126.74 | 126.84 | 5919700.0 |
| 2006-08-11 16:00:00 | SPY | ETF | 126.85 | 127.06 | 126.84 | 127.0 | 1094500.0 |
| 2006-08-11 16:30:00 | SPY | ETF | 126.97 | 127.0 | 126.95 | 126.95 | 14600.0 |
| 2006-08-11 17:00:00 | SPY | ETF | 127.0 | 127.0 | 126.95 | 126.99 | 4600.0 |
| 2006-08-11 17:30:00 | SPY | ETF | 126.99 | 127.0 | 126.99 | 127.0 | 5100.0 |
| 2006-08-11 18:00:00 | SPY | ETF | 126.99 | 126.99 | 126.9 | 126.9 | 7100.0 |
| 2006-08-11 19:00:00 | SPY | ETF | 127.0 | 127.0 | 127.0 | 127.0 | 1100.0 |
| 2006-08-11 09:30:00 | QQQ | ETF | 36.65 | 36.69 | 36.5 | 36.52 | 10817100.0 |
| 2006-08-11 10:00:00 | QQQ | ETF | 36.52 | 36.64 | 36.47 | 36.61 | 9923900.0 |
| 2006-08-11 10:30:00 | QQQ | ETF | 36.61 | 36.67 | 36.57 | 36.62 | 6864400.0 |
| 2006-08-11 11:00:00 | QQQ | ETF | 36.61 | 36.65 | 36.54 | 36.56 | 7809800.0 |
| 2006-08-11 11:30:00 | QQQ | ETF | 36.55 | 36.58 | 36.44 | 36.47 | 4108600.0 |
| 2006-08-11 12:00:00 | QQQ | ETF | 36.46 | 36.5 | 36.43 | 36.5 | 3016400.0 |
| 2006-08-11 12:30:00 | QQQ | ETF | 36.5 | 36.53 | 36.43 | 36.49 | 4225400.0 |
| 2006-08-11 13:00:00 | QQQ | ETF | 36.49 | 36.54 | 36.37 | 36.39 | 6908600.0 |
| 2006-08-11 13:30:00 | QQQ | ETF | 36.39 | 36.5 | 36.39 | 36.47 | 5316000.0 |
| 2006-08-11 14:00:00 | QQQ | ETF | 36.47 | 36.52 | 36.42 | 36.44 | 4032200.0 |
| 2006-08-11 14:30:00 | QQQ | ETF | 36.44 | 36.5 | 36.4 | 36.46 | 2611200.0 |
| 2006-08-11 15:00:00 | QQQ | ETF | 36.45 | 36.49 | 36.41 | 36.48 | 3429500.0 |
| 2006-08-11 15:30:00 | QQQ | ETF | 36.47 | 36.54 | 36.46 | 36.54 | 7792500.0 |
| 2006-08-11 07:30:00 | IWM | ETF | 68.25 | 68.26 | 68.23 | 68.23 | 30100.0 |
| 2006-08-11 08:00:00 | IWM | ETF | 68.28 | 68.35 | 68.28 | 68.28 | 90800.0 |
| 2006-08-11 08:30:00 | IWM | ETF | 68.36 | 68.47 | 68.13 | 68.17 | 209200.0 |
| 2006-08-11 09:00:00 | IWM | ETF | 68.15 | 68.18 | 68.05 | 68.05 | 471900.0 |
| 2006-08-11 09:30:00 | IWM | ETF | 68.06 | 68.07 | 67.54 | 67.59 | 6382700.0 |
| 2006-08-11 10:00:00 | IWM | ETF | 67.59 | 67.76 | 67.45 | 67.72 | 3194600.0 |
| 2006-08-11 10:30:00 | IWM | ETF | 67.74 | 67.85 | 67.63 | 67.71 | 1921700.0 |
| 2006-08-11 11:00:00 | IWM | ETF | 67.71 | 67.79 | 67.49 | 67.55 | 4541300.0 |
| 2006-08-11 11:30:00 | IWM | ETF | 67.55 | 67.7 | 67.37 | 67.39 | 4714200.0 |
| 2006-08-11 12:00:00 | IWM | ETF | 67.39 | 67.52 | 67.3 | 67.51 | 2111200.0 |
| 2006-08-11 12:30:00 | IWM | ETF | 67.52 | 67.6 | 67.36 | 67.46 | 2500300.0 |
| 2006-08-11 13:00:00 | IWM | ETF | 67.45 | 67.5 | 67.23 | 67.28 | 2352200.0 |
> showing 50 of 2,613 rows — these rows as CSV