PREVIEW / etf_1hour / 2002-07-05
file: by_date/etf_1hour/2002/2002-07-05.parquet size: 11 KB rows: 191
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-05 09:00:00 | SPY | ETF | 96.78 | 97.3 | 96.66 | 97.18 | 3937200.0 |
| 2002-07-05 10:00:00 | SPY | ETF | 97.2 | 98.54 | 97.15 | 98.17 | 4479200.0 |
| 2002-07-05 11:00:00 | SPY | ETF | 98.15 | 98.83 | 98.14 | 98.53 | 3517300.0 |
| 2002-07-05 12:00:00 | SPY | ETF | 98.52 | 99.31 | 98.4 | 99.31 | 4993600.0 |
| 2002-07-05 13:00:00 | SPY | ETF | 99.32 | 99.53 | 99.24 | 99.31 | 1149000.0 |
| 2002-07-05 09:00:00 | QQQ | ETF | 25.26 | 25.67 | 25.26 | 25.62 | 11943200.0 |
| 2002-07-05 10:00:00 | QQQ | ETF | 25.61 | 26.04 | 25.6 | 25.86 | 17374500.0 |
| 2002-07-05 11:00:00 | QQQ | ETF | 25.84 | 26.14 | 25.82 | 26.04 | 9289400.0 |
| 2002-07-05 12:00:00 | QQQ | ETF | 26.03 | 26.37 | 25.94 | 26.36 | 12752500.0 |
| 2002-07-05 13:00:00 | QQQ | ETF | 26.35 | 26.39 | 26.27 | 26.34 | 2375600.0 |
| 2002-07-05 09:00:00 | IWM | ETF | 43.075 | 43.25 | 42.9 | 43.225 | 108000.0 |
| 2002-07-05 10:00:00 | IWM | ETF | 43.325 | 43.925 | 43.3 | 43.765 | 223000.0 |
| 2002-07-05 11:00:00 | IWM | ETF | 43.765 | 43.875 | 43.705 | 43.84 | 177000.0 |
| 2002-07-05 12:00:00 | IWM | ETF | 43.8 | 43.925 | 43.645 | 43.825 | 243600.0 |
| 2002-07-05 13:00:00 | IWM | ETF | 43.8 | 43.96 | 43.8 | 43.96 | 4800.0 |
| 2002-07-05 09:00:00 | DIA | ETF | 91.6 | 92.14 | 91.49 | 92.02 | 880900.0 |
| 2002-07-05 10:00:00 | DIA | ETF | 92.05 | 93.17 | 92.03 | 92.93 | 585900.0 |
| 2002-07-05 11:00:00 | DIA | ETF | 92.91 | 93.66 | 92.9 | 93.39 | 510500.0 |
| 2002-07-05 12:00:00 | DIA | ETF | 93.35 | 94.0 | 93.14 | 94.0 | 798000.0 |
| 2002-07-05 13:00:00 | DIA | ETF | 93.9 | 94.17 | 93.9 | 94.17 | 98700.0 |
> showing 20 of 191 rows — these rows as CSV