PREVIEW / etf_30min / 2006-09-18
file: by_date/etf_30min/2006/2006-09-18.parquet size: 80 KB rows: 2,828
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-09-18 06:30:00 | SPY | ETF | 132.09 | 132.09 | 132.09 | 132.09 | 900.0 |
| 2006-09-18 07:00:00 | SPY | ETF | 132.05 | 132.12 | 132.05 | 132.08 | 8600.0 |
| 2006-09-18 07:30:00 | SPY | ETF | 132.08 | 132.08 | 132.0 | 132.06 | 57100.0 |
| 2006-09-18 08:00:00 | SPY | ETF | 132.05 | 132.06 | 131.96 | 132.0 | 1067500.0 |
| 2006-09-18 08:30:00 | SPY | ETF | 131.98 | 132.05 | 131.86 | 131.96 | 1000700.0 |
| 2006-09-18 09:00:00 | SPY | ETF | 131.95 | 131.95 | 131.71 | 131.79 | 939000.0 |
| 2006-09-18 09:30:00 | SPY | ETF | 131.79 | 131.99 | 131.65 | 131.94 | 5712600.0 |
| 2006-09-18 10:00:00 | SPY | ETF | 131.94 | 132.22 | 131.85 | 132.11 | 7331800.0 |
| 2006-09-18 10:30:00 | SPY | ETF | 132.1076 | 132.17 | 131.92 | 131.96 | 3068900.0 |
| 2006-09-18 11:00:00 | SPY | ETF | 131.97 | 132.09 | 131.9 | 132.06 | 3136000.0 |
| 2006-09-18 11:30:00 | SPY | ETF | 132.07 | 132.33 | 132.02 | 132.22 | 4197000.0 |
| 2006-09-18 12:00:00 | SPY | ETF | 132.22 | 132.31 | 132.08 | 132.14 | 3261800.0 |
| 2006-09-18 12:30:00 | SPY | ETF | 132.14 | 132.31 | 132.08 | 132.29 | 2133100.0 |
| 2006-09-18 13:00:00 | SPY | ETF | 132.29 | 132.39 | 132.19 | 132.35 | 3248500.0 |
| 2006-09-18 13:30:00 | SPY | ETF | 132.34 | 132.36 | 131.8 | 131.9 | 7902500.0 |
| 2006-09-18 14:00:00 | SPY | ETF | 131.9 | 131.95 | 131.78 | 131.92 | 2489000.0 |
| 2006-09-18 14:30:00 | SPY | ETF | 131.92 | 131.93 | 131.69 | 131.84 | 3954400.0 |
| 2006-09-18 15:00:00 | SPY | ETF | 131.84 | 132.05 | 131.81 | 132.01 | 3942300.0 |
| 2006-09-18 15:30:00 | SPY | ETF | 132.02 | 132.12 | 131.93 | 132.02 | 4491800.0 |
| 2006-09-18 16:00:00 | SPY | ETF | 132.02 | 132.19 | 131.99 | 132.14 | 2281800.0 |
| 2006-09-18 16:30:00 | SPY | ETF | 132.14 | 132.16 | 132.11 | 132.16 | 265500.0 |
| 2006-09-18 17:00:00 | SPY | ETF | 132.12 | 132.12 | 132.01 | 132.08 | 1013600.0 |
| 2006-09-18 17:30:00 | SPY | ETF | 132.05 | 132.05 | 132.05 | 132.05 | 500.0 |
| 2006-09-18 18:00:00 | SPY | ETF | 132.05 | 132.05 | 132.04 | 132.05 | 1400.0 |
| 2006-09-18 18:30:00 | SPY | ETF | 132.04 | 132.06 | 132.04 | 132.06 | 1000.0 |
| 2006-09-18 19:30:00 | SPY | ETF | 132.06 | 132.08 | 132.06 | 132.08 | 21500.0 |
| 2006-09-18 09:30:00 | QQQ | ETF | 40.12 | 40.28 | 40.03 | 40.23 | 11609800.0 |
| 2006-09-18 10:00:00 | QQQ | ETF | 40.23 | 40.37 | 40.18 | 40.27 | 8339900.0 |
| 2006-09-18 10:30:00 | QQQ | ETF | 40.26 | 40.36 | 40.19 | 40.2 | 7702000.0 |
| 2006-09-18 11:00:00 | QQQ | ETF | 40.21 | 40.27 | 40.15 | 40.27 | 5634200.0 |
| 2006-09-18 11:30:00 | QQQ | ETF | 40.27 | 40.4 | 40.25 | 40.33 | 6690300.0 |
| 2006-09-18 12:00:00 | QQQ | ETF | 40.34 | 40.35 | 40.22 | 40.26 | 4392900.0 |
| 2006-09-18 12:30:00 | QQQ | ETF | 40.26 | 40.38 | 40.24 | 40.37 | 4916700.0 |
| 2006-09-18 13:00:00 | QQQ | ETF | 40.37 | 40.4 | 40.31 | 40.36 | 4264000.0 |
| 2006-09-18 13:30:00 | QQQ | ETF | 40.36 | 40.36 | 40.07 | 40.1 | 12632500.0 |
| 2006-09-18 14:00:00 | QQQ | ETF | 40.09 | 40.14 | 40.06 | 40.1 | 7180900.0 |
| 2006-09-18 14:30:00 | QQQ | ETF | 40.1 | 40.2 | 39.94 | 40.04 | 15550200.0 |
| 2006-09-18 15:00:00 | QQQ | ETF | 40.04 | 40.1 | 39.98 | 40.07 | 4783800.0 |
| 2006-09-18 15:30:00 | QQQ | ETF | 40.07 | 40.14 | 40.05 | 40.12 | 9670400.0 |
| 2006-09-18 07:00:00 | IWM | ETF | 72.5 | 72.5 | 72.5 | 72.5 | 100.0 |
| 2006-09-18 08:00:00 | IWM | ETF | 72.52 | 72.52 | 72.51 | 72.51 | 2500.0 |
| 2006-09-18 08:30:00 | IWM | ETF | 72.48 | 72.49 | 72.44 | 72.45 | 71000.0 |
| 2006-09-18 09:00:00 | IWM | ETF | 72.36 | 72.39 | 72.31 | 72.33 | 235000.0 |
| 2006-09-18 09:30:00 | IWM | ETF | 72.35 | 72.58 | 72.14 | 72.55 | 6232800.0 |
| 2006-09-18 10:00:00 | IWM | ETF | 72.54 | 72.75 | 72.38 | 72.57 | 3745000.0 |
| 2006-09-18 10:30:00 | IWM | ETF | 72.57 | 72.7 | 72.4 | 72.42 | 2759700.0 |
| 2006-09-18 11:00:00 | IWM | ETF | 72.41 | 72.68 | 72.38 | 72.68 | 2048600.0 |
| 2006-09-18 11:30:00 | IWM | ETF | 72.67 | 72.95 | 72.64 | 72.86 | 2375200.0 |
| 2006-09-18 12:00:00 | IWM | ETF | 72.85 | 72.92 | 72.73 | 72.83 | 959300.0 |
| 2006-09-18 12:30:00 | IWM | ETF | 72.84 | 73.04 | 72.8 | 73.01 | 1740700.0 |
> showing 50 of 2,828 rows — these rows as CSV