PREVIEW / etf_30min / 2006-08-16
file: by_date/etf_30min/2006/2006-08-16.parquet size: 80 KB rows: 2,844
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-16 07:00:00 | SPY | ETF | 128.69 | 128.69 | 128.62 | 128.68 | 15200.0 |
| 2006-08-16 07:30:00 | SPY | ETF | 128.67 | 128.71 | 128.62 | 128.71 | 156300.0 |
| 2006-08-16 08:00:00 | SPY | ETF | 128.68 | 128.75 | 128.63 | 128.64 | 428700.0 |
| 2006-08-16 08:30:00 | SPY | ETF | 128.68 | 129.34 | 128.68 | 129.31 | 3665100.0 |
| 2006-08-16 09:00:00 | SPY | ETF | 129.32 | 129.38 | 129.22 | 129.33 | 1210300.0 |
| 2006-08-16 09:30:00 | SPY | ETF | 129.32 | 129.4 | 129.12 | 129.12 | 7737100.0 |
| 2006-08-16 10:00:00 | SPY | ETF | 129.12 | 129.26 | 129.04 | 129.15 | 5221100.0 |
| 2006-08-16 10:30:00 | SPY | ETF | 129.15 | 129.46 | 129.12 | 129.36 | 5505000.0 |
| 2006-08-16 11:00:00 | SPY | ETF | 129.34 | 129.39 | 129.18 | 129.23 | 3242500.0 |
| 2006-08-16 11:30:00 | SPY | ETF | 129.23 | 129.46 | 129.22 | 129.34 | 2723600.0 |
| 2006-08-16 12:00:00 | SPY | ETF | 129.34 | 129.57 | 129.28 | 129.45 | 3202000.0 |
| 2006-08-16 12:30:00 | SPY | ETF | 129.45 | 129.6 | 129.24 | 129.39 | 5389000.0 |
| 2006-08-16 13:00:00 | SPY | ETF | 129.39 | 129.54 | 129.25 | 129.32 | 4583900.0 |
| 2006-08-16 13:30:00 | SPY | ETF | 129.32 | 129.46 | 129.25 | 129.45 | 2148600.0 |
| 2006-08-16 14:00:00 | SPY | ETF | 129.44 | 129.58 | 129.35 | 129.43 | 2489300.0 |
| 2006-08-16 14:30:00 | SPY | ETF | 129.43 | 129.73 | 129.42 | 129.66 | 5260500.0 |
| 2006-08-16 15:00:00 | SPY | ETF | 129.66 | 129.86 | 129.65 | 129.77 | 5684000.0 |
| 2006-08-16 15:30:00 | SPY | ETF | 129.76 | 129.89 | 129.66 | 129.75 | 7231300.0 |
| 2006-08-16 16:00:00 | SPY | ETF | 129.75 | 129.85 | 129.68 | 129.85 | 1175000.0 |
| 2006-08-16 16:30:00 | SPY | ETF | 129.85 | 129.85 | 129.65 | 129.72 | 416500.0 |
| 2006-08-16 17:00:00 | SPY | ETF | 129.74 | 129.76 | 129.71 | 129.71 | 2900.0 |
| 2006-08-16 17:30:00 | SPY | ETF | 129.77 | 129.8 | 129.77 | 129.79 | 6400.0 |
| 2006-08-16 18:00:00 | SPY | ETF | 129.74 | 129.74 | 129.65 | 129.68 | 21600.0 |
| 2006-08-16 18:30:00 | SPY | ETF | 129.65 | 129.65 | 129.65 | 129.65 | 600.0 |
| 2006-08-16 19:30:00 | SPY | ETF | 129.71 | 129.71 | 129.71 | 129.71 | 200.0 |
| 2006-08-16 09:30:00 | QQQ | ETF | 37.99 | 38.02 | 37.85 | 37.89 | 21286400.0 |
| 2006-08-16 10:00:00 | QQQ | ETF | 37.89 | 37.97 | 37.84 | 37.9 | 8259000.0 |
| 2006-08-16 10:30:00 | QQQ | ETF | 37.9 | 38.09 | 37.88 | 38.04 | 10383700.0 |
| 2006-08-16 11:00:00 | QQQ | ETF | 38.04 | 38.07 | 37.97 | 38.0 | 5007700.0 |
| 2006-08-16 11:30:00 | QQQ | ETF | 38.0 | 38.13 | 37.99 | 38.09 | 5655400.0 |
| 2006-08-16 12:00:00 | QQQ | ETF | 38.09 | 38.23 | 38.06 | 38.19 | 6980700.0 |
| 2006-08-16 12:30:00 | QQQ | ETF | 38.19 | 38.29 | 38.15 | 38.17 | 8061300.0 |
| 2006-08-16 13:00:00 | QQQ | ETF | 38.17 | 38.24 | 36.16 | 38.16 | 8511000.0 |
| 2006-08-16 13:30:00 | QQQ | ETF | 38.16 | 38.25 | 38.13 | 38.22 | 2776600.0 |
| 2006-08-16 14:00:00 | QQQ | ETF | 38.23 | 38.32 | 38.15 | 38.28 | 7256300.0 |
| 2006-08-16 14:30:00 | QQQ | ETF | 38.29 | 38.43 | 38.28 | 38.4 | 8657300.0 |
| 2006-08-16 15:00:00 | QQQ | ETF | 38.4 | 38.51 | 38.39 | 38.47 | 13172000.0 |
| 2006-08-16 15:30:00 | QQQ | ETF | 38.47 | 38.58 | 38.47 | 38.58 | 13173000.0 |
| 2006-08-16 08:00:00 | IWM | ETF | 69.42 | 69.47 | 69.36 | 69.4 | 258600.0 |
| 2006-08-16 08:30:00 | IWM | ETF | 69.45 | 70.09 | 69.45 | 70.08 | 1868900.0 |
| 2006-08-16 09:00:00 | IWM | ETF | 70.08 | 70.11 | 69.86 | 69.89 | 410300.0 |
| 2006-08-16 09:30:00 | IWM | ETF | 69.87 | 69.98 | 69.72 | 69.77 | 6412400.0 |
| 2006-08-16 10:00:00 | IWM | ETF | 69.78 | 69.85 | 69.49 | 69.61 | 4355700.0 |
| 2006-08-16 10:30:00 | IWM | ETF | 69.61 | 70.09 | 69.58 | 70.02 | 5349900.0 |
| 2006-08-16 11:00:00 | IWM | ETF | 70.03 | 70.04 | 69.8 | 69.86 | 2104900.0 |
| 2006-08-16 11:30:00 | IWM | ETF | 69.86 | 70.03 | 69.83 | 69.87 | 1810800.0 |
| 2006-08-16 12:00:00 | IWM | ETF | 69.88 | 70.15 | 69.83 | 70.11 | 3253900.0 |
| 2006-08-16 12:30:00 | IWM | ETF | 70.11 | 70.21 | 70.04 | 70.04 | 2150900.0 |
| 2006-08-16 13:00:00 | IWM | ETF | 70.05 | 70.13 | 69.84 | 69.94 | 1504800.0 |
| 2006-08-16 13:30:00 | IWM | ETF | 69.95 | 70.06 | 69.88 | 70.02 | 1382900.0 |
> showing 50 of 2,844 rows — these rows as CSV