PREVIEW / etf_1hour / 2001-05-15
file: by_date/etf_1hour/2001/2001-05-15.parquet size: 11 KB rows: 210
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-15 09:00:00 | SPY | ETF | 125.55 | 125.55 | 125.03 | 125.37 | 947200.0 |
| 2001-05-15 10:00:00 | SPY | ETF | 125.35 | 125.65 | 125.25 | 125.34 | 1216400.0 |
| 2001-05-15 11:00:00 | SPY | ETF | 125.29 | 125.52 | 125.18 | 125.2 | 504700.0 |
| 2001-05-15 12:00:00 | SPY | ETF | 125.27 | 125.48 | 125.19 | 125.33 | 296500.0 |
| 2001-05-15 13:00:00 | SPY | ETF | 125.34 | 125.43 | 125.15 | 125.2 | 615600.0 |
| 2001-05-15 14:00:00 | SPY | ETF | 125.22 | 126.08 | 124.85 | 125.98 | 3063900.0 |
| 2001-05-15 15:00:00 | SPY | ETF | 125.98 | 126.22 | 124.95 | 125.3 | 1648900.0 |
| 2001-05-15 16:00:00 | SPY | ETF | 125.3 | 125.98 | 125.2 | 125.66 | 793300.0 |
| 2001-05-15 17:00:00 | SPY | ETF | 125.62 | 125.64 | 125.62 | 125.64 | 1600.0 |
| 2001-05-15 18:00:00 | SPY | ETF | 125.62 | 125.62 | 125.62 | 125.62 | 300.0 |
| 2001-05-15 09:00:00 | QQQ | ETF | 44.9 | 45.14 | 44.65 | 45.05 | 4931400.0 |
| 2001-05-15 10:00:00 | QQQ | ETF | 45.06 | 45.6 | 45.03 | 45.2 | 8941300.0 |
| 2001-05-15 11:00:00 | QQQ | ETF | 45.18 | 45.37 | 45.01 | 45.04 | 2740400.0 |
| 2001-05-15 12:00:00 | QQQ | ETF | 45.05 | 45.34 | 45.01 | 45.25 | 3089200.0 |
| 2001-05-15 13:00:00 | QQQ | ETF | 45.27 | 45.32 | 45.09 | 45.15 | 3171900.0 |
| 2001-05-15 14:00:00 | QQQ | ETF | 45.18 | 46.15 | 44.92 | 45.98 | 22620000.0 |
| 2001-05-15 15:00:00 | QQQ | ETF | 45.95 | 46.3 | 44.58 | 44.75 | 17451500.0 |
| 2001-05-15 16:00:00 | QQQ | ETF | 44.75 | 46.1 | 44.65 | 45.0 | 3413600.0 |
| 2001-05-15 17:00:00 | QQQ | ETF | 44.95 | 45.2 | 44.9 | 45.06 | 118000.0 |
| 2001-05-15 18:00:00 | QQQ | ETF | 45.1 | 45.15 | 45.0 | 45.15 | 4100.0 |
| 2001-05-15 09:00:00 | IWM | ETF | 48.5 | 48.61 | 48.425 | 48.61 | 11200.0 |
| 2001-05-15 10:00:00 | IWM | ETF | 48.45 | 48.75 | 48.45 | 48.525 | 43000.0 |
| 2001-05-15 11:00:00 | IWM | ETF | 48.5 | 48.7 | 48.5 | 48.58 | 19200.0 |
| 2001-05-15 12:00:00 | IWM | ETF | 48.575 | 48.65 | 48.505 | 48.515 | 2800.0 |
| 2001-05-15 13:00:00 | IWM | ETF | 48.535 | 48.695 | 48.535 | 48.64 | 13200.0 |
| 2001-05-15 14:00:00 | IWM | ETF | 48.565 | 48.95 | 48.53 | 48.945 | 40400.0 |
| 2001-05-15 15:00:00 | IWM | ETF | 48.975 | 49.1 | 48.65 | 48.805 | 256200.0 |
| 2001-05-15 16:00:00 | IWM | ETF | 49.075 | 49.1 | 48.655 | 48.925 | 18000.0 |
| 2001-05-15 09:00:00 | DIA | ETF | 109.1 | 109.1 | 108.7 | 108.88 | 154400.0 |
| 2001-05-15 10:00:00 | DIA | ETF | 108.82 | 109.07 | 108.65 | 108.67 | 619100.0 |
| 2001-05-15 11:00:00 | DIA | ETF | 108.69 | 108.91 | 108.65 | 108.7 | 52900.0 |
| 2001-05-15 12:00:00 | DIA | ETF | 108.75 | 108.89 | 108.75 | 108.76 | 262300.0 |
| 2001-05-15 13:00:00 | DIA | ETF | 108.75 | 108.75 | 108.47 | 108.53 | 168100.0 |
| 2001-05-15 14:00:00 | DIA | ETF | 108.47 | 109.75 | 108.14 | 109.3 | 1219400.0 |
| 2001-05-15 15:00:00 | DIA | ETF | 109.33 | 109.44 | 108.46 | 108.89 | 662700.0 |
| 2001-05-15 16:00:00 | DIA | ETF | 108.81 | 109.22 | 108.75 | 109.22 | 180100.0 |
> showing 36 of 210 rows — these rows as CSV