PREVIEW / etf_1hour / 2000-03-29
file: by_date/etf_1hour/2000/2000-03-29.parquet size: 8 KB rows: 132
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-29 09:00:00 | SPY | ETF | 151.5625 | 152.0312 | 150.9375 | 151.0 | 642500.0 |
| 2000-03-29 10:00:00 | SPY | ETF | 151.0312 | 152.2188 | 151.0312 | 151.375 | 751400.0 |
| 2000-03-29 11:00:00 | SPY | ETF | 151.25 | 151.4062 | 149.6562 | 150.4062 | 1739500.0 |
| 2000-03-29 12:00:00 | SPY | ETF | 150.4062 | 151.0 | 149.75 | 150.125 | 604000.0 |
| 2000-03-29 13:00:00 | SPY | ETF | 150.0938 | 150.75 | 149.8125 | 150.1562 | 257000.0 |
| 2000-03-29 14:00:00 | SPY | ETF | 150.1562 | 151.7812 | 150.0 | 151.125 | 530800.0 |
| 2000-03-29 15:00:00 | SPY | ETF | 150.9062 | 152.4688 | 150.8125 | 151.0312 | 1801300.0 |
| 2000-03-29 16:00:00 | SPY | ETF | 151.2188 | 151.4688 | 151.0312 | 151.2188 | 295600.0 |
| 2000-03-29 09:00:00 | QQQ | ETF | 115.375 | 115.4375 | 113.1875 | 113.4375 | 2396700.0 |
| 2000-03-29 10:00:00 | QQQ | ETF | 113.4375 | 114.0 | 112.25 | 112.625 | 3643900.0 |
| 2000-03-29 11:00:00 | QQQ | ETF | 112.625 | 112.75 | 110.25 | 111.625 | 5809800.0 |
| 2000-03-29 12:00:00 | QQQ | ETF | 111.6875 | 112.0 | 110.0312 | 110.5 | 2391200.0 |
| 2000-03-29 13:00:00 | QQQ | ETF | 110.25 | 111.875 | 110.25 | 110.5 | 2527700.0 |
| 2000-03-29 14:00:00 | QQQ | ETF | 110.75 | 112.625 | 110.0 | 111.375 | 4540800.0 |
| 2000-03-29 15:00:00 | QQQ | ETF | 111.25 | 113.25 | 110.0 | 110.0312 | 5043000.0 |
| 2000-03-29 16:00:00 | QQQ | ETF | 110.25 | 110.625 | 110.0312 | 110.625 | 747600.0 |
| 2000-03-29 17:00:00 | QQQ | ETF | 110.5 | 110.5 | 110.25 | 110.25 | 1400.0 |
| 2000-03-29 18:00:00 | QQQ | ETF | 110.25 | 110.25 | 110.0 | 110.0 | 300.0 |
| 2000-03-29 09:00:00 | DIA | ETF | 109.8438 | 110.0625 | 109.4062 | 109.625 | 106700.0 |
| 2000-03-29 10:00:00 | DIA | ETF | 109.5625 | 110.4062 | 109.5625 | 110.0 | 214700.0 |
| 2000-03-29 11:00:00 | DIA | ETF | 109.875 | 109.9688 | 108.9375 | 109.5625 | 314800.0 |
| 2000-03-29 12:00:00 | DIA | ETF | 109.375 | 109.6562 | 109.0 | 109.1875 | 74900.0 |
| 2000-03-29 13:00:00 | DIA | ETF | 109.2188 | 109.625 | 109.125 | 109.3438 | 62400.0 |
| 2000-03-29 14:00:00 | DIA | ETF | 109.25 | 110.25 | 109.125 | 109.9375 | 98500.0 |
| 2000-03-29 15:00:00 | DIA | ETF | 110.125 | 111.2188 | 110.0625 | 110.4375 | 526700.0 |
| 2000-03-29 16:00:00 | DIA | ETF | 110.4375 | 110.7188 | 110.4375 | 110.7188 | 22100.0 |
| 2000-03-29 18:00:00 | DIA | ETF | 110.75 | 110.75 | 110.75 | 110.75 | 500.0 |
> showing 27 of 132 rows — these rows as CSV