PREVIEW / etf_1hour / 2000-01-14
file: by_date/etf_1hour/2000/2000-01-14.parquet size: 8 KB rows: 133
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-14 09:00:00 | SPY | ETF | 146.5312 | 147.3125 | 146.4688 | 147.25 | 1449600.0 |
| 2000-01-14 10:00:00 | SPY | ETF | 147.0938 | 147.4375 | 146.6875 | 147.25 | 1000400.0 |
| 2000-01-14 11:00:00 | SPY | ETF | 147.3125 | 147.4688 | 146.5 | 147.0938 | 918600.0 |
| 2000-01-14 12:00:00 | SPY | ETF | 147.0938 | 147.0938 | 145.9688 | 146.5 | 1271600.0 |
| 2000-01-14 13:00:00 | SPY | ETF | 146.3438 | 146.9688 | 146.3438 | 146.7812 | 233800.0 |
| 2000-01-14 14:00:00 | SPY | ETF | 146.7812 | 147.125 | 146.3125 | 146.5 | 812600.0 |
| 2000-01-14 15:00:00 | SPY | ETF | 146.375 | 147.0 | 146.125 | 146.5 | 1133400.0 |
| 2000-01-14 16:00:00 | SPY | ETF | 146.5312 | 146.9688 | 146.4688 | 146.9688 | 573700.0 |
| 2000-01-14 09:00:00 | QQQ | ETF | 93.0 | 93.375 | 92.5 | 92.5 | 4921800.0 |
| 2000-01-14 10:00:00 | QQQ | ETF | 92.5625 | 93.5 | 92.25 | 93.375 | 3485800.0 |
| 2000-01-14 11:00:00 | QQQ | ETF | 93.4219 | 93.625 | 92.5938 | 93.0625 | 2561600.0 |
| 2000-01-14 12:00:00 | QQQ | ETF | 93.0 | 93.0625 | 92.0 | 92.5156 | 2557800.0 |
| 2000-01-14 13:00:00 | QQQ | ETF | 92.625 | 93.375 | 92.5625 | 93.0469 | 1367000.0 |
| 2000-01-14 14:00:00 | QQQ | ETF | 93.0312 | 93.4844 | 92.5 | 92.875 | 2505600.0 |
| 2000-01-14 15:00:00 | QQQ | ETF | 92.875 | 93.4375 | 92.1875 | 92.5 | 3542800.0 |
| 2000-01-14 16:00:00 | QQQ | ETF | 92.5312 | 92.875 | 92.4531 | 92.6875 | 282400.0 |
| 2000-01-14 18:00:00 | QQQ | ETF | 93.25 | 93.375 | 93.25 | 93.375 | 600.0 |
| 2000-01-14 09:00:00 | DIA | ETF | 117.4688 | 117.4688 | 116.9062 | 117.0625 | 295100.0 |
| 2000-01-14 10:00:00 | DIA | ETF | 117.3438 | 117.3438 | 116.875 | 117.0 | 84100.0 |
| 2000-01-14 11:00:00 | DIA | ETF | 117.125 | 117.4375 | 116.875 | 117.0625 | 109700.0 |
| 2000-01-14 12:00:00 | DIA | ETF | 117.0 | 117.0 | 116.125 | 116.8125 | 958800.0 |
| 2000-01-14 13:00:00 | DIA | ETF | 116.75 | 117.25 | 116.75 | 117.0938 | 80000.0 |
| 2000-01-14 14:00:00 | DIA | ETF | 117.0938 | 117.5 | 116.8125 | 117.0312 | 219100.0 |
| 2000-01-14 15:00:00 | DIA | ETF | 117.0 | 117.3438 | 116.8438 | 117.0312 | 174900.0 |
| 2000-01-14 16:00:00 | DIA | ETF | 117.1562 | 117.5 | 117.1562 | 117.5 | 11000.0 |
> showing 25 of 133 rows — these rows as CSV