PREVIEW / etf_1hour / 2001-02-26
file: by_date/etf_1hour/2001/2001-02-26.parquet size: 11 KB rows: 219
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-26 09:00:00 | SPY | ETF | 125.8 | 125.87 | 125.1 | 125.25 | 1979700.0 |
| 2001-02-26 10:00:00 | SPY | ETF | 125.28 | 125.78 | 124.5 | 124.95 | 1453500.0 |
| 2001-02-26 11:00:00 | SPY | ETF | 124.87 | 125.79 | 124.8 | 125.5 | 830700.0 |
| 2001-02-26 12:00:00 | SPY | ETF | 125.45 | 125.87 | 125.33 | 125.67 | 649600.0 |
| 2001-02-26 13:00:00 | SPY | ETF | 125.75 | 125.98 | 125.26 | 125.26 | 627800.0 |
| 2001-02-26 14:00:00 | SPY | ETF | 125.25 | 126.61 | 125.2 | 126.61 | 1662900.0 |
| 2001-02-26 15:00:00 | SPY | ETF | 126.6 | 127.25 | 126.35 | 127.25 | 1968300.0 |
| 2001-02-26 16:00:00 | SPY | ETF | 127.14 | 127.62 | 126.95 | 127.5 | 1900100.0 |
| 2001-02-26 17:00:00 | SPY | ETF | 127.25 | 127.5 | 127.25 | 127.35 | 101100.0 |
| 2001-02-26 18:00:00 | SPY | ETF | 127.5 | 127.55 | 127.5 | 127.55 | 1100.0 |
| 2001-02-26 09:00:00 | QQQ | ETF | 52.08 | 52.6 | 51.56 | 51.67 | 12273700.0 |
| 2001-02-26 10:00:00 | QQQ | ETF | 51.69 | 51.76 | 50.25 | 50.87 | 17395300.0 |
| 2001-02-26 11:00:00 | QQQ | ETF | 50.87 | 51.9 | 50.69 | 51.4 | 9956300.0 |
| 2001-02-26 12:00:00 | QQQ | ETF | 51.4 | 51.8 | 51.25 | 51.63 | 4132500.0 |
| 2001-02-26 13:00:00 | QQQ | ETF | 51.65 | 51.7 | 50.73 | 50.8 | 8935900.0 |
| 2001-02-26 14:00:00 | QQQ | ETF | 50.8 | 52.12 | 50.68 | 52.1 | 9917300.0 |
| 2001-02-26 15:00:00 | QQQ | ETF | 52.12 | 52.3 | 51.64 | 52.25 | 11204000.0 |
| 2001-02-26 16:00:00 | QQQ | ETF | 52.3 | 52.35 | 51.15 | 52.17 | 1473300.0 |
| 2001-02-26 17:00:00 | QQQ | ETF | 52.16 | 52.29 | 52.1 | 52.21 | 43800.0 |
| 2001-02-26 18:00:00 | QQQ | ETF | 52.2 | 52.27 | 52.17 | 52.18 | 12500.0 |
| 2001-02-26 09:00:00 | IWM | ETF | 48.075 | 48.15 | 48.0 | 48.1 | 28000.0 |
| 2001-02-26 10:00:00 | IWM | ETF | 48.18 | 48.2 | 47.855 | 47.9 | 84000.0 |
| 2001-02-26 11:00:00 | IWM | ETF | 48.035 | 48.225 | 48.035 | 48.225 | 28600.0 |
| 2001-02-26 12:00:00 | IWM | ETF | 48.3 | 48.375 | 48.225 | 48.25 | 61600.0 |
| 2001-02-26 13:00:00 | IWM | ETF | 48.275 | 48.375 | 48.275 | 48.3 | 32000.0 |
| 2001-02-26 14:00:00 | IWM | ETF | 48.17 | 48.55 | 48.1 | 48.45 | 41200.0 |
| 2001-02-26 15:00:00 | IWM | ETF | 48.5 | 48.745 | 48.4 | 48.6 | 154800.0 |
| 2001-02-26 16:00:00 | IWM | ETF | 48.65 | 48.65 | 48.37 | 48.37 | 455000.0 |
| 2001-02-26 09:00:00 | DIA | ETF | 104.9 | 105.14 | 104.58 | 104.6 | 140500.0 |
| 2001-02-26 10:00:00 | DIA | ETF | 104.5 | 105.01 | 104.26 | 104.62 | 252900.0 |
| 2001-02-26 11:00:00 | DIA | ETF | 104.5 | 105.2 | 104.48 | 105.1 | 128400.0 |
| 2001-02-26 12:00:00 | DIA | ETF | 105.07 | 105.45 | 104.85 | 105.25 | 45500.0 |
| 2001-02-26 13:00:00 | DIA | ETF | 105.33 | 105.5 | 105.15 | 105.18 | 148100.0 |
| 2001-02-26 14:00:00 | DIA | ETF | 105.12 | 106.2 | 105.09 | 106.2 | 280500.0 |
| 2001-02-26 15:00:00 | DIA | ETF | 106.0 | 106.48 | 105.85 | 106.4 | 226700.0 |
| 2001-02-26 16:00:00 | DIA | ETF | 106.49 | 106.7 | 106.4 | 106.7 | 25700.0 |
> showing 36 of 219 rows — these rows as CSV