PREVIEW / etf_30min / 2006-12-07
file: by_date/etf_30min/2006/2006-12-07.parquet size: 88 KB rows: 3,052
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-12-07 07:30:00 | SPY | ETF | 141.82 | 141.86 | 141.81 | 141.86 | 183900.0 |
| 2006-12-07 08:00:00 | SPY | ETF | 141.86 | 141.95 | 141.8 | 141.93 | 460900.0 |
| 2006-12-07 08:30:00 | SPY | ETF | 141.9 | 141.97 | 141.88 | 141.94 | 494800.0 |
| 2006-12-07 09:00:00 | SPY | ETF | 141.92 | 142.14 | 141.92 | 142.04 | 847300.0 |
| 2006-12-07 09:30:00 | SPY | ETF | 142.03 | 142.3 | 141.96 | 142.12 | 7737100.0 |
| 2006-12-07 10:00:00 | SPY | ETF | 142.12 | 142.12 | 141.76 | 141.83 | 6179200.0 |
| 2006-12-07 10:30:00 | SPY | ETF | 141.83 | 141.87 | 141.43 | 141.59 | 6107800.0 |
| 2006-12-07 11:00:00 | SPY | ETF | 141.58 | 141.7 | 141.43 | 141.51 | 2987500.0 |
| 2006-12-07 11:30:00 | SPY | ETF | 141.51 | 141.83 | 141.5 | 141.75 | 2655500.0 |
| 2006-12-07 12:00:00 | SPY | ETF | 141.74 | 141.8 | 141.65 | 141.76 | 2204200.0 |
| 2006-12-07 12:30:00 | SPY | ETF | 141.76 | 141.78 | 141.58 | 141.66 | 1441100.0 |
| 2006-12-07 13:00:00 | SPY | ETF | 141.65 | 141.87 | 141.62 | 141.86 | 1322100.0 |
| 2006-12-07 13:30:00 | SPY | ETF | 141.86 | 141.89 | 141.68 | 141.69 | 2593800.0 |
| 2006-12-07 14:00:00 | SPY | ETF | 141.69 | 141.85 | 141.31 | 141.4 | 4452400.0 |
| 2006-12-07 14:30:00 | SPY | ETF | 141.39 | 141.54 | 141.36 | 141.38 | 3436300.0 |
| 2006-12-07 15:00:00 | SPY | ETF | 141.38 | 141.56 | 141.11 | 141.29 | 7890300.0 |
| 2006-12-07 15:30:00 | SPY | ETF | 141.29 | 141.36 | 141.11 | 141.1829 | 7046800.0 |
| 2006-12-07 16:00:00 | SPY | ETF | 141.23 | 141.26 | 141.14 | 141.14 | 889400.0 |
| 2006-12-07 16:30:00 | SPY | ETF | 141.14 | 141.22 | 141.13 | 141.15 | 1909900.0 |
| 2006-12-07 17:00:00 | SPY | ETF | 141.15 | 141.17 | 141.09 | 141.11 | 470900.0 |
| 2006-12-07 17:30:00 | SPY | ETF | 141.16 | 141.2 | 141.15 | 141.15 | 121600.0 |
| 2006-12-07 18:00:00 | SPY | ETF | 141.15 | 141.15 | 141.11 | 141.13 | 23600.0 |
| 2006-12-07 18:30:00 | SPY | ETF | 141.15 | 141.15 | 141.11 | 141.11 | 2600.0 |
| 2006-12-07 19:00:00 | SPY | ETF | 141.1 | 141.15 | 141.1 | 141.15 | 4200.0 |
| 2006-12-07 19:30:00 | SPY | ETF | 141.15 | 141.15 | 141.15 | 141.15 | 800.0 |
| 2006-12-07 09:30:00 | QQQ | ETF | 44.34 | 44.48 | 44.3 | 44.32 | 12182300.0 |
| 2006-12-07 10:00:00 | QQQ | ETF | 44.32 | 44.33 | 44.02 | 44.11 | 12863000.0 |
| 2006-12-07 10:30:00 | QQQ | ETF | 44.1 | 44.17 | 43.88 | 43.94 | 16919500.0 |
| 2006-12-07 11:00:00 | QQQ | ETF | 43.93 | 44.95 | 43.89 | 43.92 | 6363300.0 |
| 2006-12-07 11:30:00 | QQQ | ETF | 43.92 | 44.12 | 43.9 | 44.07 | 8534800.0 |
| 2006-12-07 12:00:00 | QQQ | ETF | 44.08 | 44.15 | 44.04 | 44.12 | 4041600.0 |
| 2006-12-07 12:30:00 | QQQ | ETF | 44.11 | 44.14 | 44.04 | 44.06 | 3198400.0 |
| 2006-12-07 13:00:00 | QQQ | ETF | 44.06 | 44.16 | 44.03 | 44.16 | 1946000.0 |
| 2006-12-07 13:30:00 | QQQ | ETF | 44.15 | 44.18 | 44.06 | 44.07 | 5927300.0 |
| 2006-12-07 14:00:00 | QQQ | ETF | 44.08 | 44.08 | 43.86 | 43.89 | 8063200.0 |
| 2006-12-07 14:30:00 | QQQ | ETF | 43.89 | 43.96 | 43.86 | 43.89 | 5504600.0 |
| 2006-12-07 15:00:00 | QQQ | ETF | 43.89 | 43.89 | 43.7 | 43.82 | 13582800.0 |
| 2006-12-07 15:30:00 | QQQ | ETF | 43.82 | 43.84 | 43.7 | 43.7 | 11744800.0 |
| 2006-12-07 08:00:00 | IWM | ETF | 79.18 | 79.24 | 79.11 | 79.24 | 143700.0 |
| 2006-12-07 08:30:00 | IWM | ETF | 79.2 | 79.23 | 79.17 | 79.2 | 41100.0 |
| 2006-12-07 09:00:00 | IWM | ETF | 79.2 | 79.43 | 79.2 | 79.29 | 320600.0 |
| 2006-12-07 09:30:00 | IWM | ETF | 79.29 | 79.51 | 79.15 | 79.37 | 3444600.0 |
| 2006-12-07 10:00:00 | IWM | ETF | 79.37 | 79.37 | 78.75 | 78.81 | 8578800.0 |
| 2006-12-07 10:30:00 | IWM | ETF | 78.81 | 79.07 | 78.66 | 78.79 | 4372300.0 |
| 2006-12-07 11:00:00 | IWM | ETF | 78.77 | 78.94 | 78.76 | 78.83 | 1542900.0 |
| 2006-12-07 11:30:00 | IWM | ETF | 78.84 | 79.13 | 78.84 | 79.05 | 1106700.0 |
| 2006-12-07 12:00:00 | IWM | ETF | 79.05 | 79.24 | 79.01 | 79.21 | 1333400.0 |
| 2006-12-07 12:30:00 | IWM | ETF | 79.21 | 79.27 | 79.12 | 79.17 | 695500.0 |
| 2006-12-07 13:00:00 | IWM | ETF | 79.18 | 79.41 | 79.13 | 79.38 | 1319600.0 |
| 2006-12-07 13:30:00 | IWM | ETF | 79.39 | 79.46 | 79.32 | 79.35 | 1900600.0 |
> showing 50 of 3,052 rows — these rows as CSV