PREVIEW / etf_1hour / 2002-02-11
file: by_date/etf_1hour/2002/2002-02-11.parquet size: 13 KB rows: 288
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-11 09:00:00 | SPY | ETF | 110.05 | 110.3 | 109.82 | 110.24 | 3032000.0 |
| 2002-02-11 10:00:00 | SPY | ETF | 110.2 | 110.59 | 110.19 | 110.42 | 3129200.0 |
| 2002-02-11 11:00:00 | SPY | ETF | 110.4 | 110.72 | 110.18 | 110.67 | 2179300.0 |
| 2002-02-11 12:00:00 | SPY | ETF | 110.67 | 110.99 | 110.67 | 110.85 | 2261000.0 |
| 2002-02-11 13:00:00 | SPY | ETF | 110.83 | 111.16 | 110.72 | 111.11 | 2051600.0 |
| 2002-02-11 14:00:00 | SPY | ETF | 111.08 | 111.3 | 111.01 | 111.13 | 1366500.0 |
| 2002-02-11 15:00:00 | SPY | ETF | 111.16 | 111.63 | 111.14 | 111.59 | 2740800.0 |
| 2002-02-11 16:00:00 | SPY | ETF | 111.6 | 111.64 | 111.33 | 111.42 | 1555600.0 |
| 2002-02-11 17:00:00 | SPY | ETF | 111.41 | 111.43 | 111.4 | 111.43 | 7900.0 |
| 2002-02-11 18:00:00 | SPY | ETF | 111.33 | 111.45 | 111.33 | 111.45 | 300.0 |
| 2002-02-11 09:00:00 | QQQ | ETF | 36.14 | 36.44 | 36.03 | 36.24 | 7886900.0 |
| 2002-02-11 10:00:00 | QQQ | ETF | 36.24 | 36.4 | 36.1 | 36.25 | 9684300.0 |
| 2002-02-11 11:00:00 | QQQ | ETF | 36.25 | 36.29 | 35.98 | 36.17 | 7341600.0 |
| 2002-02-11 12:00:00 | QQQ | ETF | 36.16 | 36.4 | 36.15 | 36.29 | 7451000.0 |
| 2002-02-11 13:00:00 | QQQ | ETF | 36.29 | 36.49 | 36.2 | 36.4 | 6260300.0 |
| 2002-02-11 14:00:00 | QQQ | ETF | 36.4 | 36.58 | 36.34 | 36.47 | 5684700.0 |
| 2002-02-11 15:00:00 | QQQ | ETF | 36.46 | 36.8 | 36.44 | 36.79 | 11090700.0 |
| 2002-02-11 16:00:00 | QQQ | ETF | 36.8 | 36.81 | 36.55 | 36.57 | 1864800.0 |
| 2002-02-11 17:00:00 | QQQ | ETF | 36.59 | 36.63 | 36.56 | 36.59 | 41000.0 |
| 2002-02-11 18:00:00 | QQQ | ETF | 36.58 | 36.64 | 36.55 | 36.57 | 22900.0 |
| 2002-02-11 09:00:00 | IWM | ETF | 46.4 | 46.575 | 46.375 | 46.405 | 253600.0 |
| 2002-02-11 10:00:00 | IWM | ETF | 46.5 | 46.765 | 46.435 | 46.76 | 382800.0 |
| 2002-02-11 11:00:00 | IWM | ETF | 46.615 | 46.76 | 46.56 | 46.74 | 41400.0 |
| 2002-02-11 12:00:00 | IWM | ETF | 46.625 | 46.85 | 46.625 | 46.78 | 52600.0 |
| 2002-02-11 13:00:00 | IWM | ETF | 46.735 | 46.84 | 46.65 | 46.77 | 64400.0 |
| 2002-02-11 14:00:00 | IWM | ETF | 46.825 | 46.85 | 46.735 | 46.845 | 51200.0 |
| 2002-02-11 15:00:00 | IWM | ETF | 46.85 | 47.0 | 46.765 | 46.855 | 155200.0 |
| 2002-02-11 16:00:00 | IWM | ETF | 46.985 | 46.985 | 46.805 | 46.805 | 24600.0 |
| 2002-02-11 09:00:00 | DIA | ETF | 97.6 | 97.85 | 97.34 | 97.84 | 368700.0 |
| 2002-02-11 10:00:00 | DIA | ETF | 97.78 | 98.25 | 97.78 | 98.14 | 352600.0 |
| 2002-02-11 11:00:00 | DIA | ETF | 98.07 | 98.36 | 97.9 | 98.29 | 213100.0 |
| 2002-02-11 12:00:00 | DIA | ETF | 98.3 | 98.54 | 98.3 | 98.38 | 158600.0 |
| 2002-02-11 13:00:00 | DIA | ETF | 98.41 | 98.71 | 98.34 | 98.71 | 179300.0 |
| 2002-02-11 14:00:00 | DIA | ETF | 98.62 | 98.75 | 98.52 | 98.67 | 133700.0 |
| 2002-02-11 15:00:00 | DIA | ETF | 98.67 | 99.11 | 98.66 | 99.03 | 584300.0 |
| 2002-02-11 16:00:00 | DIA | ETF | 99.07 | 99.07 | 98.0 | 98.92 | 112000.0 |
| 2002-02-11 17:00:00 | DIA | ETF | 98.55 | 98.55 | 98.55 | 98.55 | 100.0 |
> showing 37 of 288 rows — these rows as CSV