PREVIEW / etf_1hour / 2001-10-04
file: by_date/etf_1hour/2001/2001-10-04.parquet size: 13 KB rows: 260
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-10-04 09:00:00 | SPY | ETF | 108.29 | 108.29 | 107.18 | 107.62 | 3382100.0 |
| 2001-10-04 10:00:00 | SPY | ETF | 107.65 | 108.28 | 107.23 | 108.25 | 5632900.0 |
| 2001-10-04 11:00:00 | SPY | ETF | 108.22 | 108.75 | 108.1 | 108.38 | 4187300.0 |
| 2001-10-04 12:00:00 | SPY | ETF | 108.42 | 108.67 | 108.16 | 108.42 | 2247700.0 |
| 2001-10-04 13:00:00 | SPY | ETF | 108.41 | 108.75 | 107.95 | 108.22 | 2448600.0 |
| 2001-10-04 14:00:00 | SPY | ETF | 108.18 | 108.25 | 107.38 | 107.95 | 5863400.0 |
| 2001-10-04 15:00:00 | SPY | ETF | 108.03 | 108.18 | 106.75 | 107.1 | 5180600.0 |
| 2001-10-04 16:00:00 | SPY | ETF | 107.18 | 107.8 | 107.13 | 107.45 | 974000.0 |
| 2001-10-04 17:00:00 | SPY | ETF | 107.45 | 107.45 | 107.43 | 107.43 | 1400.0 |
| 2001-10-04 18:00:00 | SPY | ETF | 107.25 | 107.44 | 107.25 | 107.25 | 700.0 |
| 2001-10-04 09:00:00 | QQQ | ETF | 31.65 | 31.7 | 30.94 | 31.55 | 18834900.0 |
| 2001-10-04 10:00:00 | QQQ | ETF | 31.54 | 32.25 | 31.5 | 32.2 | 26430300.0 |
| 2001-10-04 11:00:00 | QQQ | ETF | 32.21 | 32.74 | 32.13 | 32.39 | 18409000.0 |
| 2001-10-04 12:00:00 | QQQ | ETF | 32.38 | 32.6 | 32.14 | 32.28 | 9742300.0 |
| 2001-10-04 13:00:00 | QQQ | ETF | 32.29 | 32.63 | 32.06 | 32.2 | 8956900.0 |
| 2001-10-04 14:00:00 | QQQ | ETF | 32.22 | 32.25 | 31.59 | 32.0 | 16072800.0 |
| 2001-10-04 15:00:00 | QQQ | ETF | 32.01 | 32.19 | 31.26 | 31.38 | 20499400.0 |
| 2001-10-04 16:00:00 | QQQ | ETF | 31.38 | 32.63 | 31.25 | 31.37 | 2637400.0 |
| 2001-10-04 17:00:00 | QQQ | ETF | 31.37 | 31.55 | 31.3 | 31.3 | 40400.0 |
| 2001-10-04 18:00:00 | QQQ | ETF | 31.33 | 31.39 | 31.28 | 31.29 | 15700.0 |
| 2001-10-04 09:00:00 | IWM | ETF | 41.25 | 41.395 | 41.025 | 41.255 | 383200.0 |
| 2001-10-04 10:00:00 | IWM | ETF | 41.345 | 41.6 | 41.2 | 41.6 | 226200.0 |
| 2001-10-04 11:00:00 | IWM | ETF | 41.5 | 41.85 | 41.5 | 41.81 | 140400.0 |
| 2001-10-04 12:00:00 | IWM | ETF | 41.8 | 41.825 | 41.675 | 41.77 | 61200.0 |
| 2001-10-04 13:00:00 | IWM | ETF | 41.81 | 41.97 | 41.7 | 41.745 | 235000.0 |
| 2001-10-04 14:00:00 | IWM | ETF | 41.75 | 41.79 | 41.5 | 41.7 | 590600.0 |
| 2001-10-04 15:00:00 | IWM | ETF | 41.695 | 41.72 | 41.31 | 41.4 | 265200.0 |
| 2001-10-04 16:00:00 | IWM | ETF | 41.355 | 41.51 | 41.355 | 41.51 | 4400.0 |
| 2001-10-04 09:00:00 | DIA | ETF | 91.9 | 91.9 | 90.94 | 91.26 | 1059900.0 |
| 2001-10-04 10:00:00 | DIA | ETF | 91.26 | 91.88 | 90.86 | 91.69 | 1428500.0 |
| 2001-10-04 11:00:00 | DIA | ETF | 91.65 | 91.98 | 91.52 | 91.72 | 902700.0 |
| 2001-10-04 12:00:00 | DIA | ETF | 91.71 | 91.92 | 91.51 | 91.71 | 376400.0 |
| 2001-10-04 13:00:00 | DIA | ETF | 91.7 | 91.95 | 91.38 | 91.66 | 515200.0 |
| 2001-10-04 14:00:00 | DIA | ETF | 91.6 | 91.62 | 90.84 | 91.3 | 1720500.0 |
| 2001-10-04 15:00:00 | DIA | ETF | 91.31 | 91.5 | 90.4 | 90.5 | 1550200.0 |
| 2001-10-04 16:00:00 | DIA | ETF | 90.6 | 90.9 | 90.6 | 90.9 | 88500.0 |
| 2001-10-04 18:00:00 | DIA | ETF | 90.66 | 90.66 | 90.66 | 90.66 | 200.0 |
> showing 37 of 260 rows — these rows as CSV