PREVIEW / etf_1hour / 2000-02-09
file: by_date/etf_1hour/2000/2000-02-09.parquet size: 8 KB rows: 134
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-02-09 09:00:00 | SPY | ETF | 144.4688 | 144.4688 | 143.4375 | 143.6875 | 538900.0 |
| 2000-02-09 10:00:00 | SPY | ETF | 143.7188 | 144.2812 | 143.4375 | 143.9375 | 609600.0 |
| 2000-02-09 11:00:00 | SPY | ETF | 144.125 | 144.2812 | 142.7812 | 142.8438 | 1392300.0 |
| 2000-02-09 12:00:00 | SPY | ETF | 142.8125 | 143.0312 | 142.4062 | 142.5312 | 1210200.0 |
| 2000-02-09 13:00:00 | SPY | ETF | 142.625 | 143.125 | 142.1875 | 142.3125 | 753600.0 |
| 2000-02-09 14:00:00 | SPY | ETF | 142.4062 | 143.125 | 142.2812 | 142.875 | 1197400.0 |
| 2000-02-09 15:00:00 | SPY | ETF | 142.8125 | 142.875 | 141.375 | 141.4062 | 2057200.0 |
| 2000-02-09 16:00:00 | SPY | ETF | 141.4375 | 141.5625 | 141.25 | 141.2812 | 561700.0 |
| 2000-02-09 09:00:00 | QQQ | ETF | 102.0625 | 102.0625 | 101.0156 | 101.4062 | 4151200.0 |
| 2000-02-09 10:00:00 | QQQ | ETF | 101.3438 | 102.1875 | 101.125 | 101.9688 | 3758400.0 |
| 2000-02-09 11:00:00 | QQQ | ETF | 101.9688 | 102.1875 | 100.3438 | 100.5 | 3833600.0 |
| 2000-02-09 12:00:00 | QQQ | ETF | 100.4688 | 100.5312 | 99.5 | 100.0 | 4371800.0 |
| 2000-02-09 13:00:00 | QQQ | ETF | 99.9375 | 100.6875 | 99.75 | 99.75 | 1905000.0 |
| 2000-02-09 14:00:00 | QQQ | ETF | 99.75 | 100.75 | 99.6875 | 100.6875 | 3363600.0 |
| 2000-02-09 15:00:00 | QQQ | ETF | 100.625 | 100.7188 | 99.375 | 99.375 | 4182400.0 |
| 2000-02-09 16:00:00 | QQQ | ETF | 99.375 | 99.5 | 98.75 | 99.0 | 1460400.0 |
| 2000-02-09 18:00:00 | QQQ | ETF | 99.0 | 99.0 | 99.0 | 99.0 | 200.0 |
| 2000-02-09 09:00:00 | DIA | ETF | 109.1875 | 109.375 | 108.5 | 108.875 | 97700.0 |
| 2000-02-09 10:00:00 | DIA | ETF | 108.75 | 109.2812 | 108.5938 | 109.2188 | 71600.0 |
| 2000-02-09 11:00:00 | DIA | ETF | 109.0312 | 109.25 | 108.25 | 108.2812 | 62700.0 |
| 2000-02-09 12:00:00 | DIA | ETF | 108.25 | 108.5 | 108.0312 | 108.2188 | 112700.0 |
| 2000-02-09 13:00:00 | DIA | ETF | 108.1875 | 108.5312 | 107.75 | 107.875 | 245600.0 |
| 2000-02-09 14:00:00 | DIA | ETF | 107.875 | 108.5 | 107.8125 | 108.2188 | 60500.0 |
| 2000-02-09 15:00:00 | DIA | ETF | 108.25 | 108.25 | 107.0625 | 107.0625 | 114900.0 |
| 2000-02-09 16:00:00 | DIA | ETF | 107.1875 | 107.1875 | 106.7812 | 106.9062 | 51800.0 |
> showing 25 of 134 rows — these rows as CSV