PREVIEW / etf_30min / 2002-12-31
file: by_date/etf_30min/2002/2002-12-31.parquet size: 22 KB rows: 647
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-31 08:00:00 | SPY | ETF | 88.18 | 88.18 | 88.13 | 88.13 | 700.0 |
| 2002-12-31 09:00:00 | SPY | ETF | 88.21 | 88.21 | 88.1 | 88.13 | 10400.0 |
| 2002-12-31 09:30:00 | SPY | ETF | 87.99 | 88.23 | 87.89 | 88.1 | 2767000.0 |
| 2002-12-31 10:00:00 | SPY | ETF | 88.06 | 88.06 | 87.32 | 87.35 | 4185000.0 |
| 2002-12-31 10:30:00 | SPY | ETF | 87.35 | 87.41 | 87.11 | 87.31 | 2519800.0 |
| 2002-12-31 11:00:00 | SPY | ETF | 87.31 | 87.58 | 87.18 | 87.54 | 1227200.0 |
| 2002-12-31 11:30:00 | SPY | ETF | 87.51 | 87.93 | 87.51 | 87.77 | 2291600.0 |
| 2002-12-31 12:00:00 | SPY | ETF | 87.76 | 87.99 | 87.65 | 87.96 | 1200300.0 |
| 2002-12-31 12:30:00 | SPY | ETF | 87.95 | 88.22 | 87.85 | 88.02 | 1187100.0 |
| 2002-12-31 13:00:00 | SPY | ETF | 88.0 | 88.36 | 87.94 | 88.27 | 1177900.0 |
| 2002-12-31 13:30:00 | SPY | ETF | 88.33 | 88.42 | 87.99 | 88.03 | 1645500.0 |
| 2002-12-31 14:00:00 | SPY | ETF | 88.01 | 88.27 | 87.93 | 88.24 | 1942400.0 |
| 2002-12-31 14:30:00 | SPY | ETF | 88.25 | 88.35 | 88.05 | 88.3 | 999500.0 |
| 2002-12-31 15:00:00 | SPY | ETF | 88.28 | 88.43 | 88.0 | 88.05 | 2170300.0 |
| 2002-12-31 15:30:00 | SPY | ETF | 87.99 | 88.19 | 87.88 | 88.16 | 2447900.0 |
| 2002-12-31 16:00:00 | SPY | ETF | 88.2 | 88.43 | 88.11 | 88.19 | 2802600.0 |
| 2002-12-31 16:30:00 | SPY | ETF | 88.26 | 88.26 | 88.23 | 88.23 | 2900.0 |
| 2002-12-31 17:00:00 | SPY | ETF | 88.23 | 88.23 | 88.23 | 88.23 | 1000.0 |
| 2002-12-31 17:30:00 | SPY | ETF | 88.25 | 88.25 | 88.25 | 88.25 | 200.0 |
| 2002-12-31 18:00:00 | SPY | ETF | 88.26 | 88.26 | 88.25 | 88.25 | 600.0 |
| 2002-12-31 18:30:00 | SPY | ETF | 88.26 | 88.26 | 88.26 | 88.26 | 100.0 |
| 2002-12-31 19:30:00 | SPY | ETF | 88.26 | 88.31 | 88.26 | 88.31 | 800.0 |
| 2002-12-31 08:00:00 | QQQ | ETF | 24.56 | 24.62 | 24.56 | 24.58 | 33500.0 |
| 2002-12-31 08:30:00 | QQQ | ETF | 24.57 | 24.59 | 24.56 | 24.57 | 5600.0 |
| 2002-12-31 09:00:00 | QQQ | ETF | 24.58 | 24.6 | 24.58 | 24.59 | 9600.0 |
| 2002-12-31 09:30:00 | QQQ | ETF | 24.54 | 24.71 | 24.5 | 24.65 | 4271400.0 |
| 2002-12-31 10:00:00 | QQQ | ETF | 24.65 | 24.65 | 24.38 | 24.4 | 7827800.0 |
| 2002-12-31 10:30:00 | QQQ | ETF | 24.4 | 24.45 | 24.28 | 24.35 | 3264900.0 |
| 2002-12-31 11:00:00 | QQQ | ETF | 24.35 | 24.4 | 24.28 | 24.39 | 2026700.0 |
| 2002-12-31 11:30:00 | QQQ | ETF | 24.4 | 24.54 | 24.36 | 24.5 | 2400600.0 |
| 2002-12-31 12:00:00 | QQQ | ETF | 24.51 | 24.53 | 24.45 | 24.51 | 2063100.0 |
| 2002-12-31 12:30:00 | QQQ | ETF | 24.51 | 24.59 | 24.45 | 24.53 | 2272900.0 |
| 2002-12-31 13:00:00 | QQQ | ETF | 24.52 | 24.66 | 24.5 | 24.62 | 1467900.0 |
| 2002-12-31 13:30:00 | QQQ | ETF | 24.62 | 24.68 | 24.46 | 24.49 | 2443800.0 |
| 2002-12-31 14:00:00 | QQQ | ETF | 24.5 | 24.61 | 24.48 | 24.59 | 1917400.0 |
| 2002-12-31 14:30:00 | QQQ | ETF | 24.59 | 24.62 | 24.48 | 24.56 | 1592400.0 |
| 2002-12-31 15:00:00 | QQQ | ETF | 24.55 | 24.61 | 24.41 | 24.42 | 2498100.0 |
| 2002-12-31 15:30:00 | QQQ | ETF | 24.41 | 24.5 | 24.37 | 24.43 | 3678300.0 |
| 2002-12-31 16:00:00 | QQQ | ETF | 24.42 | 24.5 | 24.37 | 24.4 | 1713900.0 |
| 2002-12-31 16:30:00 | QQQ | ETF | 24.39 | 24.41 | 24.39 | 24.41 | 36300.0 |
| 2002-12-31 17:00:00 | QQQ | ETF | 24.41 | 24.43 | 24.4 | 24.43 | 9000.0 |
| 2002-12-31 17:30:00 | QQQ | ETF | 24.43 | 24.45 | 24.41 | 24.41 | 4400.0 |
| 2002-12-31 18:00:00 | QQQ | ETF | 24.44 | 24.46 | 24.42 | 24.42 | 8400.0 |
| 2002-12-31 18:30:00 | QQQ | ETF | 24.41 | 24.45 | 24.41 | 24.44 | 5200.0 |
| 2002-12-31 19:00:00 | QQQ | ETF | 24.41 | 24.41 | 24.41 | 24.41 | 300.0 |
| 2002-12-31 19:30:00 | QQQ | ETF | 24.44 | 24.46 | 24.43 | 24.46 | 1100.0 |
| 2002-12-31 09:30:00 | IWM | ETF | 38.07 | 38.2 | 37.935 | 38.16 | 1006400.0 |
| 2002-12-31 10:00:00 | IWM | ETF | 38.125 | 38.125 | 37.875 | 37.875 | 652200.0 |
| 2002-12-31 10:30:00 | IWM | ETF | 37.865 | 37.925 | 37.8 | 37.925 | 202800.0 |
| 2002-12-31 11:00:00 | IWM | ETF | 37.9 | 38.04 | 37.845 | 38.04 | 46000.0 |
> showing 50 of 647 rows — these rows as CSV