PREVIEW / etf_30min / 2001-08-15
file: by_date/etf_30min/2001/2001-08-15.parquet size: 15 KB rows: 373
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-08-15 09:30:00 | SPY | ETF | 119.23 | 119.61 | 119.2 | 119.23 | 751000.0 |
| 2001-08-15 10:00:00 | SPY | ETF | 119.25 | 119.58 | 118.94 | 118.94 | 957000.0 |
| 2001-08-15 10:30:00 | SPY | ETF | 118.94 | 118.96 | 118.66 | 118.91 | 1064800.0 |
| 2001-08-15 11:00:00 | SPY | ETF | 118.95 | 119.01 | 118.52 | 118.52 | 428400.0 |
| 2001-08-15 11:30:00 | SPY | ETF | 118.52 | 118.61 | 118.16 | 118.33 | 585400.0 |
| 2001-08-15 12:00:00 | SPY | ETF | 118.35 | 118.49 | 118.28 | 118.44 | 348200.0 |
| 2001-08-15 12:30:00 | SPY | ETF | 118.45 | 118.6 | 118.37 | 118.58 | 267000.0 |
| 2001-08-15 13:00:00 | SPY | ETF | 118.53 | 118.84 | 118.53 | 118.7 | 319400.0 |
| 2001-08-15 13:30:00 | SPY | ETF | 118.68 | 118.95 | 118.65 | 118.73 | 393100.0 |
| 2001-08-15 14:00:00 | SPY | ETF | 118.74 | 118.95 | 118.55 | 118.95 | 376400.0 |
| 2001-08-15 14:30:00 | SPY | ETF | 118.97 | 119.13 | 118.54 | 118.67 | 580000.0 |
| 2001-08-15 15:00:00 | SPY | ETF | 118.6 | 118.72 | 118.41 | 118.7 | 400900.0 |
| 2001-08-15 15:30:00 | SPY | ETF | 118.68 | 118.72 | 118.2 | 118.28 | 756300.0 |
| 2001-08-15 16:00:00 | SPY | ETF | 118.23 | 118.42 | 118.08 | 118.36 | 1098500.0 |
| 2001-08-15 16:30:00 | SPY | ETF | 118.13 | 118.18 | 118.13 | 118.18 | 8500.0 |
| 2001-08-15 17:00:00 | SPY | ETF | 118.05 | 118.05 | 118.05 | 118.05 | 100.0 |
| 2001-08-15 09:30:00 | QQQ | ETF | 40.62 | 40.93 | 40.3 | 40.37 | 7121200.0 |
| 2001-08-15 10:00:00 | QQQ | ETF | 40.37 | 40.6 | 40.15 | 40.18 | 5621100.0 |
| 2001-08-15 10:30:00 | QQQ | ETF | 40.17 | 40.2 | 39.94 | 40.16 | 5737500.0 |
| 2001-08-15 11:00:00 | QQQ | ETF | 40.13 | 40.2 | 39.75 | 39.79 | 3392700.0 |
| 2001-08-15 11:30:00 | QQQ | ETF | 39.79 | 39.81 | 39.49 | 39.6 | 4756200.0 |
| 2001-08-15 12:00:00 | QQQ | ETF | 39.63 | 39.74 | 39.46 | 39.63 | 4335100.0 |
| 2001-08-15 12:30:00 | QQQ | ETF | 39.63 | 39.75 | 39.54 | 39.71 | 1603200.0 |
| 2001-08-15 13:00:00 | QQQ | ETF | 39.69 | 39.89 | 39.65 | 39.73 | 2421200.0 |
| 2001-08-15 13:30:00 | QQQ | ETF | 39.74 | 39.92 | 39.67 | 39.68 | 1595700.0 |
| 2001-08-15 14:00:00 | QQQ | ETF | 39.69 | 39.71 | 39.49 | 39.67 | 3156600.0 |
| 2001-08-15 14:30:00 | QQQ | ETF | 39.68 | 39.8 | 39.34 | 39.43 | 4363800.0 |
| 2001-08-15 15:00:00 | QQQ | ETF | 39.42 | 39.6 | 39.3 | 39.52 | 3072600.0 |
| 2001-08-15 15:30:00 | QQQ | ETF | 39.54 | 39.57 | 39.16 | 39.19 | 7638000.0 |
| 2001-08-15 16:00:00 | QQQ | ETF | 39.15 | 39.2 | 39.07 | 39.15 | 1531700.0 |
| 2001-08-15 16:30:00 | QQQ | ETF | 39.15 | 39.42 | 39.09 | 39.2 | 205200.0 |
| 2001-08-15 17:00:00 | QQQ | ETF | 39.2 | 39.23 | 39.15 | 39.16 | 49300.0 |
| 2001-08-15 17:30:00 | QQQ | ETF | 39.16 | 39.19 | 39.13 | 39.18 | 10000.0 |
| 2001-08-15 18:00:00 | QQQ | ETF | 39.17 | 39.22 | 39.15 | 39.15 | 13600.0 |
| 2001-08-15 09:30:00 | IWM | ETF | 47.875 | 48.09 | 47.875 | 47.935 | 7400.0 |
| 2001-08-15 10:00:00 | IWM | ETF | 48.07 | 48.115 | 47.93 | 47.95 | 27400.0 |
| 2001-08-15 10:30:00 | IWM | ETF | 47.775 | 47.94 | 47.705 | 47.71 | 4000.0 |
| 2001-08-15 11:00:00 | IWM | ETF | 47.68 | 47.68 | 47.655 | 47.655 | 1000.0 |
| 2001-08-15 12:00:00 | IWM | ETF | 47.6 | 47.665 | 47.6 | 47.665 | 51000.0 |
| 2001-08-15 12:30:00 | IWM | ETF | 47.51 | 47.72 | 47.51 | 47.6 | 82200.0 |
| 2001-08-15 13:00:00 | IWM | ETF | 47.74 | 47.795 | 47.74 | 47.765 | 61200.0 |
| 2001-08-15 13:30:00 | IWM | ETF | 47.705 | 47.94 | 47.705 | 47.85 | 83200.0 |
| 2001-08-15 14:00:00 | IWM | ETF | 47.865 | 47.865 | 47.75 | 47.825 | 116000.0 |
| 2001-08-15 14:30:00 | IWM | ETF | 47.83 | 47.95 | 47.75 | 47.75 | 124600.0 |
| 2001-08-15 15:00:00 | IWM | ETF | 47.79 | 47.825 | 47.7 | 47.825 | 128200.0 |
| 2001-08-15 15:30:00 | IWM | ETF | 47.875 | 47.92 | 47.68 | 47.8 | 147400.0 |
| 2001-08-15 16:00:00 | IWM | ETF | 47.79 | 47.79 | 47.79 | 47.79 | 20000.0 |
| 2001-08-15 09:30:00 | DIA | ETF | 104.31 | 104.7 | 104.27 | 104.56 | 185900.0 |
| 2001-08-15 10:00:00 | DIA | ETF | 104.51 | 104.84 | 104.41 | 104.41 | 279800.0 |
| 2001-08-15 10:30:00 | DIA | ETF | 104.35 | 104.4 | 104.16 | 104.34 | 259700.0 |
> showing 50 of 373 rows — these rows as CSV