PREVIEW / etf_1hour / 2000-05-17
file: by_date/etf_1hour/2000/2000-05-17.parquet size: 8 KB rows: 127
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-05-17 09:00:00 | SPY | ETF | 145.6875 | 145.9375 | 144.875 | 145.5938 | 1146200.0 |
| 2000-05-17 10:00:00 | SPY | ETF | 145.375 | 145.625 | 144.7812 | 145.25 | 771300.0 |
| 2000-05-17 11:00:00 | SPY | ETF | 145.125 | 145.3125 | 144.4688 | 144.7812 | 606600.0 |
| 2000-05-17 12:00:00 | SPY | ETF | 144.6875 | 145.2188 | 144.6875 | 144.9688 | 503500.0 |
| 2000-05-17 13:00:00 | SPY | ETF | 145.0 | 145.6875 | 144.75 | 145.4375 | 794900.0 |
| 2000-05-17 14:00:00 | SPY | ETF | 145.5 | 145.625 | 144.75 | 145.0312 | 540100.0 |
| 2000-05-17 15:00:00 | SPY | ETF | 145.0625 | 146.1875 | 144.9375 | 145.25 | 1036100.0 |
| 2000-05-17 16:00:00 | SPY | ETF | 145.1875 | 145.5625 | 145.1562 | 145.1562 | 407800.0 |
| 2000-05-17 17:00:00 | SPY | ETF | 145.1562 | 145.1562 | 145.1562 | 145.1562 | 300.0 |
| 2000-05-17 09:00:00 | QQQ | ETF | 89.25 | 90.0 | 88.5 | 89.125 | 3007200.0 |
| 2000-05-17 10:00:00 | QQQ | ETF | 89.125 | 89.375 | 88.125 | 88.9688 | 3492800.0 |
| 2000-05-17 11:00:00 | QQQ | ETF | 88.75 | 88.875 | 87.75 | 88.4375 | 2567400.0 |
| 2000-05-17 12:00:00 | QQQ | ETF | 88.625 | 89.125 | 88.2812 | 88.6875 | 1746400.0 |
| 2000-05-17 13:00:00 | QQQ | ETF | 88.625 | 89.9375 | 88.5 | 89.8125 | 2530100.0 |
| 2000-05-17 14:00:00 | QQQ | ETF | 89.8125 | 89.875 | 88.5 | 89.0 | 2045500.0 |
| 2000-05-17 15:00:00 | QQQ | ETF | 89.1875 | 90.5 | 88.6875 | 88.75 | 4285400.0 |
| 2000-05-17 16:00:00 | QQQ | ETF | 88.75 | 89.4375 | 88.625 | 89.1875 | 389500.0 |
| 2000-05-17 17:00:00 | QQQ | ETF | 89.125 | 89.125 | 89.0 | 89.125 | 2100.0 |
| 2000-05-17 18:00:00 | QQQ | ETF | 88.9375 | 88.9375 | 88.9375 | 88.9375 | 500.0 |
| 2000-05-17 09:00:00 | DIA | ETF | 108.3125 | 108.5938 | 108.0 | 108.3438 | 239100.0 |
| 2000-05-17 10:00:00 | DIA | ETF | 108.25 | 108.6875 | 107.75 | 108.1875 | 249300.0 |
| 2000-05-17 11:00:00 | DIA | ETF | 108.0625 | 108.25 | 107.625 | 107.8125 | 71200.0 |
| 2000-05-17 12:00:00 | DIA | ETF | 107.9062 | 108.1562 | 107.6875 | 107.9688 | 37400.0 |
| 2000-05-17 13:00:00 | DIA | ETF | 107.9375 | 108.4062 | 107.9375 | 108.4062 | 135600.0 |
| 2000-05-17 14:00:00 | DIA | ETF | 108.3125 | 108.3125 | 107.5625 | 107.8125 | 32000.0 |
| 2000-05-17 15:00:00 | DIA | ETF | 107.75 | 108.3438 | 107.75 | 108.0312 | 125500.0 |
| 2000-05-17 16:00:00 | DIA | ETF | 108.0312 | 108.0312 | 107.75 | 107.75 | 5900.0 |
> showing 27 of 127 rows — these rows as CSV