PREVIEW / etf_30min / 2002-07-26
file: by_date/etf_30min/2002/2002-07-26.parquet size: 18 KB rows: 496
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-07-26 09:30:00 | SPY | ETF | 84.65 | 85.2 | 83.81 | 85.1 | 8034300.0 |
| 2002-07-26 10:00:00 | SPY | ETF | 85.11 | 85.28 | 84.23 | 84.57 | 3993400.0 |
| 2002-07-26 10:30:00 | SPY | ETF | 84.56 | 85.09 | 84.05 | 84.64 | 2331000.0 |
| 2002-07-26 11:00:00 | SPY | ETF | 84.52 | 85.11 | 84.47 | 84.74 | 1707400.0 |
| 2002-07-26 11:30:00 | SPY | ETF | 84.77 | 85.0 | 84.46 | 84.46 | 1691000.0 |
| 2002-07-26 12:00:00 | SPY | ETF | 84.52 | 84.7 | 84.06 | 84.16 | 1325300.0 |
| 2002-07-26 12:30:00 | SPY | ETF | 84.17 | 84.48 | 83.9 | 84.36 | 1958100.0 |
| 2002-07-26 13:00:00 | SPY | ETF | 84.4 | 84.62 | 83.8 | 84.2 | 1877800.0 |
| 2002-07-26 13:30:00 | SPY | ETF | 84.3 | 84.65 | 84.1 | 84.28 | 2319600.0 |
| 2002-07-26 14:00:00 | SPY | ETF | 84.32 | 84.6 | 83.9 | 84.1 | 1418600.0 |
| 2002-07-26 14:30:00 | SPY | ETF | 84.11 | 84.53 | 83.96 | 84.43 | 1632300.0 |
| 2002-07-26 15:00:00 | SPY | ETF | 84.43 | 85.16 | 84.36 | 84.88 | 3457000.0 |
| 2002-07-26 15:30:00 | SPY | ETF | 84.87 | 85.69 | 84.73 | 85.6 | 5157200.0 |
| 2002-07-26 16:00:00 | SPY | ETF | 85.63 | 85.93 | 85.55 | 85.6 | 1815500.0 |
| 2002-07-26 09:30:00 | QQQ | ETF | 22.56 | 22.68 | 22.32 | 22.62 | 17753800.0 |
| 2002-07-26 10:00:00 | QQQ | ETF | 22.65 | 22.73 | 22.22 | 22.37 | 10773300.0 |
| 2002-07-26 10:30:00 | QQQ | ETF | 22.36 | 22.62 | 22.31 | 22.61 | 8566700.0 |
| 2002-07-26 11:00:00 | QQQ | ETF | 22.6 | 22.84 | 22.49 | 22.68 | 7327200.0 |
| 2002-07-26 11:30:00 | QQQ | ETF | 22.7 | 22.73 | 22.5 | 22.51 | 4569900.0 |
| 2002-07-26 12:00:00 | QQQ | ETF | 22.51 | 22.59 | 22.25 | 22.3 | 3284300.0 |
| 2002-07-26 12:30:00 | QQQ | ETF | 22.3 | 22.39 | 22.18 | 22.35 | 5091200.0 |
| 2002-07-26 13:00:00 | QQQ | ETF | 22.35 | 22.48 | 22.16 | 22.34 | 5075400.0 |
| 2002-07-26 13:30:00 | QQQ | ETF | 22.33 | 22.45 | 22.26 | 22.31 | 2764800.0 |
| 2002-07-26 14:00:00 | QQQ | ETF | 22.32 | 22.38 | 22.03 | 22.15 | 4772900.0 |
| 2002-07-26 14:30:00 | QQQ | ETF | 22.14 | 22.34 | 22.01 | 22.32 | 4042100.0 |
| 2002-07-26 15:00:00 | QQQ | ETF | 22.31 | 22.52 | 22.27 | 22.39 | 6681100.0 |
| 2002-07-26 15:30:00 | QQQ | ETF | 22.39 | 22.67 | 22.26 | 22.63 | 9114400.0 |
| 2002-07-26 16:00:00 | QQQ | ETF | 22.63 | 22.75 | 22.56 | 22.67 | 1244300.0 |
| 2002-07-26 09:30:00 | IWM | ETF | 37.975 | 38.025 | 37.75 | 38.025 | 448400.0 |
| 2002-07-26 10:00:00 | IWM | ETF | 38.1 | 38.26 | 37.8 | 37.86 | 205200.0 |
| 2002-07-26 10:30:00 | IWM | ETF | 37.915 | 38.04 | 37.75 | 37.755 | 100400.0 |
| 2002-07-26 11:00:00 | IWM | ETF | 37.835 | 38.005 | 37.8 | 37.895 | 162400.0 |
| 2002-07-26 11:30:00 | IWM | ETF | 37.955 | 37.99 | 37.85 | 37.85 | 64400.0 |
| 2002-07-26 12:00:00 | IWM | ETF | 37.845 | 37.87 | 37.73 | 37.73 | 57400.0 |
| 2002-07-26 12:30:00 | IWM | ETF | 37.72 | 37.72 | 37.6 | 37.63 | 188200.0 |
| 2002-07-26 13:00:00 | IWM | ETF | 37.705 | 37.825 | 37.55 | 37.675 | 168200.0 |
| 2002-07-26 13:30:00 | IWM | ETF | 37.58 | 37.655 | 37.57 | 37.57 | 25000.0 |
| 2002-07-26 14:00:00 | IWM | ETF | 37.575 | 37.695 | 37.325 | 37.425 | 142800.0 |
| 2002-07-26 14:30:00 | IWM | ETF | 37.51 | 37.54 | 37.425 | 37.54 | 118400.0 |
| 2002-07-26 15:00:00 | IWM | ETF | 37.55 | 37.72 | 37.545 | 37.72 | 310400.0 |
| 2002-07-26 15:30:00 | IWM | ETF | 37.695 | 38.13 | 37.625 | 38.035 | 328400.0 |
| 2002-07-26 16:00:00 | IWM | ETF | 38.05 | 38.3 | 38.05 | 38.3 | 5400.0 |
| 2002-07-26 09:30:00 | DIA | ETF | 82.55 | 82.8 | 81.45 | 82.71 | 1436100.0 |
| 2002-07-26 10:00:00 | DIA | ETF | 82.76 | 82.95 | 81.76 | 82.13 | 966100.0 |
| 2002-07-26 10:30:00 | DIA | ETF | 82.15 | 82.58 | 81.56 | 82.06 | 947000.0 |
| 2002-07-26 11:00:00 | DIA | ETF | 82.1 | 82.5 | 81.9 | 82.19 | 440400.0 |
| 2002-07-26 11:30:00 | DIA | ETF | 82.21 | 82.4 | 82.0 | 82.01 | 200900.0 |
| 2002-07-26 12:00:00 | DIA | ETF | 82.0 | 82.13 | 81.55 | 81.6 | 568900.0 |
| 2002-07-26 12:30:00 | DIA | ETF | 81.58 | 81.78 | 81.2 | 81.65 | 832700.0 |
| 2002-07-26 13:00:00 | DIA | ETF | 81.7 | 81.95 | 81.16 | 81.6 | 543300.0 |
> showing 50 of 496 rows — these rows as CSV