PREVIEW / etf_1hour / 2002-05-03
file: by_date/etf_1hour/2002/2002-05-03.parquet size: 14 KB rows: 314
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-03 09:00:00 | SPY | ETF | 108.6 | 108.7 | 107.68 | 107.77 | 3344700.0 |
| 2002-05-03 10:00:00 | SPY | ETF | 107.76 | 107.94 | 107.28 | 107.76 | 3651600.0 |
| 2002-05-03 11:00:00 | SPY | ETF | 107.73 | 107.92 | 107.48 | 107.61 | 1861900.0 |
| 2002-05-03 12:00:00 | SPY | ETF | 107.67 | 107.67 | 107.2 | 107.43 | 1248200.0 |
| 2002-05-03 13:00:00 | SPY | ETF | 107.4 | 107.66 | 107.24 | 107.41 | 1139600.0 |
| 2002-05-03 14:00:00 | SPY | ETF | 107.41 | 108.23 | 107.29 | 107.94 | 2923600.0 |
| 2002-05-03 15:00:00 | SPY | ETF | 107.92 | 108.09 | 107.57 | 107.67 | 2552600.0 |
| 2002-05-03 16:00:00 | SPY | ETF | 107.65 | 108.6 | 107.47 | 107.75 | 1342200.0 |
| 2002-05-03 17:00:00 | SPY | ETF | 107.75 | 107.78 | 107.45 | 107.78 | 4500.0 |
| 2002-05-03 09:00:00 | QQQ | ETF | 30.47 | 30.51 | 29.88 | 29.93 | 16699900.0 |
| 2002-05-03 10:00:00 | QQQ | ETF | 29.91 | 30.1 | 29.7 | 29.91 | 18465700.0 |
| 2002-05-03 11:00:00 | QQQ | ETF | 29.91 | 30.01 | 29.63 | 29.71 | 7881800.0 |
| 2002-05-03 12:00:00 | QQQ | ETF | 29.71 | 29.75 | 29.48 | 29.62 | 10363800.0 |
| 2002-05-03 13:00:00 | QQQ | ETF | 29.62 | 29.8 | 29.52 | 29.68 | 6673300.0 |
| 2002-05-03 14:00:00 | QQQ | ETF | 29.66 | 30.19 | 29.59 | 29.95 | 13810500.0 |
| 2002-05-03 15:00:00 | QQQ | ETF | 29.95 | 30.0 | 29.63 | 29.65 | 12029200.0 |
| 2002-05-03 16:00:00 | QQQ | ETF | 29.69 | 29.96 | 29.5 | 29.69 | 4681900.0 |
| 2002-05-03 17:00:00 | QQQ | ETF | 29.69 | 29.81 | 29.69 | 29.78 | 527600.0 |
| 2002-05-03 18:00:00 | QQQ | ETF | 29.8 | 29.85 | 29.78 | 29.84 | 18600.0 |
| 2002-05-03 09:00:00 | IWM | ETF | 51.25 | 51.25 | 50.83 | 50.845 | 63400.0 |
| 2002-05-03 10:00:00 | IWM | ETF | 50.78 | 50.93 | 50.65 | 50.89 | 543600.0 |
| 2002-05-03 11:00:00 | IWM | ETF | 50.84 | 51.03 | 50.825 | 50.88 | 64400.0 |
| 2002-05-03 12:00:00 | IWM | ETF | 50.91 | 50.91 | 50.7 | 50.83 | 99600.0 |
| 2002-05-03 13:00:00 | IWM | ETF | 50.87 | 50.96 | 50.735 | 50.93 | 68600.0 |
| 2002-05-03 14:00:00 | IWM | ETF | 50.93 | 51.175 | 50.875 | 51.125 | 317400.0 |
| 2002-05-03 15:00:00 | IWM | ETF | 51.085 | 51.16 | 50.835 | 50.85 | 336800.0 |
| 2002-05-03 16:00:00 | IWM | ETF | 50.95 | 50.95 | 50.95 | 50.95 | 1000.0 |
| 2002-05-03 09:00:00 | DIA | ETF | 100.73 | 100.89 | 100.06 | 100.1 | 476400.0 |
| 2002-05-03 10:00:00 | DIA | ETF | 100.1 | 100.32 | 99.72 | 99.95 | 1678300.0 |
| 2002-05-03 11:00:00 | DIA | ETF | 99.97 | 100.17 | 99.84 | 100.0 | 393400.0 |
| 2002-05-03 12:00:00 | DIA | ETF | 100.0 | 100.05 | 99.45 | 99.66 | 573300.0 |
| 2002-05-03 13:00:00 | DIA | ETF | 99.68 | 99.92 | 99.6 | 99.68 | 210200.0 |
| 2002-05-03 14:00:00 | DIA | ETF | 99.67 | 100.38 | 99.56 | 100.25 | 657300.0 |
| 2002-05-03 15:00:00 | DIA | ETF | 100.25 | 100.38 | 100.0 | 100.2 | 297000.0 |
| 2002-05-03 16:00:00 | DIA | ETF | 100.15 | 100.18 | 99.49 | 99.56 | 55300.0 |
> showing 35 of 314 rows — these rows as CSV