PREVIEW / etf_30min / 2005-02-22
file: by_date/etf_30min/2005/2005-02-22.parquet size: 46 KB rows: 1,510
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-02-22 08:00:00 | SPY | ETF | 119.86 | 119.88 | 119.84 | 119.85 | 36000.0 |
| 2005-02-22 08:30:00 | SPY | ETF | 119.85 | 119.91 | 119.83 | 119.9 | 290900.0 |
| 2005-02-22 09:00:00 | SPY | ETF | 119.9 | 119.95 | 119.83 | 119.89 | 236100.0 |
| 2005-02-22 09:30:00 | SPY | ETF | 119.9 | 119.95 | 119.76 | 119.91 | 5874900.0 |
| 2005-02-22 10:00:00 | SPY | ETF | 119.91 | 120.2 | 119.77 | 120.11 | 6353400.0 |
| 2005-02-22 10:30:00 | SPY | ETF | 120.11 | 120.47 | 120.09 | 120.26 | 6669700.0 |
| 2005-02-22 11:00:00 | SPY | ETF | 120.26 | 120.29 | 119.96 | 119.99 | 3965700.0 |
| 2005-02-22 11:30:00 | SPY | ETF | 119.99 | 120.1 | 119.88 | 119.92 | 2614300.0 |
| 2005-02-22 12:00:00 | SPY | ETF | 119.92 | 120.07 | 119.3 | 119.45 | 7475000.0 |
| 2005-02-22 12:30:00 | SPY | ETF | 119.45 | 119.46 | 119.27 | 119.4 | 7251400.0 |
| 2005-02-22 13:00:00 | SPY | ETF | 119.4 | 120.3576 | 119.31 | 119.43 | 3926400.0 |
| 2005-02-22 13:30:00 | SPY | ETF | 119.43 | 119.45 | 119.19 | 119.25 | 4321300.0 |
| 2005-02-22 14:00:00 | SPY | ETF | 119.25 | 119.25 | 118.87 | 119.02 | 7577800.0 |
| 2005-02-22 14:30:00 | SPY | ETF | 119.03 | 119.1 | 118.92 | 118.93 | 3448800.0 |
| 2005-02-22 15:00:00 | SPY | ETF | 118.94 | 119.375 | 118.68 | 118.732 | 5134200.0 |
| 2005-02-22 15:30:00 | SPY | ETF | 118.74 | 118.81 | 118.58 | 118.59 | 6467700.0 |
| 2005-02-22 16:00:00 | SPY | ETF | 118.59 | 118.68 | 118.57 | 118.65 | 1641900.0 |
| 2005-02-22 16:30:00 | SPY | ETF | 118.65 | 119.03 | 118.61 | 118.62 | 67200.0 |
| 2005-02-22 17:00:00 | SPY | ETF | 118.65 | 118.65 | 118.6 | 118.61 | 55000.0 |
| 2005-02-22 17:30:00 | SPY | ETF | 118.62 | 118.7 | 118.56 | 118.7 | 77300.0 |
| 2005-02-22 18:00:00 | SPY | ETF | 118.62 | 118.66 | 118.6 | 118.65 | 10700.0 |
| 2005-02-22 18:30:00 | SPY | ETF | 118.65 | 118.7 | 118.65 | 118.7 | 7200.0 |
| 2005-02-22 19:00:00 | SPY | ETF | 118.68 | 118.68 | 118.68 | 118.68 | 10000.0 |
| 2005-02-22 19:30:00 | SPY | ETF | 118.66 | 118.68 | 118.66 | 118.68 | 1200.0 |
| 2005-02-22 09:30:00 | QQQ | ETF | 37.03 | 37.11 | 36.96 | 37.08 | 15247400.0 |
| 2005-02-22 10:00:00 | QQQ | ETF | 37.09 | 37.42 | 37.03 | 37.33 | 14442300.0 |
| 2005-02-22 10:30:00 | QQQ | ETF | 37.33 | 37.55 | 37.32 | 37.37 | 10119400.0 |
| 2005-02-22 11:00:00 | QQQ | ETF | 37.37 | 37.37 | 37.26 | 37.29 | 5177200.0 |
| 2005-02-22 11:30:00 | QQQ | ETF | 37.29 | 37.37 | 37.27 | 37.32 | 5911500.0 |
| 2005-02-22 12:00:00 | QQQ | ETF | 37.32 | 37.41 | 37.01 | 37.1 | 7831300.0 |
| 2005-02-22 12:30:00 | QQQ | ETF | 37.1 | 37.12 | 37.01 | 37.1 | 5360200.0 |
| 2005-02-22 13:00:00 | QQQ | ETF | 37.1 | 37.2 | 37.04 | 37.16 | 6580200.0 |
| 2005-02-22 13:30:00 | QQQ | ETF | 37.16 | 37.17 | 37.07 | 37.11 | 3772400.0 |
| 2005-02-22 14:00:00 | QQQ | ETF | 37.11 | 37.12 | 36.97 | 37.06 | 7852600.0 |
| 2005-02-22 14:30:00 | QQQ | ETF | 37.07 | 37.09 | 37.01 | 37.03 | 3788300.0 |
| 2005-02-22 15:00:00 | QQQ | ETF | 37.03 | 37.04 | 36.82 | 36.84 | 14734800.0 |
| 2005-02-22 15:30:00 | QQQ | ETF | 36.84 | 36.92 | 36.79 | 36.89 | 11963400.0 |
| 2005-02-22 08:30:00 | IWM | ETF | 62.425 | 62.425 | 62.425 | 62.425 | 400.0 |
| 2005-02-22 09:00:00 | IWM | ETF | 62.37 | 62.425 | 62.37 | 62.425 | 1200.0 |
| 2005-02-22 09:30:00 | IWM | ETF | 62.45 | 62.495 | 62.1465 | 62.325 | 1984400.0 |
| 2005-02-22 10:00:00 | IWM | ETF | 62.325 | 62.79 | 62.12 | 62.69 | 3489800.0 |
| 2005-02-22 10:30:00 | IWM | ETF | 62.685 | 62.85 | 62.405 | 62.45 | 2521000.0 |
| 2005-02-22 11:00:00 | IWM | ETF | 62.45 | 62.535 | 62.375 | 62.465 | 979600.0 |
| 2005-02-22 11:30:00 | IWM | ETF | 62.465 | 62.52 | 62.345 | 62.405 | 1127800.0 |
| 2005-02-22 12:00:00 | IWM | ETF | 62.405 | 62.5 | 61.925 | 62.075 | 2565800.0 |
| 2005-02-22 12:30:00 | IWM | ETF | 62.07 | 62.11 | 61.875 | 62.0 | 1789200.0 |
| 2005-02-22 13:00:00 | IWM | ETF | 62.0 | 62.115 | 61.945 | 62.03 | 1211800.0 |
| 2005-02-22 13:30:00 | IWM | ETF | 62.0 | 62.035 | 61.805 | 61.865 | 1645000.0 |
| 2005-02-22 14:00:00 | IWM | ETF | 61.86 | 61.86 | 61.72 | 61.82 | 2801800.0 |
| 2005-02-22 14:30:00 | IWM | ETF | 61.805 | 61.88 | 61.765 | 61.805 | 1026200.0 |
> showing 50 of 1,510 rows — these rows as CSV