PREVIEW / etf_1hour / 2001-04-03
file: by_date/etf_1hour/2001/2001-04-03.parquet size: 12 KB rows: 230
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 |
|---|---|---|---|---|---|---|---|
| 2001-04-03 09:00:00 | SPY | ETF | 113.98 | 114.15 | 113.22 | 113.25 | 1915200.0 |
| 2001-04-03 10:00:00 | SPY | ETF | 113.22 | 113.49 | 112.55 | 112.75 | 2252500.0 |
| 2001-04-03 11:00:00 | SPY | ETF | 112.72 | 112.76 | 111.55 | 111.85 | 1715000.0 |
| 2001-04-03 12:00:00 | SPY | ETF | 111.81 | 112.58 | 111.51 | 112.23 | 1076100.0 |
| 2001-04-03 13:00:00 | SPY | ETF | 112.24 | 112.24 | 111.48 | 111.74 | 706700.0 |
| 2001-04-03 14:00:00 | SPY | ETF | 111.75 | 111.89 | 110.48 | 111.03 | 1935900.0 |
| 2001-04-03 15:00:00 | SPY | ETF | 111.19 | 111.19 | 110.1 | 110.67 | 2608200.0 |
| 2001-04-03 16:00:00 | SPY | ETF | 110.66 | 110.89 | 110.02 | 110.2 | 522700.0 |
| 2001-04-03 17:00:00 | SPY | ETF | 110.32 | 110.32 | 110.05 | 110.1 | 102400.0 |
| 2001-04-03 18:00:00 | SPY | ETF | 110.05 | 110.05 | 110.05 | 110.05 | 2000.0 |
| 2001-04-03 09:00:00 | QQQ | ETF | 37.2 | 37.3 | 36.19 | 36.3 | 9382500.0 |
| 2001-04-03 10:00:00 | QQQ | ETF | 36.44 | 36.78 | 36.01 | 36.09 | 13452700.0 |
| 2001-04-03 11:00:00 | QQQ | ETF | 36.06 | 36.1 | 35.2 | 35.58 | 19907200.0 |
| 2001-04-03 12:00:00 | QQQ | ETF | 35.52 | 36.15 | 35.37 | 35.89 | 8951800.0 |
| 2001-04-03 13:00:00 | QQQ | ETF | 35.86 | 35.96 | 35.33 | 35.46 | 6741500.0 |
| 2001-04-03 14:00:00 | QQQ | ETF | 35.43 | 35.58 | 35.01 | 35.27 | 10422500.0 |
| 2001-04-03 15:00:00 | QQQ | ETF | 35.26 | 35.37 | 34.62 | 34.86 | 14858300.0 |
| 2001-04-03 16:00:00 | QQQ | ETF | 34.89 | 37.0 | 34.54 | 34.66 | 3069700.0 |
| 2001-04-03 17:00:00 | QQQ | ETF | 34.66 | 34.85 | 34.57 | 34.62 | 164700.0 |
| 2001-04-03 18:00:00 | QQQ | ETF | 34.58 | 34.6 | 34.4 | 34.44 | 46700.0 |
| 2001-04-03 09:00:00 | IWM | ETF | 43.65 | 43.65 | 43.225 | 43.25 | 71800.0 |
| 2001-04-03 10:00:00 | IWM | ETF | 43.05 | 43.05 | 42.75 | 42.75 | 59200.0 |
| 2001-04-03 11:00:00 | IWM | ETF | 42.75 | 42.75 | 42.4 | 42.6 | 153000.0 |
| 2001-04-03 12:00:00 | IWM | ETF | 42.5 | 42.675 | 42.4 | 42.5 | 157600.0 |
| 2001-04-03 13:00:00 | IWM | ETF | 42.575 | 42.575 | 42.325 | 42.405 | 10800.0 |
| 2001-04-03 14:00:00 | IWM | ETF | 42.55 | 42.55 | 42.25 | 42.445 | 24600.0 |
| 2001-04-03 15:00:00 | IWM | ETF | 42.45 | 42.475 | 42.125 | 42.395 | 28400.0 |
| 2001-04-03 16:00:00 | IWM | ETF | 42.265 | 42.265 | 42.265 | 42.265 | 2000.0 |
| 2001-04-03 09:00:00 | DIA | ETF | 97.05 | 97.2 | 96.4 | 96.4 | 1282300.0 |
| 2001-04-03 10:00:00 | DIA | ETF | 96.39 | 96.7 | 95.87 | 96.18 | 1200100.0 |
| 2001-04-03 11:00:00 | DIA | ETF | 96.11 | 96.19 | 95.29 | 95.58 | 1051800.0 |
| 2001-04-03 12:00:00 | DIA | ETF | 95.44 | 96.24 | 95.17 | 95.81 | 784700.0 |
| 2001-04-03 13:00:00 | DIA | ETF | 95.8 | 96.05 | 95.4 | 95.55 | 272600.0 |
| 2001-04-03 14:00:00 | DIA | ETF | 95.55 | 95.8 | 94.5 | 95.0 | 900100.0 |
| 2001-04-03 15:00:00 | DIA | ETF | 95.0 | 95.1 | 94.25 | 94.85 | 835900.0 |
| 2001-04-03 16:00:00 | DIA | ETF | 94.8 | 94.95 | 94.26 | 94.43 | 201200.0 |
| 2001-04-03 17:00:00 | DIA | ETF | 94.26 | 94.26 | 94.26 | 94.26 | 2000.0 |
| 2001-04-03 18:00:00 | DIA | ETF | 94.25 | 94.25 | 94.25 | 94.25 | 300.0 |
> showing 38 of 230 rows — these rows as CSV