PREVIEW / etf_1hour / 2001-05-29
file: by_date/etf_1hour/2001/2001-05-29.parquet size: 12 KB rows: 232
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 |
|---|---|---|---|---|---|---|---|
| 2001-05-29 09:00:00 | SPY | ETF | 128.22 | 128.34 | 127.84 | 127.99 | 1358100.0 |
| 2001-05-29 10:00:00 | SPY | ETF | 127.99 | 128.3 | 127.31 | 127.73 | 1763000.0 |
| 2001-05-29 11:00:00 | SPY | ETF | 127.74 | 127.89 | 127.48 | 127.59 | 855800.0 |
| 2001-05-29 12:00:00 | SPY | ETF | 127.69 | 127.79 | 127.15 | 127.51 | 457700.0 |
| 2001-05-29 13:00:00 | SPY | ETF | 127.53 | 127.63 | 126.9 | 127.29 | 1359300.0 |
| 2001-05-29 14:00:00 | SPY | ETF | 127.21 | 127.53 | 127.06 | 127.45 | 616900.0 |
| 2001-05-29 15:00:00 | SPY | ETF | 127.38 | 127.63 | 127.07 | 127.3 | 1095600.0 |
| 2001-05-29 16:00:00 | SPY | ETF | 127.26 | 127.4 | 127.0 | 127.0 | 658100.0 |
| 2001-05-29 17:00:00 | SPY | ETF | 126.85 | 126.85 | 126.82 | 126.85 | 11800.0 |
| 2001-05-29 09:00:00 | QQQ | ETF | 48.5 | 48.5 | 47.67 | 47.82 | 7870400.0 |
| 2001-05-29 10:00:00 | QQQ | ETF | 47.85 | 48.2 | 47.16 | 47.45 | 15323500.0 |
| 2001-05-29 11:00:00 | QQQ | ETF | 47.45 | 47.64 | 47.23 | 47.38 | 5688900.0 |
| 2001-05-29 12:00:00 | QQQ | ETF | 47.38 | 47.44 | 47.0 | 47.07 | 4247300.0 |
| 2001-05-29 13:00:00 | QQQ | ETF | 47.08 | 47.15 | 46.5 | 46.75 | 7894800.0 |
| 2001-05-29 14:00:00 | QQQ | ETF | 46.75 | 46.88 | 46.45 | 46.88 | 8922800.0 |
| 2001-05-29 15:00:00 | QQQ | ETF | 46.83 | 47.0 | 46.54 | 46.7 | 10834000.0 |
| 2001-05-29 16:00:00 | QQQ | ETF | 46.7 | 46.73 | 46.08 | 46.2 | 2894700.0 |
| 2001-05-29 17:00:00 | QQQ | ETF | 46.2 | 46.25 | 46.02 | 46.04 | 107300.0 |
| 2001-05-29 18:00:00 | QQQ | ETF | 46.08 | 46.1 | 46.04 | 46.1 | 6300.0 |
| 2001-05-29 09:00:00 | IWM | ETF | 50.75 | 50.75 | 50.6 | 50.6 | 19600.0 |
| 2001-05-29 10:00:00 | IWM | ETF | 50.6 | 50.625 | 50.3 | 50.445 | 210200.0 |
| 2001-05-29 11:00:00 | IWM | ETF | 50.425 | 50.52 | 50.375 | 50.4 | 67000.0 |
| 2001-05-29 12:00:00 | IWM | ETF | 50.35 | 50.385 | 50.26 | 50.3 | 72600.0 |
| 2001-05-29 13:00:00 | IWM | ETF | 50.325 | 50.35 | 50.1 | 50.13 | 86400.0 |
| 2001-05-29 14:00:00 | IWM | ETF | 50.15 | 50.2 | 50.1 | 50.2 | 48200.0 |
| 2001-05-29 15:00:00 | IWM | ETF | 50.175 | 50.25 | 50.075 | 50.125 | 140800.0 |
| 2001-05-29 16:00:00 | IWM | ETF | 50.09 | 50.225 | 50.0 | 50.0 | 100600.0 |
| 2001-05-29 09:00:00 | DIA | ETF | 110.45 | 110.64 | 110.3 | 110.44 | 373600.0 |
| 2001-05-29 10:00:00 | DIA | ETF | 110.45 | 110.8 | 110.06 | 110.55 | 562400.0 |
| 2001-05-29 11:00:00 | DIA | ETF | 110.6 | 110.7 | 110.31 | 110.35 | 240400.0 |
| 2001-05-29 12:00:00 | DIA | ETF | 110.55 | 110.59 | 110.17 | 110.23 | 106900.0 |
| 2001-05-29 13:00:00 | DIA | ETF | 110.32 | 110.38 | 109.76 | 110.05 | 230900.0 |
| 2001-05-29 14:00:00 | DIA | ETF | 110.08 | 110.25 | 109.88 | 110.24 | 112800.0 |
| 2001-05-29 15:00:00 | DIA | ETF | 110.19 | 110.64 | 110.19 | 110.5 | 287000.0 |
| 2001-05-29 16:00:00 | DIA | ETF | 110.5 | 110.6 | 110.35 | 110.5 | 115000.0 |
> showing 35 of 232 rows — these rows as CSV