PREVIEW / etf_30min / 2002-12-17
file: by_date/etf_30min/2002/2002-12-17.parquet size: 22 KB rows: 645
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-17 08:00:00 | SPY | ETF | 91.4 | 91.59 | 91.4 | 91.59 | 3800.0 |
| 2002-12-17 08:30:00 | SPY | ETF | 91.67 | 91.73 | 91.34 | 91.39 | 28700.0 |
| 2002-12-17 09:00:00 | SPY | ETF | 91.43 | 91.59 | 91.34 | 91.34 | 36000.0 |
| 2002-12-17 09:30:00 | SPY | ETF | 91.35 | 91.67 | 91.21 | 91.54 | 3597200.0 |
| 2002-12-17 10:00:00 | SPY | ETF | 91.55 | 91.74 | 91.42 | 91.48 | 2924600.0 |
| 2002-12-17 10:30:00 | SPY | ETF | 91.5 | 91.55 | 90.92 | 91.04 | 3352600.0 |
| 2002-12-17 11:00:00 | SPY | ETF | 91.02 | 91.18 | 90.96 | 91.13 | 2242700.0 |
| 2002-12-17 11:30:00 | SPY | ETF | 91.12 | 91.36 | 91.07 | 91.29 | 1400200.0 |
| 2002-12-17 12:00:00 | SPY | ETF | 91.3 | 91.38 | 91.15 | 91.24 | 933000.0 |
| 2002-12-17 12:30:00 | SPY | ETF | 91.24 | 91.37 | 91.08 | 91.28 | 781300.0 |
| 2002-12-17 13:00:00 | SPY | ETF | 91.28 | 91.38 | 91.08 | 91.11 | 995900.0 |
| 2002-12-17 13:30:00 | SPY | ETF | 91.11 | 91.22 | 91.03 | 91.12 | 1103800.0 |
| 2002-12-17 14:00:00 | SPY | ETF | 91.15 | 91.37 | 91.02 | 91.33 | 1455500.0 |
| 2002-12-17 14:30:00 | SPY | ETF | 91.3 | 91.35 | 91.03 | 91.14 | 1832400.0 |
| 2002-12-17 15:00:00 | SPY | ETF | 91.14 | 91.21 | 90.95 | 91.01 | 1347800.0 |
| 2002-12-17 15:30:00 | SPY | ETF | 91.01 | 91.04 | 90.74 | 90.9 | 3175500.0 |
| 2002-12-17 16:00:00 | SPY | ETF | 90.88 | 90.98 | 90.7 | 90.81 | 1539400.0 |
| 2002-12-17 16:30:00 | SPY | ETF | 90.85 | 91.0 | 90.85 | 90.99 | 131000.0 |
| 2002-12-17 17:00:00 | SPY | ETF | 90.94 | 90.94 | 90.62 | 90.83 | 184300.0 |
| 2002-12-17 17:30:00 | SPY | ETF | 90.82 | 90.87 | 90.74 | 90.83 | 44600.0 |
| 2002-12-17 18:00:00 | SPY | ETF | 90.87 | 90.92 | 90.74 | 90.85 | 8700.0 |
| 2002-12-17 18:30:00 | SPY | ETF | 90.74 | 90.84 | 90.73 | 90.73 | 5400.0 |
| 2002-12-17 19:30:00 | SPY | ETF | 90.87 | 90.87 | 90.8 | 90.8 | 500.0 |
| 2002-12-17 08:00:00 | QQQ | ETF | 25.8 | 25.83 | 25.75 | 25.83 | 24300.0 |
| 2002-12-17 08:30:00 | QQQ | ETF | 25.85 | 25.94 | 25.79 | 25.82 | 85700.0 |
| 2002-12-17 09:00:00 | QQQ | ETF | 25.81 | 25.87 | 25.81 | 25.83 | 47300.0 |
| 2002-12-17 09:30:00 | QQQ | ETF | 25.87 | 26.1 | 25.7 | 26.07 | 9279700.0 |
| 2002-12-17 10:00:00 | QQQ | ETF | 26.07 | 26.2 | 25.91 | 26.06 | 9094500.0 |
| 2002-12-17 10:30:00 | QQQ | ETF | 26.05 | 26.07 | 25.72 | 25.76 | 6986500.0 |
| 2002-12-17 11:00:00 | QQQ | ETF | 25.77 | 25.95 | 25.75 | 25.92 | 4052700.0 |
| 2002-12-17 11:30:00 | QQQ | ETF | 25.93 | 26.03 | 25.84 | 26.02 | 3066300.0 |
| 2002-12-17 12:00:00 | QQQ | ETF | 26.01 | 26.04 | 25.92 | 25.99 | 1130200.0 |
| 2002-12-17 12:30:00 | QQQ | ETF | 25.98 | 26.09 | 25.91 | 26.02 | 1759200.0 |
| 2002-12-17 13:00:00 | QQQ | ETF | 26.02 | 26.08 | 25.94 | 25.97 | 1266800.0 |
| 2002-12-17 13:30:00 | QQQ | ETF | 25.93 | 26.01 | 25.86 | 25.9 | 1762400.0 |
| 2002-12-17 14:00:00 | QQQ | ETF | 25.89 | 25.98 | 25.82 | 25.95 | 2906400.0 |
| 2002-12-17 14:30:00 | QQQ | ETF | 25.95 | 25.98 | 25.82 | 25.86 | 2343900.0 |
| 2002-12-17 15:00:00 | QQQ | ETF | 25.91 | 25.92 | 25.75 | 25.78 | 2689500.0 |
| 2002-12-17 15:30:00 | QQQ | ETF | 25.78 | 25.89 | 25.66 | 25.86 | 6476200.0 |
| 2002-12-17 16:00:00 | QQQ | ETF | 25.87 | 25.95 | 25.78 | 25.92 | 1337100.0 |
| 2002-12-17 16:30:00 | QQQ | ETF | 25.94 | 25.95 | 25.91 | 25.94 | 243400.0 |
| 2002-12-17 17:00:00 | QQQ | ETF | 25.93 | 25.94 | 25.59 | 25.7 | 1572600.0 |
| 2002-12-17 17:30:00 | QQQ | ETF | 25.7 | 25.75 | 25.69 | 25.75 | 39100.0 |
| 2002-12-17 18:00:00 | QQQ | ETF | 25.74 | 25.82 | 25.72 | 25.81 | 90000.0 |
| 2002-12-17 18:30:00 | QQQ | ETF | 25.82 | 25.87 | 25.77 | 25.77 | 100000.0 |
| 2002-12-17 19:00:00 | QQQ | ETF | 25.77 | 25.9 | 25.77 | 25.9 | 141200.0 |
| 2002-12-17 19:30:00 | QQQ | ETF | 25.91 | 25.94 | 25.82 | 25.88 | 48800.0 |
| 2002-12-17 09:30:00 | IWM | ETF | 39.225 | 39.26 | 39.0 | 39.205 | 412800.0 |
| 2002-12-17 10:00:00 | IWM | ETF | 39.16 | 39.27 | 39.1 | 39.205 | 260000.0 |
| 2002-12-17 10:30:00 | IWM | ETF | 39.165 | 39.205 | 39.0 | 39.01 | 133400.0 |
> showing 50 of 645 rows — these rows as CSV