PREVIEW / etf_1hour / 2001-06-19
file: by_date/etf_1hour/2001/2001-06-19.parquet size: 12 KB rows: 241
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-06-19 09:00:00 | SPY | ETF | 122.38 | 122.89 | 122.0 | 122.54 | 1304400.0 |
| 2001-06-19 10:00:00 | SPY | ETF | 122.5 | 122.74 | 121.81 | 121.84 | 1291800.0 |
| 2001-06-19 11:00:00 | SPY | ETF | 121.8 | 121.88 | 121.38 | 121.83 | 1041300.0 |
| 2001-06-19 12:00:00 | SPY | ETF | 121.83 | 122.14 | 121.77 | 122.05 | 761600.0 |
| 2001-06-19 13:00:00 | SPY | ETF | 122.09 | 122.25 | 121.66 | 121.8 | 416800.0 |
| 2001-06-19 14:00:00 | SPY | ETF | 121.77 | 121.99 | 121.15 | 121.28 | 738300.0 |
| 2001-06-19 15:00:00 | SPY | ETF | 121.22 | 121.53 | 120.89 | 121.46 | 1230300.0 |
| 2001-06-19 16:00:00 | SPY | ETF | 121.41 | 122.48 | 121.07 | 121.7 | 603900.0 |
| 2001-06-19 17:00:00 | SPY | ETF | 121.55 | 121.55 | 121.5 | 121.5 | 1100.0 |
| 2001-06-19 09:00:00 | QQQ | ETF | 43.32 | 43.56 | 42.99 | 43.05 | 11635000.0 |
| 2001-06-19 10:00:00 | QQQ | ETF | 43.05 | 43.25 | 42.58 | 42.6 | 13770800.0 |
| 2001-06-19 11:00:00 | QQQ | ETF | 42.6 | 42.7 | 42.15 | 42.65 | 12631000.0 |
| 2001-06-19 12:00:00 | QQQ | ETF | 42.67 | 42.86 | 42.55 | 42.55 | 6010000.0 |
| 2001-06-19 13:00:00 | QQQ | ETF | 42.62 | 42.81 | 42.15 | 42.24 | 4912600.0 |
| 2001-06-19 14:00:00 | QQQ | ETF | 42.24 | 42.34 | 41.58 | 41.6 | 9336500.0 |
| 2001-06-19 15:00:00 | QQQ | ETF | 41.62 | 41.82 | 41.26 | 41.79 | 10095200.0 |
| 2001-06-19 16:00:00 | QQQ | ETF | 41.8 | 42.33 | 41.5 | 41.7 | 2479400.0 |
| 2001-06-19 17:00:00 | QQQ | ETF | 41.7 | 41.82 | 41.58 | 41.7 | 58000.0 |
| 2001-06-19 18:00:00 | QQQ | ETF | 41.6 | 41.65 | 41.56 | 41.6 | 10600.0 |
| 2001-06-19 09:00:00 | IWM | ETF | 49.5 | 49.55 | 49.35 | 49.53 | 97800.0 |
| 2001-06-19 10:00:00 | IWM | ETF | 49.525 | 49.525 | 49.15 | 49.18 | 107600.0 |
| 2001-06-19 11:00:00 | IWM | ETF | 49.09 | 49.1 | 48.905 | 48.94 | 77800.0 |
| 2001-06-19 12:00:00 | IWM | ETF | 48.94 | 49.0 | 48.9 | 48.97 | 67800.0 |
| 2001-06-19 13:00:00 | IWM | ETF | 48.975 | 49.055 | 48.925 | 48.925 | 62200.0 |
| 2001-06-19 14:00:00 | IWM | ETF | 48.94 | 49.05 | 48.605 | 48.745 | 129000.0 |
| 2001-06-19 15:00:00 | IWM | ETF | 48.755 | 48.78 | 48.59 | 48.69 | 165200.0 |
| 2001-06-19 16:00:00 | IWM | ETF | 48.7 | 48.85 | 48.7 | 48.85 | 49600.0 |
| 2001-06-19 09:00:00 | DIA | ETF | 107.25 | 107.56 | 107.11 | 107.11 | 395500.0 |
| 2001-06-19 10:00:00 | DIA | ETF | 107.2 | 107.35 | 106.6 | 106.6 | 223300.0 |
| 2001-06-19 11:00:00 | DIA | ETF | 106.6 | 106.6 | 106.07 | 106.44 | 903100.0 |
| 2001-06-19 12:00:00 | DIA | ETF | 106.55 | 106.81 | 106.43 | 106.7 | 296400.0 |
| 2001-06-19 13:00:00 | DIA | ETF | 106.68 | 106.83 | 106.27 | 106.55 | 100900.0 |
| 2001-06-19 14:00:00 | DIA | ETF | 106.42 | 106.7 | 105.9 | 106.1 | 331200.0 |
| 2001-06-19 15:00:00 | DIA | ETF | 106.03 | 106.22 | 105.65 | 106.08 | 606000.0 |
| 2001-06-19 16:00:00 | DIA | ETF | 106.14 | 106.24 | 106.08 | 106.24 | 653000.0 |
> showing 35 of 241 rows — these rows as CSV