PREVIEW / etf_30min / 2002-06-13
file: by_date/etf_30min/2002/2002-06-13.parquet size: 18 KB rows: 490
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-06-13 09:30:00 | SPY | ETF | 102.13 | 102.4 | 102.1 | 102.28 | 2067100.0 |
| 2002-06-13 10:00:00 | SPY | ETF | 102.24 | 102.31 | 101.55 | 101.79 | 2451900.0 |
| 2002-06-13 10:30:00 | SPY | ETF | 101.74 | 101.89 | 101.54 | 101.88 | 845700.0 |
| 2002-06-13 11:00:00 | SPY | ETF | 101.88 | 102.36 | 101.7 | 102.3 | 1318100.0 |
| 2002-06-13 11:30:00 | SPY | ETF | 102.27 | 102.88 | 102.11 | 102.78 | 1161300.0 |
| 2002-06-13 12:00:00 | SPY | ETF | 102.75 | 103.0 | 102.52 | 102.8 | 1865700.0 |
| 2002-06-13 12:30:00 | SPY | ETF | 102.79 | 102.8 | 102.35 | 102.53 | 1414200.0 |
| 2002-06-13 13:00:00 | SPY | ETF | 102.52 | 102.68 | 102.29 | 102.65 | 729000.0 |
| 2002-06-13 13:30:00 | SPY | ETF | 102.64 | 102.8 | 102.32 | 102.4 | 751000.0 |
| 2002-06-13 14:00:00 | SPY | ETF | 102.36 | 102.47 | 101.98 | 102.2 | 1171600.0 |
| 2002-06-13 14:30:00 | SPY | ETF | 102.2 | 102.36 | 102.0 | 102.26 | 750800.0 |
| 2002-06-13 15:00:00 | SPY | ETF | 102.27 | 102.36 | 101.85 | 101.95 | 1654900.0 |
| 2002-06-13 15:30:00 | SPY | ETF | 101.98 | 101.99 | 101.34 | 101.48 | 1964000.0 |
| 2002-06-13 16:00:00 | SPY | ETF | 101.49 | 101.64 | 101.13 | 101.6 | 1210200.0 |
| 2002-06-13 16:30:00 | SPY | ETF | 101.52 | 101.65 | 101.52 | 101.58 | 15900.0 |
| 2002-06-13 17:00:00 | SPY | ETF | 101.52 | 101.52 | 101.5 | 101.5 | 34400.0 |
| 2002-06-13 17:30:00 | SPY | ETF | 101.48 | 101.54 | 101.48 | 101.51 | 2600.0 |
| 2002-06-13 18:00:00 | SPY | ETF | 101.54 | 101.65 | 101.48 | 101.65 | 1500.0 |
| 2002-06-13 09:30:00 | QQQ | ETF | 27.76 | 27.93 | 27.69 | 27.79 | 10841900.0 |
| 2002-06-13 10:00:00 | QQQ | ETF | 27.77 | 27.82 | 27.4 | 27.54 | 9171300.0 |
| 2002-06-13 10:30:00 | QQQ | ETF | 27.54 | 27.59 | 27.35 | 27.52 | 4439300.0 |
| 2002-06-13 11:00:00 | QQQ | ETF | 27.54 | 27.9 | 27.5 | 27.87 | 5844000.0 |
| 2002-06-13 11:30:00 | QQQ | ETF | 27.87 | 28.16 | 27.69 | 28.08 | 7452200.0 |
| 2002-06-13 12:00:00 | QQQ | ETF | 28.06 | 28.21 | 27.98 | 28.09 | 8379800.0 |
| 2002-06-13 12:30:00 | QQQ | ETF | 28.09 | 28.14 | 27.83 | 27.93 | 5149300.0 |
| 2002-06-13 13:00:00 | QQQ | ETF | 27.93 | 28.06 | 27.82 | 28.04 | 4950200.0 |
| 2002-06-13 13:30:00 | QQQ | ETF | 28.04 | 28.19 | 27.89 | 27.93 | 4929200.0 |
| 2002-06-13 14:00:00 | QQQ | ETF | 27.93 | 27.99 | 27.6 | 27.78 | 8557900.0 |
| 2002-06-13 14:30:00 | QQQ | ETF | 27.75 | 27.95 | 27.7 | 27.91 | 7260200.0 |
| 2002-06-13 15:00:00 | QQQ | ETF | 27.91 | 27.97 | 27.63 | 27.73 | 4419200.0 |
| 2002-06-13 15:30:00 | QQQ | ETF | 27.75 | 27.76 | 27.51 | 27.55 | 8430500.0 |
| 2002-06-13 16:00:00 | QQQ | ETF | 27.55 | 27.8 | 27.52 | 27.65 | 3245700.0 |
| 2002-06-13 16:30:00 | QQQ | ETF | 27.65 | 27.69 | 27.57 | 27.61 | 142900.0 |
| 2002-06-13 17:00:00 | QQQ | ETF | 27.61 | 27.63 | 27.54 | 27.56 | 99500.0 |
| 2002-06-13 17:30:00 | QQQ | ETF | 27.56 | 27.58 | 27.54 | 27.57 | 17400.0 |
| 2002-06-13 18:00:00 | QQQ | ETF | 27.56 | 27.59 | 27.47 | 27.59 | 12500.0 |
| 2002-06-13 09:30:00 | IWM | ETF | 46.1 | 46.165 | 46.005 | 46.035 | 506800.0 |
| 2002-06-13 10:00:00 | IWM | ETF | 46.0 | 46.0 | 45.755 | 45.82 | 173000.0 |
| 2002-06-13 10:30:00 | IWM | ETF | 45.82 | 45.88 | 45.75 | 45.88 | 63800.0 |
| 2002-06-13 11:00:00 | IWM | ETF | 45.9 | 46.045 | 45.84 | 46.04 | 79400.0 |
| 2002-06-13 11:30:00 | IWM | ETF | 46.075 | 46.295 | 45.92 | 46.295 | 76000.0 |
| 2002-06-13 12:00:00 | IWM | ETF | 46.24 | 46.285 | 46.175 | 46.275 | 20200.0 |
| 2002-06-13 12:30:00 | IWM | ETF | 46.2 | 46.26 | 46.08 | 46.135 | 47600.0 |
| 2002-06-13 13:00:00 | IWM | ETF | 46.125 | 46.125 | 46.0 | 46.105 | 56800.0 |
| 2002-06-13 13:30:00 | IWM | ETF | 46.11 | 46.185 | 46.0 | 46.0 | 19200.0 |
| 2002-06-13 14:00:00 | IWM | ETF | 46.035 | 46.045 | 45.81 | 45.835 | 75800.0 |
| 2002-06-13 14:30:00 | IWM | ETF | 45.825 | 45.905 | 45.82 | 45.905 | 17800.0 |
| 2002-06-13 15:00:00 | IWM | ETF | 45.875 | 45.915 | 45.795 | 45.835 | 40600.0 |
| 2002-06-13 15:30:00 | IWM | ETF | 45.765 | 45.83 | 45.385 | 45.475 | 176200.0 |
| 2002-06-13 16:00:00 | IWM | ETF | 45.4 | 45.5 | 45.4 | 45.5 | 23400.0 |
> showing 50 of 490 rows — these rows as CSV