PREVIEW / etf_1hour / 2005-06-13

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-06-13.parquet
  size:    29 KB
  rows:    862

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-13 07:00:00	SPY	ETF	120.13	120.13	120.03	120.09	110900.0
2005-06-13 08:00:00	SPY	ETF	120.09	120.09	119.99	120.08	133600.0
2005-06-13 09:00:00	SPY	ETF	120.03	120.14	119.85	119.96	4458000.0
2005-06-13 10:00:00	SPY	ETF	119.96	120.71	119.81	120.68	10220400.0
2005-06-13 11:00:00	SPY	ETF	120.69	121.08	120.68	120.85	7411900.0
2005-06-13 12:00:00	SPY	ETF	120.85	120.91	120.63	120.77	3983300.0
2005-06-13 13:00:00	SPY	ETF	120.77	120.88	120.51	120.54	3390700.0
2005-06-13 14:00:00	SPY	ETF	120.55	120.75	120.39	120.6	5330000.0
2005-06-13 15:00:00	SPY	ETF	120.6	120.65	120.18	120.49	9902300.0
2005-06-13 16:00:00	SPY	ETF	120.5	120.64	120.46	120.61	326200.0
2005-06-13 17:00:00	SPY	ETF	120.61	120.63	120.54	120.62	23000.0
2005-06-13 18:00:00	SPY	ETF	120.58	120.58	120.58	120.58	1000.0
2005-06-13 19:00:00	SPY	ETF	120.57	120.57	120.56	120.56	600.0
2005-06-13 09:00:00	QQQ	ETF	37.48	37.63	37.46	37.56	9702600.0
2005-06-13 10:00:00	QQQ	ETF	37.56	37.89	37.47	37.86	21195200.0
2005-06-13 11:00:00	QQQ	ETF	37.86	37.95	37.85	37.88	14536100.0
2005-06-13 12:00:00	QQQ	ETF	37.88	37.89	37.77	37.83	6462800.0
2005-06-13 13:00:00	QQQ	ETF	37.83	37.86	37.73	37.73	6693700.0
2005-06-13 14:00:00	QQQ	ETF	37.73	37.81	37.65	37.75	10691300.0
2005-06-13 15:00:00	QQQ	ETF	37.75	37.77	37.64	37.71	10112500.0
2005-06-13 07:00:00	IWM	ETF	62.35	62.36	62.3	62.3	44100.0
2005-06-13 08:00:00	IWM	ETF	62.3	62.3	62.3	62.3	14900.0
2005-06-13 09:00:00	IWM	ETF	62.26	62.4	62.19	62.25	1327300.0
2005-06-13 10:00:00	IWM	ETF	62.24	62.71	62.13	62.7	2361300.0
2005-06-13 11:00:00	IWM	ETF	62.7	62.82	62.55	62.64	1571600.0
2005-06-13 12:00:00	IWM	ETF	62.65	62.68	62.5	62.61	819800.0
2005-06-13 13:00:00	IWM	ETF	62.6	62.73	62.44	62.47	3275400.0
2005-06-13 14:00:00	IWM	ETF	62.46	62.59	62.31	62.46	2837500.0
2005-06-13 15:00:00	IWM	ETF	62.46	62.63	62.29	62.62	1901500.0
2005-06-13 16:00:00	IWM	ETF	62.62	62.73	62.3713	62.372	7189700.0
2005-06-13 17:00:00	IWM	ETF	62.73	62.73	62.73	62.73	200000.0
2005-06-13 08:00:00	DIA	ETF	104.98	105.06	104.98	105.05	1200.0
2005-06-13 09:00:00	DIA	ETF	105.04	105.05	104.79	104.87	264800.0
2005-06-13 10:00:00	DIA	ETF	104.87	105.64	104.76	105.62	1207900.0
2005-06-13 11:00:00	DIA	ETF	105.61	105.94	105.6	105.82	1078600.0
2005-06-13 12:00:00	DIA	ETF	105.82	105.82	105.55	105.66	189600.0
2005-06-13 13:00:00	DIA	ETF	105.66	105.75	105.49	105.49	193500.0
2005-06-13 14:00:00	DIA	ETF	105.5	105.61	105.19	105.39	705200.0
2005-06-13 15:00:00	DIA	ETF	105.42	105.45	105.05	105.29	1008200.0
2005-06-13 16:00:00	DIA	ETF	105.28	105.38	105.14	105.38	123100.0
2005-06-13 18:00:00	DIA	ETF	105.3	105.3	105.3	105.3	100.0
2005-06-13 08:00:00	GLD	ETF	42.61	42.61	42.52	42.52	1500.0
2005-06-13 09:00:00	GLD	ETF	42.59	42.87	42.59	42.84	167000.0
2005-06-13 10:00:00	GLD	ETF	42.84	42.85	42.7	42.76	307100.0
2005-06-13 11:00:00	GLD	ETF	42.76	42.84	42.74	42.82	370900.0
2005-06-13 12:00:00	GLD	ETF	42.83	43.01	42.82	42.87	306700.0
2005-06-13 13:00:00	GLD	ETF	42.88	42.89	42.77	42.79	367000.0
2005-06-13 14:00:00	GLD	ETF	42.78	42.79	42.74	42.77	264400.0
2005-06-13 15:00:00	GLD	ETF	42.76	42.8	42.74	42.78	489300.0
2005-06-13 16:00:00	GLD	ETF	42.78	42.78	42.78	42.78	600.0

> showing 50 of 862 rows — these rows as CSV

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