PREVIEW / etf_1hour / 2001-01-05
file: by_date/etf_1hour/2001/2001-01-05.parquet size: 10 KB rows: 201
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-05 09:00:00 | SPY | ETF | 133.4688 | 133.625 | 130.4375 | 131.25 | 1822200.0 |
| 2001-01-05 10:00:00 | SPY | ETF | 131.4375 | 132.75 | 131.2812 | 131.625 | 4334800.0 |
| 2001-01-05 11:00:00 | SPY | ETF | 131.6562 | 131.6875 | 130.2812 | 131.125 | 1433800.0 |
| 2001-01-05 12:00:00 | SPY | ETF | 131.2812 | 131.75 | 130.6875 | 131.4375 | 987800.0 |
| 2001-01-05 13:00:00 | SPY | ETF | 131.5312 | 131.5625 | 130.8438 | 131.4375 | 524000.0 |
| 2001-01-05 14:00:00 | SPY | ETF | 131.4688 | 131.4688 | 130.0625 | 130.3125 | 705500.0 |
| 2001-01-05 15:00:00 | SPY | ETF | 130.4062 | 130.4062 | 129.2812 | 130.25 | 2251400.0 |
| 2001-01-05 16:00:00 | SPY | ETF | 130.3438 | 130.4062 | 129.1875 | 129.1875 | 632200.0 |
| 2001-01-05 17:00:00 | SPY | ETF | 129.4688 | 129.4688 | 129.4688 | 129.4688 | 100.0 |
| 2001-01-05 09:00:00 | QQQ | ETF | 61.3125 | 61.3125 | 58.25 | 58.5 | 12807900.0 |
| 2001-01-05 10:00:00 | QQQ | ETF | 58.5 | 59.9375 | 58.3438 | 58.5625 | 15940800.0 |
| 2001-01-05 11:00:00 | QQQ | ETF | 58.5938 | 58.6562 | 57.375 | 58.25 | 10896500.0 |
| 2001-01-05 12:00:00 | QQQ | ETF | 58.1875 | 58.75 | 57.625 | 58.2812 | 5434300.0 |
| 2001-01-05 13:00:00 | QQQ | ETF | 58.2812 | 58.4688 | 57.375 | 57.7188 | 4307900.0 |
| 2001-01-05 14:00:00 | QQQ | ETF | 57.75 | 57.875 | 56.5625 | 56.875 | 5593800.0 |
| 2001-01-05 15:00:00 | QQQ | ETF | 56.875 | 57.0 | 56.0 | 56.6875 | 12261700.0 |
| 2001-01-05 16:00:00 | QQQ | ETF | 56.75 | 56.875 | 56.0 | 56.8125 | 1108700.0 |
| 2001-01-05 17:00:00 | QQQ | ETF | 56.5 | 56.625 | 56.0 | 56.1875 | 15200.0 |
| 2001-01-05 18:00:00 | QQQ | ETF | 56.1875 | 56.8125 | 56.125 | 56.25 | 7400.0 |
| 2001-01-05 09:00:00 | IWM | ETF | 47.4375 | 47.4375 | 46.3125 | 46.5 | 66200.0 |
| 2001-01-05 10:00:00 | IWM | ETF | 46.4375 | 46.9688 | 46.4062 | 46.75 | 81200.0 |
| 2001-01-05 11:00:00 | IWM | ETF | 46.7188 | 46.7188 | 46.0625 | 46.25 | 28600.0 |
| 2001-01-05 12:00:00 | IWM | ETF | 46.25 | 46.375 | 46.1875 | 46.1875 | 20600.0 |
| 2001-01-05 13:00:00 | IWM | ETF | 46.4375 | 46.4375 | 46.1562 | 46.1562 | 3800.0 |
| 2001-01-05 14:00:00 | IWM | ETF | 46.2812 | 46.2812 | 46.0 | 46.0938 | 25200.0 |
| 2001-01-05 15:00:00 | IWM | ETF | 46.0 | 46.1562 | 45.8125 | 45.9688 | 36400.0 |
| 2001-01-05 16:00:00 | IWM | ETF | 46.0312 | 46.0312 | 46.0312 | 46.0312 | 1200.0 |
| 2001-01-05 09:00:00 | DIA | ETF | 108.1875 | 108.4062 | 106.625 | 107.6562 | 343000.0 |
| 2001-01-05 10:00:00 | DIA | ETF | 107.5 | 108.3125 | 107.4062 | 107.5 | 393900.0 |
| 2001-01-05 11:00:00 | DIA | ETF | 107.375 | 107.625 | 106.6875 | 107.125 | 207700.0 |
| 2001-01-05 12:00:00 | DIA | ETF | 107.1562 | 107.4688 | 106.75 | 107.4062 | 90500.0 |
| 2001-01-05 13:00:00 | DIA | ETF | 107.25 | 107.4375 | 106.9375 | 107.0312 | 106200.0 |
| 2001-01-05 14:00:00 | DIA | ETF | 107.0312 | 107.125 | 106.4375 | 106.625 | 142400.0 |
| 2001-01-05 15:00:00 | DIA | ETF | 106.6875 | 106.8125 | 106.25 | 106.75 | 297800.0 |
| 2001-01-05 16:00:00 | DIA | ETF | 106.625 | 106.6875 | 106.25 | 106.2812 | 51300.0 |
> showing 35 of 201 rows — these rows as CSV