PREVIEW / etf_1hour / 2000-03-07
file: by_date/etf_1hour/2000/2000-03-07.parquet size: 8 KB rows: 138
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-03-07 09:00:00 | SPY | ETF | 140.0 | 140.1562 | 138.6562 | 138.75 | 1735100.0 |
| 2000-03-07 10:00:00 | SPY | ETF | 138.625 | 138.875 | 136.875 | 137.875 | 2790600.0 |
| 2000-03-07 11:00:00 | SPY | ETF | 137.7812 | 139.1562 | 137.7812 | 138.75 | 3161300.0 |
| 2000-03-07 12:00:00 | SPY | ETF | 138.75 | 139.0 | 137.7812 | 138.0 | 3083300.0 |
| 2000-03-07 13:00:00 | SPY | ETF | 137.9062 | 138.125 | 136.875 | 136.9062 | 2345500.0 |
| 2000-03-07 14:00:00 | SPY | ETF | 137.125 | 138.0625 | 136.75 | 137.5312 | 1766100.0 |
| 2000-03-07 15:00:00 | SPY | ETF | 137.6562 | 137.7812 | 135.2188 | 136.0312 | 2440500.0 |
| 2000-03-07 16:00:00 | SPY | ETF | 135.9375 | 137.0625 | 135.3125 | 137.0312 | 2559400.0 |
| 2000-03-07 09:00:00 | QQQ | ETF | 113.8125 | 113.875 | 112.5 | 112.5312 | 3800200.0 |
| 2000-03-07 10:00:00 | QQQ | ETF | 112.5312 | 112.6875 | 110.0 | 111.3125 | 9380000.0 |
| 2000-03-07 11:00:00 | QQQ | ETF | 111.4062 | 113.3125 | 111.25 | 113.1562 | 3511600.0 |
| 2000-03-07 12:00:00 | QQQ | ETF | 113.125 | 113.375 | 112.125 | 112.6562 | 2882800.0 |
| 2000-03-07 13:00:00 | QQQ | ETF | 112.625 | 112.8125 | 110.625 | 110.75 | 4577600.0 |
| 2000-03-07 14:00:00 | QQQ | ETF | 110.9375 | 111.9375 | 110.4375 | 111.625 | 6725400.0 |
| 2000-03-07 15:00:00 | QQQ | ETF | 111.625 | 111.9375 | 108.75 | 109.75 | 7671000.0 |
| 2000-03-07 16:00:00 | QQQ | ETF | 109.625 | 109.8125 | 109.3125 | 109.5 | 840000.0 |
| 2000-03-07 17:00:00 | QQQ | ETF | 109.4375 | 110.0 | 109.4375 | 110.0 | 5000.0 |
| 2000-03-07 18:00:00 | QQQ | ETF | 110.0 | 110.25 | 110.0 | 110.25 | 1000.0 |
| 2000-03-07 09:00:00 | DIA | ETF | 101.4688 | 101.5312 | 99.6875 | 99.75 | 194400.0 |
| 2000-03-07 10:00:00 | DIA | ETF | 99.6875 | 99.9688 | 98.2812 | 99.4375 | 687200.0 |
| 2000-03-07 11:00:00 | DIA | ETF | 99.4375 | 100.0 | 99.375 | 99.6562 | 227200.0 |
| 2000-03-07 12:00:00 | DIA | ETF | 99.6562 | 99.75 | 99.125 | 99.1875 | 127100.0 |
| 2000-03-07 13:00:00 | DIA | ETF | 99.1562 | 99.2188 | 98.375 | 98.5938 | 643600.0 |
| 2000-03-07 14:00:00 | DIA | ETF | 98.5625 | 99.375 | 98.4062 | 99.125 | 438700.0 |
| 2000-03-07 15:00:00 | DIA | ETF | 99.1562 | 99.1875 | 97.5312 | 98.0312 | 1354300.0 |
| 2000-03-07 16:00:00 | DIA | ETF | 98.0938 | 98.0938 | 97.5625 | 98.0 | 55900.0 |
| 2000-03-07 17:00:00 | DIA | ETF | 98.0 | 98.0 | 98.0 | 98.0 | 200.0 |
| 2000-03-07 18:00:00 | DIA | ETF | 98.0 | 98.0 | 98.0 | 98.0 | 100.0 |
> showing 28 of 138 rows — these rows as CSV