PREVIEW / etf_30min / 2002-10-14
file: by_date/etf_30min/2002/2002-10-14.parquet size: 20 KB rows: 578
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-10-14 08:00:00 | SPY | ETF | 83.3 | 83.32 | 83.26 | 83.31 | 5400.0 |
| 2002-10-14 08:30:00 | SPY | ETF | 83.32 | 83.32 | 83.26 | 83.28 | 13700.0 |
| 2002-10-14 09:00:00 | SPY | ETF | 83.31 | 83.31 | 83.13 | 83.13 | 5400.0 |
| 2002-10-14 09:30:00 | SPY | ETF | 83.2 | 84.2 | 83.04 | 84.07 | 7679400.0 |
| 2002-10-14 10:00:00 | SPY | ETF | 84.04 | 84.15 | 83.61 | 84.05 | 4337700.0 |
| 2002-10-14 10:30:00 | SPY | ETF | 84.09 | 84.5 | 83.59 | 83.63 | 3716000.0 |
| 2002-10-14 11:00:00 | SPY | ETF | 83.63 | 84.18 | 83.58 | 83.99 | 2409700.0 |
| 2002-10-14 11:30:00 | SPY | ETF | 83.97 | 84.4 | 83.77 | 84.27 | 1879500.0 |
| 2002-10-14 12:00:00 | SPY | ETF | 84.29 | 84.82 | 84.0 | 84.79 | 2112000.0 |
| 2002-10-14 12:30:00 | SPY | ETF | 84.8 | 84.85 | 84.31 | 84.47 | 1938200.0 |
| 2002-10-14 13:00:00 | SPY | ETF | 84.47 | 84.6 | 84.21 | 84.35 | 1086200.0 |
| 2002-10-14 13:30:00 | SPY | ETF | 84.41 | 84.6 | 84.08 | 84.37 | 2071000.0 |
| 2002-10-14 14:00:00 | SPY | ETF | 84.35 | 84.64 | 84.23 | 84.23 | 1552500.0 |
| 2002-10-14 14:30:00 | SPY | ETF | 84.2 | 84.3 | 83.82 | 83.89 | 2477400.0 |
| 2002-10-14 15:00:00 | SPY | ETF | 83.9 | 84.55 | 83.85 | 84.2 | 2774200.0 |
| 2002-10-14 15:30:00 | SPY | ETF | 84.13 | 84.55 | 84.09 | 84.5 | 2849300.0 |
| 2002-10-14 16:00:00 | SPY | ETF | 84.48 | 84.68 | 84.4 | 84.64 | 2429600.0 |
| 2002-10-14 16:30:00 | SPY | ETF | 84.65 | 84.69 | 84.53 | 84.55 | 24200.0 |
| 2002-10-14 17:00:00 | SPY | ETF | 84.57 | 84.62 | 84.5 | 84.56 | 17000.0 |
| 2002-10-14 17:30:00 | SPY | ETF | 84.53 | 84.65 | 84.52 | 84.57 | 3500.0 |
| 2002-10-14 18:00:00 | SPY | ETF | 84.62 | 84.68 | 84.62 | 84.64 | 6400.0 |
| 2002-10-14 08:00:00 | QQQ | ETF | 21.87 | 21.87 | 21.86 | 21.87 | 6200.0 |
| 2002-10-14 09:00:00 | QQQ | ETF | 21.88 | 21.9 | 21.86 | 21.87 | 10600.0 |
| 2002-10-14 09:30:00 | QQQ | ETF | 21.87 | 22.25 | 21.78 | 22.16 | 11770200.0 |
| 2002-10-14 10:00:00 | QQQ | ETF | 22.15 | 22.22 | 21.96 | 22.08 | 8999200.0 |
| 2002-10-14 10:30:00 | QQQ | ETF | 22.09 | 22.2 | 21.94 | 21.94 | 6183300.0 |
| 2002-10-14 11:00:00 | QQQ | ETF | 21.95 | 22.21 | 21.92 | 22.16 | 5377800.0 |
| 2002-10-14 11:30:00 | QQQ | ETF | 22.18 | 22.28 | 22.06 | 22.23 | 4845600.0 |
| 2002-10-14 12:00:00 | QQQ | ETF | 22.24 | 22.48 | 22.16 | 22.45 | 8640500.0 |
| 2002-10-14 12:30:00 | QQQ | ETF | 22.45 | 22.48 | 22.27 | 22.31 | 7101600.0 |
| 2002-10-14 13:00:00 | QQQ | ETF | 22.29 | 22.38 | 22.24 | 22.31 | 2807100.0 |
| 2002-10-14 13:30:00 | QQQ | ETF | 22.32 | 22.34 | 22.16 | 22.25 | 3149300.0 |
| 2002-10-14 14:00:00 | QQQ | ETF | 22.26 | 22.34 | 22.21 | 22.25 | 2158600.0 |
| 2002-10-14 14:30:00 | QQQ | ETF | 22.24 | 22.27 | 22.14 | 22.16 | 3747800.0 |
| 2002-10-14 15:00:00 | QQQ | ETF | 22.18 | 22.39 | 22.15 | 22.28 | 4106900.0 |
| 2002-10-14 15:30:00 | QQQ | ETF | 22.29 | 22.42 | 22.24 | 22.42 | 4676300.0 |
| 2002-10-14 16:00:00 | QQQ | ETF | 22.42 | 22.55 | 22.35 | 22.5 | 3059200.0 |
| 2002-10-14 16:30:00 | QQQ | ETF | 22.48 | 22.58 | 22.48 | 22.49 | 270200.0 |
| 2002-10-14 17:00:00 | QQQ | ETF | 22.49 | 22.51 | 22.46 | 22.49 | 61000.0 |
| 2002-10-14 17:30:00 | QQQ | ETF | 22.48 | 22.49 | 22.44 | 22.47 | 86700.0 |
| 2002-10-14 18:00:00 | QQQ | ETF | 22.48 | 22.5 | 22.45 | 22.49 | 44700.0 |
| 2002-10-14 19:00:00 | QQQ | ETF | 22.5 | 22.5 | 22.5 | 22.5 | 1500.0 |
| 2002-10-14 19:30:00 | QQQ | ETF | 22.44 | 22.44 | 22.42 | 22.42 | 2100.0 |
| 2002-10-14 09:30:00 | IWM | ETF | 34.05 | 34.44 | 34.05 | 34.44 | 418200.0 |
| 2002-10-14 10:00:00 | IWM | ETF | 34.425 | 34.435 | 34.305 | 34.41 | 272000.0 |
| 2002-10-14 10:30:00 | IWM | ETF | 34.435 | 34.56 | 34.355 | 34.36 | 344000.0 |
| 2002-10-14 11:00:00 | IWM | ETF | 34.365 | 34.445 | 34.365 | 34.44 | 34800.0 |
| 2002-10-14 11:30:00 | IWM | ETF | 34.44 | 34.475 | 34.315 | 34.475 | 132400.0 |
| 2002-10-14 12:00:00 | IWM | ETF | 34.475 | 34.52 | 34.355 | 34.52 | 83000.0 |
| 2002-10-14 12:30:00 | IWM | ETF | 34.525 | 34.555 | 34.455 | 34.54 | 160000.0 |
> showing 50 of 578 rows — these rows as CSV