PREVIEW / etf_1hour / 2000-11-10
file: by_date/etf_1hour/2000/2000-11-10.parquet size: 10 KB rows: 190
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 |
|---|---|---|---|---|---|---|---|
| 2000-11-10 09:00:00 | SPY | ETF | 139.0 | 139.3125 | 138.5 | 138.6875 | 986300.0 |
| 2000-11-10 10:00:00 | SPY | ETF | 138.5625 | 139.4375 | 138.125 | 138.875 | 1104900.0 |
| 2000-11-10 11:00:00 | SPY | ETF | 138.8125 | 139.1562 | 137.8125 | 138.0938 | 633400.0 |
| 2000-11-10 12:00:00 | SPY | ETF | 138.125 | 138.5312 | 137.75 | 138.375 | 996500.0 |
| 2000-11-10 13:00:00 | SPY | ETF | 138.1875 | 138.8438 | 137.9375 | 138.125 | 1613900.0 |
| 2000-11-10 14:00:00 | SPY | ETF | 138.0 | 138.4688 | 137.375 | 138.25 | 954200.0 |
| 2000-11-10 15:00:00 | SPY | ETF | 138.375 | 138.5 | 136.875 | 136.9688 | 1639200.0 |
| 2000-11-10 16:00:00 | SPY | ETF | 136.9062 | 137.0 | 136.5312 | 136.625 | 465000.0 |
| 2000-11-10 09:00:00 | QQQ | ETF | 74.25 | 75.1875 | 73.9375 | 74.3125 | 6695100.0 |
| 2000-11-10 10:00:00 | QQQ | ETF | 74.375 | 75.0 | 73.4375 | 74.1875 | 8460200.0 |
| 2000-11-10 11:00:00 | QQQ | ETF | 74.2812 | 74.375 | 73.0625 | 73.375 | 5427000.0 |
| 2000-11-10 12:00:00 | QQQ | ETF | 73.5 | 74.125 | 73.0625 | 74.125 | 5644900.0 |
| 2000-11-10 13:00:00 | QQQ | ETF | 74.125 | 74.2812 | 73.25 | 73.4688 | 3947800.0 |
| 2000-11-10 14:00:00 | QQQ | ETF | 73.4375 | 73.9062 | 72.9375 | 73.6562 | 5643100.0 |
| 2000-11-10 15:00:00 | QQQ | ETF | 73.6875 | 73.875 | 72.0 | 72.0 | 8782300.0 |
| 2000-11-10 16:00:00 | QQQ | ETF | 72.0 | 72.25 | 71.5625 | 71.5625 | 2368800.0 |
| 2000-11-10 17:00:00 | QQQ | ETF | 71.6875 | 73.3125 | 71.5 | 72.0 | 78800.0 |
| 2000-11-10 18:00:00 | QQQ | ETF | 71.5 | 72.125 | 71.5 | 72.125 | 14000.0 |
| 2000-11-10 09:00:00 | IWM | ETF | 49.375 | 49.375 | 48.875 | 48.875 | 8600.0 |
| 2000-11-10 10:00:00 | IWM | ETF | 48.625 | 48.7969 | 48.625 | 48.7969 | 3800.0 |
| 2000-11-10 11:00:00 | IWM | ETF | 48.6562 | 48.6875 | 48.3438 | 48.3438 | 74000.0 |
| 2000-11-10 12:00:00 | IWM | ETF | 48.4062 | 48.4688 | 48.25 | 48.3438 | 30000.0 |
| 2000-11-10 13:00:00 | IWM | ETF | 48.375 | 48.4375 | 48.3438 | 48.3438 | 5400.0 |
| 2000-11-10 14:00:00 | IWM | ETF | 48.3438 | 48.4062 | 48.1562 | 48.1562 | 12200.0 |
| 2000-11-10 15:00:00 | IWM | ETF | 48.375 | 48.375 | 48.0625 | 48.0625 | 48200.0 |
| 2000-11-10 16:00:00 | IWM | ETF | 48.0 | 48.0 | 48.0 | 48.0 | 2000.0 |
| 2000-11-10 09:00:00 | DIA | ETF | 107.5625 | 107.8125 | 107.0625 | 107.25 | 137200.0 |
| 2000-11-10 10:00:00 | DIA | ETF | 107.4375 | 107.75 | 106.75 | 107.5625 | 157400.0 |
| 2000-11-10 11:00:00 | DIA | ETF | 107.4062 | 107.5938 | 106.75 | 106.875 | 209500.0 |
| 2000-11-10 12:00:00 | DIA | ETF | 106.9688 | 107.2188 | 106.4688 | 106.9062 | 591200.0 |
| 2000-11-10 13:00:00 | DIA | ETF | 106.7188 | 107.2188 | 106.5312 | 106.7188 | 79600.0 |
| 2000-11-10 14:00:00 | DIA | ETF | 106.7812 | 107.0 | 106.125 | 106.75 | 179600.0 |
| 2000-11-10 15:00:00 | DIA | ETF | 106.8125 | 107.0 | 106.0312 | 106.0625 | 186200.0 |
| 2000-11-10 16:00:00 | DIA | ETF | 106.0312 | 107.125 | 106.0 | 106.125 | 40800.0 |
| 2000-11-10 18:00:00 | DIA | ETF | 105.125 | 105.125 | 105.125 | 105.125 | 500.0 |
> showing 35 of 190 rows — these rows as CSV