PREVIEW / etf_1hour / 2002-08-28
file: by_date/etf_1hour/2002/2002-08-28.parquet size: 15 KB rows: 344
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-08-28 09:00:00 | SPY | ETF | 93.28 | 93.49 | 93.1 | 93.25 | 5085800.0 |
| 2002-08-28 10:00:00 | SPY | ETF | 93.25 | 93.37 | 92.83 | 93.01 | 4768400.0 |
| 2002-08-28 11:00:00 | SPY | ETF | 93.0 | 93.06 | 92.26 | 92.41 | 6139200.0 |
| 2002-08-28 12:00:00 | SPY | ETF | 92.38 | 92.62 | 92.0 | 92.51 | 4666900.0 |
| 2002-08-28 13:00:00 | SPY | ETF | 92.5 | 92.86 | 92.14 | 92.35 | 4892700.0 |
| 2002-08-28 14:00:00 | SPY | ETF | 92.37 | 92.5 | 91.87 | 92.12 | 5403200.0 |
| 2002-08-28 15:00:00 | SPY | ETF | 92.13 | 92.8 | 91.8 | 92.3 | 5936000.0 |
| 2002-08-28 16:00:00 | SPY | ETF | 92.3 | 92.3 | 92.1 | 92.1 | 1067000.0 |
| 2002-08-28 09:00:00 | QQQ | ETF | 24.02 | 24.09 | 23.94 | 23.99 | 9686900.0 |
| 2002-08-28 10:00:00 | QQQ | ETF | 24.0 | 24.05 | 23.82 | 23.93 | 13467900.0 |
| 2002-08-28 11:00:00 | QQQ | ETF | 23.93 | 23.96 | 23.65 | 23.7 | 12443700.0 |
| 2002-08-28 12:00:00 | QQQ | ETF | 23.72 | 23.82 | 23.6 | 23.79 | 13124800.0 |
| 2002-08-28 13:00:00 | QQQ | ETF | 23.77 | 23.95 | 23.71 | 23.82 | 17277400.0 |
| 2002-08-28 14:00:00 | QQQ | ETF | 23.82 | 23.83 | 23.45 | 23.5 | 20953800.0 |
| 2002-08-28 15:00:00 | QQQ | ETF | 23.5 | 23.74 | 23.39 | 23.5 | 22908500.0 |
| 2002-08-28 16:00:00 | QQQ | ETF | 23.48 | 23.5 | 23.45 | 23.48 | 909300.0 |
| 2002-08-28 09:00:00 | IWM | ETF | 39.35 | 39.525 | 39.3 | 39.525 | 218200.0 |
| 2002-08-28 10:00:00 | IWM | ETF | 39.495 | 39.495 | 39.25 | 39.34 | 471400.0 |
| 2002-08-28 11:00:00 | IWM | ETF | 39.305 | 39.305 | 39.08 | 39.16 | 215000.0 |
| 2002-08-28 12:00:00 | IWM | ETF | 39.135 | 39.21 | 39.03 | 39.16 | 330400.0 |
| 2002-08-28 13:00:00 | IWM | ETF | 39.22 | 39.295 | 39.075 | 39.09 | 278000.0 |
| 2002-08-28 14:00:00 | IWM | ETF | 39.09 | 39.115 | 38.955 | 39.05 | 162800.0 |
| 2002-08-28 15:00:00 | IWM | ETF | 38.99 | 39.225 | 38.835 | 38.925 | 914400.0 |
| 2002-08-28 16:00:00 | IWM | ETF | 38.9 | 39.0 | 38.9 | 39.0 | 102800.0 |
| 2002-08-28 09:00:00 | DIA | ETF | 87.76 | 87.99 | 87.6 | 87.81 | 1118800.0 |
| 2002-08-28 10:00:00 | DIA | ETF | 87.8 | 87.93 | 87.53 | 87.69 | 1097000.0 |
| 2002-08-28 11:00:00 | DIA | ETF | 87.66 | 87.72 | 87.06 | 87.22 | 1257300.0 |
| 2002-08-28 12:00:00 | DIA | ETF | 87.26 | 87.45 | 86.9 | 87.39 | 830300.0 |
| 2002-08-28 13:00:00 | DIA | ETF | 87.35 | 87.64 | 86.99 | 87.12 | 738100.0 |
| 2002-08-28 14:00:00 | DIA | ETF | 87.12 | 87.24 | 86.66 | 86.9 | 1086700.0 |
| 2002-08-28 15:00:00 | DIA | ETF | 86.9 | 87.6 | 86.58 | 87.0 | 1717300.0 |
| 2002-08-28 16:00:00 | DIA | ETF | 87.02 | 87.16 | 87.0 | 87.08 | 34700.0 |
| 2002-08-28 09:00:00 | TLT | ETF | 86.04 | 86.04 | 86.04 | 86.04 | 100.0 |
| 2002-08-28 10:00:00 | TLT | ETF | 85.87 | 86.0 | 85.84 | 86.0 | 4300.0 |
| 2002-08-28 11:00:00 | TLT | ETF | 86.03 | 86.13 | 85.98 | 85.98 | 1500.0 |
| 2002-08-28 12:00:00 | TLT | ETF | 86.12 | 86.18 | 85.99 | 85.99 | 1300.0 |
| 2002-08-28 13:00:00 | TLT | ETF | 85.99 | 86.03 | 85.93 | 85.96 | 2500.0 |
| 2002-08-28 14:00:00 | TLT | ETF | 85.96 | 86.13 | 85.96 | 86.01 | 2200.0 |
| 2002-08-28 15:00:00 | TLT | ETF | 86.05 | 86.05 | 85.87 | 85.87 | 6200.0 |
> showing 39 of 344 rows — these rows as CSV