PREVIEW / etf_1hour / 2000-04-07
file: by_date/etf_1hour/2000/2000-04-07.parquet size: 8 KB rows: 113
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-04-07 09:00:00 | SPY | ETF | 151.5625 | 151.6875 | 150.5 | 150.5938 | 485700.0 |
| 2000-04-07 10:00:00 | SPY | ETF | 151.0 | 151.6562 | 150.5312 | 151.6562 | 810400.0 |
| 2000-04-07 11:00:00 | SPY | ETF | 151.5625 | 152.0625 | 151.375 | 151.6875 | 315700.0 |
| 2000-04-07 12:00:00 | SPY | ETF | 151.6562 | 152.125 | 151.4688 | 151.75 | 640400.0 |
| 2000-04-07 13:00:00 | SPY | ETF | 151.8125 | 152.0938 | 151.25 | 151.25 | 524200.0 |
| 2000-04-07 14:00:00 | SPY | ETF | 151.125 | 151.4375 | 150.6562 | 151.0625 | 1712000.0 |
| 2000-04-07 15:00:00 | SPY | ETF | 151.0625 | 151.9688 | 151.0 | 151.375 | 858900.0 |
| 2000-04-07 09:00:00 | QQQ | ETF | 104.125 | 104.5 | 102.875 | 103.1875 | 4605200.0 |
| 2000-04-07 10:00:00 | QQQ | ETF | 103.1875 | 104.9688 | 102.9375 | 104.8125 | 2980300.0 |
| 2000-04-07 11:00:00 | QQQ | ETF | 105.0 | 105.75 | 104.8125 | 105.0625 | 3100200.0 |
| 2000-04-07 12:00:00 | QQQ | ETF | 105.0 | 105.75 | 104.75 | 105.0625 | 2060300.0 |
| 2000-04-07 13:00:00 | QQQ | ETF | 105.0625 | 105.7188 | 104.875 | 104.875 | 1435100.0 |
| 2000-04-07 14:00:00 | QQQ | ETF | 104.9375 | 105.25 | 104.2188 | 104.8125 | 2373000.0 |
| 2000-04-07 15:00:00 | QQQ | ETF | 104.875 | 107.0 | 104.875 | 107.0 | 3341000.0 |
| 2000-04-07 16:00:00 | QQQ | ETF | 106.9375 | 107.375 | 106.75 | 106.875 | 466700.0 |
| 2000-04-07 09:00:00 | DIA | ETF | 111.9688 | 111.9688 | 110.8125 | 111.0625 | 329100.0 |
| 2000-04-07 10:00:00 | DIA | ETF | 111.0625 | 111.5625 | 110.9062 | 111.1562 | 96600.0 |
| 2000-04-07 11:00:00 | DIA | ETF | 111.4375 | 111.75 | 111.125 | 111.25 | 64600.0 |
| 2000-04-07 12:00:00 | DIA | ETF | 111.4375 | 111.7188 | 111.25 | 111.4375 | 89500.0 |
| 2000-04-07 13:00:00 | DIA | ETF | 111.5 | 111.7188 | 111.25 | 111.25 | 48000.0 |
| 2000-04-07 14:00:00 | DIA | ETF | 111.1875 | 111.3438 | 110.5625 | 111.0 | 90600.0 |
| 2000-04-07 15:00:00 | DIA | ETF | 110.9688 | 111.3438 | 110.6875 | 110.9375 | 230800.0 |
| 2000-04-07 16:00:00 | DIA | ETF | 111.0 | 111.1562 | 110.875 | 110.875 | 527100.0 |
> showing 23 of 113 rows — these rows as CSV