PREVIEW / etf_1hour / 2000-10-25
file: by_date/etf_1hour/2000/2000-10-25.parquet size: 10 KB rows: 180
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-25 09:00:00 | SPY | ETF | 138.75 | 138.75 | 137.5312 | 138.2188 | 1271100.0 |
| 2000-10-25 10:00:00 | SPY | ETF | 138.1875 | 139.4688 | 137.9375 | 139.0312 | 1555600.0 |
| 2000-10-25 11:00:00 | SPY | ETF | 139.0312 | 139.5625 | 138.25 | 138.3125 | 411600.0 |
| 2000-10-25 12:00:00 | SPY | ETF | 138.4375 | 138.6875 | 138.0625 | 138.25 | 615000.0 |
| 2000-10-25 13:00:00 | SPY | ETF | 138.0625 | 138.25 | 137.375 | 137.9688 | 655000.0 |
| 2000-10-25 14:00:00 | SPY | ETF | 137.875 | 138.5312 | 137.3125 | 137.3125 | 781600.0 |
| 2000-10-25 15:00:00 | SPY | ETF | 137.2812 | 137.5625 | 136.375 | 136.9062 | 2075400.0 |
| 2000-10-25 16:00:00 | SPY | ETF | 136.875 | 139.375 | 136.0625 | 136.0625 | 1427000.0 |
| 2000-10-25 17:00:00 | SPY | ETF | 136.25 | 137.0 | 136.25 | 137.0 | 2200.0 |
| 2000-10-25 18:00:00 | SPY | ETF | 136.5 | 136.5 | 136.4375 | 136.4375 | 1500.0 |
| 2000-10-25 09:00:00 | QQQ | ETF | 81.25 | 81.5 | 79.6875 | 80.875 | 8600200.0 |
| 2000-10-25 10:00:00 | QQQ | ETF | 80.75 | 82.0 | 80.3125 | 81.375 | 8624100.0 |
| 2000-10-25 11:00:00 | QQQ | ETF | 81.3125 | 82.0 | 79.9375 | 80.0625 | 4030800.0 |
| 2000-10-25 12:00:00 | QQQ | ETF | 80.125 | 80.4375 | 79.25 | 79.625 | 4940400.0 |
| 2000-10-25 13:00:00 | QQQ | ETF | 79.6875 | 80.0938 | 78.25 | 79.1562 | 5741800.0 |
| 2000-10-25 14:00:00 | QQQ | ETF | 79.0312 | 79.8125 | 78.1875 | 78.25 | 4276500.0 |
| 2000-10-25 15:00:00 | QQQ | ETF | 78.25 | 78.4688 | 76.875 | 77.6875 | 10017500.0 |
| 2000-10-25 16:00:00 | QQQ | ETF | 77.6875 | 79.9375 | 76.875 | 77.625 | 1271700.0 |
| 2000-10-25 17:00:00 | QQQ | ETF | 77.6875 | 78.25 | 77.625 | 78.125 | 21400.0 |
| 2000-10-25 18:00:00 | QQQ | ETF | 78.125 | 78.4375 | 77.875 | 78.0 | 4200.0 |
| 2000-10-25 09:00:00 | IWM | ETF | 48.25 | 48.25 | 47.6875 | 48.0625 | 17000.0 |
| 2000-10-25 10:00:00 | IWM | ETF | 48.125 | 48.25 | 48.0938 | 48.1719 | 1600.0 |
| 2000-10-25 11:00:00 | IWM | ETF | 48.4062 | 48.5 | 48.25 | 48.25 | 800.0 |
| 2000-10-25 12:00:00 | IWM | ETF | 47.9531 | 48.0938 | 47.9531 | 48.0938 | 2800.0 |
| 2000-10-25 13:00:00 | IWM | ETF | 47.8125 | 47.8125 | 47.8125 | 47.8125 | 200.0 |
| 2000-10-25 14:00:00 | IWM | ETF | 47.75 | 47.8906 | 47.75 | 47.7812 | 2600.0 |
| 2000-10-25 15:00:00 | IWM | ETF | 47.7344 | 47.7344 | 47.4375 | 47.4375 | 6800.0 |
| 2000-10-25 16:00:00 | IWM | ETF | 47.2656 | 47.2656 | 47.2656 | 47.2656 | 200.0 |
| 2000-10-25 09:00:00 | DIA | ETF | 103.5625 | 103.5625 | 102.7188 | 103.25 | 216700.0 |
| 2000-10-25 10:00:00 | DIA | ETF | 103.25 | 104.2812 | 103.1875 | 103.9375 | 345800.0 |
| 2000-10-25 11:00:00 | DIA | ETF | 103.9375 | 104.6875 | 103.875 | 103.9688 | 207400.0 |
| 2000-10-25 12:00:00 | DIA | ETF | 103.875 | 104.1875 | 103.6562 | 103.8438 | 173400.0 |
| 2000-10-25 13:00:00 | DIA | ETF | 103.8125 | 103.9062 | 103.3438 | 103.875 | 173100.0 |
| 2000-10-25 14:00:00 | DIA | ETF | 103.75 | 104.2188 | 103.5 | 103.625 | 157600.0 |
| 2000-10-25 15:00:00 | DIA | ETF | 103.625 | 103.7812 | 103.0312 | 103.3125 | 265200.0 |
| 2000-10-25 16:00:00 | DIA | ETF | 103.3125 | 103.3125 | 102.875 | 103.0312 | 31800.0 |
> showing 36 of 180 rows — these rows as CSV