PREVIEW / etf_30min / 2002-01-23
file: by_date/etf_30min/2002/2002-01-23.parquet size: 18 KB rows: 463
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-01-23 09:30:00 | SPY | ETF | 112.63 | 112.67 | 112.37 | 112.42 | 1456500.0 |
| 2002-01-23 10:00:00 | SPY | ETF | 112.37 | 112.4 | 112.02 | 112.1 | 1240900.0 |
| 2002-01-23 10:30:00 | SPY | ETF | 112.1 | 112.75 | 112.08 | 112.74 | 1493300.0 |
| 2002-01-23 11:00:00 | SPY | ETF | 112.71 | 112.72 | 112.42 | 112.65 | 584400.0 |
| 2002-01-23 11:30:00 | SPY | ETF | 112.6 | 112.95 | 112.6 | 112.81 | 913900.0 |
| 2002-01-23 12:00:00 | SPY | ETF | 112.82 | 112.91 | 112.6 | 112.87 | 339200.0 |
| 2002-01-23 12:30:00 | SPY | ETF | 112.82 | 113.11 | 112.63 | 113.04 | 570200.0 |
| 2002-01-23 13:00:00 | SPY | ETF | 113.04 | 113.28 | 112.98 | 113.1 | 594300.0 |
| 2002-01-23 13:30:00 | SPY | ETF | 113.1 | 113.55 | 113.1 | 113.42 | 882400.0 |
| 2002-01-23 14:00:00 | SPY | ETF | 113.4 | 113.52 | 113.25 | 113.37 | 514200.0 |
| 2002-01-23 14:30:00 | SPY | ETF | 113.35 | 113.45 | 113.09 | 113.18 | 427100.0 |
| 2002-01-23 15:00:00 | SPY | ETF | 113.18 | 113.4 | 113.02 | 113.4 | 818200.0 |
| 2002-01-23 15:30:00 | SPY | ETF | 113.38 | 113.44 | 112.92 | 113.14 | 1034900.0 |
| 2002-01-23 16:00:00 | SPY | ETF | 113.18 | 113.23 | 113.05 | 113.05 | 1048400.0 |
| 2002-01-23 16:30:00 | SPY | ETF | 113.19 | 113.26 | 113.19 | 113.2 | 4200.0 |
| 2002-01-23 17:30:00 | SPY | ETF | 113.18 | 113.18 | 113.15 | 113.15 | 2200.0 |
| 2002-01-23 18:00:00 | SPY | ETF | 113.26 | 113.26 | 113.2 | 113.2 | 200.0 |
| 2002-01-23 09:30:00 | QQQ | ETF | 37.65 | 37.94 | 37.6 | 37.6 | 9082900.0 |
| 2002-01-23 10:00:00 | QQQ | ETF | 37.62 | 37.63 | 37.35 | 37.4 | 9608900.0 |
| 2002-01-23 10:30:00 | QQQ | ETF | 37.4 | 38.04 | 37.35 | 38.0 | 9255600.0 |
| 2002-01-23 11:00:00 | QQQ | ETF | 38.04 | 38.04 | 37.79 | 37.95 | 5081400.0 |
| 2002-01-23 11:30:00 | QQQ | ETF | 37.95 | 38.21 | 37.93 | 38.14 | 4983100.0 |
| 2002-01-23 12:00:00 | QQQ | ETF | 38.12 | 38.21 | 38.01 | 38.12 | 2955600.0 |
| 2002-01-23 12:30:00 | QQQ | ETF | 38.14 | 38.36 | 38.0 | 38.3 | 3959400.0 |
| 2002-01-23 13:00:00 | QQQ | ETF | 38.29 | 38.5 | 38.23 | 38.37 | 5647800.0 |
| 2002-01-23 13:30:00 | QQQ | ETF | 38.37 | 38.68 | 38.35 | 38.57 | 5352400.0 |
| 2002-01-23 14:00:00 | QQQ | ETF | 38.54 | 38.66 | 38.43 | 38.52 | 3091200.0 |
| 2002-01-23 14:30:00 | QQQ | ETF | 38.53 | 38.55 | 38.32 | 38.43 | 3845900.0 |
| 2002-01-23 15:00:00 | QQQ | ETF | 38.44 | 38.67 | 38.35 | 38.65 | 4447800.0 |
| 2002-01-23 15:30:00 | QQQ | ETF | 38.66 | 38.69 | 38.39 | 38.53 | 4235200.0 |
| 2002-01-23 16:00:00 | QQQ | ETF | 38.51 | 38.59 | 38.37 | 38.41 | 1007200.0 |
| 2002-01-23 16:30:00 | QQQ | ETF | 38.45 | 38.56 | 38.3 | 38.48 | 283100.0 |
| 2002-01-23 17:00:00 | QQQ | ETF | 38.49 | 38.5 | 38.34 | 38.36 | 371600.0 |
| 2002-01-23 17:30:00 | QQQ | ETF | 38.39 | 38.39 | 38.28 | 38.32 | 72300.0 |
| 2002-01-23 18:00:00 | QQQ | ETF | 38.3 | 38.44 | 38.3 | 38.44 | 16600.0 |
| 2002-01-23 09:30:00 | IWM | ETF | 46.825 | 46.905 | 46.785 | 46.785 | 20600.0 |
| 2002-01-23 10:00:00 | IWM | ETF | 46.79 | 46.79 | 46.4 | 46.48 | 196400.0 |
| 2002-01-23 10:30:00 | IWM | ETF | 46.495 | 46.75 | 46.475 | 46.75 | 142800.0 |
| 2002-01-23 11:00:00 | IWM | ETF | 46.71 | 46.775 | 46.665 | 46.69 | 277800.0 |
| 2002-01-23 11:30:00 | IWM | ETF | 46.725 | 46.85 | 46.685 | 46.85 | 24200.0 |
| 2002-01-23 12:00:00 | IWM | ETF | 46.775 | 46.85 | 46.755 | 46.775 | 8000.0 |
| 2002-01-23 12:30:00 | IWM | ETF | 46.95 | 46.95 | 46.8 | 46.945 | 87000.0 |
| 2002-01-23 13:00:00 | IWM | ETF | 46.955 | 47.065 | 46.925 | 47.0 | 101400.0 |
| 2002-01-23 13:30:00 | IWM | ETF | 46.995 | 47.29 | 46.995 | 47.275 | 48400.0 |
| 2002-01-23 14:00:00 | IWM | ETF | 47.175 | 47.3 | 47.175 | 47.275 | 149000.0 |
| 2002-01-23 14:30:00 | IWM | ETF | 47.275 | 47.275 | 47.125 | 47.205 | 93800.0 |
| 2002-01-23 15:00:00 | IWM | ETF | 47.215 | 47.395 | 47.16 | 47.395 | 41000.0 |
| 2002-01-23 15:30:00 | IWM | ETF | 47.35 | 47.425 | 47.25 | 47.315 | 329400.0 |
| 2002-01-23 16:00:00 | IWM | ETF | 47.35 | 47.39 | 47.295 | 47.3 | 223800.0 |
| 2002-01-23 16:30:00 | IWM | ETF | 46.775 | 46.775 | 46.775 | 46.775 | 216000.0 |
> showing 50 of 463 rows — these rows as CSV