PREVIEW / etf_30min / 2002-09-19
file: by_date/etf_30min/2002/2002-09-19.parquet size: 20 KB rows: 567
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-19 09:30:00 | SPY | ETF | 85.99 | 86.34 | 85.7 | 86.26 | 4524800.0 |
| 2002-09-19 10:00:00 | SPY | ETF | 86.24 | 86.74 | 85.94 | 86.12 | 3724500.0 |
| 2002-09-19 10:30:00 | SPY | ETF | 86.1 | 86.33 | 85.82 | 86.14 | 3262700.0 |
| 2002-09-19 11:00:00 | SPY | ETF | 86.2 | 86.4 | 85.86 | 85.96 | 2382500.0 |
| 2002-09-19 11:30:00 | SPY | ETF | 85.95 | 86.26 | 85.9 | 86.06 | 1353100.0 |
| 2002-09-19 12:00:00 | SPY | ETF | 86.11 | 86.5 | 86.02 | 86.45 | 3677200.0 |
| 2002-09-19 12:30:00 | SPY | ETF | 86.45 | 86.8 | 86.35 | 86.41 | 3390200.0 |
| 2002-09-19 13:00:00 | SPY | ETF | 86.43 | 86.45 | 86.01 | 86.11 | 1667400.0 |
| 2002-09-19 13:30:00 | SPY | ETF | 86.1 | 86.21 | 85.82 | 85.91 | 1803500.0 |
| 2002-09-19 14:00:00 | SPY | ETF | 85.9 | 86.2 | 85.62 | 86.14 | 3038200.0 |
| 2002-09-19 14:30:00 | SPY | ETF | 86.11 | 86.15 | 85.41 | 85.43 | 3287500.0 |
| 2002-09-19 15:00:00 | SPY | ETF | 85.45 | 85.68 | 85.14 | 85.53 | 5587600.0 |
| 2002-09-19 15:30:00 | SPY | ETF | 85.56 | 85.64 | 84.78 | 84.85 | 6002000.0 |
| 2002-09-19 16:00:00 | SPY | ETF | 84.85 | 84.95 | 84.7 | 84.7 | 1625500.0 |
| 2002-09-19 09:30:00 | QQQ | ETF | 21.7 | 21.92 | 21.7 | 21.89 | 9059300.0 |
| 2002-09-19 10:00:00 | QQQ | ETF | 21.88 | 22.08 | 21.82 | 21.88 | 9576100.0 |
| 2002-09-19 10:30:00 | QQQ | ETF | 21.9 | 22.04 | 21.8 | 21.99 | 6678800.0 |
| 2002-09-19 11:00:00 | QQQ | ETF | 22.0 | 22.13 | 21.87 | 21.92 | 4597400.0 |
| 2002-09-19 11:30:00 | QQQ | ETF | 21.92 | 22.04 | 21.81 | 21.86 | 3355000.0 |
| 2002-09-19 12:00:00 | QQQ | ETF | 21.86 | 22.02 | 21.82 | 21.99 | 4682500.0 |
| 2002-09-19 12:30:00 | QQQ | ETF | 22.0 | 22.09 | 21.95 | 21.97 | 4437900.0 |
| 2002-09-19 13:00:00 | QQQ | ETF | 21.98 | 21.99 | 21.79 | 21.84 | 2967300.0 |
| 2002-09-19 13:30:00 | QQQ | ETF | 21.83 | 21.89 | 21.74 | 21.79 | 4633800.0 |
| 2002-09-19 14:00:00 | QQQ | ETF | 21.79 | 21.93 | 21.73 | 21.88 | 5385900.0 |
| 2002-09-19 14:30:00 | QQQ | ETF | 21.88 | 21.9 | 21.61 | 21.67 | 6520400.0 |
| 2002-09-19 15:00:00 | QQQ | ETF | 21.67 | 21.74 | 21.55 | 21.65 | 7844100.0 |
| 2002-09-19 15:30:00 | QQQ | ETF | 21.66 | 21.79 | 21.56 | 21.6 | 8012900.0 |
| 2002-09-19 16:00:00 | QQQ | ETF | 21.57 | 21.62 | 21.55 | 21.58 | 1442900.0 |
| 2002-09-19 09:30:00 | IWM | ETF | 36.75 | 37.14 | 36.75 | 37.0 | 141400.0 |
| 2002-09-19 10:00:00 | IWM | ETF | 37.12 | 37.245 | 37.05 | 37.155 | 57000.0 |
| 2002-09-19 10:30:00 | IWM | ETF | 37.19 | 37.19 | 37.07 | 37.11 | 38600.0 |
| 2002-09-19 11:00:00 | IWM | ETF | 37.18 | 37.285 | 37.1 | 37.1 | 111600.0 |
| 2002-09-19 11:30:00 | IWM | ETF | 37.12 | 37.15 | 37.1 | 37.1 | 64800.0 |
| 2002-09-19 12:00:00 | IWM | ETF | 37.095 | 37.185 | 37.05 | 37.14 | 23800.0 |
| 2002-09-19 12:30:00 | IWM | ETF | 37.205 | 37.225 | 37.06 | 37.075 | 71200.0 |
| 2002-09-19 13:00:00 | IWM | ETF | 37.065 | 37.07 | 36.78 | 36.8 | 87800.0 |
| 2002-09-19 13:30:00 | IWM | ETF | 36.79 | 36.82 | 36.67 | 36.7 | 77800.0 |
| 2002-09-19 14:00:00 | IWM | ETF | 36.7 | 36.75 | 36.605 | 36.72 | 253800.0 |
| 2002-09-19 14:30:00 | IWM | ETF | 36.75 | 36.76 | 36.4 | 36.505 | 132800.0 |
| 2002-09-19 15:00:00 | IWM | ETF | 36.42 | 36.57 | 36.3 | 36.505 | 144200.0 |
| 2002-09-19 15:30:00 | IWM | ETF | 36.43 | 36.49 | 36.305 | 36.305 | 193000.0 |
| 2002-09-19 16:00:00 | IWM | ETF | 36.325 | 36.395 | 36.325 | 36.395 | 1200.0 |
| 2002-09-19 09:30:00 | DIA | ETF | 80.5 | 80.8 | 80.29 | 80.75 | 1151300.0 |
| 2002-09-19 10:00:00 | DIA | ETF | 80.7 | 81.2 | 80.59 | 80.74 | 1079400.0 |
| 2002-09-19 10:30:00 | DIA | ETF | 80.7 | 80.93 | 80.5 | 80.76 | 639700.0 |
| 2002-09-19 11:00:00 | DIA | ETF | 80.82 | 80.98 | 80.54 | 80.66 | 622400.0 |
| 2002-09-19 11:30:00 | DIA | ETF | 80.59 | 80.95 | 80.59 | 80.75 | 458800.0 |
| 2002-09-19 12:00:00 | DIA | ETF | 80.76 | 81.17 | 80.73 | 81.14 | 858800.0 |
| 2002-09-19 12:30:00 | DIA | ETF | 81.13 | 81.49 | 81.05 | 81.16 | 503500.0 |
| 2002-09-19 13:00:00 | DIA | ETF | 81.17 | 81.18 | 80.69 | 80.85 | 318500.0 |
> showing 50 of 567 rows — these rows as CSV