PREVIEW / etf_30min / 2003-03-20
file: by_date/etf_30min/2003/2003-03-20.parquet size: 23 KB rows: 656
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-03-20 08:00:00 | SPY | ETF | 87.87 | 87.87 | 87.56 | 87.61 | 89100.0 |
| 2003-03-20 08:30:00 | SPY | ETF | 87.62 | 87.75 | 87.37 | 87.37 | 46900.0 |
| 2003-03-20 09:00:00 | SPY | ETF | 87.33 | 87.44 | 87.31 | 87.34 | 31300.0 |
| 2003-03-20 09:30:00 | SPY | ETF | 87.33 | 87.63 | 86.91 | 87.17 | 6163000.0 |
| 2003-03-20 10:00:00 | SPY | ETF | 86.97 | 87.1 | 86.35 | 86.5 | 5831700.0 |
| 2003-03-20 10:30:00 | SPY | ETF | 86.5 | 87.4 | 86.44 | 87.29 | 6347100.0 |
| 2003-03-20 11:00:00 | SPY | ETF | 87.28 | 87.95 | 87.25 | 87.42 | 8641400.0 |
| 2003-03-20 11:30:00 | SPY | ETF | 87.43 | 87.55 | 87.21 | 87.54 | 2539700.0 |
| 2003-03-20 12:00:00 | SPY | ETF | 87.52 | 87.99 | 87.3 | 87.92 | 3270900.0 |
| 2003-03-20 12:30:00 | SPY | ETF | 87.9 | 88.06 | 87.54 | 87.62 | 2940200.0 |
| 2003-03-20 13:00:00 | SPY | ETF | 87.6 | 88.3 | 87.56 | 88.15 | 4505900.0 |
| 2003-03-20 13:30:00 | SPY | ETF | 88.14 | 88.59 | 88.14 | 88.33 | 5944800.0 |
| 2003-03-20 14:00:00 | SPY | ETF | 88.31 | 88.43 | 87.91 | 88.22 | 3532800.0 |
| 2003-03-20 14:30:00 | SPY | ETF | 88.22 | 88.29 | 87.8 | 87.8 | 2447600.0 |
| 2003-03-20 15:00:00 | SPY | ETF | 87.83 | 88.26 | 87.71 | 88.25 | 3119200.0 |
| 2003-03-20 15:30:00 | SPY | ETF | 88.26 | 88.39 | 88.03 | 88.13 | 4024200.0 |
| 2003-03-20 16:00:00 | SPY | ETF | 88.13 | 88.25 | 88.05 | 88.25 | 1679400.0 |
| 2003-03-20 16:30:00 | SPY | ETF | 88.26 | 88.26 | 88.01 | 88.05 | 251000.0 |
| 2003-03-20 17:00:00 | SPY | ETF | 88.07 | 88.1 | 88.0 | 88.05 | 59900.0 |
| 2003-03-20 17:30:00 | SPY | ETF | 88.05 | 88.3 | 88.05 | 88.16 | 100500.0 |
| 2003-03-20 18:00:00 | SPY | ETF | 88.16 | 88.17 | 88.05 | 88.1 | 85100.0 |
| 2003-03-20 18:30:00 | SPY | ETF | 88.15 | 88.33 | 88.15 | 88.22 | 21800.0 |
| 2003-03-20 19:00:00 | SPY | ETF | 88.22 | 88.33 | 88.2 | 88.2 | 2500.0 |
| 2003-03-20 19:30:00 | SPY | ETF | 88.2 | 88.2 | 88.14 | 88.14 | 2600.0 |
| 2003-03-20 08:00:00 | QQQ | ETF | 26.65 | 26.65 | 26.48 | 26.48 | 85400.0 |
| 2003-03-20 08:30:00 | QQQ | ETF | 26.49 | 26.59 | 26.46 | 26.49 | 91500.0 |
| 2003-03-20 09:00:00 | QQQ | ETF | 26.46 | 26.53 | 26.46 | 26.51 | 48500.0 |
| 2003-03-20 09:30:00 | QQQ | ETF | 26.54 | 26.58 | 26.32 | 26.35 | 8464500.0 |
| 2003-03-20 10:00:00 | QQQ | ETF | 26.35 | 26.42 | 26.17 | 26.23 | 9251300.0 |
| 2003-03-20 10:30:00 | QQQ | ETF | 26.25 | 26.59 | 26.2 | 26.52 | 6939700.0 |
| 2003-03-20 11:00:00 | QQQ | ETF | 26.54 | 26.78 | 26.52 | 26.6 | 8330500.0 |
| 2003-03-20 11:30:00 | QQQ | ETF | 26.57 | 26.63 | 26.48 | 26.61 | 2716900.0 |
| 2003-03-20 12:00:00 | QQQ | ETF | 26.61 | 26.8 | 26.52 | 26.76 | 3453000.0 |
| 2003-03-20 12:30:00 | QQQ | ETF | 26.77 | 26.97 | 26.73 | 26.75 | 4677000.0 |
| 2003-03-20 13:00:00 | QQQ | ETF | 26.75 | 27.0 | 26.7 | 26.96 | 5314900.0 |
| 2003-03-20 13:30:00 | QQQ | ETF | 26.96 | 27.14 | 26.95 | 27.0 | 7505700.0 |
| 2003-03-20 14:00:00 | QQQ | ETF | 27.0 | 27.05 | 26.86 | 26.96 | 4198800.0 |
| 2003-03-20 14:30:00 | QQQ | ETF | 26.98 | 26.98 | 26.8 | 26.82 | 6081000.0 |
| 2003-03-20 15:00:00 | QQQ | ETF | 26.82 | 26.96 | 26.72 | 26.92 | 6079300.0 |
| 2003-03-20 15:30:00 | QQQ | ETF | 26.95 | 27.03 | 26.83 | 26.83 | 5963000.0 |
| 2003-03-20 16:00:00 | QQQ | ETF | 26.87 | 27.1 | 26.79 | 26.79 | 2731000.0 |
| 2003-03-20 16:30:00 | QQQ | ETF | 26.79 | 26.87 | 26.77 | 26.86 | 161900.0 |
| 2003-03-20 17:00:00 | QQQ | ETF | 26.85 | 26.85 | 26.77 | 26.81 | 92800.0 |
| 2003-03-20 17:30:00 | QQQ | ETF | 26.79 | 26.86 | 26.78 | 26.8 | 191300.0 |
| 2003-03-20 18:00:00 | QQQ | ETF | 26.84 | 26.85 | 26.79 | 26.84 | 266600.0 |
| 2003-03-20 18:30:00 | QQQ | ETF | 26.84 | 26.86 | 26.84 | 26.86 | 29300.0 |
| 2003-03-20 19:00:00 | QQQ | ETF | 26.86 | 26.87 | 26.82 | 26.82 | 15700.0 |
| 2003-03-20 19:30:00 | QQQ | ETF | 26.86 | 26.87 | 26.82 | 26.87 | 2600.0 |
| 2003-03-20 08:30:00 | IWM | ETF | 36.6 | 36.6 | 36.6 | 36.6 | 5000.0 |
| 2003-03-20 09:30:00 | IWM | ETF | 36.55 | 36.55 | 36.2 | 36.2 | 336600.0 |
> showing 50 of 656 rows — these rows as CSV