PREVIEW / etf_30min / 2006-09-13
file: by_date/etf_30min/2006/2006-09-13.parquet size: 80 KB rows: 2,831
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-13 04:00:00 | SPY | ETF | 131.76 | 131.76 | 131.76 | 131.76 | 200.0 |
| 2006-09-13 05:00:00 | SPY | ETF | 131.73 | 131.73 | 131.69 | 131.69 | 300.0 |
| 2006-09-13 06:30:00 | SPY | ETF | 131.61 | 131.61 | 131.6 | 131.6 | 10000.0 |
| 2006-09-13 07:00:00 | SPY | ETF | 131.63 | 131.65 | 131.62 | 131.65 | 5000.0 |
| 2006-09-13 07:30:00 | SPY | ETF | 131.66 | 131.71 | 131.62 | 131.71 | 3300.0 |
| 2006-09-13 08:00:00 | SPY | ETF | 131.69 | 131.78 | 131.65 | 131.74 | 925200.0 |
| 2006-09-13 08:30:00 | SPY | ETF | 131.74 | 131.81 | 131.73 | 131.73 | 416200.0 |
| 2006-09-13 09:00:00 | SPY | ETF | 131.73 | 131.77 | 131.53 | 131.62 | 847300.0 |
| 2006-09-13 09:30:00 | SPY | ETF | 131.64 | 131.91 | 131.52 | 131.83 | 6575100.0 |
| 2006-09-13 10:00:00 | SPY | ETF | 131.82 | 131.83 | 131.7 | 131.81 | 4440600.0 |
| 2006-09-13 10:30:00 | SPY | ETF | 131.8 | 131.81 | 131.56 | 131.72 | 9608200.0 |
| 2006-09-13 11:00:00 | SPY | ETF | 131.71 | 131.94 | 131.69 | 131.87 | 2800500.0 |
| 2006-09-13 11:30:00 | SPY | ETF | 131.88 | 132.04 | 131.8 | 132.01 | 4634900.0 |
| 2006-09-13 12:00:00 | SPY | ETF | 132.04 | 132.21 | 131.95 | 132.13 | 4900800.0 |
| 2006-09-13 12:30:00 | SPY | ETF | 132.13 | 132.18 | 132.0 | 132.03 | 2359100.0 |
| 2006-09-13 13:00:00 | SPY | ETF | 132.03 | 132.11 | 131.96 | 132.03 | 2878300.0 |
| 2006-09-13 13:30:00 | SPY | ETF | 132.03 | 132.23 | 132.02 | 132.17 | 1689800.0 |
| 2006-09-13 14:00:00 | SPY | ETF | 132.17 | 132.24 | 132.09 | 132.14 | 2217100.0 |
| 2006-09-13 14:30:00 | SPY | ETF | 132.14 | 132.45 | 132.13 | 132.41 | 6720300.0 |
| 2006-09-13 15:00:00 | SPY | ETF | 132.41 | 132.41 | 132.07 | 132.15 | 5430800.0 |
| 2006-09-13 15:30:00 | SPY | ETF | 132.16 | 132.32 | 132.1 | 132.25 | 4335100.0 |
| 2006-09-13 16:00:00 | SPY | ETF | 132.25 | 132.26 | 132.19 | 132.22 | 435500.0 |
| 2006-09-13 16:30:00 | SPY | ETF | 132.21 | 132.21 | 132.13 | 132.16 | 399300.0 |
| 2006-09-13 17:00:00 | SPY | ETF | 132.16 | 132.17 | 132.13 | 132.16 | 9100.0 |
| 2006-09-13 17:30:00 | SPY | ETF | 132.18 | 132.18 | 132.18 | 132.18 | 1300.0 |
| 2006-09-13 18:00:00 | SPY | ETF | 132.16 | 132.18 | 132.16 | 132.17 | 13100.0 |
| 2006-09-13 18:30:00 | SPY | ETF | 132.15 | 132.17 | 132.15 | 132.17 | 600.0 |
| 2006-09-13 19:00:00 | SPY | ETF | 132.17 | 132.17 | 132.15 | 132.16 | 6500.0 |
| 2006-09-13 19:30:00 | SPY | ETF | 132.17 | 132.17 | 132.13 | 132.13 | 12100.0 |
| 2006-09-13 09:30:00 | QQQ | ETF | 39.73 | 39.93 | 39.63 | 39.86 | 20415800.0 |
| 2006-09-13 10:00:00 | QQQ | ETF | 39.86 | 39.88 | 39.77 | 39.88 | 10044200.0 |
| 2006-09-13 10:30:00 | QQQ | ETF | 39.87 | 39.89 | 39.65 | 39.76 | 16743000.0 |
| 2006-09-13 11:00:00 | QQQ | ETF | 39.75 | 39.91 | 39.74 | 39.87 | 7764600.0 |
| 2006-09-13 11:30:00 | QQQ | ETF | 39.88 | 39.95 | 39.82 | 39.94 | 8692200.0 |
| 2006-09-13 12:00:00 | QQQ | ETF | 39.94 | 39.98 | 39.87 | 39.91 | 5893900.0 |
| 2006-09-13 12:30:00 | QQQ | ETF | 39.91 | 39.93 | 39.81 | 39.82 | 3718300.0 |
| 2006-09-13 13:00:00 | QQQ | ETF | 39.82 | 39.85 | 39.77 | 39.81 | 3170000.0 |
| 2006-09-13 13:30:00 | QQQ | ETF | 39.81 | 39.9 | 39.8 | 39.85 | 3859600.0 |
| 2006-09-13 14:00:00 | QQQ | ETF | 39.85 | 39.92 | 39.85 | 39.89 | 3013700.0 |
| 2006-09-13 14:30:00 | QQQ | ETF | 39.9 | 39.98 | 39.88 | 39.97 | 7441500.0 |
| 2006-09-13 15:00:00 | QQQ | ETF | 39.96 | 39.97 | 39.79 | 39.84 | 7972700.0 |
| 2006-09-13 15:30:00 | QQQ | ETF | 39.84 | 39.98 | 39.83 | 39.95 | 8759300.0 |
| 2006-09-13 07:00:00 | IWM | ETF | 72.0 | 72.0 | 72.0 | 72.0 | 2000.0 |
| 2006-09-13 08:00:00 | IWM | ETF | 72.0 | 72.24 | 72.0 | 72.2 | 17700.0 |
| 2006-09-13 08:30:00 | IWM | ETF | 72.22 | 72.3 | 72.21 | 72.24 | 215900.0 |
| 2006-09-13 09:00:00 | IWM | ETF | 72.24 | 72.26 | 72.13 | 72.14 | 362500.0 |
| 2006-09-13 09:30:00 | IWM | ETF | 72.16 | 72.5 | 72.0 | 72.38 | 3236900.0 |
| 2006-09-13 10:00:00 | IWM | ETF | 72.37 | 72.48 | 72.24 | 72.46 | 2202800.0 |
| 2006-09-13 10:30:00 | IWM | ETF | 72.47 | 72.47 | 72.03 | 72.22 | 2629800.0 |
| 2006-09-13 11:00:00 | IWM | ETF | 72.22 | 72.45 | 72.19 | 72.43 | 1808300.0 |
> showing 50 of 2,831 rows — these rows as CSV