PREVIEW / etf_1hour / 2002-03-06
file: by_date/etf_1hour/2002/2002-03-06.parquet size: 14 KB rows: 303
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 |
|---|---|---|---|---|---|---|---|
| 2002-03-06 09:00:00 | SPY | ETF | 115.1 | 115.58 | 115.08 | 115.55 | 1850800.0 |
| 2002-03-06 10:00:00 | SPY | ETF | 115.55 | 116.27 | 115.07 | 116.1 | 4120600.0 |
| 2002-03-06 11:00:00 | SPY | ETF | 116.11 | 116.2 | 115.83 | 116.04 | 1577500.0 |
| 2002-03-06 12:00:00 | SPY | ETF | 116.06 | 116.47 | 116.01 | 116.2 | 2176100.0 |
| 2002-03-06 13:00:00 | SPY | ETF | 116.23 | 116.34 | 115.86 | 116.02 | 1694100.0 |
| 2002-03-06 14:00:00 | SPY | ETF | 116.02 | 116.83 | 115.74 | 116.74 | 3354400.0 |
| 2002-03-06 15:00:00 | SPY | ETF | 116.74 | 117.15 | 116.6 | 116.81 | 3481800.0 |
| 2002-03-06 16:00:00 | SPY | ETF | 116.86 | 117.75 | 116.4 | 116.78 | 1118700.0 |
| 2002-03-06 17:00:00 | SPY | ETF | 116.75 | 116.75 | 116.66 | 116.66 | 2800.0 |
| 2002-03-06 18:00:00 | SPY | ETF | 117.0 | 117.0 | 116.5 | 116.5 | 25900.0 |
| 2002-03-06 09:00:00 | QQQ | ETF | 37.08 | 37.17 | 36.8 | 37.01 | 10550800.0 |
| 2002-03-06 10:00:00 | QQQ | ETF | 37.03 | 37.35 | 36.6 | 37.22 | 20056300.0 |
| 2002-03-06 11:00:00 | QQQ | ETF | 37.23 | 37.32 | 36.95 | 37.21 | 7129000.0 |
| 2002-03-06 12:00:00 | QQQ | ETF | 37.23 | 37.69 | 37.2 | 37.48 | 10966800.0 |
| 2002-03-06 13:00:00 | QQQ | ETF | 37.49 | 37.6 | 37.08 | 37.2 | 8378800.0 |
| 2002-03-06 14:00:00 | QQQ | ETF | 37.2 | 37.66 | 37.04 | 37.54 | 11243800.0 |
| 2002-03-06 15:00:00 | QQQ | ETF | 37.53 | 37.95 | 37.48 | 37.78 | 14272000.0 |
| 2002-03-06 16:00:00 | QQQ | ETF | 37.78 | 37.8 | 37.45 | 37.66 | 1134300.0 |
| 2002-03-06 17:00:00 | QQQ | ETF | 37.66 | 37.75 | 37.45 | 37.65 | 49700.0 |
| 2002-03-06 18:00:00 | QQQ | ETF | 37.67 | 37.68 | 37.61 | 37.67 | 21500.0 |
| 2002-03-06 09:00:00 | IWM | ETF | 48.61 | 48.64 | 48.35 | 48.45 | 124200.0 |
| 2002-03-06 10:00:00 | IWM | ETF | 48.48 | 48.625 | 48.2 | 48.625 | 211600.0 |
| 2002-03-06 11:00:00 | IWM | ETF | 48.63 | 48.73 | 48.58 | 48.73 | 72600.0 |
| 2002-03-06 12:00:00 | IWM | ETF | 48.74 | 49.005 | 48.74 | 48.99 | 80400.0 |
| 2002-03-06 13:00:00 | IWM | ETF | 48.99 | 48.99 | 48.795 | 48.795 | 21200.0 |
| 2002-03-06 14:00:00 | IWM | ETF | 48.92 | 49.12 | 48.825 | 49.095 | 96600.0 |
| 2002-03-06 15:00:00 | IWM | ETF | 49.1 | 49.32 | 48.98 | 49.175 | 229400.0 |
| 2002-03-06 16:00:00 | IWM | ETF | 49.2 | 49.2 | 49.2 | 49.2 | 800.0 |
| 2002-03-06 09:00:00 | DIA | ETF | 104.64 | 105.1 | 104.6 | 105.09 | 1709400.0 |
| 2002-03-06 10:00:00 | DIA | ETF | 105.08 | 105.8 | 104.72 | 105.6 | 1443600.0 |
| 2002-03-06 11:00:00 | DIA | ETF | 105.59 | 105.6 | 105.28 | 105.44 | 453900.0 |
| 2002-03-06 12:00:00 | DIA | ETF | 105.45 | 105.74 | 105.38 | 105.58 | 425500.0 |
| 2002-03-06 13:00:00 | DIA | ETF | 105.58 | 105.61 | 105.24 | 105.34 | 401000.0 |
| 2002-03-06 14:00:00 | DIA | ETF | 105.34 | 106.09 | 105.15 | 105.92 | 1646400.0 |
| 2002-03-06 15:00:00 | DIA | ETF | 105.93 | 106.3 | 105.8 | 105.92 | 1005800.0 |
| 2002-03-06 16:00:00 | DIA | ETF | 105.92 | 106.9 | 105.54 | 105.9 | 448400.0 |
| 2002-03-06 17:00:00 | DIA | ETF | 105.93 | 105.93 | 105.93 | 105.93 | 600.0 |
> showing 37 of 303 rows — these rows as CSV