PREVIEW / etf_30min / 2001-08-22
file: by_date/etf_30min/2001/2001-08-22.parquet size: 16 KB rows: 393
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-22 09:30:00 | SPY | ETF | 116.75 | 116.79 | 116.32 | 116.74 | 1425900.0 |
| 2001-08-22 10:00:00 | SPY | ETF | 116.79 | 116.84 | 116.01 | 116.15 | 1398900.0 |
| 2001-08-22 10:30:00 | SPY | ETF | 116.19 | 116.57 | 115.98 | 116.03 | 815500.0 |
| 2001-08-22 11:00:00 | SPY | ETF | 116.0 | 116.22 | 115.78 | 116.21 | 619200.0 |
| 2001-08-22 11:30:00 | SPY | ETF | 116.14 | 116.54 | 115.98 | 116.52 | 789500.0 |
| 2001-08-22 12:00:00 | SPY | ETF | 116.52 | 116.8 | 116.46 | 116.59 | 493700.0 |
| 2001-08-22 12:30:00 | SPY | ETF | 116.61 | 116.78 | 116.39 | 116.47 | 372600.0 |
| 2001-08-22 13:00:00 | SPY | ETF | 116.47 | 116.62 | 116.32 | 116.59 | 287400.0 |
| 2001-08-22 13:30:00 | SPY | ETF | 116.55 | 116.56 | 116.12 | 116.15 | 320200.0 |
| 2001-08-22 14:00:00 | SPY | ETF | 116.14 | 116.7 | 116.05 | 116.68 | 678700.0 |
| 2001-08-22 14:30:00 | SPY | ETF | 116.69 | 117.31 | 116.65 | 117.15 | 1438800.0 |
| 2001-08-22 15:00:00 | SPY | ETF | 117.19 | 117.43 | 116.8 | 116.95 | 1006600.0 |
| 2001-08-22 15:30:00 | SPY | ETF | 116.96 | 117.05 | 116.56 | 117.05 | 814300.0 |
| 2001-08-22 16:00:00 | SPY | ETF | 117.04 | 117.4 | 116.81 | 117.05 | 661500.0 |
| 2001-08-22 16:30:00 | SPY | ETF | 117.1 | 117.1 | 116.91 | 117.0 | 11300.0 |
| 2001-08-22 17:30:00 | SPY | ETF | 117.2 | 117.2 | 117.2 | 117.2 | 500.0 |
| 2001-08-22 09:30:00 | QQQ | ETF | 37.45 | 37.49 | 37.06 | 37.33 | 9127100.0 |
| 2001-08-22 10:00:00 | QQQ | ETF | 37.33 | 37.4 | 36.85 | 37.0 | 6708300.0 |
| 2001-08-22 10:30:00 | QQQ | ETF | 37.02 | 37.21 | 36.74 | 36.74 | 4601900.0 |
| 2001-08-22 11:00:00 | QQQ | ETF | 36.8 | 36.87 | 36.54 | 36.87 | 5791100.0 |
| 2001-08-22 11:30:00 | QQQ | ETF | 36.87 | 37.08 | 36.74 | 37.08 | 3574700.0 |
| 2001-08-22 12:00:00 | QQQ | ETF | 37.04 | 37.18 | 37.01 | 37.1 | 2547700.0 |
| 2001-08-22 12:30:00 | QQQ | ETF | 37.12 | 37.22 | 36.91 | 36.97 | 2297400.0 |
| 2001-08-22 13:00:00 | QQQ | ETF | 36.96 | 37.08 | 36.85 | 37.03 | 1621900.0 |
| 2001-08-22 13:30:00 | QQQ | ETF | 37.01 | 37.04 | 36.67 | 36.67 | 2758000.0 |
| 2001-08-22 14:00:00 | QQQ | ETF | 36.66 | 37.08 | 36.56 | 37.05 | 2927600.0 |
| 2001-08-22 14:30:00 | QQQ | ETF | 37.09 | 37.61 | 36.96 | 37.55 | 5824100.0 |
| 2001-08-22 15:00:00 | QQQ | ETF | 37.56 | 37.84 | 37.47 | 37.63 | 6016500.0 |
| 2001-08-22 15:30:00 | QQQ | ETF | 37.63 | 37.75 | 37.31 | 37.69 | 5454900.0 |
| 2001-08-22 16:00:00 | QQQ | ETF | 37.7 | 37.73 | 37.14 | 37.7 | 2318700.0 |
| 2001-08-22 16:30:00 | QQQ | ETF | 37.72 | 37.78 | 37.06 | 37.77 | 627400.0 |
| 2001-08-22 17:00:00 | QQQ | ETF | 37.72 | 37.83 | 37.7 | 37.82 | 54200.0 |
| 2001-08-22 17:30:00 | QQQ | ETF | 37.82 | 37.85 | 37.73 | 37.78 | 22400.0 |
| 2001-08-22 18:00:00 | QQQ | ETF | 37.74 | 37.9 | 37.74 | 37.9 | 45600.0 |
| 2001-08-22 09:30:00 | IWM | ETF | 47.45 | 47.525 | 47.35 | 47.445 | 29800.0 |
| 2001-08-22 10:00:00 | IWM | ETF | 47.375 | 47.425 | 47.15 | 47.15 | 36800.0 |
| 2001-08-22 10:30:00 | IWM | ETF | 47.2 | 47.325 | 47.125 | 47.125 | 46200.0 |
| 2001-08-22 11:00:00 | IWM | ETF | 47.055 | 47.125 | 46.89 | 47.065 | 17000.0 |
| 2001-08-22 11:30:00 | IWM | ETF | 47.005 | 47.55 | 47.005 | 47.15 | 221000.0 |
| 2001-08-22 12:00:00 | IWM | ETF | 47.095 | 47.245 | 47.095 | 47.195 | 36400.0 |
| 2001-08-22 12:30:00 | IWM | ETF | 47.175 | 47.195 | 47.15 | 47.195 | 14400.0 |
| 2001-08-22 13:00:00 | IWM | ETF | 47.125 | 47.165 | 47.075 | 47.12 | 27200.0 |
| 2001-08-22 13:30:00 | IWM | ETF | 47.12 | 47.15 | 47.04 | 47.04 | 217400.0 |
| 2001-08-22 14:00:00 | IWM | ETF | 47.025 | 47.2 | 47.025 | 47.15 | 81600.0 |
| 2001-08-22 14:30:00 | IWM | ETF | 47.175 | 47.42 | 47.175 | 47.385 | 66400.0 |
| 2001-08-22 15:00:00 | IWM | ETF | 47.37 | 47.6 | 47.37 | 47.445 | 35600.0 |
| 2001-08-22 15:30:00 | IWM | ETF | 47.44 | 47.65 | 47.4 | 47.55 | 432000.0 |
| 2001-08-22 16:00:00 | IWM | ETF | 47.675 | 47.675 | 47.65 | 47.65 | 5800.0 |
| 2001-08-22 09:30:00 | DIA | ETF | 102.2 | 102.3 | 101.92 | 102.25 | 817100.0 |
| 2001-08-22 10:00:00 | DIA | ETF | 102.26 | 102.32 | 101.6 | 101.76 | 742300.0 |
> showing 50 of 393 rows — these rows as CSV