PREVIEW / etf_1hour / 2002-12-03
file: by_date/etf_1hour/2002/2002-12-03.parquet size: 16 KB rows: 393
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 |
|---|---|---|---|---|---|---|---|
| 2002-12-03 08:00:00 | SPY | ETF | 93.99 | 93.99 | 93.38 | 93.38 | 86900.0 |
| 2002-12-03 09:00:00 | SPY | ETF | 93.35 | 93.4 | 92.95 | 93.0 | 3670100.0 |
| 2002-12-03 10:00:00 | SPY | ETF | 92.96 | 93.33 | 92.7 | 92.99 | 4273800.0 |
| 2002-12-03 11:00:00 | SPY | ETF | 92.98 | 93.17 | 92.42 | 92.57 | 3435300.0 |
| 2002-12-03 12:00:00 | SPY | ETF | 92.54 | 92.85 | 92.35 | 92.67 | 4378000.0 |
| 2002-12-03 13:00:00 | SPY | ETF | 92.65 | 92.99 | 92.53 | 92.62 | 3290900.0 |
| 2002-12-03 14:00:00 | SPY | ETF | 92.61 | 93.13 | 92.5 | 92.89 | 4406900.0 |
| 2002-12-03 15:00:00 | SPY | ETF | 92.84 | 93.19 | 92.44 | 92.55 | 7040700.0 |
| 2002-12-03 16:00:00 | SPY | ETF | 92.57 | 92.95 | 92.51 | 92.85 | 2277600.0 |
| 2002-12-03 17:00:00 | SPY | ETF | 92.82 | 92.82 | 92.58 | 92.63 | 176000.0 |
| 2002-12-03 18:00:00 | SPY | ETF | 92.61 | 92.61 | 92.53 | 92.55 | 21200.0 |
| 2002-12-03 19:00:00 | SPY | ETF | 92.6 | 92.6 | 92.6 | 92.6 | 100.0 |
| 2002-12-03 08:00:00 | QQQ | ETF | 27.9 | 27.92 | 27.6 | 27.6 | 74300.0 |
| 2002-12-03 09:00:00 | QQQ | ETF | 27.6 | 27.63 | 27.25 | 27.27 | 10722700.0 |
| 2002-12-03 10:00:00 | QQQ | ETF | 27.27 | 27.38 | 27.07 | 27.2 | 13473800.0 |
| 2002-12-03 11:00:00 | QQQ | ETF | 27.2 | 27.28 | 27.02 | 27.09 | 9656700.0 |
| 2002-12-03 12:00:00 | QQQ | ETF | 27.1 | 27.17 | 26.93 | 27.08 | 8159200.0 |
| 2002-12-03 13:00:00 | QQQ | ETF | 27.08 | 27.33 | 27.05 | 27.13 | 8465200.0 |
| 2002-12-03 14:00:00 | QQQ | ETF | 27.13 | 27.31 | 27.05 | 27.22 | 7793400.0 |
| 2002-12-03 15:00:00 | QQQ | ETF | 27.19 | 27.37 | 27.01 | 27.08 | 11835100.0 |
| 2002-12-03 16:00:00 | QQQ | ETF | 27.07 | 27.2 | 27.05 | 27.09 | 1276500.0 |
| 2002-12-03 17:00:00 | QQQ | ETF | 27.09 | 27.1 | 26.98 | 27.03 | 921200.0 |
| 2002-12-03 18:00:00 | QQQ | ETF | 27.03 | 27.04 | 26.96 | 26.98 | 60000.0 |
| 2002-12-03 19:00:00 | QQQ | ETF | 27.0 | 27.0 | 26.94 | 26.94 | 22300.0 |
| 2002-12-03 09:00:00 | IWM | ETF | 40.45 | 40.595 | 40.28 | 40.28 | 347400.0 |
| 2002-12-03 10:00:00 | IWM | ETF | 40.24 | 40.34 | 40.105 | 40.22 | 544000.0 |
| 2002-12-03 11:00:00 | IWM | ETF | 40.23 | 40.32 | 40.07 | 40.15 | 308200.0 |
| 2002-12-03 12:00:00 | IWM | ETF | 40.115 | 40.155 | 40.025 | 40.11 | 192600.0 |
| 2002-12-03 13:00:00 | IWM | ETF | 40.105 | 40.22 | 40.085 | 40.085 | 122400.0 |
| 2002-12-03 14:00:00 | IWM | ETF | 40.125 | 40.4 | 40.055 | 40.35 | 343800.0 |
| 2002-12-03 15:00:00 | IWM | ETF | 40.35 | 40.495 | 39.965 | 40.115 | 473200.0 |
| 2002-12-03 16:00:00 | IWM | ETF | 40.09 | 40.13 | 39.99 | 40.035 | 275800.0 |
| 2002-12-03 08:00:00 | DIA | ETF | 88.84 | 88.84 | 87.9 | 88.31 | 14100.0 |
| 2002-12-03 09:00:00 | DIA | ETF | 88.31 | 88.39 | 87.88 | 88.01 | 992000.0 |
| 2002-12-03 10:00:00 | DIA | ETF | 88.0 | 88.34 | 87.7 | 87.99 | 1034600.0 |
| 2002-12-03 11:00:00 | DIA | ETF | 87.99 | 88.19 | 87.52 | 87.63 | 788300.0 |
| 2002-12-03 12:00:00 | DIA | ETF | 87.64 | 87.94 | 87.41 | 87.75 | 844800.0 |
| 2002-12-03 13:00:00 | DIA | ETF | 87.78 | 88.08 | 87.63 | 87.71 | 424800.0 |
| 2002-12-03 14:00:00 | DIA | ETF | 87.72 | 88.15 | 87.58 | 87.95 | 991800.0 |
| 2002-12-03 15:00:00 | DIA | ETF | 87.95 | 88.28 | 87.46 | 87.64 | 1266400.0 |
| 2002-12-03 16:00:00 | DIA | ETF | 87.64 | 88.0 | 87.6 | 87.75 | 114700.0 |
| 2002-12-03 17:00:00 | DIA | ETF | 87.88 | 87.88 | 87.75 | 87.75 | 25100.0 |
| 2002-12-03 18:00:00 | DIA | ETF | 87.71 | 87.71 | 87.55 | 87.55 | 4400.0 |
| 2002-12-03 09:00:00 | TLT | ETF | 85.7 | 85.7 | 85.57 | 85.62 | 34500.0 |
| 2002-12-03 10:00:00 | TLT | ETF | 85.61 | 85.61 | 85.45 | 85.51 | 42600.0 |
| 2002-12-03 11:00:00 | TLT | ETF | 85.45 | 85.56 | 85.3 | 85.54 | 3900.0 |
| 2002-12-03 12:00:00 | TLT | ETF | 85.55 | 85.58 | 85.52 | 85.52 | 3900.0 |
| 2002-12-03 13:00:00 | TLT | ETF | 85.54 | 85.58 | 85.45 | 85.45 | 8900.0 |
| 2002-12-03 14:00:00 | TLT | ETF | 85.48 | 85.48 | 85.14 | 85.19 | 2300.0 |
| 2002-12-03 15:00:00 | TLT | ETF | 85.22 | 85.42 | 85.12 | 85.42 | 6500.0 |
> showing 50 of 393 rows — these rows as CSV