PREVIEW / etf_30min / 2002-12-27
file: by_date/etf_30min/2002/2002-12-27.parquet size: 21 KB rows: 624
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-27 08:00:00 | SPY | ETF | 89.07 | 89.16 | 89.07 | 89.13 | 14000.0 |
| 2002-12-27 08:30:00 | SPY | ETF | 89.13 | 89.13 | 89.05 | 89.1 | 21700.0 |
| 2002-12-27 09:00:00 | SPY | ETF | 89.09 | 89.09 | 88.94 | 88.94 | 7400.0 |
| 2002-12-27 09:30:00 | SPY | ETF | 88.96 | 89.29 | 88.83 | 88.93 | 2417300.0 |
| 2002-12-27 10:00:00 | SPY | ETF | 88.87 | 89.19 | 88.54 | 88.64 | 2222000.0 |
| 2002-12-27 10:30:00 | SPY | ETF | 88.62 | 88.83 | 88.39 | 88.46 | 1444400.0 |
| 2002-12-27 11:00:00 | SPY | ETF | 88.45 | 88.58 | 88.3 | 88.43 | 962900.0 |
| 2002-12-27 11:30:00 | SPY | ETF | 88.41 | 88.43 | 88.22 | 88.35 | 1204500.0 |
| 2002-12-27 12:00:00 | SPY | ETF | 88.35 | 88.39 | 88.11 | 88.26 | 766300.0 |
| 2002-12-27 12:30:00 | SPY | ETF | 88.26 | 88.38 | 88.06 | 88.37 | 705400.0 |
| 2002-12-27 13:00:00 | SPY | ETF | 88.33 | 88.33 | 88.16 | 88.26 | 956400.0 |
| 2002-12-27 13:30:00 | SPY | ETF | 88.27 | 88.29 | 87.9 | 87.96 | 1336600.0 |
| 2002-12-27 14:00:00 | SPY | ETF | 87.96 | 87.99 | 87.71 | 87.95 | 1034800.0 |
| 2002-12-27 14:30:00 | SPY | ETF | 87.93 | 87.97 | 87.53 | 87.65 | 1581900.0 |
| 2002-12-27 15:00:00 | SPY | ETF | 87.63 | 87.93 | 87.52 | 87.82 | 1603400.0 |
| 2002-12-27 15:30:00 | SPY | ETF | 87.83 | 88.02 | 87.64 | 87.68 | 2412200.0 |
| 2002-12-27 16:00:00 | SPY | ETF | 87.7 | 87.71 | 87.36 | 87.36 | 1289500.0 |
| 2002-12-27 16:30:00 | SPY | ETF | 87.4 | 87.41 | 87.26 | 87.37 | 5600.0 |
| 2002-12-27 17:00:00 | SPY | ETF | 87.36 | 87.42 | 87.35 | 87.42 | 3100.0 |
| 2002-12-27 17:30:00 | SPY | ETF | 87.4 | 87.42 | 87.38 | 87.42 | 2300.0 |
| 2002-12-27 18:00:00 | SPY | ETF | 87.47 | 87.49 | 87.41 | 87.49 | 4900.0 |
| 2002-12-27 18:30:00 | SPY | ETF | 87.41 | 87.41 | 87.41 | 87.41 | 100.0 |
| 2002-12-27 08:00:00 | QQQ | ETF | 25.24 | 25.25 | 25.24 | 25.25 | 2100.0 |
| 2002-12-27 08:30:00 | QQQ | ETF | 25.25 | 25.27 | 25.2 | 25.2 | 10900.0 |
| 2002-12-27 09:00:00 | QQQ | ETF | 25.19 | 25.24 | 25.19 | 25.2 | 10400.0 |
| 2002-12-27 09:30:00 | QQQ | ETF | 25.18 | 25.3 | 25.12 | 25.21 | 3464800.0 |
| 2002-12-27 10:00:00 | QQQ | ETF | 25.21 | 25.33 | 25.1 | 25.18 | 3649300.0 |
| 2002-12-27 10:30:00 | QQQ | ETF | 25.17 | 25.22 | 25.06 | 25.08 | 2408700.0 |
| 2002-12-27 11:00:00 | QQQ | ETF | 25.06 | 25.11 | 25.01 | 25.06 | 2263800.0 |
| 2002-12-27 11:30:00 | QQQ | ETF | 25.05 | 25.07 | 24.97 | 25.05 | 3080600.0 |
| 2002-12-27 12:00:00 | QQQ | ETF | 25.03 | 25.09 | 24.98 | 25.05 | 1306600.0 |
| 2002-12-27 12:30:00 | QQQ | ETF | 25.04 | 25.1 | 24.97 | 25.05 | 1582200.0 |
| 2002-12-27 13:00:00 | QQQ | ETF | 25.06 | 25.08 | 24.98 | 25.0 | 1972600.0 |
| 2002-12-27 13:30:00 | QQQ | ETF | 25.0 | 25.03 | 24.87 | 24.9 | 2558400.0 |
| 2002-12-27 14:00:00 | QQQ | ETF | 24.9 | 24.92 | 24.83 | 24.9 | 1840600.0 |
| 2002-12-27 14:30:00 | QQQ | ETF | 24.89 | 24.92 | 24.77 | 24.82 | 4043900.0 |
| 2002-12-27 15:00:00 | QQQ | ETF | 24.81 | 24.88 | 24.75 | 24.85 | 3596900.0 |
| 2002-12-27 15:30:00 | QQQ | ETF | 24.84 | 24.89 | 24.77 | 24.82 | 3813900.0 |
| 2002-12-27 16:00:00 | QQQ | ETF | 24.82 | 24.83 | 24.75 | 24.76 | 2528900.0 |
| 2002-12-27 16:30:00 | QQQ | ETF | 24.78 | 24.8 | 24.78 | 24.8 | 34100.0 |
| 2002-12-27 17:00:00 | QQQ | ETF | 24.8 | 24.82 | 24.79 | 24.79 | 29600.0 |
| 2002-12-27 17:30:00 | QQQ | ETF | 24.8 | 24.8 | 24.79 | 24.79 | 17700.0 |
| 2002-12-27 18:00:00 | QQQ | ETF | 24.8 | 24.82 | 24.77 | 24.8 | 29700.0 |
| 2002-12-27 18:30:00 | QQQ | ETF | 24.8 | 24.8 | 24.8 | 24.8 | 2500.0 |
| 2002-12-27 19:00:00 | QQQ | ETF | 24.83 | 24.83 | 24.82 | 24.82 | 4300.0 |
| 2002-12-27 19:30:00 | QQQ | ETF | 24.82 | 24.83 | 24.82 | 24.83 | 3700.0 |
| 2002-12-27 09:30:00 | IWM | ETF | 38.625 | 38.625 | 38.48 | 38.51 | 194600.0 |
| 2002-12-27 10:00:00 | IWM | ETF | 38.55 | 38.615 | 38.355 | 38.435 | 180800.0 |
| 2002-12-27 10:30:00 | IWM | ETF | 38.425 | 38.49 | 38.335 | 38.41 | 181600.0 |
| 2002-12-27 11:00:00 | IWM | ETF | 38.355 | 38.4 | 38.345 | 38.365 | 85800.0 |
> showing 50 of 624 rows — these rows as CSV