PREVIEW / etf_30min / 2001-10-02
file: by_date/etf_30min/2001/2001-10-02.parquet size: 16 KB rows: 427
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-10-02 09:30:00 | SPY | ETF | 104.0 | 104.53 | 103.85 | 104.29 | 2014600.0 |
| 2001-10-02 10:00:00 | SPY | ETF | 104.25 | 104.44 | 103.97 | 104.23 | 1079700.0 |
| 2001-10-02 10:30:00 | SPY | ETF | 104.23 | 104.55 | 104.22 | 104.4 | 738500.0 |
| 2001-10-02 11:00:00 | SPY | ETF | 104.35 | 104.87 | 104.28 | 104.81 | 1284400.0 |
| 2001-10-02 11:30:00 | SPY | ETF | 104.8 | 104.88 | 104.63 | 104.77 | 568100.0 |
| 2001-10-02 12:00:00 | SPY | ETF | 104.75 | 104.81 | 104.58 | 104.66 | 724000.0 |
| 2001-10-02 12:30:00 | SPY | ETF | 104.7 | 104.83 | 104.62 | 104.62 | 223900.0 |
| 2001-10-02 13:00:00 | SPY | ETF | 104.68 | 104.7 | 104.42 | 104.5 | 437800.0 |
| 2001-10-02 13:30:00 | SPY | ETF | 104.55 | 104.55 | 104.26 | 104.44 | 1743100.0 |
| 2001-10-02 14:00:00 | SPY | ETF | 104.44 | 104.75 | 103.8 | 104.1 | 2568800.0 |
| 2001-10-02 14:30:00 | SPY | ETF | 104.1 | 104.3 | 103.65 | 103.73 | 2147700.0 |
| 2001-10-02 15:00:00 | SPY | ETF | 103.67 | 104.83 | 103.65 | 104.7 | 2030800.0 |
| 2001-10-02 15:30:00 | SPY | ETF | 104.7 | 105.38 | 104.59 | 105.38 | 2294100.0 |
| 2001-10-02 16:00:00 | SPY | ETF | 105.35 | 105.7 | 104.45 | 105.7 | 1401300.0 |
| 2001-10-02 16:30:00 | SPY | ETF | 105.58 | 105.7 | 105.45 | 105.45 | 8900.0 |
| 2001-10-02 17:00:00 | SPY | ETF | 105.45 | 105.53 | 105.45 | 105.53 | 3000.0 |
| 2001-10-02 17:30:00 | SPY | ETF | 105.55 | 105.55 | 105.55 | 105.55 | 400.0 |
| 2001-10-02 18:00:00 | SPY | ETF | 105.55 | 105.55 | 105.55 | 105.55 | 500.0 |
| 2001-10-02 09:30:00 | QQQ | ETF | 28.65 | 29.11 | 28.55 | 29.1 | 10200900.0 |
| 2001-10-02 10:00:00 | QQQ | ETF | 29.08 | 29.29 | 28.92 | 29.08 | 4493500.0 |
| 2001-10-02 10:30:00 | QQQ | ETF | 29.09 | 29.2 | 29.05 | 29.12 | 4787800.0 |
| 2001-10-02 11:00:00 | QQQ | ETF | 29.1 | 29.41 | 29.05 | 29.34 | 6071700.0 |
| 2001-10-02 11:30:00 | QQQ | ETF | 29.32 | 29.35 | 29.15 | 29.2 | 2340200.0 |
| 2001-10-02 12:00:00 | QQQ | ETF | 29.22 | 29.25 | 29.14 | 29.2 | 1894100.0 |
| 2001-10-02 12:30:00 | QQQ | ETF | 29.19 | 29.28 | 29.1 | 29.12 | 2491800.0 |
| 2001-10-02 13:00:00 | QQQ | ETF | 29.11 | 29.15 | 29.01 | 29.03 | 1778900.0 |
| 2001-10-02 13:30:00 | QQQ | ETF | 29.01 | 29.09 | 28.94 | 29.06 | 2635000.0 |
| 2001-10-02 14:00:00 | QQQ | ETF | 29.06 | 29.21 | 28.55 | 28.74 | 11680500.0 |
| 2001-10-02 14:30:00 | QQQ | ETF | 28.74 | 28.89 | 28.4 | 28.44 | 9142700.0 |
| 2001-10-02 15:00:00 | QQQ | ETF | 28.45 | 28.9 | 28.41 | 28.74 | 6607700.0 |
| 2001-10-02 15:30:00 | QQQ | ETF | 28.8 | 28.98 | 28.65 | 28.85 | 6386500.0 |
| 2001-10-02 16:00:00 | QQQ | ETF | 28.85 | 28.89 | 28.75 | 28.82 | 1521900.0 |
| 2001-10-02 16:30:00 | QQQ | ETF | 28.81 | 28.83 | 28.74 | 28.75 | 111300.0 |
| 2001-10-02 17:00:00 | QQQ | ETF | 28.75 | 28.81 | 28.75 | 28.8 | 26300.0 |
| 2001-10-02 17:30:00 | QQQ | ETF | 28.77 | 28.82 | 28.7 | 28.8 | 52900.0 |
| 2001-10-02 18:00:00 | QQQ | ETF | 28.8 | 28.86 | 28.8 | 28.8 | 15600.0 |
| 2001-10-02 09:30:00 | IWM | ETF | 39.55 | 39.925 | 39.55 | 39.925 | 15000.0 |
| 2001-10-02 10:00:00 | IWM | ETF | 39.825 | 39.925 | 39.725 | 39.8 | 31400.0 |
| 2001-10-02 10:30:00 | IWM | ETF | 39.89 | 39.89 | 39.77 | 39.77 | 14200.0 |
| 2001-10-02 11:00:00 | IWM | ETF | 39.85 | 40.04 | 39.85 | 40.04 | 10800.0 |
| 2001-10-02 11:30:00 | IWM | ETF | 39.89 | 39.965 | 39.84 | 39.93 | 6400.0 |
| 2001-10-02 12:00:00 | IWM | ETF | 39.855 | 39.93 | 39.8 | 39.805 | 37200.0 |
| 2001-10-02 12:30:00 | IWM | ETF | 39.81 | 39.87 | 39.78 | 39.85 | 58000.0 |
| 2001-10-02 13:00:00 | IWM | ETF | 39.86 | 39.87 | 39.795 | 39.795 | 50600.0 |
| 2001-10-02 13:30:00 | IWM | ETF | 39.705 | 39.8 | 39.705 | 39.765 | 6200.0 |
| 2001-10-02 14:00:00 | IWM | ETF | 39.83 | 39.9 | 39.5 | 39.71 | 168600.0 |
| 2001-10-02 14:30:00 | IWM | ETF | 39.7 | 40.0 | 39.6 | 40.0 | 174400.0 |
| 2001-10-02 15:00:00 | IWM | ETF | 39.575 | 39.995 | 39.575 | 39.995 | 123600.0 |
| 2001-10-02 15:30:00 | IWM | ETF | 39.965 | 40.115 | 39.92 | 40.0 | 140600.0 |
| 2001-10-02 16:00:00 | IWM | ETF | 40.125 | 40.185 | 40.0 | 40.125 | 240800.0 |
> showing 50 of 427 rows — these rows as CSV