PREVIEW / etf_1hour / 2000-07-17
file: by_date/etf_1hour/2000/2000-07-17.parquet size: 9 KB rows: 173
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-07-17 09:00:00 | SPY | ETF | 150.9688 | 151.1875 | 150.75 | 151.0625 | 627800.0 |
| 2000-07-17 10:00:00 | SPY | ETF | 151.0 | 151.2812 | 150.6875 | 150.875 | 494000.0 |
| 2000-07-17 11:00:00 | SPY | ETF | 151.0 | 151.5938 | 151.0 | 151.3438 | 408600.0 |
| 2000-07-17 12:00:00 | SPY | ETF | 151.3438 | 151.625 | 151.3125 | 151.5 | 431100.0 |
| 2000-07-17 13:00:00 | SPY | ETF | 151.5 | 151.9375 | 151.4375 | 151.9375 | 218700.0 |
| 2000-07-17 14:00:00 | SPY | ETF | 151.8125 | 151.9688 | 151.5625 | 151.75 | 573700.0 |
| 2000-07-17 15:00:00 | SPY | ETF | 151.7188 | 151.9688 | 151.0625 | 151.0625 | 592400.0 |
| 2000-07-17 16:00:00 | SPY | ETF | 151.2188 | 151.2188 | 150.8438 | 151.0 | 1123600.0 |
| 2000-07-17 09:00:00 | QQQ | ETF | 100.9375 | 100.9375 | 100.0 | 100.3438 | 1821700.0 |
| 2000-07-17 10:00:00 | QQQ | ETF | 100.4375 | 101.125 | 99.875 | 100.875 | 2737400.0 |
| 2000-07-17 11:00:00 | QQQ | ETF | 100.875 | 101.875 | 100.875 | 101.8125 | 1888700.0 |
| 2000-07-17 12:00:00 | QQQ | ETF | 101.8125 | 102.0625 | 101.3125 | 101.5 | 1545800.0 |
| 2000-07-17 13:00:00 | QQQ | ETF | 101.4375 | 102.0 | 101.375 | 101.9375 | 1324100.0 |
| 2000-07-17 14:00:00 | QQQ | ETF | 101.875 | 102.0625 | 101.25 | 101.375 | 1351500.0 |
| 2000-07-17 15:00:00 | QQQ | ETF | 101.3438 | 101.875 | 101.125 | 101.5 | 1838300.0 |
| 2000-07-17 16:00:00 | QQQ | ETF | 101.4688 | 101.5625 | 101.125 | 101.375 | 561500.0 |
| 2000-07-17 17:00:00 | QQQ | ETF | 101.5 | 101.5 | 101.0 | 101.0 | 26500.0 |
| 2000-07-17 18:00:00 | QQQ | ETF | 102.0 | 102.0 | 101.375 | 101.75 | 3100.0 |
| 2000-07-17 09:00:00 | IWM | ETF | 54.3594 | 54.3594 | 54.2188 | 54.2188 | 4200.0 |
| 2000-07-17 10:00:00 | IWM | ETF | 54.3125 | 54.3438 | 54.3125 | 54.3438 | 4600.0 |
| 2000-07-17 11:00:00 | IWM | ETF | 54.4688 | 54.4688 | 54.4688 | 54.4688 | 20000.0 |
| 2000-07-17 12:00:00 | IWM | ETF | 54.4844 | 54.5 | 54.4844 | 54.5 | 1600.0 |
| 2000-07-17 13:00:00 | IWM | ETF | 54.5469 | 54.5469 | 54.5469 | 54.5469 | 400.0 |
| 2000-07-17 14:00:00 | IWM | ETF | 54.5781 | 54.5938 | 54.5 | 54.5938 | 4800.0 |
| 2000-07-17 15:00:00 | IWM | ETF | 54.5625 | 54.5625 | 54.4375 | 54.5 | 11000.0 |
| 2000-07-17 09:00:00 | DIA | ETF | 107.875 | 108.4375 | 107.875 | 108.1875 | 76600.0 |
| 2000-07-17 10:00:00 | DIA | ETF | 108.1562 | 108.1562 | 107.5625 | 107.6875 | 51100.0 |
| 2000-07-17 11:00:00 | DIA | ETF | 107.75 | 107.9062 | 107.6875 | 107.875 | 24400.0 |
| 2000-07-17 12:00:00 | DIA | ETF | 107.9062 | 108.25 | 107.875 | 108.125 | 85900.0 |
| 2000-07-17 13:00:00 | DIA | ETF | 108.25 | 108.6875 | 108.25 | 108.5 | 86900.0 |
| 2000-07-17 14:00:00 | DIA | ETF | 108.5938 | 108.6875 | 108.25 | 108.3125 | 296800.0 |
| 2000-07-17 15:00:00 | DIA | ETF | 108.4688 | 108.5625 | 108.125 | 108.2188 | 47000.0 |
| 2000-07-17 16:00:00 | DIA | ETF | 108.125 | 108.1875 | 107.9062 | 108.0 | 21900.0 |
> showing 33 of 173 rows — these rows as CSV