PREVIEW / etf_30min / 2002-11-22
file: by_date/etf_30min/2002/2002-11-22.parquet size: 22 KB rows: 639
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-11-22 08:00:00 | SPY | ETF | 93.79 | 93.81 | 93.66 | 93.73 | 11300.0 |
| 2002-11-22 08:30:00 | SPY | ETF | 93.71 | 93.71 | 93.55 | 93.56 | 14800.0 |
| 2002-11-22 09:00:00 | SPY | ETF | 93.55 | 93.55 | 93.45 | 93.45 | 6900.0 |
| 2002-11-22 09:30:00 | SPY | ETF | 93.48 | 93.87 | 93.27 | 93.77 | 4443900.0 |
| 2002-11-22 10:00:00 | SPY | ETF | 93.83 | 94.09 | 93.5 | 93.66 | 3698600.0 |
| 2002-11-22 10:30:00 | SPY | ETF | 93.65 | 93.74 | 93.39 | 93.52 | 2060200.0 |
| 2002-11-22 11:00:00 | SPY | ETF | 93.48 | 93.84 | 93.41 | 93.65 | 1738200.0 |
| 2002-11-22 11:30:00 | SPY | ETF | 93.67 | 93.7 | 93.31 | 93.38 | 1200200.0 |
| 2002-11-22 12:00:00 | SPY | ETF | 93.34 | 93.68 | 93.28 | 93.55 | 980500.0 |
| 2002-11-22 12:30:00 | SPY | ETF | 93.55 | 93.9 | 93.51 | 93.75 | 763100.0 |
| 2002-11-22 13:00:00 | SPY | ETF | 93.75 | 93.77 | 93.6 | 93.73 | 804300.0 |
| 2002-11-22 13:30:00 | SPY | ETF | 93.7 | 93.9 | 93.63 | 93.77 | 535700.0 |
| 2002-11-22 14:00:00 | SPY | ETF | 93.77 | 94.19 | 93.72 | 94.09 | 2258700.0 |
| 2002-11-22 14:30:00 | SPY | ETF | 94.08 | 94.23 | 93.85 | 93.99 | 2281300.0 |
| 2002-11-22 15:00:00 | SPY | ETF | 94.04 | 94.27 | 93.86 | 94.0 | 1791600.0 |
| 2002-11-22 15:30:00 | SPY | ETF | 94.01 | 94.06 | 93.45 | 93.62 | 4991600.0 |
| 2002-11-22 16:00:00 | SPY | ETF | 93.59 | 93.68 | 93.16 | 93.35 | 2305000.0 |
| 2002-11-22 16:30:00 | SPY | ETF | 93.34 | 93.42 | 93.34 | 93.34 | 51300.0 |
| 2002-11-22 17:00:00 | SPY | ETF | 93.35 | 93.49 | 93.34 | 93.42 | 15400.0 |
| 2002-11-22 17:30:00 | SPY | ETF | 93.42 | 93.42 | 93.4 | 93.4 | 200.0 |
| 2002-11-22 18:00:00 | SPY | ETF | 93.42 | 93.5 | 93.42 | 93.5 | 200.0 |
| 2002-11-22 19:00:00 | SPY | ETF | 93.42 | 93.42 | 93.4 | 93.4 | 900.0 |
| 2002-11-22 08:00:00 | QQQ | ETF | 27.56 | 27.61 | 27.0 | 27.53 | 35700.0 |
| 2002-11-22 08:30:00 | QQQ | ETF | 27.5 | 27.52 | 27.44 | 27.46 | 89200.0 |
| 2002-11-22 09:00:00 | QQQ | ETF | 27.45 | 27.47 | 27.4 | 27.4 | 43600.0 |
| 2002-11-22 09:30:00 | QQQ | ETF | 27.37 | 27.72 | 27.32 | 27.64 | 13929800.0 |
| 2002-11-22 10:00:00 | QQQ | ETF | 27.65 | 27.8 | 27.52 | 27.58 | 7318600.0 |
| 2002-11-22 10:30:00 | QQQ | ETF | 27.58 | 27.62 | 27.39 | 27.42 | 5337800.0 |
| 2002-11-22 11:00:00 | QQQ | ETF | 27.43 | 27.63 | 27.41 | 27.54 | 3879900.0 |
| 2002-11-22 11:30:00 | QQQ | ETF | 27.54 | 27.63 | 27.45 | 27.46 | 2988200.0 |
| 2002-11-22 12:00:00 | QQQ | ETF | 27.46 | 27.64 | 27.44 | 27.57 | 3198900.0 |
| 2002-11-22 12:30:00 | QQQ | ETF | 27.58 | 27.7 | 27.52 | 27.64 | 3256500.0 |
| 2002-11-22 13:00:00 | QQQ | ETF | 27.65 | 27.67 | 27.59 | 27.62 | 1714800.0 |
| 2002-11-22 13:30:00 | QQQ | ETF | 27.62 | 27.73 | 27.6 | 27.68 | 2146900.0 |
| 2002-11-22 14:00:00 | QQQ | ETF | 27.68 | 27.92 | 27.65 | 27.88 | 5900500.0 |
| 2002-11-22 14:30:00 | QQQ | ETF | 27.88 | 27.92 | 27.71 | 27.75 | 4366200.0 |
| 2002-11-22 15:00:00 | QQQ | ETF | 27.81 | 27.94 | 27.72 | 27.75 | 3816900.0 |
| 2002-11-22 15:30:00 | QQQ | ETF | 27.75 | 27.8 | 27.58 | 27.73 | 7864200.0 |
| 2002-11-22 16:00:00 | QQQ | ETF | 27.73 | 27.79 | 27.65 | 27.71 | 2740100.0 |
| 2002-11-22 16:30:00 | QQQ | ETF | 27.7 | 27.76 | 27.68 | 27.75 | 19600.0 |
| 2002-11-22 17:00:00 | QQQ | ETF | 27.75 | 27.75 | 27.68 | 27.7 | 25300.0 |
| 2002-11-22 17:30:00 | QQQ | ETF | 27.71 | 27.73 | 27.71 | 27.71 | 12000.0 |
| 2002-11-22 18:00:00 | QQQ | ETF | 27.73 | 27.73 | 27.7 | 27.72 | 12900.0 |
| 2002-11-22 18:30:00 | QQQ | ETF | 27.73 | 27.77 | 27.73 | 27.77 | 4300.0 |
| 2002-11-22 19:00:00 | QQQ | ETF | 27.76 | 27.77 | 27.76 | 27.77 | 1400.0 |
| 2002-11-22 19:30:00 | QQQ | ETF | 27.77 | 27.77 | 27.73 | 27.73 | 1400.0 |
| 2002-11-22 09:30:00 | IWM | ETF | 39.4 | 39.55 | 39.335 | 39.55 | 257800.0 |
| 2002-11-22 10:00:00 | IWM | ETF | 39.555 | 39.75 | 39.515 | 39.645 | 585600.0 |
| 2002-11-22 10:30:00 | IWM | ETF | 39.68 | 39.69 | 39.535 | 39.54 | 77400.0 |
| 2002-11-22 11:00:00 | IWM | ETF | 39.595 | 39.685 | 39.57 | 39.635 | 180600.0 |
> showing 50 of 639 rows — these rows as CSV