PREVIEW / etf_1hour / 2001-01-24
file: by_date/etf_1hour/2001/2001-01-24.parquet size: 10 KB rows: 200
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-24 09:00:00 | SPY | ETF | 136.25 | 136.7188 | 135.875 | 136.4375 | 1031200.0 |
| 2001-01-24 10:00:00 | SPY | ETF | 136.5 | 137.0625 | 136.25 | 136.6875 | 1098800.0 |
| 2001-01-24 11:00:00 | SPY | ETF | 136.8125 | 137.3125 | 136.6875 | 136.9062 | 1024500.0 |
| 2001-01-24 12:00:00 | SPY | ETF | 136.9688 | 137.0312 | 136.4062 | 136.5 | 439800.0 |
| 2001-01-24 13:00:00 | SPY | ETF | 136.4062 | 136.5625 | 135.8438 | 136.1875 | 567800.0 |
| 2001-01-24 14:00:00 | SPY | ETF | 136.1875 | 136.7188 | 136.0 | 136.4375 | 716400.0 |
| 2001-01-24 15:00:00 | SPY | ETF | 136.5625 | 136.9375 | 136.25 | 136.6875 | 607900.0 |
| 2001-01-24 16:00:00 | SPY | ETF | 136.7188 | 136.8438 | 136.25 | 136.25 | 501700.0 |
| 2001-01-24 17:00:00 | SPY | ETF | 136.4375 | 136.4375 | 136.25 | 136.25 | 2000.0 |
| 2001-01-24 18:00:00 | SPY | ETF | 136.25 | 136.25 | 136.25 | 136.25 | 300.0 |
| 2001-01-24 09:00:00 | QQQ | ETF | 68.0625 | 68.7188 | 67.375 | 68.4062 | 10173200.0 |
| 2001-01-24 10:00:00 | QQQ | ETF | 68.4688 | 68.9375 | 67.9375 | 68.6875 | 9762100.0 |
| 2001-01-24 11:00:00 | QQQ | ETF | 68.6562 | 69.125 | 68.5 | 68.8125 | 7653100.0 |
| 2001-01-24 12:00:00 | QQQ | ETF | 68.75 | 68.875 | 68.0 | 68.0625 | 4787300.0 |
| 2001-01-24 13:00:00 | QQQ | ETF | 68.0625 | 68.0625 | 67.0312 | 67.5 | 6265600.0 |
| 2001-01-24 14:00:00 | QQQ | ETF | 67.5 | 68.125 | 67.3125 | 67.8125 | 4523400.0 |
| 2001-01-24 15:00:00 | QQQ | ETF | 67.8438 | 68.4375 | 67.5 | 67.9375 | 6010400.0 |
| 2001-01-24 16:00:00 | QQQ | ETF | 67.9375 | 68.0625 | 66.375 | 66.8125 | 2518400.0 |
| 2001-01-24 17:00:00 | QQQ | ETF | 66.75 | 67.375 | 66.7188 | 66.9375 | 200600.0 |
| 2001-01-24 18:00:00 | QQQ | ETF | 66.9375 | 67.125 | 66.6875 | 66.75 | 88500.0 |
| 2001-01-24 09:00:00 | IWM | ETF | 50.25 | 50.25 | 49.9062 | 50.2344 | 79000.0 |
| 2001-01-24 10:00:00 | IWM | ETF | 50.2344 | 50.3438 | 50.1562 | 50.2188 | 107400.0 |
| 2001-01-24 11:00:00 | IWM | ETF | 50.2812 | 50.4062 | 50.1875 | 50.2812 | 72600.0 |
| 2001-01-24 12:00:00 | IWM | ETF | 50.2188 | 50.2656 | 50.0938 | 50.1875 | 98600.0 |
| 2001-01-24 13:00:00 | IWM | ETF | 50.2812 | 50.2812 | 49.8125 | 49.8125 | 239400.0 |
| 2001-01-24 14:00:00 | IWM | ETF | 49.9375 | 50.1562 | 49.9375 | 50.0625 | 151600.0 |
| 2001-01-24 15:00:00 | IWM | ETF | 50.0 | 50.2344 | 50.0 | 50.0 | 136800.0 |
| 2001-01-24 09:00:00 | DIA | ETF | 106.5312 | 106.625 | 106.25 | 106.5 | 81600.0 |
| 2001-01-24 10:00:00 | DIA | ETF | 106.5938 | 106.8438 | 106.375 | 106.5938 | 137000.0 |
| 2001-01-24 11:00:00 | DIA | ETF | 106.6875 | 106.9688 | 106.5625 | 106.6875 | 89500.0 |
| 2001-01-24 12:00:00 | DIA | ETF | 106.625 | 106.625 | 106.3125 | 106.3125 | 138700.0 |
| 2001-01-24 13:00:00 | DIA | ETF | 106.3438 | 106.5938 | 106.2188 | 106.3125 | 43100.0 |
| 2001-01-24 14:00:00 | DIA | ETF | 106.4375 | 106.7188 | 106.3438 | 106.5625 | 51100.0 |
| 2001-01-24 15:00:00 | DIA | ETF | 106.6875 | 106.75 | 106.25 | 106.6875 | 57500.0 |
| 2001-01-24 16:00:00 | DIA | ETF | 106.625 | 106.625 | 106.3438 | 106.3438 | 11600.0 |
> showing 35 of 200 rows — these rows as CSV