PREVIEW / etf_1hour / 2002-12-10
file: by_date/etf_1hour/2002/2002-12-10.parquet size: 16 KB rows: 375
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-10 08:00:00 | SPY | ETF | 90.2 | 90.29 | 90.15 | 90.24 | 87200.0 |
| 2002-12-10 09:00:00 | SPY | ETF | 90.27 | 90.33 | 89.82 | 90.09 | 4442700.0 |
| 2002-12-10 10:00:00 | SPY | ETF | 90.09 | 90.38 | 89.76 | 90.02 | 6634800.0 |
| 2002-12-10 11:00:00 | SPY | ETF | 90.04 | 90.71 | 89.99 | 90.51 | 4200400.0 |
| 2002-12-10 12:00:00 | SPY | ETF | 90.51 | 90.55 | 90.21 | 90.44 | 2321900.0 |
| 2002-12-10 13:00:00 | SPY | ETF | 90.44 | 90.71 | 90.32 | 90.71 | 1766400.0 |
| 2002-12-10 14:00:00 | SPY | ETF | 90.75 | 90.84 | 90.4 | 90.48 | 4676700.0 |
| 2002-12-10 15:00:00 | SPY | ETF | 90.46 | 91.1 | 90.27 | 90.92 | 4994400.0 |
| 2002-12-10 16:00:00 | SPY | ETF | 90.96 | 91.09 | 90.7 | 90.79 | 1569600.0 |
| 2002-12-10 17:00:00 | SPY | ETF | 90.79 | 90.82 | 90.76 | 90.79 | 117400.0 |
| 2002-12-10 18:00:00 | SPY | ETF | 90.79 | 90.79 | 90.7 | 90.71 | 8900.0 |
| 2002-12-10 19:00:00 | SPY | ETF | 90.71 | 90.79 | 90.7 | 90.79 | 2600.0 |
| 2002-12-10 08:00:00 | QQQ | ETF | 25.4 | 25.45 | 25.38 | 25.43 | 85700.0 |
| 2002-12-10 09:00:00 | QQQ | ETF | 25.41 | 25.57 | 25.35 | 25.46 | 12013000.0 |
| 2002-12-10 10:00:00 | QQQ | ETF | 25.46 | 25.68 | 25.43 | 25.61 | 12395800.0 |
| 2002-12-10 11:00:00 | QQQ | ETF | 25.6 | 25.95 | 25.58 | 25.85 | 13435100.0 |
| 2002-12-10 12:00:00 | QQQ | ETF | 25.85 | 25.88 | 25.7 | 25.83 | 4597200.0 |
| 2002-12-10 13:00:00 | QQQ | ETF | 25.83 | 25.92 | 25.76 | 25.9 | 3272200.0 |
| 2002-12-10 14:00:00 | QQQ | ETF | 25.9 | 25.95 | 25.7 | 25.78 | 9238700.0 |
| 2002-12-10 15:00:00 | QQQ | ETF | 25.78 | 25.87 | 25.63 | 25.67 | 8836800.0 |
| 2002-12-10 16:00:00 | QQQ | ETF | 25.67 | 25.76 | 25.56 | 25.61 | 1678000.0 |
| 2002-12-10 17:00:00 | QQQ | ETF | 25.61 | 25.67 | 25.61 | 25.63 | 359500.0 |
| 2002-12-10 18:00:00 | QQQ | ETF | 25.62 | 25.67 | 25.59 | 25.64 | 42900.0 |
| 2002-12-10 19:00:00 | QQQ | ETF | 25.63 | 25.63 | 25.58 | 25.62 | 11800.0 |
| 2002-12-10 09:00:00 | IWM | ETF | 38.74 | 38.975 | 38.735 | 38.845 | 205600.0 |
| 2002-12-10 10:00:00 | IWM | ETF | 38.82 | 38.98 | 38.785 | 38.875 | 388600.0 |
| 2002-12-10 11:00:00 | IWM | ETF | 38.88 | 39.155 | 38.88 | 39.12 | 569200.0 |
| 2002-12-10 12:00:00 | IWM | ETF | 39.12 | 39.135 | 39.03 | 39.135 | 71000.0 |
| 2002-12-10 13:00:00 | IWM | ETF | 39.145 | 39.2 | 39.1 | 39.19 | 135400.0 |
| 2002-12-10 14:00:00 | IWM | ETF | 39.2 | 39.245 | 39.1 | 39.14 | 457400.0 |
| 2002-12-10 15:00:00 | IWM | ETF | 39.15 | 39.455 | 39.025 | 39.345 | 622600.0 |
| 2002-12-10 16:00:00 | IWM | ETF | 39.445 | 39.445 | 39.28 | 39.28 | 6200.0 |
| 2002-12-10 08:00:00 | DIA | ETF | 85.33 | 85.47 | 85.33 | 85.43 | 11200.0 |
| 2002-12-10 09:00:00 | DIA | ETF | 85.45 | 85.45 | 84.96 | 85.21 | 816200.0 |
| 2002-12-10 10:00:00 | DIA | ETF | 85.21 | 85.47 | 84.92 | 85.19 | 846500.0 |
| 2002-12-10 11:00:00 | DIA | ETF | 85.19 | 85.67 | 85.11 | 85.55 | 991900.0 |
| 2002-12-10 12:00:00 | DIA | ETF | 85.55 | 85.55 | 85.24 | 85.47 | 541000.0 |
| 2002-12-10 13:00:00 | DIA | ETF | 85.47 | 85.71 | 85.36 | 85.7 | 367700.0 |
| 2002-12-10 14:00:00 | DIA | ETF | 85.71 | 85.88 | 85.4 | 85.5 | 958300.0 |
| 2002-12-10 15:00:00 | DIA | ETF | 85.5 | 86.01 | 85.25 | 85.91 | 1100200.0 |
| 2002-12-10 16:00:00 | DIA | ETF | 85.91 | 85.97 | 85.71 | 85.8 | 71600.0 |
| 2002-12-10 18:00:00 | DIA | ETF | 85.88 | 85.88 | 85.88 | 85.88 | 100.0 |
| 2002-12-10 09:00:00 | TLT | ETF | 86.61 | 86.74 | 86.55 | 86.74 | 6100.0 |
| 2002-12-10 10:00:00 | TLT | ETF | 86.54 | 86.83 | 86.54 | 86.76 | 22300.0 |
| 2002-12-10 11:00:00 | TLT | ETF | 86.79 | 86.79 | 86.57 | 86.6 | 14000.0 |
| 2002-12-10 12:00:00 | TLT | ETF | 86.65 | 86.66 | 86.55 | 86.66 | 1300.0 |
| 2002-12-10 13:00:00 | TLT | ETF | 86.7 | 86.7 | 86.67 | 86.67 | 15500.0 |
| 2002-12-10 14:00:00 | TLT | ETF | 86.73 | 86.81 | 86.5 | 86.81 | 65100.0 |
| 2002-12-10 15:00:00 | TLT | ETF | 86.9 | 86.93 | 86.78 | 86.78 | 15200.0 |
| 2002-12-10 16:00:00 | TLT | ETF | 86.76 | 86.88 | 86.76 | 86.88 | 9100.0 |
> showing 50 of 375 rows — these rows as CSV