PREVIEW / etf_1hour / 2001-02-21
file: by_date/etf_1hour/2001/2001-02-21.parquet size: 11 KB rows: 213
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-21 09:00:00 | SPY | ETF | 127.9 | 128.56 | 127.62 | 128.28 | 1803100.0 |
| 2001-02-21 10:00:00 | SPY | ETF | 128.4 | 128.4 | 127.3 | 127.79 | 1958500.0 |
| 2001-02-21 11:00:00 | SPY | ETF | 127.67 | 128.42 | 127.31 | 128.17 | 903600.0 |
| 2001-02-21 12:00:00 | SPY | ETF | 128.2 | 128.84 | 128.17 | 128.5 | 1365100.0 |
| 2001-02-21 13:00:00 | SPY | ETF | 128.42 | 128.53 | 127.36 | 127.39 | 700200.0 |
| 2001-02-21 14:00:00 | SPY | ETF | 127.45 | 127.63 | 126.9 | 127.19 | 731000.0 |
| 2001-02-21 15:00:00 | SPY | ETF | 127.17 | 127.31 | 125.52 | 125.6 | 2232700.0 |
| 2001-02-21 16:00:00 | SPY | ETF | 125.57 | 127.48 | 125.5 | 127.48 | 692700.0 |
| 2001-02-21 18:00:00 | SPY | ETF | 126.0 | 126.0 | 126.0 | 126.0 | 100.0 |
| 2001-02-21 09:00:00 | QQQ | ETF | 51.55 | 53.46 | 51.5 | 52.75 | 14362600.0 |
| 2001-02-21 10:00:00 | QQQ | ETF | 52.8 | 53.2 | 51.74 | 52.45 | 10574400.0 |
| 2001-02-21 11:00:00 | QQQ | ETF | 52.45 | 53.39 | 52.0 | 53.16 | 6232700.0 |
| 2001-02-21 12:00:00 | QQQ | ETF | 53.2 | 54.07 | 53.16 | 53.6 | 8402100.0 |
| 2001-02-21 13:00:00 | QQQ | ETF | 53.6 | 53.63 | 52.56 | 52.64 | 5865300.0 |
| 2001-02-21 14:00:00 | QQQ | ETF | 52.63 | 52.88 | 51.93 | 52.14 | 8073100.0 |
| 2001-02-21 15:00:00 | QQQ | ETF | 52.1 | 52.35 | 50.92 | 51.4 | 14534200.0 |
| 2001-02-21 16:00:00 | QQQ | ETF | 51.4 | 51.9 | 51.2 | 51.35 | 1496300.0 |
| 2001-02-21 17:00:00 | QQQ | ETF | 51.31 | 51.5 | 50.06 | 50.6 | 342200.0 |
| 2001-02-21 18:00:00 | QQQ | ETF | 50.59 | 51.5 | 50.54 | 50.65 | 45800.0 |
| 2001-02-21 09:00:00 | IWM | ETF | 48.6 | 49.075 | 48.45 | 48.7 | 63800.0 |
| 2001-02-21 10:00:00 | IWM | ETF | 48.6 | 48.795 | 48.5 | 48.63 | 156400.0 |
| 2001-02-21 11:00:00 | IWM | ETF | 48.5 | 48.64 | 48.43 | 48.64 | 11600.0 |
| 2001-02-21 12:00:00 | IWM | ETF | 48.7 | 48.875 | 48.7 | 48.775 | 31800.0 |
| 2001-02-21 13:00:00 | IWM | ETF | 48.875 | 48.875 | 48.525 | 48.655 | 20600.0 |
| 2001-02-21 14:00:00 | IWM | ETF | 48.69 | 48.74 | 48.45 | 48.65 | 52600.0 |
| 2001-02-21 15:00:00 | IWM | ETF | 48.5 | 48.5 | 48.025 | 48.025 | 46000.0 |
| 2001-02-21 16:00:00 | IWM | ETF | 48.175 | 48.175 | 48.175 | 48.175 | 2400.0 |
| 2001-02-21 09:00:00 | DIA | ETF | 107.15 | 107.4 | 106.85 | 107.1 | 200100.0 |
| 2001-02-21 10:00:00 | DIA | ETF | 107.2 | 107.2 | 106.36 | 106.56 | 318100.0 |
| 2001-02-21 11:00:00 | DIA | ETF | 106.56 | 107.15 | 106.3 | 107.1 | 71400.0 |
| 2001-02-21 12:00:00 | DIA | ETF | 106.9 | 107.49 | 106.9 | 107.23 | 159000.0 |
| 2001-02-21 13:00:00 | DIA | ETF | 107.2 | 107.27 | 106.5 | 106.5 | 202500.0 |
| 2001-02-21 14:00:00 | DIA | ETF | 106.51 | 106.75 | 106.2 | 106.49 | 162900.0 |
| 2001-02-21 15:00:00 | DIA | ETF | 106.38 | 106.49 | 105.2 | 105.2 | 391800.0 |
| 2001-02-21 16:00:00 | DIA | ETF | 105.3 | 105.35 | 105.1 | 105.3 | 229300.0 |
> showing 35 of 213 rows — these rows as CSV