PREVIEW / etf_30min / 2002-12-23
file: by_date/etf_30min/2002/2002-12-23.parquet size: 22 KB rows: 637
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-23 08:00:00 | SPY | ETF | 89.53 | 89.53 | 89.44 | 89.49 | 9500.0 |
| 2002-12-23 08:30:00 | SPY | ETF | 89.5 | 89.5 | 89.42 | 89.49 | 14300.0 |
| 2002-12-23 09:00:00 | SPY | ETF | 89.45 | 89.55 | 89.45 | 89.5 | 8400.0 |
| 2002-12-23 09:30:00 | SPY | ETF | 89.59 | 89.85 | 89.31 | 89.52 | 2682200.0 |
| 2002-12-23 10:00:00 | SPY | ETF | 89.52 | 89.88 | 89.36 | 89.77 | 1993100.0 |
| 2002-12-23 10:30:00 | SPY | ETF | 89.81 | 90.33 | 89.7 | 90.27 | 2452500.0 |
| 2002-12-23 11:00:00 | SPY | ETF | 90.28 | 90.47 | 90.27 | 90.4 | 2185500.0 |
| 2002-12-23 11:30:00 | SPY | ETF | 90.38 | 90.44 | 90.14 | 90.14 | 1350000.0 |
| 2002-12-23 12:00:00 | SPY | ETF | 90.17 | 90.19 | 89.93 | 90.14 | 1004400.0 |
| 2002-12-23 12:30:00 | SPY | ETF | 90.15 | 90.19 | 89.89 | 89.95 | 679800.0 |
| 2002-12-23 13:00:00 | SPY | ETF | 89.97 | 90.05 | 89.85 | 90.0 | 618000.0 |
| 2002-12-23 13:30:00 | SPY | ETF | 90.0 | 90.01 | 89.65 | 89.65 | 998700.0 |
| 2002-12-23 14:00:00 | SPY | ETF | 89.7 | 89.82 | 89.51 | 89.8 | 1107800.0 |
| 2002-12-23 14:30:00 | SPY | ETF | 89.78 | 89.86 | 89.57 | 89.77 | 596200.0 |
| 2002-12-23 15:00:00 | SPY | ETF | 89.78 | 89.94 | 89.7 | 89.72 | 973500.0 |
| 2002-12-23 15:30:00 | SPY | ETF | 89.73 | 90.01 | 89.64 | 89.93 | 1806400.0 |
| 2002-12-23 16:00:00 | SPY | ETF | 89.87 | 90.19 | 89.87 | 90.02 | 1973300.0 |
| 2002-12-23 16:30:00 | SPY | ETF | 90.02 | 90.05 | 89.97 | 90.05 | 32500.0 |
| 2002-12-23 17:00:00 | SPY | ETF | 90.1 | 90.14 | 90.06 | 90.1 | 378000.0 |
| 2002-12-23 17:30:00 | SPY | ETF | 90.02 | 90.02 | 90.02 | 90.02 | 43400.0 |
| 2002-12-23 18:00:00 | SPY | ETF | 90.07 | 90.07 | 90.07 | 90.07 | 100.0 |
| 2002-12-23 08:00:00 | QQQ | ETF | 25.29 | 25.29 | 25.21 | 25.21 | 4900.0 |
| 2002-12-23 08:30:00 | QQQ | ETF | 25.21 | 25.25 | 25.2 | 25.25 | 22200.0 |
| 2002-12-23 09:00:00 | QQQ | ETF | 25.23 | 25.26 | 25.21 | 25.22 | 19000.0 |
| 2002-12-23 09:30:00 | QQQ | ETF | 25.18 | 25.5 | 25.13 | 25.39 | 7101200.0 |
| 2002-12-23 10:00:00 | QQQ | ETF | 25.39 | 25.59 | 25.34 | 25.51 | 5007300.0 |
| 2002-12-23 10:30:00 | QQQ | ETF | 25.52 | 25.75 | 25.48 | 25.69 | 4499100.0 |
| 2002-12-23 11:00:00 | QQQ | ETF | 25.68 | 25.76 | 25.65 | 25.73 | 4050600.0 |
| 2002-12-23 11:30:00 | QQQ | ETF | 25.73 | 25.75 | 25.59 | 25.63 | 2788900.0 |
| 2002-12-23 12:00:00 | QQQ | ETF | 25.64 | 25.68 | 25.57 | 25.64 | 1730100.0 |
| 2002-12-23 12:30:00 | QQQ | ETF | 25.64 | 25.67 | 25.57 | 25.59 | 1651500.0 |
| 2002-12-23 13:00:00 | QQQ | ETF | 25.59 | 25.67 | 25.55 | 25.64 | 1561600.0 |
| 2002-12-23 13:30:00 | QQQ | ETF | 25.64 | 25.66 | 25.5 | 25.53 | 1763300.0 |
| 2002-12-23 14:00:00 | QQQ | ETF | 25.53 | 25.58 | 25.44 | 25.54 | 1604600.0 |
| 2002-12-23 14:30:00 | QQQ | ETF | 25.54 | 25.61 | 25.5 | 25.59 | 2321300.0 |
| 2002-12-23 15:00:00 | QQQ | ETF | 25.6 | 25.68 | 25.53 | 25.6 | 1592900.0 |
| 2002-12-23 15:30:00 | QQQ | ETF | 25.6 | 25.69 | 25.51 | 25.67 | 4537800.0 |
| 2002-12-23 16:00:00 | QQQ | ETF | 25.69 | 25.69 | 25.55 | 25.64 | 1748500.0 |
| 2002-12-23 16:30:00 | QQQ | ETF | 25.64 | 25.67 | 25.62 | 25.67 | 37800.0 |
| 2002-12-23 17:00:00 | QQQ | ETF | 25.66 | 25.66 | 25.61 | 25.62 | 45000.0 |
| 2002-12-23 17:30:00 | QQQ | ETF | 25.62 | 25.62 | 25.6 | 25.61 | 31500.0 |
| 2002-12-23 18:00:00 | QQQ | ETF | 25.64 | 25.64 | 25.6 | 25.63 | 3400.0 |
| 2002-12-23 18:30:00 | QQQ | ETF | 25.68 | 25.68 | 25.61 | 25.61 | 600.0 |
| 2002-12-23 19:00:00 | QQQ | ETF | 25.65 | 25.65 | 25.65 | 25.65 | 5000.0 |
| 2002-12-23 19:30:00 | QQQ | ETF | 25.66 | 25.69 | 25.66 | 25.69 | 3700.0 |
| 2002-12-23 09:30:00 | IWM | ETF | 38.45 | 38.625 | 38.355 | 38.53 | 543400.0 |
| 2002-12-23 10:00:00 | IWM | ETF | 38.51 | 38.69 | 38.48 | 38.6 | 159600.0 |
| 2002-12-23 10:30:00 | IWM | ETF | 38.65 | 38.815 | 38.62 | 38.73 | 161200.0 |
| 2002-12-23 11:00:00 | IWM | ETF | 38.76 | 38.83 | 38.73 | 38.765 | 127200.0 |
| 2002-12-23 11:30:00 | IWM | ETF | 38.795 | 38.8 | 38.73 | 38.735 | 33400.0 |
> showing 50 of 637 rows — these rows as CSV