PREVIEW / etf_30min / 2001-11-08
file: by_date/etf_30min/2001/2001-11-08.parquet size: 18 KB rows: 469
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-08 09:30:00 | SPY | ETF | 112.87 | 113.06 | 112.6 | 112.91 | 2897600.0 |
| 2001-11-08 10:00:00 | SPY | ETF | 112.9 | 113.55 | 112.7 | 113.42 | 1498800.0 |
| 2001-11-08 10:30:00 | SPY | ETF | 113.44 | 113.95 | 113.3 | 113.93 | 1873300.0 |
| 2001-11-08 11:00:00 | SPY | ETF | 113.9 | 114.08 | 113.4 | 113.45 | 1661900.0 |
| 2001-11-08 11:30:00 | SPY | ETF | 113.4 | 113.86 | 113.37 | 113.66 | 1999200.0 |
| 2001-11-08 12:00:00 | SPY | ETF | 113.64 | 113.74 | 113.2 | 113.3 | 972500.0 |
| 2001-11-08 12:30:00 | SPY | ETF | 113.3 | 113.48 | 113.21 | 113.34 | 634400.0 |
| 2001-11-08 13:00:00 | SPY | ETF | 113.42 | 113.55 | 113.1 | 113.41 | 889300.0 |
| 2001-11-08 13:30:00 | SPY | ETF | 113.4 | 113.7 | 113.32 | 113.35 | 952900.0 |
| 2001-11-08 14:00:00 | SPY | ETF | 113.33 | 113.4 | 112.82 | 113.02 | 1655700.0 |
| 2001-11-08 14:30:00 | SPY | ETF | 113.02 | 113.1 | 112.67 | 112.71 | 1068900.0 |
| 2001-11-08 15:00:00 | SPY | ETF | 112.73 | 112.75 | 112.11 | 112.19 | 2464400.0 |
| 2001-11-08 15:30:00 | SPY | ETF | 112.19 | 112.5 | 111.9 | 112.35 | 1842300.0 |
| 2001-11-08 16:00:00 | SPY | ETF | 112.3 | 112.68 | 112.27 | 112.6 | 1649700.0 |
| 2001-11-08 16:30:00 | SPY | ETF | 112.26 | 112.65 | 112.26 | 112.62 | 206600.0 |
| 2001-11-08 17:00:00 | SPY | ETF | 112.62 | 113.26 | 112.49 | 112.49 | 184500.0 |
| 2001-11-08 17:30:00 | SPY | ETF | 112.6 | 112.6 | 112.6 | 112.6 | 100.0 |
| 2001-11-08 18:00:00 | SPY | ETF | 112.5 | 112.53 | 112.5 | 112.53 | 1400.0 |
| 2001-11-08 09:30:00 | QQQ | ETF | 38.55 | 38.81 | 38.35 | 38.73 | 14309000.0 |
| 2001-11-08 10:00:00 | QQQ | ETF | 38.72 | 39.1 | 38.59 | 39.0 | 11208700.0 |
| 2001-11-08 10:30:00 | QQQ | ETF | 39.0 | 39.33 | 38.83 | 39.28 | 7199100.0 |
| 2001-11-08 11:00:00 | QQQ | ETF | 39.28 | 39.4 | 39.02 | 39.05 | 8086300.0 |
| 2001-11-08 11:30:00 | QQQ | ETF | 39.05 | 39.34 | 38.98 | 39.16 | 7268600.0 |
| 2001-11-08 12:00:00 | QQQ | ETF | 39.18 | 39.2 | 38.88 | 39.0 | 3755600.0 |
| 2001-11-08 12:30:00 | QQQ | ETF | 38.99 | 39.19 | 38.93 | 39.16 | 3785800.0 |
| 2001-11-08 13:00:00 | QQQ | ETF | 39.12 | 39.24 | 38.9 | 39.1 | 2762700.0 |
| 2001-11-08 13:30:00 | QQQ | ETF | 39.07 | 39.3 | 38.97 | 38.97 | 3976500.0 |
| 2001-11-08 14:00:00 | QQQ | ETF | 38.99 | 39.01 | 38.49 | 38.6 | 8947200.0 |
| 2001-11-08 14:30:00 | QQQ | ETF | 38.62 | 38.65 | 38.15 | 38.18 | 8476600.0 |
| 2001-11-08 15:00:00 | QQQ | ETF | 38.19 | 38.2 | 37.48 | 37.61 | 11159200.0 |
| 2001-11-08 15:30:00 | QQQ | ETF | 37.6 | 37.96 | 37.28 | 37.65 | 10580200.0 |
| 2001-11-08 16:00:00 | QQQ | ETF | 37.67 | 37.81 | 36.92 | 37.8 | 2214300.0 |
| 2001-11-08 16:30:00 | QQQ | ETF | 37.8 | 37.98 | 37.65 | 37.68 | 132200.0 |
| 2001-11-08 17:00:00 | QQQ | ETF | 37.68 | 38.74 | 37.65 | 37.69 | 23600.0 |
| 2001-11-08 17:30:00 | QQQ | ETF | 37.69 | 37.76 | 37.67 | 37.72 | 31000.0 |
| 2001-11-08 18:00:00 | QQQ | ETF | 37.72 | 37.75 | 37.68 | 37.75 | 34100.0 |
| 2001-11-08 09:30:00 | IWM | ETF | 44.175 | 44.195 | 43.905 | 44.155 | 9400.0 |
| 2001-11-08 10:00:00 | IWM | ETF | 44.09 | 44.45 | 44.09 | 44.35 | 26400.0 |
| 2001-11-08 10:30:00 | IWM | ETF | 44.355 | 44.445 | 44.23 | 44.445 | 37400.0 |
| 2001-11-08 11:00:00 | IWM | ETF | 44.45 | 44.45 | 44.305 | 44.315 | 22000.0 |
| 2001-11-08 11:30:00 | IWM | ETF | 44.25 | 44.255 | 44.185 | 44.21 | 46400.0 |
| 2001-11-08 12:00:00 | IWM | ETF | 44.205 | 44.225 | 43.955 | 43.955 | 50600.0 |
| 2001-11-08 12:30:00 | IWM | ETF | 44.005 | 44.115 | 44.005 | 44.105 | 28200.0 |
| 2001-11-08 13:00:00 | IWM | ETF | 44.12 | 44.24 | 44.1 | 44.225 | 25800.0 |
| 2001-11-08 13:30:00 | IWM | ETF | 44.195 | 44.275 | 44.19 | 44.22 | 20400.0 |
| 2001-11-08 14:00:00 | IWM | ETF | 44.18 | 44.19 | 44.15 | 44.15 | 2800.0 |
| 2001-11-08 14:30:00 | IWM | ETF | 44.09 | 44.09 | 44.0 | 44.02 | 32400.0 |
| 2001-11-08 15:00:00 | IWM | ETF | 43.975 | 43.975 | 43.695 | 43.725 | 87200.0 |
| 2001-11-08 15:30:00 | IWM | ETF | 43.72 | 43.84 | 43.475 | 43.725 | 67800.0 |
| 2001-11-08 16:00:00 | IWM | ETF | 43.85 | 43.85 | 43.85 | 43.85 | 26000.0 |
> showing 50 of 469 rows — these rows as CSV