PREVIEW / etf_1hour / 2003-12-12
file: by_date/etf_1hour/2003/2003-12-12.parquet size: 19 KB rows: 507
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-12 08:00:00 | SPY | ETF | 108.02 | 108.18 | 107.93 | 108.1 | 50200.0 |
| 2003-12-12 09:00:00 | SPY | ETF | 108.1 | 108.1 | 107.45 | 107.49 | 5738000.0 |
| 2003-12-12 10:00:00 | SPY | ETF | 107.49 | 107.8 | 107.39 | 107.63 | 5430500.0 |
| 2003-12-12 11:00:00 | SPY | ETF | 107.63 | 107.9 | 107.55 | 107.76 | 5452600.0 |
| 2003-12-12 12:00:00 | SPY | ETF | 107.75 | 108.04 | 107.7 | 107.78 | 4753600.0 |
| 2003-12-12 13:00:00 | SPY | ETF | 107.79 | 107.94 | 107.7 | 107.75 | 1443300.0 |
| 2003-12-12 14:00:00 | SPY | ETF | 107.74 | 107.97 | 107.61 | 107.9 | 1655100.0 |
| 2003-12-12 15:00:00 | SPY | ETF | 107.91 | 108.2 | 107.86 | 108.13 | 5705900.0 |
| 2003-12-12 16:00:00 | SPY | ETF | 108.12 | 108.16 | 107.95 | 107.98 | 1517800.0 |
| 2003-12-12 17:00:00 | SPY | ETF | 108.03 | 108.1 | 108.01 | 108.01 | 1700.0 |
| 2003-12-12 18:00:00 | SPY | ETF | 108.01 | 108.01 | 108.0 | 108.0 | 1000.0 |
| 2003-12-12 19:00:00 | SPY | ETF | 108.01 | 108.05 | 108.01 | 108.05 | 400.0 |
| 2003-12-12 08:00:00 | QQQ | ETF | 35.29 | 35.42 | 35.29 | 35.38 | 118300.0 |
| 2003-12-12 09:00:00 | QQQ | ETF | 35.38 | 35.38 | 35.0 | 35.0 | 12025600.0 |
| 2003-12-12 10:00:00 | QQQ | ETF | 35.0 | 35.132 | 34.93 | 35.001 | 12711600.0 |
| 2003-12-12 11:00:00 | QQQ | ETF | 35.0 | 35.15 | 34.92 | 35.05 | 8839400.0 |
| 2003-12-12 12:00:00 | QQQ | ETF | 35.08 | 35.16 | 34.97 | 35.0 | 5727500.0 |
| 2003-12-12 13:00:00 | QQQ | ETF | 35.0 | 35.1 | 34.95 | 34.98 | 3985800.0 |
| 2003-12-12 14:00:00 | QQQ | ETF | 34.97 | 35.12 | 34.92 | 35.09 | 7129400.0 |
| 2003-12-12 15:00:00 | QQQ | ETF | 35.09 | 35.29 | 35.06 | 35.23 | 13466500.0 |
| 2003-12-12 16:00:00 | QQQ | ETF | 35.23 | 35.29 | 35.08 | 35.221 | 2482700.0 |
| 2003-12-12 17:00:00 | QQQ | ETF | 35.24 | 35.25 | 35.22 | 35.25 | 21000.0 |
| 2003-12-12 18:00:00 | QQQ | ETF | 35.25 | 35.27 | 35.23 | 35.23 | 20600.0 |
| 2003-12-12 19:00:00 | QQQ | ETF | 35.23 | 35.28 | 35.23 | 35.28 | 4400.0 |
| 2003-12-12 08:00:00 | IWM | ETF | 54.18 | 54.255 | 54.18 | 54.255 | 14000.0 |
| 2003-12-12 09:00:00 | IWM | ETF | 54.181 | 54.365 | 53.85 | 53.855 | 1361600.0 |
| 2003-12-12 10:00:00 | IWM | ETF | 53.85 | 54.2 | 53.77 | 54.055 | 1851200.0 |
| 2003-12-12 11:00:00 | IWM | ETF | 54.095 | 54.445 | 54.015 | 54.1845 | 851000.0 |
| 2003-12-12 12:00:00 | IWM | ETF | 54.165 | 54.375 | 54.145 | 54.185 | 123400.0 |
| 2003-12-12 13:00:00 | IWM | ETF | 54.185 | 54.225 | 54.05 | 54.095 | 590800.0 |
| 2003-12-12 14:00:00 | IWM | ETF | 54.095 | 54.1645 | 54.015 | 54.09 | 360200.0 |
| 2003-12-12 15:00:00 | IWM | ETF | 54.08 | 54.479 | 54.075 | 54.465 | 2890600.0 |
| 2003-12-12 16:00:00 | IWM | ETF | 54.455 | 54.495 | 54.4 | 54.48 | 256600.0 |
| 2003-12-12 08:00:00 | DIA | ETF | 100.4 | 100.54 | 100.39 | 100.48 | 23900.0 |
| 2003-12-12 09:00:00 | DIA | ETF | 100.48 | 100.48 | 99.966 | 100.0 | 793900.0 |
| 2003-12-12 10:00:00 | DIA | ETF | 100.0 | 100.43 | 99.93 | 100.22 | 1689700.0 |
| 2003-12-12 11:00:00 | DIA | ETF | 100.22 | 100.38 | 100.13 | 100.29 | 757800.0 |
| 2003-12-12 12:00:00 | DIA | ETF | 100.3 | 100.56 | 100.29 | 100.43 | 667500.0 |
| 2003-12-12 13:00:00 | DIA | ETF | 100.44 | 100.51 | 100.33 | 100.35 | 404500.0 |
| 2003-12-12 14:00:00 | DIA | ETF | 100.35 | 100.51 | 100.25 | 100.46 | 532700.0 |
| 2003-12-12 15:00:00 | DIA | ETF | 100.45 | 100.77 | 100.43 | 100.63 | 878500.0 |
| 2003-12-12 16:00:00 | DIA | ETF | 100.65 | 100.67 | 100.54 | 100.54 | 357100.0 |
| 2003-12-12 17:00:00 | DIA | ETF | 100.6 | 100.6 | 100.6 | 100.6 | 500.0 |
| 2003-12-12 19:00:00 | DIA | ETF | 100.56 | 100.63 | 100.56 | 100.63 | 300.0 |
| 2003-12-12 09:00:00 | TLT | ETF | 85.42 | 85.8 | 85.42 | 85.79 | 94300.0 |
| 2003-12-12 10:00:00 | TLT | ETF | 85.75 | 85.88 | 85.68 | 85.7 | 69600.0 |
| 2003-12-12 11:00:00 | TLT | ETF | 85.66 | 85.75 | 85.59 | 85.75 | 16400.0 |
| 2003-12-12 12:00:00 | TLT | ETF | 85.75 | 85.8 | 85.6 | 85.65 | 56100.0 |
| 2003-12-12 13:00:00 | TLT | ETF | 85.59 | 85.75 | 85.59 | 85.75 | 13300.0 |
| 2003-12-12 14:00:00 | TLT | ETF | 85.81 | 85.85 | 85.53 | 85.59 | 76900.0 |
> showing 50 of 507 rows — these rows as CSV