PREVIEW / etf_1hour / 2003-12-10
file: by_date/etf_1hour/2003/2003-12-10.parquet size: 19 KB rows: 503
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 |
|---|---|---|---|---|---|---|---|
| 2003-12-10 08:00:00 | SPY | ETF | 106.62 | 106.74 | 106.62 | 106.73 | 13300.0 |
| 2003-12-10 09:00:00 | SPY | ETF | 106.75 | 106.84 | 106.54 | 106.83 | 4234500.0 |
| 2003-12-10 10:00:00 | SPY | ETF | 106.84 | 106.98 | 106.54 | 106.56 | 4757900.0 |
| 2003-12-10 11:00:00 | SPY | ETF | 106.57 | 106.93 | 106.44 | 106.89 | 3499600.0 |
| 2003-12-10 12:00:00 | SPY | ETF | 106.9 | 106.92 | 106.68 | 106.69 | 1225100.0 |
| 2003-12-10 13:00:00 | SPY | ETF | 106.7 | 106.77 | 106.49 | 106.72 | 1698500.0 |
| 2003-12-10 14:00:00 | SPY | ETF | 106.72 | 106.74 | 106.03 | 106.19 | 3369400.0 |
| 2003-12-10 15:00:00 | SPY | ETF | 106.16 | 106.57 | 105.98 | 106.54 | 5313200.0 |
| 2003-12-10 16:00:00 | SPY | ETF | 106.52 | 106.78 | 106.49 | 106.75 | 4764400.0 |
| 2003-12-10 17:00:00 | SPY | ETF | 106.75 | 106.81 | 106.74 | 106.74 | 8500.0 |
| 2003-12-10 18:00:00 | SPY | ETF | 106.74 | 106.75 | 106.65 | 106.65 | 10700.0 |
| 2003-12-10 19:00:00 | SPY | ETF | 106.72 | 106.72 | 106.67 | 106.72 | 1200.0 |
| 2003-12-10 08:00:00 | QQQ | ETF | 34.45 | 34.5 | 34.42 | 34.48 | 326500.0 |
| 2003-12-10 09:00:00 | QQQ | ETF | 34.49 | 34.59 | 34.38 | 34.59 | 11206000.0 |
| 2003-12-10 10:00:00 | QQQ | ETF | 34.58 | 34.7 | 34.35 | 34.35 | 15592100.0 |
| 2003-12-10 11:00:00 | QQQ | ETF | 34.38 | 34.63 | 34.26 | 34.607 | 16208900.0 |
| 2003-12-10 12:00:00 | QQQ | ETF | 34.61 | 34.66 | 34.46 | 34.472 | 6065500.0 |
| 2003-12-10 13:00:00 | QQQ | ETF | 34.472 | 34.53 | 34.32 | 34.51 | 8037100.0 |
| 2003-12-10 14:00:00 | QQQ | ETF | 34.52 | 34.53 | 34.13 | 34.25 | 15122500.0 |
| 2003-12-10 15:00:00 | QQQ | ETF | 34.25 | 34.58 | 34.18 | 34.533 | 16249300.0 |
| 2003-12-10 16:00:00 | QQQ | ETF | 34.533 | 34.6 | 34.51 | 34.55 | 4886400.0 |
| 2003-12-10 17:00:00 | QQQ | ETF | 34.54 | 34.565 | 34.52 | 34.53 | 56300.0 |
| 2003-12-10 18:00:00 | QQQ | ETF | 34.556 | 34.574 | 34.53 | 34.56 | 41700.0 |
| 2003-12-10 19:00:00 | QQQ | ETF | 34.55 | 34.56 | 34.55 | 34.56 | 2900.0 |
| 2003-12-10 09:00:00 | IWM | ETF | 53.44 | 53.5 | 53.0 | 53.176 | 638400.0 |
| 2003-12-10 10:00:00 | IWM | ETF | 53.183 | 53.38 | 52.925 | 52.925 | 1158600.0 |
| 2003-12-10 11:00:00 | IWM | ETF | 53.0 | 53.17 | 52.85 | 53.145 | 1380800.0 |
| 2003-12-10 12:00:00 | IWM | ETF | 53.17 | 53.25 | 53.075 | 53.085 | 782400.0 |
| 2003-12-10 13:00:00 | IWM | ETF | 53.095 | 53.095 | 52.925 | 53.08 | 178800.0 |
| 2003-12-10 14:00:00 | IWM | ETF | 53.052 | 53.065 | 52.51 | 52.575 | 1912200.0 |
| 2003-12-10 15:00:00 | IWM | ETF | 52.568 | 52.88 | 52.445 | 52.78 | 2322200.0 |
| 2003-12-10 16:00:00 | IWM | ETF | 52.78 | 52.805 | 50.755 | 52.805 | 376800.0 |
| 2003-12-10 08:00:00 | DIA | ETF | 99.35 | 99.39 | 99.32 | 99.39 | 7500.0 |
| 2003-12-10 09:00:00 | DIA | ETF | 99.42 | 99.58 | 99.35 | 99.57 | 400200.0 |
| 2003-12-10 10:00:00 | DIA | ETF | 99.55 | 99.77 | 99.34 | 99.36 | 1314700.0 |
| 2003-12-10 11:00:00 | DIA | ETF | 99.36 | 99.74 | 99.29 | 99.72 | 414200.0 |
| 2003-12-10 12:00:00 | DIA | ETF | 99.71 | 99.72 | 99.51 | 99.55 | 310600.0 |
| 2003-12-10 13:00:00 | DIA | ETF | 99.55 | 99.63 | 99.4 | 99.55 | 288600.0 |
| 2003-12-10 14:00:00 | DIA | ETF | 99.54 | 99.58 | 99.0 | 99.14 | 799300.0 |
| 2003-12-10 15:00:00 | DIA | ETF | 99.16 | 99.44 | 98.98 | 99.39 | 1613000.0 |
| 2003-12-10 16:00:00 | DIA | ETF | 99.42 | 99.75 | 99.38 | 99.58 | 92500.0 |
| 2003-12-10 17:00:00 | DIA | ETF | 99.58 | 99.58 | 99.58 | 99.58 | 2500.0 |
| 2003-12-10 18:00:00 | DIA | ETF | 99.63 | 99.65 | 99.63 | 99.65 | 500.0 |
| 2003-12-10 09:00:00 | TLT | ETF | 84.91 | 85.1 | 84.91 | 84.93 | 202900.0 |
| 2003-12-10 10:00:00 | TLT | ETF | 84.99 | 85.06 | 84.9 | 84.9 | 105000.0 |
| 2003-12-10 11:00:00 | TLT | ETF | 84.99 | 84.99 | 84.78 | 84.79 | 60800.0 |
| 2003-12-10 12:00:00 | TLT | ETF | 84.78 | 84.83 | 84.66 | 84.66 | 32700.0 |
| 2003-12-10 13:00:00 | TLT | ETF | 84.73 | 84.73 | 84.55 | 84.6 | 29000.0 |
| 2003-12-10 14:00:00 | TLT | ETF | 84.65 | 84.8 | 84.65 | 84.77 | 18100.0 |
| 2003-12-10 15:00:00 | TLT | ETF | 84.78 | 84.88 | 84.75 | 84.77 | 67100.0 |
> showing 50 of 503 rows — these rows as CSV