PREVIEW / etf_1hour / 2001-01-03
file: by_date/etf_1hour/2001/2001-01-03.parquet size: 11 KB rows: 208
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-03 09:00:00 | SPY | ETF | 128.3125 | 129.5312 | 128.3125 | 128.8125 | 859000.0 |
| 2001-01-03 10:00:00 | SPY | ETF | 128.8125 | 130.4688 | 128.7188 | 129.3125 | 1216700.0 |
| 2001-01-03 11:00:00 | SPY | ETF | 129.5312 | 129.5312 | 128.0938 | 128.3438 | 1019600.0 |
| 2001-01-03 12:00:00 | SPY | ETF | 128.375 | 128.7188 | 127.6562 | 128.5625 | 1223600.0 |
| 2001-01-03 13:00:00 | SPY | ETF | 128.6562 | 136.0 | 128.1562 | 133.0 | 8169600.0 |
| 2001-01-03 14:00:00 | SPY | ETF | 133.0 | 134.8125 | 132.625 | 134.1562 | 3014000.0 |
| 2001-01-03 15:00:00 | SPY | ETF | 134.3438 | 135.3438 | 134.1562 | 135.0 | 1416900.0 |
| 2001-01-03 16:00:00 | SPY | ETF | 134.8438 | 135.5 | 134.0312 | 134.0312 | 2424200.0 |
| 2001-01-03 17:00:00 | SPY | ETF | 134.875 | 135.0 | 134.875 | 135.0 | 2000.0 |
| 2001-01-03 09:00:00 | QQQ | ETF | 52.1875 | 54.1875 | 52.1562 | 53.25 | 11923000.0 |
| 2001-01-03 10:00:00 | QQQ | ETF | 53.25 | 55.3125 | 52.6875 | 54.5625 | 14830600.0 |
| 2001-01-03 11:00:00 | QQQ | ETF | 54.5312 | 54.6562 | 53.0 | 53.0938 | 8650600.0 |
| 2001-01-03 12:00:00 | QQQ | ETF | 53.0 | 54.125 | 52.3438 | 54.0 | 6702600.0 |
| 2001-01-03 13:00:00 | QQQ | ETF | 54.0625 | 63.5 | 53.2812 | 59.3125 | 36219900.0 |
| 2001-01-03 14:00:00 | QQQ | ETF | 59.375 | 62.25 | 59.25 | 61.8438 | 17551000.0 |
| 2001-01-03 15:00:00 | QQQ | ETF | 62.0625 | 63.0625 | 61.75 | 62.75 | 15106000.0 |
| 2001-01-03 16:00:00 | QQQ | ETF | 62.8125 | 65.25 | 58.0 | 62.0 | 4302600.0 |
| 2001-01-03 17:00:00 | QQQ | ETF | 62.0 | 62.375 | 61.25 | 62.0938 | 54800.0 |
| 2001-01-03 18:00:00 | QQQ | ETF | 62.125 | 62.25 | 62.125 | 62.25 | 1800.0 |
| 2001-01-03 09:00:00 | IWM | ETF | 45.75 | 46.1875 | 45.75 | 45.9375 | 39800.0 |
| 2001-01-03 10:00:00 | IWM | ETF | 45.9688 | 46.5781 | 45.875 | 46.25 | 81800.0 |
| 2001-01-03 11:00:00 | IWM | ETF | 46.2188 | 46.375 | 46.1562 | 46.25 | 6800.0 |
| 2001-01-03 12:00:00 | IWM | ETF | 46.125 | 46.125 | 45.7188 | 45.75 | 6000.0 |
| 2001-01-03 13:00:00 | IWM | ETF | 45.9688 | 48.75 | 45.8125 | 47.3125 | 605800.0 |
| 2001-01-03 14:00:00 | IWM | ETF | 47.5 | 48.0312 | 47.25 | 48.0312 | 280600.0 |
| 2001-01-03 15:00:00 | IWM | ETF | 48.0 | 48.25 | 47.8125 | 48.1094 | 339200.0 |
| 2001-01-03 16:00:00 | IWM | ETF | 48.1094 | 48.1094 | 48.1094 | 48.1094 | 47400.0 |
| 2001-01-03 09:00:00 | DIA | ETF | 106.4062 | 107.375 | 106.3438 | 106.6875 | 452600.0 |
| 2001-01-03 10:00:00 | DIA | ETF | 106.75 | 107.6562 | 106.5312 | 106.7188 | 472900.0 |
| 2001-01-03 11:00:00 | DIA | ETF | 106.6562 | 106.8125 | 105.9062 | 106.1875 | 326300.0 |
| 2001-01-03 12:00:00 | DIA | ETF | 106.0312 | 106.4375 | 105.625 | 106.4375 | 205000.0 |
| 2001-01-03 13:00:00 | DIA | ETF | 106.375 | 112.5 | 106.1875 | 108.5 | 1659000.0 |
| 2001-01-03 14:00:00 | DIA | ETF | 108.75 | 109.7188 | 108.5 | 109.375 | 709300.0 |
| 2001-01-03 15:00:00 | DIA | ETF | 109.5 | 110.125 | 109.3125 | 109.625 | 397800.0 |
| 2001-01-03 16:00:00 | DIA | ETF | 109.6875 | 109.8125 | 109.375 | 109.5 | 156300.0 |
| 2001-01-03 17:00:00 | DIA | ETF | 109.5 | 109.5 | 109.5 | 109.5 | 100.0 |
> showing 36 of 208 rows — these rows as CSV