PREVIEW / etf_1hour / 2000-10-12
file: by_date/etf_1hour/2000/2000-10-12.parquet size: 10 KB rows: 192
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-10-12 09:00:00 | SPY | ETF | 137.2812 | 137.5938 | 134.75 | 135.0 | 1429900.0 |
| 2000-10-12 10:00:00 | SPY | ETF | 134.75 | 136.0 | 133.25 | 135.7812 | 3091100.0 |
| 2000-10-12 11:00:00 | SPY | ETF | 135.875 | 135.9688 | 134.5 | 134.625 | 1334600.0 |
| 2000-10-12 12:00:00 | SPY | ETF | 134.625 | 134.75 | 133.5 | 134.0625 | 1088000.0 |
| 2000-10-12 13:00:00 | SPY | ETF | 134.0625 | 134.6875 | 133.5 | 133.9688 | 984400.0 |
| 2000-10-12 14:00:00 | SPY | ETF | 133.9375 | 134.2812 | 133.1562 | 134.1562 | 1064900.0 |
| 2000-10-12 15:00:00 | SPY | ETF | 133.9688 | 134.6875 | 132.7812 | 133.1562 | 1740500.0 |
| 2000-10-12 16:00:00 | SPY | ETF | 133.0 | 133.625 | 132.9688 | 133.625 | 508900.0 |
| 2000-10-12 17:00:00 | SPY | ETF | 133.2812 | 133.625 | 133.25 | 133.625 | 1000500.0 |
| 2000-10-12 18:00:00 | SPY | ETF | 133.25 | 133.25 | 133.25 | 133.25 | 100.0 |
| 2000-10-12 09:00:00 | QQQ | ETF | 79.25 | 79.5625 | 77.1875 | 77.25 | 7294000.0 |
| 2000-10-12 10:00:00 | QQQ | ETF | 77.25 | 78.75 | 75.0625 | 78.5 | 13425100.0 |
| 2000-10-12 11:00:00 | QQQ | ETF | 78.5 | 79.0 | 76.5625 | 76.75 | 4891000.0 |
| 2000-10-12 12:00:00 | QQQ | ETF | 76.9375 | 77.125 | 75.875 | 76.625 | 4059900.0 |
| 2000-10-12 13:00:00 | QQQ | ETF | 76.7188 | 77.25 | 76.125 | 76.375 | 4823900.0 |
| 2000-10-12 14:00:00 | QQQ | ETF | 76.5 | 76.625 | 75.125 | 75.875 | 6258600.0 |
| 2000-10-12 15:00:00 | QQQ | ETF | 75.75 | 76.8125 | 74.4062 | 74.875 | 8762300.0 |
| 2000-10-12 16:00:00 | QQQ | ETF | 74.875 | 76.5 | 74.5 | 76.0625 | 1190700.0 |
| 2000-10-12 17:00:00 | QQQ | ETF | 76.1875 | 76.5 | 75.0 | 75.9375 | 417500.0 |
| 2000-10-12 18:00:00 | QQQ | ETF | 75.75 | 75.8125 | 75.5 | 75.5 | 1500.0 |
| 2000-10-12 09:00:00 | IWM | ETF | 47.8438 | 47.8438 | 47.5625 | 47.5625 | 17800.0 |
| 2000-10-12 10:00:00 | IWM | ETF | 47.1094 | 47.1875 | 46.875 | 47.1875 | 10800.0 |
| 2000-10-12 11:00:00 | IWM | ETF | 47.1875 | 47.25 | 46.9375 | 46.9688 | 38600.0 |
| 2000-10-12 12:00:00 | IWM | ETF | 46.75 | 46.75 | 46.5 | 46.5 | 29400.0 |
| 2000-10-12 13:00:00 | IWM | ETF | 46.5312 | 46.6562 | 46.4062 | 46.4062 | 23400.0 |
| 2000-10-12 14:00:00 | IWM | ETF | 46.3438 | 46.3906 | 46.2656 | 46.2812 | 13200.0 |
| 2000-10-12 15:00:00 | IWM | ETF | 46.375 | 46.4375 | 46.0938 | 46.1562 | 27800.0 |
| 2000-10-12 16:00:00 | IWM | ETF | 46.0 | 46.0 | 45.9688 | 45.9688 | 400.0 |
| 2000-10-12 09:00:00 | DIA | ETF | 104.375 | 104.375 | 101.75 | 101.8125 | 258600.0 |
| 2000-10-12 10:00:00 | DIA | ETF | 101.75 | 102.8438 | 101.0312 | 102.5 | 657300.0 |
| 2000-10-12 11:00:00 | DIA | ETF | 102.625 | 102.6875 | 101.25 | 101.3125 | 150500.0 |
| 2000-10-12 12:00:00 | DIA | ETF | 101.4375 | 101.5938 | 100.625 | 101.0625 | 411500.0 |
| 2000-10-12 13:00:00 | DIA | ETF | 101.0 | 101.5625 | 100.7188 | 101.125 | 316700.0 |
| 2000-10-12 14:00:00 | DIA | ETF | 101.2812 | 101.375 | 100.5625 | 101.1875 | 355500.0 |
| 2000-10-12 15:00:00 | DIA | ETF | 101.25 | 101.5938 | 100.25 | 100.625 | 425900.0 |
| 2000-10-12 16:00:00 | DIA | ETF | 100.4375 | 100.5938 | 100.375 | 100.375 | 62500.0 |
| 2000-10-12 17:00:00 | DIA | ETF | 103.0 | 103.0 | 100.625 | 100.625 | 300.0 |
> showing 37 of 192 rows — these rows as CSV