PREVIEW / etf_1hour / 2000-02-24
file: by_date/etf_1hour/2000/2000-02-24.parquet size: 8 KB rows: 133
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-02-24 09:00:00 | SPY | ETF | 136.6875 | 137.0312 | 135.7812 | 135.9375 | 1492700.0 |
| 2000-02-24 10:00:00 | SPY | ETF | 136.0 | 136.0625 | 133.7812 | 133.9062 | 3757500.0 |
| 2000-02-24 11:00:00 | SPY | ETF | 133.9062 | 134.625 | 133.5625 | 134.5625 | 3179300.0 |
| 2000-02-24 12:00:00 | SPY | ETF | 134.5 | 134.8125 | 133.875 | 134.0625 | 1583000.0 |
| 2000-02-24 13:00:00 | SPY | ETF | 134.1875 | 134.9062 | 134.0 | 134.0 | 553700.0 |
| 2000-02-24 14:00:00 | SPY | ETF | 134.0 | 134.5312 | 133.0938 | 134.2188 | 2207500.0 |
| 2000-02-24 15:00:00 | SPY | ETF | 134.125 | 136.3438 | 134.125 | 135.625 | 3388800.0 |
| 2000-02-24 16:00:00 | SPY | ETF | 135.6875 | 135.7188 | 135.3125 | 135.375 | 416300.0 |
| 2000-02-24 17:00:00 | SPY | ETF | 133.8125 | 133.8125 | 133.8125 | 133.8125 | 750000.0 |
| 2000-02-24 09:00:00 | QQQ | ETF | 104.875 | 106.25 | 104.5938 | 105.625 | 5542000.0 |
| 2000-02-24 10:00:00 | QQQ | ETF | 105.6875 | 106.0 | 102.5 | 102.5 | 9613600.0 |
| 2000-02-24 11:00:00 | QQQ | ETF | 103.1562 | 104.0 | 102.0 | 103.875 | 6934800.0 |
| 2000-02-24 12:00:00 | QQQ | ETF | 103.9062 | 104.6875 | 103.375 | 103.75 | 5933200.0 |
| 2000-02-24 13:00:00 | QQQ | ETF | 103.8125 | 104.9688 | 103.6875 | 103.6875 | 3391600.0 |
| 2000-02-24 14:00:00 | QQQ | ETF | 103.6875 | 104.25 | 102.1562 | 103.9375 | 8978200.0 |
| 2000-02-24 15:00:00 | QQQ | ETF | 103.875 | 106.4375 | 103.875 | 106.1406 | 7459600.0 |
| 2000-02-24 16:00:00 | QQQ | ETF | 106.0625 | 106.7969 | 106.0 | 106.125 | 667400.0 |
| 2000-02-24 17:00:00 | QQQ | ETF | 106.625 | 106.75 | 106.5 | 106.5 | 1000.0 |
| 2000-02-24 18:00:00 | QQQ | ETF | 106.5 | 106.5 | 106.5 | 106.5 | 200.0 |
| 2000-02-24 09:00:00 | DIA | ETF | 102.5625 | 102.6875 | 101.25 | 101.4688 | 234300.0 |
| 2000-02-24 10:00:00 | DIA | ETF | 101.5 | 101.5 | 100.2188 | 100.3125 | 655700.0 |
| 2000-02-24 11:00:00 | DIA | ETF | 100.25 | 100.9062 | 100.0625 | 100.75 | 1002500.0 |
| 2000-02-24 12:00:00 | DIA | ETF | 100.75 | 100.8125 | 100.0625 | 100.25 | 376400.0 |
| 2000-02-24 13:00:00 | DIA | ETF | 100.3438 | 100.7812 | 100.0625 | 100.125 | 314200.0 |
| 2000-02-24 14:00:00 | DIA | ETF | 100.125 | 100.5 | 99.5625 | 100.4062 | 1061500.0 |
| 2000-02-24 15:00:00 | DIA | ETF | 100.4375 | 101.7188 | 100.2812 | 100.9375 | 831500.0 |
| 2000-02-24 16:00:00 | DIA | ETF | 100.9375 | 101.125 | 100.7812 | 101.125 | 21100.0 |
| 2000-02-24 17:00:00 | DIA | ETF | 102.0 | 102.0 | 102.0 | 102.0 | 100.0 |
> showing 28 of 133 rows — these rows as CSV