PREVIEW / etf_1hour / 2001-01-18
file: by_date/etf_1hour/2001/2001-01-18.parquet size: 10 KB rows: 207
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 |
|---|---|---|---|---|---|---|---|
| 2001-01-18 09:00:00 | SPY | ETF | 133.4375 | 133.6562 | 132.9375 | 133.375 | 1262400.0 |
| 2001-01-18 10:00:00 | SPY | ETF | 133.4062 | 133.9688 | 132.9375 | 133.875 | 1220800.0 |
| 2001-01-18 11:00:00 | SPY | ETF | 133.8125 | 134.4375 | 133.6875 | 134.1562 | 1597500.0 |
| 2001-01-18 12:00:00 | SPY | ETF | 134.125 | 134.9062 | 134.0 | 134.6875 | 671900.0 |
| 2001-01-18 13:00:00 | SPY | ETF | 134.8125 | 135.3438 | 134.6562 | 135.3125 | 885100.0 |
| 2001-01-18 14:00:00 | SPY | ETF | 135.3438 | 135.5938 | 134.7812 | 134.875 | 794000.0 |
| 2001-01-18 15:00:00 | SPY | ETF | 134.9062 | 135.6875 | 134.8438 | 135.0312 | 1137400.0 |
| 2001-01-18 16:00:00 | SPY | ETF | 135.0 | 135.4375 | 134.625 | 135.4375 | 303900.0 |
| 2001-01-18 17:00:00 | SPY | ETF | 135.4375 | 135.4375 | 135.4375 | 135.4375 | 100.0 |
| 2001-01-18 18:00:00 | SPY | ETF | 135.0 | 135.0 | 135.0 | 135.0 | 100.0 |
| 2001-01-18 09:00:00 | QQQ | ETF | 64.125 | 64.1875 | 63.0312 | 63.9375 | 7367300.0 |
| 2001-01-18 10:00:00 | QQQ | ETF | 64.0 | 64.875 | 63.0625 | 64.625 | 8271000.0 |
| 2001-01-18 11:00:00 | QQQ | ETF | 64.7812 | 65.4688 | 64.625 | 64.75 | 7334900.0 |
| 2001-01-18 12:00:00 | QQQ | ETF | 64.75 | 65.625 | 64.625 | 65.375 | 5095400.0 |
| 2001-01-18 13:00:00 | QQQ | ETF | 65.375 | 65.9375 | 65.3125 | 65.8125 | 4912700.0 |
| 2001-01-18 14:00:00 | QQQ | ETF | 65.875 | 66.5 | 65.625 | 65.75 | 7943400.0 |
| 2001-01-18 15:00:00 | QQQ | ETF | 65.75 | 66.75 | 65.7188 | 66.5 | 9654200.0 |
| 2001-01-18 16:00:00 | QQQ | ETF | 66.5 | 68.0 | 64.9375 | 67.4688 | 1732600.0 |
| 2001-01-18 17:00:00 | QQQ | ETF | 67.4688 | 68.0 | 67.375 | 67.875 | 252700.0 |
| 2001-01-18 18:00:00 | QQQ | ETF | 67.875 | 68.5 | 67.75 | 68.0 | 59100.0 |
| 2001-01-18 09:00:00 | IWM | ETF | 49.4375 | 49.4375 | 48.9375 | 49.1562 | 36600.0 |
| 2001-01-18 10:00:00 | IWM | ETF | 49.0 | 49.0312 | 48.8438 | 49.0 | 181600.0 |
| 2001-01-18 11:00:00 | IWM | ETF | 49.0 | 49.125 | 49.0 | 49.125 | 32800.0 |
| 2001-01-18 12:00:00 | IWM | ETF | 48.9375 | 48.9375 | 48.8438 | 48.9219 | 31200.0 |
| 2001-01-18 13:00:00 | IWM | ETF | 48.9375 | 49.0469 | 48.7812 | 48.9062 | 23600.0 |
| 2001-01-18 14:00:00 | IWM | ETF | 48.9062 | 49.0312 | 48.9062 | 49.0312 | 63200.0 |
| 2001-01-18 15:00:00 | IWM | ETF | 49.0312 | 49.4688 | 49.0312 | 49.4219 | 402400.0 |
| 2001-01-18 16:00:00 | IWM | ETF | 49.25 | 49.5 | 49.25 | 49.5 | 121400.0 |
| 2001-01-18 09:00:00 | DIA | ETF | 106.3125 | 106.4375 | 105.8125 | 106.0312 | 279900.0 |
| 2001-01-18 10:00:00 | DIA | ETF | 105.8438 | 106.375 | 105.5938 | 106.375 | 242400.0 |
| 2001-01-18 11:00:00 | DIA | ETF | 106.3125 | 106.9062 | 106.1875 | 106.625 | 116600.0 |
| 2001-01-18 12:00:00 | DIA | ETF | 106.5625 | 107.1562 | 106.5625 | 107.0 | 76800.0 |
| 2001-01-18 13:00:00 | DIA | ETF | 107.0 | 107.4688 | 106.875 | 107.3125 | 130700.0 |
| 2001-01-18 14:00:00 | DIA | ETF | 107.1875 | 107.4688 | 106.75 | 106.75 | 63900.0 |
| 2001-01-18 15:00:00 | DIA | ETF | 106.75 | 107.25 | 106.6875 | 106.8125 | 111700.0 |
| 2001-01-18 16:00:00 | DIA | ETF | 106.9062 | 106.9062 | 106.625 | 106.75 | 48200.0 |
> showing 36 of 207 rows — these rows as CSV