PREVIEW / etf_30min / 2006-08-10
file: by_date/etf_30min/2006/2006-08-10.parquet size: 77 KB rows: 2,662
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-10 04:00:00 | SPY | ETF | 126.21 | 126.21 | 126.21 | 126.21 | 800.0 |
| 2006-08-10 05:30:00 | SPY | ETF | 126.53 | 126.53 | 126.53 | 126.53 | 100.0 |
| 2006-08-10 06:00:00 | SPY | ETF | 126.44 | 126.45 | 126.44 | 126.45 | 10000.0 |
| 2006-08-10 06:30:00 | SPY | ETF | 126.47 | 126.47 | 126.29 | 126.31 | 17200.0 |
| 2006-08-10 07:00:00 | SPY | ETF | 126.31 | 126.51 | 126.24 | 126.32 | 158900.0 |
| 2006-08-10 07:30:00 | SPY | ETF | 126.35 | 126.37 | 126.2 | 126.27 | 180700.0 |
| 2006-08-10 08:00:00 | SPY | ETF | 126.3 | 126.5 | 126.16 | 126.36 | 1449500.0 |
| 2006-08-10 08:30:00 | SPY | ETF | 126.36 | 126.62 | 126.31 | 126.62 | 545900.0 |
| 2006-08-10 09:00:00 | SPY | ETF | 126.63 | 126.66 | 126.41 | 126.51 | 1191800.0 |
| 2006-08-10 09:30:00 | SPY | ETF | 126.53 | 126.79 | 126.36 | 126.71 | 9085400.0 |
| 2006-08-10 10:00:00 | SPY | ETF | 126.68 | 126.74 | 126.28 | 126.72 | 7726700.0 |
| 2006-08-10 10:30:00 | SPY | ETF | 126.72 | 126.84 | 126.55 | 126.74 | 5060300.0 |
| 2006-08-10 11:00:00 | SPY | ETF | 126.73 | 127.14 | 126.63 | 126.93 | 5236800.0 |
| 2006-08-10 11:30:00 | SPY | ETF | 126.92 | 126.97 | 126.67 | 126.91 | 3189600.0 |
| 2006-08-10 12:00:00 | SPY | ETF | 126.91 | 127.01 | 126.78 | 126.97 | 2325400.0 |
| 2006-08-10 12:30:00 | SPY | ETF | 126.97 | 127.03 | 126.82 | 126.94 | 2226700.0 |
| 2006-08-10 13:00:00 | SPY | ETF | 126.95 | 126.96 | 126.73 | 126.83 | 3241000.0 |
| 2006-08-10 13:30:00 | SPY | ETF | 126.83 | 127.28 | 126.82 | 127.11 | 3587600.0 |
| 2006-08-10 14:00:00 | SPY | ETF | 127.11 | 127.45 | 127.11 | 127.29 | 5462900.0 |
| 2006-08-10 14:30:00 | SPY | ETF | 127.28 | 127.33 | 127.0 | 127.09 | 3823700.0 |
| 2006-08-10 15:00:00 | SPY | ETF | 127.08 | 127.27 | 126.93 | 127.07 | 3555900.0 |
| 2006-08-10 15:30:00 | SPY | ETF | 127.07 | 127.5 | 127.03 | 127.28 | 5197100.0 |
| 2006-08-10 16:00:00 | SPY | ETF | 127.28 | 127.37 | 127.23 | 127.25 | 2549500.0 |
| 2006-08-10 16:30:00 | SPY | ETF | 127.25 | 127.38 | 127.23 | 127.35 | 79400.0 |
| 2006-08-10 17:00:00 | SPY | ETF | 127.36 | 127.36 | 127.29 | 127.3 | 159500.0 |
| 2006-08-10 17:30:00 | SPY | ETF | 127.33 | 127.37 | 127.33 | 127.33 | 1200.0 |
| 2006-08-10 18:00:00 | SPY | ETF | 127.33 | 127.36 | 127.33 | 127.35 | 1800.0 |
| 2006-08-10 19:30:00 | SPY | ETF | 127.3 | 127.31 | 127.3 | 127.31 | 1600.0 |
| 2006-08-10 09:30:00 | QQQ | ETF | 36.46 | 36.61 | 36.31 | 36.53 | 18311700.0 |
| 2006-08-10 10:00:00 | QQQ | ETF | 36.53 | 36.59 | 36.36 | 36.57 | 8931700.0 |
| 2006-08-10 10:30:00 | QQQ | ETF | 36.58 | 36.64 | 36.47 | 36.54 | 8848900.0 |
| 2006-08-10 11:00:00 | QQQ | ETF | 36.53 | 36.73 | 36.52 | 36.64 | 8393900.0 |
| 2006-08-10 11:30:00 | QQQ | ETF | 36.65 | 36.7 | 36.55 | 36.7 | 5970600.0 |
| 2006-08-10 12:00:00 | QQQ | ETF | 36.7 | 36.74 | 36.63 | 36.72 | 4045200.0 |
| 2006-08-10 12:30:00 | QQQ | ETF | 36.73 | 36.75 | 36.64 | 36.68 | 4751700.0 |
| 2006-08-10 13:00:00 | QQQ | ETF | 36.68 | 36.69 | 36.59 | 36.61 | 4806000.0 |
| 2006-08-10 13:30:00 | QQQ | ETF | 36.61 | 36.77 | 36.6 | 36.72 | 5839200.0 |
| 2006-08-10 14:00:00 | QQQ | ETF | 36.72 | 36.88 | 36.71 | 36.8 | 7930500.0 |
| 2006-08-10 14:30:00 | QQQ | ETF | 36.8 | 36.82 | 36.66 | 36.72 | 4308600.0 |
| 2006-08-10 15:00:00 | QQQ | ETF | 36.71 | 36.75 | 36.64 | 36.67 | 4068100.0 |
| 2006-08-10 15:30:00 | QQQ | ETF | 36.67 | 36.82 | 36.65 | 36.77 | 6280200.0 |
| 2006-08-10 07:30:00 | IWM | ETF | 67.2 | 67.26 | 67.1 | 67.1 | 28000.0 |
| 2006-08-10 08:00:00 | IWM | ETF | 67.1 | 67.19 | 66.98 | 67.14 | 124600.0 |
| 2006-08-10 08:30:00 | IWM | ETF | 67.13 | 67.35 | 67.13 | 67.35 | 80400.0 |
| 2006-08-10 09:00:00 | IWM | ETF | 67.35 | 67.4 | 67.15 | 67.27 | 243700.0 |
| 2006-08-10 09:30:00 | IWM | ETF | 67.31 | 67.65 | 67.03 | 67.58 | 8648400.0 |
| 2006-08-10 10:00:00 | IWM | ETF | 67.59 | 67.75 | 67.27 | 67.72 | 5673500.0 |
| 2006-08-10 10:30:00 | IWM | ETF | 67.72 | 67.93 | 67.42 | 67.6 | 4252900.0 |
| 2006-08-10 11:00:00 | IWM | ETF | 67.61 | 67.96 | 67.48 | 67.84 | 3070300.0 |
| 2006-08-10 11:30:00 | IWM | ETF | 67.85 | 67.93 | 67.63 | 67.91 | 3263500.0 |
> showing 50 of 2,662 rows — these rows as CSV