PREVIEW / etf_30min / 2002-04-12
file: by_date/etf_30min/2002/2002-04-12.parquet size: 18 KB rows: 467
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-04-12 09:30:00 | SPY | ETF | 111.02 | 111.25 | 110.66 | 111.15 | 2292600.0 |
| 2002-04-12 10:00:00 | SPY | ETF | 111.22 | 111.58 | 111.1 | 111.3 | 1697200.0 |
| 2002-04-12 10:30:00 | SPY | ETF | 111.3 | 111.38 | 111.13 | 111.22 | 664000.0 |
| 2002-04-12 11:00:00 | SPY | ETF | 111.21 | 111.31 | 110.7 | 110.79 | 1332500.0 |
| 2002-04-12 11:30:00 | SPY | ETF | 110.81 | 110.89 | 110.57 | 110.85 | 960200.0 |
| 2002-04-12 12:00:00 | SPY | ETF | 110.85 | 111.22 | 110.85 | 111.1 | 981900.0 |
| 2002-04-12 12:30:00 | SPY | ETF | 111.08 | 111.38 | 111.07 | 111.24 | 684000.0 |
| 2002-04-12 13:00:00 | SPY | ETF | 111.26 | 111.45 | 111.05 | 111.07 | 857900.0 |
| 2002-04-12 13:30:00 | SPY | ETF | 111.08 | 111.18 | 110.97 | 111.09 | 528600.0 |
| 2002-04-12 14:00:00 | SPY | ETF | 111.09 | 111.65 | 111.07 | 111.5 | 752600.0 |
| 2002-04-12 14:30:00 | SPY | ETF | 111.49 | 111.63 | 111.26 | 111.35 | 697500.0 |
| 2002-04-12 15:00:00 | SPY | ETF | 111.33 | 111.48 | 111.03 | 111.3 | 895900.0 |
| 2002-04-12 15:30:00 | SPY | ETF | 111.3 | 111.62 | 111.23 | 111.33 | 816400.0 |
| 2002-04-12 16:00:00 | SPY | ETF | 111.32 | 111.46 | 111.25 | 111.43 | 922500.0 |
| 2002-04-12 16:30:00 | SPY | ETF | 111.43 | 111.43 | 111.43 | 111.43 | 400.0 |
| 2002-04-12 09:30:00 | QQQ | ETF | 33.32 | 33.38 | 32.95 | 33.35 | 15514800.0 |
| 2002-04-12 10:00:00 | QQQ | ETF | 33.36 | 33.57 | 33.28 | 33.43 | 8744400.0 |
| 2002-04-12 10:30:00 | QQQ | ETF | 33.43 | 33.48 | 33.28 | 33.35 | 5544900.0 |
| 2002-04-12 11:00:00 | QQQ | ETF | 33.36 | 33.4 | 32.99 | 33.05 | 8710400.0 |
| 2002-04-12 11:30:00 | QQQ | ETF | 33.05 | 33.22 | 33.0 | 33.2 | 4128800.0 |
| 2002-04-12 12:00:00 | QQQ | ETF | 33.18 | 33.42 | 33.18 | 33.28 | 5889600.0 |
| 2002-04-12 12:30:00 | QQQ | ETF | 33.28 | 33.45 | 33.26 | 33.37 | 2073200.0 |
| 2002-04-12 13:00:00 | QQQ | ETF | 33.37 | 33.48 | 33.26 | 33.27 | 1649500.0 |
| 2002-04-12 13:30:00 | QQQ | ETF | 33.27 | 33.39 | 33.2 | 33.34 | 1527700.0 |
| 2002-04-12 14:00:00 | QQQ | ETF | 33.34 | 33.68 | 33.34 | 33.63 | 5041300.0 |
| 2002-04-12 14:30:00 | QQQ | ETF | 33.63 | 33.8 | 33.55 | 33.59 | 4697000.0 |
| 2002-04-12 15:00:00 | QQQ | ETF | 33.59 | 33.7 | 33.4 | 33.52 | 5080400.0 |
| 2002-04-12 15:30:00 | QQQ | ETF | 33.5 | 33.7 | 33.48 | 33.62 | 4636100.0 |
| 2002-04-12 16:00:00 | QQQ | ETF | 33.58 | 33.64 | 33.52 | 33.55 | 1481500.0 |
| 2002-04-12 16:30:00 | QQQ | ETF | 33.54 | 33.56 | 33.51 | 33.54 | 47600.0 |
| 2002-04-12 17:00:00 | QQQ | ETF | 33.54 | 33.6 | 33.5 | 33.51 | 28700.0 |
| 2002-04-12 17:30:00 | QQQ | ETF | 33.51 | 33.55 | 33.5 | 33.55 | 7700.0 |
| 2002-04-12 18:00:00 | QQQ | ETF | 33.53 | 33.56 | 33.53 | 33.55 | 2200.0 |
| 2002-04-12 09:30:00 | IWM | ETF | 50.5 | 50.52 | 50.125 | 50.385 | 214400.0 |
| 2002-04-12 10:00:00 | IWM | ETF | 50.385 | 50.52 | 50.385 | 50.44 | 48400.0 |
| 2002-04-12 10:30:00 | IWM | ETF | 50.51 | 50.51 | 50.36 | 50.36 | 81000.0 |
| 2002-04-12 11:00:00 | IWM | ETF | 50.385 | 50.385 | 50.25 | 50.25 | 84000.0 |
| 2002-04-12 11:30:00 | IWM | ETF | 50.245 | 50.25 | 50.15 | 50.245 | 424400.0 |
| 2002-04-12 12:00:00 | IWM | ETF | 50.25 | 50.45 | 50.245 | 50.355 | 96000.0 |
| 2002-04-12 12:30:00 | IWM | ETF | 50.435 | 50.575 | 50.405 | 50.575 | 32800.0 |
| 2002-04-12 13:00:00 | IWM | ETF | 50.575 | 50.68 | 50.555 | 50.585 | 41800.0 |
| 2002-04-12 13:30:00 | IWM | ETF | 50.585 | 50.665 | 50.565 | 50.575 | 73200.0 |
| 2002-04-12 14:00:00 | IWM | ETF | 50.565 | 50.955 | 50.565 | 50.945 | 48800.0 |
| 2002-04-12 14:30:00 | IWM | ETF | 50.93 | 51.01 | 50.8 | 50.845 | 100800.0 |
| 2002-04-12 15:00:00 | IWM | ETF | 50.81 | 51.04 | 50.8 | 50.885 | 1334800.0 |
| 2002-04-12 15:30:00 | IWM | ETF | 50.925 | 51.235 | 50.91 | 51.15 | 233000.0 |
| 2002-04-12 16:00:00 | IWM | ETF | 51.175 | 51.35 | 51.175 | 51.35 | 23200.0 |
| 2002-04-12 09:30:00 | DIA | ETF | 102.4 | 102.42 | 101.76 | 102.08 | 2067700.0 |
| 2002-04-12 10:00:00 | DIA | ETF | 102.14 | 102.53 | 102.09 | 102.21 | 510500.0 |
| 2002-04-12 10:30:00 | DIA | ETF | 102.22 | 102.32 | 102.09 | 102.12 | 143400.0 |
> showing 50 of 467 rows — these rows as CSV