PREVIEW / etf_30min / 2002-05-02
file: by_date/etf_30min/2002/2002-05-02.parquet size: 18 KB rows: 495
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-05-02 09:30:00 | SPY | ETF | 109.1 | 109.5 | 108.76 | 109.25 | 2917100.0 |
| 2002-05-02 10:00:00 | SPY | ETF | 109.25 | 109.53 | 108.78 | 109.08 | 2379200.0 |
| 2002-05-02 10:30:00 | SPY | ETF | 109.01 | 109.26 | 108.88 | 109.15 | 1012200.0 |
| 2002-05-02 11:00:00 | SPY | ETF | 109.15 | 109.21 | 108.58 | 108.58 | 1264700.0 |
| 2002-05-02 11:30:00 | SPY | ETF | 108.58 | 108.99 | 108.53 | 108.89 | 735200.0 |
| 2002-05-02 12:00:00 | SPY | ETF | 108.86 | 108.95 | 108.58 | 108.81 | 528000.0 |
| 2002-05-02 12:30:00 | SPY | ETF | 108.79 | 108.83 | 108.56 | 108.58 | 611900.0 |
| 2002-05-02 13:00:00 | SPY | ETF | 108.59 | 108.92 | 108.57 | 108.72 | 391400.0 |
| 2002-05-02 13:30:00 | SPY | ETF | 108.76 | 109.08 | 108.7 | 108.92 | 739400.0 |
| 2002-05-02 14:00:00 | SPY | ETF | 108.93 | 108.95 | 108.56 | 108.56 | 807800.0 |
| 2002-05-02 14:30:00 | SPY | ETF | 108.58 | 108.77 | 108.36 | 108.7 | 982800.0 |
| 2002-05-02 15:00:00 | SPY | ETF | 108.73 | 108.74 | 108.2 | 108.39 | 935000.0 |
| 2002-05-02 15:30:00 | SPY | ETF | 108.39 | 109.0 | 108.31 | 108.8 | 1191400.0 |
| 2002-05-02 16:00:00 | SPY | ETF | 108.78 | 108.86 | 108.6 | 108.8 | 973500.0 |
| 2002-05-02 16:30:00 | SPY | ETF | 108.48 | 108.84 | 108.48 | 108.76 | 104100.0 |
| 2002-05-02 17:30:00 | SPY | ETF | 108.77 | 108.77 | 108.77 | 108.77 | 100.0 |
| 2002-05-02 18:00:00 | SPY | ETF | 108.9 | 109.0 | 108.9 | 109.0 | 400.0 |
| 2002-05-02 09:30:00 | QQQ | ETF | 31.39 | 31.92 | 31.25 | 31.72 | 10425400.0 |
| 2002-05-02 10:00:00 | QQQ | ETF | 31.72 | 31.99 | 31.42 | 31.47 | 9782400.0 |
| 2002-05-02 10:30:00 | QQQ | ETF | 31.47 | 31.56 | 31.29 | 31.46 | 6880900.0 |
| 2002-05-02 11:00:00 | QQQ | ETF | 31.46 | 31.53 | 31.08 | 31.09 | 5381800.0 |
| 2002-05-02 11:30:00 | QQQ | ETF | 31.08 | 31.24 | 31.05 | 31.16 | 4661300.0 |
| 2002-05-02 12:00:00 | QQQ | ETF | 31.19 | 31.2 | 30.9 | 31.01 | 4835700.0 |
| 2002-05-02 12:30:00 | QQQ | ETF | 31.01 | 31.03 | 30.71 | 30.72 | 5013300.0 |
| 2002-05-02 13:00:00 | QQQ | ETF | 30.77 | 30.94 | 30.68 | 30.74 | 3832900.0 |
| 2002-05-02 13:30:00 | QQQ | ETF | 30.75 | 31.06 | 30.74 | 30.94 | 4569300.0 |
| 2002-05-02 14:00:00 | QQQ | ETF | 30.96 | 31.1 | 30.74 | 30.75 | 5313200.0 |
| 2002-05-02 14:30:00 | QQQ | ETF | 30.75 | 30.86 | 30.61 | 30.83 | 6655600.0 |
| 2002-05-02 15:00:00 | QQQ | ETF | 30.84 | 30.85 | 30.46 | 30.5 | 7915100.0 |
| 2002-05-02 15:30:00 | QQQ | ETF | 30.52 | 30.8 | 30.46 | 30.58 | 7350600.0 |
| 2002-05-02 16:00:00 | QQQ | ETF | 30.53 | 30.6 | 30.47 | 30.51 | 1928000.0 |
| 2002-05-02 16:30:00 | QQQ | ETF | 30.5 | 30.55 | 30.49 | 30.53 | 155000.0 |
| 2002-05-02 17:00:00 | QQQ | ETF | 30.53 | 30.92 | 30.51 | 30.92 | 58200.0 |
| 2002-05-02 17:30:00 | QQQ | ETF | 30.53 | 30.55 | 30.5 | 30.52 | 14600.0 |
| 2002-05-02 18:00:00 | QQQ | ETF | 30.51 | 30.55 | 30.45 | 30.51 | 16300.0 |
| 2002-05-02 09:30:00 | IWM | ETF | 50.95 | 51.225 | 50.82 | 51.225 | 79000.0 |
| 2002-05-02 10:00:00 | IWM | ETF | 51.18 | 51.245 | 51.03 | 51.15 | 39800.0 |
| 2002-05-02 10:30:00 | IWM | ETF | 51.175 | 51.245 | 51.13 | 51.2 | 41400.0 |
| 2002-05-02 11:00:00 | IWM | ETF | 51.25 | 51.275 | 51.03 | 51.12 | 57600.0 |
| 2002-05-02 11:30:00 | IWM | ETF | 51.085 | 51.195 | 51.045 | 51.15 | 55200.0 |
| 2002-05-02 12:00:00 | IWM | ETF | 51.065 | 51.2 | 50.96 | 51.155 | 63200.0 |
| 2002-05-02 12:30:00 | IWM | ETF | 51.125 | 51.17 | 51.04 | 51.1 | 47000.0 |
| 2002-05-02 13:00:00 | IWM | ETF | 51.06 | 51.195 | 51.0 | 51.19 | 22400.0 |
| 2002-05-02 13:30:00 | IWM | ETF | 51.2 | 51.25 | 51.18 | 51.2 | 27600.0 |
| 2002-05-02 14:00:00 | IWM | ETF | 51.18 | 51.25 | 51.1 | 51.1 | 21000.0 |
| 2002-05-02 14:30:00 | IWM | ETF | 51.185 | 51.185 | 50.915 | 51.11 | 96200.0 |
| 2002-05-02 15:00:00 | IWM | ETF | 51.085 | 51.15 | 50.99 | 50.99 | 53800.0 |
| 2002-05-02 15:30:00 | IWM | ETF | 50.925 | 51.3 | 50.91 | 51.175 | 324600.0 |
| 2002-05-02 16:00:00 | IWM | ETF | 51.2 | 51.225 | 51.2 | 51.225 | 400.0 |
| 2002-05-02 09:30:00 | DIA | ETF | 100.69 | 101.23 | 100.48 | 100.94 | 323500.0 |
> showing 50 of 495 rows — these rows as CSV