PREVIEW / etf_1hour / 2001-01-12
file: by_date/etf_1hour/2001/2001-01-12.parquet size: 10 KB rows: 189
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-12 09:00:00 | SPY | ETF | 132.6875 | 132.8438 | 131.9688 | 132.0312 | 766800.0 |
| 2001-01-12 10:00:00 | SPY | ETF | 132.0 | 133.0 | 131.4375 | 132.8438 | 1122300.0 |
| 2001-01-12 11:00:00 | SPY | ETF | 132.875 | 133.7188 | 132.7188 | 132.875 | 784500.0 |
| 2001-01-12 12:00:00 | SPY | ETF | 132.75 | 132.9062 | 131.5625 | 132.1875 | 1037200.0 |
| 2001-01-12 13:00:00 | SPY | ETF | 132.125 | 132.3438 | 131.5625 | 132.125 | 373900.0 |
| 2001-01-12 14:00:00 | SPY | ETF | 132.0938 | 132.3125 | 131.2812 | 131.9375 | 780400.0 |
| 2001-01-12 15:00:00 | SPY | ETF | 131.9688 | 132.4688 | 131.5625 | 131.9062 | 1320900.0 |
| 2001-01-12 16:00:00 | SPY | ETF | 131.875 | 132.375 | 131.7812 | 132.0 | 833100.0 |
| 2001-01-12 09:00:00 | QQQ | ETF | 62.75 | 62.8438 | 61.5 | 61.8438 | 10522300.0 |
| 2001-01-12 10:00:00 | QQQ | ETF | 61.875 | 63.7188 | 61.5 | 63.4375 | 12128100.0 |
| 2001-01-12 11:00:00 | QQQ | ETF | 63.625 | 64.625 | 63.25 | 63.5938 | 10725400.0 |
| 2001-01-12 12:00:00 | QQQ | ETF | 63.6562 | 63.8125 | 62.0312 | 62.875 | 8638200.0 |
| 2001-01-12 13:00:00 | QQQ | ETF | 62.875 | 63.3125 | 62.3438 | 63.0938 | 4271400.0 |
| 2001-01-12 14:00:00 | QQQ | ETF | 63.0938 | 63.25 | 61.875 | 62.875 | 5560000.0 |
| 2001-01-12 15:00:00 | QQQ | ETF | 62.875 | 63.0 | 62.0625 | 62.4688 | 4798100.0 |
| 2001-01-12 16:00:00 | QQQ | ETF | 62.4375 | 62.8125 | 60.5 | 62.75 | 1273400.0 |
| 2001-01-12 17:00:00 | QQQ | ETF | 62.8125 | 62.8125 | 62.5625 | 62.75 | 11000.0 |
| 2001-01-12 18:00:00 | QQQ | ETF | 62.625 | 62.8125 | 62.625 | 62.625 | 1900.0 |
| 2001-01-12 09:00:00 | IWM | ETF | 48.0625 | 48.2188 | 47.9844 | 48.0938 | 133400.0 |
| 2001-01-12 10:00:00 | IWM | ETF | 48.0 | 48.3438 | 47.8125 | 48.1875 | 93400.0 |
| 2001-01-12 11:00:00 | IWM | ETF | 48.3438 | 48.7188 | 48.3125 | 48.5312 | 383000.0 |
| 2001-01-12 12:00:00 | IWM | ETF | 48.6562 | 48.6562 | 48.3125 | 48.4062 | 79800.0 |
| 2001-01-12 13:00:00 | IWM | ETF | 48.375 | 48.5 | 48.2812 | 48.4688 | 15400.0 |
| 2001-01-12 14:00:00 | IWM | ETF | 48.4688 | 48.4688 | 48.1875 | 48.1875 | 131600.0 |
| 2001-01-12 15:00:00 | IWM | ETF | 48.1875 | 48.5 | 48.1875 | 48.2812 | 41200.0 |
| 2001-01-12 16:00:00 | IWM | ETF | 48.1875 | 48.375 | 48.1875 | 48.375 | 15800.0 |
| 2001-01-12 09:00:00 | DIA | ETF | 105.5312 | 105.7812 | 105.375 | 105.4375 | 327200.0 |
| 2001-01-12 10:00:00 | DIA | ETF | 105.4688 | 106.0 | 105.0312 | 105.8125 | 391300.0 |
| 2001-01-12 11:00:00 | DIA | ETF | 105.6875 | 106.25 | 105.6875 | 105.6875 | 130300.0 |
| 2001-01-12 12:00:00 | DIA | ETF | 105.6875 | 105.8125 | 105.25 | 105.4375 | 65400.0 |
| 2001-01-12 13:00:00 | DIA | ETF | 105.375 | 105.4062 | 104.875 | 105.4062 | 156700.0 |
| 2001-01-12 14:00:00 | DIA | ETF | 105.375 | 105.4375 | 104.625 | 105.2812 | 207700.0 |
| 2001-01-12 15:00:00 | DIA | ETF | 105.125 | 105.4375 | 104.9375 | 105.1875 | 214900.0 |
| 2001-01-12 16:00:00 | DIA | ETF | 105.1875 | 105.4062 | 105.1875 | 105.3438 | 73600.0 |
> showing 34 of 189 rows — these rows as CSV