PREVIEW / etf_1hour / 2001-08-30
file: by_date/etf_1hour/2001/2001-08-30.parquet size: 12 KB rows: 240
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-08-30 09:00:00 | SPY | ETF | 114.85 | 115.74 | 114.85 | 115.54 | 1789700.0 |
| 2001-08-30 10:00:00 | SPY | ETF | 115.52 | 115.57 | 114.33 | 114.34 | 2470400.0 |
| 2001-08-30 11:00:00 | SPY | ETF | 114.32 | 114.44 | 113.07 | 113.55 | 3266600.0 |
| 2001-08-30 12:00:00 | SPY | ETF | 113.61 | 113.91 | 113.46 | 113.61 | 1493200.0 |
| 2001-08-30 13:00:00 | SPY | ETF | 113.61 | 113.8 | 113.28 | 113.33 | 801400.0 |
| 2001-08-30 14:00:00 | SPY | ETF | 113.34 | 113.58 | 112.93 | 113.52 | 1700700.0 |
| 2001-08-30 15:00:00 | SPY | ETF | 113.51 | 113.72 | 113.12 | 113.28 | 2037900.0 |
| 2001-08-30 16:00:00 | SPY | ETF | 113.28 | 113.44 | 113.16 | 113.32 | 1734500.0 |
| 2001-08-30 17:00:00 | SPY | ETF | 113.4 | 113.4 | 113.25 | 113.25 | 202500.0 |
| 2001-08-30 18:00:00 | SPY | ETF | 113.25 | 113.25 | 113.25 | 113.25 | 200.0 |
| 2001-08-30 09:00:00 | QQQ | ETF | 36.8 | 37.31 | 36.64 | 37.15 | 8437400.0 |
| 2001-08-30 10:00:00 | QQQ | ETF | 37.13 | 37.21 | 36.44 | 36.45 | 12015900.0 |
| 2001-08-30 11:00:00 | QQQ | ETF | 36.45 | 36.5 | 35.87 | 36.21 | 16925200.0 |
| 2001-08-30 12:00:00 | QQQ | ETF | 36.22 | 36.44 | 36.15 | 36.24 | 4592200.0 |
| 2001-08-30 13:00:00 | QQQ | ETF | 36.24 | 36.35 | 36.02 | 36.02 | 4822400.0 |
| 2001-08-30 14:00:00 | QQQ | ETF | 36.03 | 36.32 | 35.83 | 36.26 | 11442800.0 |
| 2001-08-30 15:00:00 | QQQ | ETF | 36.26 | 36.42 | 36.05 | 36.2 | 11927800.0 |
| 2001-08-30 16:00:00 | QQQ | ETF | 36.2 | 36.58 | 36.1 | 36.22 | 1640500.0 |
| 2001-08-30 17:00:00 | QQQ | ETF | 36.2 | 36.35 | 36.2 | 36.27 | 197200.0 |
| 2001-08-30 18:00:00 | QQQ | ETF | 36.27 | 36.32 | 36.19 | 36.2 | 21600.0 |
| 2001-08-30 09:00:00 | IWM | ETF | 46.9 | 47.025 | 46.9 | 47.025 | 21800.0 |
| 2001-08-30 10:00:00 | IWM | ETF | 47.1 | 47.1 | 46.805 | 46.805 | 152600.0 |
| 2001-08-30 11:00:00 | IWM | ETF | 46.705 | 46.75 | 46.41 | 46.53 | 448200.0 |
| 2001-08-30 12:00:00 | IWM | ETF | 46.53 | 46.725 | 46.53 | 46.615 | 57800.0 |
| 2001-08-30 13:00:00 | IWM | ETF | 46.575 | 46.715 | 46.53 | 46.53 | 77000.0 |
| 2001-08-30 14:00:00 | IWM | ETF | 46.53 | 46.625 | 46.305 | 46.625 | 78400.0 |
| 2001-08-30 15:00:00 | IWM | ETF | 46.645 | 46.65 | 46.38 | 46.555 | 83000.0 |
| 2001-08-30 09:00:00 | DIA | ETF | 100.54 | 101.42 | 100.54 | 101.22 | 543900.0 |
| 2001-08-30 10:00:00 | DIA | ETF | 101.17 | 101.28 | 100.19 | 100.21 | 872600.0 |
| 2001-08-30 11:00:00 | DIA | ETF | 100.2 | 100.34 | 99.15 | 99.6 | 1204900.0 |
| 2001-08-30 12:00:00 | DIA | ETF | 99.59 | 99.88 | 99.51 | 99.62 | 282800.0 |
| 2001-08-30 13:00:00 | DIA | ETF | 99.69 | 99.8 | 99.28 | 99.28 | 425900.0 |
| 2001-08-30 14:00:00 | DIA | ETF | 99.33 | 99.53 | 98.83 | 99.48 | 1047600.0 |
| 2001-08-30 15:00:00 | DIA | ETF | 99.48 | 99.69 | 99.05 | 99.34 | 682600.0 |
| 2001-08-30 16:00:00 | DIA | ETF | 99.33 | 99.4 | 99.26 | 99.26 | 161200.0 |
| 2001-08-30 17:00:00 | DIA | ETF | 99.31 | 99.31 | 99.25 | 99.25 | 200.0 |
| 2001-08-30 18:00:00 | DIA | ETF | 99.31 | 99.31 | 99.31 | 99.31 | 100.0 |
> showing 37 of 240 rows — these rows as CSV