PREVIEW / etf_30min / 2006-11-16
file: by_date/etf_30min/2006/2006-11-16.parquet size: 89 KB rows: 3,125
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-11-16 06:00:00 | SPY | ETF | 139.99 | 139.99 | 139.99 | 139.99 | 5000.0 |
| 2006-11-16 06:30:00 | SPY | ETF | 140.01 | 140.02 | 139.97 | 139.97 | 12400.0 |
| 2006-11-16 07:00:00 | SPY | ETF | 140.02 | 140.02 | 139.95 | 139.95 | 7000.0 |
| 2006-11-16 07:30:00 | SPY | ETF | 139.99 | 139.99 | 139.91 | 139.92 | 3200.0 |
| 2006-11-16 08:00:00 | SPY | ETF | 139.94 | 140.07 | 139.86 | 139.96 | 1619400.0 |
| 2006-11-16 08:30:00 | SPY | ETF | 140.03 | 140.68 | 139.99 | 140.56 | 5345700.0 |
| 2006-11-16 09:00:00 | SPY | ETF | 140.55 | 140.6 | 140.42 | 140.44 | 560000.0 |
| 2006-11-16 09:30:00 | SPY | ETF | 140.44 | 140.47 | 140.19 | 140.39 | 8293100.0 |
| 2006-11-16 10:00:00 | SPY | ETF | 140.41 | 140.45 | 140.22 | 140.33 | 4322100.0 |
| 2006-11-16 10:30:00 | SPY | ETF | 140.32 | 140.49 | 139.49 | 140.21 | 7263000.0 |
| 2006-11-16 11:00:00 | SPY | ETF | 140.2 | 140.36 | 140.15 | 140.31 | 3332900.0 |
| 2006-11-16 11:30:00 | SPY | ETF | 140.32 | 140.39 | 140.21 | 140.3101 | 3927400.0 |
| 2006-11-16 12:00:00 | SPY | ETF | 140.31 | 140.5 | 140.25 | 140.33 | 4799300.0 |
| 2006-11-16 12:30:00 | SPY | ETF | 140.32 | 140.37 | 140.28 | 140.32 | 1498900.0 |
| 2006-11-16 13:00:00 | SPY | ETF | 140.33 | 140.43 | 140.31 | 140.4 | 1445200.0 |
| 2006-11-16 13:30:00 | SPY | ETF | 140.39 | 140.68 | 139.941 | 140.49 | 6348800.0 |
| 2006-11-16 14:00:00 | SPY | ETF | 140.49 | 140.66 | 140.25 | 140.36 | 5507300.0 |
| 2006-11-16 14:30:00 | SPY | ETF | 140.35 | 140.46 | 140.27 | 140.37 | 1930800.0 |
| 2006-11-16 15:00:00 | SPY | ETF | 140.36 | 140.56 | 140.33 | 140.46 | 3130400.0 |
| 2006-11-16 15:30:00 | SPY | ETF | 140.47 | 140.5 | 140.23 | 140.23 | 6786700.0 |
| 2006-11-16 16:00:00 | SPY | ETF | 140.23 | 140.39 | 140.23 | 140.35 | 1525800.0 |
| 2006-11-16 16:30:00 | SPY | ETF | 140.3 | 140.41 | 140.2 | 140.25 | 707300.0 |
| 2006-11-16 17:00:00 | SPY | ETF | 140.25 | 140.26 | 140.17 | 140.17 | 43800.0 |
| 2006-11-16 17:30:00 | SPY | ETF | 140.19 | 140.22 | 140.18 | 140.18 | 4300.0 |
| 2006-11-16 18:00:00 | SPY | ETF | 140.19 | 140.22 | 140.19 | 140.22 | 10000.0 |
| 2006-11-16 18:30:00 | SPY | ETF | 140.21 | 140.21 | 140.21 | 140.21 | 9900.0 |
| 2006-11-16 19:30:00 | SPY | ETF | 140.22 | 140.22 | 140.22 | 140.22 | 100.0 |
| 2006-11-16 09:30:00 | QQQ | ETF | 44.25 | 44.29 | 44.02 | 44.14 | 22717000.0 |
| 2006-11-16 10:00:00 | QQQ | ETF | 44.14 | 44.2 | 44.06 | 44.15 | 7049200.0 |
| 2006-11-16 10:30:00 | QQQ | ETF | 44.16 | 44.21 | 44.04 | 44.1 | 8753200.0 |
| 2006-11-16 11:00:00 | QQQ | ETF | 44.1 | 44.18 | 44.07 | 44.17 | 3036700.0 |
| 2006-11-16 11:30:00 | QQQ | ETF | 44.17 | 44.22 | 44.14 | 44.18 | 4976900.0 |
| 2006-11-16 12:00:00 | QQQ | ETF | 44.18 | 44.27 | 44.14 | 44.23 | 4345100.0 |
| 2006-11-16 12:30:00 | QQQ | ETF | 44.23 | 44.23 | 44.19 | 44.21 | 2718200.0 |
| 2006-11-16 13:00:00 | QQQ | ETF | 44.21 | 44.27 | 44.19 | 44.27 | 2662800.0 |
| 2006-11-16 13:30:00 | QQQ | ETF | 44.26 | 44.42 | 43.33 | 44.35 | 12094200.0 |
| 2006-11-16 14:00:00 | QQQ | ETF | 44.35 | 44.37 | 44.21 | 44.28 | 10938900.0 |
| 2006-11-16 14:30:00 | QQQ | ETF | 44.27 | 44.32 | 44.24 | 44.28 | 4145500.0 |
| 2006-11-16 15:00:00 | QQQ | ETF | 44.28 | 44.39 | 44.27 | 44.35 | 5699400.0 |
| 2006-11-16 15:30:00 | QQQ | ETF | 44.36 | 44.38 | 44.28 | 44.32 | 9734700.0 |
| 2006-11-16 07:30:00 | IWM | ETF | 78.7 | 78.7 | 78.62 | 78.63 | 31000.0 |
| 2006-11-16 08:00:00 | IWM | ETF | 78.64 | 78.68 | 78.6 | 78.61 | 659300.0 |
| 2006-11-16 08:30:00 | IWM | ETF | 78.7 | 79.25 | 78.7 | 79.2 | 1642700.0 |
| 2006-11-16 09:00:00 | IWM | ETF | 79.2 | 79.23 | 79.11 | 79.11 | 1122100.0 |
| 2006-11-16 09:30:00 | IWM | ETF | 79.1 | 79.11 | 78.61 | 78.91 | 7567100.0 |
| 2006-11-16 10:00:00 | IWM | ETF | 78.91 | 78.92 | 78.68 | 78.77 | 2579500.0 |
| 2006-11-16 10:30:00 | IWM | ETF | 78.76 | 78.91 | 78.45 | 78.49 | 4980400.0 |
| 2006-11-16 11:00:00 | IWM | ETF | 78.49 | 78.58 | 78.44 | 78.56 | 2412100.0 |
| 2006-11-16 11:30:00 | IWM | ETF | 78.57 | 78.63 | 78.38 | 78.44 | 3542400.0 |
| 2006-11-16 12:00:00 | IWM | ETF | 78.44 | 78.76 | 78.41 | 78.65 | 3070300.0 |
> showing 50 of 3,125 rows — these rows as CSV