PREVIEW / etf_30min / 2001-11-15
file: by_date/etf_30min/2001/2001-11-15.parquet size: 17 KB rows: 451
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-15 09:30:00 | SPY | ETF | 114.37 | 114.44 | 114.07 | 114.18 | 771000.0 |
| 2001-11-15 10:00:00 | SPY | ETF | 114.17 | 114.88 | 113.98 | 114.7 | 1584000.0 |
| 2001-11-15 10:30:00 | SPY | ETF | 114.72 | 115.18 | 114.6 | 114.93 | 1103800.0 |
| 2001-11-15 11:00:00 | SPY | ETF | 114.9 | 115.0 | 114.52 | 114.6 | 983500.0 |
| 2001-11-15 11:30:00 | SPY | ETF | 114.59 | 114.8 | 114.53 | 114.67 | 356900.0 |
| 2001-11-15 12:00:00 | SPY | ETF | 114.72 | 114.97 | 114.53 | 114.8 | 851200.0 |
| 2001-11-15 12:30:00 | SPY | ETF | 114.8 | 114.99 | 114.67 | 114.96 | 869400.0 |
| 2001-11-15 13:00:00 | SPY | ETF | 114.92 | 115.01 | 114.55 | 114.6 | 4255900.0 |
| 2001-11-15 13:30:00 | SPY | ETF | 114.6 | 114.85 | 114.24 | 114.27 | 475100.0 |
| 2001-11-15 14:00:00 | SPY | ETF | 114.32 | 114.33 | 113.93 | 114.23 | 1456300.0 |
| 2001-11-15 14:30:00 | SPY | ETF | 114.26 | 114.55 | 113.98 | 114.41 | 1423300.0 |
| 2001-11-15 15:00:00 | SPY | ETF | 114.41 | 114.52 | 114.12 | 114.19 | 810800.0 |
| 2001-11-15 15:30:00 | SPY | ETF | 114.19 | 114.68 | 114.18 | 114.6 | 654300.0 |
| 2001-11-15 16:00:00 | SPY | ETF | 114.64 | 115.05 | 114.57 | 114.9 | 1029300.0 |
| 2001-11-15 16:30:00 | SPY | ETF | 114.98 | 114.98 | 114.76 | 114.8 | 6700.0 |
| 2001-11-15 17:00:00 | SPY | ETF | 114.79 | 114.8 | 114.79 | 114.8 | 4200.0 |
| 2001-11-15 17:30:00 | SPY | ETF | 114.84 | 114.86 | 114.84 | 114.86 | 1100.0 |
| 2001-11-15 18:00:00 | SPY | ETF | 114.84 | 114.9 | 114.78 | 114.78 | 1200.0 |
| 2001-11-15 09:30:00 | QQQ | ETF | 39.16 | 39.4 | 39.06 | 39.3 | 3981600.0 |
| 2001-11-15 10:00:00 | QQQ | ETF | 39.3 | 39.88 | 39.18 | 39.73 | 11700500.0 |
| 2001-11-15 10:30:00 | QQQ | ETF | 39.73 | 40.11 | 39.69 | 39.85 | 8575100.0 |
| 2001-11-15 11:00:00 | QQQ | ETF | 39.86 | 39.92 | 39.45 | 39.54 | 8271700.0 |
| 2001-11-15 11:30:00 | QQQ | ETF | 39.54 | 39.73 | 39.45 | 39.53 | 3540300.0 |
| 2001-11-15 12:00:00 | QQQ | ETF | 39.53 | 39.74 | 39.4 | 39.72 | 4522300.0 |
| 2001-11-15 12:30:00 | QQQ | ETF | 39.7 | 39.9 | 39.65 | 39.9 | 2505000.0 |
| 2001-11-15 13:00:00 | QQQ | ETF | 39.86 | 39.93 | 39.55 | 39.67 | 3829100.0 |
| 2001-11-15 13:30:00 | QQQ | ETF | 39.65 | 39.8 | 39.3 | 39.36 | 4385700.0 |
| 2001-11-15 14:00:00 | QQQ | ETF | 39.35 | 39.41 | 39.11 | 39.39 | 5437300.0 |
| 2001-11-15 14:30:00 | QQQ | ETF | 39.38 | 39.47 | 39.1 | 39.36 | 4559200.0 |
| 2001-11-15 15:00:00 | QQQ | ETF | 39.37 | 39.5 | 39.15 | 39.23 | 4602300.0 |
| 2001-11-15 15:30:00 | QQQ | ETF | 39.23 | 39.44 | 39.21 | 39.41 | 6239900.0 |
| 2001-11-15 16:00:00 | QQQ | ETF | 39.42 | 39.71 | 39.32 | 39.5 | 2590300.0 |
| 2001-11-15 16:30:00 | QQQ | ETF | 39.5 | 39.51 | 39.3 | 39.3 | 1825300.0 |
| 2001-11-15 17:00:00 | QQQ | ETF | 39.4 | 39.41 | 39.25 | 39.41 | 209800.0 |
| 2001-11-15 17:30:00 | QQQ | ETF | 39.41 | 39.41 | 39.33 | 39.36 | 15100.0 |
| 2001-11-15 18:00:00 | QQQ | ETF | 39.36 | 39.36 | 39.35 | 39.35 | 8500.0 |
| 2001-11-15 09:30:00 | IWM | ETF | 44.875 | 44.925 | 44.675 | 44.925 | 4200.0 |
| 2001-11-15 10:00:00 | IWM | ETF | 44.75 | 45.165 | 44.75 | 45.15 | 20800.0 |
| 2001-11-15 10:30:00 | IWM | ETF | 45.15 | 45.2 | 45.025 | 45.1 | 41400.0 |
| 2001-11-15 11:00:00 | IWM | ETF | 45.085 | 45.125 | 44.95 | 44.995 | 8400.0 |
| 2001-11-15 11:30:00 | IWM | ETF | 44.995 | 44.995 | 44.935 | 44.94 | 19000.0 |
| 2001-11-15 12:00:00 | IWM | ETF | 44.88 | 44.995 | 44.88 | 44.935 | 12200.0 |
| 2001-11-15 12:30:00 | IWM | ETF | 44.995 | 45.125 | 44.94 | 45.045 | 26800.0 |
| 2001-11-15 13:00:00 | IWM | ETF | 45.07 | 45.07 | 44.925 | 45.0 | 13800.0 |
| 2001-11-15 13:30:00 | IWM | ETF | 44.925 | 45.0 | 44.88 | 44.925 | 26400.0 |
| 2001-11-15 14:00:00 | IWM | ETF | 44.875 | 44.875 | 44.795 | 44.825 | 6200.0 |
| 2001-11-15 14:30:00 | IWM | ETF | 44.83 | 44.9 | 44.81 | 44.85 | 38600.0 |
| 2001-11-15 15:00:00 | IWM | ETF | 44.855 | 44.895 | 44.82 | 44.82 | 20600.0 |
| 2001-11-15 15:30:00 | IWM | ETF | 44.81 | 44.87 | 44.8 | 44.815 | 46800.0 |
| 2001-11-15 16:00:00 | IWM | ETF | 44.755 | 44.95 | 44.755 | 44.95 | 49800.0 |
> showing 50 of 451 rows — these rows as CSV