PREVIEW / etf_30min / 2002-09-25
file: by_date/etf_30min/2002/2002-09-25.parquet size: 21 KB rows: 584
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-09-25 09:30:00 | SPY | ETF | 83.37 | 83.61 | 82.87 | 83.0 | 6146400.0 |
| 2002-09-25 10:00:00 | SPY | ETF | 83.01 | 83.1 | 82.58 | 82.97 | 4325900.0 |
| 2002-09-25 10:30:00 | SPY | ETF | 82.97 | 83.14 | 82.26 | 82.5 | 3080700.0 |
| 2002-09-25 11:00:00 | SPY | ETF | 82.52 | 82.8 | 82.04 | 82.66 | 4643100.0 |
| 2002-09-25 11:30:00 | SPY | ETF | 82.67 | 83.11 | 82.61 | 82.87 | 2980900.0 |
| 2002-09-25 12:00:00 | SPY | ETF | 82.86 | 83.2 | 82.83 | 83.2 | 1988300.0 |
| 2002-09-25 12:30:00 | SPY | ETF | 83.21 | 83.43 | 82.99 | 83.25 | 1846900.0 |
| 2002-09-25 13:00:00 | SPY | ETF | 83.26 | 83.94 | 83.04 | 83.93 | 5512000.0 |
| 2002-09-25 13:30:00 | SPY | ETF | 83.89 | 84.17 | 83.75 | 83.95 | 3564000.0 |
| 2002-09-25 14:00:00 | SPY | ETF | 83.95 | 84.56 | 83.88 | 84.43 | 4674600.0 |
| 2002-09-25 14:30:00 | SPY | ETF | 84.42 | 84.77 | 84.22 | 84.31 | 5559100.0 |
| 2002-09-25 15:00:00 | SPY | ETF | 84.3 | 84.65 | 84.0 | 84.47 | 4971300.0 |
| 2002-09-25 15:30:00 | SPY | ETF | 84.47 | 84.59 | 83.9 | 84.11 | 4011800.0 |
| 2002-09-25 16:00:00 | SPY | ETF | 84.12 | 84.53 | 84.05 | 84.35 | 1948600.0 |
| 2002-09-25 09:30:00 | QQQ | ETF | 21.35 | 21.49 | 21.23 | 21.3 | 13885400.0 |
| 2002-09-25 10:00:00 | QQQ | ETF | 21.3 | 21.41 | 21.14 | 21.35 | 8283200.0 |
| 2002-09-25 10:30:00 | QQQ | ETF | 21.35 | 21.42 | 21.16 | 21.25 | 5913800.0 |
| 2002-09-25 11:00:00 | QQQ | ETF | 21.24 | 21.38 | 21.1 | 21.29 | 8352500.0 |
| 2002-09-25 11:30:00 | QQQ | ETF | 21.28 | 21.46 | 21.27 | 21.35 | 8129900.0 |
| 2002-09-25 12:00:00 | QQQ | ETF | 21.36 | 21.51 | 21.35 | 21.5 | 4522000.0 |
| 2002-09-25 12:30:00 | QQQ | ETF | 21.5 | 21.59 | 21.45 | 21.54 | 4846800.0 |
| 2002-09-25 13:00:00 | QQQ | ETF | 21.53 | 21.8 | 21.48 | 21.79 | 7094600.0 |
| 2002-09-25 13:30:00 | QQQ | ETF | 21.79 | 21.9 | 21.66 | 21.8 | 7271600.0 |
| 2002-09-25 14:00:00 | QQQ | ETF | 21.79 | 22.0 | 21.75 | 21.89 | 7198400.0 |
| 2002-09-25 14:30:00 | QQQ | ETF | 21.9 | 21.99 | 21.81 | 21.86 | 4588100.0 |
| 2002-09-25 15:00:00 | QQQ | ETF | 21.86 | 22.04 | 21.76 | 21.99 | 6681800.0 |
| 2002-09-25 15:30:00 | QQQ | ETF | 21.98 | 22.02 | 21.77 | 21.87 | 6733900.0 |
| 2002-09-25 16:00:00 | QQQ | ETF | 21.88 | 21.9 | 21.82 | 21.87 | 1027900.0 |
| 2002-09-25 09:30:00 | IWM | ETF | 35.625 | 35.91 | 35.605 | 35.785 | 293600.0 |
| 2002-09-25 10:00:00 | IWM | ETF | 35.7 | 35.87 | 35.615 | 35.87 | 289800.0 |
| 2002-09-25 10:30:00 | IWM | ETF | 35.87 | 35.87 | 35.655 | 35.71 | 126000.0 |
| 2002-09-25 11:00:00 | IWM | ETF | 35.64 | 35.68 | 35.495 | 35.665 | 183400.0 |
| 2002-09-25 11:30:00 | IWM | ETF | 35.695 | 35.755 | 35.65 | 35.725 | 244200.0 |
| 2002-09-25 12:00:00 | IWM | ETF | 35.725 | 35.775 | 35.685 | 35.72 | 67200.0 |
| 2002-09-25 12:30:00 | IWM | ETF | 35.775 | 35.91 | 35.775 | 35.9 | 103000.0 |
| 2002-09-25 13:00:00 | IWM | ETF | 35.9 | 36.18 | 35.875 | 36.18 | 127000.0 |
| 2002-09-25 13:30:00 | IWM | ETF | 36.165 | 36.255 | 36.14 | 36.21 | 74400.0 |
| 2002-09-25 14:00:00 | IWM | ETF | 36.21 | 36.37 | 36.19 | 36.315 | 174600.0 |
| 2002-09-25 14:30:00 | IWM | ETF | 36.315 | 36.395 | 36.22 | 36.275 | 197400.0 |
| 2002-09-25 15:00:00 | IWM | ETF | 36.265 | 36.32 | 36.165 | 36.245 | 286800.0 |
| 2002-09-25 15:30:00 | IWM | ETF | 36.25 | 36.345 | 36.12 | 36.345 | 152800.0 |
| 2002-09-25 16:00:00 | IWM | ETF | 36.4 | 36.45 | 36.36 | 36.45 | 272400.0 |
| 2002-09-25 09:30:00 | DIA | ETF | 78.05 | 78.38 | 77.6 | 77.77 | 1504400.0 |
| 2002-09-25 10:00:00 | DIA | ETF | 77.7 | 77.78 | 77.35 | 77.66 | 1053500.0 |
| 2002-09-25 10:30:00 | DIA | ETF | 77.69 | 77.81 | 76.95 | 77.19 | 1183700.0 |
| 2002-09-25 11:00:00 | DIA | ETF | 77.16 | 77.45 | 76.69 | 77.35 | 1128900.0 |
| 2002-09-25 11:30:00 | DIA | ETF | 77.35 | 77.75 | 77.27 | 77.62 | 893800.0 |
| 2002-09-25 12:00:00 | DIA | ETF | 77.62 | 77.85 | 77.56 | 77.75 | 551800.0 |
| 2002-09-25 12:30:00 | DIA | ETF | 77.8 | 78.0 | 77.55 | 77.82 | 499800.0 |
| 2002-09-25 13:00:00 | DIA | ETF | 77.81 | 78.36 | 77.67 | 78.36 | 602100.0 |
> showing 50 of 584 rows — these rows as CSV