PREVIEW / etf_30min / 2001-11-26
file: by_date/etf_30min/2001/2001-11-26.parquet size: 17 KB rows: 462
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-26 09:30:00 | SPY | ETF | 115.75 | 116.1 | 115.35 | 115.88 | 2238600.0 |
| 2001-11-26 10:00:00 | SPY | ETF | 115.86 | 116.05 | 115.46 | 115.52 | 1144400.0 |
| 2001-11-26 10:30:00 | SPY | ETF | 115.49 | 115.79 | 115.31 | 115.42 | 926100.0 |
| 2001-11-26 11:00:00 | SPY | ETF | 115.43 | 115.52 | 115.07 | 115.19 | 701200.0 |
| 2001-11-26 11:30:00 | SPY | ETF | 115.15 | 115.38 | 115.1 | 115.35 | 550900.0 |
| 2001-11-26 12:00:00 | SPY | ETF | 115.37 | 115.6 | 115.27 | 115.49 | 344400.0 |
| 2001-11-26 12:30:00 | SPY | ETF | 115.47 | 115.69 | 115.34 | 115.63 | 449900.0 |
| 2001-11-26 13:00:00 | SPY | ETF | 115.6 | 115.94 | 115.58 | 115.84 | 514700.0 |
| 2001-11-26 13:30:00 | SPY | ETF | 115.78 | 116.03 | 115.75 | 115.98 | 790700.0 |
| 2001-11-26 14:00:00 | SPY | ETF | 115.97 | 116.13 | 115.82 | 115.86 | 1683100.0 |
| 2001-11-26 14:30:00 | SPY | ETF | 115.82 | 116.32 | 115.79 | 116.27 | 1413500.0 |
| 2001-11-26 15:00:00 | SPY | ETF | 116.3 | 116.34 | 116.07 | 116.18 | 968700.0 |
| 2001-11-26 15:30:00 | SPY | ETF | 116.21 | 116.28 | 115.96 | 116.21 | 1430100.0 |
| 2001-11-26 16:00:00 | SPY | ETF | 116.24 | 116.24 | 115.92 | 115.92 | 480900.0 |
| 2001-11-26 16:30:00 | SPY | ETF | 115.92 | 115.98 | 115.89 | 115.91 | 2600.0 |
| 2001-11-26 17:00:00 | SPY | ETF | 115.91 | 115.96 | 115.9 | 115.91 | 1500.0 |
| 2001-11-26 17:30:00 | SPY | ETF | 115.95 | 115.95 | 115.9 | 115.9 | 1000.0 |
| 2001-11-26 18:00:00 | SPY | ETF | 115.85 | 115.85 | 115.85 | 115.85 | 1000.0 |
| 2001-11-26 09:30:00 | QQQ | ETF | 39.58 | 40.1 | 39.45 | 39.99 | 14213200.0 |
| 2001-11-26 10:00:00 | QQQ | ETF | 39.96 | 40.18 | 39.77 | 39.78 | 8163000.0 |
| 2001-11-26 10:30:00 | QQQ | ETF | 39.81 | 40.02 | 39.6 | 39.66 | 4956700.0 |
| 2001-11-26 11:00:00 | QQQ | ETF | 39.66 | 39.75 | 39.35 | 39.41 | 4332600.0 |
| 2001-11-26 11:30:00 | QQQ | ETF | 39.4 | 39.73 | 39.38 | 39.72 | 3436700.0 |
| 2001-11-26 12:00:00 | QQQ | ETF | 39.71 | 39.86 | 39.61 | 39.76 | 2165700.0 |
| 2001-11-26 12:30:00 | QQQ | ETF | 39.76 | 39.88 | 39.63 | 39.81 | 1980800.0 |
| 2001-11-26 13:00:00 | QQQ | ETF | 39.81 | 39.99 | 39.79 | 39.95 | 3018300.0 |
| 2001-11-26 13:30:00 | QQQ | ETF | 39.95 | 40.21 | 39.92 | 40.16 | 7355000.0 |
| 2001-11-26 14:00:00 | QQQ | ETF | 40.14 | 40.27 | 40.01 | 40.04 | 6111200.0 |
| 2001-11-26 14:30:00 | QQQ | ETF | 40.05 | 40.35 | 39.95 | 40.34 | 5181400.0 |
| 2001-11-26 15:00:00 | QQQ | ETF | 40.34 | 40.35 | 40.12 | 40.18 | 6304600.0 |
| 2001-11-26 15:30:00 | QQQ | ETF | 40.15 | 40.34 | 40.08 | 40.33 | 6188500.0 |
| 2001-11-26 16:00:00 | QQQ | ETF | 40.3 | 40.36 | 40.21 | 40.28 | 1276400.0 |
| 2001-11-26 16:30:00 | QQQ | ETF | 40.25 | 40.32 | 40.05 | 40.2 | 84200.0 |
| 2001-11-26 17:00:00 | QQQ | ETF | 40.26 | 40.28 | 40.22 | 40.27 | 27000.0 |
| 2001-11-26 17:30:00 | QQQ | ETF | 40.27 | 40.28 | 40.19 | 40.23 | 20800.0 |
| 2001-11-26 18:00:00 | QQQ | ETF | 40.22 | 40.23 | 40.2 | 40.22 | 16900.0 |
| 2001-11-26 09:30:00 | IWM | ETF | 45.74 | 45.995 | 45.675 | 45.995 | 163000.0 |
| 2001-11-26 10:00:00 | IWM | ETF | 45.875 | 46.075 | 45.725 | 45.79 | 36600.0 |
| 2001-11-26 10:30:00 | IWM | ETF | 45.705 | 45.85 | 45.705 | 45.705 | 26200.0 |
| 2001-11-26 11:00:00 | IWM | ETF | 45.705 | 45.735 | 45.53 | 45.53 | 85600.0 |
| 2001-11-26 11:30:00 | IWM | ETF | 45.52 | 45.58 | 45.45 | 45.58 | 19200.0 |
| 2001-11-26 12:00:00 | IWM | ETF | 45.55 | 45.6 | 45.515 | 45.595 | 11200.0 |
| 2001-11-26 12:30:00 | IWM | ETF | 45.575 | 45.58 | 45.475 | 45.565 | 17400.0 |
| 2001-11-26 13:00:00 | IWM | ETF | 45.595 | 45.725 | 45.585 | 45.725 | 25600.0 |
| 2001-11-26 13:30:00 | IWM | ETF | 45.725 | 45.8 | 45.725 | 45.76 | 20200.0 |
| 2001-11-26 14:00:00 | IWM | ETF | 45.81 | 45.875 | 45.775 | 45.825 | 15800.0 |
| 2001-11-26 14:30:00 | IWM | ETF | 45.785 | 45.89 | 45.765 | 45.89 | 19600.0 |
| 2001-11-26 15:00:00 | IWM | ETF | 45.915 | 45.94 | 45.855 | 45.9 | 18600.0 |
| 2001-11-26 15:30:00 | IWM | ETF | 45.875 | 45.98 | 45.805 | 45.98 | 86200.0 |
| 2001-11-26 16:00:00 | IWM | ETF | 45.855 | 45.975 | 45.855 | 45.975 | 2600.0 |
> showing 50 of 462 rows — these rows as CSV