PREVIEW / etf_30min / 2001-11-06
file: by_date/etf_30min/2001/2001-11-06.parquet size: 17 KB rows: 433
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-11-06 09:30:00 | SPY | ETF | 110.35 | 110.53 | 110.15 | 110.5 | 1798700.0 |
| 2001-11-06 10:00:00 | SPY | ETF | 110.52 | 110.63 | 110.28 | 110.43 | 715700.0 |
| 2001-11-06 10:30:00 | SPY | ETF | 110.41 | 110.7 | 110.38 | 110.66 | 693000.0 |
| 2001-11-06 11:00:00 | SPY | ETF | 110.65 | 110.67 | 110.43 | 110.55 | 660100.0 |
| 2001-11-06 11:30:00 | SPY | ETF | 110.55 | 110.65 | 110.49 | 110.55 | 498200.0 |
| 2001-11-06 12:00:00 | SPY | ETF | 110.5 | 110.62 | 110.45 | 110.5 | 338300.0 |
| 2001-11-06 12:30:00 | SPY | ETF | 110.47 | 110.49 | 110.21 | 110.27 | 615800.0 |
| 2001-11-06 13:00:00 | SPY | ETF | 110.25 | 110.42 | 110.22 | 110.25 | 158900.0 |
| 2001-11-06 13:30:00 | SPY | ETF | 110.27 | 110.37 | 109.98 | 110.0 | 642800.0 |
| 2001-11-06 14:00:00 | SPY | ETF | 109.96 | 110.82 | 109.85 | 110.7 | 2923000.0 |
| 2001-11-06 14:30:00 | SPY | ETF | 110.83 | 111.14 | 110.16 | 110.6 | 4688900.0 |
| 2001-11-06 15:00:00 | SPY | ETF | 110.59 | 111.53 | 110.36 | 111.53 | 2885300.0 |
| 2001-11-06 15:30:00 | SPY | ETF | 111.55 | 112.45 | 111.39 | 112.29 | 4603600.0 |
| 2001-11-06 16:00:00 | SPY | ETF | 112.26 | 112.49 | 112.15 | 112.49 | 1356700.0 |
| 2001-11-06 16:30:00 | SPY | ETF | 111.55 | 112.37 | 111.55 | 112.33 | 5700.0 |
| 2001-11-06 17:00:00 | SPY | ETF | 112.26 | 112.45 | 112.24 | 112.25 | 11600.0 |
| 2001-11-06 17:30:00 | SPY | ETF | 112.4 | 112.4 | 112.4 | 112.4 | 100.0 |
| 2001-11-06 18:00:00 | SPY | ETF | 112.2 | 112.2 | 112.16 | 112.16 | 2200.0 |
| 2001-11-06 09:30:00 | QQQ | ETF | 36.6 | 36.9 | 36.39 | 36.87 | 9621100.0 |
| 2001-11-06 10:00:00 | QQQ | ETF | 36.86 | 36.97 | 36.65 | 36.76 | 5516200.0 |
| 2001-11-06 10:30:00 | QQQ | ETF | 36.75 | 37.05 | 36.72 | 37.0 | 4758700.0 |
| 2001-11-06 11:00:00 | QQQ | ETF | 36.99 | 37.01 | 36.8 | 36.88 | 4076100.0 |
| 2001-11-06 11:30:00 | QQQ | ETF | 36.88 | 36.98 | 36.86 | 36.91 | 1411100.0 |
| 2001-11-06 12:00:00 | QQQ | ETF | 36.91 | 36.98 | 36.87 | 36.87 | 1735400.0 |
| 2001-11-06 12:30:00 | QQQ | ETF | 36.89 | 36.91 | 36.6 | 36.64 | 2656200.0 |
| 2001-11-06 13:00:00 | QQQ | ETF | 36.65 | 36.74 | 36.61 | 36.67 | 1787400.0 |
| 2001-11-06 13:30:00 | QQQ | ETF | 36.67 | 36.75 | 36.42 | 36.45 | 5409900.0 |
| 2001-11-06 14:00:00 | QQQ | ETF | 36.45 | 37.08 | 36.4 | 37.05 | 15007900.0 |
| 2001-11-06 14:30:00 | QQQ | ETF | 37.03 | 37.33 | 36.76 | 36.96 | 17089900.0 |
| 2001-11-06 15:00:00 | QQQ | ETF | 36.95 | 37.56 | 36.84 | 37.56 | 10541700.0 |
| 2001-11-06 15:30:00 | QQQ | ETF | 37.56 | 37.98 | 37.47 | 37.92 | 14323200.0 |
| 2001-11-06 16:00:00 | QQQ | ETF | 37.92 | 38.25 | 37.25 | 38.23 | 9309500.0 |
| 2001-11-06 16:30:00 | QQQ | ETF | 38.21 | 38.25 | 37.93 | 38.0 | 290200.0 |
| 2001-11-06 17:00:00 | QQQ | ETF | 38.0 | 38.07 | 36.9 | 37.91 | 282600.0 |
| 2001-11-06 17:30:00 | QQQ | ETF | 37.91 | 37.95 | 37.85 | 37.86 | 112800.0 |
| 2001-11-06 18:00:00 | QQQ | ETF | 37.9 | 38.0 | 37.84 | 37.88 | 29600.0 |
| 2001-11-06 09:30:00 | IWM | ETF | 43.375 | 43.6 | 43.25 | 43.6 | 122400.0 |
| 2001-11-06 10:00:00 | IWM | ETF | 43.5 | 43.6 | 43.36 | 43.45 | 307400.0 |
| 2001-11-06 10:30:00 | IWM | ETF | 43.4 | 43.545 | 43.39 | 43.545 | 14000.0 |
| 2001-11-06 11:00:00 | IWM | ETF | 43.5 | 43.555 | 43.47 | 43.5 | 10000.0 |
| 2001-11-06 11:30:00 | IWM | ETF | 43.5 | 43.725 | 43.47 | 43.565 | 11600.0 |
| 2001-11-06 12:00:00 | IWM | ETF | 43.53 | 43.585 | 43.53 | 43.58 | 12800.0 |
| 2001-11-06 12:30:00 | IWM | ETF | 43.56 | 43.56 | 43.485 | 43.52 | 6800.0 |
| 2001-11-06 13:00:00 | IWM | ETF | 43.5 | 43.51 | 43.435 | 43.505 | 9400.0 |
| 2001-11-06 13:30:00 | IWM | ETF | 43.42 | 43.49 | 43.325 | 43.435 | 9000.0 |
| 2001-11-06 14:00:00 | IWM | ETF | 43.38 | 43.65 | 43.275 | 43.525 | 89600.0 |
| 2001-11-06 14:30:00 | IWM | ETF | 43.475 | 43.725 | 43.35 | 43.55 | 18000.0 |
| 2001-11-06 15:00:00 | IWM | ETF | 43.375 | 43.76 | 43.375 | 43.75 | 46400.0 |
| 2001-11-06 15:30:00 | IWM | ETF | 43.81 | 44.125 | 43.81 | 44.075 | 767200.0 |
| 2001-11-06 16:00:00 | IWM | ETF | 44.11 | 44.25 | 43.95 | 44.25 | 44600.0 |
> showing 50 of 433 rows — these rows as CSV