PREVIEW / etf_1hour / 2002-07-02
file: by_date/etf_1hour/2002/2002-07-02.parquet size: 14 KB rows: 324
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-07-02 09:00:00 | SPY | ETF | 96.86 | 97.2 | 96.58 | 96.91 | 2936800.0 |
| 2002-07-02 10:00:00 | SPY | ETF | 96.95 | 96.96 | 95.63 | 95.96 | 4594000.0 |
| 2002-07-02 11:00:00 | SPY | ETF | 95.96 | 96.08 | 95.11 | 95.2 | 5027000.0 |
| 2002-07-02 12:00:00 | SPY | ETF | 95.2 | 95.58 | 94.86 | 95.3 | 4463000.0 |
| 2002-07-02 13:00:00 | SPY | ETF | 95.29 | 96.13 | 94.77 | 95.78 | 5330500.0 |
| 2002-07-02 14:00:00 | SPY | ETF | 95.76 | 96.25 | 95.52 | 95.7 | 4249700.0 |
| 2002-07-02 15:00:00 | SPY | ETF | 95.67 | 95.97 | 94.9 | 95.02 | 4900800.0 |
| 2002-07-02 16:00:00 | SPY | ETF | 95.08 | 95.23 | 94.9 | 95.03 | 1282300.0 |
| 2002-07-02 17:00:00 | SPY | ETF | 95.04 | 95.07 | 95.01 | 95.07 | 2300.0 |
| 2002-07-02 18:00:00 | SPY | ETF | 95.07 | 95.15 | 95.06 | 95.14 | 4800.0 |
| 2002-07-02 09:00:00 | QQQ | ETF | 24.6 | 24.75 | 24.38 | 24.61 | 14645500.0 |
| 2002-07-02 10:00:00 | QQQ | ETF | 24.61 | 24.65 | 24.18 | 24.25 | 16843000.0 |
| 2002-07-02 11:00:00 | QQQ | ETF | 24.25 | 24.31 | 23.96 | 24.0 | 17298500.0 |
| 2002-07-02 12:00:00 | QQQ | ETF | 24.02 | 24.35 | 23.95 | 24.2 | 10960700.0 |
| 2002-07-02 13:00:00 | QQQ | ETF | 24.19 | 24.5 | 23.95 | 24.36 | 11444500.0 |
| 2002-07-02 14:00:00 | QQQ | ETF | 24.34 | 24.57 | 24.1 | 24.18 | 16409400.0 |
| 2002-07-02 15:00:00 | QQQ | ETF | 24.17 | 24.28 | 23.89 | 24.01 | 17856800.0 |
| 2002-07-02 16:00:00 | QQQ | ETF | 24.0 | 24.13 | 23.91 | 24.05 | 3014300.0 |
| 2002-07-02 17:00:00 | QQQ | ETF | 24.02 | 24.1 | 24.0 | 24.05 | 87500.0 |
| 2002-07-02 18:00:00 | QQQ | ETF | 24.04 | 24.05 | 24.0 | 24.0 | 22200.0 |
| 2002-07-02 09:00:00 | IWM | ETF | 44.28 | 44.3 | 43.975 | 44.225 | 195000.0 |
| 2002-07-02 10:00:00 | IWM | ETF | 44.225 | 44.25 | 43.525 | 43.56 | 313800.0 |
| 2002-07-02 11:00:00 | IWM | ETF | 43.55 | 43.575 | 43.15 | 43.195 | 185000.0 |
| 2002-07-02 12:00:00 | IWM | ETF | 43.255 | 43.365 | 43.08 | 43.285 | 196200.0 |
| 2002-07-02 13:00:00 | IWM | ETF | 43.29 | 43.565 | 43.16 | 43.505 | 172200.0 |
| 2002-07-02 14:00:00 | IWM | ETF | 43.52 | 43.675 | 43.42 | 43.45 | 101600.0 |
| 2002-07-02 15:00:00 | IWM | ETF | 43.42 | 43.47 | 43.0 | 43.0 | 355400.0 |
| 2002-07-02 16:00:00 | IWM | ETF | 43.06 | 43.065 | 43.06 | 43.065 | 4400.0 |
| 2002-07-02 17:00:00 | IWM | ETF | 43.135 | 43.135 | 43.135 | 43.135 | 180800.0 |
| 2002-07-02 09:00:00 | DIA | ETF | 91.04 | 91.58 | 91.0 | 91.34 | 409300.0 |
| 2002-07-02 10:00:00 | DIA | ETF | 91.34 | 91.4 | 90.21 | 90.59 | 1173400.0 |
| 2002-07-02 11:00:00 | DIA | ETF | 90.59 | 90.74 | 90.0 | 90.15 | 652900.0 |
| 2002-07-02 12:00:00 | DIA | ETF | 90.17 | 90.53 | 89.7 | 90.29 | 733700.0 |
| 2002-07-02 13:00:00 | DIA | ETF | 90.27 | 91.13 | 89.88 | 90.76 | 1120500.0 |
| 2002-07-02 14:00:00 | DIA | ETF | 90.72 | 91.23 | 90.53 | 90.67 | 1558600.0 |
| 2002-07-02 15:00:00 | DIA | ETF | 90.71 | 90.94 | 90.1 | 90.25 | 2018300.0 |
| 2002-07-02 16:00:00 | DIA | ETF | 90.26 | 90.63 | 90.01 | 90.63 | 368100.0 |
| 2002-07-02 17:00:00 | DIA | ETF | 90.25 | 90.25 | 90.25 | 90.25 | 1000.0 |
| 2002-07-02 18:00:00 | DIA | ETF | 90.25 | 90.45 | 90.25 | 90.45 | 2000.0 |
> showing 39 of 324 rows — these rows as CSV