PREVIEW / etf_1hour / 2001-05-14
file: by_date/etf_1hour/2001/2001-05-14.parquet size: 11 KB rows: 218
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-05-14 09:00:00 | SPY | ETF | 124.9 | 125.15 | 124.63 | 124.7 | 1271000.0 |
| 2001-05-14 10:00:00 | SPY | ETF | 124.74 | 125.19 | 124.52 | 124.71 | 1477100.0 |
| 2001-05-14 11:00:00 | SPY | ETF | 124.7 | 124.74 | 124.46 | 124.59 | 985000.0 |
| 2001-05-14 12:00:00 | SPY | ETF | 124.64 | 124.97 | 124.55 | 124.83 | 479500.0 |
| 2001-05-14 13:00:00 | SPY | ETF | 124.8 | 124.89 | 124.52 | 124.57 | 267600.0 |
| 2001-05-14 14:00:00 | SPY | ETF | 124.64 | 124.88 | 124.46 | 124.82 | 622200.0 |
| 2001-05-14 15:00:00 | SPY | ETF | 124.77 | 125.44 | 124.62 | 125.23 | 2088000.0 |
| 2001-05-14 16:00:00 | SPY | ETF | 125.22 | 125.45 | 124.67 | 125.32 | 498600.0 |
| 2001-05-14 17:00:00 | SPY | ETF | 125.26 | 125.26 | 125.25 | 125.25 | 700.0 |
| 2001-05-14 09:00:00 | QQQ | ETF | 45.3 | 45.36 | 44.6 | 44.72 | 6770600.0 |
| 2001-05-14 10:00:00 | QQQ | ETF | 44.73 | 44.92 | 44.47 | 44.58 | 6594100.0 |
| 2001-05-14 11:00:00 | QQQ | ETF | 44.58 | 44.59 | 44.26 | 44.54 | 4771700.0 |
| 2001-05-14 12:00:00 | QQQ | ETF | 44.46 | 44.83 | 44.38 | 44.68 | 3362400.0 |
| 2001-05-14 13:00:00 | QQQ | ETF | 44.66 | 44.69 | 44.33 | 44.42 | 4299500.0 |
| 2001-05-14 14:00:00 | QQQ | ETF | 44.43 | 44.59 | 44.11 | 44.39 | 4843500.0 |
| 2001-05-14 15:00:00 | QQQ | ETF | 44.38 | 44.9 | 44.26 | 44.69 | 9135200.0 |
| 2001-05-14 16:00:00 | QQQ | ETF | 44.7 | 44.95 | 44.69 | 44.88 | 692500.0 |
| 2001-05-14 17:00:00 | QQQ | ETF | 44.9 | 44.98 | 44.88 | 44.95 | 50400.0 |
| 2001-05-14 18:00:00 | QQQ | ETF | 44.94 | 45.0 | 44.85 | 44.86 | 9400.0 |
| 2001-05-14 09:00:00 | IWM | ETF | 48.46 | 48.66 | 48.375 | 48.545 | 50400.0 |
| 2001-05-14 10:00:00 | IWM | ETF | 48.45 | 48.65 | 48.425 | 48.58 | 31000.0 |
| 2001-05-14 11:00:00 | IWM | ETF | 48.375 | 48.495 | 48.28 | 48.375 | 33800.0 |
| 2001-05-14 12:00:00 | IWM | ETF | 48.375 | 48.495 | 48.275 | 48.305 | 20200.0 |
| 2001-05-14 13:00:00 | IWM | ETF | 48.31 | 48.495 | 48.275 | 48.375 | 12000.0 |
| 2001-05-14 14:00:00 | IWM | ETF | 48.4 | 48.495 | 48.15 | 48.365 | 33000.0 |
| 2001-05-14 15:00:00 | IWM | ETF | 48.15 | 48.595 | 48.15 | 48.45 | 52000.0 |
| 2001-05-14 16:00:00 | IWM | ETF | 48.52 | 48.52 | 48.45 | 48.45 | 4400.0 |
| 2001-05-14 09:00:00 | DIA | ETF | 108.35 | 108.51 | 108.11 | 108.36 | 325500.0 |
| 2001-05-14 10:00:00 | DIA | ETF | 108.28 | 108.8 | 108.11 | 108.3 | 459900.0 |
| 2001-05-14 11:00:00 | DIA | ETF | 108.33 | 108.45 | 108.15 | 108.31 | 350600.0 |
| 2001-05-14 12:00:00 | DIA | ETF | 108.33 | 108.65 | 108.25 | 108.52 | 72000.0 |
| 2001-05-14 13:00:00 | DIA | ETF | 108.54 | 108.58 | 108.36 | 108.38 | 114900.0 |
| 2001-05-14 14:00:00 | DIA | ETF | 108.45 | 108.58 | 108.22 | 108.49 | 167600.0 |
| 2001-05-14 15:00:00 | DIA | ETF | 108.53 | 108.96 | 108.35 | 108.85 | 317900.0 |
| 2001-05-14 16:00:00 | DIA | ETF | 108.92 | 108.99 | 108.83 | 108.99 | 86700.0 |
> showing 35 of 218 rows — these rows as CSV