PREVIEW / etf_1hour / 2003-02-12
file: by_date/etf_1hour/2003/2003-02-12.parquet size: 16 KB rows: 377
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-02-12 08:00:00 | SPY | ETF | 83.17 | 83.35 | 83.06 | 83.2 | 24000.0 |
| 2003-02-12 09:00:00 | SPY | ETF | 83.21 | 83.62 | 83.03 | 83.38 | 6031200.0 |
| 2003-02-12 10:00:00 | SPY | ETF | 83.4 | 83.58 | 82.75 | 82.95 | 6490400.0 |
| 2003-02-12 11:00:00 | SPY | ETF | 82.94 | 83.2 | 82.65 | 83.1 | 4573300.0 |
| 2003-02-12 12:00:00 | SPY | ETF | 83.11 | 83.13 | 82.76 | 82.9 | 1754200.0 |
| 2003-02-12 13:00:00 | SPY | ETF | 82.92 | 82.99 | 82.5 | 82.78 | 2918600.0 |
| 2003-02-12 14:00:00 | SPY | ETF | 82.78 | 82.94 | 82.46 | 82.48 | 3246200.0 |
| 2003-02-12 15:00:00 | SPY | ETF | 82.5 | 82.58 | 82.22 | 82.25 | 5267700.0 |
| 2003-02-12 16:00:00 | SPY | ETF | 82.23 | 82.68 | 81.96 | 82.2 | 1630500.0 |
| 2003-02-12 17:00:00 | SPY | ETF | 82.19 | 82.19 | 82.11 | 82.18 | 70500.0 |
| 2003-02-12 18:00:00 | SPY | ETF | 82.14 | 82.23 | 82.1 | 82.21 | 45500.0 |
| 2003-02-12 19:00:00 | SPY | ETF | 82.19 | 82.19 | 82.15 | 82.15 | 5900.0 |
| 2003-02-12 08:00:00 | QQQ | ETF | 24.02 | 24.14 | 24.0 | 24.1 | 49600.0 |
| 2003-02-12 09:00:00 | QQQ | ETF | 24.09 | 24.33 | 24.03 | 24.24 | 10183300.0 |
| 2003-02-12 10:00:00 | QQQ | ETF | 24.22 | 24.33 | 24.02 | 24.11 | 9679500.0 |
| 2003-02-12 11:00:00 | QQQ | ETF | 24.11 | 24.22 | 24.02 | 24.16 | 4821100.0 |
| 2003-02-12 12:00:00 | QQQ | ETF | 24.17 | 24.19 | 24.03 | 24.11 | 3284400.0 |
| 2003-02-12 13:00:00 | QQQ | ETF | 24.09 | 24.12 | 23.92 | 24.0 | 5399200.0 |
| 2003-02-12 14:00:00 | QQQ | ETF | 24.0 | 24.06 | 23.88 | 23.92 | 4731500.0 |
| 2003-02-12 15:00:00 | QQQ | ETF | 23.92 | 23.95 | 23.8 | 23.83 | 7543900.0 |
| 2003-02-12 16:00:00 | QQQ | ETF | 23.83 | 23.92 | 23.75 | 23.81 | 2195500.0 |
| 2003-02-12 17:00:00 | QQQ | ETF | 23.81 | 23.82 | 23.77 | 23.82 | 27900.0 |
| 2003-02-12 18:00:00 | QQQ | ETF | 23.81 | 23.84 | 23.77 | 23.79 | 49800.0 |
| 2003-02-12 19:00:00 | QQQ | ETF | 23.82 | 23.82 | 23.8 | 23.82 | 13000.0 |
| 2003-02-12 09:00:00 | IWM | ETF | 35.85 | 35.94 | 35.705 | 35.9 | 259000.0 |
| 2003-02-12 10:00:00 | IWM | ETF | 35.9 | 35.925 | 35.6 | 35.675 | 291400.0 |
| 2003-02-12 11:00:00 | IWM | ETF | 35.62 | 35.735 | 35.58 | 35.735 | 258200.0 |
| 2003-02-12 12:00:00 | IWM | ETF | 35.715 | 35.715 | 35.6 | 35.63 | 85400.0 |
| 2003-02-12 13:00:00 | IWM | ETF | 35.645 | 35.655 | 35.475 | 35.58 | 254600.0 |
| 2003-02-12 14:00:00 | IWM | ETF | 35.59 | 35.645 | 35.505 | 35.525 | 262000.0 |
| 2003-02-12 15:00:00 | IWM | ETF | 35.495 | 35.515 | 35.335 | 35.395 | 363600.0 |
| 2003-02-12 16:00:00 | IWM | ETF | 35.38 | 35.45 | 35.365 | 35.41 | 5452000.0 |
| 2003-02-12 18:00:00 | IWM | ETF | 35.41 | 35.41 | 35.41 | 35.41 | 84600.0 |
| 2003-02-12 08:00:00 | DIA | ETF | 78.57 | 78.62 | 78.54 | 78.54 | 2800.0 |
| 2003-02-12 09:00:00 | DIA | ETF | 78.5 | 78.84 | 78.32 | 78.64 | 839700.0 |
| 2003-02-12 10:00:00 | DIA | ETF | 78.65 | 78.81 | 78.1 | 78.27 | 1285700.0 |
| 2003-02-12 11:00:00 | DIA | ETF | 78.27 | 78.6 | 78.08 | 78.48 | 809600.0 |
| 2003-02-12 12:00:00 | DIA | ETF | 78.53 | 78.55 | 78.24 | 78.4 | 410200.0 |
| 2003-02-12 13:00:00 | DIA | ETF | 78.39 | 78.5 | 78.0 | 78.3 | 668200.0 |
| 2003-02-12 14:00:00 | DIA | ETF | 78.27 | 78.38 | 78.01 | 78.02 | 788500.0 |
| 2003-02-12 15:00:00 | DIA | ETF | 78.05 | 78.15 | 77.78 | 77.78 | 1333700.0 |
| 2003-02-12 16:00:00 | DIA | ETF | 77.8 | 77.88 | 77.68 | 77.82 | 148100.0 |
| 2003-02-12 17:00:00 | DIA | ETF | 77.75 | 77.75 | 77.75 | 77.75 | 101000.0 |
| 2003-02-12 18:00:00 | DIA | ETF | 77.75 | 77.83 | 77.75 | 77.79 | 2700.0 |
| 2003-02-12 09:00:00 | TLT | ETF | 87.8 | 87.9 | 87.67 | 87.75 | 4800.0 |
| 2003-02-12 10:00:00 | TLT | ETF | 87.75 | 87.99 | 87.75 | 87.95 | 3700.0 |
| 2003-02-12 11:00:00 | TLT | ETF | 87.95 | 88.03 | 87.85 | 87.85 | 3700.0 |
| 2003-02-12 12:00:00 | TLT | ETF | 87.76 | 87.86 | 87.73 | 87.86 | 24000.0 |
| 2003-02-12 13:00:00 | TLT | ETF | 87.86 | 88.03 | 87.86 | 87.92 | 23700.0 |
| 2003-02-12 14:00:00 | TLT | ETF | 87.92 | 88.0 | 87.92 | 87.99 | 31200.0 |
> showing 50 of 377 rows — these rows as CSV