PREVIEW / etf_1hour / 2001-03-13
file: by_date/etf_1hour/2001/2001-03-13.parquet size: 11 KB rows: 224
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-03-13 09:00:00 | SPY | ETF | 119.4 | 119.4 | 118.0 | 118.35 | 3113400.0 |
| 2001-03-13 10:00:00 | SPY | ETF | 118.36 | 119.5 | 118.05 | 118.78 | 1995000.0 |
| 2001-03-13 11:00:00 | SPY | ETF | 118.71 | 118.75 | 117.53 | 117.9 | 1766900.0 |
| 2001-03-13 12:00:00 | SPY | ETF | 117.96 | 118.52 | 117.77 | 118.15 | 821200.0 |
| 2001-03-13 13:00:00 | SPY | ETF | 118.15 | 119.38 | 118.1 | 118.69 | 1227900.0 |
| 2001-03-13 14:00:00 | SPY | ETF | 118.73 | 119.64 | 118.48 | 119.6 | 686500.0 |
| 2001-03-13 15:00:00 | SPY | ETF | 119.65 | 120.44 | 119.57 | 120.2 | 2161900.0 |
| 2001-03-13 16:00:00 | SPY | ETF | 120.18 | 120.38 | 119.75 | 119.75 | 465000.0 |
| 2001-03-13 17:00:00 | SPY | ETF | 120.16 | 120.21 | 120.16 | 120.21 | 4000.0 |
| 2001-03-13 18:00:00 | SPY | ETF | 120.16 | 120.25 | 120.16 | 120.25 | 800.0 |
| 2001-03-13 09:00:00 | QQQ | ETF | 42.78 | 43.25 | 42.13 | 42.6 | 12035100.0 |
| 2001-03-13 10:00:00 | QQQ | ETF | 42.55 | 43.67 | 42.48 | 43.2 | 11808700.0 |
| 2001-03-13 11:00:00 | QQQ | ETF | 43.21 | 43.22 | 42.37 | 42.74 | 7333200.0 |
| 2001-03-13 12:00:00 | QQQ | ETF | 42.68 | 43.25 | 42.64 | 43.0 | 8625100.0 |
| 2001-03-13 13:00:00 | QQQ | ETF | 43.07 | 43.92 | 42.96 | 43.54 | 10364100.0 |
| 2001-03-13 14:00:00 | QQQ | ETF | 43.53 | 43.97 | 43.1 | 43.9 | 7322100.0 |
| 2001-03-13 15:00:00 | QQQ | ETF | 43.93 | 44.71 | 43.85 | 44.68 | 16855800.0 |
| 2001-03-13 16:00:00 | QQQ | ETF | 44.54 | 44.8 | 43.63 | 44.77 | 2149000.0 |
| 2001-03-13 17:00:00 | QQQ | ETF | 44.72 | 45.0 | 44.7 | 44.95 | 69600.0 |
| 2001-03-13 18:00:00 | QQQ | ETF | 44.99 | 45.1 | 44.85 | 45.06 | 22400.0 |
| 2001-03-13 09:00:00 | IWM | ETF | 45.9 | 45.9 | 45.4 | 45.5 | 96800.0 |
| 2001-03-13 10:00:00 | IWM | ETF | 45.625 | 45.725 | 45.5 | 45.555 | 113800.0 |
| 2001-03-13 11:00:00 | IWM | ETF | 45.475 | 45.475 | 45.15 | 45.2 | 76800.0 |
| 2001-03-13 12:00:00 | IWM | ETF | 45.035 | 45.225 | 45.005 | 45.19 | 45800.0 |
| 2001-03-13 13:00:00 | IWM | ETF | 45.195 | 45.375 | 45.175 | 45.175 | 8600.0 |
| 2001-03-13 14:00:00 | IWM | ETF | 45.175 | 45.585 | 45.1 | 45.585 | 9800.0 |
| 2001-03-13 15:00:00 | IWM | ETF | 45.4 | 46.1 | 45.4 | 46.1 | 169200.0 |
| 2001-03-13 09:00:00 | DIA | ETF | 102.55 | 102.76 | 101.56 | 101.75 | 1737600.0 |
| 2001-03-13 10:00:00 | DIA | ETF | 101.87 | 102.8 | 101.6 | 102.37 | 1052700.0 |
| 2001-03-13 11:00:00 | DIA | ETF | 102.37 | 102.37 | 101.1 | 101.55 | 871800.0 |
| 2001-03-13 12:00:00 | DIA | ETF | 101.45 | 101.99 | 101.3 | 101.53 | 479600.0 |
| 2001-03-13 13:00:00 | DIA | ETF | 101.51 | 102.59 | 101.41 | 102.1 | 643300.0 |
| 2001-03-13 14:00:00 | DIA | ETF | 102.1 | 102.71 | 101.84 | 102.67 | 549300.0 |
| 2001-03-13 15:00:00 | DIA | ETF | 102.64 | 103.25 | 102.52 | 103.03 | 698000.0 |
| 2001-03-13 16:00:00 | DIA | ETF | 103.08 | 103.14 | 102.86 | 102.86 | 49600.0 |
| 2001-03-13 17:00:00 | DIA | ETF | 102.85 | 102.85 | 102.85 | 102.85 | 1800.0 |
> showing 36 of 224 rows — these rows as CSV