PREVIEW / etf_30min / 2001-08-02
file: by_date/etf_30min/2001/2001-08-02.parquet size: 14 KB rows: 360
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-08-02 09:30:00 | SPY | ETF | 123.23 | 123.25 | 122.1 | 122.81 | 1697800.0 |
| 2001-08-02 10:00:00 | SPY | ETF | 122.82 | 122.92 | 122.17 | 122.5 | 797500.0 |
| 2001-08-02 10:30:00 | SPY | ETF | 122.53 | 122.67 | 122.26 | 122.28 | 655500.0 |
| 2001-08-02 11:00:00 | SPY | ETF | 122.28 | 122.46 | 122.15 | 122.35 | 574900.0 |
| 2001-08-02 11:30:00 | SPY | ETF | 122.35 | 122.55 | 122.31 | 122.48 | 579200.0 |
| 2001-08-02 12:00:00 | SPY | ETF | 122.48 | 122.64 | 122.4 | 122.64 | 152600.0 |
| 2001-08-02 12:30:00 | SPY | ETF | 122.65 | 122.69 | 122.4 | 122.41 | 246400.0 |
| 2001-08-02 13:00:00 | SPY | ETF | 122.44 | 122.47 | 122.28 | 122.45 | 399900.0 |
| 2001-08-02 13:30:00 | SPY | ETF | 122.44 | 122.44 | 121.95 | 122.04 | 899600.0 |
| 2001-08-02 14:00:00 | SPY | ETF | 122.02 | 122.11 | 121.89 | 122.1 | 1087000.0 |
| 2001-08-02 14:30:00 | SPY | ETF | 122.11 | 122.32 | 122.07 | 122.23 | 780000.0 |
| 2001-08-02 15:00:00 | SPY | ETF | 122.2 | 122.27 | 121.96 | 122.15 | 542000.0 |
| 2001-08-02 15:30:00 | SPY | ETF | 122.14 | 122.57 | 122.14 | 122.4 | 1495400.0 |
| 2001-08-02 16:00:00 | SPY | ETF | 122.38 | 122.62 | 122.25 | 122.62 | 802500.0 |
| 2001-08-02 16:30:00 | SPY | ETF | 122.6 | 122.96 | 122.31 | 122.61 | 5300.0 |
| 2001-08-02 17:00:00 | SPY | ETF | 122.12 | 122.68 | 122.12 | 122.63 | 11000.0 |
| 2001-08-02 18:00:00 | SPY | ETF | 122.59 | 122.59 | 122.59 | 122.59 | 100.0 |
| 2001-08-02 09:30:00 | QQQ | ETF | 43.79 | 44.0 | 43.66 | 43.75 | 8645900.0 |
| 2001-08-02 10:00:00 | QQQ | ETF | 43.75 | 43.84 | 43.26 | 43.5 | 5751800.0 |
| 2001-08-02 10:30:00 | QQQ | ETF | 43.53 | 43.69 | 43.26 | 43.3 | 4707400.0 |
| 2001-08-02 11:00:00 | QQQ | ETF | 43.29 | 43.37 | 43.1 | 43.26 | 2809800.0 |
| 2001-08-02 11:30:00 | QQQ | ETF | 43.24 | 43.49 | 43.2 | 43.33 | 1927700.0 |
| 2001-08-02 12:00:00 | QQQ | ETF | 43.34 | 43.56 | 43.26 | 43.54 | 1133600.0 |
| 2001-08-02 12:30:00 | QQQ | ETF | 43.55 | 43.58 | 43.34 | 43.34 | 1631800.0 |
| 2001-08-02 13:00:00 | QQQ | ETF | 43.4 | 43.42 | 43.2 | 43.27 | 1634200.0 |
| 2001-08-02 13:30:00 | QQQ | ETF | 43.24 | 43.26 | 42.82 | 42.92 | 3393000.0 |
| 2001-08-02 14:00:00 | QQQ | ETF | 42.94 | 43.1 | 42.86 | 43.05 | 2275400.0 |
| 2001-08-02 14:30:00 | QQQ | ETF | 43.02 | 43.27 | 43.01 | 43.11 | 2689800.0 |
| 2001-08-02 15:00:00 | QQQ | ETF | 43.11 | 43.2 | 42.93 | 43.1 | 2578300.0 |
| 2001-08-02 15:30:00 | QQQ | ETF | 43.12 | 43.75 | 43.08 | 43.68 | 8153400.0 |
| 2001-08-02 16:00:00 | QQQ | ETF | 43.65 | 43.99 | 43.3 | 43.97 | 2591200.0 |
| 2001-08-02 16:30:00 | QQQ | ETF | 43.96 | 44.05 | 43.85 | 43.92 | 423200.0 |
| 2001-08-02 17:00:00 | QQQ | ETF | 43.92 | 43.95 | 43.9 | 43.91 | 70200.0 |
| 2001-08-02 17:30:00 | QQQ | ETF | 43.93 | 43.95 | 43.89 | 43.9 | 13000.0 |
| 2001-08-02 18:00:00 | QQQ | ETF | 43.94 | 44.03 | 43.88 | 43.97 | 29600.0 |
| 2001-08-02 09:30:00 | IWM | ETF | 49.225 | 49.25 | 49.05 | 49.05 | 370800.0 |
| 2001-08-02 10:00:00 | IWM | ETF | 49.0 | 49.0 | 48.805 | 49.0 | 4000.0 |
| 2001-08-02 10:30:00 | IWM | ETF | 49.025 | 49.025 | 48.975 | 48.975 | 2000.0 |
| 2001-08-02 11:00:00 | IWM | ETF | 48.825 | 48.865 | 48.8 | 48.825 | 4600.0 |
| 2001-08-02 11:30:00 | IWM | ETF | 48.8 | 48.845 | 48.8 | 48.845 | 800.0 |
| 2001-08-02 12:00:00 | IWM | ETF | 48.825 | 48.825 | 48.625 | 48.82 | 22200.0 |
| 2001-08-02 12:30:00 | IWM | ETF | 48.76 | 48.845 | 48.76 | 48.845 | 1400.0 |
| 2001-08-02 13:00:00 | IWM | ETF | 48.75 | 48.85 | 48.63 | 48.82 | 115800.0 |
| 2001-08-02 13:30:00 | IWM | ETF | 48.8 | 48.8 | 48.475 | 48.475 | 600.0 |
| 2001-08-02 14:00:00 | IWM | ETF | 48.645 | 48.65 | 48.45 | 48.45 | 7200.0 |
| 2001-08-02 14:30:00 | IWM | ETF | 48.53 | 48.75 | 48.53 | 48.75 | 5200.0 |
| 2001-08-02 15:00:00 | IWM | ETF | 48.725 | 48.725 | 48.575 | 48.625 | 12400.0 |
| 2001-08-02 15:30:00 | IWM | ETF | 48.625 | 48.795 | 48.45 | 48.75 | 1800.0 |
| 2001-08-02 16:00:00 | IWM | ETF | 48.7 | 48.7 | 48.7 | 48.7 | 4000.0 |
| 2001-08-02 09:30:00 | DIA | ETF | 106.25 | 106.25 | 105.93 | 105.99 | 458100.0 |
> showing 50 of 360 rows — these rows as CSV