PREVIEW / etf_1hour / 2000-05-25
file: by_date/etf_1hour/2000/2000-05-25.parquet size: 8 KB rows: 123
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-25 09:00:00 | SPY | ETF | 140.6875 | 141.8125 | 140.375 | 141.3125 | 1526900.0 |
| 2000-05-25 10:00:00 | SPY | ETF | 141.4062 | 141.5 | 140.8438 | 141.125 | 1012400.0 |
| 2000-05-25 11:00:00 | SPY | ETF | 141.0625 | 141.4062 | 140.625 | 140.9375 | 490400.0 |
| 2000-05-25 12:00:00 | SPY | ETF | 140.9688 | 141.375 | 140.875 | 140.875 | 200800.0 |
| 2000-05-25 13:00:00 | SPY | ETF | 140.875 | 141.4688 | 140.5 | 140.5625 | 404300.0 |
| 2000-05-25 14:00:00 | SPY | ETF | 140.5 | 140.5312 | 139.0625 | 139.1562 | 925700.0 |
| 2000-05-25 15:00:00 | SPY | ETF | 139.1562 | 139.2812 | 137.7188 | 138.875 | 2209900.0 |
| 2000-05-25 16:00:00 | SPY | ETF | 138.6875 | 139.0938 | 137.8438 | 137.8438 | 1189300.0 |
| 2000-05-25 09:00:00 | QQQ | ETF | 80.25 | 82.25 | 80.0 | 81.5312 | 5835400.0 |
| 2000-05-25 10:00:00 | QQQ | ETF | 81.625 | 82.0 | 81.0625 | 81.375 | 3856500.0 |
| 2000-05-25 11:00:00 | QQQ | ETF | 81.4375 | 81.75 | 80.25 | 80.9062 | 2253800.0 |
| 2000-05-25 12:00:00 | QQQ | ETF | 80.9375 | 81.5 | 80.875 | 81.0 | 2056100.0 |
| 2000-05-25 13:00:00 | QQQ | ETF | 81.0 | 82.0625 | 80.9375 | 81.25 | 3005300.0 |
| 2000-05-25 14:00:00 | QQQ | ETF | 81.0625 | 81.3438 | 79.1875 | 79.1875 | 4038300.0 |
| 2000-05-25 15:00:00 | QQQ | ETF | 79.1875 | 79.5 | 76.5 | 77.5625 | 7810800.0 |
| 2000-05-25 16:00:00 | QQQ | ETF | 77.5 | 78.0 | 77.4062 | 77.5 | 660400.0 |
| 2000-05-25 17:00:00 | QQQ | ETF | 77.5 | 77.625 | 77.5 | 77.625 | 1200.0 |
| 2000-05-25 18:00:00 | QQQ | ETF | 77.25 | 77.75 | 77.25 | 77.75 | 1000.0 |
| 2000-05-25 09:00:00 | DIA | ETF | 105.7188 | 105.8125 | 104.7812 | 105.4688 | 174400.0 |
| 2000-05-25 10:00:00 | DIA | ETF | 105.4062 | 105.4062 | 104.8125 | 104.8125 | 116500.0 |
| 2000-05-25 11:00:00 | DIA | ETF | 104.8125 | 105.2188 | 104.6875 | 104.7188 | 24200.0 |
| 2000-05-25 12:00:00 | DIA | ETF | 105.0625 | 105.25 | 104.8438 | 104.9688 | 123100.0 |
| 2000-05-25 13:00:00 | DIA | ETF | 104.875 | 105.3125 | 104.5625 | 104.625 | 106500.0 |
| 2000-05-25 14:00:00 | DIA | ETF | 104.5625 | 104.5938 | 103.3438 | 103.4062 | 169800.0 |
| 2000-05-25 15:00:00 | DIA | ETF | 103.625 | 103.625 | 102.5625 | 103.2812 | 461600.0 |
| 2000-05-25 16:00:00 | DIA | ETF | 103.25 | 103.5 | 103.125 | 103.5 | 23500.0 |
> showing 26 of 123 rows — these rows as CSV