PREVIEW / etf_1hour / 2001-02-28
file: by_date/etf_1hour/2001/2001-02-28.parquet size: 11 KB rows: 223
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-02-28 09:00:00 | SPY | ETF | 126.75 | 126.84 | 125.85 | 126.06 | 1917700.0 |
| 2001-02-28 10:00:00 | SPY | ETF | 126.04 | 126.84 | 125.06 | 125.06 | 1881500.0 |
| 2001-02-28 11:00:00 | SPY | ETF | 125.07 | 125.15 | 124.1 | 124.85 | 1848900.0 |
| 2001-02-28 12:00:00 | SPY | ETF | 124.71 | 124.8 | 123.85 | 124.8 | 1747400.0 |
| 2001-02-28 13:00:00 | SPY | ETF | 124.8 | 125.35 | 124.3 | 124.69 | 2337200.0 |
| 2001-02-28 14:00:00 | SPY | ETF | 124.68 | 124.94 | 123.7 | 123.85 | 1221900.0 |
| 2001-02-28 15:00:00 | SPY | ETF | 123.9 | 124.9 | 123.27 | 124.15 | 2304100.0 |
| 2001-02-28 16:00:00 | SPY | ETF | 124.26 | 124.4 | 123.73 | 124.4 | 958200.0 |
| 2001-02-28 17:00:00 | SPY | ETF | 123.9 | 124.0 | 123.9 | 124.0 | 5000.0 |
| 2001-02-28 09:00:00 | QQQ | ETF | 49.45 | 49.54 | 48.47 | 49.1 | 10542300.0 |
| 2001-02-28 10:00:00 | QQQ | ETF | 49.04 | 50.21 | 48.43 | 48.45 | 19156900.0 |
| 2001-02-28 11:00:00 | QQQ | ETF | 48.46 | 48.74 | 47.15 | 47.75 | 18319500.0 |
| 2001-02-28 12:00:00 | QQQ | ETF | 47.77 | 48.24 | 47.23 | 48.2 | 9632300.0 |
| 2001-02-28 13:00:00 | QQQ | ETF | 48.2 | 48.95 | 47.5 | 48.4 | 10601300.0 |
| 2001-02-28 14:00:00 | QQQ | ETF | 48.42 | 48.54 | 47.15 | 47.33 | 8719600.0 |
| 2001-02-28 15:00:00 | QQQ | ETF | 47.33 | 48.2 | 46.86 | 47.5 | 19564500.0 |
| 2001-02-28 16:00:00 | QQQ | ETF | 47.45 | 48.74 | 47.15 | 47.22 | 1717900.0 |
| 2001-02-28 17:00:00 | QQQ | ETF | 47.22 | 47.35 | 47.16 | 47.34 | 46200.0 |
| 2001-02-28 18:00:00 | QQQ | ETF | 47.3 | 47.33 | 47.16 | 47.25 | 8900.0 |
| 2001-02-28 09:00:00 | IWM | ETF | 47.9 | 47.9 | 47.875 | 47.9 | 10600.0 |
| 2001-02-28 10:00:00 | IWM | ETF | 47.65 | 47.875 | 47.525 | 47.525 | 37200.0 |
| 2001-02-28 11:00:00 | IWM | ETF | 47.525 | 47.525 | 46.95 | 46.95 | 52400.0 |
| 2001-02-28 12:00:00 | IWM | ETF | 46.965 | 46.965 | 46.925 | 46.925 | 600.0 |
| 2001-02-28 13:00:00 | IWM | ETF | 47.185 | 47.45 | 46.925 | 47.45 | 8600.0 |
| 2001-02-28 14:00:00 | IWM | ETF | 47.3 | 47.3 | 47.025 | 47.075 | 28200.0 |
| 2001-02-28 15:00:00 | IWM | ETF | 47.01 | 47.4 | 47.01 | 47.065 | 173400.0 |
| 2001-02-28 16:00:00 | IWM | ETF | 47.115 | 47.115 | 47.075 | 47.075 | 3600.0 |
| 2001-02-28 09:00:00 | DIA | ETF | 106.75 | 107.1 | 106.3 | 106.35 | 592900.0 |
| 2001-02-28 10:00:00 | DIA | ETF | 106.45 | 106.95 | 105.67 | 105.67 | 465300.0 |
| 2001-02-28 11:00:00 | DIA | ETF | 105.67 | 105.67 | 104.85 | 105.5 | 482500.0 |
| 2001-02-28 12:00:00 | DIA | ETF | 105.35 | 105.48 | 104.8 | 105.45 | 276200.0 |
| 2001-02-28 13:00:00 | DIA | ETF | 105.52 | 105.79 | 105.1 | 105.12 | 257700.0 |
| 2001-02-28 14:00:00 | DIA | ETF | 105.12 | 105.3 | 104.61 | 104.8 | 156900.0 |
| 2001-02-28 15:00:00 | DIA | ETF | 104.7 | 105.55 | 104.27 | 105.05 | 584400.0 |
| 2001-02-28 16:00:00 | DIA | ETF | 105.01 | 105.08 | 104.82 | 104.82 | 10400.0 |
> showing 35 of 223 rows — these rows as CSV