PREVIEW / etf_30min / 2003-01-02
file: by_date/etf_30min/2003/2003-01-02.parquet size: 23 KB rows: 662
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 |
|---|---|---|---|---|---|---|---|
| 2003-01-02 08:00:00 | SPY | ETF | 88.88 | 89.06 | 88.84 | 88.84 | 9000.0 |
| 2003-01-02 08:30:00 | SPY | ETF | 88.8 | 89.03 | 88.66 | 88.95 | 12900.0 |
| 2003-01-02 09:00:00 | SPY | ETF | 88.95 | 88.95 | 88.82 | 88.9 | 9500.0 |
| 2003-01-02 09:30:00 | SPY | ETF | 88.85 | 89.4 | 88.55 | 88.7 | 4032400.0 |
| 2003-01-02 10:00:00 | SPY | ETF | 88.7 | 90.24 | 88.58 | 90.24 | 9351400.0 |
| 2003-01-02 10:30:00 | SPY | ETF | 90.22 | 90.44 | 90.11 | 90.35 | 3527900.0 |
| 2003-01-02 11:00:00 | SPY | ETF | 90.35 | 90.48 | 90.04 | 90.24 | 2313600.0 |
| 2003-01-02 11:30:00 | SPY | ETF | 90.25 | 90.4 | 90.1 | 90.36 | 1286600.0 |
| 2003-01-02 12:00:00 | SPY | ETF | 90.36 | 90.7 | 90.33 | 90.43 | 1659100.0 |
| 2003-01-02 12:30:00 | SPY | ETF | 90.47 | 90.59 | 90.39 | 90.53 | 909300.0 |
| 2003-01-02 13:00:00 | SPY | ETF | 90.55 | 90.69 | 90.32 | 90.44 | 2089800.0 |
| 2003-01-02 13:30:00 | SPY | ETF | 90.43 | 90.55 | 90.38 | 90.49 | 972600.0 |
| 2003-01-02 14:00:00 | SPY | ETF | 90.51 | 90.81 | 90.48 | 90.74 | 1526900.0 |
| 2003-01-02 14:30:00 | SPY | ETF | 90.77 | 90.8 | 90.57 | 90.66 | 1286100.0 |
| 2003-01-02 15:00:00 | SPY | ETF | 90.64 | 91.0 | 90.62 | 90.9 | 2030400.0 |
| 2003-01-02 15:30:00 | SPY | ETF | 90.89 | 91.15 | 90.83 | 91.11 | 3371900.0 |
| 2003-01-02 16:00:00 | SPY | ETF | 91.1 | 91.3 | 90.96 | 91.02 | 2053200.0 |
| 2003-01-02 16:30:00 | SPY | ETF | 91.07 | 91.18 | 90.99 | 91.02 | 336700.0 |
| 2003-01-02 17:00:00 | SPY | ETF | 90.98 | 90.98 | 90.79 | 90.96 | 84200.0 |
| 2003-01-02 17:30:00 | SPY | ETF | 90.92 | 91.0 | 90.85 | 90.96 | 114900.0 |
| 2003-01-02 18:00:00 | SPY | ETF | 90.99 | 91.03 | 90.99 | 91.03 | 7500.0 |
| 2003-01-02 18:30:00 | SPY | ETF | 91.05 | 91.1 | 91.05 | 91.1 | 2200.0 |
| 2003-01-02 19:30:00 | SPY | ETF | 91.07 | 91.07 | 91.07 | 91.07 | 2000.0 |
| 2003-01-02 08:00:00 | QQQ | ETF | 24.74 | 24.75 | 24.7 | 24.72 | 36100.0 |
| 2003-01-02 08:30:00 | QQQ | ETF | 24.71 | 24.77 | 24.68 | 24.76 | 98700.0 |
| 2003-01-02 09:00:00 | QQQ | ETF | 24.75 | 24.78 | 24.7 | 24.71 | 67400.0 |
| 2003-01-02 09:30:00 | QQQ | ETF | 24.72 | 24.87 | 24.45 | 24.57 | 7522100.0 |
| 2003-01-02 10:00:00 | QQQ | ETF | 24.57 | 25.14 | 24.54 | 25.11 | 11575900.0 |
| 2003-01-02 10:30:00 | QQQ | ETF | 25.12 | 25.27 | 25.1 | 25.24 | 6191200.0 |
| 2003-01-02 11:00:00 | QQQ | ETF | 25.24 | 25.29 | 25.07 | 25.19 | 3556000.0 |
| 2003-01-02 11:30:00 | QQQ | ETF | 25.23 | 25.28 | 25.15 | 25.28 | 2645100.0 |
| 2003-01-02 12:00:00 | QQQ | ETF | 25.24 | 25.36 | 25.23 | 25.31 | 2912500.0 |
| 2003-01-02 12:30:00 | QQQ | ETF | 25.31 | 25.39 | 25.3 | 25.32 | 2596200.0 |
| 2003-01-02 13:00:00 | QQQ | ETF | 25.34 | 25.4 | 25.25 | 25.28 | 3466600.0 |
| 2003-01-02 13:30:00 | QQQ | ETF | 25.29 | 25.34 | 25.25 | 25.29 | 1500600.0 |
| 2003-01-02 14:00:00 | QQQ | ETF | 25.31 | 25.5 | 25.29 | 25.46 | 3297900.0 |
| 2003-01-02 14:30:00 | QQQ | ETF | 25.47 | 25.49 | 25.34 | 25.4 | 2409200.0 |
| 2003-01-02 15:00:00 | QQQ | ETF | 25.43 | 25.53 | 25.38 | 25.49 | 4062800.0 |
| 2003-01-02 15:30:00 | QQQ | ETF | 25.49 | 25.55 | 25.45 | 25.5 | 4109300.0 |
| 2003-01-02 16:00:00 | QQQ | ETF | 25.52 | 25.53 | 25.39 | 25.48 | 2595500.0 |
| 2003-01-02 16:30:00 | QQQ | ETF | 25.48 | 25.48 | 25.4 | 25.45 | 156800.0 |
| 2003-01-02 17:00:00 | QQQ | ETF | 25.43 | 25.48 | 25.29 | 25.35 | 432900.0 |
| 2003-01-02 17:30:00 | QQQ | ETF | 25.34 | 25.45 | 25.34 | 25.44 | 364900.0 |
| 2003-01-02 18:00:00 | QQQ | ETF | 25.43 | 25.44 | 25.4 | 25.4 | 30500.0 |
| 2003-01-02 18:30:00 | QQQ | ETF | 25.44 | 25.44 | 25.4 | 25.42 | 8800.0 |
| 2003-01-02 19:00:00 | QQQ | ETF | 25.4 | 25.43 | 25.4 | 25.43 | 3600.0 |
| 2003-01-02 19:30:00 | QQQ | ETF | 25.44 | 25.44 | 25.44 | 25.44 | 4200.0 |
| 2003-01-02 09:30:00 | IWM | ETF | 38.25 | 38.44 | 38.035 | 38.12 | 225800.0 |
| 2003-01-02 10:00:00 | IWM | ETF | 38.17 | 38.5 | 38.17 | 38.48 | 561000.0 |
| 2003-01-02 10:30:00 | IWM | ETF | 38.495 | 38.625 | 38.495 | 38.625 | 129800.0 |
> showing 50 of 662 rows — these rows as CSV