PREVIEW / etf_1hour / 2001-05-18
file: by_date/etf_1hour/2001/2001-05-18.parquet size: 11 KB rows: 226
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-18 09:00:00 | SPY | ETF | 129.09 | 129.39 | 128.92 | 129.21 | 1062000.0 |
| 2001-05-18 10:00:00 | SPY | ETF | 129.2 | 129.72 | 128.87 | 129.43 | 1268500.0 |
| 2001-05-18 11:00:00 | SPY | ETF | 129.4 | 129.49 | 128.9 | 129.0 | 404500.0 |
| 2001-05-18 12:00:00 | SPY | ETF | 128.97 | 129.17 | 128.69 | 128.78 | 595900.0 |
| 2001-05-18 13:00:00 | SPY | ETF | 128.83 | 128.97 | 128.54 | 128.65 | 525400.0 |
| 2001-05-18 14:00:00 | SPY | ETF | 128.61 | 128.9 | 128.5 | 128.87 | 747800.0 |
| 2001-05-18 15:00:00 | SPY | ETF | 128.84 | 129.67 | 128.75 | 129.62 | 1289300.0 |
| 2001-05-18 16:00:00 | SPY | ETF | 129.6 | 130.55 | 129.52 | 129.74 | 646400.0 |
| 2001-05-18 17:00:00 | SPY | ETF | 129.51 | 129.54 | 128.78 | 129.41 | 900.0 |
| 2001-05-18 09:00:00 | QQQ | ETF | 47.64 | 47.94 | 47.25 | 47.89 | 6959400.0 |
| 2001-05-18 10:00:00 | QQQ | ETF | 47.86 | 48.38 | 47.6 | 48.06 | 10412800.0 |
| 2001-05-18 11:00:00 | QQQ | ETF | 47.95 | 48.2 | 47.6 | 47.7 | 3398500.0 |
| 2001-05-18 12:00:00 | QQQ | ETF | 47.7 | 47.9 | 47.56 | 47.6 | 3079700.0 |
| 2001-05-18 13:00:00 | QQQ | ETF | 47.63 | 47.8 | 47.33 | 47.53 | 3414000.0 |
| 2001-05-18 14:00:00 | QQQ | ETF | 47.51 | 47.81 | 47.4 | 47.7 | 3771500.0 |
| 2001-05-18 15:00:00 | QQQ | ETF | 47.7 | 48.15 | 47.58 | 48.1 | 6834500.0 |
| 2001-05-18 16:00:00 | QQQ | ETF | 48.1 | 48.14 | 47.97 | 48.04 | 2046800.0 |
| 2001-05-18 17:00:00 | QQQ | ETF | 48.01 | 48.05 | 47.96 | 48.02 | 32200.0 |
| 2001-05-18 18:00:00 | QQQ | ETF | 48.0 | 48.03 | 47.95 | 48.03 | 3400.0 |
| 2001-05-18 09:00:00 | IWM | ETF | 50.125 | 50.32 | 50.125 | 50.32 | 22200.0 |
| 2001-05-18 10:00:00 | IWM | ETF | 50.35 | 50.575 | 50.24 | 50.425 | 32000.0 |
| 2001-05-18 11:00:00 | IWM | ETF | 50.395 | 50.475 | 50.29 | 50.45 | 25600.0 |
| 2001-05-18 12:00:00 | IWM | ETF | 50.475 | 50.475 | 50.29 | 50.445 | 5200.0 |
| 2001-05-18 13:00:00 | IWM | ETF | 50.44 | 50.44 | 50.15 | 50.155 | 40400.0 |
| 2001-05-18 14:00:00 | IWM | ETF | 50.325 | 50.475 | 50.15 | 50.445 | 33400.0 |
| 2001-05-18 15:00:00 | IWM | ETF | 50.445 | 50.675 | 50.33 | 50.54 | 129800.0 |
| 2001-05-18 16:00:00 | IWM | ETF | 50.5 | 50.575 | 50.5 | 50.575 | 16200.0 |
| 2001-05-18 09:00:00 | DIA | ETF | 112.55 | 112.85 | 112.4 | 112.61 | 373800.0 |
| 2001-05-18 10:00:00 | DIA | ETF | 112.6 | 112.86 | 112.16 | 112.52 | 555100.0 |
| 2001-05-18 11:00:00 | DIA | ETF | 112.6 | 112.72 | 112.16 | 112.22 | 386700.0 |
| 2001-05-18 12:00:00 | DIA | ETF | 112.25 | 112.43 | 112.06 | 112.12 | 365800.0 |
| 2001-05-18 13:00:00 | DIA | ETF | 112.15 | 112.34 | 112.06 | 112.25 | 134000.0 |
| 2001-05-18 14:00:00 | DIA | ETF | 112.11 | 112.4 | 112.07 | 112.32 | 248800.0 |
| 2001-05-18 15:00:00 | DIA | ETF | 112.23 | 113.09 | 112.14 | 113.04 | 1433500.0 |
| 2001-05-18 16:00:00 | DIA | ETF | 113.03 | 113.17 | 112.63 | 113.13 | 208800.0 |
> showing 35 of 226 rows — these rows as CSV