PREVIEW / etf_30min / 2004-11-26
file: by_date/etf_30min/2004/2004-11-26.parquet size: 24 KB rows: 723
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-26 08:00:00 | SPY | ETF | 118.5 | 118.55 | 118.5 | 118.55 | 55300.0 |
| 2004-11-26 08:30:00 | SPY | ETF | 118.53 | 118.53 | 118.49 | 118.5 | 58200.0 |
| 2004-11-26 09:00:00 | SPY | ETF | 118.52 | 118.57 | 118.47 | 118.5 | 13400.0 |
| 2004-11-26 09:30:00 | SPY | ETF | 118.51 | 118.85 | 118.45 | 118.76 | 2910400.0 |
| 2004-11-26 10:00:00 | SPY | ETF | 118.74 | 118.87 | 118.66 | 118.74 | 1163400.0 |
| 2004-11-26 10:30:00 | SPY | ETF | 118.73 | 118.87 | 118.71 | 118.86 | 1607200.0 |
| 2004-11-26 11:00:00 | SPY | ETF | 118.85 | 118.98 | 118.81 | 118.88 | 1419700.0 |
| 2004-11-26 11:30:00 | SPY | ETF | 118.88 | 118.91 | 118.71 | 118.73 | 2004100.0 |
| 2004-11-26 12:00:00 | SPY | ETF | 118.73 | 118.79 | 118.7 | 118.73 | 1464500.0 |
| 2004-11-26 12:30:00 | SPY | ETF | 118.74 | 118.86 | 118.54 | 118.54 | 2169900.0 |
| 2004-11-26 13:00:00 | SPY | ETF | 118.54 | 118.55 | 118.3 | 118.35 | 578600.0 |
| 2004-11-26 08:00:00 | QQQ | ETF | 39.32 | 39.43 | 39.32 | 39.43 | 56600.0 |
| 2004-11-26 08:30:00 | QQQ | ETF | 39.41 | 39.42 | 39.39 | 39.4 | 116400.0 |
| 2004-11-26 09:00:00 | QQQ | ETF | 39.4 | 39.43 | 39.35 | 39.36 | 95300.0 |
| 2004-11-26 09:30:00 | QQQ | ETF | 39.37 | 39.45 | 39.348 | 39.41 | 7785600.0 |
| 2004-11-26 10:00:00 | QQQ | ETF | 39.41 | 39.46 | 39.368 | 39.415 | 3159300.0 |
| 2004-11-26 10:30:00 | QQQ | ETF | 39.415 | 39.44 | 39.39 | 39.43 | 2655900.0 |
| 2004-11-26 11:00:00 | QQQ | ETF | 39.43 | 39.48 | 39.41 | 39.42 | 3136600.0 |
| 2004-11-26 11:30:00 | QQQ | ETF | 39.41 | 39.42 | 39.33 | 39.331 | 3270800.0 |
| 2004-11-26 12:00:00 | QQQ | ETF | 39.33 | 39.35 | 39.3 | 39.31 | 2859300.0 |
| 2004-11-26 12:30:00 | QQQ | ETF | 39.3 | 39.36 | 39.28 | 39.31 | 5918700.0 |
| 2004-11-26 13:00:00 | QQQ | ETF | 39.31 | 39.31 | 39.17 | 39.21 | 1408700.0 |
| 2004-11-26 08:30:00 | IWM | ETF | 62.825 | 62.825 | 62.825 | 62.825 | 9600.0 |
| 2004-11-26 09:00:00 | IWM | ETF | 62.85 | 62.875 | 62.8 | 62.8 | 5200.0 |
| 2004-11-26 09:30:00 | IWM | ETF | 62.825 | 63.075 | 62.81 | 62.985 | 2019800.0 |
| 2004-11-26 10:00:00 | IWM | ETF | 62.99 | 63.04 | 62.96 | 63.04 | 642000.0 |
| 2004-11-26 10:30:00 | IWM | ETF | 63.05 | 63.14 | 63.03 | 63.14 | 192400.0 |
| 2004-11-26 11:00:00 | IWM | ETF | 63.14 | 63.2 | 63.12 | 63.145 | 315400.0 |
| 2004-11-26 11:30:00 | IWM | ETF | 63.14 | 63.145 | 63.09 | 63.09 | 676400.0 |
| 2004-11-26 12:00:00 | IWM | ETF | 63.085 | 63.115 | 63.065 | 63.115 | 700200.0 |
| 2004-11-26 12:30:00 | IWM | ETF | 63.115 | 63.14 | 62.905 | 62.925 | 1014400.0 |
| 2004-11-26 13:00:00 | IWM | ETF | 62.935 | 62.935 | 62.775 | 62.8 | 104400.0 |
| 2004-11-26 13:30:00 | IWM | ETF | 62.75 | 62.75 | 62.75 | 62.75 | 600.0 |
| 2004-11-26 08:00:00 | DIA | ETF | 105.15 | 105.15 | 105.15 | 105.15 | 300.0 |
| 2004-11-26 08:30:00 | DIA | ETF | 105.07 | 105.07 | 105.07 | 105.07 | 1800.0 |
| 2004-11-26 09:00:00 | DIA | ETF | 105.11 | 105.11 | 105.09 | 105.09 | 2700.0 |
| 2004-11-26 09:30:00 | DIA | ETF | 105.09 | 105.26 | 105.06 | 105.21 | 531800.0 |
| 2004-11-26 10:00:00 | DIA | ETF | 105.23 | 105.28 | 105.1 | 105.13 | 232500.0 |
| 2004-11-26 10:30:00 | DIA | ETF | 105.14 | 105.27 | 105.14 | 105.27 | 206700.0 |
| 2004-11-26 11:00:00 | DIA | ETF | 105.25 | 105.35 | 105.23 | 105.26 | 165300.0 |
| 2004-11-26 11:30:00 | DIA | ETF | 105.26 | 105.27 | 105.14 | 105.14 | 97500.0 |
| 2004-11-26 12:00:00 | DIA | ETF | 105.14 | 105.21 | 105.14 | 105.18 | 61600.0 |
| 2004-11-26 12:30:00 | DIA | ETF | 105.16 | 105.3 | 105.07 | 105.14 | 417500.0 |
| 2004-11-26 13:00:00 | DIA | ETF | 105.14 | 105.15 | 104.9 | 104.92 | 49400.0 |
| 2004-11-26 09:30:00 | GLD | ETF | 45.25 | 45.3 | 45.06 | 45.09 | 798700.0 |
| 2004-11-26 10:00:00 | GLD | ETF | 45.11 | 45.27 | 45.07 | 45.23 | 607800.0 |
| 2004-11-26 10:30:00 | GLD | ETF | 45.24 | 45.3 | 45.22 | 45.3 | 345700.0 |
| 2004-11-26 11:00:00 | GLD | ETF | 45.28 | 45.6 | 45.27 | 45.53 | 497000.0 |
| 2004-11-26 11:30:00 | GLD | ETF | 45.54 | 45.54 | 45.28 | 45.29 | 298000.0 |
| 2004-11-26 12:00:00 | GLD | ETF | 45.3 | 45.36 | 45.29 | 45.32 | 288000.0 |
> showing 50 of 723 rows — these rows as CSV