PREVIEW / etf_1hour / 2001-06-08
file: by_date/etf_1hour/2001/2001-06-08.parquet size: 11 KB rows: 205
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-06-08 09:00:00 | SPY | ETF | 127.7 | 127.87 | 127.5 | 127.69 | 1031600.0 |
| 2001-06-08 10:00:00 | SPY | ETF | 127.71 | 127.71 | 126.77 | 126.97 | 844300.0 |
| 2001-06-08 11:00:00 | SPY | ETF | 126.9 | 127.09 | 126.54 | 126.65 | 649100.0 |
| 2001-06-08 12:00:00 | SPY | ETF | 126.62 | 126.72 | 126.14 | 126.5 | 1449000.0 |
| 2001-06-08 13:00:00 | SPY | ETF | 126.52 | 126.75 | 126.32 | 126.62 | 1220900.0 |
| 2001-06-08 14:00:00 | SPY | ETF | 126.68 | 127.03 | 126.55 | 126.85 | 670500.0 |
| 2001-06-08 15:00:00 | SPY | ETF | 126.88 | 127.25 | 126.65 | 127.0 | 874700.0 |
| 2001-06-08 16:00:00 | SPY | ETF | 127.0 | 127.19 | 126.96 | 127.03 | 1044700.0 |
| 2001-06-08 09:00:00 | QQQ | ETF | 48.72 | 48.77 | 47.9 | 48.21 | 10203400.0 |
| 2001-06-08 10:00:00 | QQQ | ETF | 48.21 | 48.26 | 47.54 | 47.8 | 9723400.0 |
| 2001-06-08 11:00:00 | QQQ | ETF | 47.8 | 47.83 | 47.35 | 47.37 | 7517300.0 |
| 2001-06-08 12:00:00 | QQQ | ETF | 47.35 | 47.46 | 46.95 | 47.37 | 8602500.0 |
| 2001-06-08 13:00:00 | QQQ | ETF | 47.3 | 47.49 | 47.07 | 47.33 | 6095500.0 |
| 2001-06-08 14:00:00 | QQQ | ETF | 47.33 | 47.7 | 47.2 | 47.43 | 4167000.0 |
| 2001-06-08 15:00:00 | QQQ | ETF | 47.45 | 47.54 | 47.17 | 47.27 | 6493200.0 |
| 2001-06-08 16:00:00 | QQQ | ETF | 47.27 | 47.45 | 47.23 | 47.3 | 990400.0 |
| 2001-06-08 17:00:00 | QQQ | ETF | 47.27 | 47.35 | 47.25 | 47.35 | 14500.0 |
| 2001-06-08 18:00:00 | QQQ | ETF | 47.28 | 47.28 | 47.28 | 47.28 | 4000.0 |
| 2001-06-08 09:00:00 | IWM | ETF | 51.25 | 51.3 | 51.15 | 51.175 | 50000.0 |
| 2001-06-08 10:00:00 | IWM | ETF | 51.165 | 51.275 | 51.025 | 51.17 | 75600.0 |
| 2001-06-08 11:00:00 | IWM | ETF | 51.075 | 51.075 | 50.725 | 50.9 | 11200.0 |
| 2001-06-08 12:00:00 | IWM | ETF | 50.725 | 50.875 | 50.525 | 50.75 | 52400.0 |
| 2001-06-08 13:00:00 | IWM | ETF | 50.745 | 50.875 | 50.625 | 50.87 | 147600.0 |
| 2001-06-08 14:00:00 | IWM | ETF | 50.875 | 51.075 | 50.825 | 51.075 | 87800.0 |
| 2001-06-08 15:00:00 | IWM | ETF | 51.075 | 51.125 | 50.855 | 50.855 | 99800.0 |
| 2001-06-08 16:00:00 | IWM | ETF | 50.95 | 50.95 | 50.95 | 50.95 | 5000.0 |
| 2001-06-08 09:00:00 | DIA | ETF | 110.8 | 110.8 | 110.5 | 110.75 | 200600.0 |
| 2001-06-08 10:00:00 | DIA | ETF | 110.7 | 110.7 | 109.9 | 110.1 | 147500.0 |
| 2001-06-08 11:00:00 | DIA | ETF | 110.1 | 110.1 | 109.76 | 109.82 | 164700.0 |
| 2001-06-08 12:00:00 | DIA | ETF | 109.76 | 109.8 | 109.37 | 109.65 | 278100.0 |
| 2001-06-08 13:00:00 | DIA | ETF | 109.56 | 109.8 | 109.45 | 109.78 | 112100.0 |
| 2001-06-08 14:00:00 | DIA | ETF | 109.79 | 109.87 | 109.5 | 109.78 | 62700.0 |
| 2001-06-08 15:00:00 | DIA | ETF | 109.73 | 110.12 | 109.5 | 109.8 | 352900.0 |
| 2001-06-08 16:00:00 | DIA | ETF | 109.87 | 109.94 | 109.75 | 109.75 | 47200.0 |
> showing 34 of 205 rows — these rows as CSV