PREVIEW / etf_30min / 2002-11-21
file: by_date/etf_30min/2002/2002-11-21.parquet size: 23 KB rows: 659
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-21 08:00:00 | SPY | ETF | 92.57 | 92.57 | 92.21 | 92.45 | 29000.0 |
| 2002-11-21 08:30:00 | SPY | ETF | 92.5 | 92.89 | 92.5 | 92.82 | 38600.0 |
| 2002-11-21 09:00:00 | SPY | ETF | 92.82 | 92.85 | 92.66 | 92.66 | 10600.0 |
| 2002-11-21 09:30:00 | SPY | ETF | 92.6 | 93.04 | 92.43 | 92.9 | 6734600.0 |
| 2002-11-21 10:00:00 | SPY | ETF | 92.87 | 93.13 | 92.67 | 93.1 | 4651800.0 |
| 2002-11-21 10:30:00 | SPY | ETF | 93.07 | 93.53 | 92.84 | 93.39 | 5601100.0 |
| 2002-11-21 11:00:00 | SPY | ETF | 93.43 | 93.75 | 93.38 | 93.44 | 4087400.0 |
| 2002-11-21 11:30:00 | SPY | ETF | 93.45 | 93.59 | 93.35 | 93.5 | 1996400.0 |
| 2002-11-21 12:00:00 | SPY | ETF | 93.46 | 93.76 | 93.2 | 93.35 | 4107700.0 |
| 2002-11-21 12:30:00 | SPY | ETF | 93.37 | 93.63 | 93.34 | 93.52 | 1529600.0 |
| 2002-11-21 13:00:00 | SPY | ETF | 93.51 | 93.93 | 93.45 | 93.82 | 2713500.0 |
| 2002-11-21 13:30:00 | SPY | ETF | 93.82 | 94.0 | 93.67 | 93.72 | 3096600.0 |
| 2002-11-21 14:00:00 | SPY | ETF | 93.75 | 93.93 | 93.45 | 93.58 | 1709000.0 |
| 2002-11-21 14:30:00 | SPY | ETF | 93.57 | 94.11 | 93.52 | 93.98 | 3541000.0 |
| 2002-11-21 15:00:00 | SPY | ETF | 93.98 | 94.04 | 93.51 | 93.59 | 3336300.0 |
| 2002-11-21 15:30:00 | SPY | ETF | 93.59 | 93.94 | 93.36 | 93.9 | 4050500.0 |
| 2002-11-21 16:00:00 | SPY | ETF | 93.91 | 94.19 | 93.87 | 94.1 | 4723000.0 |
| 2002-11-21 16:30:00 | SPY | ETF | 94.08 | 94.17 | 94.04 | 94.09 | 23600.0 |
| 2002-11-21 17:00:00 | SPY | ETF | 94.05 | 94.06 | 93.9 | 93.95 | 21500.0 |
| 2002-11-21 17:30:00 | SPY | ETF | 93.9 | 93.91 | 93.83 | 93.91 | 27000.0 |
| 2002-11-21 18:00:00 | SPY | ETF | 93.9 | 93.94 | 93.9 | 93.93 | 1700.0 |
| 2002-11-21 18:30:00 | SPY | ETF | 93.88 | 93.94 | 93.88 | 93.94 | 8500.0 |
| 2002-11-21 08:00:00 | QQQ | ETF | 26.96 | 27.0 | 26.83 | 26.89 | 47200.0 |
| 2002-11-21 08:30:00 | QQQ | ETF | 26.91 | 27.04 | 26.91 | 27.02 | 92700.0 |
| 2002-11-21 09:00:00 | QQQ | ETF | 27.03 | 27.03 | 26.92 | 26.92 | 60700.0 |
| 2002-11-21 09:30:00 | QQQ | ETF | 26.93 | 27.35 | 26.85 | 27.27 | 17526800.0 |
| 2002-11-21 10:00:00 | QQQ | ETF | 27.28 | 27.41 | 27.14 | 27.36 | 11454400.0 |
| 2002-11-21 10:30:00 | QQQ | ETF | 27.37 | 27.61 | 27.27 | 27.56 | 7710400.0 |
| 2002-11-21 11:00:00 | QQQ | ETF | 27.55 | 27.74 | 27.52 | 27.6 | 8505900.0 |
| 2002-11-21 11:30:00 | QQQ | ETF | 27.6 | 27.65 | 27.47 | 27.53 | 5289300.0 |
| 2002-11-21 12:00:00 | QQQ | ETF | 27.53 | 27.71 | 27.42 | 27.5 | 6881900.0 |
| 2002-11-21 12:30:00 | QQQ | ETF | 27.49 | 27.64 | 27.48 | 27.58 | 2803200.0 |
| 2002-11-21 13:00:00 | QQQ | ETF | 27.58 | 27.75 | 27.55 | 27.72 | 4577300.0 |
| 2002-11-21 13:30:00 | QQQ | ETF | 27.72 | 27.76 | 27.6 | 27.63 | 3914300.0 |
| 2002-11-21 14:00:00 | QQQ | ETF | 27.63 | 27.73 | 27.47 | 27.58 | 4553000.0 |
| 2002-11-21 14:30:00 | QQQ | ETF | 27.59 | 27.84 | 27.55 | 27.81 | 6318800.0 |
| 2002-11-21 15:00:00 | QQQ | ETF | 27.8 | 27.85 | 27.61 | 27.65 | 6511800.0 |
| 2002-11-21 15:30:00 | QQQ | ETF | 27.65 | 27.82 | 27.54 | 27.8 | 9569600.0 |
| 2002-11-21 16:00:00 | QQQ | ETF | 27.79 | 27.84 | 27.71 | 27.75 | 2365000.0 |
| 2002-11-21 16:30:00 | QQQ | ETF | 27.75 | 27.82 | 27.71 | 27.78 | 281300.0 |
| 2002-11-21 17:00:00 | QQQ | ETF | 27.78 | 27.81 | 27.62 | 27.64 | 748700.0 |
| 2002-11-21 17:30:00 | QQQ | ETF | 27.62 | 27.65 | 27.59 | 27.62 | 654400.0 |
| 2002-11-21 18:00:00 | QQQ | ETF | 27.63 | 27.65 | 27.6 | 27.64 | 37300.0 |
| 2002-11-21 18:30:00 | QQQ | ETF | 27.64 | 27.65 | 27.6 | 27.65 | 12200.0 |
| 2002-11-21 19:00:00 | QQQ | ETF | 27.65 | 27.67 | 27.6 | 27.61 | 4100.0 |
| 2002-11-21 19:30:00 | QQQ | ETF | 27.6 | 27.63 | 27.6 | 27.63 | 10000.0 |
| 2002-11-21 09:30:00 | IWM | ETF | 39.01 | 39.15 | 38.88 | 39.14 | 264000.0 |
| 2002-11-21 10:00:00 | IWM | ETF | 39.245 | 39.28 | 39.08 | 39.28 | 92400.0 |
| 2002-11-21 10:30:00 | IWM | ETF | 39.29 | 39.47 | 39.235 | 39.39 | 513600.0 |
| 2002-11-21 11:00:00 | IWM | ETF | 39.455 | 39.575 | 39.395 | 39.43 | 494000.0 |
> showing 50 of 659 rows — these rows as CSV