PREVIEW / etf_1hour / 2000-03-21
file: by_date/etf_1hour/2000/2000-03-21.parquet size: 8 KB rows: 128
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-21 09:00:00 | SPY | ETF | 145.5312 | 145.9062 | 144.5 | 144.7188 | 1016000.0 |
| 2000-03-21 10:00:00 | SPY | ETF | 144.7188 | 147.0312 | 144.5625 | 146.9375 | 3516500.0 |
| 2000-03-21 11:00:00 | SPY | ETF | 146.9375 | 147.5 | 146.5938 | 147.0625 | 1501800.0 |
| 2000-03-21 12:00:00 | SPY | ETF | 147.0312 | 147.1875 | 146.375 | 146.9062 | 745900.0 |
| 2000-03-21 13:00:00 | SPY | ETF | 146.7188 | 147.4688 | 146.5625 | 147.0625 | 654300.0 |
| 2000-03-21 14:00:00 | SPY | ETF | 147.2188 | 147.9375 | 146.2812 | 147.5 | 2703300.0 |
| 2000-03-21 15:00:00 | SPY | ETF | 147.5 | 149.7188 | 147.5 | 149.7188 | 2466700.0 |
| 2000-03-21 16:00:00 | SPY | ETF | 149.75 | 149.75 | 149.125 | 149.1875 | 967100.0 |
| 2000-03-21 09:00:00 | QQQ | ETF | 106.125 | 106.5 | 103.5625 | 104.5 | 4960900.0 |
| 2000-03-21 10:00:00 | QQQ | ETF | 104.5 | 108.25 | 104.125 | 107.75 | 6933100.0 |
| 2000-03-21 11:00:00 | QQQ | ETF | 107.75 | 108.9688 | 106.25 | 106.875 | 4189600.0 |
| 2000-03-21 12:00:00 | QQQ | ETF | 106.9375 | 107.1875 | 105.75 | 106.625 | 1734900.0 |
| 2000-03-21 13:00:00 | QQQ | ETF | 106.5625 | 107.75 | 106.375 | 107.3125 | 2321900.0 |
| 2000-03-21 14:00:00 | QQQ | ETF | 107.3125 | 109.1875 | 106.0 | 108.75 | 6133100.0 |
| 2000-03-21 15:00:00 | QQQ | ETF | 108.6875 | 111.5 | 108.6875 | 111.3125 | 6237200.0 |
| 2000-03-21 16:00:00 | QQQ | ETF | 111.1875 | 111.875 | 111.0 | 111.0 | 534900.0 |
| 2000-03-21 17:00:00 | QQQ | ETF | 111.25 | 111.5 | 111.25 | 111.25 | 2000.0 |
| 2000-03-21 18:00:00 | QQQ | ETF | 111.25 | 111.9375 | 111.125 | 111.75 | 1400.0 |
| 2000-03-21 09:00:00 | DIA | ETF | 106.5625 | 106.5625 | 105.9375 | 105.9375 | 192100.0 |
| 2000-03-21 10:00:00 | DIA | ETF | 106.0625 | 107.5938 | 106.0312 | 107.5938 | 452800.0 |
| 2000-03-21 11:00:00 | DIA | ETF | 107.625 | 108.4688 | 107.4688 | 108.3125 | 526400.0 |
| 2000-03-21 12:00:00 | DIA | ETF | 108.25 | 108.25 | 107.7812 | 108.0625 | 118800.0 |
| 2000-03-21 13:00:00 | DIA | ETF | 108.0938 | 108.375 | 107.9375 | 108.1875 | 186800.0 |
| 2000-03-21 14:00:00 | DIA | ETF | 108.1875 | 108.5312 | 107.375 | 108.0 | 455400.0 |
| 2000-03-21 15:00:00 | DIA | ETF | 108.1875 | 108.9688 | 108.0938 | 108.9688 | 257200.0 |
| 2000-03-21 16:00:00 | DIA | ETF | 108.9688 | 109.1875 | 108.8438 | 109.125 | 105500.0 |
> showing 26 of 128 rows — these rows as CSV