PREVIEW / etf_1hour / 2005-06-14

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-06-14.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-14 06:00:00	SPY	ETF	120.56	120.56	120.56	120.56	1000.0
2005-06-14 07:00:00	SPY	ETF	120.56	120.56	120.43	120.55	111800.0
2005-06-14 08:00:00	SPY	ETF	120.57	120.86	120.55	120.66	616300.0
2005-06-14 09:00:00	SPY	ETF	120.62	120.78	120.38	120.72	6346600.0
2005-06-14 10:00:00	SPY	ETF	120.72	120.86	120.48	120.57	5527800.0
2005-06-14 11:00:00	SPY	ETF	120.57	120.79	120.53	120.73	2596500.0
2005-06-14 12:00:00	SPY	ETF	120.73	120.75	120.59	120.6992	1726300.0
2005-06-14 13:00:00	SPY	ETF	120.7	121.14	120.51	121.13	4817100.0
2005-06-14 14:00:00	SPY	ETF	121.13	121.2	120.56	120.72	6140500.0
2005-06-14 15:00:00	SPY	ETF	120.72	120.85	120.62	120.83	4360500.0
2005-06-14 16:00:00	SPY	ETF	120.84	120.95	120.77	120.84	1181600.0
2005-06-14 17:00:00	SPY	ETF	120.81	120.85	120.77	120.84	28600.0
2005-06-14 18:00:00	SPY	ETF	120.78	120.79	120.78	120.79	500.0
2005-06-14 09:00:00	QQQ	ETF	37.69	37.84	37.63	37.79	8412000.0
2005-06-14 10:00:00	QQQ	ETF	37.79	37.79	37.59	37.63	11297000.0
2005-06-14 11:00:00	QQQ	ETF	37.62	37.67	37.58	37.63	4321500.0
2005-06-14 12:00:00	QQQ	ETF	37.63	37.64	37.54	37.6	5498000.0
2005-06-14 13:00:00	QQQ	ETF	37.59	37.69	37.52	37.69	8301400.0
2005-06-14 14:00:00	QQQ	ETF	37.69	37.73	37.51	37.54	8006700.0
2005-06-14 15:00:00	QQQ	ETF	37.53	37.61	37.5	37.59	8574800.0
2005-06-14 07:00:00	IWM	ETF	62.63	62.63	62.63	62.63	200.0
2005-06-14 08:00:00	IWM	ETF	62.66	62.66	62.66	62.66	200.0
2005-06-14 09:00:00	IWM	ETF	62.62	62.81	62.47	62.79	2232100.0
2005-06-14 10:00:00	IWM	ETF	62.79	62.94	62.64	62.74	3092000.0
2005-06-14 11:00:00	IWM	ETF	62.73	62.9	62.72	62.84	1273000.0
2005-06-14 12:00:00	IWM	ETF	62.84	62.91	62.78	62.87	671300.0
2005-06-14 13:00:00	IWM	ETF	62.87	63.12	62.7	63.12	1927500.0
2005-06-14 14:00:00	IWM	ETF	63.13	63.17	62.81	62.89	2217000.0
2005-06-14 15:00:00	IWM	ETF	62.88	63.18	62.85	63.18	3129300.0
2005-06-14 16:00:00	IWM	ETF	63.17	63.23	63.14	63.22	122500.0
2005-06-14 17:00:00	IWM	ETF	63.25	63.25	63.25	63.25	100.0
2005-06-14 08:00:00	DIA	ETF	105.4	105.51	105.36	105.37	3100.0
2005-06-14 09:00:00	DIA	ETF	105.38	105.64	105.19	105.55	778200.0
2005-06-14 10:00:00	DIA	ETF	105.55	105.61	105.27	105.33	502500.0
2005-06-14 11:00:00	DIA	ETF	105.34	105.54	105.32	105.5	499600.0
2005-06-14 12:00:00	DIA	ETF	105.5	105.53	105.39	105.47	365600.0
2005-06-14 13:00:00	DIA	ETF	105.47	105.88	105.33	105.88	646700.0
2005-06-14 14:00:00	DIA	ETF	105.89	105.91	105.39	105.49	854500.0
2005-06-14 15:00:00	DIA	ETF	105.49	105.63	105.41	105.54	467500.0
2005-06-14 16:00:00	DIA	ETF	105.51	105.58	105.5	105.54	53400.0
2005-06-14 07:00:00	GLD	ETF	42.68	42.68	42.64	42.64	1400.0
2005-06-14 08:00:00	GLD	ETF	42.64	42.67	42.6	42.67	2100.0
2005-06-14 09:00:00	GLD	ETF	42.62	42.66	42.58	42.61	102700.0
2005-06-14 10:00:00	GLD	ETF	42.62	42.65	42.59	42.64	106200.0
2005-06-14 11:00:00	GLD	ETF	42.64	42.7	42.6	42.7	234000.0
2005-06-14 12:00:00	GLD	ETF	42.69	42.7	42.62	42.65	99200.0
2005-06-14 13:00:00	GLD	ETF	42.65	42.69	42.62	42.63	47900.0
2005-06-14 14:00:00	GLD	ETF	42.64	42.64	42.58	42.58	166800.0
2005-06-14 15:00:00	GLD	ETF	42.59	42.62	42.58	42.59	54900.0
2005-06-14 16:00:00	GLD	ETF	42.64	42.64	42.64	42.64	200.0

> showing 50 of 870 rows — these rows as CSV

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