PREVIEW / etf_1hour / 2003-03-17
file: by_date/etf_1hour/2003/2003-03-17.parquet size: 17 KB rows: 419
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-03-17 08:00:00 | SPY | ETF | 83.65 | 83.75 | 83.37 | 83.5 | 133100.0 |
| 2003-03-17 09:00:00 | SPY | ETF | 83.55 | 84.48 | 83.22 | 84.46 | 11059100.0 |
| 2003-03-17 10:00:00 | SPY | ETF | 84.46 | 86.5 | 83.25 | 85.72 | 19602000.0 |
| 2003-03-17 11:00:00 | SPY | ETF | 85.68 | 86.39 | 85.6 | 85.95 | 11480100.0 |
| 2003-03-17 12:00:00 | SPY | ETF | 85.88 | 86.37 | 85.7 | 86.11 | 6307700.0 |
| 2003-03-17 13:00:00 | SPY | ETF | 86.12 | 86.18 | 85.81 | 85.96 | 4849900.0 |
| 2003-03-17 14:00:00 | SPY | ETF | 85.96 | 86.56 | 85.91 | 86.48 | 8578400.0 |
| 2003-03-17 15:00:00 | SPY | ETF | 86.5 | 86.95 | 86.29 | 86.83 | 13441500.0 |
| 2003-03-17 16:00:00 | SPY | ETF | 86.82 | 86.91 | 86.4 | 86.79 | 6522900.0 |
| 2003-03-17 17:00:00 | SPY | ETF | 86.79 | 86.9 | 86.79 | 86.85 | 146300.0 |
| 2003-03-17 18:00:00 | SPY | ETF | 86.86 | 86.98 | 86.84 | 86.98 | 15800.0 |
| 2003-03-17 19:00:00 | SPY | ETF | 86.92 | 86.97 | 86.75 | 86.75 | 21200.0 |
| 2003-03-17 08:00:00 | QQQ | ETF | 25.53 | 25.55 | 25.43 | 25.45 | 121000.0 |
| 2003-03-17 09:00:00 | QQQ | ETF | 25.44 | 25.9 | 25.35 | 25.9 | 13579500.0 |
| 2003-03-17 10:00:00 | QQQ | ETF | 25.88 | 26.75 | 25.72 | 26.49 | 38482900.0 |
| 2003-03-17 11:00:00 | QQQ | ETF | 26.5 | 26.78 | 26.35 | 26.57 | 24935100.0 |
| 2003-03-17 12:00:00 | QQQ | ETF | 26.61 | 26.69 | 26.38 | 26.58 | 13926300.0 |
| 2003-03-17 13:00:00 | QQQ | ETF | 26.58 | 26.62 | 26.41 | 26.54 | 11368300.0 |
| 2003-03-17 14:00:00 | QQQ | ETF | 26.53 | 26.78 | 26.51 | 26.66 | 10222300.0 |
| 2003-03-17 15:00:00 | QQQ | ETF | 26.65 | 26.77 | 26.56 | 26.76 | 16830000.0 |
| 2003-03-17 16:00:00 | QQQ | ETF | 26.76 | 26.8 | 26.58 | 26.64 | 3585000.0 |
| 2003-03-17 17:00:00 | QQQ | ETF | 26.67 | 26.7 | 26.62 | 26.65 | 249600.0 |
| 2003-03-17 18:00:00 | QQQ | ETF | 26.66 | 26.68 | 26.61 | 26.68 | 77800.0 |
| 2003-03-17 19:00:00 | QQQ | ETF | 26.67 | 26.69 | 26.65 | 26.67 | 12900.0 |
| 2003-03-17 09:00:00 | IWM | ETF | 35.275 | 35.495 | 35.09 | 35.495 | 409000.0 |
| 2003-03-17 10:00:00 | IWM | ETF | 35.495 | 36.005 | 35.36 | 35.89 | 462800.0 |
| 2003-03-17 11:00:00 | IWM | ETF | 35.905 | 36.08 | 35.825 | 35.96 | 422600.0 |
| 2003-03-17 12:00:00 | IWM | ETF | 35.935 | 36.05 | 35.885 | 36.02 | 149600.0 |
| 2003-03-17 13:00:00 | IWM | ETF | 36.04 | 36.055 | 35.94 | 36.0 | 80000.0 |
| 2003-03-17 14:00:00 | IWM | ETF | 36.035 | 36.165 | 36.005 | 36.15 | 239600.0 |
| 2003-03-17 15:00:00 | IWM | ETF | 36.155 | 36.34 | 36.15 | 36.34 | 330000.0 |
| 2003-03-17 16:00:00 | IWM | ETF | 36.32 | 36.4 | 36.165 | 36.165 | 33400.0 |
| 2003-03-17 17:00:00 | IWM | ETF | 36.365 | 36.395 | 36.365 | 36.395 | 56200.0 |
| 2003-03-17 08:00:00 | DIA | ETF | 78.4 | 78.45 | 78.16 | 78.35 | 16200.0 |
| 2003-03-17 09:00:00 | DIA | ETF | 78.37 | 79.03 | 77.92 | 78.95 | 1323000.0 |
| 2003-03-17 10:00:00 | DIA | ETF | 78.95 | 80.9 | 78.56 | 80.54 | 4078600.0 |
| 2003-03-17 11:00:00 | DIA | ETF | 80.49 | 81.15 | 80.42 | 80.76 | 2515200.0 |
| 2003-03-17 12:00:00 | DIA | ETF | 80.75 | 81.2 | 80.58 | 80.9 | 1250100.0 |
| 2003-03-17 13:00:00 | DIA | ETF | 80.9 | 80.95 | 80.6 | 80.8 | 711100.0 |
| 2003-03-17 14:00:00 | DIA | ETF | 80.78 | 81.41 | 80.78 | 81.29 | 1258100.0 |
| 2003-03-17 15:00:00 | DIA | ETF | 81.3 | 81.75 | 81.14 | 81.64 | 2183800.0 |
| 2003-03-17 16:00:00 | DIA | ETF | 81.68 | 81.69 | 81.42 | 81.54 | 307400.0 |
| 2003-03-17 17:00:00 | DIA | ETF | 81.54 | 81.68 | 81.48 | 81.6 | 7600.0 |
| 2003-03-17 18:00:00 | DIA | ETF | 81.55 | 81.63 | 81.5 | 81.63 | 3400.0 |
| 2003-03-17 19:00:00 | DIA | ETF | 81.63 | 81.63 | 81.58 | 81.63 | 2100.0 |
| 2003-03-17 09:00:00 | TLT | ETF | 90.52 | 90.52 | 89.89 | 90.0 | 141300.0 |
| 2003-03-17 10:00:00 | TLT | ETF | 89.9 | 90.15 | 89.1 | 89.19 | 179700.0 |
| 2003-03-17 11:00:00 | TLT | ETF | 89.27 | 89.35 | 88.95 | 89.22 | 81600.0 |
| 2003-03-17 12:00:00 | TLT | ETF | 89.15 | 89.29 | 88.86 | 88.86 | 60200.0 |
| 2003-03-17 13:00:00 | TLT | ETF | 88.9 | 89.19 | 88.9 | 88.93 | 155400.0 |
> showing 50 of 419 rows — these rows as CSV