PREVIEW / etf_30min / 2002-05-28
file: by_date/etf_30min/2002/2002-05-28.parquet size: 18 KB rows: 503
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-28 09:30:00 | SPY | ETF | 109.05 | 109.13 | 108.58 | 108.62 | 3666400.0 |
| 2002-05-28 10:00:00 | SPY | ETF | 108.64 | 108.85 | 107.97 | 108.31 | 3037100.0 |
| 2002-05-28 10:30:00 | SPY | ETF | 108.27 | 108.34 | 107.5 | 107.61 | 3647500.0 |
| 2002-05-28 11:00:00 | SPY | ETF | 107.68 | 107.75 | 107.45 | 107.69 | 1683600.0 |
| 2002-05-28 11:30:00 | SPY | ETF | 107.7 | 107.8 | 107.58 | 107.7 | 673100.0 |
| 2002-05-28 12:00:00 | SPY | ETF | 107.71 | 107.74 | 107.61 | 107.7 | 428900.0 |
| 2002-05-28 12:30:00 | SPY | ETF | 107.67 | 107.78 | 107.49 | 107.67 | 329300.0 |
| 2002-05-28 13:00:00 | SPY | ETF | 107.74 | 107.94 | 107.68 | 107.91 | 1416600.0 |
| 2002-05-28 13:30:00 | SPY | ETF | 107.89 | 107.92 | 107.7 | 107.92 | 1176300.0 |
| 2002-05-28 14:00:00 | SPY | ETF | 107.9 | 108.25 | 107.87 | 107.95 | 894400.0 |
| 2002-05-28 14:30:00 | SPY | ETF | 107.99 | 108.1 | 107.66 | 107.81 | 1305400.0 |
| 2002-05-28 15:00:00 | SPY | ETF | 107.79 | 108.06 | 107.68 | 107.88 | 1215400.0 |
| 2002-05-28 15:30:00 | SPY | ETF | 107.84 | 108.16 | 107.83 | 107.9 | 2140600.0 |
| 2002-05-28 16:00:00 | SPY | ETF | 107.91 | 108.11 | 107.86 | 108.1 | 1613500.0 |
| 2002-05-28 16:30:00 | SPY | ETF | 108.1 | 108.18 | 107.97 | 108.0 | 6600.0 |
| 2002-05-28 17:00:00 | SPY | ETF | 107.97 | 107.97 | 107.9 | 107.9 | 3900.0 |
| 2002-05-28 17:30:00 | SPY | ETF | 107.92 | 107.92 | 107.92 | 107.92 | 200.0 |
| 2002-05-28 18:00:00 | SPY | ETF | 107.88 | 107.88 | 107.88 | 107.88 | 100.0 |
| 2002-05-28 09:30:00 | QQQ | ETF | 31.47 | 31.52 | 31.08 | 31.18 | 10573700.0 |
| 2002-05-28 10:00:00 | QQQ | ETF | 31.19 | 31.35 | 30.73 | 30.89 | 13441600.0 |
| 2002-05-28 10:30:00 | QQQ | ETF | 30.88 | 30.9 | 30.49 | 30.56 | 8896200.0 |
| 2002-05-28 11:00:00 | QQQ | ETF | 30.58 | 30.68 | 30.52 | 30.67 | 3415100.0 |
| 2002-05-28 11:30:00 | QQQ | ETF | 30.67 | 30.77 | 30.61 | 30.66 | 2945400.0 |
| 2002-05-28 12:00:00 | QQQ | ETF | 30.66 | 30.68 | 30.59 | 30.65 | 1954200.0 |
| 2002-05-28 12:30:00 | QQQ | ETF | 30.64 | 30.74 | 30.52 | 30.7 | 2038100.0 |
| 2002-05-28 13:00:00 | QQQ | ETF | 30.7 | 30.82 | 30.68 | 30.77 | 1670700.0 |
| 2002-05-28 13:30:00 | QQQ | ETF | 30.77 | 30.89 | 30.69 | 30.85 | 2272300.0 |
| 2002-05-28 14:00:00 | QQQ | ETF | 30.85 | 31.06 | 30.81 | 30.9 | 4959500.0 |
| 2002-05-28 14:30:00 | QQQ | ETF | 30.89 | 30.97 | 30.71 | 30.77 | 3578600.0 |
| 2002-05-28 15:00:00 | QQQ | ETF | 30.77 | 30.97 | 30.74 | 30.87 | 2707300.0 |
| 2002-05-28 15:30:00 | QQQ | ETF | 30.88 | 31.09 | 30.86 | 30.98 | 6698200.0 |
| 2002-05-28 16:00:00 | QQQ | ETF | 30.98 | 31.15 | 30.93 | 31.11 | 2653400.0 |
| 2002-05-28 16:30:00 | QQQ | ETF | 31.11 | 31.24 | 30.95 | 30.96 | 308700.0 |
| 2002-05-28 17:00:00 | QQQ | ETF | 30.96 | 30.97 | 30.85 | 30.87 | 465100.0 |
| 2002-05-28 17:30:00 | QQQ | ETF | 30.87 | 30.91 | 30.82 | 30.91 | 33600.0 |
| 2002-05-28 18:00:00 | QQQ | ETF | 30.92 | 30.94 | 30.89 | 30.9 | 21100.0 |
| 2002-05-28 09:30:00 | IWM | ETF | 49.4 | 49.4 | 49.0 | 49.005 | 356200.0 |
| 2002-05-28 10:00:00 | IWM | ETF | 49.01 | 49.17 | 48.665 | 48.74 | 231400.0 |
| 2002-05-28 10:30:00 | IWM | ETF | 48.685 | 48.75 | 48.5 | 48.505 | 585400.0 |
| 2002-05-28 11:00:00 | IWM | ETF | 48.505 | 48.575 | 48.5 | 48.555 | 109600.0 |
| 2002-05-28 11:30:00 | IWM | ETF | 48.56 | 48.64 | 48.55 | 48.6 | 140000.0 |
| 2002-05-28 12:00:00 | IWM | ETF | 48.6 | 48.6 | 48.55 | 48.55 | 15000.0 |
| 2002-05-28 12:30:00 | IWM | ETF | 48.6 | 48.62 | 48.59 | 48.62 | 18800.0 |
| 2002-05-28 13:00:00 | IWM | ETF | 48.62 | 48.69 | 48.585 | 48.69 | 178800.0 |
| 2002-05-28 13:30:00 | IWM | ETF | 48.69 | 48.69 | 48.61 | 48.68 | 425600.0 |
| 2002-05-28 14:00:00 | IWM | ETF | 48.68 | 48.925 | 48.675 | 48.875 | 265400.0 |
| 2002-05-28 14:30:00 | IWM | ETF | 48.875 | 48.91 | 48.735 | 48.775 | 137800.0 |
| 2002-05-28 15:00:00 | IWM | ETF | 48.835 | 48.88 | 48.775 | 48.875 | 223400.0 |
| 2002-05-28 15:30:00 | IWM | ETF | 48.9 | 49.065 | 48.83 | 48.985 | 183800.0 |
| 2002-05-28 16:00:00 | IWM | ETF | 48.965 | 49.125 | 48.695 | 49.06 | 110400.0 |
> showing 50 of 503 rows — these rows as CSV