PREVIEW / etf_1hour / 2002-07-17
file: by_date/etf_1hour/2002/2002-07-17.parquet size: 14 KB rows: 319
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-07-17 09:00:00 | SPY | ETF | 92.46 | 93.3 | 92.21 | 92.5 | 5480000.0 |
| 2002-07-17 10:00:00 | SPY | ETF | 92.5 | 92.9 | 91.41 | 91.45 | 8331800.0 |
| 2002-07-17 11:00:00 | SPY | ETF | 91.38 | 91.7 | 90.86 | 91.0 | 6609700.0 |
| 2002-07-17 12:00:00 | SPY | ETF | 91.01 | 91.4 | 89.75 | 90.0 | 7464100.0 |
| 2002-07-17 13:00:00 | SPY | ETF | 90.0 | 91.1 | 89.8 | 90.86 | 4978800.0 |
| 2002-07-17 14:00:00 | SPY | ETF | 90.86 | 91.3 | 89.97 | 90.33 | 4983100.0 |
| 2002-07-17 15:00:00 | SPY | ETF | 90.33 | 91.45 | 90.1 | 91.0 | 6523000.0 |
| 2002-07-17 16:00:00 | SPY | ETF | 90.96 | 91.1 | 90.7 | 90.74 | 1222500.0 |
| 2002-07-17 09:00:00 | QQQ | ETF | 26.07 | 26.44 | 26.0 | 26.1 | 26026100.0 |
| 2002-07-17 10:00:00 | QQQ | ETF | 26.1 | 26.28 | 25.7 | 25.75 | 25948400.0 |
| 2002-07-17 11:00:00 | QQQ | ETF | 25.75 | 25.95 | 25.61 | 25.76 | 18223200.0 |
| 2002-07-17 12:00:00 | QQQ | ETF | 25.8 | 25.89 | 24.89 | 25.06 | 20002700.0 |
| 2002-07-17 13:00:00 | QQQ | ETF | 25.06 | 25.54 | 25.0 | 25.4 | 16149700.0 |
| 2002-07-17 14:00:00 | QQQ | ETF | 25.4 | 25.59 | 25.11 | 25.27 | 15703400.0 |
| 2002-07-17 15:00:00 | QQQ | ETF | 25.28 | 25.78 | 25.19 | 25.54 | 24438100.0 |
| 2002-07-17 16:00:00 | QQQ | ETF | 25.55 | 25.7 | 25.5 | 25.65 | 1469600.0 |
| 2002-07-17 09:00:00 | IWM | ETF | 41.495 | 41.5 | 41.175 | 41.175 | 347000.0 |
| 2002-07-17 10:00:00 | IWM | ETF | 41.2 | 41.475 | 40.9 | 40.93 | 819600.0 |
| 2002-07-17 11:00:00 | IWM | ETF | 40.93 | 40.94 | 40.6 | 40.63 | 363800.0 |
| 2002-07-17 12:00:00 | IWM | ETF | 40.62 | 40.665 | 40.075 | 40.1 | 278000.0 |
| 2002-07-17 13:00:00 | IWM | ETF | 40.07 | 40.49 | 40.06 | 40.475 | 291600.0 |
| 2002-07-17 14:00:00 | IWM | ETF | 40.475 | 40.68 | 40.365 | 40.365 | 241800.0 |
| 2002-07-17 15:00:00 | IWM | ETF | 40.45 | 40.875 | 40.39 | 40.75 | 281600.0 |
| 2002-07-17 16:00:00 | IWM | ETF | 40.875 | 40.875 | 40.875 | 40.875 | 11000.0 |
| 2002-07-17 09:00:00 | DIA | ETF | 86.62 | 87.5 | 86.56 | 86.77 | 1568200.0 |
| 2002-07-17 10:00:00 | DIA | ETF | 86.79 | 87.22 | 85.91 | 85.91 | 1572500.0 |
| 2002-07-17 11:00:00 | DIA | ETF | 85.91 | 86.15 | 85.4 | 85.65 | 1124100.0 |
| 2002-07-17 12:00:00 | DIA | ETF | 85.66 | 86.0 | 84.55 | 84.65 | 1227600.0 |
| 2002-07-17 13:00:00 | DIA | ETF | 84.84 | 85.9 | 84.69 | 85.72 | 1245000.0 |
| 2002-07-17 14:00:00 | DIA | ETF | 85.65 | 86.0 | 84.74 | 84.99 | 736300.0 |
| 2002-07-17 15:00:00 | DIA | ETF | 85.15 | 86.08 | 84.84 | 85.6 | 1326100.0 |
| 2002-07-17 16:00:00 | DIA | ETF | 85.6 | 85.7 | 85.42 | 85.46 | 94900.0 |
> showing 32 of 319 rows — these rows as CSV