PREVIEW / etf_1hour / 2000-05-24
file: by_date/etf_1hour/2000/2000-05-24.parquet size: 8 KB rows: 134
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 |
|---|---|---|---|---|---|---|---|
| 2000-05-24 09:00:00 | SPY | ETF | 138.0 | 138.9375 | 137.6875 | 137.6875 | 1488300.0 |
| 2000-05-24 10:00:00 | SPY | ETF | 137.6875 | 139.75 | 137.4062 | 138.5312 | 2039300.0 |
| 2000-05-24 11:00:00 | SPY | ETF | 138.6562 | 138.875 | 137.625 | 137.7188 | 900500.0 |
| 2000-05-24 12:00:00 | SPY | ETF | 137.8125 | 138.375 | 136.5 | 136.7188 | 1146300.0 |
| 2000-05-24 13:00:00 | SPY | ETF | 136.625 | 138.5625 | 136.625 | 138.25 | 779100.0 |
| 2000-05-24 14:00:00 | SPY | ETF | 138.0625 | 140.0312 | 137.6562 | 139.875 | 2015600.0 |
| 2000-05-24 15:00:00 | SPY | ETF | 139.75 | 140.6875 | 139.1562 | 140.4062 | 2151000.0 |
| 2000-05-24 16:00:00 | SPY | ETF | 140.4062 | 140.4375 | 140.0312 | 140.25 | 393800.0 |
| 2000-05-24 09:00:00 | QQQ | ETF | 75.0 | 76.25 | 74.0312 | 74.5 | 6771600.0 |
| 2000-05-24 10:00:00 | QQQ | ETF | 74.0312 | 77.625 | 73.5 | 75.5 | 9990800.0 |
| 2000-05-24 11:00:00 | QQQ | ETF | 75.5 | 76.5 | 74.25 | 74.75 | 3380300.0 |
| 2000-05-24 12:00:00 | QQQ | ETF | 74.75 | 74.9688 | 72.25 | 72.75 | 3911200.0 |
| 2000-05-24 13:00:00 | QQQ | ETF | 72.5312 | 75.625 | 72.5 | 74.6875 | 7002000.0 |
| 2000-05-24 14:00:00 | QQQ | ETF | 74.6875 | 78.3438 | 74.125 | 78.0 | 8118300.0 |
| 2000-05-24 15:00:00 | QQQ | ETF | 77.9375 | 79.875 | 76.6875 | 79.4375 | 9115000.0 |
| 2000-05-24 16:00:00 | QQQ | ETF | 79.4375 | 79.75 | 78.5 | 78.875 | 842000.0 |
| 2000-05-24 17:00:00 | QQQ | ETF | 79.0 | 79.75 | 79.0 | 79.5 | 4500.0 |
| 2000-05-24 18:00:00 | QQQ | ETF | 79.75 | 79.75 | 79.5 | 79.5 | 2900.0 |
| 2000-05-24 09:00:00 | DIA | ETF | 104.7188 | 104.9688 | 104.375 | 104.375 | 74200.0 |
| 2000-05-24 10:00:00 | DIA | ETF | 104.2812 | 105.5312 | 104.2812 | 104.8438 | 125200.0 |
| 2000-05-24 11:00:00 | DIA | ETF | 104.7812 | 105.0625 | 104.25 | 104.625 | 121400.0 |
| 2000-05-24 12:00:00 | DIA | ETF | 104.5 | 104.6562 | 103.4688 | 103.5625 | 205500.0 |
| 2000-05-24 13:00:00 | DIA | ETF | 103.5938 | 104.9375 | 103.5938 | 104.7812 | 345800.0 |
| 2000-05-24 14:00:00 | DIA | ETF | 104.5625 | 105.375 | 104.5312 | 105.25 | 213700.0 |
| 2000-05-24 15:00:00 | DIA | ETF | 105.375 | 105.6875 | 104.9688 | 105.5 | 164200.0 |
| 2000-05-24 16:00:00 | DIA | ETF | 105.5 | 105.5 | 105.2812 | 105.4375 | 4200.0 |
> showing 26 of 134 rows — these rows as CSV