PREVIEW / etf_30min / 2002-02-27
file: by_date/etf_30min/2002/2002-02-27.parquet size: 18 KB rows: 481
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-02-27 09:30:00 | SPY | ETF | 111.96 | 112.43 | 111.85 | 112.36 | 2611400.0 |
| 2002-02-27 10:00:00 | SPY | ETF | 112.35 | 112.4 | 111.87 | 111.95 | 2498100.0 |
| 2002-02-27 10:30:00 | SPY | ETF | 112.03 | 112.84 | 111.95 | 112.6 | 1869200.0 |
| 2002-02-27 11:00:00 | SPY | ETF | 112.62 | 112.8 | 112.39 | 112.64 | 1643200.0 |
| 2002-02-27 11:30:00 | SPY | ETF | 112.68 | 112.86 | 112.52 | 112.55 | 1130400.0 |
| 2002-02-27 12:00:00 | SPY | ETF | 112.58 | 112.74 | 112.45 | 112.63 | 543400.0 |
| 2002-02-27 12:30:00 | SPY | ETF | 112.63 | 112.8 | 112.46 | 112.57 | 484600.0 |
| 2002-02-27 13:00:00 | SPY | ETF | 112.6 | 112.75 | 112.51 | 112.51 | 593000.0 |
| 2002-02-27 13:30:00 | SPY | ETF | 112.57 | 112.63 | 111.7 | 111.86 | 2752200.0 |
| 2002-02-27 14:00:00 | SPY | ETF | 111.88 | 112.01 | 111.4 | 111.45 | 3047500.0 |
| 2002-02-27 14:30:00 | SPY | ETF | 111.47 | 111.58 | 110.9 | 110.97 | 3288800.0 |
| 2002-02-27 15:00:00 | SPY | ETF | 110.97 | 111.21 | 110.65 | 111.12 | 2401800.0 |
| 2002-02-27 15:30:00 | SPY | ETF | 111.18 | 111.62 | 111.06 | 111.58 | 2413900.0 |
| 2002-02-27 16:00:00 | SPY | ETF | 111.55 | 111.74 | 111.53 | 111.6 | 1704200.0 |
| 2002-02-27 16:30:00 | SPY | ETF | 111.32 | 111.73 | 111.32 | 111.73 | 533500.0 |
| 2002-02-27 09:30:00 | QQQ | ETF | 35.39 | 35.43 | 35.11 | 35.28 | 8238700.0 |
| 2002-02-27 10:00:00 | QQQ | ETF | 35.29 | 35.44 | 35.02 | 35.08 | 8057600.0 |
| 2002-02-27 10:30:00 | QQQ | ETF | 35.08 | 35.51 | 35.07 | 35.38 | 7500300.0 |
| 2002-02-27 11:00:00 | QQQ | ETF | 35.38 | 35.46 | 35.25 | 35.4 | 3523300.0 |
| 2002-02-27 11:30:00 | QQQ | ETF | 35.4 | 35.49 | 35.24 | 35.26 | 3315100.0 |
| 2002-02-27 12:00:00 | QQQ | ETF | 35.26 | 35.35 | 35.15 | 35.24 | 3738300.0 |
| 2002-02-27 12:30:00 | QQQ | ETF | 35.24 | 35.39 | 35.15 | 35.28 | 3635500.0 |
| 2002-02-27 13:00:00 | QQQ | ETF | 35.28 | 35.44 | 35.23 | 35.3 | 2134000.0 |
| 2002-02-27 13:30:00 | QQQ | ETF | 35.31 | 35.35 | 34.59 | 34.72 | 11238800.0 |
| 2002-02-27 14:00:00 | QQQ | ETF | 34.72 | 34.85 | 34.31 | 34.36 | 12725700.0 |
| 2002-02-27 14:30:00 | QQQ | ETF | 34.37 | 34.49 | 34.17 | 34.25 | 10614500.0 |
| 2002-02-27 15:00:00 | QQQ | ETF | 34.25 | 34.35 | 34.06 | 34.3 | 7874400.0 |
| 2002-02-27 15:30:00 | QQQ | ETF | 34.33 | 34.48 | 34.2 | 34.34 | 7749600.0 |
| 2002-02-27 16:00:00 | QQQ | ETF | 34.33 | 34.44 | 34.3 | 34.38 | 2792300.0 |
| 2002-02-27 16:30:00 | QQQ | ETF | 34.52 | 34.52 | 34.38 | 34.43 | 51000.0 |
| 2002-02-27 17:00:00 | QQQ | ETF | 34.43 | 34.44 | 34.38 | 34.42 | 35400.0 |
| 2002-02-27 17:30:00 | QQQ | ETF | 34.43 | 34.44 | 34.4 | 34.42 | 12400.0 |
| 2002-02-27 18:00:00 | QQQ | ETF | 34.44 | 34.45 | 34.4 | 34.44 | 16900.0 |
| 2002-02-27 09:30:00 | IWM | ETF | 47.125 | 47.245 | 47.005 | 47.2 | 108400.0 |
| 2002-02-27 10:00:00 | IWM | ETF | 47.195 | 47.21 | 46.985 | 46.995 | 59200.0 |
| 2002-02-27 10:30:00 | IWM | ETF | 47.085 | 47.245 | 47.085 | 47.245 | 71600.0 |
| 2002-02-27 11:00:00 | IWM | ETF | 47.235 | 47.24 | 47.145 | 47.145 | 51600.0 |
| 2002-02-27 11:30:00 | IWM | ETF | 47.235 | 47.255 | 47.235 | 47.255 | 8800.0 |
| 2002-02-27 12:00:00 | IWM | ETF | 47.175 | 47.245 | 47.175 | 47.245 | 20000.0 |
| 2002-02-27 12:30:00 | IWM | ETF | 47.215 | 47.255 | 47.2 | 47.2 | 81000.0 |
| 2002-02-27 13:00:00 | IWM | ETF | 47.245 | 47.295 | 47.23 | 47.29 | 47800.0 |
| 2002-02-27 13:30:00 | IWM | ETF | 47.27 | 47.29 | 47.125 | 47.135 | 150400.0 |
| 2002-02-27 14:00:00 | IWM | ETF | 47.135 | 47.175 | 47.015 | 47.025 | 46400.0 |
| 2002-02-27 14:30:00 | IWM | ETF | 47.015 | 47.085 | 46.9 | 46.965 | 247800.0 |
| 2002-02-27 15:00:00 | IWM | ETF | 46.89 | 46.965 | 46.815 | 46.965 | 96000.0 |
| 2002-02-27 15:30:00 | IWM | ETF | 46.965 | 47.075 | 46.905 | 47.065 | 147800.0 |
| 2002-02-27 16:00:00 | IWM | ETF | 47.075 | 47.1 | 46.575 | 46.575 | 32800.0 |
| 2002-02-27 09:30:00 | DIA | ETF | 101.9 | 102.24 | 101.7 | 102.24 | 740700.0 |
| 2002-02-27 10:00:00 | DIA | ETF | 102.18 | 102.25 | 101.74 | 101.86 | 720900.0 |
| 2002-02-27 10:30:00 | DIA | ETF | 101.86 | 102.7 | 101.86 | 102.55 | 946700.0 |
> showing 50 of 481 rows — these rows as CSV