PREVIEW / etf_1hour / 2002-09-03
file: by_date/etf_1hour/2002/2002-09-03.parquet size: 15 KB rows: 341
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-09-03 09:00:00 | SPY | ETF | 90.73 | 90.79 | 89.98 | 90.07 | 7726100.0 |
| 2002-09-03 10:00:00 | SPY | ETF | 90.06 | 90.09 | 88.9 | 89.03 | 11467500.0 |
| 2002-09-03 11:00:00 | SPY | ETF | 89.1 | 89.44 | 88.8 | 89.03 | 4565900.0 |
| 2002-09-03 12:00:00 | SPY | ETF | 89.05 | 89.55 | 88.78 | 89.43 | 4014300.0 |
| 2002-09-03 13:00:00 | SPY | ETF | 89.43 | 89.61 | 89.07 | 89.28 | 4151100.0 |
| 2002-09-03 14:00:00 | SPY | ETF | 89.28 | 89.4 | 88.75 | 88.9 | 4498500.0 |
| 2002-09-03 15:00:00 | SPY | ETF | 88.93 | 88.96 | 88.16 | 88.21 | 8768800.0 |
| 2002-09-03 16:00:00 | SPY | ETF | 88.19 | 88.32 | 88.16 | 88.28 | 1533600.0 |
| 2002-09-03 09:00:00 | QQQ | ETF | 23.06 | 23.08 | 22.81 | 22.82 | 15469500.0 |
| 2002-09-03 10:00:00 | QQQ | ETF | 22.82 | 22.87 | 22.52 | 22.56 | 19713000.0 |
| 2002-09-03 11:00:00 | QQQ | ETF | 22.56 | 22.74 | 22.47 | 22.58 | 11160200.0 |
| 2002-09-03 12:00:00 | QQQ | ETF | 22.58 | 22.68 | 22.46 | 22.64 | 5704000.0 |
| 2002-09-03 13:00:00 | QQQ | ETF | 22.64 | 22.68 | 22.51 | 22.6 | 5266000.0 |
| 2002-09-03 14:00:00 | QQQ | ETF | 22.6 | 22.64 | 22.45 | 22.52 | 7626500.0 |
| 2002-09-03 15:00:00 | QQQ | ETF | 22.52 | 22.55 | 22.34 | 22.39 | 12156500.0 |
| 2002-09-03 16:00:00 | QQQ | ETF | 22.39 | 22.7 | 22.37 | 22.64 | 2146800.0 |
| 2002-09-03 09:00:00 | IWM | ETF | 38.325 | 38.65 | 38.325 | 38.375 | 984200.0 |
| 2002-09-03 10:00:00 | IWM | ETF | 38.375 | 38.4 | 37.905 | 38.02 | 887400.0 |
| 2002-09-03 11:00:00 | IWM | ETF | 38.02 | 38.22 | 37.875 | 37.92 | 324400.0 |
| 2002-09-03 12:00:00 | IWM | ETF | 38.05 | 38.165 | 37.885 | 38.1 | 86800.0 |
| 2002-09-03 13:00:00 | IWM | ETF | 38.115 | 38.28 | 38.055 | 38.175 | 32600.0 |
| 2002-09-03 14:00:00 | IWM | ETF | 38.185 | 38.24 | 37.915 | 37.94 | 399400.0 |
| 2002-09-03 15:00:00 | IWM | ETF | 37.945 | 37.99 | 37.58 | 37.835 | 644200.0 |
| 2002-09-03 16:00:00 | IWM | ETF | 37.825 | 37.875 | 37.825 | 37.875 | 156600.0 |
| 2002-09-03 09:00:00 | DIA | ETF | 85.52 | 85.65 | 85.01 | 85.06 | 1573100.0 |
| 2002-09-03 10:00:00 | DIA | ETF | 85.06 | 85.14 | 83.9 | 84.06 | 2708200.0 |
| 2002-09-03 11:00:00 | DIA | ETF | 84.0 | 84.4 | 83.75 | 83.92 | 1589800.0 |
| 2002-09-03 12:00:00 | DIA | ETF | 83.94 | 84.43 | 83.77 | 84.3 | 992600.0 |
| 2002-09-03 13:00:00 | DIA | ETF | 84.32 | 84.51 | 84.0 | 84.27 | 1182500.0 |
| 2002-09-03 14:00:00 | DIA | ETF | 84.25 | 84.4 | 83.79 | 83.92 | 1246900.0 |
| 2002-09-03 15:00:00 | DIA | ETF | 83.88 | 84.0 | 83.11 | 83.15 | 2447900.0 |
| 2002-09-03 16:00:00 | DIA | ETF | 83.15 | 83.24 | 83.12 | 83.16 | 101100.0 |
| 2002-09-03 09:00:00 | TLT | ETF | 87.08 | 87.08 | 87.0 | 87.0 | 6300.0 |
| 2002-09-03 10:00:00 | TLT | ETF | 87.17 | 87.78 | 87.14 | 87.78 | 28300.0 |
| 2002-09-03 11:00:00 | TLT | ETF | 87.8 | 87.86 | 87.65 | 87.72 | 3100.0 |
| 2002-09-03 12:00:00 | TLT | ETF | 87.92 | 88.0 | 87.85 | 87.94 | 30200.0 |
| 2002-09-03 13:00:00 | TLT | ETF | 87.95 | 87.95 | 87.8 | 87.89 | 5400.0 |
| 2002-09-03 14:00:00 | TLT | ETF | 87.94 | 87.95 | 87.74 | 87.74 | 11500.0 |
| 2002-09-03 15:00:00 | TLT | ETF | 87.97 | 88.04 | 87.93 | 88.04 | 17300.0 |
> showing 39 of 341 rows — these rows as CSV