PREVIEW / etf_30min / 2002-11-04
file: by_date/etf_30min/2002/2002-11-04.parquet size: 23 KB rows: 667
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 |
|---|---|---|---|---|---|---|---|
| 2002-11-04 08:00:00 | SPY | ETF | 91.54 | 91.7 | 91.53 | 91.62 | 21100.0 |
| 2002-11-04 08:30:00 | SPY | ETF | 91.65 | 91.77 | 91.65 | 91.72 | 5500.0 |
| 2002-11-04 09:00:00 | SPY | ETF | 91.83 | 91.88 | 91.71 | 91.8 | 59400.0 |
| 2002-11-04 09:30:00 | SPY | ETF | 91.8 | 91.97 | 91.6 | 91.84 | 4688600.0 |
| 2002-11-04 10:00:00 | SPY | ETF | 91.8 | 92.38 | 91.74 | 92.25 | 4761500.0 |
| 2002-11-04 10:30:00 | SPY | ETF | 92.23 | 92.59 | 92.12 | 92.31 | 3208000.0 |
| 2002-11-04 11:00:00 | SPY | ETF | 92.3 | 92.5 | 92.13 | 92.41 | 2383400.0 |
| 2002-11-04 11:30:00 | SPY | ETF | 92.45 | 92.7 | 92.38 | 92.5 | 2858200.0 |
| 2002-11-04 12:00:00 | SPY | ETF | 92.48 | 92.84 | 92.44 | 92.73 | 1856800.0 |
| 2002-11-04 12:30:00 | SPY | ETF | 92.74 | 92.94 | 92.65 | 92.69 | 1730800.0 |
| 2002-11-04 13:00:00 | SPY | ETF | 92.7 | 92.78 | 92.52 | 92.65 | 1241100.0 |
| 2002-11-04 13:30:00 | SPY | ETF | 92.62 | 92.67 | 92.32 | 92.45 | 3502800.0 |
| 2002-11-04 14:00:00 | SPY | ETF | 92.45 | 92.59 | 92.09 | 92.16 | 2129000.0 |
| 2002-11-04 14:30:00 | SPY | ETF | 92.15 | 92.53 | 91.7 | 91.85 | 3544200.0 |
| 2002-11-04 15:00:00 | SPY | ETF | 91.82 | 91.9 | 91.21 | 91.24 | 4581600.0 |
| 2002-11-04 15:30:00 | SPY | ETF | 91.2 | 91.38 | 90.9 | 91.15 | 4438200.0 |
| 2002-11-04 16:00:00 | SPY | ETF | 91.15 | 92.41 | 90.47 | 91.01 | 4386400.0 |
| 2002-11-04 16:30:00 | SPY | ETF | 91.02 | 92.41 | 91.0 | 91.15 | 496100.0 |
| 2002-11-04 17:00:00 | SPY | ETF | 91.15 | 91.15 | 91.1 | 91.15 | 8200.0 |
| 2002-11-04 17:30:00 | SPY | ETF | 91.15 | 91.18 | 91.15 | 91.18 | 1200.0 |
| 2002-11-04 18:00:00 | SPY | ETF | 91.15 | 91.15 | 91.01 | 91.01 | 900.0 |
| 2002-11-04 19:00:00 | SPY | ETF | 91.14 | 91.2 | 91.14 | 91.2 | 2100.0 |
| 2002-11-04 08:00:00 | QQQ | ETF | 25.89 | 26.04 | 25.89 | 26.04 | 45200.0 |
| 2002-11-04 08:30:00 | QQQ | ETF | 26.04 | 26.1 | 26.01 | 26.07 | 74900.0 |
| 2002-11-04 09:00:00 | QQQ | ETF | 26.07 | 26.08 | 26.03 | 26.05 | 18000.0 |
| 2002-11-04 09:30:00 | QQQ | ETF | 26.05 | 26.15 | 25.91 | 26.09 | 14088800.0 |
| 2002-11-04 10:00:00 | QQQ | ETF | 26.08 | 26.44 | 26.02 | 26.33 | 11030600.0 |
| 2002-11-04 10:30:00 | QQQ | ETF | 26.34 | 26.46 | 26.24 | 26.35 | 12188400.0 |
| 2002-11-04 11:00:00 | QQQ | ETF | 26.36 | 26.39 | 26.2 | 26.3 | 7840100.0 |
| 2002-11-04 11:30:00 | QQQ | ETF | 26.3 | 26.4 | 26.27 | 26.34 | 6911700.0 |
| 2002-11-04 12:00:00 | QQQ | ETF | 26.33 | 26.55 | 26.31 | 26.53 | 7399400.0 |
| 2002-11-04 12:30:00 | QQQ | ETF | 26.53 | 26.63 | 26.5 | 26.53 | 3476700.0 |
| 2002-11-04 13:00:00 | QQQ | ETF | 26.54 | 26.56 | 26.4 | 26.44 | 3190400.0 |
| 2002-11-04 13:30:00 | QQQ | ETF | 26.44 | 26.46 | 26.31 | 26.41 | 3823400.0 |
| 2002-11-04 14:00:00 | QQQ | ETF | 26.37 | 26.51 | 26.33 | 26.4 | 2782500.0 |
| 2002-11-04 14:30:00 | QQQ | ETF | 26.38 | 26.59 | 26.23 | 26.3 | 4429900.0 |
| 2002-11-04 15:00:00 | QQQ | ETF | 26.3 | 26.34 | 26.05 | 26.06 | 9748600.0 |
| 2002-11-04 15:30:00 | QQQ | ETF | 26.08 | 26.12 | 25.8 | 25.97 | 12150200.0 |
| 2002-11-04 16:00:00 | QQQ | ETF | 25.99 | 26.05 | 25.87 | 25.95 | 1822100.0 |
| 2002-11-04 16:30:00 | QQQ | ETF | 25.96 | 26.04 | 25.9 | 26.0 | 405200.0 |
| 2002-11-04 17:00:00 | QQQ | ETF | 26.0 | 26.0 | 25.9 | 25.98 | 62500.0 |
| 2002-11-04 17:30:00 | QQQ | ETF | 26.0 | 26.0 | 25.95 | 26.0 | 27100.0 |
| 2002-11-04 18:00:00 | QQQ | ETF | 26.0 | 26.0 | 25.97 | 25.98 | 15600.0 |
| 2002-11-04 19:00:00 | QQQ | ETF | 25.96 | 25.96 | 25.96 | 25.96 | 600.0 |
| 2002-11-04 19:30:00 | QQQ | ETF | 25.96 | 25.97 | 25.96 | 25.96 | 2800.0 |
| 2002-11-04 09:30:00 | IWM | ETF | 38.695 | 38.825 | 38.5 | 38.575 | 1261600.0 |
| 2002-11-04 10:00:00 | IWM | ETF | 38.67 | 38.92 | 38.55 | 38.835 | 219000.0 |
| 2002-11-04 10:30:00 | IWM | ETF | 38.875 | 38.965 | 38.85 | 38.9 | 511600.0 |
| 2002-11-04 11:00:00 | IWM | ETF | 38.9 | 38.955 | 38.815 | 38.9 | 47600.0 |
| 2002-11-04 11:30:00 | IWM | ETF | 38.935 | 39.025 | 38.85 | 38.87 | 162000.0 |
> showing 50 of 667 rows — these rows as CSV