PREVIEW / etf_30min / 2006-10-04
file: by_date/etf_30min/2006/2006-10-04.parquet size: 86 KB rows: 2,931
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-10-04 06:30:00 | SPY | ETF | 133.35 | 133.35 | 133.35 | 133.35 | 5000.0 |
| 2006-10-04 07:00:00 | SPY | ETF | 133.6 | 133.67 | 133.6 | 133.61 | 7400.0 |
| 2006-10-04 07:30:00 | SPY | ETF | 133.6 | 133.6 | 133.55 | 133.58 | 22500.0 |
| 2006-10-04 08:00:00 | SPY | ETF | 133.58 | 133.66 | 133.31 | 133.34 | 1619500.0 |
| 2006-10-04 08:30:00 | SPY | ETF | 133.33 | 133.35 | 133.2 | 133.31 | 494100.0 |
| 2006-10-04 09:00:00 | SPY | ETF | 133.32 | 133.32 | 133.19 | 133.22 | 314100.0 |
| 2006-10-04 09:30:00 | SPY | ETF | 133.23 | 133.41 | 133.15 | 133.26 | 5717300.0 |
| 2006-10-04 10:00:00 | SPY | ETF | 133.26 | 133.75 | 133.08 | 133.67 | 7892400.0 |
| 2006-10-04 10:30:00 | SPY | ETF | 133.67 | 133.82 | 133.59 | 133.66 | 4039400.0 |
| 2006-10-04 11:00:00 | SPY | ETF | 133.65 | 133.95 | 133.53 | 133.92 | 3454500.0 |
| 2006-10-04 11:30:00 | SPY | ETF | 133.93 | 134.1 | 133.9 | 134.08 | 4848800.0 |
| 2006-10-04 12:00:00 | SPY | ETF | 134.08 | 134.09 | 133.9 | 134.01 | 3837300.0 |
| 2006-10-04 12:30:00 | SPY | ETF | 134.01 | 134.08 | 133.95 | 134.03 | 1770600.0 |
| 2006-10-04 13:00:00 | SPY | ETF | 134.04 | 134.14 | 133.89 | 134.14 | 3174700.0 |
| 2006-10-04 13:30:00 | SPY | ETF | 134.14 | 134.38 | 134.12 | 134.3 | 5986200.0 |
| 2006-10-04 14:00:00 | SPY | ETF | 134.3 | 134.66 | 134.25 | 134.57 | 9874100.0 |
| 2006-10-04 14:30:00 | SPY | ETF | 134.57 | 134.78 | 134.56 | 134.74 | 6102900.0 |
| 2006-10-04 15:00:00 | SPY | ETF | 134.74 | 134.82 | 134.61 | 134.69 | 6792300.0 |
| 2006-10-04 15:30:00 | SPY | ETF | 134.67 | 135.0 | 134.67 | 134.95 | 10039700.0 |
| 2006-10-04 16:00:00 | SPY | ETF | 134.93 | 134.99 | 134.82 | 134.92 | 1816700.0 |
| 2006-10-04 16:30:00 | SPY | ETF | 134.92 | 134.95 | 134.88 | 134.92 | 216100.0 |
| 2006-10-04 17:00:00 | SPY | ETF | 134.95 | 134.96 | 134.9 | 134.95 | 54700.0 |
| 2006-10-04 17:30:00 | SPY | ETF | 134.92 | 134.92 | 134.84 | 134.85 | 12300.0 |
| 2006-10-04 18:00:00 | SPY | ETF | 134.92 | 134.97 | 134.92 | 134.93 | 2800.0 |
| 2006-10-04 19:00:00 | SPY | ETF | 134.91 | 134.91 | 134.91 | 134.91 | 1000.0 |
| 2006-10-04 19:30:00 | SPY | ETF | 134.93 | 134.95 | 134.93 | 134.95 | 2800.0 |
| 2006-10-04 09:30:00 | QQQ | ETF | 40.22 | 40.31 | 40.17 | 40.23 | 9308500.0 |
| 2006-10-04 10:00:00 | QQQ | ETF | 40.23 | 40.66 | 40.14 | 40.6 | 23405300.0 |
| 2006-10-04 10:30:00 | QQQ | ETF | 40.6 | 40.68 | 40.58 | 40.65 | 9335300.0 |
| 2006-10-04 11:00:00 | QQQ | ETF | 40.65 | 40.84 | 40.58 | 40.82 | 9697100.0 |
| 2006-10-04 11:30:00 | QQQ | ETF | 40.82 | 40.9 | 40.8 | 40.85 | 10666500.0 |
| 2006-10-04 12:00:00 | QQQ | ETF | 40.85 | 40.85 | 40.72 | 40.77 | 6414400.0 |
| 2006-10-04 12:30:00 | QQQ | ETF | 40.77 | 40.84 | 40.76 | 40.8 | 4756500.0 |
| 2006-10-04 13:00:00 | QQQ | ETF | 40.81 | 40.87 | 40.71 | 40.86 | 5507800.0 |
| 2006-10-04 13:30:00 | QQQ | ETF | 40.86 | 40.95 | 40.82 | 40.87 | 12717300.0 |
| 2006-10-04 14:00:00 | QQQ | ETF | 40.88 | 41.03 | 40.87 | 41.01 | 8739500.0 |
| 2006-10-04 14:30:00 | QQQ | ETF | 41.01 | 41.24 | 41.0 | 41.23 | 11730800.0 |
| 2006-10-04 15:00:00 | QQQ | ETF | 41.22 | 41.24 | 41.01 | 41.13 | 7912200.0 |
| 2006-10-04 15:30:00 | QQQ | ETF | 41.13 | 41.31 | 41.12 | 41.31 | 13459200.0 |
| 2006-10-04 07:00:00 | IWM | ETF | 71.09 | 71.4 | 71.09 | 71.38 | 2000.0 |
| 2006-10-04 07:30:00 | IWM | ETF | 71.45 | 71.45 | 71.37 | 71.39 | 4000.0 |
| 2006-10-04 08:00:00 | IWM | ETF | 71.41 | 71.43 | 71.22 | 71.27 | 560000.0 |
| 2006-10-04 08:30:00 | IWM | ETF | 71.14 | 71.21 | 71.13 | 71.21 | 335700.0 |
| 2006-10-04 09:00:00 | IWM | ETF | 71.22 | 71.25 | 71.14 | 71.2 | 114700.0 |
| 2006-10-04 09:30:00 | IWM | ETF | 71.19 | 71.57 | 71.09 | 71.44 | 5772300.0 |
| 2006-10-04 10:00:00 | IWM | ETF | 71.45 | 71.83 | 71.25 | 71.76 | 5748300.0 |
| 2006-10-04 10:30:00 | IWM | ETF | 71.77 | 71.95 | 71.75 | 71.84 | 3102900.0 |
| 2006-10-04 11:00:00 | IWM | ETF | 71.8475 | 72.08 | 71.67 | 72.06 | 3902600.0 |
| 2006-10-04 11:30:00 | IWM | ETF | 72.07 | 72.18 | 71.99 | 72.17 | 2674900.0 |
| 2006-10-04 12:00:00 | IWM | ETF | 72.16 | 72.18 | 72.03 | 72.11 | 3177100.0 |
> showing 50 of 2,931 rows — these rows as CSV