PREVIEW / etf_30min / 2005-02-24
file: by_date/etf_30min/2005/2005-02-24.parquet size: 43 KB rows: 1,448
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-24 08:00:00 | SPY | ETF | 119.28 | 119.3 | 119.24 | 119.29 | 201000.0 |
| 2005-02-24 08:30:00 | SPY | ETF | 119.31 | 119.33 | 119.27 | 119.32 | 87000.0 |
| 2005-02-24 09:00:00 | SPY | ETF | 119.31 | 119.31 | 119.2 | 119.26 | 715900.0 |
| 2005-02-24 09:30:00 | SPY | ETF | 119.24 | 119.41 | 118.98 | 119.08 | 8532200.0 |
| 2005-02-24 10:00:00 | SPY | ETF | 119.08 | 119.41 | 118.99 | 119.23 | 6768100.0 |
| 2005-02-24 10:30:00 | SPY | ETF | 119.25 | 119.7 | 119.15 | 119.17 | 8621700.0 |
| 2005-02-24 11:00:00 | SPY | ETF | 119.18 | 119.68 | 119.15 | 119.37 | 4898700.0 |
| 2005-02-24 11:30:00 | SPY | ETF | 119.37 | 119.46 | 119.22 | 119.3 | 2066300.0 |
| 2005-02-24 12:00:00 | SPY | ETF | 119.3 | 119.34 | 119.18 | 119.31 | 2413900.0 |
| 2005-02-24 12:30:00 | SPY | ETF | 119.3 | 119.37 | 119.2 | 119.25 | 1415500.0 |
| 2005-02-24 13:00:00 | SPY | ETF | 119.25 | 119.43 | 119.18 | 119.33 | 1628300.0 |
| 2005-02-24 13:30:00 | SPY | ETF | 119.34 | 119.64 | 119.31 | 119.55 | 3097400.0 |
| 2005-02-24 14:00:00 | SPY | ETF | 119.55 | 120.01 | 119.51 | 119.9 | 6975300.0 |
| 2005-02-24 14:30:00 | SPY | ETF | 119.89 | 120.0 | 119.8 | 119.94 | 3058900.0 |
| 2005-02-24 15:00:00 | SPY | ETF | 119.93 | 120.17 | 119.9 | 120.06 | 5706800.0 |
| 2005-02-24 15:30:00 | SPY | ETF | 120.06 | 120.32 | 120.02 | 120.26 | 9168200.0 |
| 2005-02-24 16:00:00 | SPY | ETF | 120.28 | 120.34 | 120.2 | 120.28 | 966500.0 |
| 2005-02-24 16:30:00 | SPY | ETF | 120.28 | 120.3 | 120.21 | 120.27 | 607800.0 |
| 2005-02-24 17:00:00 | SPY | ETF | 120.27 | 120.29 | 120.27 | 120.27 | 32200.0 |
| 2005-02-24 17:30:00 | SPY | ETF | 120.27 | 120.28 | 120.26 | 120.27 | 4900.0 |
| 2005-02-24 18:00:00 | SPY | ETF | 120.27 | 120.28 | 120.26 | 120.26 | 9800.0 |
| 2005-02-24 18:30:00 | SPY | ETF | 120.22 | 120.23 | 120.21 | 120.21 | 5000.0 |
| 2005-02-24 09:30:00 | QQQ | ETF | 36.85 | 37.0 | 36.76 | 36.83 | 14963800.0 |
| 2005-02-24 10:00:00 | QQQ | ETF | 36.83 | 37.04 | 36.76 | 36.93 | 9828100.0 |
| 2005-02-24 10:30:00 | QQQ | ETF | 36.93 | 37.15 | 36.83 | 36.83 | 11511000.0 |
| 2005-02-24 11:00:00 | QQQ | ETF | 36.84 | 37.02 | 36.81 | 36.91 | 5670100.0 |
| 2005-02-24 11:30:00 | QQQ | ETF | 36.98 | 36.99 | 36.83 | 36.87 | 4326100.0 |
| 2005-02-24 12:00:00 | QQQ | ETF | 36.87 | 36.89 | 36.8 | 36.87 | 3183500.0 |
| 2005-02-24 12:30:00 | QQQ | ETF | 36.88 | 36.92 | 36.82 | 36.86 | 1762700.0 |
| 2005-02-24 13:00:00 | QQQ | ETF | 36.86 | 36.94 | 36.83 | 36.9 | 1792900.0 |
| 2005-02-24 13:30:00 | QQQ | ETF | 36.9 | 37.08 | 36.89 | 37.03 | 5882300.0 |
| 2005-02-24 14:00:00 | QQQ | ETF | 37.03 | 37.33 | 37.02 | 37.28 | 11203100.0 |
| 2005-02-24 14:30:00 | QQQ | ETF | 37.28 | 37.36 | 37.2 | 37.28 | 6689700.0 |
| 2005-02-24 15:00:00 | QQQ | ETF | 37.28 | 37.39 | 37.24 | 37.33 | 7177900.0 |
| 2005-02-24 15:30:00 | QQQ | ETF | 37.33 | 37.44 | 37.33 | 37.41 | 9412300.0 |
| 2005-02-24 08:30:00 | IWM | ETF | 61.775 | 61.825 | 61.72 | 61.78 | 30000.0 |
| 2005-02-24 09:00:00 | IWM | ETF | 61.825 | 61.825 | 61.825 | 61.825 | 600.0 |
| 2005-02-24 09:30:00 | IWM | ETF | 61.84 | 62.0 | 61.475 | 61.51 | 1785800.0 |
| 2005-02-24 10:00:00 | IWM | ETF | 61.525 | 61.85 | 61.385 | 61.69 | 2190600.0 |
| 2005-02-24 10:30:00 | IWM | ETF | 61.685 | 62.01 | 61.615 | 61.625 | 1631800.0 |
| 2005-02-24 11:00:00 | IWM | ETF | 61.62 | 61.89 | 61.55 | 61.76 | 551400.0 |
| 2005-02-24 11:30:00 | IWM | ETF | 61.77 | 61.855 | 61.68 | 61.735 | 507000.0 |
| 2005-02-24 12:00:00 | IWM | ETF | 61.705 | 61.795 | 61.65 | 61.77 | 552400.0 |
| 2005-02-24 12:30:00 | IWM | ETF | 61.735 | 61.84 | 61.7 | 61.74 | 208000.0 |
| 2005-02-24 13:00:00 | IWM | ETF | 61.755 | 61.93 | 61.705 | 61.845 | 542000.0 |
| 2005-02-24 13:30:00 | IWM | ETF | 61.84 | 62.125 | 61.825 | 62.0 | 816000.0 |
| 2005-02-24 14:00:00 | IWM | ETF | 62.0 | 62.35 | 61.98 | 62.295 | 2063200.0 |
| 2005-02-24 14:30:00 | IWM | ETF | 62.295 | 62.35 | 62.175 | 62.295 | 1241400.0 |
| 2005-02-24 15:00:00 | IWM | ETF | 62.29 | 62.47 | 62.24 | 62.425 | 2384000.0 |
| 2005-02-24 15:30:00 | IWM | ETF | 62.415 | 62.58 | 62.415 | 62.515 | 1791200.0 |
> showing 50 of 1,448 rows — these rows as CSV