PREVIEW / etf_1hour / 2001-03-05
file: by_date/etf_1hour/2001/2001-03-05.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-03-05 09:00:00 | SPY | ETF | 124.15 | 124.7 | 124.02 | 124.21 | 1020800.0 |
| 2001-03-05 10:00:00 | SPY | ETF | 124.35 | 124.78 | 123.81 | 124.19 | 1076000.0 |
| 2001-03-05 11:00:00 | SPY | ETF | 124.24 | 124.68 | 124.0 | 124.1 | 419000.0 |
| 2001-03-05 12:00:00 | SPY | ETF | 124.12 | 124.5 | 123.85 | 124.18 | 386900.0 |
| 2001-03-05 13:00:00 | SPY | ETF | 124.2 | 124.64 | 123.96 | 124.1 | 511400.0 |
| 2001-03-05 14:00:00 | SPY | ETF | 124.2 | 124.59 | 124.06 | 124.1 | 671900.0 |
| 2001-03-05 15:00:00 | SPY | ETF | 124.22 | 124.71 | 124.07 | 124.4 | 496600.0 |
| 2001-03-05 16:00:00 | SPY | ETF | 124.42 | 124.75 | 124.34 | 124.53 | 615800.0 |
| 2001-03-05 17:00:00 | SPY | ETF | 124.45 | 125.35 | 124.45 | 125.35 | 300.0 |
| 2001-03-05 09:00:00 | QQQ | ETF | 47.5 | 47.98 | 47.11 | 47.5 | 8786100.0 |
| 2001-03-05 10:00:00 | QQQ | ETF | 47.55 | 48.25 | 47.3 | 47.91 | 8719800.0 |
| 2001-03-05 11:00:00 | QQQ | ETF | 47.92 | 48.36 | 47.67 | 47.75 | 6060700.0 |
| 2001-03-05 12:00:00 | QQQ | ETF | 47.75 | 47.95 | 47.21 | 47.45 | 3894800.0 |
| 2001-03-05 13:00:00 | QQQ | ETF | 47.45 | 48.05 | 47.29 | 47.5 | 4211400.0 |
| 2001-03-05 14:00:00 | QQQ | ETF | 47.45 | 47.91 | 47.3 | 47.49 | 4730900.0 |
| 2001-03-05 15:00:00 | QQQ | ETF | 47.51 | 47.87 | 47.36 | 47.84 | 5513700.0 |
| 2001-03-05 16:00:00 | QQQ | ETF | 47.75 | 47.85 | 47.51 | 47.77 | 906700.0 |
| 2001-03-05 17:00:00 | QQQ | ETF | 47.7 | 48.0 | 47.67 | 47.9 | 92800.0 |
| 2001-03-05 18:00:00 | QQQ | ETF | 47.89 | 48.0 | 47.85 | 47.9 | 33800.0 |
| 2001-03-05 09:00:00 | IWM | ETF | 48.0 | 48.025 | 47.695 | 47.8 | 84800.0 |
| 2001-03-05 10:00:00 | IWM | ETF | 47.925 | 47.945 | 47.625 | 47.7 | 113800.0 |
| 2001-03-05 11:00:00 | IWM | ETF | 47.7 | 47.815 | 47.58 | 47.795 | 3200.0 |
| 2001-03-05 12:00:00 | IWM | ETF | 47.55 | 47.7 | 47.525 | 47.525 | 14000.0 |
| 2001-03-05 13:00:00 | IWM | ETF | 47.665 | 47.725 | 47.525 | 47.625 | 64200.0 |
| 2001-03-05 14:00:00 | IWM | ETF | 47.6 | 47.6 | 47.425 | 47.5 | 161400.0 |
| 2001-03-05 15:00:00 | IWM | ETF | 47.3 | 47.5 | 47.3 | 47.305 | 75600.0 |
| 2001-03-05 16:00:00 | IWM | ETF | 47.305 | 47.35 | 47.305 | 47.35 | 1000.0 |
| 2001-03-05 09:00:00 | DIA | ETF | 105.25 | 105.5 | 104.89 | 105.4 | 174900.0 |
| 2001-03-05 10:00:00 | DIA | ETF | 105.32 | 105.68 | 105.03 | 105.36 | 117300.0 |
| 2001-03-05 11:00:00 | DIA | ETF | 105.48 | 105.73 | 105.25 | 105.4 | 100300.0 |
| 2001-03-05 12:00:00 | DIA | ETF | 105.3 | 105.64 | 105.3 | 105.47 | 127900.0 |
| 2001-03-05 13:00:00 | DIA | ETF | 105.52 | 105.89 | 105.35 | 105.58 | 131800.0 |
| 2001-03-05 14:00:00 | DIA | ETF | 105.55 | 105.77 | 105.35 | 105.35 | 63700.0 |
| 2001-03-05 15:00:00 | DIA | ETF | 105.4 | 105.82 | 105.3 | 105.8 | 322700.0 |
| 2001-03-05 16:00:00 | DIA | ETF | 105.69 | 106.0 | 105.57 | 105.7 | 3600.0 |
> showing 35 of 218 rows — these rows as CSV