PREVIEW / etf_1hour / 2000-05-18
file: by_date/etf_1hour/2000/2000-05-18.parquet size: 8 KB rows: 114
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-18 09:00:00 | SPY | ETF | 145.625 | 146.0625 | 145.3438 | 145.8125 | 569100.0 |
| 2000-05-18 10:00:00 | SPY | ETF | 145.7812 | 146.3125 | 145.1875 | 145.4375 | 394100.0 |
| 2000-05-18 11:00:00 | SPY | ETF | 145.5 | 145.5 | 144.5625 | 144.8438 | 544200.0 |
| 2000-05-18 12:00:00 | SPY | ETF | 144.6875 | 145.0625 | 144.625 | 145.0 | 628300.0 |
| 2000-05-18 13:00:00 | SPY | ETF | 144.9375 | 145.0 | 144.375 | 144.6875 | 374600.0 |
| 2000-05-18 14:00:00 | SPY | ETF | 144.6875 | 145.4375 | 144.6875 | 144.875 | 561800.0 |
| 2000-05-18 15:00:00 | SPY | ETF | 144.75 | 144.9688 | 143.9375 | 144.0625 | 855000.0 |
| 2000-05-18 16:00:00 | SPY | ETF | 144.0312 | 144.3438 | 143.8125 | 143.8125 | 382000.0 |
| 2000-05-18 18:00:00 | SPY | ETF | 143.375 | 143.375 | 143.375 | 143.375 | 300.0 |
| 2000-05-18 09:00:00 | QQQ | ETF | 89.0 | 89.3438 | 87.6875 | 88.625 | 1857600.0 |
| 2000-05-18 10:00:00 | QQQ | ETF | 88.625 | 89.125 | 88.0 | 88.5 | 2454700.0 |
| 2000-05-18 11:00:00 | QQQ | ETF | 88.5625 | 88.5938 | 86.6875 | 87.0 | 3110800.0 |
| 2000-05-18 12:00:00 | QQQ | ETF | 86.9375 | 87.625 | 86.875 | 87.5 | 2450900.0 |
| 2000-05-18 13:00:00 | QQQ | ETF | 87.5938 | 87.625 | 86.875 | 87.125 | 1414700.0 |
| 2000-05-18 14:00:00 | QQQ | ETF | 87.125 | 87.9688 | 86.875 | 87.125 | 2018600.0 |
| 2000-05-18 15:00:00 | QQQ | ETF | 87.125 | 87.375 | 85.5625 | 85.625 | 4610400.0 |
| 2000-05-18 16:00:00 | QQQ | ETF | 85.625 | 85.875 | 85.375 | 85.875 | 1007400.0 |
| 2000-05-18 17:00:00 | QQQ | ETF | 85.625 | 85.875 | 85.625 | 85.875 | 2600.0 |
| 2000-05-18 18:00:00 | QQQ | ETF | 85.75 | 85.75 | 85.75 | 85.75 | 100.0 |
| 2000-05-18 09:00:00 | DIA | ETF | 108.0312 | 108.5938 | 107.9062 | 108.5625 | 63500.0 |
| 2000-05-18 10:00:00 | DIA | ETF | 108.5312 | 108.8125 | 108.0 | 108.375 | 155900.0 |
| 2000-05-18 11:00:00 | DIA | ETF | 108.3438 | 108.375 | 107.6875 | 107.8438 | 169700.0 |
| 2000-05-18 12:00:00 | DIA | ETF | 107.875 | 108.25 | 107.875 | 108.25 | 29000.0 |
| 2000-05-18 13:00:00 | DIA | ETF | 108.0938 | 108.3438 | 107.8438 | 107.9688 | 105400.0 |
| 2000-05-18 14:00:00 | DIA | ETF | 107.9688 | 108.5938 | 107.9688 | 108.3125 | 139300.0 |
| 2000-05-18 15:00:00 | DIA | ETF | 108.2812 | 108.3125 | 107.5625 | 107.75 | 175700.0 |
| 2000-05-18 16:00:00 | DIA | ETF | 107.9062 | 107.9062 | 107.4062 | 107.4375 | 91800.0 |
> showing 27 of 114 rows — these rows as CSV