PREVIEW / etf_1hour / 2001-12-24
file: by_date/etf_1hour/2001/2001-12-24.parquet size: 10 KB rows: 168
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-12-24 09:00:00 | SPY | ETF | 114.83 | 115.04 | 114.8 | 114.87 | 1553600.0 |
| 2001-12-24 10:00:00 | SPY | ETF | 114.85 | 115.02 | 114.78 | 114.9 | 1016200.0 |
| 2001-12-24 11:00:00 | SPY | ETF | 114.9 | 114.99 | 114.75 | 114.84 | 513300.0 |
| 2001-12-24 12:00:00 | SPY | ETF | 114.81 | 114.93 | 114.72 | 114.77 | 1341000.0 |
| 2001-12-24 13:00:00 | SPY | ETF | 114.72 | 114.77 | 114.61 | 114.73 | 1221500.0 |
| 2001-12-24 09:00:00 | QQQ | ETF | 39.54 | 39.63 | 39.35 | 39.35 | 2688600.0 |
| 2001-12-24 10:00:00 | QQQ | ETF | 39.35 | 39.51 | 39.31 | 39.37 | 4451500.0 |
| 2001-12-24 11:00:00 | QQQ | ETF | 39.36 | 39.4 | 39.15 | 39.26 | 3706100.0 |
| 2001-12-24 12:00:00 | QQQ | ETF | 39.25 | 39.38 | 39.23 | 39.26 | 2462100.0 |
| 2001-12-24 13:00:00 | QQQ | ETF | 39.25 | 39.32 | 39.19 | 39.32 | 213700.0 |
| 2001-12-24 09:00:00 | IWM | ETF | 48.225 | 48.295 | 48.15 | 48.295 | 89400.0 |
| 2001-12-24 10:00:00 | IWM | ETF | 48.3 | 48.425 | 48.225 | 48.35 | 72400.0 |
| 2001-12-24 11:00:00 | IWM | ETF | 48.355 | 48.365 | 48.105 | 48.3 | 61000.0 |
| 2001-12-24 12:00:00 | IWM | ETF | 48.295 | 48.37 | 48.14 | 48.35 | 87000.0 |
| 2001-12-24 13:00:00 | IWM | ETF | 48.325 | 48.325 | 48.325 | 48.325 | 6000.0 |
| 2001-12-24 09:00:00 | DIA | ETF | 100.52 | 100.65 | 100.48 | 100.5 | 153800.0 |
| 2001-12-24 10:00:00 | DIA | ETF | 100.56 | 100.78 | 100.47 | 100.72 | 81500.0 |
| 2001-12-24 11:00:00 | DIA | ETF | 100.7 | 100.77 | 100.58 | 100.6 | 78400.0 |
| 2001-12-24 12:00:00 | DIA | ETF | 100.6 | 100.7 | 100.42 | 100.53 | 51900.0 |
| 2001-12-24 13:00:00 | DIA | ETF | 100.48 | 100.49 | 100.4 | 100.49 | 2900.0 |
> showing 20 of 168 rows — these rows as CSV