PREVIEW / etf_1hour / 2001-02-05
file: by_date/etf_1hour/2001/2001-02-05.parquet size: 11 KB rows: 204
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-02-05 09:00:00 | SPY | ETF | 134.8 | 135.4 | 134.8 | 135.36 | 771300.0 |
| 2001-02-05 10:00:00 | SPY | ETF | 135.4 | 135.6 | 134.87 | 134.95 | 742000.0 |
| 2001-02-05 11:00:00 | SPY | ETF | 134.91 | 135.46 | 134.91 | 135.1 | 371700.0 |
| 2001-02-05 12:00:00 | SPY | ETF | 135.19 | 135.34 | 134.9 | 135.14 | 221600.0 |
| 2001-02-05 13:00:00 | SPY | ETF | 135.1 | 135.25 | 134.75 | 135.25 | 397500.0 |
| 2001-02-05 14:00:00 | SPY | ETF | 135.29 | 135.7 | 135.05 | 135.65 | 580400.0 |
| 2001-02-05 15:00:00 | SPY | ETF | 135.56 | 135.9 | 135.3 | 135.89 | 562900.0 |
| 2001-02-05 16:00:00 | SPY | ETF | 135.89 | 136.0 | 135.44 | 136.0 | 611400.0 |
| 2001-02-05 09:00:00 | QQQ | ETF | 61.19 | 61.39 | 60.58 | 61.11 | 6573100.0 |
| 2001-02-05 10:00:00 | QQQ | ETF | 61.1 | 61.9 | 60.84 | 61.07 | 6086700.0 |
| 2001-02-05 11:00:00 | QQQ | ETF | 61.06 | 61.78 | 60.88 | 61.04 | 5215600.0 |
| 2001-02-05 12:00:00 | QQQ | ETF | 61.03 | 61.19 | 60.6 | 60.76 | 2490800.0 |
| 2001-02-05 13:00:00 | QQQ | ETF | 60.68 | 60.8 | 60.12 | 60.47 | 4685100.0 |
| 2001-02-05 14:00:00 | QQQ | ETF | 60.48 | 61.25 | 60.25 | 61.12 | 4510100.0 |
| 2001-02-05 15:00:00 | QQQ | ETF | 61.12 | 61.68 | 61.03 | 61.56 | 5410800.0 |
| 2001-02-05 16:00:00 | QQQ | ETF | 61.65 | 61.79 | 61.4 | 61.7 | 564200.0 |
| 2001-02-05 17:00:00 | QQQ | ETF | 61.7 | 61.73 | 61.6 | 61.7 | 26800.0 |
| 2001-02-05 18:00:00 | QQQ | ETF | 61.65 | 61.65 | 61.6 | 61.6 | 1300.0 |
| 2001-02-05 09:00:00 | IWM | ETF | 49.5 | 49.75 | 49.5 | 49.6 | 81200.0 |
| 2001-02-05 10:00:00 | IWM | ETF | 49.85 | 49.9 | 49.675 | 49.835 | 9600.0 |
| 2001-02-05 11:00:00 | IWM | ETF | 49.795 | 49.925 | 49.75 | 49.795 | 2400.0 |
| 2001-02-05 12:00:00 | IWM | ETF | 49.795 | 49.82 | 49.65 | 49.65 | 18800.0 |
| 2001-02-05 13:00:00 | IWM | ETF | 49.65 | 49.65 | 49.455 | 49.455 | 37600.0 |
| 2001-02-05 14:00:00 | IWM | ETF | 49.775 | 49.95 | 49.6 | 49.75 | 17600.0 |
| 2001-02-05 15:00:00 | IWM | ETF | 49.9 | 49.995 | 49.7 | 49.995 | 370800.0 |
| 2001-02-05 16:00:00 | IWM | ETF | 49.785 | 49.785 | 49.785 | 49.785 | 800.0 |
| 2001-02-05 09:00:00 | DIA | ETF | 108.87 | 109.23 | 108.75 | 109.0 | 313700.0 |
| 2001-02-05 10:00:00 | DIA | ETF | 109.0 | 109.35 | 108.85 | 108.96 | 208100.0 |
| 2001-02-05 11:00:00 | DIA | ETF | 108.99 | 109.25 | 108.86 | 109.1 | 121600.0 |
| 2001-02-05 12:00:00 | DIA | ETF | 109.24 | 109.47 | 109.15 | 109.24 | 168200.0 |
| 2001-02-05 13:00:00 | DIA | ETF | 109.25 | 109.8 | 109.0 | 109.56 | 191100.0 |
| 2001-02-05 14:00:00 | DIA | ETF | 109.73 | 109.89 | 109.43 | 109.74 | 239700.0 |
| 2001-02-05 15:00:00 | DIA | ETF | 109.67 | 109.88 | 109.44 | 109.83 | 230500.0 |
| 2001-02-05 16:00:00 | DIA | ETF | 109.7 | 109.89 | 109.66 | 109.8 | 36900.0 |
> showing 34 of 204 rows — these rows as CSV