PREVIEW / etf_30min / 2005-05-02
file: by_date/etf_30min/2005/2005-05-02.parquet size: 43 KB rows: 1,472
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-02 06:30:00 | SPY | ETF | 116.09 | 116.09 | 116.09 | 116.09 | 500.0 |
| 2005-05-02 07:00:00 | SPY | ETF | 116.2 | 116.2 | 116.17 | 116.17 | 35100.0 |
| 2005-05-02 07:30:00 | SPY | ETF | 116.12 | 116.24 | 116.12 | 116.21 | 54600.0 |
| 2005-05-02 08:00:00 | SPY | ETF | 116.16 | 116.17 | 116.08 | 116.11 | 35200.0 |
| 2005-05-02 08:30:00 | SPY | ETF | 116.1 | 116.15 | 116.02 | 116.15 | 44300.0 |
| 2005-05-02 09:00:00 | SPY | ETF | 116.13 | 116.13 | 116.0 | 116.03 | 69700.0 |
| 2005-05-02 09:30:00 | SPY | ETF | 116.07 | 116.34 | 116.0 | 116.32 | 5768000.0 |
| 2005-05-02 10:00:00 | SPY | ETF | 116.32 | 116.41 | 116.1169 | 116.14 | 10798600.0 |
| 2005-05-02 10:30:00 | SPY | ETF | 116.15 | 116.28 | 116.01 | 116.14 | 3438600.0 |
| 2005-05-02 11:00:00 | SPY | ETF | 116.14 | 116.3667 | 115.95 | 116.05 | 2297600.0 |
| 2005-05-02 11:30:00 | SPY | ETF | 116.05 | 116.08 | 115.82 | 115.98 | 2522800.0 |
| 2005-05-02 12:00:00 | SPY | ETF | 115.972 | 116.1 | 115.88 | 116.05 | 2442400.0 |
| 2005-05-02 12:30:00 | SPY | ETF | 116.04 | 116.07 | 115.94 | 115.99 | 1122800.0 |
| 2005-05-02 13:00:00 | SPY | ETF | 115.98 | 116.01 | 115.83 | 115.86 | 1422000.0 |
| 2005-05-02 13:30:00 | SPY | ETF | 115.86 | 115.98 | 115.77 | 115.86 | 3265000.0 |
| 2005-05-02 14:00:00 | SPY | ETF | 115.86 | 115.9 | 115.52 | 115.72 | 5723500.0 |
| 2005-05-02 14:30:00 | SPY | ETF | 115.72 | 116.04 | 115.69 | 115.91 | 4959700.0 |
| 2005-05-02 15:00:00 | SPY | ETF | 115.92 | 116.16 | 115.82 | 116.15 | 2694000.0 |
| 2005-05-02 15:30:00 | SPY | ETF | 116.13 | 116.38 | 116.1 | 116.33 | 4804000.0 |
| 2005-05-02 16:00:00 | SPY | ETF | 116.38 | 116.41 | 115.97 | 116.38 | 723800.0 |
| 2005-05-02 16:30:00 | SPY | ETF | 116.37 | 116.38 | 116.35 | 116.35 | 11800.0 |
| 2005-05-02 17:00:00 | SPY | ETF | 116.31 | 116.32 | 116.31 | 116.32 | 1300.0 |
| 2005-05-02 17:30:00 | SPY | ETF | 116.35 | 116.35 | 116.31 | 116.31 | 1700.0 |
| 2005-05-02 18:30:00 | SPY | ETF | 116.32 | 116.32 | 116.32 | 116.32 | 500.0 |
| 2005-05-02 19:00:00 | SPY | ETF | 116.32 | 116.33 | 116.32 | 116.33 | 2200.0 |
| 2005-05-02 19:30:00 | SPY | ETF | 116.33 | 116.33 | 116.33 | 116.33 | 900.0 |
| 2005-05-02 09:30:00 | QQQ | ETF | 35.1 | 35.22 | 35.07 | 35.2 | 8433800.0 |
| 2005-05-02 10:00:00 | QQQ | ETF | 35.2 | 35.25 | 35.01 | 35.13 | 12466800.0 |
| 2005-05-02 10:30:00 | QQQ | ETF | 35.13 | 35.19 | 35.09 | 35.12 | 4276700.0 |
| 2005-05-02 11:00:00 | QQQ | ETF | 35.12 | 35.26 | 35.07 | 35.11 | 3274800.0 |
| 2005-05-02 11:30:00 | QQQ | ETF | 35.1 | 35.13 | 34.9 | 35.08 | 3152400.0 |
| 2005-05-02 12:00:00 | QQQ | ETF | 35.07 | 35.17 | 35.05 | 35.14 | 3064000.0 |
| 2005-05-02 12:30:00 | QQQ | ETF | 35.14 | 35.15 | 35.1 | 35.12 | 1742500.0 |
| 2005-05-02 13:00:00 | QQQ | ETF | 35.12 | 35.12 | 35.04 | 35.04 | 1654200.0 |
| 2005-05-02 13:30:00 | QQQ | ETF | 35.04 | 35.07 | 35.01 | 35.03 | 2754900.0 |
| 2005-05-02 14:00:00 | QQQ | ETF | 35.02 | 35.02 | 34.89 | 34.9 | 7491800.0 |
| 2005-05-02 14:30:00 | QQQ | ETF | 34.91 | 34.99 | 34.9 | 34.97 | 3244600.0 |
| 2005-05-02 15:00:00 | QQQ | ETF | 34.97 | 35.05 | 34.93 | 35.05 | 4020800.0 |
| 2005-05-02 15:30:00 | QQQ | ETF | 35.04 | 35.11 | 35.0 | 35.1 | 6514700.0 |
| 2005-05-02 07:30:00 | IWM | ETF | 57.9 | 57.9 | 57.9 | 57.9 | 9800.0 |
| 2005-05-02 08:00:00 | IWM | ETF | 57.86 | 57.86 | 57.85 | 57.85 | 400.0 |
| 2005-05-02 08:30:00 | IWM | ETF | 57.8 | 57.82 | 57.8 | 57.82 | 1200.0 |
| 2005-05-02 09:00:00 | IWM | ETF | 57.845 | 57.845 | 57.75 | 57.75 | 4800.0 |
| 2005-05-02 09:30:00 | IWM | ETF | 57.78 | 58.03 | 57.7 | 58.015 | 3560400.0 |
| 2005-05-02 10:00:00 | IWM | ETF | 58.015 | 58.225 | 57.915 | 57.93 | 4187400.0 |
| 2005-05-02 10:30:00 | IWM | ETF | 57.915 | 58.08 | 57.865 | 58.0 | 1239800.0 |
| 2005-05-02 11:00:00 | IWM | ETF | 57.975 | 57.995 | 57.755 | 57.805 | 1090200.0 |
| 2005-05-02 11:30:00 | IWM | ETF | 57.805 | 57.92 | 57.7 | 57.895 | 1404000.0 |
| 2005-05-02 12:00:00 | IWM | ETF | 57.905 | 57.915 | 57.765 | 57.825 | 442600.0 |
| 2005-05-02 12:30:00 | IWM | ETF | 57.83 | 57.915 | 57.797 | 57.875 | 457200.0 |
> showing 50 of 1,472 rows — these rows as CSV