PREVIEW / etf_30min / 2001-07-02
file: by_date/etf_30min/2001/2001-07-02.parquet size: 15 KB rows: 362
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 |
|---|---|---|---|---|---|---|---|
| 2001-07-02 09:30:00 | SPY | ETF | 122.8 | 123.04 | 122.62 | 122.8 | 1341000.0 |
| 2001-07-02 10:00:00 | SPY | ETF | 122.86 | 123.59 | 122.78 | 123.3 | 973000.0 |
| 2001-07-02 10:30:00 | SPY | ETF | 123.38 | 123.57 | 123.18 | 123.47 | 278400.0 |
| 2001-07-02 11:00:00 | SPY | ETF | 123.46 | 124.13 | 123.4 | 123.96 | 697500.0 |
| 2001-07-02 11:30:00 | SPY | ETF | 124.03 | 124.32 | 123.91 | 124.26 | 865600.0 |
| 2001-07-02 12:00:00 | SPY | ETF | 124.23 | 124.25 | 123.91 | 123.96 | 396200.0 |
| 2001-07-02 12:30:00 | SPY | ETF | 123.98 | 124.11 | 123.75 | 123.8 | 278200.0 |
| 2001-07-02 13:00:00 | SPY | ETF | 123.88 | 124.18 | 123.84 | 124.1 | 90900.0 |
| 2001-07-02 13:30:00 | SPY | ETF | 124.14 | 124.25 | 123.85 | 123.86 | 419000.0 |
| 2001-07-02 14:00:00 | SPY | ETF | 123.94 | 124.14 | 123.83 | 124.03 | 146300.0 |
| 2001-07-02 14:30:00 | SPY | ETF | 124.09 | 124.17 | 123.86 | 124.03 | 229600.0 |
| 2001-07-02 15:00:00 | SPY | ETF | 124.01 | 124.22 | 123.93 | 124.09 | 410600.0 |
| 2001-07-02 15:30:00 | SPY | ETF | 124.05 | 124.05 | 123.53 | 123.9 | 1437700.0 |
| 2001-07-02 16:00:00 | SPY | ETF | 123.89 | 124.19 | 123.53 | 123.53 | 488400.0 |
| 2001-07-02 16:30:00 | SPY | ETF | 123.75 | 124.05 | 123.75 | 124.05 | 41000.0 |
| 2001-07-02 17:00:00 | SPY | ETF | 123.97 | 124.13 | 123.97 | 124.13 | 1200.0 |
| 2001-07-02 17:30:00 | SPY | ETF | 124.13 | 124.13 | 124.13 | 124.13 | 100.0 |
| 2001-07-02 18:00:00 | SPY | ETF | 124.0 | 124.0 | 124.0 | 124.0 | 100.0 |
| 2001-07-02 09:30:00 | QQQ | ETF | 45.65 | 45.76 | 45.26 | 45.56 | 5888600.0 |
| 2001-07-02 10:00:00 | QQQ | ETF | 45.58 | 46.09 | 45.45 | 45.91 | 6340300.0 |
| 2001-07-02 10:30:00 | QQQ | ETF | 45.91 | 46.2 | 45.81 | 46.0 | 4741900.0 |
| 2001-07-02 11:00:00 | QQQ | ETF | 46.01 | 46.45 | 45.96 | 46.36 | 7054000.0 |
| 2001-07-02 11:30:00 | QQQ | ETF | 46.36 | 46.48 | 46.26 | 46.35 | 2651600.0 |
| 2001-07-02 12:00:00 | QQQ | ETF | 46.36 | 46.36 | 46.1 | 46.14 | 1908200.0 |
| 2001-07-02 12:30:00 | QQQ | ETF | 46.13 | 46.24 | 45.84 | 45.94 | 2069900.0 |
| 2001-07-02 13:00:00 | QQQ | ETF | 45.93 | 46.1 | 45.86 | 45.92 | 1796000.0 |
| 2001-07-02 13:30:00 | QQQ | ETF | 45.95 | 46.05 | 45.7 | 45.76 | 1887900.0 |
| 2001-07-02 14:00:00 | QQQ | ETF | 45.78 | 45.96 | 45.65 | 45.88 | 1752600.0 |
| 2001-07-02 14:30:00 | QQQ | ETF | 45.86 | 46.01 | 45.71 | 45.89 | 1887500.0 |
| 2001-07-02 15:00:00 | QQQ | ETF | 45.9 | 46.11 | 45.85 | 45.95 | 2401600.0 |
| 2001-07-02 15:30:00 | QQQ | ETF | 45.9 | 45.97 | 45.19 | 45.48 | 6482700.0 |
| 2001-07-02 16:00:00 | QQQ | ETF | 45.45 | 45.69 | 45.35 | 45.54 | 1894100.0 |
| 2001-07-02 16:30:00 | QQQ | ETF | 45.53 | 45.6 | 45.38 | 45.4 | 108200.0 |
| 2001-07-02 17:00:00 | QQQ | ETF | 45.39 | 45.52 | 45.39 | 45.45 | 39200.0 |
| 2001-07-02 17:30:00 | QQQ | ETF | 45.45 | 45.61 | 45.3 | 45.45 | 31900.0 |
| 2001-07-02 18:00:00 | QQQ | ETF | 45.43 | 45.53 | 45.42 | 45.44 | 11300.0 |
| 2001-07-02 09:30:00 | IWM | ETF | 50.8 | 50.8 | 50.07 | 50.075 | 263800.0 |
| 2001-07-02 10:00:00 | IWM | ETF | 50.15 | 50.355 | 50.15 | 50.3 | 119000.0 |
| 2001-07-02 10:30:00 | IWM | ETF | 50.365 | 50.4 | 50.15 | 50.2 | 323600.0 |
| 2001-07-02 11:00:00 | IWM | ETF | 50.2 | 50.425 | 50.2 | 50.425 | 105400.0 |
| 2001-07-02 11:30:00 | IWM | ETF | 50.425 | 50.425 | 50.2 | 50.32 | 212800.0 |
| 2001-07-02 12:00:00 | IWM | ETF | 50.3 | 50.3 | 50.005 | 50.005 | 219200.0 |
| 2001-07-02 12:30:00 | IWM | ETF | 50.05 | 50.075 | 49.8 | 49.8 | 142200.0 |
| 2001-07-02 13:00:00 | IWM | ETF | 49.85 | 50.05 | 49.825 | 50.0 | 75800.0 |
| 2001-07-02 13:30:00 | IWM | ETF | 49.98 | 49.98 | 49.835 | 49.88 | 23400.0 |
| 2001-07-02 14:00:00 | IWM | ETF | 49.875 | 49.95 | 49.75 | 49.95 | 92200.0 |
| 2001-07-02 14:30:00 | IWM | ETF | 49.95 | 49.985 | 49.85 | 49.875 | 147800.0 |
| 2001-07-02 15:00:00 | IWM | ETF | 49.95 | 50.045 | 49.9 | 49.9 | 33200.0 |
| 2001-07-02 15:30:00 | IWM | ETF | 49.97 | 49.97 | 49.685 | 49.685 | 272800.0 |
| 2001-07-02 16:00:00 | IWM | ETF | 49.655 | 49.8 | 49.655 | 49.8 | 18600.0 |
> showing 50 of 362 rows — these rows as CSV