PREVIEW / etf_1hour / 2002-05-22
file: by_date/etf_1hour/2002/2002-05-22.parquet size: 14 KB rows: 310
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-05-22 09:00:00 | SPY | ETF | 108.22 | 108.64 | 108.18 | 108.56 | 1881100.0 |
| 2002-05-22 10:00:00 | SPY | ETF | 108.57 | 109.08 | 108.3 | 108.45 | 4365500.0 |
| 2002-05-22 11:00:00 | SPY | ETF | 108.41 | 108.7 | 108.06 | 108.15 | 1415800.0 |
| 2002-05-22 12:00:00 | SPY | ETF | 108.14 | 108.59 | 108.09 | 108.44 | 739400.0 |
| 2002-05-22 13:00:00 | SPY | ETF | 108.36 | 108.64 | 108.32 | 108.47 | 694100.0 |
| 2002-05-22 14:00:00 | SPY | ETF | 108.49 | 108.65 | 108.0 | 108.11 | 1553200.0 |
| 2002-05-22 15:00:00 | SPY | ETF | 108.11 | 109.12 | 108.04 | 109.05 | 4110700.0 |
| 2002-05-22 16:00:00 | SPY | ETF | 109.06 | 109.2 | 108.85 | 108.85 | 975000.0 |
| 2002-05-22 17:00:00 | SPY | ETF | 108.9 | 109.1 | 108.9 | 109.1 | 7000.0 |
| 2002-05-22 18:00:00 | SPY | ETF | 109.02 | 109.02 | 108.92 | 108.96 | 900.0 |
| 2002-05-22 09:00:00 | QQQ | ETF | 30.97 | 31.4 | 30.85 | 31.38 | 14684100.0 |
| 2002-05-22 10:00:00 | QQQ | ETF | 31.38 | 31.59 | 31.02 | 31.05 | 13957200.0 |
| 2002-05-22 11:00:00 | QQQ | ETF | 31.05 | 31.21 | 30.82 | 30.91 | 10746800.0 |
| 2002-05-22 12:00:00 | QQQ | ETF | 30.9 | 31.18 | 30.86 | 30.98 | 5454500.0 |
| 2002-05-22 13:00:00 | QQQ | ETF | 30.98 | 31.13 | 30.96 | 31.05 | 4957700.0 |
| 2002-05-22 14:00:00 | QQQ | ETF | 31.04 | 31.14 | 30.65 | 30.69 | 11451100.0 |
| 2002-05-22 15:00:00 | QQQ | ETF | 30.69 | 31.47 | 30.66 | 31.45 | 21055800.0 |
| 2002-05-22 16:00:00 | QQQ | ETF | 31.45 | 31.5 | 30.89 | 31.3 | 4853100.0 |
| 2002-05-22 17:00:00 | QQQ | ETF | 31.3 | 31.4 | 31.3 | 31.35 | 89700.0 |
| 2002-05-22 18:00:00 | QQQ | ETF | 31.34 | 31.45 | 31.32 | 31.45 | 5600.0 |
| 2002-05-22 09:00:00 | IWM | ETF | 49.15 | 49.375 | 49.105 | 49.375 | 100800.0 |
| 2002-05-22 10:00:00 | IWM | ETF | 49.4 | 49.59 | 49.155 | 49.225 | 285400.0 |
| 2002-05-22 11:00:00 | IWM | ETF | 49.11 | 49.25 | 48.925 | 48.93 | 359000.0 |
| 2002-05-22 12:00:00 | IWM | ETF | 48.95 | 49.04 | 48.93 | 49.015 | 239000.0 |
| 2002-05-22 13:00:00 | IWM | ETF | 49.01 | 49.05 | 48.915 | 49.03 | 105400.0 |
| 2002-05-22 14:00:00 | IWM | ETF | 49.03 | 49.05 | 48.81 | 48.895 | 148800.0 |
| 2002-05-22 15:00:00 | IWM | ETF | 48.75 | 49.15 | 48.675 | 49.145 | 691200.0 |
| 2002-05-22 16:00:00 | IWM | ETF | 49.2 | 49.2 | 49.0 | 49.0 | 9600.0 |
| 2002-05-22 17:00:00 | IWM | ETF | 49.2 | 49.2 | 49.2 | 49.2 | 405400.0 |
| 2002-05-22 09:00:00 | DIA | ETF | 101.01 | 101.25 | 100.85 | 101.16 | 510700.0 |
| 2002-05-22 10:00:00 | DIA | ETF | 101.18 | 101.63 | 101.02 | 101.18 | 554900.0 |
| 2002-05-22 11:00:00 | DIA | ETF | 101.14 | 101.4 | 100.78 | 100.89 | 270900.0 |
| 2002-05-22 12:00:00 | DIA | ETF | 100.89 | 101.2 | 100.86 | 101.09 | 134800.0 |
| 2002-05-22 13:00:00 | DIA | ETF | 101.02 | 101.2 | 101.0 | 101.08 | 50100.0 |
| 2002-05-22 14:00:00 | DIA | ETF | 101.12 | 101.28 | 100.72 | 100.75 | 265700.0 |
| 2002-05-22 15:00:00 | DIA | ETF | 100.78 | 101.75 | 100.75 | 101.71 | 619100.0 |
| 2002-05-22 16:00:00 | DIA | ETF | 101.73 | 101.75 | 100.74 | 101.6 | 190300.0 |
| 2002-05-22 17:00:00 | DIA | ETF | 100.74 | 100.74 | 100.74 | 100.74 | 100000.0 |
> showing 38 of 310 rows — these rows as CSV