PREVIEW / etf_30min / 2002-09-03
file: by_date/etf_30min/2002/2002-09-03.parquet size: 20 KB rows: 566
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-03 09:30:00 | SPY | ETF | 90.73 | 90.79 | 89.98 | 90.07 | 7726100.0 |
| 2002-09-03 10:00:00 | SPY | ETF | 90.06 | 90.09 | 89.04 | 89.15 | 7128000.0 |
| 2002-09-03 10:30:00 | SPY | ETF | 89.25 | 89.45 | 88.9 | 89.03 | 4339500.0 |
| 2002-09-03 11:00:00 | SPY | ETF | 89.1 | 89.44 | 88.8 | 89.2 | 3087400.0 |
| 2002-09-03 11:30:00 | SPY | ETF | 89.18 | 89.37 | 88.83 | 89.03 | 1478500.0 |
| 2002-09-03 12:00:00 | SPY | ETF | 89.05 | 89.21 | 88.78 | 89.13 | 1574900.0 |
| 2002-09-03 12:30:00 | SPY | ETF | 89.08 | 89.55 | 89.03 | 89.43 | 2439400.0 |
| 2002-09-03 13:00:00 | SPY | ETF | 89.43 | 89.5 | 89.12 | 89.24 | 1042300.0 |
| 2002-09-03 13:30:00 | SPY | ETF | 89.25 | 89.61 | 89.07 | 89.28 | 3108800.0 |
| 2002-09-03 14:00:00 | SPY | ETF | 89.28 | 89.32 | 88.75 | 89.04 | 3054700.0 |
| 2002-09-03 14:30:00 | SPY | ETF | 89.02 | 89.4 | 88.85 | 88.9 | 1443800.0 |
| 2002-09-03 15:00:00 | SPY | ETF | 88.93 | 88.96 | 88.55 | 88.61 | 3077900.0 |
| 2002-09-03 15:30:00 | SPY | ETF | 88.6 | 88.66 | 88.16 | 88.21 | 5690900.0 |
| 2002-09-03 16:00:00 | SPY | ETF | 88.19 | 88.32 | 88.16 | 88.28 | 1533600.0 |
| 2002-09-03 09:30:00 | QQQ | ETF | 23.06 | 23.08 | 22.81 | 22.82 | 15469500.0 |
| 2002-09-03 10:00:00 | QQQ | ETF | 22.82 | 22.87 | 22.52 | 22.63 | 13888600.0 |
| 2002-09-03 10:30:00 | QQQ | ETF | 22.64 | 22.73 | 22.52 | 22.56 | 5824400.0 |
| 2002-09-03 11:00:00 | QQQ | ETF | 22.56 | 22.74 | 22.5 | 22.65 | 6062400.0 |
| 2002-09-03 11:30:00 | QQQ | ETF | 22.65 | 22.72 | 22.47 | 22.58 | 5097800.0 |
| 2002-09-03 12:00:00 | QQQ | ETF | 22.58 | 22.63 | 22.46 | 22.6 | 3336500.0 |
| 2002-09-03 12:30:00 | QQQ | ETF | 22.6 | 22.68 | 22.55 | 22.64 | 2367500.0 |
| 2002-09-03 13:00:00 | QQQ | ETF | 22.64 | 22.65 | 22.53 | 22.55 | 1807200.0 |
| 2002-09-03 13:30:00 | QQQ | ETF | 22.54 | 22.68 | 22.51 | 22.6 | 3458800.0 |
| 2002-09-03 14:00:00 | QQQ | ETF | 22.6 | 22.64 | 22.45 | 22.49 | 4054100.0 |
| 2002-09-03 14:30:00 | QQQ | ETF | 22.5 | 22.64 | 22.47 | 22.52 | 3572400.0 |
| 2002-09-03 15:00:00 | QQQ | ETF | 22.52 | 22.55 | 22.42 | 22.47 | 4362100.0 |
| 2002-09-03 15:30:00 | QQQ | ETF | 22.47 | 22.49 | 22.34 | 22.39 | 7794400.0 |
| 2002-09-03 16:00:00 | QQQ | ETF | 22.39 | 22.7 | 22.37 | 22.67 | 1886800.0 |
| 2002-09-03 16:30:00 | QQQ | ETF | 22.67 | 22.67 | 22.64 | 22.64 | 260000.0 |
| 2002-09-03 09:30:00 | IWM | ETF | 38.325 | 38.65 | 38.325 | 38.375 | 984200.0 |
| 2002-09-03 10:00:00 | IWM | ETF | 38.375 | 38.4 | 37.985 | 38.1 | 629000.0 |
| 2002-09-03 10:30:00 | IWM | ETF | 37.945 | 38.125 | 37.905 | 38.02 | 258400.0 |
| 2002-09-03 11:00:00 | IWM | ETF | 38.02 | 38.22 | 37.925 | 38.075 | 132200.0 |
| 2002-09-03 11:30:00 | IWM | ETF | 38.185 | 38.185 | 37.875 | 37.92 | 192200.0 |
| 2002-09-03 12:00:00 | IWM | ETF | 38.05 | 38.05 | 37.885 | 38.0 | 43200.0 |
| 2002-09-03 12:30:00 | IWM | ETF | 38.0 | 38.165 | 38.0 | 38.1 | 43600.0 |
| 2002-09-03 13:00:00 | IWM | ETF | 38.115 | 38.225 | 38.055 | 38.125 | 11600.0 |
| 2002-09-03 13:30:00 | IWM | ETF | 38.13 | 38.28 | 38.125 | 38.175 | 21000.0 |
| 2002-09-03 14:00:00 | IWM | ETF | 38.185 | 38.24 | 37.915 | 37.95 | 225200.0 |
| 2002-09-03 14:30:00 | IWM | ETF | 37.935 | 38.11 | 37.935 | 37.94 | 174200.0 |
| 2002-09-03 15:00:00 | IWM | ETF | 37.945 | 37.99 | 37.775 | 37.795 | 214400.0 |
| 2002-09-03 15:30:00 | IWM | ETF | 37.785 | 37.835 | 37.58 | 37.835 | 429800.0 |
| 2002-09-03 16:00:00 | IWM | ETF | 37.825 | 37.875 | 37.825 | 37.875 | 156600.0 |
| 2002-09-03 09:30:00 | DIA | ETF | 85.52 | 85.65 | 85.01 | 85.06 | 1573100.0 |
| 2002-09-03 10:00:00 | DIA | ETF | 85.06 | 85.14 | 84.12 | 84.24 | 1714500.0 |
| 2002-09-03 10:30:00 | DIA | ETF | 84.28 | 84.5 | 83.9 | 84.06 | 993700.0 |
| 2002-09-03 11:00:00 | DIA | ETF | 84.0 | 84.4 | 83.75 | 84.1 | 885500.0 |
| 2002-09-03 11:30:00 | DIA | ETF | 84.13 | 84.3 | 83.79 | 83.92 | 704300.0 |
| 2002-09-03 12:00:00 | DIA | ETF | 83.94 | 84.15 | 83.77 | 84.01 | 416400.0 |
| 2002-09-03 12:30:00 | DIA | ETF | 84.03 | 84.43 | 83.97 | 84.3 | 576200.0 |
> showing 50 of 566 rows — these rows as CSV