PREVIEW / etf_1hour / 2000-03-14
file: by_date/etf_1hour/2000/2000-03-14.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-14 09:00:00 | SPY | ETF | 139.2812 | 140.0938 | 139.125 | 139.125 | 523000.0 |
| 2000-03-14 10:00:00 | SPY | ETF | 139.1875 | 139.875 | 139.0 | 139.375 | 1686600.0 |
| 2000-03-14 11:00:00 | SPY | ETF | 139.375 | 139.7188 | 138.6562 | 138.6875 | 439600.0 |
| 2000-03-14 12:00:00 | SPY | ETF | 138.6875 | 139.0312 | 137.625 | 138.0625 | 1481100.0 |
| 2000-03-14 13:00:00 | SPY | ETF | 138.3125 | 138.875 | 138.0625 | 138.5 | 1550800.0 |
| 2000-03-14 14:00:00 | SPY | ETF | 138.3438 | 138.6562 | 137.5312 | 138.0 | 672000.0 |
| 2000-03-14 15:00:00 | SPY | ETF | 137.875 | 138.375 | 136.1562 | 136.5 | 1222000.0 |
| 2000-03-14 16:00:00 | SPY | ETF | 136.625 | 136.6562 | 136.2812 | 136.625 | 612400.0 |
| 2000-03-14 18:00:00 | SPY | ETF | 136.625 | 136.625 | 136.625 | 136.625 | 200.0 |
| 2000-03-14 09:00:00 | QQQ | ETF | 112.75 | 113.375 | 112.0 | 112.1562 | 3579600.0 |
| 2000-03-14 10:00:00 | QQQ | ETF | 112.1562 | 113.2188 | 112.0 | 112.4062 | 5692600.0 |
| 2000-03-14 11:00:00 | QQQ | ETF | 112.25 | 112.8594 | 110.9375 | 111.0 | 3386800.0 |
| 2000-03-14 12:00:00 | QQQ | ETF | 111.0 | 111.0 | 108.3438 | 109.25 | 7229800.0 |
| 2000-03-14 13:00:00 | QQQ | ETF | 109.25 | 110.1875 | 109.0 | 109.375 | 4771200.0 |
| 2000-03-14 14:00:00 | QQQ | ETF | 109.2812 | 109.5938 | 107.9375 | 108.625 | 3731400.0 |
| 2000-03-14 15:00:00 | QQQ | ETF | 108.625 | 108.7812 | 105.5 | 105.7188 | 9162400.0 |
| 2000-03-14 16:00:00 | QQQ | ETF | 105.8125 | 106.375 | 105.0 | 106.0625 | 1264800.0 |
| 2000-03-14 17:00:00 | QQQ | ETF | 106.375 | 107.5 | 106.375 | 106.875 | 3200.0 |
| 2000-03-14 18:00:00 | QQQ | ETF | 107.375 | 107.375 | 107.375 | 107.375 | 400.0 |
| 2000-03-14 09:00:00 | DIA | ETF | 100.3125 | 100.6875 | 99.75 | 99.7812 | 62000.0 |
| 2000-03-14 10:00:00 | DIA | ETF | 99.75 | 100.1562 | 99.6875 | 99.875 | 143500.0 |
| 2000-03-14 11:00:00 | DIA | ETF | 100.0 | 100.375 | 99.6562 | 99.6875 | 62800.0 |
| 2000-03-14 12:00:00 | DIA | ETF | 99.75 | 100.0 | 99.1562 | 99.4062 | 196000.0 |
| 2000-03-14 13:00:00 | DIA | ETF | 99.5 | 99.9062 | 99.4062 | 99.4688 | 146200.0 |
| 2000-03-14 14:00:00 | DIA | ETF | 99.4688 | 99.8125 | 98.875 | 99.4375 | 96800.0 |
| 2000-03-14 15:00:00 | DIA | ETF | 99.1875 | 99.6875 | 98.1875 | 98.1875 | 127700.0 |
| 2000-03-14 16:00:00 | DIA | ETF | 98.3438 | 98.4688 | 98.0 | 98.4688 | 18700.0 |
> showing 27 of 132 rows — these rows as CSV