PREVIEW / etf_1hour / 2005-06-20

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-06-20.parquet
  size:    29 KB
  rows:    870

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
2005-06-20 06:00:00	SPY	ETF	121.15	121.16	121.15	121.16	4000.0
2005-06-20 07:00:00	SPY	ETF	121.13	121.16	121.12	121.16	7800.0
2005-06-20 08:00:00	SPY	ETF	121.16	121.16	121.05	121.1	427600.0
2005-06-20 09:00:00	SPY	ETF	121.12	121.2	121.04	121.14	4374700.0
2005-06-20 10:00:00	SPY	ETF	121.15	121.34	120.94	121.22	8204500.0
2005-06-20 11:00:00	SPY	ETF	121.22	121.3	121.07	121.28	3356800.0
2005-06-20 12:00:00	SPY	ETF	121.28	121.35	121.22	121.25	2412900.0
2005-06-20 13:00:00	SPY	ETF	121.24	121.33	121.12	121.27	2616500.0
2005-06-20 14:00:00	SPY	ETF	121.27	121.62	121.17	121.57	5932700.0
2005-06-20 15:00:00	SPY	ETF	121.57	121.84	121.49	121.5	11836900.0
2005-06-20 16:00:00	SPY	ETF	121.49	121.539	121.39	121.42	2025500.0
2005-06-20 17:00:00	SPY	ETF	121.41	121.45	121.4	121.45	10300.0
2005-06-20 18:00:00	SPY	ETF	121.45	121.48	121.45	121.45	38800.0
2005-06-20 19:00:00	SPY	ETF	121.45	121.47	121.43	121.43	4200.0
2005-06-20 09:00:00	QQQ	ETF	37.72	37.76	37.68	37.74	7963600.0
2005-06-20 10:00:00	QQQ	ETF	37.73	37.83	37.58	37.75	14974800.0
2005-06-20 11:00:00	QQQ	ETF	37.74	37.83	37.71	37.82	6918800.0
2005-06-20 12:00:00	QQQ	ETF	37.83	37.89	37.81	37.82	7494000.0
2005-06-20 13:00:00	QQQ	ETF	37.82	37.84	37.74	37.82	3803900.0
2005-06-20 14:00:00	QQQ	ETF	37.81	37.97	37.78	37.95	8111900.0
2005-06-20 15:00:00	QQQ	ETF	37.95	38.08	37.86	37.87	13365900.0
2005-06-20 07:00:00	IWM	ETF	63.74	63.74	63.71	63.71	7000.0
2005-06-20 08:00:00	IWM	ETF	63.7	63.73	63.63	63.63	24000.0
2005-06-20 09:00:00	IWM	ETF	63.65	63.95	63.65	63.94	2723100.0
2005-06-20 10:00:00	IWM	ETF	63.93	63.93	63.58	63.64	5527500.0
2005-06-20 11:00:00	IWM	ETF	63.64	63.85	63.56	63.84	2962200.0
2005-06-20 12:00:00	IWM	ETF	63.83	63.86	63.72	63.8	1628200.0
2005-06-20 13:00:00	IWM	ETF	63.8	63.93	63.74	63.86	776100.0
2005-06-20 14:00:00	IWM	ETF	63.86	63.97	63.77	63.89	1509600.0
2005-06-20 15:00:00	IWM	ETF	63.89	64.01	63.72	63.72	1929300.0
2005-06-20 16:00:00	IWM	ETF	63.72	63.74	63.68	63.68	15600.0
2005-06-20 17:00:00	IWM	ETF	63.68	63.68	63.68	63.68	100.0
2005-06-20 07:00:00	DIA	ETF	105.7	105.7	105.7	105.7	100.0
2005-06-20 08:00:00	DIA	ETF	105.72	105.72	105.67	105.67	3100.0
2005-06-20 09:00:00	DIA	ETF	105.69	105.76	105.58	105.72	497800.0
2005-06-20 10:00:00	DIA	ETF	105.72	105.87	105.54	105.76	946100.0
2005-06-20 11:00:00	DIA	ETF	105.77	105.82	105.66	105.76	543000.0
2005-06-20 12:00:00	DIA	ETF	105.79	105.83	105.73	105.76	194600.0
2005-06-20 13:00:00	DIA	ETF	105.75	105.82	105.65	105.76	258100.0
2005-06-20 14:00:00	DIA	ETF	105.78	106.06	105.69	106.03	694300.0
2005-06-20 15:00:00	DIA	ETF	106.05	106.27	105.98	106.02	528800.0
2005-06-20 16:00:00	DIA	ETF	105.96	105.9815	105.94	105.94	277200.0
2005-06-20 17:00:00	DIA	ETF	105.95	105.96	105.95	105.96	200.0
2005-06-20 18:00:00	DIA	ETF	106.0	106.0	106.0	106.0	100.0
2005-06-20 08:00:00	GLD	ETF	43.94	43.96	43.94	43.96	800.0
2005-06-20 09:00:00	GLD	ETF	43.94	43.94	43.85	43.88	284600.0
2005-06-20 10:00:00	GLD	ETF	43.9	43.9	43.66	43.74	347100.0
2005-06-20 11:00:00	GLD	ETF	43.72	43.77	43.67	43.75	181100.0
2005-06-20 12:00:00	GLD	ETF	43.75	43.81	43.69	43.69	113600.0
2005-06-20 13:00:00	GLD	ETF	43.69	43.75	43.67	43.71	158600.0

> showing 50 of 870 rows — these rows as CSV

> unlock the full archive -- $79 one-time