PREVIEW / etf_30min / 2003-01-22
file: by_date/etf_30min/2003/2003-01-22.parquet size: 22 KB rows: 653
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 |
|---|---|---|---|---|---|---|---|
| 2003-01-22 08:00:00 | SPY | ETF | 88.7 | 88.75 | 88.53 | 88.67 | 20200.0 |
| 2003-01-22 08:30:00 | SPY | ETF | 88.66 | 88.7 | 88.57 | 88.68 | 17300.0 |
| 2003-01-22 09:00:00 | SPY | ETF | 88.68 | 88.74 | 88.65 | 88.74 | 29100.0 |
| 2003-01-22 09:30:00 | SPY | ETF | 88.77 | 89.08 | 88.61 | 88.9 | 5344600.0 |
| 2003-01-22 10:00:00 | SPY | ETF | 88.92 | 89.1 | 88.55 | 89.1 | 3288600.0 |
| 2003-01-22 10:30:00 | SPY | ETF | 89.09 | 89.32 | 88.91 | 89.07 | 2841200.0 |
| 2003-01-22 11:00:00 | SPY | ETF | 89.08 | 89.09 | 88.56 | 88.61 | 2290300.0 |
| 2003-01-22 11:30:00 | SPY | ETF | 88.6 | 88.75 | 88.45 | 88.56 | 2224800.0 |
| 2003-01-22 12:00:00 | SPY | ETF | 88.53 | 88.92 | 88.52 | 88.74 | 2176500.0 |
| 2003-01-22 12:30:00 | SPY | ETF | 88.73 | 89.22 | 88.71 | 89.1 | 2776100.0 |
| 2003-01-22 13:00:00 | SPY | ETF | 89.08 | 89.3 | 88.96 | 89.01 | 2166500.0 |
| 2003-01-22 13:30:00 | SPY | ETF | 89.02 | 89.07 | 88.73 | 88.78 | 1226000.0 |
| 2003-01-22 14:00:00 | SPY | ETF | 88.78 | 89.22 | 88.72 | 88.96 | 2732500.0 |
| 2003-01-22 14:30:00 | SPY | ETF | 88.95 | 89.04 | 88.42 | 88.55 | 4897400.0 |
| 2003-01-22 15:00:00 | SPY | ETF | 88.54 | 88.75 | 88.25 | 88.26 | 2526300.0 |
| 2003-01-22 15:30:00 | SPY | ETF | 88.29 | 88.35 | 88.01 | 88.06 | 4478000.0 |
| 2003-01-22 16:00:00 | SPY | ETF | 88.06 | 88.22 | 88.03 | 88.19 | 1000900.0 |
| 2003-01-22 16:30:00 | SPY | ETF | 88.15 | 88.4 | 88.15 | 88.31 | 93400.0 |
| 2003-01-22 17:00:00 | SPY | ETF | 88.33 | 88.34 | 88.21 | 88.27 | 194900.0 |
| 2003-01-22 17:30:00 | SPY | ETF | 88.3 | 88.43 | 88.3 | 88.43 | 238300.0 |
| 2003-01-22 18:00:00 | SPY | ETF | 88.42 | 88.58 | 88.36 | 88.52 | 220100.0 |
| 2003-01-22 18:30:00 | SPY | ETF | 88.57 | 88.57 | 88.5 | 88.5 | 8900.0 |
| 2003-01-22 19:00:00 | SPY | ETF | 88.51 | 88.53 | 88.5 | 88.5 | 4400.0 |
| 2003-01-22 08:00:00 | QQQ | ETF | 24.89 | 24.91 | 24.84 | 24.91 | 107800.0 |
| 2003-01-22 08:30:00 | QQQ | ETF | 24.9 | 24.91 | 24.87 | 24.9 | 25300.0 |
| 2003-01-22 09:00:00 | QQQ | ETF | 24.9 | 24.96 | 24.89 | 24.95 | 63000.0 |
| 2003-01-22 09:30:00 | QQQ | ETF | 24.96 | 25.22 | 24.87 | 25.12 | 14465700.0 |
| 2003-01-22 10:00:00 | QQQ | ETF | 25.12 | 25.33 | 24.99 | 25.3 | 8757500.0 |
| 2003-01-22 10:30:00 | QQQ | ETF | 25.32 | 25.41 | 25.2 | 25.35 | 5331200.0 |
| 2003-01-22 11:00:00 | QQQ | ETF | 25.37 | 25.37 | 25.21 | 25.23 | 4700200.0 |
| 2003-01-22 11:30:00 | QQQ | ETF | 25.24 | 25.32 | 25.2 | 25.24 | 4396000.0 |
| 2003-01-22 12:00:00 | QQQ | ETF | 25.21 | 25.37 | 25.21 | 25.29 | 2977700.0 |
| 2003-01-22 12:30:00 | QQQ | ETF | 25.29 | 25.52 | 25.29 | 25.44 | 4108800.0 |
| 2003-01-22 13:00:00 | QQQ | ETF | 25.43 | 25.53 | 25.39 | 25.4 | 3147700.0 |
| 2003-01-22 13:30:00 | QQQ | ETF | 25.43 | 25.48 | 25.33 | 25.37 | 2577500.0 |
| 2003-01-22 14:00:00 | QQQ | ETF | 25.37 | 25.53 | 25.32 | 25.45 | 2502500.0 |
| 2003-01-22 14:30:00 | QQQ | ETF | 25.43 | 25.47 | 25.22 | 25.25 | 5230900.0 |
| 2003-01-22 15:00:00 | QQQ | ETF | 25.25 | 25.33 | 25.06 | 25.13 | 3568900.0 |
| 2003-01-22 15:30:00 | QQQ | ETF | 25.08 | 25.18 | 24.99 | 25.03 | 6692800.0 |
| 2003-01-22 16:00:00 | QQQ | ETF | 25.05 | 25.07 | 24.93 | 25.01 | 1903000.0 |
| 2003-01-22 16:30:00 | QQQ | ETF | 25.04 | 25.2 | 25.01 | 25.15 | 2535000.0 |
| 2003-01-22 17:00:00 | QQQ | ETF | 25.16 | 25.21 | 25.15 | 25.19 | 802700.0 |
| 2003-01-22 17:30:00 | QQQ | ETF | 25.18 | 25.28 | 25.16 | 25.25 | 532600.0 |
| 2003-01-22 18:00:00 | QQQ | ETF | 25.24 | 25.38 | 25.23 | 25.33 | 614300.0 |
| 2003-01-22 18:30:00 | QQQ | ETF | 25.32 | 25.38 | 25.32 | 25.37 | 20100.0 |
| 2003-01-22 19:00:00 | QQQ | ETF | 25.37 | 25.4 | 25.31 | 25.33 | 20700.0 |
| 2003-01-22 19:30:00 | QQQ | ETF | 25.3 | 25.35 | 25.3 | 25.32 | 14600.0 |
| 2003-01-22 09:30:00 | IWM | ETF | 37.885 | 38.0 | 37.875 | 37.955 | 471800.0 |
| 2003-01-22 10:00:00 | IWM | ETF | 37.95 | 37.98 | 37.79 | 37.95 | 683600.0 |
| 2003-01-22 10:30:00 | IWM | ETF | 37.94 | 38.05 | 37.94 | 38.0 | 144400.0 |
> showing 50 of 653 rows — these rows as CSV