PREVIEW / etf_30min / 2002-12-06
file: by_date/etf_30min/2002/2002-12-06.parquet size: 22 KB rows: 620
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-12-06 08:00:00 | SPY | ETF | 90.87 | 91.35 | 90.84 | 91.35 | 13700.0 |
| 2002-12-06 08:30:00 | SPY | ETF | 91.25 | 91.25 | 89.86 | 90.04 | 197700.0 |
| 2002-12-06 09:00:00 | SPY | ETF | 90.03 | 90.2 | 89.81 | 90.09 | 60100.0 |
| 2002-12-06 09:30:00 | SPY | ETF | 90.12 | 90.91 | 89.98 | 90.89 | 7187400.0 |
| 2002-12-06 10:00:00 | SPY | ETF | 90.92 | 91.57 | 90.82 | 91.05 | 8615200.0 |
| 2002-12-06 10:30:00 | SPY | ETF | 91.04 | 91.6 | 91.0 | 91.24 | 4297300.0 |
| 2002-12-06 11:00:00 | SPY | ETF | 91.25 | 91.54 | 90.97 | 91.25 | 2421400.0 |
| 2002-12-06 11:30:00 | SPY | ETF | 91.32 | 91.69 | 91.26 | 91.49 | 1765800.0 |
| 2002-12-06 12:00:00 | SPY | ETF | 91.5 | 91.71 | 91.39 | 91.61 | 1996900.0 |
| 2002-12-06 12:30:00 | SPY | ETF | 91.61 | 91.83 | 91.42 | 91.53 | 1822000.0 |
| 2002-12-06 13:00:00 | SPY | ETF | 91.53 | 91.7 | 91.45 | 91.59 | 868300.0 |
| 2002-12-06 13:30:00 | SPY | ETF | 91.62 | 92.05 | 91.53 | 91.92 | 2739900.0 |
| 2002-12-06 14:00:00 | SPY | ETF | 91.92 | 92.17 | 91.78 | 91.87 | 2469600.0 |
| 2002-12-06 14:30:00 | SPY | ETF | 91.85 | 92.05 | 91.48 | 91.48 | 2065000.0 |
| 2002-12-06 15:00:00 | SPY | ETF | 91.54 | 91.56 | 91.2 | 91.31 | 2941000.0 |
| 2002-12-06 15:30:00 | SPY | ETF | 91.28 | 91.8 | 91.22 | 91.8 | 2986000.0 |
| 2002-12-06 16:00:00 | SPY | ETF | 91.79 | 92.45 | 91.67 | 92.03 | 1955300.0 |
| 2002-12-06 16:30:00 | SPY | ETF | 92.0 | 92.05 | 92.0 | 92.03 | 14500.0 |
| 2002-12-06 17:00:00 | SPY | ETF | 92.05 | 92.09 | 91.9 | 92.05 | 311300.0 |
| 2002-12-06 17:30:00 | SPY | ETF | 92.07 | 92.1 | 92.06 | 92.1 | 3400.0 |
| 2002-12-06 18:00:00 | SPY | ETF | 92.17 | 92.23 | 92.15 | 92.15 | 2900.0 |
| 2002-12-06 19:00:00 | SPY | ETF | 92.34 | 92.34 | 92.34 | 92.34 | 500.0 |
| 2002-12-06 08:00:00 | QQQ | ETF | 26.14 | 26.26 | 26.11 | 26.24 | 42100.0 |
| 2002-12-06 08:30:00 | QQQ | ETF | 26.24 | 26.24 | 25.61 | 25.65 | 278100.0 |
| 2002-12-06 09:00:00 | QQQ | ETF | 25.65 | 25.84 | 25.63 | 25.81 | 177200.0 |
| 2002-12-06 09:30:00 | QQQ | ETF | 25.81 | 26.15 | 25.74 | 26.15 | 12348200.0 |
| 2002-12-06 10:00:00 | QQQ | ETF | 26.13 | 26.46 | 26.0 | 26.27 | 11439700.0 |
| 2002-12-06 10:30:00 | QQQ | ETF | 26.28 | 26.56 | 26.25 | 26.35 | 5555000.0 |
| 2002-12-06 11:00:00 | QQQ | ETF | 26.39 | 26.48 | 26.26 | 26.35 | 5861900.0 |
| 2002-12-06 11:30:00 | QQQ | ETF | 26.35 | 26.52 | 26.32 | 26.43 | 3423000.0 |
| 2002-12-06 12:00:00 | QQQ | ETF | 26.44 | 26.5 | 26.3 | 26.44 | 3173700.0 |
| 2002-12-06 12:30:00 | QQQ | ETF | 26.46 | 26.52 | 26.35 | 26.42 | 2585600.0 |
| 2002-12-06 13:00:00 | QQQ | ETF | 26.42 | 26.46 | 26.34 | 26.44 | 2274100.0 |
| 2002-12-06 13:30:00 | QQQ | ETF | 26.44 | 26.67 | 26.42 | 26.59 | 5390000.0 |
| 2002-12-06 14:00:00 | QQQ | ETF | 26.6 | 26.72 | 26.58 | 26.62 | 6010900.0 |
| 2002-12-06 14:30:00 | QQQ | ETF | 26.63 | 26.71 | 26.43 | 26.43 | 3527900.0 |
| 2002-12-06 15:00:00 | QQQ | ETF | 26.44 | 26.5 | 26.35 | 26.37 | 5578000.0 |
| 2002-12-06 15:30:00 | QQQ | ETF | 26.38 | 26.55 | 26.36 | 26.47 | 5831300.0 |
| 2002-12-06 16:00:00 | QQQ | ETF | 26.5 | 26.55 | 25.95 | 26.55 | 3878800.0 |
| 2002-12-06 16:30:00 | QQQ | ETF | 26.58 | 26.58 | 26.51 | 26.53 | 26700.0 |
| 2002-12-06 17:00:00 | QQQ | ETF | 26.54 | 26.6 | 26.51 | 26.51 | 28600.0 |
| 2002-12-06 17:30:00 | QQQ | ETF | 26.51 | 26.56 | 26.51 | 26.56 | 29100.0 |
| 2002-12-06 18:00:00 | QQQ | ETF | 26.55 | 26.56 | 26.52 | 26.52 | 12400.0 |
| 2002-12-06 18:30:00 | QQQ | ETF | 26.55 | 26.6 | 26.55 | 26.59 | 3900.0 |
| 2002-12-06 19:00:00 | QQQ | ETF | 26.55 | 26.55 | 26.55 | 26.55 | 400.0 |
| 2002-12-06 19:30:00 | QQQ | ETF | 26.58 | 26.6 | 26.58 | 26.58 | 5700.0 |
| 2002-12-06 08:30:00 | IWM | ETF | 38.97 | 38.97 | 38.97 | 38.97 | 1000.0 |
| 2002-12-06 09:30:00 | IWM | ETF | 39.0 | 39.215 | 38.925 | 39.16 | 163800.0 |
| 2002-12-06 10:00:00 | IWM | ETF | 39.175 | 39.42 | 39.13 | 39.33 | 328000.0 |
| 2002-12-06 10:30:00 | IWM | ETF | 39.325 | 39.495 | 39.3 | 39.3 | 181000.0 |
> showing 50 of 620 rows — these rows as CSV