PREVIEW / etf_1hour / 2003-10-03
file: by_date/etf_1hour/2003/2003-10-03.parquet size: 18 KB rows: 447
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-10-03 08:00:00 | SPY | ETF | 102.6 | 103.9 | 102.58 | 103.76 | 740900.0 |
| 2003-10-03 09:00:00 | SPY | ETF | 103.8 | 104.04 | 103.586 | 103.84 | 8734000.0 |
| 2003-10-03 10:00:00 | SPY | ETF | 103.83 | 104.0 | 103.43 | 103.8 | 9268700.0 |
| 2003-10-03 11:00:00 | SPY | ETF | 103.75 | 103.982 | 103.5 | 103.83 | 3288800.0 |
| 2003-10-03 12:00:00 | SPY | ETF | 103.82 | 104.25 | 103.77 | 104.2 | 3737200.0 |
| 2003-10-03 13:00:00 | SPY | ETF | 104.2 | 104.28 | 103.95 | 104.1 | 4199000.0 |
| 2003-10-03 14:00:00 | SPY | ETF | 104.08 | 104.2 | 103.58 | 103.76 | 3913600.0 |
| 2003-10-03 15:00:00 | SPY | ETF | 103.73 | 103.83 | 103.08 | 103.26 | 7406300.0 |
| 2003-10-03 16:00:00 | SPY | ETF | 103.27 | 103.49 | 103.18 | 103.49 | 1968200.0 |
| 2003-10-03 17:00:00 | SPY | ETF | 103.49 | 103.49 | 103.38 | 103.4 | 11400.0 |
| 2003-10-03 18:00:00 | SPY | ETF | 103.42 | 103.46 | 103.4 | 103.45 | 1700.0 |
| 2003-10-03 19:00:00 | SPY | ETF | 103.49 | 103.49 | 103.49 | 103.49 | 1700.0 |
| 2003-10-03 08:00:00 | QQQ | ETF | 33.34 | 33.96 | 33.3 | 33.85 | 988800.0 |
| 2003-10-03 09:00:00 | QQQ | ETF | 33.85 | 34.11 | 33.81 | 33.98 | 16770000.0 |
| 2003-10-03 10:00:00 | QQQ | ETF | 33.97 | 34.13 | 33.86 | 34.1 | 17556600.0 |
| 2003-10-03 11:00:00 | QQQ | ETF | 34.09 | 34.22 | 33.98 | 34.152 | 11590900.0 |
| 2003-10-03 12:00:00 | QQQ | ETF | 34.15 | 34.43 | 34.14 | 34.4 | 14656300.0 |
| 2003-10-03 13:00:00 | QQQ | ETF | 34.4 | 34.44 | 34.32 | 34.392 | 8775300.0 |
| 2003-10-03 14:00:00 | QQQ | ETF | 34.39 | 34.47 | 34.2 | 34.25 | 10806300.0 |
| 2003-10-03 15:00:00 | QQQ | ETF | 34.25 | 34.31 | 33.94 | 34.166 | 16472400.0 |
| 2003-10-03 16:00:00 | QQQ | ETF | 34.16 | 34.22 | 34.13 | 34.198 | 3197100.0 |
| 2003-10-03 17:00:00 | QQQ | ETF | 34.21 | 34.21 | 34.16 | 34.19 | 53500.0 |
| 2003-10-03 18:00:00 | QQQ | ETF | 34.19 | 34.22 | 34.15 | 34.16 | 21100.0 |
| 2003-10-03 19:00:00 | QQQ | ETF | 34.19 | 34.24 | 34.18 | 34.18 | 14700.0 |
| 2003-10-03 08:00:00 | IWM | ETF | 50.835 | 51.0 | 50.8 | 50.985 | 11000.0 |
| 2003-10-03 09:00:00 | IWM | ETF | 50.98 | 51.175 | 50.83 | 50.975 | 1939400.0 |
| 2003-10-03 10:00:00 | IWM | ETF | 51.02 | 51.155 | 50.83 | 51.055 | 965200.0 |
| 2003-10-03 11:00:00 | IWM | ETF | 51.04 | 51.125 | 50.935 | 51.055 | 256000.0 |
| 2003-10-03 12:00:00 | IWM | ETF | 51.055 | 51.35 | 51.05 | 51.275 | 340400.0 |
| 2003-10-03 13:00:00 | IWM | ETF | 51.275 | 51.285 | 51.135 | 51.165 | 565000.0 |
| 2003-10-03 14:00:00 | IWM | ETF | 51.155 | 51.275 | 51.025 | 51.07 | 464600.0 |
| 2003-10-03 15:00:00 | IWM | ETF | 51.068 | 51.12 | 50.75 | 51.07 | 1114200.0 |
| 2003-10-03 16:00:00 | IWM | ETF | 51.067 | 51.16 | 50.95 | 51.08 | 1853400.0 |
| 2003-10-03 08:00:00 | DIA | ETF | 95.32 | 96.4 | 95.32 | 96.36 | 46500.0 |
| 2003-10-03 09:00:00 | DIA | ETF | 96.36 | 96.5 | 96.18 | 96.35 | 1124200.0 |
| 2003-10-03 10:00:00 | DIA | ETF | 96.311 | 96.45 | 96.0 | 96.34 | 1285100.0 |
| 2003-10-03 11:00:00 | DIA | ETF | 96.33 | 96.44 | 96.13 | 96.31 | 571100.0 |
| 2003-10-03 12:00:00 | DIA | ETF | 96.3 | 96.78 | 96.29 | 96.74 | 668300.0 |
| 2003-10-03 13:00:00 | DIA | ETF | 96.73 | 96.86 | 96.49 | 96.62 | 501300.0 |
| 2003-10-03 14:00:00 | DIA | ETF | 96.62 | 96.67 | 96.17 | 96.3 | 435100.0 |
| 2003-10-03 15:00:00 | DIA | ETF | 96.24 | 96.35 | 95.7 | 95.92 | 1146500.0 |
| 2003-10-03 16:00:00 | DIA | ETF | 95.9 | 95.95 | 95.76 | 95.93 | 164900.0 |
| 2003-10-03 17:00:00 | DIA | ETF | 95.85 | 95.85 | 95.75 | 95.75 | 200.0 |
| 2003-10-03 18:00:00 | DIA | ETF | 95.8 | 95.8 | 95.8 | 95.8 | 100.0 |
| 2003-10-03 19:00:00 | DIA | ETF | 95.93 | 95.95 | 95.9 | 95.9 | 2700.0 |
| 2003-10-03 09:00:00 | TLT | ETF | 86.05 | 86.2 | 85.92 | 85.93 | 603800.0 |
| 2003-10-03 10:00:00 | TLT | ETF | 85.93 | 86.2 | 85.46 | 85.5 | 318600.0 |
| 2003-10-03 11:00:00 | TLT | ETF | 85.6 | 85.7 | 85.4 | 85.63 | 141500.0 |
| 2003-10-03 12:00:00 | TLT | ETF | 85.63 | 85.63 | 85.23 | 85.27 | 95700.0 |
| 2003-10-03 13:00:00 | TLT | ETF | 85.21 | 85.49 | 85.18 | 85.44 | 76800.0 |
> showing 50 of 447 rows — these rows as CSV