PREVIEW / etf_1hour / 2001-04-10
file: by_date/etf_1hour/2001/2001-04-10.parquet size: 11 KB rows: 226
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-04-10 09:00:00 | SPY | ETF | 115.45 | 116.2 | 115.17 | 116.06 | 2913700.0 |
| 2001-04-10 10:00:00 | SPY | ETF | 116.09 | 116.89 | 116.03 | 116.65 | 2074800.0 |
| 2001-04-10 11:00:00 | SPY | ETF | 116.65 | 117.17 | 116.34 | 117.02 | 2527100.0 |
| 2001-04-10 12:00:00 | SPY | ETF | 116.99 | 117.75 | 116.99 | 117.5 | 1689100.0 |
| 2001-04-10 13:00:00 | SPY | ETF | 117.54 | 117.69 | 117.08 | 117.26 | 900400.0 |
| 2001-04-10 14:00:00 | SPY | ETF | 117.23 | 117.55 | 116.5 | 116.87 | 2652500.0 |
| 2001-04-10 15:00:00 | SPY | ETF | 116.86 | 117.66 | 116.83 | 117.09 | 2736900.0 |
| 2001-04-10 16:00:00 | SPY | ETF | 117.03 | 117.19 | 116.6 | 116.65 | 2286700.0 |
| 2001-04-10 17:00:00 | SPY | ETF | 117.15 | 117.15 | 116.42 | 116.42 | 1100.0 |
| 2001-04-10 18:00:00 | SPY | ETF | 116.5 | 116.5 | 116.21 | 116.47 | 3800.0 |
| 2001-04-10 09:00:00 | QQQ | ETF | 37.9 | 38.76 | 37.78 | 38.6 | 13864200.0 |
| 2001-04-10 10:00:00 | QQQ | ETF | 38.6 | 39.6 | 38.55 | 39.4 | 17352800.0 |
| 2001-04-10 11:00:00 | QQQ | ETF | 39.4 | 39.86 | 39.19 | 39.8 | 10359700.0 |
| 2001-04-10 12:00:00 | QQQ | ETF | 39.76 | 40.46 | 39.75 | 40.21 | 16095400.0 |
| 2001-04-10 13:00:00 | QQQ | ETF | 40.22 | 40.38 | 39.84 | 39.87 | 7446200.0 |
| 2001-04-10 14:00:00 | QQQ | ETF | 39.86 | 40.2 | 39.53 | 39.68 | 10391700.0 |
| 2001-04-10 15:00:00 | QQQ | ETF | 39.69 | 40.46 | 39.67 | 39.9 | 15461400.0 |
| 2001-04-10 16:00:00 | QQQ | ETF | 39.86 | 40.35 | 39.1 | 39.82 | 2093200.0 |
| 2001-04-10 17:00:00 | QQQ | ETF | 39.82 | 40.0 | 39.3 | 39.52 | 303100.0 |
| 2001-04-10 18:00:00 | QQQ | ETF | 39.52 | 39.65 | 39.25 | 39.62 | 98200.0 |
| 2001-04-10 09:00:00 | IWM | ETF | 44.375 | 44.525 | 44.35 | 44.525 | 261600.0 |
| 2001-04-10 10:00:00 | IWM | ETF | 44.545 | 45.0 | 44.545 | 44.975 | 90000.0 |
| 2001-04-10 11:00:00 | IWM | ETF | 44.88 | 45.12 | 44.805 | 45.12 | 30400.0 |
| 2001-04-10 12:00:00 | IWM | ETF | 45.015 | 45.365 | 45.015 | 45.195 | 36400.0 |
| 2001-04-10 13:00:00 | IWM | ETF | 45.295 | 45.295 | 45.05 | 45.05 | 9800.0 |
| 2001-04-10 14:00:00 | IWM | ETF | 45.08 | 45.215 | 44.915 | 44.925 | 67400.0 |
| 2001-04-10 15:00:00 | IWM | ETF | 45.05 | 45.375 | 45.025 | 45.195 | 264200.0 |
| 2001-04-10 16:00:00 | IWM | ETF | 45.2 | 45.2 | 45.2 | 45.2 | 2000.0 |
| 2001-04-10 09:00:00 | DIA | ETF | 100.05 | 100.28 | 99.45 | 100.01 | 1043300.0 |
| 2001-04-10 10:00:00 | DIA | ETF | 100.0 | 100.8 | 99.95 | 100.35 | 1060500.0 |
| 2001-04-10 11:00:00 | DIA | ETF | 100.48 | 101.03 | 100.21 | 100.84 | 533300.0 |
| 2001-04-10 12:00:00 | DIA | ETF | 100.93 | 101.79 | 100.93 | 101.52 | 3499400.0 |
| 2001-04-10 13:00:00 | DIA | ETF | 101.56 | 101.71 | 101.22 | 101.26 | 536700.0 |
| 2001-04-10 14:00:00 | DIA | ETF | 101.26 | 101.6 | 100.9 | 101.1 | 676300.0 |
| 2001-04-10 15:00:00 | DIA | ETF | 101.14 | 101.55 | 100.96 | 101.01 | 570900.0 |
| 2001-04-10 16:00:00 | DIA | ETF | 101.01 | 101.19 | 100.95 | 100.97 | 126100.0 |
| 2001-04-10 17:00:00 | DIA | ETF | 100.8 | 100.8 | 100.8 | 100.8 | 200.0 |
> showing 37 of 226 rows — these rows as CSV