PREVIEW / etf_1hour / 2001-02-20
file: by_date/etf_1hour/2001/2001-02-20.parquet size: 11 KB rows: 211
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-02-20 09:00:00 | SPY | ETF | 131.04 | 131.14 | 130.48 | 130.55 | 692000.0 |
| 2001-02-20 10:00:00 | SPY | ETF | 130.51 | 130.96 | 129.93 | 130.05 | 587400.0 |
| 2001-02-20 11:00:00 | SPY | ETF | 130.01 | 130.1 | 129.06 | 129.5 | 850600.0 |
| 2001-02-20 12:00:00 | SPY | ETF | 129.5 | 129.75 | 129.05 | 129.31 | 482500.0 |
| 2001-02-20 13:00:00 | SPY | ETF | 129.31 | 129.53 | 129.0 | 129.38 | 766800.0 |
| 2001-02-20 14:00:00 | SPY | ETF | 129.4 | 129.53 | 128.81 | 128.91 | 338000.0 |
| 2001-02-20 15:00:00 | SPY | ETF | 128.81 | 129.0 | 128.16 | 128.32 | 1358100.0 |
| 2001-02-20 16:00:00 | SPY | ETF | 128.17 | 129.37 | 128.15 | 128.39 | 394800.0 |
| 2001-02-20 09:00:00 | QQQ | ETF | 55.74 | 55.84 | 54.75 | 54.98 | 5497900.0 |
| 2001-02-20 10:00:00 | QQQ | ETF | 54.97 | 55.18 | 53.61 | 53.72 | 9526500.0 |
| 2001-02-20 11:00:00 | QQQ | ETF | 53.72 | 54.06 | 53.1 | 54.0 | 8012100.0 |
| 2001-02-20 12:00:00 | QQQ | ETF | 54.0 | 54.23 | 53.51 | 53.76 | 5073800.0 |
| 2001-02-20 13:00:00 | QQQ | ETF | 53.75 | 53.86 | 53.1 | 53.5 | 3811900.0 |
| 2001-02-20 14:00:00 | QQQ | ETF | 53.5 | 53.88 | 53.01 | 53.12 | 6995400.0 |
| 2001-02-20 15:00:00 | QQQ | ETF | 53.12 | 53.32 | 52.39 | 52.4 | 11713400.0 |
| 2001-02-20 16:00:00 | QQQ | ETF | 52.42 | 53.0 | 52.25 | 53.0 | 1427500.0 |
| 2001-02-20 17:00:00 | QQQ | ETF | 53.0 | 53.1 | 52.8 | 52.95 | 73500.0 |
| 2001-02-20 18:00:00 | QQQ | ETF | 53.0 | 53.03 | 52.95 | 52.97 | 7100.0 |
| 2001-02-20 09:00:00 | IWM | ETF | 49.85 | 50.0 | 49.685 | 49.845 | 9200.0 |
| 2001-02-20 10:00:00 | IWM | ETF | 49.85 | 49.85 | 49.45 | 49.62 | 26600.0 |
| 2001-02-20 11:00:00 | IWM | ETF | 49.525 | 49.525 | 49.135 | 49.475 | 17600.0 |
| 2001-02-20 12:00:00 | IWM | ETF | 49.45 | 49.475 | 49.29 | 49.42 | 4400.0 |
| 2001-02-20 13:00:00 | IWM | ETF | 49.285 | 49.385 | 49.15 | 49.27 | 11400.0 |
| 2001-02-20 14:00:00 | IWM | ETF | 49.125 | 49.25 | 49.005 | 49.005 | 86600.0 |
| 2001-02-20 15:00:00 | IWM | ETF | 49.0 | 49.065 | 48.76 | 49.03 | 46000.0 |
| 2001-02-20 16:00:00 | IWM | ETF | 49.125 | 49.125 | 49.125 | 49.125 | 426000.0 |
| 2001-02-20 09:00:00 | DIA | ETF | 108.4 | 108.9 | 108.2 | 108.76 | 174700.0 |
| 2001-02-20 10:00:00 | DIA | ETF | 108.75 | 109.1 | 108.5 | 108.6 | 195000.0 |
| 2001-02-20 11:00:00 | DIA | ETF | 108.6 | 108.6 | 107.81 | 108.2 | 366100.0 |
| 2001-02-20 12:00:00 | DIA | ETF | 108.05 | 108.3 | 107.8 | 108.0 | 32300.0 |
| 2001-02-20 13:00:00 | DIA | ETF | 108.0 | 108.17 | 107.86 | 108.02 | 57600.0 |
| 2001-02-20 14:00:00 | DIA | ETF | 108.2 | 108.22 | 107.63 | 107.75 | 112700.0 |
| 2001-02-20 15:00:00 | DIA | ETF | 107.67 | 107.83 | 107.31 | 107.39 | 158200.0 |
| 2001-02-20 16:00:00 | DIA | ETF | 107.39 | 107.5 | 107.38 | 107.45 | 23400.0 |
> showing 34 of 211 rows — these rows as CSV