PREVIEW / etf_30min / 2003-09-02
file: by_date/etf_30min/2003/2003-09-02.parquet size: 25 KB rows: 756
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-09-02 08:00:00 | SPY | ETF | 101.76 | 101.76 | 101.76 | 101.76 | 500.0 |
| 2003-09-02 08:30:00 | SPY | ETF | 101.76 | 101.76 | 101.65 | 101.71 | 25800.0 |
| 2003-09-02 09:00:00 | SPY | ETF | 101.72 | 101.79 | 101.6 | 101.6 | 39000.0 |
| 2003-09-02 09:30:00 | SPY | ETF | 101.64 | 101.93 | 101.58 | 101.73 | 4831200.0 |
| 2003-09-02 10:00:00 | SPY | ETF | 101.75 | 101.85 | 101.06 | 101.28 | 5068100.0 |
| 2003-09-02 10:30:00 | SPY | ETF | 101.28 | 101.429 | 101.2 | 101.4 | 2204200.0 |
| 2003-09-02 11:00:00 | SPY | ETF | 101.36 | 101.78 | 101.36 | 101.714 | 2136200.0 |
| 2003-09-02 11:30:00 | SPY | ETF | 101.72 | 101.74 | 101.47 | 101.5 | 1439500.0 |
| 2003-09-02 12:00:00 | SPY | ETF | 101.5 | 102.127 | 101.48 | 101.93 | 2960300.0 |
| 2003-09-02 12:30:00 | SPY | ETF | 101.927 | 102.14 | 101.85 | 101.92 | 1457000.0 |
| 2003-09-02 13:00:00 | SPY | ETF | 101.95 | 102.04 | 101.84 | 101.85 | 794400.0 |
| 2003-09-02 13:30:00 | SPY | ETF | 101.88 | 102.02 | 101.63 | 101.69 | 1982500.0 |
| 2003-09-02 14:00:00 | SPY | ETF | 101.7 | 102.0 | 101.65 | 101.86 | 1255700.0 |
| 2003-09-02 14:30:00 | SPY | ETF | 101.88 | 102.52 | 101.84 | 102.5 | 5842000.0 |
| 2003-09-02 15:00:00 | SPY | ETF | 102.493 | 102.86 | 102.46 | 102.85 | 4658400.0 |
| 2003-09-02 15:30:00 | SPY | ETF | 102.85 | 102.88 | 102.56 | 102.77 | 3626300.0 |
| 2003-09-02 16:00:00 | SPY | ETF | 102.8 | 102.96 | 102.7 | 102.96 | 1957700.0 |
| 2003-09-02 16:30:00 | SPY | ETF | 102.81 | 102.99 | 102.81 | 102.88 | 408700.0 |
| 2003-09-02 17:00:00 | SPY | ETF | 102.88 | 102.888 | 102.82 | 102.83 | 8400.0 |
| 2003-09-02 17:30:00 | SPY | ETF | 102.85 | 102.89 | 102.85 | 102.87 | 1412800.0 |
| 2003-09-02 18:00:00 | SPY | ETF | 102.87 | 102.96 | 102.87 | 102.92 | 23000.0 |
| 2003-09-02 18:30:00 | SPY | ETF | 102.92 | 102.92 | 102.92 | 102.92 | 100.0 |
| 2003-09-02 19:00:00 | SPY | ETF | 102.86 | 102.86 | 102.86 | 102.86 | 100.0 |
| 2003-09-02 19:30:00 | SPY | ETF | 102.86 | 102.9 | 102.85 | 102.9 | 2400.0 |
| 2003-09-02 08:00:00 | QQQ | ETF | 33.61 | 33.61 | 33.55 | 33.58 | 63300.0 |
| 2003-09-02 08:30:00 | QQQ | ETF | 33.58 | 33.58 | 33.52 | 33.53 | 82600.0 |
| 2003-09-02 09:00:00 | QQQ | ETF | 33.54 | 33.55 | 33.48 | 33.48 | 58500.0 |
| 2003-09-02 09:30:00 | QQQ | ETF | 33.49 | 33.625 | 33.41 | 33.488 | 9639700.0 |
| 2003-09-02 10:00:00 | QQQ | ETF | 33.499 | 33.55 | 33.13 | 33.25 | 9984400.0 |
| 2003-09-02 10:30:00 | QQQ | ETF | 33.25 | 33.34 | 33.21 | 33.32 | 5400200.0 |
| 2003-09-02 11:00:00 | QQQ | ETF | 33.31 | 33.45 | 33.28 | 33.421 | 4217400.0 |
| 2003-09-02 11:30:00 | QQQ | ETF | 33.42 | 33.445 | 33.3 | 33.3 | 2373400.0 |
| 2003-09-02 12:00:00 | QQQ | ETF | 33.301 | 33.54 | 33.3 | 33.41 | 3757200.0 |
| 2003-09-02 12:30:00 | QQQ | ETF | 33.42 | 33.52 | 33.399 | 33.41 | 1941400.0 |
| 2003-09-02 13:00:00 | QQQ | ETF | 33.43 | 33.49 | 33.4 | 33.44 | 3144900.0 |
| 2003-09-02 13:30:00 | QQQ | ETF | 33.44 | 33.497 | 33.36 | 33.38 | 1960000.0 |
| 2003-09-02 14:00:00 | QQQ | ETF | 33.38 | 33.5 | 33.37 | 33.462 | 2282300.0 |
| 2003-09-02 14:30:00 | QQQ | ETF | 33.464 | 33.68 | 33.46 | 33.67 | 10077200.0 |
| 2003-09-02 15:00:00 | QQQ | ETF | 33.67 | 33.82 | 33.65 | 33.8 | 8475900.0 |
| 2003-09-02 15:30:00 | QQQ | ETF | 33.8 | 33.86 | 33.69 | 33.829 | 8256700.0 |
| 2003-09-02 16:00:00 | QQQ | ETF | 33.83 | 33.929 | 33.79 | 33.929 | 1802300.0 |
| 2003-09-02 16:30:00 | QQQ | ETF | 33.91 | 33.92 | 33.851 | 33.91 | 356200.0 |
| 2003-09-02 17:00:00 | QQQ | ETF | 33.91 | 33.93 | 33.88 | 33.91 | 102200.0 |
| 2003-09-02 17:30:00 | QQQ | ETF | 33.908 | 33.92 | 33.875 | 33.888 | 269300.0 |
| 2003-09-02 18:00:00 | QQQ | ETF | 33.88 | 33.92 | 33.88 | 33.9 | 18200.0 |
| 2003-09-02 18:30:00 | QQQ | ETF | 33.9 | 33.92 | 33.87 | 33.87 | 11500.0 |
| 2003-09-02 19:00:00 | QQQ | ETF | 33.87 | 33.9 | 33.87 | 33.9 | 1900.0 |
| 2003-09-02 19:30:00 | QQQ | ETF | 33.92 | 33.93 | 33.9 | 33.92 | 10500.0 |
| 2003-09-02 08:30:00 | IWM | ETF | 49.695 | 49.695 | 49.695 | 49.695 | 400.0 |
| 2003-09-02 09:30:00 | IWM | ETF | 49.875 | 49.965 | 49.725 | 49.8 | 1058600.0 |
> showing 50 of 756 rows — these rows as CSV