PREVIEW / etf_1hour / 2005-10-17

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-10-17.parquet
  size:    32 KB
  rows:    992

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-10-17 06:00:00	SPY	ETF	118.4	118.4	118.4	118.4	25000.0
2005-10-17 07:00:00	SPY	ETF	118.41	118.48	118.39	118.48	85200.0
2005-10-17 08:00:00	SPY	ETF	118.48	118.72	118.36	118.72	2646500.0
2005-10-17 09:00:00	SPY	ETF	118.71	119.01	118.66	118.89	11278000.0
2005-10-17 10:00:00	SPY	ETF	118.89	119.27	118.8	118.91	13241200.0
2005-10-17 11:00:00	SPY	ETF	118.92	119.19	118.86	119.07	4363000.0
2005-10-17 12:00:00	SPY	ETF	119.05	119.09	118.47	118.62	8140600.0
2005-10-17 13:00:00	SPY	ETF	118.61	118.88	118.45	118.8	4430300.0
2005-10-17 14:00:00	SPY	ETF	118.81	118.82	118.56	118.73	3956000.0
2005-10-17 15:00:00	SPY	ETF	118.73	119.17	118.67	119.07	11400300.0
2005-10-17 16:00:00	SPY	ETF	119.07	119.18	118.82	119.11	762800.0
2005-10-17 17:00:00	SPY	ETF	119.1	119.1	119.03	119.1	47800.0
2005-10-17 18:00:00	SPY	ETF	119.08	119.12	119.07	119.09	859700.0
2005-10-17 19:00:00	SPY	ETF	119.09	119.09	119.07	119.08	3500.0
2005-10-17 09:00:00	QQQ	ETF	38.05	38.1	37.97	38.08	8248000.0
2005-10-17 10:00:00	QQQ	ETF	38.08	38.13	38.0	38.03	11112700.0
2005-10-17 11:00:00	QQQ	ETF	38.04	38.07	38.01	38.06	5576900.0
2005-10-17 12:00:00	QQQ	ETF	38.06	38.06	37.82	37.89	12213700.0
2005-10-17 13:00:00	QQQ	ETF	37.89	38.05	37.86	38.03	6003400.0
2005-10-17 14:00:00	QQQ	ETF	38.03	38.04	37.94	38.03	4642400.0
2005-10-17 15:00:00	QQQ	ETF	38.03	38.19	38.02	38.18	10568500.0
2005-10-17 07:00:00	IWM	ETF	62.7	62.7	62.69	62.69	200.0
2005-10-17 08:00:00	IWM	ETF	62.7	62.8	62.64	62.77	84400.0
2005-10-17 09:00:00	IWM	ETF	62.8	63.18	62.78	62.96	6174600.0
2005-10-17 10:00:00	IWM	ETF	62.97	63.33	62.59	62.69	5827300.0
2005-10-17 11:00:00	IWM	ETF	62.69	62.84	62.58	62.82	3324400.0
2005-10-17 12:00:00	IWM	ETF	62.83	62.84	62.23	62.37	4950800.0
2005-10-17 13:00:00	IWM	ETF	62.38	62.63	62.3	62.58	2311500.0
2005-10-17 14:00:00	IWM	ETF	62.58	62.68	62.41	62.65	1245700.0
2005-10-17 15:00:00	IWM	ETF	62.64	63.01	62.61	62.99	4949900.0
2005-10-17 16:00:00	IWM	ETF	62.94	63.15	62.94	63.05	1112000.0
2005-10-17 17:00:00	IWM	ETF	63.05	63.08	63.05	63.08	1100.0
2005-10-17 18:00:00	IWM	ETF	63.03	63.03	63.03	63.03	1000.0
2005-10-17 08:00:00	DIA	ETF	102.72	102.96	102.72	102.96	93800.0
2005-10-17 09:00:00	DIA	ETF	102.99	103.18	102.94	103.1	2743100.0
2005-10-17 10:00:00	DIA	ETF	103.08	103.57	103.08	103.28	1933000.0
2005-10-17 11:00:00	DIA	ETF	103.25	103.4	103.22	103.35	384400.0
2005-10-17 12:00:00	DIA	ETF	103.35	103.4	102.96	103.05	812800.0
2005-10-17 13:00:00	DIA	ETF	103.06	103.4	102.99	103.19	392500.0
2005-10-17 14:00:00	DIA	ETF	103.19	103.21	103.0	103.14	625200.0
2005-10-17 15:00:00	DIA	ETF	103.14	103.51	103.12	103.5	816200.0
2005-10-17 16:00:00	DIA	ETF	103.5	103.64	103.5	103.62	2092800.0
2005-10-17 17:00:00	DIA	ETF	103.58	103.66	103.55	103.66	800.0
2005-10-17 07:00:00	GLD	ETF	46.95	46.95	46.95	46.95	2500.0
2005-10-17 08:00:00	GLD	ETF	47.0	47.31	46.95	47.31	133100.0
2005-10-17 09:00:00	GLD	ETF	47.3	47.37	47.15	47.26	417500.0
2005-10-17 10:00:00	GLD	ETF	47.26	47.35	47.21	47.33	243300.0
2005-10-17 11:00:00	GLD	ETF	47.32	47.34	47.25	47.33	133300.0
2005-10-17 12:00:00	GLD	ETF	47.34	47.37	47.25	47.3	277100.0
2005-10-17 13:00:00	GLD	ETF	47.29	47.29	47.2101	47.22	338400.0

> showing 50 of 992 rows — these rows as CSV

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