PREVIEW / etf_1hour / 2002-03-08
file: by_date/etf_1hour/2002/2002-03-08.parquet size: 14 KB rows: 316
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-08 09:00:00 | SPY | ETF | 117.38 | 117.75 | 117.15 | 117.52 | 4255300.0 |
| 2002-03-08 10:00:00 | SPY | ETF | 117.53 | 117.9 | 117.3 | 117.38 | 3678300.0 |
| 2002-03-08 11:00:00 | SPY | ETF | 117.38 | 117.46 | 117.0 | 117.26 | 2782700.0 |
| 2002-03-08 12:00:00 | SPY | ETF | 117.3 | 117.67 | 116.94 | 117.0 | 1578800.0 |
| 2002-03-08 13:00:00 | SPY | ETF | 116.95 | 117.27 | 116.89 | 117.14 | 1203500.0 |
| 2002-03-08 14:00:00 | SPY | ETF | 117.15 | 117.5 | 116.71 | 116.75 | 2565000.0 |
| 2002-03-08 15:00:00 | SPY | ETF | 116.79 | 116.97 | 116.48 | 116.93 | 2202100.0 |
| 2002-03-08 16:00:00 | SPY | ETF | 116.88 | 117.15 | 116.8 | 117.02 | 721200.0 |
| 2002-03-08 17:00:00 | SPY | ETF | 117.09 | 117.09 | 117.07 | 117.07 | 1200.0 |
| 2002-03-08 18:00:00 | SPY | ETF | 117.09 | 117.09 | 117.09 | 117.09 | 500.0 |
| 2002-03-08 09:00:00 | QQQ | ETF | 38.23 | 38.48 | 38.13 | 38.4 | 13153100.0 |
| 2002-03-08 10:00:00 | QQQ | ETF | 38.38 | 39.03 | 38.34 | 38.72 | 24236300.0 |
| 2002-03-08 11:00:00 | QQQ | ETF | 38.7 | 38.8 | 38.55 | 38.74 | 9815100.0 |
| 2002-03-08 12:00:00 | QQQ | ETF | 38.73 | 38.9 | 38.52 | 38.54 | 5365700.0 |
| 2002-03-08 13:00:00 | QQQ | ETF | 38.52 | 38.8 | 38.5 | 38.72 | 4639500.0 |
| 2002-03-08 14:00:00 | QQQ | ETF | 38.71 | 38.92 | 38.51 | 38.53 | 7773500.0 |
| 2002-03-08 15:00:00 | QQQ | ETF | 38.53 | 38.68 | 38.26 | 38.67 | 13410500.0 |
| 2002-03-08 16:00:00 | QQQ | ETF | 38.62 | 39.0 | 38.35 | 38.7 | 1345500.0 |
| 2002-03-08 17:00:00 | QQQ | ETF | 38.7 | 38.71 | 38.66 | 38.7 | 29100.0 |
| 2002-03-08 18:00:00 | QQQ | ETF | 38.7 | 38.71 | 38.67 | 38.71 | 5800.0 |
| 2002-03-08 09:00:00 | IWM | ETF | 49.85 | 49.875 | 49.58 | 49.725 | 267200.0 |
| 2002-03-08 10:00:00 | IWM | ETF | 49.65 | 49.88 | 49.61 | 49.73 | 176600.0 |
| 2002-03-08 11:00:00 | IWM | ETF | 49.705 | 49.705 | 49.47 | 49.6 | 206600.0 |
| 2002-03-08 12:00:00 | IWM | ETF | 49.54 | 49.72 | 49.53 | 49.595 | 31200.0 |
| 2002-03-08 13:00:00 | IWM | ETF | 49.535 | 49.65 | 49.51 | 49.6 | 117600.0 |
| 2002-03-08 14:00:00 | IWM | ETF | 49.59 | 49.72 | 49.5 | 49.5 | 188600.0 |
| 2002-03-08 15:00:00 | IWM | ETF | 49.49 | 49.63 | 49.345 | 49.63 | 116600.0 |
| 2002-03-08 16:00:00 | IWM | ETF | 49.69 | 49.69 | 49.69 | 49.69 | 20000.0 |
| 2002-03-08 09:00:00 | DIA | ETF | 106.49 | 106.84 | 106.12 | 106.4 | 915300.0 |
| 2002-03-08 10:00:00 | DIA | ETF | 106.46 | 106.89 | 106.24 | 106.38 | 759500.0 |
| 2002-03-08 11:00:00 | DIA | ETF | 106.32 | 106.46 | 106.0 | 106.3 | 1567900.0 |
| 2002-03-08 12:00:00 | DIA | ETF | 106.33 | 106.66 | 106.12 | 106.13 | 981700.0 |
| 2002-03-08 13:00:00 | DIA | ETF | 106.1 | 106.36 | 106.04 | 106.29 | 392800.0 |
| 2002-03-08 14:00:00 | DIA | ETF | 106.29 | 106.55 | 105.72 | 105.75 | 472100.0 |
| 2002-03-08 15:00:00 | DIA | ETF | 105.8 | 105.92 | 105.5 | 105.86 | 668000.0 |
| 2002-03-08 16:00:00 | DIA | ETF | 105.9 | 106.0 | 105.74 | 105.99 | 205600.0 |
| 2002-03-08 17:00:00 | DIA | ETF | 106.15 | 106.15 | 106.15 | 106.15 | 100.0 |
> showing 37 of 316 rows — these rows as CSV