PREVIEW / etf_30min / 2001-02-08
file: by_date/etf_30min/2001/2001-02-08.parquet size: 13 KB rows: 324
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 |
|---|---|---|---|---|---|---|---|
| 2001-02-08 09:30:00 | SPY | ETF | 134.8 | 135.15 | 134.7 | 134.9 | 1064100.0 |
| 2001-02-08 10:00:00 | SPY | ETF | 134.87 | 135.33 | 134.76 | 135.25 | 423000.0 |
| 2001-02-08 10:30:00 | SPY | ETF | 135.19 | 135.4 | 134.8 | 134.95 | 477000.0 |
| 2001-02-08 11:00:00 | SPY | ETF | 134.92 | 135.0 | 134.56 | 134.56 | 276100.0 |
| 2001-02-08 11:30:00 | SPY | ETF | 134.67 | 134.69 | 134.32 | 134.59 | 282700.0 |
| 2001-02-08 12:00:00 | SPY | ETF | 134.52 | 134.74 | 134.27 | 134.63 | 91900.0 |
| 2001-02-08 12:30:00 | SPY | ETF | 134.61 | 134.65 | 134.2 | 134.3 | 249200.0 |
| 2001-02-08 13:00:00 | SPY | ETF | 134.26 | 134.54 | 134.01 | 134.12 | 163500.0 |
| 2001-02-08 13:30:00 | SPY | ETF | 134.19 | 134.45 | 133.91 | 134.18 | 184600.0 |
| 2001-02-08 14:00:00 | SPY | ETF | 134.16 | 134.47 | 133.81 | 134.0 | 149300.0 |
| 2001-02-08 14:30:00 | SPY | ETF | 134.08 | 134.44 | 133.96 | 134.25 | 388700.0 |
| 2001-02-08 15:00:00 | SPY | ETF | 134.2 | 134.5 | 133.65 | 133.89 | 305700.0 |
| 2001-02-08 15:30:00 | SPY | ETF | 133.78 | 134.1 | 133.48 | 133.48 | 1304300.0 |
| 2001-02-08 16:00:00 | SPY | ETF | 133.5 | 134.44 | 133.1 | 133.12 | 388400.0 |
| 2001-02-08 09:30:00 | QQQ | ETF | 60.9 | 61.11 | 60.38 | 60.54 | 6646000.0 |
| 2001-02-08 10:00:00 | QQQ | ETF | 60.5 | 61.35 | 60.4 | 61.25 | 4871200.0 |
| 2001-02-08 10:30:00 | QQQ | ETF | 61.3 | 61.5 | 60.75 | 60.82 | 3206100.0 |
| 2001-02-08 11:00:00 | QQQ | ETF | 60.84 | 60.88 | 60.28 | 60.28 | 2451700.0 |
| 2001-02-08 11:30:00 | QQQ | ETF | 60.28 | 60.39 | 59.92 | 60.05 | 3038700.0 |
| 2001-02-08 12:00:00 | QQQ | ETF | 60.05 | 60.25 | 59.65 | 60.08 | 2052600.0 |
| 2001-02-08 12:30:00 | QQQ | ETF | 60.1 | 60.15 | 59.4 | 59.58 | 2440400.0 |
| 2001-02-08 13:00:00 | QQQ | ETF | 59.58 | 59.79 | 59.25 | 59.3 | 2698800.0 |
| 2001-02-08 13:30:00 | QQQ | ETF | 59.27 | 59.66 | 59.0 | 59.6 | 2905300.0 |
| 2001-02-08 14:00:00 | QQQ | ETF | 59.52 | 59.89 | 59.15 | 59.59 | 3332500.0 |
| 2001-02-08 14:30:00 | QQQ | ETF | 59.56 | 60.1 | 59.5 | 59.65 | 4125400.0 |
| 2001-02-08 15:00:00 | QQQ | ETF | 59.7 | 59.95 | 58.96 | 59.0 | 2841600.0 |
| 2001-02-08 15:30:00 | QQQ | ETF | 58.96 | 59.27 | 58.65 | 58.7 | 4248900.0 |
| 2001-02-08 16:00:00 | QQQ | ETF | 58.7 | 59.25 | 58.58 | 58.65 | 918000.0 |
| 2001-02-08 16:30:00 | QQQ | ETF | 58.69 | 59.0 | 58.66 | 58.95 | 30600.0 |
| 2001-02-08 17:00:00 | QQQ | ETF | 58.96 | 59.09 | 58.75 | 58.84 | 18600.0 |
| 2001-02-08 17:30:00 | QQQ | ETF | 58.84 | 58.87 | 58.75 | 58.8 | 14800.0 |
| 2001-02-08 18:00:00 | QQQ | ETF | 58.8 | 58.8 | 58.56 | 58.75 | 122900.0 |
| 2001-02-08 09:30:00 | IWM | ETF | 50.825 | 50.825 | 50.55 | 50.55 | 166800.0 |
| 2001-02-08 10:00:00 | IWM | ETF | 50.55 | 50.75 | 50.55 | 50.55 | 266400.0 |
| 2001-02-08 10:30:00 | IWM | ETF | 50.775 | 50.9 | 50.65 | 50.7 | 43000.0 |
| 2001-02-08 11:00:00 | IWM | ETF | 50.705 | 50.705 | 50.5 | 50.67 | 157800.0 |
| 2001-02-08 11:30:00 | IWM | ETF | 50.51 | 50.51 | 50.425 | 50.43 | 96400.0 |
| 2001-02-08 12:00:00 | IWM | ETF | 50.425 | 50.6 | 50.3 | 50.435 | 270600.0 |
| 2001-02-08 12:30:00 | IWM | ETF | 50.5 | 50.5 | 50.35 | 50.35 | 158600.0 |
| 2001-02-08 13:00:00 | IWM | ETF | 50.37 | 50.37 | 50.29 | 50.29 | 175000.0 |
| 2001-02-08 13:30:00 | IWM | ETF | 50.3 | 50.3 | 50.16 | 50.2 | 173400.0 |
| 2001-02-08 14:00:00 | IWM | ETF | 50.32 | 50.32 | 50.17 | 50.17 | 150200.0 |
| 2001-02-08 14:30:00 | IWM | ETF | 50.17 | 50.4 | 50.17 | 50.275 | 66400.0 |
| 2001-02-08 15:00:00 | IWM | ETF | 50.275 | 50.36 | 50.175 | 50.175 | 273800.0 |
| 2001-02-08 15:30:00 | IWM | ETF | 50.15 | 50.15 | 49.925 | 49.94 | 252000.0 |
| 2001-02-08 16:00:00 | IWM | ETF | 49.94 | 49.94 | 49.875 | 49.94 | 71800.0 |
| 2001-02-08 09:30:00 | DIA | ETF | 109.85 | 109.85 | 109.31 | 109.59 | 65600.0 |
| 2001-02-08 10:00:00 | DIA | ETF | 109.6 | 109.88 | 109.45 | 109.68 | 244800.0 |
| 2001-02-08 10:30:00 | DIA | ETF | 109.55 | 109.81 | 109.48 | 109.6 | 17400.0 |
| 2001-02-08 11:00:00 | DIA | ETF | 109.52 | 109.63 | 109.36 | 109.47 | 18600.0 |
> showing 50 of 324 rows — these rows as CSV