PREVIEW / etf_1hour / 2005-05-05

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-05.parquet
  size:    30 KB
  rows:    855

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-05-05 04:00:00	SPY	ETF	117.48	117.54	117.47	117.54	3000.0
2005-05-05 05:00:00	SPY	ETF	117.47	117.47	117.38	117.38	18000.0
2005-05-05 06:00:00	SPY	ETF	117.42	117.52	117.42	117.48	46100.0
2005-05-05 07:00:00	SPY	ETF	117.45	117.53	117.41	117.52	46300.0
2005-05-05 08:00:00	SPY	ETF	117.47	117.73	117.46	117.73	203300.0
2005-05-05 09:00:00	SPY	ETF	117.72	117.82	117.48	117.8	8147700.0
2005-05-05 10:00:00	SPY	ETF	117.79	118.0	117.68	117.85	10458300.0
2005-05-05 11:00:00	SPY	ETF	117.84	117.98	117.68	117.89	5316800.0
2005-05-05 12:00:00	SPY	ETF	117.89	117.97	116.93	116.94	18316600.0
2005-05-05 13:00:00	SPY	ETF	116.94	117.95	116.74	117.13	27437500.0
2005-05-05 14:00:00	SPY	ETF	117.14	117.3	116.85	116.9	10255900.0
2005-05-05 15:00:00	SPY	ETF	116.9	117.63	116.87	117.36	12967000.0
2005-05-05 16:00:00	SPY	ETF	117.35	117.66	117.34	117.47	1822700.0
2005-05-05 17:00:00	SPY	ETF	117.48	117.52	117.43	117.48	110400.0
2005-05-05 18:00:00	SPY	ETF	117.44	117.44	117.4	117.44	12800.0
2005-05-05 19:00:00	SPY	ETF	117.44	117.44	117.44	117.44	500.0
2005-05-05 09:00:00	QQQ	ETF	35.75	35.81	35.66	35.79	10371400.0
2005-05-05 10:00:00	QQQ	ETF	35.79	35.92	35.73	35.8	12162200.0
2005-05-05 11:00:00	QQQ	ETF	35.79	35.86	35.74	35.83	5325700.0
2005-05-05 12:00:00	QQQ	ETF	35.82	35.92	35.65	35.65	11056500.0
2005-05-05 13:00:00	QQQ	ETF	35.65	35.74	35.53	35.66	16080700.0
2005-05-05 14:00:00	QQQ	ETF	35.66	35.72	35.58	35.58	8821300.0
2005-05-05 15:00:00	QQQ	ETF	35.58	35.8	35.56	35.72	11223000.0
2005-05-05 08:00:00	IWM	ETF	59.185	59.185	59.125	59.125	11000.0
2005-05-05 09:00:00	IWM	ETF	59.165	59.41	59.01	59.375	3481200.0
2005-05-05 10:00:00	IWM	ETF	59.375	59.58	59.32	59.435	5499200.0
2005-05-05 11:00:00	IWM	ETF	59.43	59.575	59.37	59.515	2291800.0
2005-05-05 12:00:00	IWM	ETF	59.5204	59.55	58.85	58.93	4607200.0
2005-05-05 13:00:00	IWM	ETF	58.93	59.12	58.73	58.905	11365200.0
2005-05-05 14:00:00	IWM	ETF	58.93	59.195	58.875	58.882	4438400.0
2005-05-05 15:00:00	IWM	ETF	58.875	59.28	58.86	59.235	2136800.0
2005-05-05 16:00:00	IWM	ETF	59.275	59.325	58.965	59.12	4461200.0
2005-05-05 17:00:00	IWM	ETF	59.135	59.195	59.135	59.195	32800.0
2005-05-05 18:00:00	IWM	ETF	59.135	59.195	59.135	59.195	12200.0
2005-05-05 07:00:00	DIA	ETF	103.74	103.75	103.74	103.75	900.0
2005-05-05 08:00:00	DIA	ETF	103.72	103.92	103.72	103.86	37400.0
2005-05-05 09:00:00	DIA	ETF	103.81	103.97	103.73	103.92	504000.0
2005-05-05 10:00:00	DIA	ETF	103.91	104.08	103.78	103.86	973500.0
2005-05-05 11:00:00	DIA	ETF	103.85	103.99	103.71	103.87	286300.0
2005-05-05 12:00:00	DIA	ETF	103.88	103.97	103.18	103.19	1621200.0
2005-05-05 13:00:00	DIA	ETF	103.17	103.47	102.99	103.26	2552400.0
2005-05-05 14:00:00	DIA	ETF	103.31	103.39	103.08	103.1	983600.0
2005-05-05 15:00:00	DIA	ETF	103.11	103.69	103.07	103.46	1732300.0
2005-05-05 16:00:00	DIA	ETF	103.47	103.51	103.41	103.43	112700.0
2005-05-05 17:00:00	DIA	ETF	103.45	103.45	103.45	103.45	100.0
2005-05-05 18:00:00	DIA	ETF	103.46	103.46	103.45	103.45	400.0
2005-05-05 08:00:00	GLD	ETF	42.91	42.92	42.91	42.92	500.0
2005-05-05 09:00:00	GLD	ETF	42.96	42.96	42.87	42.88	85100.0
2005-05-05 10:00:00	GLD	ETF	42.86	42.89	42.83	42.83	38400.0
2005-05-05 11:00:00	GLD	ETF	42.82	42.84	42.71	42.78	30200.0

> showing 50 of 855 rows — these rows as CSV

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