PREVIEW / etf_30min / 2006-02-23
file: by_date/etf_30min/2006/2006-02-23.parquet size: 59 KB rows: 2,144
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-02-23 06:00:00 | SPY | ETF | 129.24 | 129.25 | 129.24 | 129.25 | 35000.0 |
| 2006-02-23 06:30:00 | SPY | ETF | 129.26 | 129.26 | 129.26 | 129.26 | 1000.0 |
| 2006-02-23 07:00:00 | SPY | ETF | 129.3 | 129.3 | 129.26 | 129.26 | 3500.0 |
| 2006-02-23 07:30:00 | SPY | ETF | 129.26 | 129.26 | 129.23 | 129.23 | 5500.0 |
| 2006-02-23 08:00:00 | SPY | ETF | 129.2 | 129.3 | 129.2 | 129.27 | 706200.0 |
| 2006-02-23 08:30:00 | SPY | ETF | 129.29 | 129.29 | 129.18 | 129.22 | 188500.0 |
| 2006-02-23 09:00:00 | SPY | ETF | 129.21 | 129.28 | 129.2 | 129.27 | 67400.0 |
| 2006-02-23 09:30:00 | SPY | ETF | 129.27 | 129.27 | 128.8 | 128.88 | 6894700.0 |
| 2006-02-23 10:00:00 | SPY | ETF | 128.87 | 129.08 | 128.71 | 129.06 | 3396300.0 |
| 2006-02-23 10:30:00 | SPY | ETF | 129.05 | 129.26 | 128.99 | 129.17 | 4277600.0 |
| 2006-02-23 11:00:00 | SPY | ETF | 129.19 | 129.47 | 129.1 | 129.43 | 2878300.0 |
| 2006-02-23 11:30:00 | SPY | ETF | 129.43 | 129.44 | 129.12 | 129.17 | 3384400.0 |
| 2006-02-23 12:00:00 | SPY | ETF | 129.16 | 129.26 | 129.05 | 129.17 | 1198900.0 |
| 2006-02-23 12:30:00 | SPY | ETF | 129.18 | 129.63 | 129.16 | 129.57 | 2680000.0 |
| 2006-02-23 13:00:00 | SPY | ETF | 129.55 | 129.64 | 129.45 | 129.58 | 1649700.0 |
| 2006-02-23 13:30:00 | SPY | ETF | 129.57 | 129.6 | 129.36 | 129.46 | 1916700.0 |
| 2006-02-23 14:00:00 | SPY | ETF | 129.45 | 129.5 | 129.19 | 129.34 | 2270100.0 |
| 2006-02-23 14:30:00 | SPY | ETF | 129.36 | 129.58 | 129.29 | 129.3905 | 1866700.0 |
| 2006-02-23 15:00:00 | SPY | ETF | 129.4 | 129.5 | 129.27 | 129.37 | 1160800.0 |
| 2006-02-23 15:30:00 | SPY | ETF | 129.37 | 129.41 | 128.97 | 129.01 | 5769300.0 |
| 2006-02-23 16:00:00 | SPY | ETF | 129.01 | 129.08 | 128.96 | 129.02 | 1623900.0 |
| 2006-02-23 16:30:00 | SPY | ETF | 129.02 | 129.06 | 128.98 | 129.01 | 133900.0 |
| 2006-02-23 17:00:00 | SPY | ETF | 129.01 | 129.12 | 129.01 | 129.12 | 48600.0 |
| 2006-02-23 17:30:00 | SPY | ETF | 129.13 | 129.15 | 129.1 | 129.1 | 7000.0 |
| 2006-02-23 18:00:00 | SPY | ETF | 129.15 | 129.17 | 129.15 | 129.15 | 26600.0 |
| 2006-02-23 18:30:00 | SPY | ETF | 129.15 | 129.15 | 129.15 | 129.15 | 300.0 |
| 2006-02-23 19:00:00 | SPY | ETF | 129.16 | 129.18 | 129.16 | 129.18 | 4800.0 |
| 2006-02-23 09:30:00 | QQQ | ETF | 41.22 | 41.25 | 41.08 | 41.14 | 7218100.0 |
| 2006-02-23 10:00:00 | QQQ | ETF | 41.13 | 41.23 | 41.08 | 41.21 | 5423800.0 |
| 2006-02-23 10:30:00 | QQQ | ETF | 41.22 | 41.35 | 41.19 | 41.3 | 5740300.0 |
| 2006-02-23 11:00:00 | QQQ | ETF | 41.3 | 41.44 | 41.25 | 41.43 | 4546300.0 |
| 2006-02-23 11:30:00 | QQQ | ETF | 41.43 | 41.44 | 41.29 | 41.3 | 4157300.0 |
| 2006-02-23 12:00:00 | QQQ | ETF | 41.3 | 41.34 | 41.26 | 41.33 | 1845200.0 |
| 2006-02-23 12:30:00 | QQQ | ETF | 41.33 | 41.47 | 41.33 | 41.45 | 4946400.0 |
| 2006-02-23 13:00:00 | QQQ | ETF | 41.45 | 41.54 | 41.39 | 41.51 | 4335900.0 |
| 2006-02-23 13:30:00 | QQQ | ETF | 41.52 | 41.52 | 41.41 | 41.44 | 3024300.0 |
| 2006-02-23 14:00:00 | QQQ | ETF | 41.45 | 41.47 | 41.31 | 41.37 | 3083900.0 |
| 2006-02-23 14:30:00 | QQQ | ETF | 41.36 | 41.46 | 41.34 | 41.38 | 4379800.0 |
| 2006-02-23 15:00:00 | QQQ | ETF | 41.37 | 41.4 | 41.32 | 41.37 | 2989500.0 |
| 2006-02-23 15:30:00 | QQQ | ETF | 41.37 | 41.38 | 41.11 | 41.14 | 10072000.0 |
| 2006-02-23 08:00:00 | IWM | ETF | 72.7 | 72.73 | 72.7 | 72.72 | 350100.0 |
| 2006-02-23 08:30:00 | IWM | ETF | 72.71 | 72.71 | 72.7 | 72.7 | 7700.0 |
| 2006-02-23 09:00:00 | IWM | ETF | 72.71 | 72.76 | 72.71 | 72.76 | 42000.0 |
| 2006-02-23 09:30:00 | IWM | ETF | 72.75 | 72.77 | 72.44 | 72.44 | 2772400.0 |
| 2006-02-23 10:00:00 | IWM | ETF | 72.43 | 72.61 | 72.38 | 72.57 | 2136700.0 |
| 2006-02-23 10:30:00 | IWM | ETF | 72.57 | 72.82 | 72.56 | 72.75 | 1143700.0 |
| 2006-02-23 11:00:00 | IWM | ETF | 72.75 | 73.05 | 72.7 | 73.03 | 2973600.0 |
| 2006-02-23 11:30:00 | IWM | ETF | 73.04 | 73.11 | 72.98 | 73.04 | 3899900.0 |
| 2006-02-23 12:00:00 | IWM | ETF | 73.05 | 73.09 | 72.96 | 73.0405 | 1169200.0 |
| 2006-02-23 12:30:00 | IWM | ETF | 73.05 | 73.27 | 73.04 | 73.21 | 4537900.0 |
> showing 50 of 2,144 rows — these rows as CSV