PREVIEW / etf_1hour / 2002-06-18
file: by_date/etf_1hour/2002/2002-06-18.parquet size: 14 KB rows: 321
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-06-18 09:00:00 | SPY | ETF | 103.74 | 104.12 | 103.63 | 104.03 | 2157800.0 |
| 2002-06-18 10:00:00 | SPY | ETF | 104.07 | 104.7 | 103.85 | 104.57 | 4327400.0 |
| 2002-06-18 11:00:00 | SPY | ETF | 104.58 | 104.74 | 104.03 | 104.62 | 2041600.0 |
| 2002-06-18 12:00:00 | SPY | ETF | 104.6 | 104.65 | 104.07 | 104.1 | 1719100.0 |
| 2002-06-18 13:00:00 | SPY | ETF | 104.12 | 104.37 | 103.92 | 104.25 | 1229800.0 |
| 2002-06-18 14:00:00 | SPY | ETF | 104.17 | 104.55 | 104.04 | 104.5 | 1482500.0 |
| 2002-06-18 15:00:00 | SPY | ETF | 104.51 | 104.64 | 104.14 | 104.25 | 2632200.0 |
| 2002-06-18 16:00:00 | SPY | ETF | 104.22 | 105.48 | 104.19 | 104.66 | 5649600.0 |
| 2002-06-18 17:00:00 | SPY | ETF | 104.66 | 104.7 | 104.2 | 104.38 | 157800.0 |
| 2002-06-18 18:00:00 | SPY | ETF | 104.42 | 104.5 | 104.32 | 104.39 | 85700.0 |
| 2002-06-18 09:00:00 | QQQ | ETF | 28.31 | 28.63 | 28.31 | 28.56 | 12057500.0 |
| 2002-06-18 10:00:00 | QQQ | ETF | 28.56 | 28.95 | 28.44 | 28.82 | 20393300.0 |
| 2002-06-18 11:00:00 | QQQ | ETF | 28.81 | 28.86 | 28.5 | 28.77 | 11079900.0 |
| 2002-06-18 12:00:00 | QQQ | ETF | 28.76 | 28.82 | 28.5 | 28.53 | 7429900.0 |
| 2002-06-18 13:00:00 | QQQ | ETF | 28.52 | 28.57 | 28.31 | 28.48 | 9318900.0 |
| 2002-06-18 14:00:00 | QQQ | ETF | 28.48 | 28.64 | 28.41 | 28.59 | 7714800.0 |
| 2002-06-18 15:00:00 | QQQ | ETF | 28.59 | 28.68 | 28.32 | 28.33 | 9439900.0 |
| 2002-06-18 16:00:00 | QQQ | ETF | 28.35 | 29.25 | 28.24 | 28.61 | 18260700.0 |
| 2002-06-18 17:00:00 | QQQ | ETF | 28.62 | 28.67 | 28.23 | 28.26 | 2535400.0 |
| 2002-06-18 18:00:00 | QQQ | ETF | 28.28 | 28.38 | 28.26 | 28.32 | 423300.0 |
| 2002-06-18 09:00:00 | IWM | ETF | 46.765 | 46.91 | 46.68 | 46.89 | 169200.0 |
| 2002-06-18 10:00:00 | IWM | ETF | 46.895 | 47.275 | 46.785 | 47.2 | 526400.0 |
| 2002-06-18 11:00:00 | IWM | ETF | 47.16 | 47.245 | 46.96 | 47.09 | 257800.0 |
| 2002-06-18 12:00:00 | IWM | ETF | 47.06 | 47.125 | 46.84 | 46.84 | 105800.0 |
| 2002-06-18 13:00:00 | IWM | ETF | 46.845 | 46.845 | 46.575 | 46.77 | 100800.0 |
| 2002-06-18 14:00:00 | IWM | ETF | 46.64 | 46.815 | 46.64 | 46.81 | 153000.0 |
| 2002-06-18 15:00:00 | IWM | ETF | 46.83 | 46.945 | 46.69 | 46.69 | 350200.0 |
| 2002-06-18 16:00:00 | IWM | ETF | 46.665 | 46.945 | 46.665 | 46.71 | 220800.0 |
| 2002-06-18 09:00:00 | DIA | ETF | 96.75 | 97.04 | 96.58 | 97.02 | 458800.0 |
| 2002-06-18 10:00:00 | DIA | ETF | 96.93 | 97.47 | 96.75 | 97.4 | 587400.0 |
| 2002-06-18 11:00:00 | DIA | ETF | 97.35 | 97.45 | 96.85 | 97.35 | 304600.0 |
| 2002-06-18 12:00:00 | DIA | ETF | 97.39 | 97.42 | 96.94 | 96.95 | 105600.0 |
| 2002-06-18 13:00:00 | DIA | ETF | 97.0 | 97.18 | 96.88 | 97.05 | 335900.0 |
| 2002-06-18 14:00:00 | DIA | ETF | 97.02 | 97.32 | 96.88 | 97.22 | 229000.0 |
| 2002-06-18 15:00:00 | DIA | ETF | 97.28 | 97.4 | 96.95 | 97.2 | 364600.0 |
| 2002-06-18 16:00:00 | DIA | ETF | 97.2 | 98.0 | 96.58 | 96.58 | 210600.0 |
| 2002-06-18 17:00:00 | DIA | ETF | 97.5 | 97.6 | 97.5 | 97.6 | 25100.0 |
> showing 37 of 321 rows — these rows as CSV