PREVIEW / etf_1hour / 2001-03-21
file: by_date/etf_1hour/2001/2001-03-21.parquet size: 11 KB rows: 222
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-21 09:00:00 | SPY | ETF | 114.18 | 114.44 | 113.31 | 113.52 | 2587200.0 |
| 2001-03-21 10:00:00 | SPY | ETF | 113.45 | 115.26 | 113.06 | 114.8 | 3107100.0 |
| 2001-03-21 11:00:00 | SPY | ETF | 114.67 | 114.9 | 113.58 | 113.69 | 1987900.0 |
| 2001-03-21 12:00:00 | SPY | ETF | 113.68 | 114.12 | 113.11 | 113.84 | 1699100.0 |
| 2001-03-21 13:00:00 | SPY | ETF | 113.85 | 114.02 | 112.98 | 113.53 | 1588400.0 |
| 2001-03-21 14:00:00 | SPY | ETF | 113.44 | 114.48 | 113.34 | 113.55 | 1549300.0 |
| 2001-03-21 15:00:00 | SPY | ETF | 113.6 | 114.08 | 111.9 | 112.34 | 3704200.0 |
| 2001-03-21 16:00:00 | SPY | ETF | 112.31 | 114.25 | 112.21 | 112.4 | 551500.0 |
| 2001-03-21 17:00:00 | SPY | ETF | 112.41 | 112.5 | 112.13 | 112.13 | 430600.0 |
| 2001-03-21 09:00:00 | QQQ | ETF | 40.52 | 40.84 | 39.95 | 40.25 | 11926100.0 |
| 2001-03-21 10:00:00 | QQQ | ETF | 40.25 | 41.95 | 40.0 | 41.25 | 16399700.0 |
| 2001-03-21 11:00:00 | QQQ | ETF | 41.18 | 41.43 | 40.3 | 40.4 | 10489400.0 |
| 2001-03-21 12:00:00 | QQQ | ETF | 40.4 | 40.72 | 39.99 | 40.51 | 8931900.0 |
| 2001-03-21 13:00:00 | QQQ | ETF | 40.55 | 40.64 | 39.71 | 40.3 | 8954900.0 |
| 2001-03-21 14:00:00 | QQQ | ETF | 40.3 | 41.34 | 40.01 | 40.57 | 15745100.0 |
| 2001-03-21 15:00:00 | QQQ | ETF | 40.6 | 40.9 | 39.79 | 40.1 | 18057000.0 |
| 2001-03-21 16:00:00 | QQQ | ETF | 40.01 | 40.47 | 39.94 | 40.3 | 2802500.0 |
| 2001-03-21 17:00:00 | QQQ | ETF | 40.26 | 40.48 | 40.12 | 40.36 | 46700.0 |
| 2001-03-21 18:00:00 | QQQ | ETF | 40.36 | 40.59 | 40.36 | 40.5 | 180600.0 |
| 2001-03-21 09:00:00 | IWM | ETF | 44.125 | 44.15 | 43.95 | 43.95 | 17200.0 |
| 2001-03-21 10:00:00 | IWM | ETF | 43.95 | 44.3 | 43.7 | 44.13 | 185600.0 |
| 2001-03-21 11:00:00 | IWM | ETF | 44.0 | 44.0 | 43.775 | 43.8 | 34800.0 |
| 2001-03-21 12:00:00 | IWM | ETF | 43.775 | 43.9 | 43.5 | 43.725 | 142000.0 |
| 2001-03-21 13:00:00 | IWM | ETF | 43.725 | 43.75 | 43.475 | 43.675 | 15200.0 |
| 2001-03-21 14:00:00 | IWM | ETF | 43.7 | 43.95 | 43.625 | 43.95 | 9600.0 |
| 2001-03-21 15:00:00 | IWM | ETF | 43.5 | 43.75 | 43.075 | 43.37 | 79400.0 |
| 2001-03-21 16:00:00 | IWM | ETF | 43.375 | 43.45 | 43.375 | 43.425 | 4200.0 |
| 2001-03-21 09:00:00 | DIA | ETF | 96.96 | 96.96 | 95.88 | 95.94 | 1339700.0 |
| 2001-03-21 10:00:00 | DIA | ETF | 95.8 | 97.32 | 95.4 | 96.88 | 1484100.0 |
| 2001-03-21 11:00:00 | DIA | ETF | 96.92 | 97.07 | 95.9 | 96.05 | 785600.0 |
| 2001-03-21 12:00:00 | DIA | ETF | 96.05 | 96.39 | 95.55 | 96.28 | 740800.0 |
| 2001-03-21 13:00:00 | DIA | ETF | 96.3 | 96.3 | 95.45 | 95.92 | 671500.0 |
| 2001-03-21 14:00:00 | DIA | ETF | 96.0 | 96.71 | 95.71 | 95.75 | 527400.0 |
| 2001-03-21 15:00:00 | DIA | ETF | 95.9 | 96.16 | 94.5 | 94.89 | 1356300.0 |
| 2001-03-21 16:00:00 | DIA | ETF | 94.85 | 95.15 | 94.76 | 94.96 | 608300.0 |
| 2001-03-21 17:00:00 | DIA | ETF | 94.87 | 94.87 | 94.87 | 94.87 | 500.0 |
> showing 36 of 222 rows — these rows as CSV