PREVIEW / etf_30min / 2006-06-08
file: by_date/etf_30min/2006/2006-06-08.parquet size: 75 KB rows: 2,524
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-06-08 04:00:00 | SPY | ETF | 125.1 | 125.15 | 125.1 | 125.15 | 2600.0 |
| 2006-06-08 04:30:00 | SPY | ETF | 125.04 | 125.04 | 125.04 | 125.04 | 500.0 |
| 2006-06-08 06:00:00 | SPY | ETF | 125.24 | 125.25 | 125.24 | 125.25 | 2500.0 |
| 2006-06-08 06:30:00 | SPY | ETF | 125.56 | 125.56 | 125.35 | 125.35 | 38000.0 |
| 2006-06-08 07:00:00 | SPY | ETF | 125.41 | 125.41 | 125.18 | 125.24 | 826400.0 |
| 2006-06-08 07:30:00 | SPY | ETF | 125.24 | 125.34 | 125.19 | 125.29 | 193400.0 |
| 2006-06-08 08:00:00 | SPY | ETF | 125.28 | 125.56 | 125.17 | 125.55 | 3152400.0 |
| 2006-06-08 08:30:00 | SPY | ETF | 125.55 | 125.79 | 125.48 | 125.76 | 2875600.0 |
| 2006-06-08 09:00:00 | SPY | ETF | 125.76 | 125.86 | 125.14 | 125.59 | 1855300.0 |
| 2006-06-08 09:30:00 | SPY | ETF | 125.58 | 126.18 | 125.32 | 125.69 | 15692000.0 |
| 2006-06-08 10:00:00 | SPY | ETF | 125.69 | 125.86 | 125.25 | 125.27 | 11919000.0 |
| 2006-06-08 10:30:00 | SPY | ETF | 125.26 | 125.44 | 125.04 | 125.27 | 13583500.0 |
| 2006-06-08 11:00:00 | SPY | ETF | 125.24 | 126.13 | 124.32 | 124.67 | 22706100.0 |
| 2006-06-08 11:30:00 | SPY | ETF | 124.65 | 125.44 | 123.87 | 124.23 | 25804800.0 |
| 2006-06-08 12:00:00 | SPY | ETF | 124.23 | 124.81 | 124.19 | 124.49 | 13148500.0 |
| 2006-06-08 12:30:00 | SPY | ETF | 124.48 | 124.95 | 124.4 | 124.69 | 7916400.0 |
| 2006-06-08 13:00:00 | SPY | ETF | 124.7 | 124.77 | 124.31 | 124.6 | 4802700.0 |
| 2006-06-08 13:30:00 | SPY | ETF | 124.62 | 125.26 | 124.55 | 125.25 | 15510000.0 |
| 2006-06-08 14:00:00 | SPY | ETF | 125.25 | 125.33 | 124.89 | 125.26 | 12344700.0 |
| 2006-06-08 14:30:00 | SPY | ETF | 125.26 | 125.85 | 125.07 | 125.27 | 13420100.0 |
| 2006-06-08 15:00:00 | SPY | ETF | 125.27 | 126.13 | 125.16 | 125.73 | 15414900.0 |
| 2006-06-08 15:30:00 | SPY | ETF | 125.73 | 126.5 | 125.69 | 126.12 | 17905100.0 |
| 2006-06-08 16:00:00 | SPY | ETF | 126.11 | 126.2142 | 125.71 | 125.85 | 2507300.0 |
| 2006-06-08 16:30:00 | SPY | ETF | 125.83 | 126.02 | 125.83 | 126.01 | 118700.0 |
| 2006-06-08 17:00:00 | SPY | ETF | 126.04 | 126.06 | 126.0 | 126.04 | 109700.0 |
| 2006-06-08 17:30:00 | SPY | ETF | 126.06 | 126.09 | 126.05 | 126.09 | 3700.0 |
| 2006-06-08 18:00:00 | SPY | ETF | 126.02 | 126.04 | 125.9 | 126.04 | 3900.0 |
| 2006-06-08 18:30:00 | SPY | ETF | 126.04 | 126.04 | 126.02 | 126.02 | 4800.0 |
| 2006-06-08 19:00:00 | SPY | ETF | 126.02 | 126.04 | 126.02 | 126.02 | 5600.0 |
| 2006-06-08 19:30:00 | SPY | ETF | 126.0 | 126.04 | 125.98 | 126.04 | 1800.0 |
| 2006-06-08 09:30:00 | QQQ | ETF | 38.27 | 38.49 | 38.13 | 38.31 | 30070800.0 |
| 2006-06-08 10:00:00 | QQQ | ETF | 38.31 | 38.43 | 38.03 | 38.04 | 20746300.0 |
| 2006-06-08 10:30:00 | QQQ | ETF | 38.03 | 38.13 | 37.95 | 38.07 | 17000400.0 |
| 2006-06-08 11:00:00 | QQQ | ETF | 38.07 | 38.2 | 37.73 | 37.84 | 20974400.0 |
| 2006-06-08 11:30:00 | QQQ | ETF | 37.83 | 37.84 | 37.49 | 37.7 | 24509500.0 |
| 2006-06-08 12:00:00 | QQQ | ETF | 37.7 | 37.89 | 37.69 | 37.78 | 15281500.0 |
| 2006-06-08 12:30:00 | QQQ | ETF | 37.78 | 38.03 | 37.75 | 37.94 | 12537900.0 |
| 2006-06-08 13:00:00 | QQQ | ETF | 37.94 | 37.96 | 37.67 | 37.79 | 19017700.0 |
| 2006-06-08 13:30:00 | QQQ | ETF | 37.79 | 38.07 | 37.74 | 38.06 | 15787300.0 |
| 2006-06-08 14:00:00 | QQQ | ETF | 38.05 | 38.1 | 37.89 | 38.07 | 14452200.0 |
| 2006-06-08 14:30:00 | QQQ | ETF | 38.07 | 38.21 | 37.96 | 38.05 | 15068400.0 |
| 2006-06-08 15:00:00 | QQQ | ETF | 38.04 | 38.37 | 37.99 | 38.25 | 18936300.0 |
| 2006-06-08 15:30:00 | QQQ | ETF | 38.24 | 38.56 | 38.23 | 38.4 | 25049500.0 |
| 2006-06-08 08:00:00 | IWM | ETF | 69.68 | 69.74 | 69.5 | 69.74 | 82800.0 |
| 2006-06-08 08:30:00 | IWM | ETF | 69.77 | 69.95 | 69.69 | 69.95 | 202700.0 |
| 2006-06-08 09:00:00 | IWM | ETF | 69.94 | 69.95 | 69.79 | 69.79 | 174400.0 |
| 2006-06-08 09:30:00 | IWM | ETF | 69.78 | 69.97 | 69.12 | 69.55 | 14976800.0 |
| 2006-06-08 10:00:00 | IWM | ETF | 69.53 | 69.75 | 68.89 | 68.89 | 13942700.0 |
| 2006-06-08 10:30:00 | IWM | ETF | 68.89 | 69.12 | 68.81 | 69.05 | 11479800.0 |
| 2006-06-08 11:00:00 | IWM | ETF | 69.04 | 69.43 | 68.57 | 68.69 | 16581500.0 |
> showing 50 of 2,524 rows — these rows as CSV