PREVIEW / etf_1hour / 2001-02-09
file: by_date/etf_1hour/2001/2001-02-09.parquet size: 11 KB rows: 202
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-02-09 09:00:00 | SPY | ETF | 133.35 | 133.35 | 132.8 | 132.94 | 1541900.0 |
| 2001-02-09 10:00:00 | SPY | ETF | 132.9 | 133.35 | 132.5 | 132.89 | 1713400.0 |
| 2001-02-09 11:00:00 | SPY | ETF | 132.74 | 132.89 | 132.3 | 132.54 | 1756700.0 |
| 2001-02-09 12:00:00 | SPY | ETF | 132.54 | 132.75 | 132.33 | 132.43 | 1165300.0 |
| 2001-02-09 13:00:00 | SPY | ETF | 132.5 | 132.77 | 132.16 | 132.37 | 477400.0 |
| 2001-02-09 14:00:00 | SPY | ETF | 132.35 | 132.48 | 131.85 | 131.88 | 661600.0 |
| 2001-02-09 15:00:00 | SPY | ETF | 131.84 | 132.05 | 131.26 | 131.83 | 1965800.0 |
| 2001-02-09 16:00:00 | SPY | ETF | 131.75 | 132.5 | 131.47 | 132.5 | 566200.0 |
| 2001-02-09 09:00:00 | QQQ | ETF | 58.25 | 58.6 | 57.55 | 57.69 | 8468600.0 |
| 2001-02-09 10:00:00 | QQQ | ETF | 57.69 | 58.56 | 57.25 | 57.52 | 9383200.0 |
| 2001-02-09 11:00:00 | QQQ | ETF | 57.47 | 57.75 | 56.9 | 57.19 | 10519700.0 |
| 2001-02-09 12:00:00 | QQQ | ETF | 57.15 | 57.72 | 57.0 | 57.13 | 5194600.0 |
| 2001-02-09 13:00:00 | QQQ | ETF | 57.15 | 57.5 | 56.72 | 56.96 | 4287600.0 |
| 2001-02-09 14:00:00 | QQQ | ETF | 56.96 | 57.12 | 56.38 | 56.4 | 5700700.0 |
| 2001-02-09 15:00:00 | QQQ | ETF | 56.4 | 56.69 | 56.01 | 56.46 | 9457600.0 |
| 2001-02-09 16:00:00 | QQQ | ETF | 56.47 | 61.04 | 56.11 | 56.7 | 1710300.0 |
| 2001-02-09 17:00:00 | QQQ | ETF | 56.47 | 56.68 | 56.4 | 56.5 | 10800.0 |
| 2001-02-09 18:00:00 | QQQ | ETF | 56.45 | 56.6 | 56.4 | 56.48 | 2400.0 |
| 2001-02-09 09:00:00 | IWM | ETF | 49.875 | 49.975 | 49.8 | 49.8 | 36200.0 |
| 2001-02-09 10:00:00 | IWM | ETF | 49.68 | 49.965 | 49.54 | 49.54 | 172400.0 |
| 2001-02-09 11:00:00 | IWM | ETF | 49.74 | 49.74 | 49.4 | 49.4 | 168600.0 |
| 2001-02-09 12:00:00 | IWM | ETF | 49.57 | 49.575 | 49.45 | 49.5 | 15200.0 |
| 2001-02-09 13:00:00 | IWM | ETF | 49.375 | 49.675 | 49.3 | 49.4 | 215400.0 |
| 2001-02-09 14:00:00 | IWM | ETF | 49.475 | 49.475 | 49.2 | 49.205 | 9400.0 |
| 2001-02-09 15:00:00 | IWM | ETF | 49.2 | 49.5 | 49.125 | 49.3 | 367800.0 |
| 2001-02-09 09:00:00 | DIA | ETF | 108.5 | 108.98 | 108.5 | 108.76 | 243700.0 |
| 2001-02-09 10:00:00 | DIA | ETF | 108.86 | 109.0 | 108.52 | 108.61 | 205300.0 |
| 2001-02-09 11:00:00 | DIA | ETF | 108.61 | 108.76 | 108.22 | 108.41 | 287100.0 |
| 2001-02-09 12:00:00 | DIA | ETF | 108.42 | 108.54 | 108.2 | 108.26 | 212100.0 |
| 2001-02-09 13:00:00 | DIA | ETF | 108.25 | 108.6 | 108.1 | 108.12 | 134500.0 |
| 2001-02-09 14:00:00 | DIA | ETF | 108.23 | 108.39 | 107.91 | 107.91 | 110100.0 |
| 2001-02-09 15:00:00 | DIA | ETF | 108.05 | 108.24 | 107.67 | 108.05 | 215300.0 |
| 2001-02-09 16:00:00 | DIA | ETF | 108.0 | 108.1 | 107.91 | 108.02 | 119500.0 |
> showing 33 of 202 rows — these rows as CSV