PREVIEW / etf_1hour / 2001-01-02
file: by_date/etf_1hour/2001/2001-01-02.parquet size: 10 KB rows: 200
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-01-02 09:00:00 | SPY | ETF | 132.0 | 132.1562 | 131.3438 | 131.5 | 1335300.0 |
| 2001-01-02 10:00:00 | SPY | ETF | 131.5 | 131.625 | 130.25 | 130.3125 | 1824400.0 |
| 2001-01-02 11:00:00 | SPY | ETF | 130.1562 | 130.2812 | 129.3125 | 130.0312 | 896600.0 |
| 2001-01-02 12:00:00 | SPY | ETF | 130.0938 | 130.125 | 129.5 | 129.9375 | 311300.0 |
| 2001-01-02 13:00:00 | SPY | ETF | 130.0 | 130.2812 | 129.1562 | 129.375 | 710100.0 |
| 2001-01-02 14:00:00 | SPY | ETF | 129.25 | 129.4688 | 128.4062 | 128.5625 | 1202600.0 |
| 2001-01-02 15:00:00 | SPY | ETF | 128.5938 | 128.6562 | 127.5625 | 128.25 | 2023600.0 |
| 2001-01-02 16:00:00 | SPY | ETF | 128.0938 | 128.8125 | 128.0 | 128.8125 | 407400.0 |
| 2001-01-02 18:00:00 | SPY | ETF | 128.0625 | 128.0625 | 128.0625 | 128.0625 | 100.0 |
| 2001-01-02 09:00:00 | QQQ | ETF | 58.5625 | 58.6875 | 56.6875 | 56.6875 | 6087800.0 |
| 2001-01-02 10:00:00 | QQQ | ETF | 57.0 | 57.0 | 55.0312 | 55.125 | 9993900.0 |
| 2001-01-02 11:00:00 | QQQ | ETF | 55.125 | 55.125 | 53.8125 | 54.9062 | 10712300.0 |
| 2001-01-02 12:00:00 | QQQ | ETF | 55.0 | 55.125 | 54.2812 | 54.9375 | 4177700.0 |
| 2001-01-02 13:00:00 | QQQ | ETF | 54.9688 | 55.4688 | 54.2812 | 54.5 | 4155700.0 |
| 2001-01-02 14:00:00 | QQQ | ETF | 54.5 | 54.875 | 53.375 | 53.625 | 7659300.0 |
| 2001-01-02 15:00:00 | QQQ | ETF | 53.625 | 53.75 | 52.4375 | 53.0 | 16400300.0 |
| 2001-01-02 16:00:00 | QQQ | ETF | 53.2188 | 53.625 | 52.5 | 53.4062 | 2616500.0 |
| 2001-01-02 17:00:00 | QQQ | ETF | 53.4062 | 53.875 | 53.25 | 53.5 | 32400.0 |
| 2001-01-02 18:00:00 | QQQ | ETF | 53.5 | 54.0 | 53.375 | 53.5 | 10000.0 |
| 2001-01-02 09:00:00 | IWM | ETF | 47.875 | 47.875 | 47.5 | 47.5 | 180200.0 |
| 2001-01-02 10:00:00 | IWM | ETF | 47.4375 | 47.4688 | 46.5 | 46.5 | 283800.0 |
| 2001-01-02 11:00:00 | IWM | ETF | 46.1875 | 46.4219 | 46.1875 | 46.4219 | 67800.0 |
| 2001-01-02 12:00:00 | IWM | ETF | 46.4375 | 46.5 | 46.3438 | 46.4375 | 38000.0 |
| 2001-01-02 13:00:00 | IWM | ETF | 46.4688 | 46.6406 | 46.4062 | 46.4062 | 71600.0 |
| 2001-01-02 14:00:00 | IWM | ETF | 46.25 | 46.4219 | 45.8438 | 45.8438 | 75400.0 |
| 2001-01-02 15:00:00 | IWM | ETF | 45.8438 | 46.125 | 45.8438 | 46.0 | 98000.0 |
| 2001-01-02 16:00:00 | IWM | ETF | 46.2031 | 46.2031 | 46.2031 | 46.2031 | 3600.0 |
| 2001-01-02 09:00:00 | DIA | ETF | 107.1875 | 107.4375 | 106.6875 | 107.375 | 222600.0 |
| 2001-01-02 10:00:00 | DIA | ETF | 107.3438 | 107.7188 | 106.9375 | 107.125 | 199700.0 |
| 2001-01-02 11:00:00 | DIA | ETF | 107.0625 | 107.125 | 106.375 | 107.0312 | 313100.0 |
| 2001-01-02 12:00:00 | DIA | ETF | 107.1562 | 107.1562 | 106.625 | 107.0 | 85800.0 |
| 2001-01-02 13:00:00 | DIA | ETF | 107.0 | 107.1875 | 106.25 | 106.4375 | 127400.0 |
| 2001-01-02 14:00:00 | DIA | ETF | 106.625 | 106.6875 | 106.1875 | 106.3125 | 178400.0 |
| 2001-01-02 15:00:00 | DIA | ETF | 106.25 | 106.4688 | 105.5938 | 105.9688 | 253700.0 |
| 2001-01-02 16:00:00 | DIA | ETF | 106.0938 | 106.4688 | 106.0938 | 106.4062 | 86300.0 |
> showing 35 of 200 rows — these rows as CSV