PREVIEW / etf_1hour / 2002-02-13
file: by_date/etf_1hour/2002/2002-02-13.parquet size: 13 KB rows: 282
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 |
|---|---|---|---|---|---|---|---|
| 2002-02-13 09:00:00 | SPY | ETF | 111.48 | 112.02 | 111.35 | 111.9 | 2452500.0 |
| 2002-02-13 10:00:00 | SPY | ETF | 111.88 | 112.54 | 111.82 | 112.15 | 4369500.0 |
| 2002-02-13 11:00:00 | SPY | ETF | 112.15 | 112.24 | 111.79 | 111.91 | 2259900.0 |
| 2002-02-13 12:00:00 | SPY | ETF | 111.91 | 112.2 | 111.82 | 112.06 | 1741100.0 |
| 2002-02-13 13:00:00 | SPY | ETF | 112.06 | 112.44 | 112.02 | 112.13 | 2016100.0 |
| 2002-02-13 14:00:00 | SPY | ETF | 112.12 | 112.32 | 111.81 | 111.87 | 1597200.0 |
| 2002-02-13 15:00:00 | SPY | ETF | 111.9 | 112.3 | 111.86 | 112.26 | 1371000.0 |
| 2002-02-13 16:00:00 | SPY | ETF | 112.25 | 112.39 | 112.16 | 112.27 | 855200.0 |
| 2002-02-13 17:00:00 | SPY | ETF | 112.26 | 112.36 | 112.25 | 112.36 | 2900.0 |
| 2002-02-13 18:00:00 | SPY | ETF | 112.19 | 112.5 | 112.19 | 112.5 | 8400.0 |
| 2002-02-13 09:00:00 | QQQ | ETF | 36.72 | 37.15 | 36.67 | 37.05 | 8637600.0 |
| 2002-02-13 10:00:00 | QQQ | ETF | 37.06 | 37.15 | 36.75 | 36.78 | 16059900.0 |
| 2002-02-13 11:00:00 | QQQ | ETF | 36.77 | 36.9 | 36.61 | 36.82 | 8031000.0 |
| 2002-02-13 12:00:00 | QQQ | ETF | 36.85 | 37.0 | 36.7 | 36.88 | 3966200.0 |
| 2002-02-13 13:00:00 | QQQ | ETF | 36.89 | 37.15 | 36.88 | 36.94 | 7943100.0 |
| 2002-02-13 14:00:00 | QQQ | ETF | 36.96 | 37.11 | 36.78 | 36.85 | 7287800.0 |
| 2002-02-13 15:00:00 | QQQ | ETF | 36.85 | 37.1 | 36.82 | 36.95 | 7578500.0 |
| 2002-02-13 16:00:00 | QQQ | ETF | 36.96 | 37.02 | 36.7 | 36.91 | 1427100.0 |
| 2002-02-13 17:00:00 | QQQ | ETF | 36.94 | 37.0 | 36.93 | 36.97 | 89600.0 |
| 2002-02-13 18:00:00 | QQQ | ETF | 36.96 | 36.99 | 36.94 | 36.99 | 7000.0 |
| 2002-02-13 09:00:00 | IWM | ETF | 47.125 | 47.275 | 47.005 | 47.27 | 69800.0 |
| 2002-02-13 10:00:00 | IWM | ETF | 47.275 | 47.385 | 47.23 | 47.285 | 52000.0 |
| 2002-02-13 11:00:00 | IWM | ETF | 47.25 | 47.275 | 47.15 | 47.2 | 20000.0 |
| 2002-02-13 12:00:00 | IWM | ETF | 47.2 | 47.245 | 47.125 | 47.165 | 48200.0 |
| 2002-02-13 13:00:00 | IWM | ETF | 47.235 | 47.28 | 47.17 | 47.17 | 20000.0 |
| 2002-02-13 14:00:00 | IWM | ETF | 47.235 | 47.245 | 47.09 | 47.165 | 23400.0 |
| 2002-02-13 15:00:00 | IWM | ETF | 47.155 | 47.395 | 47.07 | 47.395 | 118200.0 |
| 2002-02-13 16:00:00 | IWM | ETF | 47.35 | 47.35 | 47.35 | 47.35 | 5200.0 |
| 2002-02-13 09:00:00 | DIA | ETF | 99.16 | 99.72 | 98.99 | 99.56 | 314100.0 |
| 2002-02-13 10:00:00 | DIA | ETF | 99.53 | 100.19 | 99.48 | 99.87 | 1252100.0 |
| 2002-02-13 11:00:00 | DIA | ETF | 99.86 | 99.99 | 99.57 | 99.7 | 640100.0 |
| 2002-02-13 12:00:00 | DIA | ETF | 99.71 | 99.94 | 99.53 | 99.79 | 163800.0 |
| 2002-02-13 13:00:00 | DIA | ETF | 99.79 | 100.08 | 99.79 | 99.88 | 254400.0 |
| 2002-02-13 14:00:00 | DIA | ETF | 99.88 | 100.15 | 99.68 | 99.77 | 220600.0 |
| 2002-02-13 15:00:00 | DIA | ETF | 99.83 | 100.1 | 99.73 | 100.0 | 360600.0 |
| 2002-02-13 16:00:00 | DIA | ETF | 100.05 | 100.12 | 99.58 | 99.58 | 19200.0 |
> showing 36 of 282 rows — these rows as CSV