PREVIEW / etf_1hour / 2001-03-26
file: by_date/etf_1hour/2001/2001-03-26.parquet size: 11 KB rows: 223
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-03-26 09:00:00 | SPY | ETF | 115.7 | 115.8 | 115.2 | 115.4 | 1559000.0 |
| 2001-03-26 10:00:00 | SPY | ETF | 115.27 | 116.01 | 115.02 | 115.56 | 1672700.0 |
| 2001-03-26 11:00:00 | SPY | ETF | 115.67 | 115.99 | 115.33 | 115.99 | 678000.0 |
| 2001-03-26 12:00:00 | SPY | ETF | 115.95 | 116.27 | 115.67 | 115.8 | 713200.0 |
| 2001-03-26 13:00:00 | SPY | ETF | 115.79 | 115.99 | 115.14 | 115.43 | 1079900.0 |
| 2001-03-26 14:00:00 | SPY | ETF | 115.35 | 115.6 | 114.84 | 115.2 | 1154600.0 |
| 2001-03-26 15:00:00 | SPY | ETF | 115.19 | 115.7 | 114.77 | 115.5 | 1509000.0 |
| 2001-03-26 16:00:00 | SPY | ETF | 115.62 | 116.25 | 115.4 | 115.8 | 593600.0 |
| 2001-03-26 17:00:00 | SPY | ETF | 116.0 | 116.0 | 116.0 | 116.0 | 1000.0 |
| 2001-03-26 18:00:00 | SPY | ETF | 116.01 | 116.01 | 116.0 | 116.0 | 1000.0 |
| 2001-03-26 09:00:00 | QQQ | ETF | 43.47 | 43.49 | 42.77 | 42.81 | 7914000.0 |
| 2001-03-26 10:00:00 | QQQ | ETF | 42.84 | 43.21 | 42.6 | 42.92 | 9361300.0 |
| 2001-03-26 11:00:00 | QQQ | ETF | 42.92 | 43.05 | 42.6 | 43.0 | 5375700.0 |
| 2001-03-26 12:00:00 | QQQ | ETF | 43.01 | 43.19 | 42.53 | 42.62 | 5108900.0 |
| 2001-03-26 13:00:00 | QQQ | ETF | 42.62 | 42.8 | 42.03 | 42.22 | 6628400.0 |
| 2001-03-26 14:00:00 | QQQ | ETF | 42.22 | 42.26 | 41.7 | 41.84 | 7392000.0 |
| 2001-03-26 15:00:00 | QQQ | ETF | 41.86 | 42.0 | 41.55 | 41.93 | 7873800.0 |
| 2001-03-26 16:00:00 | QQQ | ETF | 41.9 | 43.4 | 41.75 | 41.97 | 1480500.0 |
| 2001-03-26 17:00:00 | QQQ | ETF | 41.85 | 42.49 | 41.85 | 41.96 | 779300.0 |
| 2001-03-26 18:00:00 | QQQ | ETF | 41.9 | 41.98 | 41.9 | 41.9 | 7600.0 |
| 2001-03-26 09:00:00 | IWM | ETF | 44.5 | 44.7 | 44.3 | 44.7 | 86400.0 |
| 2001-03-26 10:00:00 | IWM | ETF | 44.7 | 44.825 | 44.5 | 44.8 | 16000.0 |
| 2001-03-26 11:00:00 | IWM | ETF | 44.73 | 44.85 | 44.625 | 44.825 | 3800.0 |
| 2001-03-26 12:00:00 | IWM | ETF | 44.875 | 44.975 | 44.775 | 44.875 | 19800.0 |
| 2001-03-26 13:00:00 | IWM | ETF | 44.875 | 44.875 | 44.5 | 44.675 | 305600.0 |
| 2001-03-26 14:00:00 | IWM | ETF | 44.665 | 44.695 | 44.325 | 44.575 | 26600.0 |
| 2001-03-26 15:00:00 | IWM | ETF | 44.4 | 44.65 | 44.4 | 44.65 | 315400.0 |
| 2001-03-26 16:00:00 | IWM | ETF | 44.75 | 44.75 | 44.725 | 44.725 | 26400.0 |
| 2001-03-26 09:00:00 | DIA | ETF | 96.0 | 96.55 | 95.9 | 95.9 | 1022400.0 |
| 2001-03-26 10:00:00 | DIA | ETF | 95.9 | 96.77 | 95.8 | 96.43 | 836900.0 |
| 2001-03-26 11:00:00 | DIA | ETF | 96.46 | 97.06 | 96.16 | 97.06 | 492200.0 |
| 2001-03-26 12:00:00 | DIA | ETF | 97.19 | 97.33 | 96.96 | 97.0 | 750000.0 |
| 2001-03-26 13:00:00 | DIA | ETF | 97.0 | 97.17 | 96.51 | 96.7 | 571700.0 |
| 2001-03-26 14:00:00 | DIA | ETF | 96.65 | 96.87 | 96.25 | 96.79 | 625700.0 |
| 2001-03-26 15:00:00 | DIA | ETF | 96.78 | 97.0 | 96.35 | 97.0 | 551600.0 |
| 2001-03-26 16:00:00 | DIA | ETF | 97.0 | 97.45 | 96.85 | 97.18 | 398900.0 |
| 2001-03-26 17:00:00 | DIA | ETF | 97.16 | 97.21 | 97.16 | 97.21 | 300.0 |
| 2001-03-26 18:00:00 | DIA | ETF | 97.4 | 97.4 | 97.4 | 97.4 | 300.0 |
> showing 38 of 223 rows — these rows as CSV