PREVIEW / etf_1hour / 2002-01-15
file: by_date/etf_1hour/2002/2002-01-15.parquet size: 13 KB rows: 278
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-15 09:00:00 | SPY | ETF | 114.55 | 114.84 | 114.3 | 114.79 | 1952300.0 |
| 2002-01-15 10:00:00 | SPY | ETF | 114.82 | 115.22 | 114.82 | 114.96 | 2540400.0 |
| 2002-01-15 11:00:00 | SPY | ETF | 114.96 | 115.39 | 114.82 | 114.9 | 2268800.0 |
| 2002-01-15 12:00:00 | SPY | ETF | 114.94 | 114.95 | 114.65 | 114.81 | 1094100.0 |
| 2002-01-15 13:00:00 | SPY | ETF | 114.8 | 114.87 | 114.06 | 114.11 | 1200400.0 |
| 2002-01-15 14:00:00 | SPY | ETF | 114.08 | 114.43 | 113.9 | 114.21 | 2475600.0 |
| 2002-01-15 15:00:00 | SPY | ETF | 114.17 | 115.04 | 114.17 | 114.88 | 3517100.0 |
| 2002-01-15 16:00:00 | SPY | ETF | 114.89 | 115.2 | 114.05 | 114.63 | 4649000.0 |
| 2002-01-15 17:00:00 | SPY | ETF | 114.64 | 114.7 | 114.35 | 114.6 | 100700.0 |
| 2002-01-15 18:00:00 | SPY | ETF | 114.68 | 114.68 | 114.68 | 114.68 | 1000.0 |
| 2002-01-15 09:00:00 | QQQ | ETF | 40.03 | 40.19 | 39.76 | 40.14 | 8499100.0 |
| 2002-01-15 10:00:00 | QQQ | ETF | 40.16 | 40.32 | 40.05 | 40.2 | 9208900.0 |
| 2002-01-15 11:00:00 | QQQ | ETF | 40.21 | 40.75 | 40.1 | 40.2 | 10687000.0 |
| 2002-01-15 12:00:00 | QQQ | ETF | 40.19 | 40.24 | 39.94 | 40.11 | 5184400.0 |
| 2002-01-15 13:00:00 | QQQ | ETF | 40.11 | 40.16 | 39.62 | 39.64 | 4989800.0 |
| 2002-01-15 14:00:00 | QQQ | ETF | 39.66 | 39.92 | 39.56 | 39.78 | 9479700.0 |
| 2002-01-15 15:00:00 | QQQ | ETF | 39.77 | 40.19 | 39.71 | 40.13 | 12831100.0 |
| 2002-01-15 16:00:00 | QQQ | ETF | 40.14 | 40.55 | 39.5 | 39.67 | 4410600.0 |
| 2002-01-15 17:00:00 | QQQ | ETF | 39.66 | 39.77 | 39.63 | 39.69 | 294400.0 |
| 2002-01-15 18:00:00 | QQQ | ETF | 39.68 | 39.75 | 39.6 | 39.6 | 34500.0 |
| 2002-01-15 09:00:00 | IWM | ETF | 48.095 | 48.125 | 47.935 | 48.11 | 39800.0 |
| 2002-01-15 10:00:00 | IWM | ETF | 48.125 | 48.24 | 48.075 | 48.135 | 497200.0 |
| 2002-01-15 11:00:00 | IWM | ETF | 48.045 | 48.165 | 48.0 | 48.0 | 183400.0 |
| 2002-01-15 12:00:00 | IWM | ETF | 48.065 | 48.065 | 47.92 | 47.92 | 40600.0 |
| 2002-01-15 13:00:00 | IWM | ETF | 47.93 | 47.995 | 47.75 | 47.75 | 126000.0 |
| 2002-01-15 14:00:00 | IWM | ETF | 47.75 | 47.87 | 47.73 | 47.765 | 53400.0 |
| 2002-01-15 15:00:00 | IWM | ETF | 47.765 | 48.24 | 47.765 | 48.24 | 198800.0 |
| 2002-01-15 16:00:00 | IWM | ETF | 48.24 | 48.3 | 48.225 | 48.275 | 30400.0 |
| 2002-01-15 09:00:00 | DIA | ETF | 99.35 | 99.64 | 99.23 | 99.64 | 196000.0 |
| 2002-01-15 10:00:00 | DIA | ETF | 99.64 | 99.95 | 99.64 | 99.75 | 764800.0 |
| 2002-01-15 11:00:00 | DIA | ETF | 99.75 | 99.98 | 99.67 | 99.75 | 174000.0 |
| 2002-01-15 12:00:00 | DIA | ETF | 99.78 | 99.8 | 99.53 | 99.61 | 176800.0 |
| 2002-01-15 13:00:00 | DIA | ETF | 99.62 | 99.66 | 98.97 | 98.98 | 139600.0 |
| 2002-01-15 14:00:00 | DIA | ETF | 98.96 | 99.15 | 98.72 | 98.92 | 313700.0 |
| 2002-01-15 15:00:00 | DIA | ETF | 98.95 | 99.47 | 98.9 | 99.35 | 1118300.0 |
| 2002-01-15 16:00:00 | DIA | ETF | 99.36 | 99.57 | 98.5 | 99.5 | 78500.0 |
| 2002-01-15 17:00:00 | DIA | ETF | 99.2 | 99.2 | 98.05 | 98.05 | 1400.0 |
> showing 37 of 278 rows — these rows as CSV