PREVIEW / etf_1hour / 2001-04-17
file: by_date/etf_1hour/2001/2001-04-17.parquet size: 12 KB rows: 232
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-17 09:00:00 | SPY | ETF | 117.31 | 118.22 | 117.02 | 118.0 | 1428400.0 |
| 2001-04-17 10:00:00 | SPY | ETF | 118.0 | 119.66 | 117.94 | 119.12 | 3133300.0 |
| 2001-04-17 11:00:00 | SPY | ETF | 119.1 | 119.17 | 118.55 | 118.57 | 1011300.0 |
| 2001-04-17 12:00:00 | SPY | ETF | 118.65 | 118.98 | 118.3 | 118.74 | 636500.0 |
| 2001-04-17 13:00:00 | SPY | ETF | 118.74 | 119.12 | 118.15 | 118.54 | 665400.0 |
| 2001-04-17 14:00:00 | SPY | ETF | 118.56 | 118.82 | 118.06 | 118.39 | 870100.0 |
| 2001-04-17 15:00:00 | SPY | ETF | 118.42 | 119.45 | 118.27 | 119.42 | 2066200.0 |
| 2001-04-17 16:00:00 | SPY | ETF | 119.49 | 120.6 | 118.03 | 120.56 | 950000.0 |
| 2001-04-17 17:00:00 | SPY | ETF | 120.45 | 120.8 | 120.42 | 120.59 | 16700.0 |
| 2001-04-17 18:00:00 | SPY | ETF | 120.7 | 120.9 | 120.7 | 120.78 | 2700.0 |
| 2001-04-17 09:00:00 | QQQ | ETF | 39.95 | 41.47 | 39.9 | 41.28 | 13363700.0 |
| 2001-04-17 10:00:00 | QQQ | ETF | 41.29 | 42.27 | 41.21 | 41.79 | 20502500.0 |
| 2001-04-17 11:00:00 | QQQ | ETF | 41.79 | 41.88 | 41.08 | 41.14 | 8945100.0 |
| 2001-04-17 12:00:00 | QQQ | ETF | 41.11 | 41.77 | 40.87 | 41.46 | 7533000.0 |
| 2001-04-17 13:00:00 | QQQ | ETF | 41.45 | 41.75 | 40.96 | 41.4 | 6737100.0 |
| 2001-04-17 14:00:00 | QQQ | ETF | 41.35 | 41.55 | 40.69 | 40.88 | 9517300.0 |
| 2001-04-17 15:00:00 | QQQ | ETF | 40.97 | 41.7 | 40.85 | 41.65 | 12670400.0 |
| 2001-04-17 16:00:00 | QQQ | ETF | 41.64 | 43.5 | 41.05 | 43.2 | 10425200.0 |
| 2001-04-17 17:00:00 | QQQ | ETF | 43.26 | 43.75 | 42.53 | 43.49 | 899900.0 |
| 2001-04-17 18:00:00 | QQQ | ETF | 43.48 | 43.5 | 42.25 | 43.4 | 277500.0 |
| 2001-04-17 09:00:00 | IWM | ETF | 44.375 | 45.03 | 44.375 | 45.03 | 12600.0 |
| 2001-04-17 10:00:00 | IWM | ETF | 45.095 | 45.45 | 45.05 | 45.27 | 40200.0 |
| 2001-04-17 11:00:00 | IWM | ETF | 45.275 | 45.35 | 45.05 | 45.175 | 41000.0 |
| 2001-04-17 12:00:00 | IWM | ETF | 45.275 | 45.285 | 45.0 | 45.275 | 20200.0 |
| 2001-04-17 13:00:00 | IWM | ETF | 45.15 | 45.2 | 44.955 | 44.955 | 1800.0 |
| 2001-04-17 14:00:00 | IWM | ETF | 45.025 | 45.3 | 44.875 | 45.075 | 64600.0 |
| 2001-04-17 15:00:00 | IWM | ETF | 45.1 | 45.545 | 45.1 | 45.525 | 94800.0 |
| 2001-04-17 16:00:00 | IWM | ETF | 45.55 | 45.55 | 45.3 | 45.35 | 20200.0 |
| 2001-04-17 09:00:00 | DIA | ETF | 100.77 | 101.24 | 100.71 | 100.96 | 635000.0 |
| 2001-04-17 10:00:00 | DIA | ETF | 101.1 | 102.45 | 100.98 | 101.86 | 1072100.0 |
| 2001-04-17 11:00:00 | DIA | ETF | 101.86 | 101.95 | 101.46 | 101.57 | 530300.0 |
| 2001-04-17 12:00:00 | DIA | ETF | 101.69 | 101.79 | 101.3 | 101.6 | 133300.0 |
| 2001-04-17 13:00:00 | DIA | ETF | 101.6 | 101.85 | 101.06 | 101.45 | 204100.0 |
| 2001-04-17 14:00:00 | DIA | ETF | 101.39 | 101.65 | 101.05 | 101.35 | 232800.0 |
| 2001-04-17 15:00:00 | DIA | ETF | 101.44 | 102.3 | 101.31 | 102.24 | 321700.0 |
| 2001-04-17 16:00:00 | DIA | ETF | 102.24 | 103.49 | 101.8 | 102.8 | 118300.0 |
| 2001-04-17 17:00:00 | DIA | ETF | 103.5 | 104.1 | 103.0 | 103.0 | 3300.0 |
| 2001-04-17 18:00:00 | DIA | ETF | 103.45 | 103.6 | 103.45 | 103.6 | 400.0 |
> showing 38 of 232 rows — these rows as CSV