PREVIEW / etf_1hour / 2001-05-17
file: by_date/etf_1hour/2001/2001-05-17.parquet size: 12 KB rows: 238
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-17 09:00:00 | SPY | ETF | 128.97 | 129.7 | 128.83 | 129.61 | 2066100.0 |
| 2001-05-17 10:00:00 | SPY | ETF | 129.6 | 130.08 | 128.56 | 129.09 | 2428400.0 |
| 2001-05-17 11:00:00 | SPY | ETF | 129.07 | 129.43 | 128.78 | 129.21 | 969600.0 |
| 2001-05-17 12:00:00 | SPY | ETF | 129.29 | 129.71 | 129.21 | 129.71 | 946800.0 |
| 2001-05-17 13:00:00 | SPY | ETF | 129.74 | 130.07 | 129.37 | 129.38 | 1863900.0 |
| 2001-05-17 14:00:00 | SPY | ETF | 129.41 | 129.84 | 129.04 | 129.07 | 1212600.0 |
| 2001-05-17 15:00:00 | SPY | ETF | 129.19 | 129.66 | 129.06 | 129.31 | 1457300.0 |
| 2001-05-17 16:00:00 | SPY | ETF | 129.3 | 129.39 | 129.12 | 129.12 | 600900.0 |
| 2001-05-17 17:00:00 | SPY | ETF | 128.8 | 128.8 | 128.8 | 128.8 | 4300.0 |
| 2001-05-17 09:00:00 | QQQ | ETF | 47.45 | 48.33 | 47.3 | 48.28 | 11360600.0 |
| 2001-05-17 10:00:00 | QQQ | ETF | 48.29 | 48.47 | 47.39 | 47.83 | 17175800.0 |
| 2001-05-17 11:00:00 | QQQ | ETF | 47.85 | 48.09 | 47.51 | 47.97 | 5212400.0 |
| 2001-05-17 12:00:00 | QQQ | ETF | 47.99 | 48.4 | 47.95 | 48.36 | 4774700.0 |
| 2001-05-17 13:00:00 | QQQ | ETF | 48.35 | 48.79 | 48.05 | 48.12 | 10014100.0 |
| 2001-05-17 14:00:00 | QQQ | ETF | 48.13 | 48.31 | 47.6 | 47.6 | 12321500.0 |
| 2001-05-17 15:00:00 | QQQ | ETF | 47.64 | 48.1 | 47.45 | 48.03 | 8772800.0 |
| 2001-05-17 16:00:00 | QQQ | ETF | 48.0 | 48.25 | 47.5 | 47.71 | 1376600.0 |
| 2001-05-17 17:00:00 | QQQ | ETF | 47.75 | 47.75 | 47.4 | 47.4 | 121700.0 |
| 2001-05-17 18:00:00 | QQQ | ETF | 47.45 | 47.5 | 47.31 | 47.31 | 31800.0 |
| 2001-05-17 09:00:00 | IWM | ETF | 49.875 | 50.2 | 49.875 | 50.15 | 31800.0 |
| 2001-05-17 10:00:00 | IWM | ETF | 50.1 | 50.325 | 49.75 | 49.75 | 71000.0 |
| 2001-05-17 11:00:00 | IWM | ETF | 50.05 | 50.145 | 49.97 | 50.145 | 21200.0 |
| 2001-05-17 12:00:00 | IWM | ETF | 50.145 | 50.26 | 50.025 | 50.25 | 5400.0 |
| 2001-05-17 13:00:00 | IWM | ETF | 50.32 | 50.425 | 50.2 | 50.375 | 10600.0 |
| 2001-05-17 14:00:00 | IWM | ETF | 50.375 | 50.375 | 50.175 | 50.25 | 4600.0 |
| 2001-05-17 15:00:00 | IWM | ETF | 50.25 | 50.375 | 50.05 | 50.375 | 21200.0 |
| 2001-05-17 16:00:00 | IWM | ETF | 50.39 | 50.39 | 50.375 | 50.38 | 3200.0 |
| 2001-05-17 09:00:00 | DIA | ETF | 112.4 | 113.1 | 112.15 | 112.91 | 894900.0 |
| 2001-05-17 10:00:00 | DIA | ETF | 113.0 | 113.39 | 112.37 | 112.61 | 1441300.0 |
| 2001-05-17 11:00:00 | DIA | ETF | 112.78 | 113.12 | 112.5 | 113.0 | 321200.0 |
| 2001-05-17 12:00:00 | DIA | ETF | 112.91 | 113.2 | 112.91 | 113.09 | 150700.0 |
| 2001-05-17 13:00:00 | DIA | ETF | 113.11 | 113.64 | 112.9 | 112.9 | 665500.0 |
| 2001-05-17 14:00:00 | DIA | ETF | 112.87 | 113.2 | 112.55 | 112.63 | 203300.0 |
| 2001-05-17 15:00:00 | DIA | ETF | 112.55 | 113.12 | 112.49 | 112.77 | 257000.0 |
| 2001-05-17 16:00:00 | DIA | ETF | 112.8 | 113.01 | 112.65 | 112.65 | 41700.0 |
| 2001-05-17 17:00:00 | DIA | ETF | 112.65 | 112.65 | 112.65 | 112.65 | 400.0 |
> showing 36 of 238 rows — these rows as CSV