PREVIEW / etf_1hour / 2001-02-15
file: by_date/etf_1hour/2001/2001-02-15.parquet size: 11 KB rows: 213
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-15 09:00:00 | SPY | ETF | 132.84 | 133.15 | 132.5 | 133.0 | 822800.0 |
| 2001-02-15 10:00:00 | SPY | ETF | 132.86 | 133.36 | 132.56 | 133.35 | 943600.0 |
| 2001-02-15 11:00:00 | SPY | ETF | 133.24 | 133.52 | 133.04 | 133.18 | 638000.0 |
| 2001-02-15 12:00:00 | SPY | ETF | 133.17 | 133.48 | 133.1 | 133.47 | 413100.0 |
| 2001-02-15 13:00:00 | SPY | ETF | 133.49 | 133.5 | 133.01 | 133.1 | 838700.0 |
| 2001-02-15 14:00:00 | SPY | ETF | 133.1 | 133.45 | 132.95 | 133.0 | 646400.0 |
| 2001-02-15 15:00:00 | SPY | ETF | 133.05 | 133.19 | 132.65 | 132.96 | 928200.0 |
| 2001-02-15 16:00:00 | SPY | ETF | 133.12 | 133.35 | 132.6 | 133.34 | 524200.0 |
| 2001-02-15 17:00:00 | SPY | ETF | 132.65 | 132.65 | 132.65 | 132.65 | 200.0 |
| 2001-02-15 18:00:00 | SPY | ETF | 132.8 | 133.0 | 132.55 | 132.55 | 2000.0 |
| 2001-02-15 09:00:00 | QQQ | ETF | 58.8 | 59.66 | 58.65 | 59.41 | 13707200.0 |
| 2001-02-15 10:00:00 | QQQ | ETF | 59.42 | 60.2 | 59.16 | 59.95 | 11513800.0 |
| 2001-02-15 11:00:00 | QQQ | ETF | 59.9 | 60.17 | 59.48 | 59.9 | 6033800.0 |
| 2001-02-15 12:00:00 | QQQ | ETF | 59.81 | 60.49 | 59.68 | 60.44 | 5248700.0 |
| 2001-02-15 13:00:00 | QQQ | ETF | 60.44 | 60.48 | 59.82 | 60.03 | 4966300.0 |
| 2001-02-15 14:00:00 | QQQ | ETF | 59.98 | 60.43 | 59.6 | 59.75 | 5462700.0 |
| 2001-02-15 15:00:00 | QQQ | ETF | 59.65 | 59.85 | 58.65 | 59.1 | 13538400.0 |
| 2001-02-15 16:00:00 | QQQ | ETF | 59.0 | 60.35 | 57.25 | 57.8 | 3976200.0 |
| 2001-02-15 17:00:00 | QQQ | ETF | 57.8 | 58.0 | 57.5 | 57.55 | 388300.0 |
| 2001-02-15 18:00:00 | QQQ | ETF | 57.55 | 57.56 | 57.1 | 57.54 | 42200.0 |
| 2001-02-15 09:00:00 | IWM | ETF | 51.0 | 51.0 | 50.575 | 50.975 | 378000.0 |
| 2001-02-15 10:00:00 | IWM | ETF | 50.8 | 50.97 | 50.675 | 50.775 | 131200.0 |
| 2001-02-15 11:00:00 | IWM | ETF | 50.825 | 51.0 | 50.74 | 50.925 | 96800.0 |
| 2001-02-15 12:00:00 | IWM | ETF | 50.925 | 51.075 | 50.87 | 51.075 | 276800.0 |
| 2001-02-15 13:00:00 | IWM | ETF | 51.0 | 51.05 | 50.925 | 50.925 | 14600.0 |
| 2001-02-15 14:00:00 | IWM | ETF | 51.0 | 51.05 | 50.905 | 51.05 | 68600.0 |
| 2001-02-15 15:00:00 | IWM | ETF | 50.85 | 50.85 | 50.515 | 50.725 | 47600.0 |
| 2001-02-15 16:00:00 | IWM | ETF | 50.75 | 50.75 | 50.65 | 50.65 | 83000.0 |
| 2001-02-15 09:00:00 | DIA | ETF | 108.7 | 108.85 | 108.31 | 108.77 | 177800.0 |
| 2001-02-15 10:00:00 | DIA | ETF | 108.74 | 109.3 | 108.55 | 109.24 | 273800.0 |
| 2001-02-15 11:00:00 | DIA | ETF | 109.35 | 109.42 | 109.02 | 109.11 | 129200.0 |
| 2001-02-15 12:00:00 | DIA | ETF | 109.19 | 109.43 | 109.11 | 109.33 | 49300.0 |
| 2001-02-15 13:00:00 | DIA | ETF | 109.25 | 109.33 | 108.99 | 109.01 | 79600.0 |
| 2001-02-15 14:00:00 | DIA | ETF | 109.18 | 109.43 | 109.0 | 109.05 | 20800.0 |
| 2001-02-15 15:00:00 | DIA | ETF | 109.17 | 109.3 | 108.81 | 109.2 | 122400.0 |
| 2001-02-15 16:00:00 | DIA | ETF | 109.25 | 109.34 | 109.1 | 109.34 | 30800.0 |
> showing 36 of 213 rows — these rows as CSV