PREVIEW / etf_1hour / 2001-11-23
file: by_date/etf_1hour/2001/2001-11-23.parquet size: 10 KB rows: 153
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-11-23 09:00:00 | SPY | ETF | 114.04 | 114.46 | 114.0 | 114.27 | 775700.0 |
| 2001-11-23 10:00:00 | SPY | ETF | 114.28 | 114.59 | 114.13 | 114.59 | 1086600.0 |
| 2001-11-23 11:00:00 | SPY | ETF | 114.59 | 115.24 | 114.54 | 115.17 | 1322000.0 |
| 2001-11-23 12:00:00 | SPY | ETF | 115.19 | 115.66 | 115.15 | 115.46 | 2394100.0 |
| 2001-11-23 13:00:00 | SPY | ETF | 115.49 | 115.75 | 115.38 | 115.68 | 598700.0 |
| 2001-11-23 09:00:00 | QQQ | ETF | 38.76 | 38.9 | 38.57 | 38.69 | 4355000.0 |
| 2001-11-23 10:00:00 | QQQ | ETF | 38.67 | 38.88 | 38.57 | 38.75 | 4647200.0 |
| 2001-11-23 11:00:00 | QQQ | ETF | 38.75 | 39.28 | 38.72 | 39.22 | 8810700.0 |
| 2001-11-23 12:00:00 | QQQ | ETF | 39.23 | 39.43 | 39.16 | 39.27 | 6808200.0 |
| 2001-11-23 13:00:00 | QQQ | ETF | 39.25 | 39.32 | 39.2 | 39.28 | 1071400.0 |
| 2001-11-23 09:00:00 | IWM | ETF | 45.025 | 45.225 | 45.025 | 45.225 | 6600.0 |
| 2001-11-23 10:00:00 | IWM | ETF | 45.225 | 45.44 | 45.065 | 45.43 | 18600.0 |
| 2001-11-23 11:00:00 | IWM | ETF | 45.42 | 45.59 | 45.41 | 45.56 | 35800.0 |
| 2001-11-23 12:00:00 | IWM | ETF | 45.7 | 45.775 | 45.5 | 45.74 | 162600.0 |
| 2001-11-23 13:00:00 | IWM | ETF | 45.74 | 45.74 | 45.74 | 45.74 | 1000.0 |
| 2001-11-23 09:00:00 | DIA | ETF | 98.55 | 98.97 | 98.45 | 98.79 | 180100.0 |
| 2001-11-23 10:00:00 | DIA | ETF | 98.84 | 98.99 | 98.66 | 98.92 | 165000.0 |
| 2001-11-23 11:00:00 | DIA | ETF | 98.97 | 99.47 | 98.89 | 99.38 | 195500.0 |
| 2001-11-23 12:00:00 | DIA | ETF | 99.43 | 99.81 | 99.33 | 99.71 | 245200.0 |
| 2001-11-23 13:00:00 | DIA | ETF | 99.7 | 99.95 | 99.68 | 99.9 | 81300.0 |
> showing 20 of 153 rows — these rows as CSV