PREVIEW / etf_1hour / 2001-07-11
file: by_date/etf_1hour/2001/2001-07-11.parquet size: 12 KB rows: 238
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-07-11 09:00:00 | SPY | ETF | 118.1 | 118.56 | 117.78 | 118.06 | 1761900.0 |
| 2001-07-11 10:00:00 | SPY | ETF | 118.07 | 118.89 | 117.91 | 117.91 | 1521600.0 |
| 2001-07-11 11:00:00 | SPY | ETF | 117.92 | 117.99 | 117.09 | 117.55 | 1982700.0 |
| 2001-07-11 12:00:00 | SPY | ETF | 117.55 | 118.83 | 117.55 | 118.16 | 1271000.0 |
| 2001-07-11 13:00:00 | SPY | ETF | 118.19 | 118.79 | 118.02 | 118.46 | 3154500.0 |
| 2001-07-11 14:00:00 | SPY | ETF | 118.48 | 118.62 | 117.9 | 118.01 | 502200.0 |
| 2001-07-11 15:00:00 | SPY | ETF | 118.03 | 118.45 | 117.73 | 118.27 | 3412700.0 |
| 2001-07-11 16:00:00 | SPY | ETF | 118.21 | 118.65 | 118.09 | 118.4 | 388300.0 |
| 2001-07-11 17:00:00 | SPY | ETF | 118.4 | 120.0 | 118.3 | 119.7 | 971500.0 |
| 2001-07-11 18:00:00 | SPY | ETF | 119.99 | 120.0 | 119.51 | 119.51 | 44300.0 |
| 2001-07-11 09:00:00 | QQQ | ETF | 40.42 | 40.71 | 40.12 | 40.48 | 9118800.0 |
| 2001-07-11 10:00:00 | QQQ | ETF | 40.5 | 41.1 | 40.35 | 40.41 | 11055900.0 |
| 2001-07-11 11:00:00 | QQQ | ETF | 40.42 | 40.44 | 39.87 | 40.26 | 11400400.0 |
| 2001-07-11 12:00:00 | QQQ | ETF | 40.26 | 40.79 | 40.25 | 40.69 | 7769700.0 |
| 2001-07-11 13:00:00 | QQQ | ETF | 40.7 | 41.09 | 40.55 | 40.86 | 9662300.0 |
| 2001-07-11 14:00:00 | QQQ | ETF | 40.85 | 41.05 | 40.46 | 40.57 | 8007700.0 |
| 2001-07-11 15:00:00 | QQQ | ETF | 40.53 | 40.93 | 40.37 | 40.9 | 11140400.0 |
| 2001-07-11 16:00:00 | QQQ | ETF | 40.86 | 41.45 | 40.67 | 41.35 | 1932400.0 |
| 2001-07-11 17:00:00 | QQQ | ETF | 41.33 | 43.0 | 41.23 | 42.95 | 4666000.0 |
| 2001-07-11 18:00:00 | QQQ | ETF | 42.96 | 43.09 | 42.8 | 42.99 | 442900.0 |
| 2001-07-11 09:00:00 | IWM | ETF | 47.4 | 47.4 | 47.02 | 47.025 | 224600.0 |
| 2001-07-11 10:00:00 | IWM | ETF | 47.15 | 47.475 | 47.15 | 47.225 | 62800.0 |
| 2001-07-11 11:00:00 | IWM | ETF | 47.225 | 47.225 | 46.745 | 46.9 | 381600.0 |
| 2001-07-11 12:00:00 | IWM | ETF | 46.945 | 47.115 | 46.945 | 47.115 | 53400.0 |
| 2001-07-11 13:00:00 | IWM | ETF | 47.08 | 47.3 | 47.08 | 47.23 | 31200.0 |
| 2001-07-11 14:00:00 | IWM | ETF | 47.285 | 47.34 | 47.19 | 47.2 | 77200.0 |
| 2001-07-11 15:00:00 | IWM | ETF | 47.2 | 47.62 | 47.16 | 47.62 | 239400.0 |
| 2001-07-11 16:00:00 | IWM | ETF | 47.62 | 47.62 | 47.5 | 47.5 | 28200.0 |
| 2001-07-11 09:00:00 | DIA | ETF | 102.03 | 102.2 | 101.62 | 101.97 | 892800.0 |
| 2001-07-11 10:00:00 | DIA | ETF | 101.9 | 102.74 | 101.9 | 102.05 | 622500.0 |
| 2001-07-11 11:00:00 | DIA | ETF | 102.05 | 102.05 | 101.34 | 101.59 | 501100.0 |
| 2001-07-11 12:00:00 | DIA | ETF | 101.72 | 102.5 | 101.72 | 102.46 | 190600.0 |
| 2001-07-11 13:00:00 | DIA | ETF | 102.47 | 102.93 | 102.25 | 102.57 | 392500.0 |
| 2001-07-11 14:00:00 | DIA | ETF | 102.57 | 102.75 | 102.08 | 102.16 | 278300.0 |
| 2001-07-11 15:00:00 | DIA | ETF | 102.11 | 102.62 | 102.0 | 102.5 | 560600.0 |
| 2001-07-11 16:00:00 | DIA | ETF | 102.47 | 102.6 | 102.35 | 102.55 | 51800.0 |
> showing 36 of 238 rows — these rows as CSV