PREVIEW / etf_1hour / 2001-01-11
file: by_date/etf_1hour/2001/2001-01-11.parquet size: 10 KB rows: 191
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-01-11 09:00:00 | SPY | ETF | 131.0938 | 132.0 | 131.0938 | 132.0 | 833900.0 |
| 2001-01-11 10:00:00 | SPY | ETF | 132.0 | 132.875 | 131.625 | 132.1562 | 1422300.0 |
| 2001-01-11 11:00:00 | SPY | ETF | 132.1562 | 132.7188 | 132.0625 | 132.5 | 595700.0 |
| 2001-01-11 12:00:00 | SPY | ETF | 132.4062 | 132.7812 | 132.25 | 132.375 | 714800.0 |
| 2001-01-11 13:00:00 | SPY | ETF | 132.3125 | 132.7188 | 132.0312 | 132.5 | 518900.0 |
| 2001-01-11 14:00:00 | SPY | ETF | 132.625 | 133.0625 | 132.3125 | 132.9375 | 574900.0 |
| 2001-01-11 15:00:00 | SPY | ETF | 132.8125 | 133.4688 | 132.6875 | 132.75 | 1251700.0 |
| 2001-01-11 16:00:00 | SPY | ETF | 132.875 | 132.875 | 131.5 | 132.3125 | 1053500.0 |
| 2001-01-11 17:00:00 | SPY | ETF | 132.3125 | 132.3125 | 132.25 | 132.25 | 5100.0 |
| 2001-01-11 09:00:00 | QQQ | ETF | 59.25 | 60.9375 | 59.25 | 60.1875 | 9382500.0 |
| 2001-01-11 10:00:00 | QQQ | ETF | 60.25 | 61.4375 | 59.75 | 60.75 | 9788300.0 |
| 2001-01-11 11:00:00 | QQQ | ETF | 60.75 | 62.1562 | 60.6562 | 61.75 | 8567500.0 |
| 2001-01-11 12:00:00 | QQQ | ETF | 61.75 | 62.25 | 61.5 | 61.8125 | 5185900.0 |
| 2001-01-11 13:00:00 | QQQ | ETF | 61.7812 | 62.5312 | 61.375 | 62.375 | 5272900.0 |
| 2001-01-11 14:00:00 | QQQ | ETF | 62.375 | 63.125 | 62.375 | 62.75 | 9604100.0 |
| 2001-01-11 15:00:00 | QQQ | ETF | 62.6875 | 63.6875 | 62.6875 | 62.875 | 10546000.0 |
| 2001-01-11 16:00:00 | QQQ | ETF | 62.9688 | 62.9688 | 61.25 | 61.5 | 3949900.0 |
| 2001-01-11 17:00:00 | QQQ | ETF | 61.6875 | 62.125 | 61.4375 | 62.0625 | 239300.0 |
| 2001-01-11 18:00:00 | QQQ | ETF | 62.0625 | 62.25 | 62.0 | 62.125 | 101000.0 |
| 2001-01-11 09:00:00 | IWM | ETF | 47.25 | 47.7188 | 47.25 | 47.3438 | 38600.0 |
| 2001-01-11 10:00:00 | IWM | ETF | 47.6875 | 47.7812 | 47.625 | 47.6875 | 36800.0 |
| 2001-01-11 11:00:00 | IWM | ETF | 47.6719 | 47.9062 | 47.6719 | 47.8906 | 57800.0 |
| 2001-01-11 12:00:00 | IWM | ETF | 47.8906 | 48.0312 | 47.8438 | 47.875 | 7200.0 |
| 2001-01-11 13:00:00 | IWM | ETF | 47.9062 | 48.0 | 47.9062 | 48.0 | 2400.0 |
| 2001-01-11 14:00:00 | IWM | ETF | 48.0 | 48.3125 | 48.0 | 48.2188 | 72800.0 |
| 2001-01-11 15:00:00 | IWM | ETF | 48.2969 | 48.4375 | 48.0938 | 48.2344 | 64200.0 |
| 2001-01-11 09:00:00 | DIA | ETF | 106.375 | 106.5312 | 105.6562 | 105.9375 | 60200.0 |
| 2001-01-11 10:00:00 | DIA | ETF | 106.0 | 106.4688 | 105.75 | 105.9062 | 313100.0 |
| 2001-01-11 11:00:00 | DIA | ETF | 105.9688 | 106.125 | 105.5 | 105.7812 | 122900.0 |
| 2001-01-11 12:00:00 | DIA | ETF | 105.875 | 106.1875 | 105.75 | 105.75 | 167300.0 |
| 2001-01-11 13:00:00 | DIA | ETF | 105.75 | 106.0 | 105.5625 | 105.8125 | 168400.0 |
| 2001-01-11 14:00:00 | DIA | ETF | 105.8125 | 106.1875 | 105.6875 | 106.0625 | 287300.0 |
| 2001-01-11 15:00:00 | DIA | ETF | 106.0312 | 106.5 | 106.0 | 106.25 | 396700.0 |
| 2001-01-11 16:00:00 | DIA | ETF | 106.125 | 106.125 | 105.25 | 105.9375 | 74900.0 |
> showing 34 of 191 rows — these rows as CSV