PREVIEW / etf_1hour / 2002-03-07
file: by_date/etf_1hour/2002/2002-03-07.parquet size: 14 KB rows: 307
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-07 09:00:00 | SPY | ETF | 117.36 | 117.5 | 116.54 | 116.55 | 2846700.0 |
| 2002-03-07 10:00:00 | SPY | ETF | 116.54 | 117.21 | 116.02 | 116.42 | 5467300.0 |
| 2002-03-07 11:00:00 | SPY | ETF | 116.32 | 116.64 | 116.21 | 116.35 | 1484200.0 |
| 2002-03-07 12:00:00 | SPY | ETF | 116.37 | 116.55 | 116.08 | 116.27 | 1064100.0 |
| 2002-03-07 13:00:00 | SPY | ETF | 116.28 | 116.42 | 115.69 | 115.78 | 1739200.0 |
| 2002-03-07 14:00:00 | SPY | ETF | 115.72 | 116.11 | 115.57 | 115.89 | 1718500.0 |
| 2002-03-07 15:00:00 | SPY | ETF | 115.86 | 116.36 | 115.7 | 116.33 | 2832500.0 |
| 2002-03-07 16:00:00 | SPY | ETF | 116.38 | 116.59 | 116.0 | 116.54 | 960100.0 |
| 2002-03-07 17:00:00 | SPY | ETF | 116.5 | 116.59 | 116.5 | 116.51 | 6100.0 |
| 2002-03-07 18:00:00 | SPY | ETF | 116.51 | 116.51 | 116.48 | 116.48 | 600.0 |
| 2002-03-07 09:00:00 | QQQ | ETF | 38.12 | 38.33 | 37.66 | 37.68 | 15606300.0 |
| 2002-03-07 10:00:00 | QQQ | ETF | 37.68 | 38.17 | 37.51 | 37.61 | 20383600.0 |
| 2002-03-07 11:00:00 | QQQ | ETF | 37.6 | 37.98 | 37.58 | 37.77 | 6402600.0 |
| 2002-03-07 12:00:00 | QQQ | ETF | 37.76 | 37.95 | 37.62 | 37.79 | 6158500.0 |
| 2002-03-07 13:00:00 | QQQ | ETF | 37.81 | 37.86 | 37.11 | 37.11 | 9713500.0 |
| 2002-03-07 14:00:00 | QQQ | ETF | 37.11 | 37.39 | 37.01 | 37.26 | 12560600.0 |
| 2002-03-07 15:00:00 | QQQ | ETF | 37.28 | 37.59 | 37.16 | 37.51 | 8963800.0 |
| 2002-03-07 16:00:00 | QQQ | ETF | 37.51 | 37.7 | 37.3 | 37.65 | 2541400.0 |
| 2002-03-07 17:00:00 | QQQ | ETF | 37.65 | 37.76 | 37.62 | 37.62 | 172500.0 |
| 2002-03-07 18:00:00 | QQQ | ETF | 37.62 | 37.69 | 37.6 | 37.67 | 20400.0 |
| 2002-03-07 09:00:00 | IWM | ETF | 49.55 | 49.65 | 49.325 | 49.415 | 79800.0 |
| 2002-03-07 10:00:00 | IWM | ETF | 49.395 | 49.5 | 49.15 | 49.285 | 188200.0 |
| 2002-03-07 11:00:00 | IWM | ETF | 49.305 | 49.395 | 49.29 | 49.375 | 32400.0 |
| 2002-03-07 12:00:00 | IWM | ETF | 49.365 | 49.445 | 49.315 | 49.425 | 101200.0 |
| 2002-03-07 13:00:00 | IWM | ETF | 49.435 | 49.45 | 49.2 | 49.28 | 62800.0 |
| 2002-03-07 14:00:00 | IWM | ETF | 49.195 | 49.24 | 49.075 | 49.175 | 142200.0 |
| 2002-03-07 15:00:00 | IWM | ETF | 49.175 | 49.31 | 49.125 | 49.28 | 164600.0 |
| 2002-03-07 16:00:00 | IWM | ETF | 49.31 | 49.375 | 49.25 | 49.25 | 362600.0 |
| 2002-03-07 09:00:00 | DIA | ETF | 106.49 | 106.5 | 105.5 | 105.5 | 913700.0 |
| 2002-03-07 10:00:00 | DIA | ETF | 105.5 | 105.96 | 104.94 | 105.37 | 2780900.0 |
| 2002-03-07 11:00:00 | DIA | ETF | 105.32 | 105.6 | 105.2 | 105.35 | 461700.0 |
| 2002-03-07 12:00:00 | DIA | ETF | 105.35 | 105.57 | 105.15 | 105.4 | 688200.0 |
| 2002-03-07 13:00:00 | DIA | ETF | 105.36 | 105.53 | 104.94 | 104.94 | 615600.0 |
| 2002-03-07 14:00:00 | DIA | ETF | 104.97 | 105.32 | 104.85 | 105.06 | 567400.0 |
| 2002-03-07 15:00:00 | DIA | ETF | 105.14 | 105.51 | 104.95 | 105.44 | 1050200.0 |
| 2002-03-07 16:00:00 | DIA | ETF | 105.45 | 105.65 | 105.45 | 105.65 | 252800.0 |
| 2002-03-07 17:00:00 | DIA | ETF | 105.75 | 105.75 | 105.62 | 105.75 | 2400.0 |
> showing 37 of 307 rows — these rows as CSV