PREVIEW / etf_30min / 2002-12-09
file: by_date/etf_30min/2002/2002-12-09.parquet size: 22 KB rows: 631
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-09 08:00:00 | SPY | ETF | 91.2 | 91.27 | 91.13 | 91.15 | 3200.0 |
| 2002-12-09 08:30:00 | SPY | ETF | 91.18 | 91.22 | 91.13 | 91.18 | 7600.0 |
| 2002-12-09 09:00:00 | SPY | ETF | 91.13 | 91.14 | 91.08 | 91.1 | 22200.0 |
| 2002-12-09 09:30:00 | SPY | ETF | 91.07 | 91.46 | 90.9 | 91.44 | 2949800.0 |
| 2002-12-09 10:00:00 | SPY | ETF | 91.41 | 91.44 | 90.85 | 90.95 | 2406600.0 |
| 2002-12-09 10:30:00 | SPY | ETF | 90.94 | 91.19 | 90.76 | 90.82 | 2341000.0 |
| 2002-12-09 11:00:00 | SPY | ETF | 90.77 | 90.94 | 90.6 | 90.6 | 2069000.0 |
| 2002-12-09 11:30:00 | SPY | ETF | 90.63 | 90.82 | 90.25 | 90.45 | 3268400.0 |
| 2002-12-09 12:00:00 | SPY | ETF | 90.45 | 90.46 | 90.23 | 90.35 | 1094800.0 |
| 2002-12-09 12:30:00 | SPY | ETF | 90.37 | 90.57 | 90.19 | 90.54 | 1552100.0 |
| 2002-12-09 13:00:00 | SPY | ETF | 90.54 | 90.55 | 90.25 | 90.37 | 1793600.0 |
| 2002-12-09 13:30:00 | SPY | ETF | 90.34 | 90.45 | 90.05 | 90.1 | 1824700.0 |
| 2002-12-09 14:00:00 | SPY | ETF | 90.1 | 90.73 | 90.1 | 90.63 | 1728300.0 |
| 2002-12-09 14:30:00 | SPY | ETF | 90.67 | 90.75 | 90.29 | 90.4 | 1565700.0 |
| 2002-12-09 15:00:00 | SPY | ETF | 90.4 | 90.55 | 89.97 | 90.06 | 2337800.0 |
| 2002-12-09 15:30:00 | SPY | ETF | 90.09 | 90.15 | 89.62 | 89.67 | 4631000.0 |
| 2002-12-09 16:00:00 | SPY | ETF | 89.73 | 89.84 | 89.35 | 89.43 | 1739200.0 |
| 2002-12-09 16:30:00 | SPY | ETF | 89.43 | 89.75 | 89.42 | 89.57 | 714300.0 |
| 2002-12-09 17:00:00 | SPY | ETF | 89.57 | 89.72 | 89.56 | 89.67 | 272400.0 |
| 2002-12-09 17:30:00 | SPY | ETF | 89.66 | 89.73 | 89.66 | 89.7 | 3000.0 |
| 2002-12-09 18:00:00 | SPY | ETF | 89.66 | 89.77 | 89.66 | 89.71 | 7500.0 |
| 2002-12-09 18:30:00 | SPY | ETF | 89.74 | 89.8 | 89.68 | 89.68 | 13200.0 |
| 2002-12-09 19:00:00 | SPY | ETF | 89.79 | 89.89 | 89.7 | 89.89 | 55800.0 |
| 2002-12-09 19:30:00 | SPY | ETF | 89.88 | 89.88 | 89.75 | 89.75 | 4000.0 |
| 2002-12-09 08:00:00 | QQQ | ETF | 26.23 | 26.26 | 26.2 | 26.2 | 18500.0 |
| 2002-12-09 08:30:00 | QQQ | ETF | 26.21 | 26.24 | 26.16 | 26.18 | 47700.0 |
| 2002-12-09 09:00:00 | QQQ | ETF | 26.17 | 26.22 | 26.15 | 26.2 | 19700.0 |
| 2002-12-09 09:30:00 | QQQ | ETF | 26.22 | 26.27 | 26.06 | 26.22 | 9746000.0 |
| 2002-12-09 10:00:00 | QQQ | ETF | 26.22 | 26.25 | 25.9 | 25.92 | 8819800.0 |
| 2002-12-09 10:30:00 | QQQ | ETF | 25.92 | 25.96 | 25.72 | 25.77 | 6292100.0 |
| 2002-12-09 11:00:00 | QQQ | ETF | 25.75 | 25.83 | 25.68 | 25.7 | 4239100.0 |
| 2002-12-09 11:30:00 | QQQ | ETF | 25.7 | 25.73 | 25.51 | 25.62 | 5285800.0 |
| 2002-12-09 12:00:00 | QQQ | ETF | 25.59 | 25.63 | 25.5 | 25.57 | 2893500.0 |
| 2002-12-09 12:30:00 | QQQ | ETF | 25.58 | 25.69 | 25.53 | 25.68 | 3497900.0 |
| 2002-12-09 13:00:00 | QQQ | ETF | 25.68 | 25.7 | 25.53 | 25.57 | 1897300.0 |
| 2002-12-09 13:30:00 | QQQ | ETF | 25.56 | 25.62 | 25.42 | 25.48 | 3021000.0 |
| 2002-12-09 14:00:00 | QQQ | ETF | 25.5 | 25.72 | 25.46 | 25.65 | 6362500.0 |
| 2002-12-09 14:30:00 | QQQ | ETF | 25.65 | 25.7 | 25.49 | 25.52 | 3800800.0 |
| 2002-12-09 15:00:00 | QQQ | ETF | 25.53 | 25.59 | 25.39 | 25.45 | 4307700.0 |
| 2002-12-09 15:30:00 | QQQ | ETF | 25.43 | 25.49 | 25.25 | 25.3 | 7503800.0 |
| 2002-12-09 16:00:00 | QQQ | ETF | 25.3 | 25.3 | 25.2 | 25.22 | 2120400.0 |
| 2002-12-09 16:30:00 | QQQ | ETF | 25.23 | 25.25 | 25.2 | 25.24 | 112500.0 |
| 2002-12-09 17:00:00 | QQQ | ETF | 25.24 | 25.27 | 25.2 | 25.24 | 75800.0 |
| 2002-12-09 17:30:00 | QQQ | ETF | 25.25 | 25.29 | 25.23 | 25.28 | 45900.0 |
| 2002-12-09 18:00:00 | QQQ | ETF | 25.26 | 25.31 | 25.26 | 25.3 | 34100.0 |
| 2002-12-09 18:30:00 | QQQ | ETF | 25.28 | 25.37 | 25.28 | 25.35 | 36400.0 |
| 2002-12-09 19:00:00 | QQQ | ETF | 25.33 | 25.41 | 25.32 | 25.41 | 208200.0 |
| 2002-12-09 19:30:00 | QQQ | ETF | 25.37 | 25.37 | 25.3 | 25.33 | 15200.0 |
| 2002-12-09 09:00:00 | IWM | ETF | 39.495 | 39.495 | 39.405 | 39.405 | 4000.0 |
| 2002-12-09 09:30:00 | IWM | ETF | 39.265 | 39.375 | 39.21 | 39.375 | 92400.0 |
> showing 50 of 631 rows — these rows as CSV