PREVIEW / etf_1hour / 2002-12-06
file: by_date/etf_1hour/2002/2002-12-06.parquet size: 16 KB rows: 376
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-12-06 08:00:00 | SPY | ETF | 90.87 | 91.35 | 89.86 | 90.04 | 211400.0 |
| 2002-12-06 09:00:00 | SPY | ETF | 90.03 | 90.91 | 89.81 | 90.89 | 7247500.0 |
| 2002-12-06 10:00:00 | SPY | ETF | 90.92 | 91.6 | 90.82 | 91.24 | 12912500.0 |
| 2002-12-06 11:00:00 | SPY | ETF | 91.25 | 91.69 | 90.97 | 91.49 | 4187200.0 |
| 2002-12-06 12:00:00 | SPY | ETF | 91.5 | 91.83 | 91.39 | 91.53 | 3818900.0 |
| 2002-12-06 13:00:00 | SPY | ETF | 91.53 | 92.05 | 91.45 | 91.92 | 3608200.0 |
| 2002-12-06 14:00:00 | SPY | ETF | 91.92 | 92.17 | 91.48 | 91.48 | 4534600.0 |
| 2002-12-06 15:00:00 | SPY | ETF | 91.54 | 91.8 | 91.2 | 91.8 | 5927000.0 |
| 2002-12-06 16:00:00 | SPY | ETF | 91.79 | 92.45 | 91.67 | 92.03 | 1969800.0 |
| 2002-12-06 17:00:00 | SPY | ETF | 92.05 | 92.1 | 91.9 | 92.1 | 314700.0 |
| 2002-12-06 18:00:00 | SPY | ETF | 92.17 | 92.23 | 92.15 | 92.15 | 2900.0 |
| 2002-12-06 19:00:00 | SPY | ETF | 92.34 | 92.34 | 92.34 | 92.34 | 500.0 |
| 2002-12-06 08:00:00 | QQQ | ETF | 26.14 | 26.26 | 25.61 | 25.65 | 320200.0 |
| 2002-12-06 09:00:00 | QQQ | ETF | 25.65 | 26.15 | 25.63 | 26.15 | 12525400.0 |
| 2002-12-06 10:00:00 | QQQ | ETF | 26.13 | 26.56 | 26.0 | 26.35 | 16994700.0 |
| 2002-12-06 11:00:00 | QQQ | ETF | 26.39 | 26.52 | 26.26 | 26.43 | 9284900.0 |
| 2002-12-06 12:00:00 | QQQ | ETF | 26.44 | 26.52 | 26.3 | 26.42 | 5759300.0 |
| 2002-12-06 13:00:00 | QQQ | ETF | 26.42 | 26.67 | 26.34 | 26.59 | 7664100.0 |
| 2002-12-06 14:00:00 | QQQ | ETF | 26.6 | 26.72 | 26.43 | 26.43 | 9538800.0 |
| 2002-12-06 15:00:00 | QQQ | ETF | 26.44 | 26.55 | 26.35 | 26.47 | 11409300.0 |
| 2002-12-06 16:00:00 | QQQ | ETF | 26.5 | 26.58 | 25.95 | 26.53 | 3905500.0 |
| 2002-12-06 17:00:00 | QQQ | ETF | 26.54 | 26.6 | 26.51 | 26.56 | 57700.0 |
| 2002-12-06 18:00:00 | QQQ | ETF | 26.55 | 26.6 | 26.52 | 26.59 | 16300.0 |
| 2002-12-06 19:00:00 | QQQ | ETF | 26.55 | 26.6 | 26.55 | 26.58 | 6100.0 |
| 2002-12-06 08:00:00 | IWM | ETF | 38.97 | 38.97 | 38.97 | 38.97 | 1000.0 |
| 2002-12-06 09:00:00 | IWM | ETF | 39.0 | 39.215 | 38.925 | 39.16 | 163800.0 |
| 2002-12-06 10:00:00 | IWM | ETF | 39.175 | 39.495 | 39.13 | 39.3 | 509000.0 |
| 2002-12-06 11:00:00 | IWM | ETF | 39.335 | 39.425 | 39.26 | 39.395 | 275200.0 |
| 2002-12-06 12:00:00 | IWM | ETF | 39.395 | 39.445 | 39.305 | 39.42 | 96400.0 |
| 2002-12-06 13:00:00 | IWM | ETF | 39.435 | 39.695 | 39.41 | 39.69 | 178000.0 |
| 2002-12-06 14:00:00 | IWM | ETF | 39.69 | 39.79 | 39.62 | 39.63 | 72800.0 |
| 2002-12-06 15:00:00 | IWM | ETF | 39.61 | 39.655 | 39.54 | 39.62 | 106800.0 |
| 2002-12-06 16:00:00 | IWM | ETF | 39.61 | 39.7 | 39.55 | 39.58 | 9000.0 |
| 2002-12-06 17:00:00 | IWM | ETF | 39.61 | 39.61 | 39.61 | 39.61 | 75600.0 |
| 2002-12-06 08:00:00 | DIA | ETF | 86.21 | 86.45 | 85.29 | 85.35 | 54900.0 |
| 2002-12-06 09:00:00 | DIA | ETF | 85.4 | 85.98 | 85.1 | 85.86 | 1196600.0 |
| 2002-12-06 10:00:00 | DIA | ETF | 85.9 | 86.51 | 85.65 | 86.09 | 2512400.0 |
| 2002-12-06 11:00:00 | DIA | ETF | 86.13 | 86.67 | 85.95 | 86.49 | 905400.0 |
| 2002-12-06 12:00:00 | DIA | ETF | 86.44 | 86.76 | 86.31 | 86.5 | 851000.0 |
| 2002-12-06 13:00:00 | DIA | ETF | 86.51 | 86.95 | 86.39 | 86.81 | 798100.0 |
| 2002-12-06 14:00:00 | DIA | ETF | 86.81 | 87.04 | 86.51 | 86.54 | 987100.0 |
| 2002-12-06 15:00:00 | DIA | ETF | 86.51 | 86.74 | 86.21 | 86.67 | 1316700.0 |
| 2002-12-06 16:00:00 | DIA | ETF | 86.67 | 86.91 | 86.2 | 86.9 | 166100.0 |
| 2002-12-06 17:00:00 | DIA | ETF | 86.9 | 86.9 | 86.9 | 86.9 | 400.0 |
| 2002-12-06 18:00:00 | DIA | ETF | 86.93 | 86.94 | 86.93 | 86.94 | 700.0 |
| 2002-12-06 08:00:00 | TLT | ETF | 87.2 | 87.2 | 87.2 | 87.2 | 1100.0 |
| 2002-12-06 09:00:00 | TLT | ETF | 87.23 | 87.23 | 86.66 | 86.66 | 91500.0 |
| 2002-12-06 10:00:00 | TLT | ETF | 86.69 | 86.69 | 85.76 | 85.98 | 31400.0 |
| 2002-12-06 11:00:00 | TLT | ETF | 86.1 | 86.18 | 85.92 | 86.13 | 179300.0 |
| 2002-12-06 12:00:00 | TLT | ETF | 85.96 | 86.11 | 85.76 | 85.95 | 37900.0 |
> showing 50 of 376 rows — these rows as CSV