PREVIEW / etf_30min / 2002-08-02
file: by_date/etf_30min/2002/2002-08-02.parquet size: 20 KB rows: 576
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-08-02 09:30:00 | SPY | ETF | 88.5 | 88.91 | 88.1 | 88.46 | 5773400.0 |
| 2002-08-02 10:00:00 | SPY | ETF | 88.46 | 88.8 | 87.93 | 88.06 | 4692500.0 |
| 2002-08-02 10:30:00 | SPY | ETF | 88.01 | 88.35 | 87.5 | 87.82 | 3302100.0 |
| 2002-08-02 11:00:00 | SPY | ETF | 87.81 | 87.87 | 87.37 | 87.49 | 3461300.0 |
| 2002-08-02 11:30:00 | SPY | ETF | 87.44 | 87.88 | 86.9 | 87.03 | 1942600.0 |
| 2002-08-02 12:00:00 | SPY | ETF | 87.0 | 87.03 | 86.43 | 86.65 | 3745100.0 |
| 2002-08-02 12:30:00 | SPY | ETF | 86.65 | 86.96 | 86.15 | 86.35 | 3444700.0 |
| 2002-08-02 13:00:00 | SPY | ETF | 86.2 | 87.21 | 86.2 | 86.64 | 3126000.0 |
| 2002-08-02 13:30:00 | SPY | ETF | 86.64 | 86.98 | 86.53 | 86.8 | 1822800.0 |
| 2002-08-02 14:00:00 | SPY | ETF | 86.81 | 86.9 | 86.21 | 86.25 | 2864200.0 |
| 2002-08-02 14:30:00 | SPY | ETF | 86.3 | 86.8 | 86.2 | 86.53 | 3240900.0 |
| 2002-08-02 15:00:00 | SPY | ETF | 86.51 | 86.52 | 85.62 | 86.05 | 5849500.0 |
| 2002-08-02 15:30:00 | SPY | ETF | 86.03 | 86.85 | 86.0 | 86.65 | 4910700.0 |
| 2002-08-02 16:00:00 | SPY | ETF | 86.61 | 86.88 | 86.49 | 86.79 | 1472400.0 |
| 2002-08-02 09:30:00 | QQQ | ETF | 22.78 | 22.84 | 22.47 | 22.63 | 9298200.0 |
| 2002-08-02 10:00:00 | QQQ | ETF | 22.63 | 22.74 | 22.52 | 22.54 | 9133000.0 |
| 2002-08-02 10:30:00 | QQQ | ETF | 22.55 | 22.61 | 22.27 | 22.35 | 7711700.0 |
| 2002-08-02 11:00:00 | QQQ | ETF | 22.36 | 22.4 | 22.16 | 22.22 | 8960600.0 |
| 2002-08-02 11:30:00 | QQQ | ETF | 22.2 | 22.35 | 22.04 | 22.09 | 5095400.0 |
| 2002-08-02 12:00:00 | QQQ | ETF | 22.09 | 22.1 | 21.94 | 22.0 | 6325000.0 |
| 2002-08-02 12:30:00 | QQQ | ETF | 22.01 | 22.1 | 21.91 | 21.94 | 3823400.0 |
| 2002-08-02 13:00:00 | QQQ | ETF | 21.94 | 22.26 | 21.9 | 22.07 | 4686800.0 |
| 2002-08-02 13:30:00 | QQQ | ETF | 22.07 | 22.19 | 22.01 | 22.1 | 2279700.0 |
| 2002-08-02 14:00:00 | QQQ | ETF | 22.09 | 22.14 | 21.93 | 21.95 | 3946400.0 |
| 2002-08-02 14:30:00 | QQQ | ETF | 21.95 | 22.17 | 21.93 | 22.1 | 3901200.0 |
| 2002-08-02 15:00:00 | QQQ | ETF | 22.06 | 22.09 | 21.82 | 21.97 | 8643100.0 |
| 2002-08-02 15:30:00 | QQQ | ETF | 21.97 | 22.25 | 21.95 | 22.19 | 7839700.0 |
| 2002-08-02 16:00:00 | QQQ | ETF | 22.21 | 22.27 | 22.15 | 22.25 | 929000.0 |
| 2002-08-02 09:30:00 | IWM | ETF | 38.625 | 38.675 | 38.465 | 38.6 | 148400.0 |
| 2002-08-02 10:00:00 | IWM | ETF | 38.47 | 38.65 | 38.43 | 38.43 | 113800.0 |
| 2002-08-02 10:30:00 | IWM | ETF | 38.435 | 38.49 | 37.91 | 38.0 | 252600.0 |
| 2002-08-02 11:00:00 | IWM | ETF | 38.05 | 38.1 | 37.9 | 37.915 | 124200.0 |
| 2002-08-02 11:30:00 | IWM | ETF | 37.935 | 38.01 | 37.84 | 37.905 | 81800.0 |
| 2002-08-02 12:00:00 | IWM | ETF | 37.82 | 37.825 | 37.59 | 37.59 | 91800.0 |
| 2002-08-02 12:30:00 | IWM | ETF | 37.69 | 37.85 | 37.54 | 37.54 | 111800.0 |
| 2002-08-02 13:00:00 | IWM | ETF | 37.6 | 37.75 | 37.55 | 37.615 | 731200.0 |
| 2002-08-02 13:30:00 | IWM | ETF | 37.61 | 37.695 | 37.59 | 37.675 | 249600.0 |
| 2002-08-02 14:00:00 | IWM | ETF | 37.675 | 37.675 | 37.54 | 37.555 | 83400.0 |
| 2002-08-02 14:30:00 | IWM | ETF | 37.555 | 37.66 | 37.555 | 37.59 | 162800.0 |
| 2002-08-02 15:00:00 | IWM | ETF | 37.56 | 37.59 | 37.43 | 37.59 | 53600.0 |
| 2002-08-02 15:30:00 | IWM | ETF | 37.57 | 37.75 | 37.51 | 37.75 | 349400.0 |
| 2002-08-02 16:00:00 | IWM | ETF | 37.675 | 37.7 | 37.485 | 37.485 | 97800.0 |
| 2002-08-02 09:30:00 | DIA | ETF | 84.7 | 85.07 | 84.47 | 84.95 | 999600.0 |
| 2002-08-02 10:00:00 | DIA | ETF | 84.91 | 85.15 | 84.22 | 84.42 | 1076800.0 |
| 2002-08-02 10:30:00 | DIA | ETF | 84.43 | 84.8 | 83.9 | 84.2 | 1227200.0 |
| 2002-08-02 11:00:00 | DIA | ETF | 84.21 | 84.3 | 83.8 | 83.86 | 754800.0 |
| 2002-08-02 11:30:00 | DIA | ETF | 83.88 | 84.37 | 83.45 | 83.59 | 1071800.0 |
| 2002-08-02 12:00:00 | DIA | ETF | 83.45 | 83.52 | 83.02 | 83.25 | 880900.0 |
| 2002-08-02 12:30:00 | DIA | ETF | 83.23 | 83.46 | 82.65 | 82.84 | 664100.0 |
| 2002-08-02 13:00:00 | DIA | ETF | 82.84 | 83.54 | 82.8 | 83.01 | 753400.0 |
> showing 50 of 576 rows — these rows as CSV