PREVIEW / etf_1hour / 2002-05-16
file: by_date/etf_1hour/2002/2002-05-16.parquet size: 14 KB rows: 309
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-16 09:00:00 | SPY | ETF | 109.7 | 109.97 | 109.33 | 109.55 | 2859900.0 |
| 2002-05-16 10:00:00 | SPY | ETF | 109.49 | 110.28 | 109.48 | 110.2 | 3329300.0 |
| 2002-05-16 11:00:00 | SPY | ETF | 110.17 | 110.29 | 109.95 | 110.03 | 1374800.0 |
| 2002-05-16 12:00:00 | SPY | ETF | 110.0 | 110.0 | 109.58 | 109.87 | 2334100.0 |
| 2002-05-16 13:00:00 | SPY | ETF | 109.88 | 110.07 | 109.8 | 110.02 | 858800.0 |
| 2002-05-16 14:00:00 | SPY | ETF | 110.0 | 110.43 | 109.99 | 110.31 | 3517400.0 |
| 2002-05-16 15:00:00 | SPY | ETF | 110.27 | 110.36 | 109.95 | 110.35 | 3012500.0 |
| 2002-05-16 16:00:00 | SPY | ETF | 110.29 | 110.48 | 109.97 | 110.45 | 10033100.0 |
| 2002-05-16 17:00:00 | SPY | ETF | 110.45 | 110.55 | 110.45 | 110.55 | 13700.0 |
| 2002-05-16 18:00:00 | SPY | ETF | 110.6 | 110.73 | 110.59 | 110.73 | 2400.0 |
| 2002-05-16 09:00:00 | QQQ | ETF | 32.54 | 32.79 | 32.22 | 32.35 | 12536400.0 |
| 2002-05-16 10:00:00 | QQQ | ETF | 32.33 | 32.86 | 32.23 | 32.76 | 16528600.0 |
| 2002-05-16 11:00:00 | QQQ | ETF | 32.76 | 32.81 | 32.48 | 32.49 | 7104000.0 |
| 2002-05-16 12:00:00 | QQQ | ETF | 32.51 | 32.57 | 32.25 | 32.45 | 8618800.0 |
| 2002-05-16 13:00:00 | QQQ | ETF | 32.45 | 32.65 | 32.4 | 32.57 | 5189600.0 |
| 2002-05-16 14:00:00 | QQQ | ETF | 32.6 | 32.85 | 32.52 | 32.66 | 10005100.0 |
| 2002-05-16 15:00:00 | QQQ | ETF | 32.65 | 32.76 | 32.45 | 32.75 | 9060700.0 |
| 2002-05-16 16:00:00 | QQQ | ETF | 32.75 | 33.09 | 32.4 | 32.93 | 5327700.0 |
| 2002-05-16 17:00:00 | QQQ | ETF | 32.93 | 33.02 | 32.62 | 32.99 | 869500.0 |
| 2002-05-16 18:00:00 | QQQ | ETF | 32.99 | 33.04 | 32.95 | 33.03 | 85600.0 |
| 2002-05-16 09:00:00 | IWM | ETF | 51.175 | 51.175 | 50.855 | 50.93 | 90600.0 |
| 2002-05-16 10:00:00 | IWM | ETF | 50.895 | 50.97 | 50.79 | 50.925 | 398600.0 |
| 2002-05-16 11:00:00 | IWM | ETF | 50.94 | 50.975 | 50.78 | 50.82 | 98000.0 |
| 2002-05-16 12:00:00 | IWM | ETF | 50.79 | 50.79 | 50.575 | 50.66 | 138200.0 |
| 2002-05-16 13:00:00 | IWM | ETF | 50.65 | 50.72 | 50.615 | 50.64 | 130600.0 |
| 2002-05-16 14:00:00 | IWM | ETF | 50.64 | 50.73 | 50.6 | 50.645 | 120800.0 |
| 2002-05-16 15:00:00 | IWM | ETF | 50.645 | 50.645 | 50.375 | 50.43 | 339200.0 |
| 2002-05-16 16:00:00 | IWM | ETF | 50.575 | 51.175 | 50.545 | 51.175 | 22200.0 |
| 2002-05-16 09:00:00 | DIA | ETF | 102.64 | 102.96 | 102.45 | 102.64 | 472000.0 |
| 2002-05-16 10:00:00 | DIA | ETF | 102.72 | 103.41 | 102.68 | 103.32 | 535400.0 |
| 2002-05-16 11:00:00 | DIA | ETF | 103.32 | 103.34 | 102.98 | 103.07 | 256100.0 |
| 2002-05-16 12:00:00 | DIA | ETF | 102.98 | 102.98 | 102.65 | 102.91 | 190900.0 |
| 2002-05-16 13:00:00 | DIA | ETF | 102.94 | 103.0 | 102.78 | 102.97 | 112500.0 |
| 2002-05-16 14:00:00 | DIA | ETF | 103.0 | 103.3 | 102.98 | 103.19 | 464300.0 |
| 2002-05-16 15:00:00 | DIA | ETF | 103.13 | 103.17 | 102.82 | 103.15 | 238200.0 |
| 2002-05-16 16:00:00 | DIA | ETF | 103.1 | 103.29 | 102.49 | 102.49 | 61500.0 |
> showing 36 of 309 rows — these rows as CSV