PREVIEW / etf_30min / 2002-09-26
file: by_date/etf_30min/2002/2002-09-26.parquet size: 20 KB rows: 577
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-26 09:30:00 | SPY | ETF | 85.02 | 85.46 | 84.45 | 85.25 | 7776400.0 |
| 2002-09-26 10:00:00 | SPY | ETF | 85.26 | 85.63 | 85.14 | 85.24 | 6717800.0 |
| 2002-09-26 10:30:00 | SPY | ETF | 85.25 | 85.35 | 84.9 | 85.18 | 2373900.0 |
| 2002-09-26 11:00:00 | SPY | ETF | 85.18 | 85.95 | 85.03 | 85.83 | 2609600.0 |
| 2002-09-26 11:30:00 | SPY | ETF | 85.83 | 85.9 | 85.42 | 85.49 | 3055000.0 |
| 2002-09-26 12:00:00 | SPY | ETF | 85.46 | 85.77 | 85.26 | 85.31 | 3234700.0 |
| 2002-09-26 12:30:00 | SPY | ETF | 85.31 | 85.42 | 84.97 | 85.08 | 3111900.0 |
| 2002-09-26 13:00:00 | SPY | ETF | 85.03 | 85.18 | 84.54 | 84.66 | 2745200.0 |
| 2002-09-26 13:30:00 | SPY | ETF | 84.64 | 84.97 | 84.5 | 84.82 | 3509200.0 |
| 2002-09-26 14:00:00 | SPY | ETF | 84.85 | 85.09 | 84.54 | 84.97 | 2908800.0 |
| 2002-09-26 14:30:00 | SPY | ETF | 84.99 | 85.38 | 84.93 | 85.26 | 2504000.0 |
| 2002-09-26 15:00:00 | SPY | ETF | 85.26 | 85.91 | 85.23 | 85.49 | 4188800.0 |
| 2002-09-26 15:30:00 | SPY | ETF | 85.48 | 85.86 | 85.3 | 85.86 | 3347500.0 |
| 2002-09-26 16:00:00 | SPY | ETF | 85.84 | 85.97 | 85.71 | 85.73 | 1876000.0 |
| 2002-09-26 09:30:00 | QQQ | ETF | 22.16 | 22.27 | 21.94 | 22.2 | 16472400.0 |
| 2002-09-26 10:00:00 | QQQ | ETF | 22.22 | 22.33 | 22.01 | 22.04 | 12087500.0 |
| 2002-09-26 10:30:00 | QQQ | ETF | 22.05 | 22.1 | 21.84 | 21.98 | 7714200.0 |
| 2002-09-26 11:00:00 | QQQ | ETF | 21.96 | 22.16 | 21.94 | 22.11 | 5356400.0 |
| 2002-09-26 11:30:00 | QQQ | ETF | 22.12 | 22.14 | 21.9 | 21.92 | 4002500.0 |
| 2002-09-26 12:00:00 | QQQ | ETF | 21.93 | 21.96 | 21.69 | 21.72 | 5901300.0 |
| 2002-09-26 12:30:00 | QQQ | ETF | 21.72 | 21.73 | 21.55 | 21.65 | 8083500.0 |
| 2002-09-26 13:00:00 | QQQ | ETF | 21.66 | 21.69 | 21.37 | 21.42 | 7687300.0 |
| 2002-09-26 13:30:00 | QQQ | ETF | 21.42 | 21.69 | 21.37 | 21.61 | 6269200.0 |
| 2002-09-26 14:00:00 | QQQ | ETF | 21.62 | 21.78 | 21.51 | 21.71 | 4151500.0 |
| 2002-09-26 14:30:00 | QQQ | ETF | 21.71 | 21.83 | 21.6 | 21.75 | 4091600.0 |
| 2002-09-26 15:00:00 | QQQ | ETF | 21.76 | 21.95 | 21.71 | 21.74 | 6050700.0 |
| 2002-09-26 15:30:00 | QQQ | ETF | 21.72 | 21.81 | 21.64 | 21.77 | 5642800.0 |
| 2002-09-26 16:00:00 | QQQ | ETF | 21.77 | 21.78 | 21.59 | 21.6 | 2226700.0 |
| 2002-09-26 09:30:00 | IWM | ETF | 36.7 | 36.73 | 36.46 | 36.68 | 1186600.0 |
| 2002-09-26 10:00:00 | IWM | ETF | 36.65 | 36.81 | 36.65 | 36.75 | 96000.0 |
| 2002-09-26 10:30:00 | IWM | ETF | 36.69 | 36.71 | 36.6 | 36.67 | 644200.0 |
| 2002-09-26 11:00:00 | IWM | ETF | 36.675 | 36.805 | 36.65 | 36.74 | 69600.0 |
| 2002-09-26 11:30:00 | IWM | ETF | 36.775 | 36.8 | 36.71 | 36.745 | 645000.0 |
| 2002-09-26 12:00:00 | IWM | ETF | 36.71 | 36.745 | 36.67 | 36.67 | 93000.0 |
| 2002-09-26 12:30:00 | IWM | ETF | 36.635 | 36.67 | 36.56 | 36.655 | 144800.0 |
| 2002-09-26 13:00:00 | IWM | ETF | 36.65 | 36.65 | 36.455 | 36.5 | 492400.0 |
| 2002-09-26 13:30:00 | IWM | ETF | 36.46 | 36.565 | 36.405 | 36.53 | 82600.0 |
| 2002-09-26 14:00:00 | IWM | ETF | 36.525 | 36.72 | 36.425 | 36.72 | 103800.0 |
| 2002-09-26 14:30:00 | IWM | ETF | 36.65 | 36.81 | 36.635 | 36.81 | 394800.0 |
| 2002-09-26 15:00:00 | IWM | ETF | 36.82 | 37.01 | 36.81 | 36.935 | 307000.0 |
| 2002-09-26 15:30:00 | IWM | ETF | 36.925 | 36.995 | 36.805 | 36.99 | 298200.0 |
| 2002-09-26 16:00:00 | IWM | ETF | 37.0 | 37.065 | 36.93 | 36.93 | 7200.0 |
| 2002-09-26 09:30:00 | DIA | ETF | 79.18 | 79.6 | 78.6 | 79.46 | 1343600.0 |
| 2002-09-26 10:00:00 | DIA | ETF | 79.45 | 79.8 | 79.31 | 79.45 | 947800.0 |
| 2002-09-26 10:30:00 | DIA | ETF | 79.45 | 79.55 | 79.1 | 79.38 | 803900.0 |
| 2002-09-26 11:00:00 | DIA | ETF | 79.37 | 80.1 | 79.29 | 80.0 | 876200.0 |
| 2002-09-26 11:30:00 | DIA | ETF | 79.98 | 80.02 | 79.52 | 79.65 | 850700.0 |
| 2002-09-26 12:00:00 | DIA | ETF | 79.63 | 79.93 | 79.5 | 79.54 | 541000.0 |
| 2002-09-26 12:30:00 | DIA | ETF | 79.53 | 79.6 | 79.2 | 79.34 | 713600.0 |
| 2002-09-26 13:00:00 | DIA | ETF | 79.38 | 79.46 | 78.9 | 78.99 | 571000.0 |
> showing 50 of 577 rows — these rows as CSV