PREVIEW / etf_1hour / 2005-02-11

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-02-11.parquet
  size:    29 KB
  rows:    836

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-02-11 08:00:00	SPY	ETF	119.77	119.77	119.7	119.76	56800.0
2005-02-11 09:00:00	SPY	ETF	119.77	119.82	119.54	119.59	4509300.0
2005-02-11 10:00:00	SPY	ETF	119.59	119.93	119.46	119.84	10354100.0
2005-02-11 11:00:00	SPY	ETF	119.85	121.04	119.84	120.77	16447200.0
2005-02-11 12:00:00	SPY	ETF	120.73	120.98	120.7	120.82	4268100.0
2005-02-11 13:00:00	SPY	ETF	120.81	120.99	120.64	120.9	5297200.0
2005-02-11 14:00:00	SPY	ETF	120.9	120.98	120.65	120.871	3926100.0
2005-02-11 15:00:00	SPY	ETF	120.87	120.96	120.67	120.72	5499800.0
2005-02-11 16:00:00	SPY	ETF	120.7	120.9	120.65	120.88	1075700.0
2005-02-11 17:00:00	SPY	ETF	120.88	120.95	120.65	120.89	80600.0
2005-02-11 19:00:00	SPY	ETF	120.9	120.9	120.9	120.9	4000.0
2005-02-11 09:00:00	QQQ	ETF	37.07	37.12	36.93	36.98	13350200.0
2005-02-11 10:00:00	QQQ	ETF	36.98	37.36	36.93	37.29	22955600.0
2005-02-11 11:00:00	QQQ	ETF	37.28	37.92	37.28	37.61	25972200.0
2005-02-11 12:00:00	QQQ	ETF	37.62	37.75	37.57	37.69	9698600.0
2005-02-11 13:00:00	QQQ	ETF	37.69	37.85	37.62	37.8	12574500.0
2005-02-11 14:00:00	QQQ	ETF	37.8	37.81	37.69	37.77	6923500.0
2005-02-11 15:00:00	QQQ	ETF	37.77	37.8	37.68	37.71	11894400.0
2005-02-11 08:00:00	IWM	ETF	62.2	62.2	62.17	62.2	11400.0
2005-02-11 09:00:00	IWM	ETF	62.31	62.345	61.955	62.045	1632600.0
2005-02-11 10:00:00	IWM	ETF	62.04	62.41	61.88	62.315	3671000.0
2005-02-11 11:00:00	IWM	ETF	62.335	63.135	62.33	62.94	4523800.0
2005-02-11 12:00:00	IWM	ETF	62.935	63.045	62.81	63.01	1050800.0
2005-02-11 13:00:00	IWM	ETF	63.02	63.35	62.905	63.26	2384600.0
2005-02-11 14:00:00	IWM	ETF	63.27	63.33	63.17	63.205	1461600.0
2005-02-11 15:00:00	IWM	ETF	63.21	63.37	63.0	63.215	2813200.0
2005-02-11 16:00:00	IWM	ETF	63.24	63.365	63.19	63.33	444000.0
2005-02-11 08:00:00	DIA	ETF	107.5	107.5	107.5	107.5	100.0
2005-02-11 09:00:00	DIA	ETF	107.46	107.52	107.24	107.24	536400.0
2005-02-11 10:00:00	DIA	ETF	107.25	107.44	107.14	107.39	792900.0
2005-02-11 11:00:00	DIA	ETF	107.4	108.39	107.4	108.16	1264900.0
2005-02-11 12:00:00	DIA	ETF	108.17	108.26	108.02	108.1	407900.0
2005-02-11 13:00:00	DIA	ETF	108.1	108.24	107.97	108.17	449900.0
2005-02-11 14:00:00	DIA	ETF	108.16	108.28	108.06	108.2	339700.0
2005-02-11 15:00:00	DIA	ETF	108.21	108.27	108.04	108.06	840000.0
2005-02-11 16:00:00	DIA	ETF	108.07	108.17	108.0	108.16	80100.0
2005-02-11 17:00:00	DIA	ETF	108.15	108.18	108.15	108.18	500.0
2005-02-11 09:00:00	GLD	ETF	41.89	41.9	41.83	41.9	182600.0
2005-02-11 10:00:00	GLD	ETF	41.89	42.02	41.89	42.0	395900.0
2005-02-11 11:00:00	GLD	ETF	42.0	42.16	41.89	41.96	609200.0
2005-02-11 12:00:00	GLD	ETF	41.97	42.05	41.95	41.97	292900.0
2005-02-11 13:00:00	GLD	ETF	41.99	42.06	41.97	42.05	111300.0
2005-02-11 14:00:00	GLD	ETF	42.04	42.1	42.03	42.09	169500.0
2005-02-11 15:00:00	GLD	ETF	42.08	42.1	42.04	42.08	134800.0
2005-02-11 08:00:00	TLT	ETF	92.62	92.7	92.55	92.7	12400.0
2005-02-11 09:00:00	TLT	ETF	92.6	92.65	92.4	92.41	171300.0
2005-02-11 10:00:00	TLT	ETF	92.42	92.67	92.41	92.65	808800.0
2005-02-11 11:00:00	TLT	ETF	92.65	92.98	92.61	92.95	32200.0
2005-02-11 12:00:00	TLT	ETF	92.95	92.98	92.83	92.94	19100.0
2005-02-11 13:00:00	TLT	ETF	92.84	92.84	92.51	92.62	80400.0

> showing 50 of 836 rows — these rows as CSV

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