PREVIEW / etf_1hour / 2000-01-07
file: by_date/etf_1hour/2000/2000-01-07.parquet size: 8 KB rows: 143
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-01-07 09:00:00 | SPY | ETF | 140.3125 | 141.4062 | 140.0625 | 141.0938 | 1107200.0 |
| 2000-01-07 10:00:00 | SPY | ETF | 141.25 | 142.5312 | 141.0 | 142.1875 | 1996100.0 |
| 2000-01-07 11:00:00 | SPY | ETF | 142.1875 | 142.3438 | 141.6562 | 142.0 | 854400.0 |
| 2000-01-07 12:00:00 | SPY | ETF | 141.875 | 142.1875 | 141.625 | 141.75 | 430800.0 |
| 2000-01-07 13:00:00 | SPY | ETF | 141.6562 | 142.7812 | 141.5938 | 142.1562 | 800600.0 |
| 2000-01-07 14:00:00 | SPY | ETF | 142.125 | 143.125 | 142.125 | 143.0 | 602500.0 |
| 2000-01-07 15:00:00 | SPY | ETF | 143.0 | 144.4375 | 142.8125 | 144.4375 | 1259100.0 |
| 2000-01-07 16:00:00 | SPY | ETF | 144.5 | 145.75 | 144.3125 | 145.75 | 794500.0 |
| 2000-01-07 09:00:00 | QQQ | ETF | 82.9375 | 83.875 | 82.5 | 83.875 | 5263800.0 |
| 2000-01-07 10:00:00 | QQQ | ETF | 83.5 | 86.0 | 83.5 | 85.75 | 4682800.0 |
| 2000-01-07 11:00:00 | QQQ | ETF | 85.75 | 85.9688 | 84.625 | 85.0 | 3732000.0 |
| 2000-01-07 12:00:00 | QQQ | ETF | 85.0 | 85.75 | 84.625 | 84.75 | 1801600.0 |
| 2000-01-07 13:00:00 | QQQ | ETF | 84.75 | 86.1875 | 84.625 | 85.5625 | 2815600.0 |
| 2000-01-07 14:00:00 | QQQ | ETF | 85.5625 | 86.4375 | 85.2812 | 86.2188 | 3184600.0 |
| 2000-01-07 15:00:00 | QQQ | ETF | 86.2188 | 88.4375 | 86.0156 | 88.4375 | 5429800.0 |
| 2000-01-07 16:00:00 | QQQ | ETF | 88.125 | 88.5 | 87.375 | 87.5 | 1143400.0 |
| 2000-01-07 17:00:00 | QQQ | ETF | 88.5 | 88.5 | 87.0 | 88.0 | 4000.0 |
| 2000-01-07 18:00:00 | QQQ | ETF | 88.5 | 90.0 | 88.5 | 90.0 | 1200.0 |
| 2000-01-07 09:00:00 | DIA | ETF | 113.3125 | 113.875 | 113.2188 | 113.875 | 269300.0 |
| 2000-01-07 10:00:00 | DIA | ETF | 113.8438 | 114.6875 | 113.75 | 114.6562 | 1056100.0 |
| 2000-01-07 11:00:00 | DIA | ETF | 114.375 | 114.5938 | 113.875 | 113.9688 | 770800.0 |
| 2000-01-07 12:00:00 | DIA | ETF | 114.0 | 114.1562 | 113.3438 | 113.7188 | 460400.0 |
| 2000-01-07 13:00:00 | DIA | ETF | 113.75 | 114.4688 | 113.7188 | 114.1562 | 159700.0 |
| 2000-01-07 14:00:00 | DIA | ETF | 114.1562 | 114.5938 | 114.0625 | 114.375 | 314800.0 |
| 2000-01-07 15:00:00 | DIA | ETF | 114.4688 | 115.375 | 114.25 | 115.375 | 651200.0 |
| 2000-01-07 16:00:00 | DIA | ETF | 115.3438 | 115.5625 | 115.1562 | 115.5 | 61200.0 |
> showing 26 of 143 rows — these rows as CSV