PREVIEW / etf_1hour / 2005-05-10

all etf 1-hour files

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

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-10 05:00:00	SPY	ETF	117.71	117.71	117.7	117.7	10300.0
2005-05-10 07:00:00	SPY	ETF	117.59	117.62	117.53	117.58	135900.0
2005-05-10 08:00:00	SPY	ETF	117.6	117.6	117.36	117.36	294400.0
2005-05-10 09:00:00	SPY	ETF	117.38	117.41	117.15	117.21	6076500.0
2005-05-10 10:00:00	SPY	ETF	117.21	117.3	116.95	117.06	9567500.0
2005-05-10 11:00:00	SPY	ETF	117.05	117.25	116.82	116.86	7599800.0
2005-05-10 12:00:00	SPY	ETF	116.89	117.3	116.8	117.23	8109500.0
2005-05-10 13:00:00	SPY	ETF	117.23	117.5	117.07	117.34	6895300.0
2005-05-10 14:00:00	SPY	ETF	117.35	117.42	116.55	116.64	13947000.0
2005-05-10 15:00:00	SPY	ETF	116.64	116.78	116.39	116.69	14986300.0
2005-05-10 16:00:00	SPY	ETF	116.69	117.1793	116.59	116.7	4093100.0
2005-05-10 17:00:00	SPY	ETF	116.67	116.67	116.43	116.54	57700.0
2005-05-10 18:00:00	SPY	ETF	116.53	116.64	116.53	116.64	17200.0
2005-05-10 19:00:00	SPY	ETF	116.6	116.64	116.58	116.64	800.0
2005-05-10 09:00:00	QQQ	ETF	35.86	35.88	35.78	35.82	9908200.0
2005-05-10 10:00:00	QQQ	ETF	35.83	35.86	35.74	35.79	11831400.0
2005-05-10 11:00:00	QQQ	ETF	35.78	35.85	35.72	35.74	7851600.0
2005-05-10 12:00:00	QQQ	ETF	35.74	35.9	35.73	35.87	8949100.0
2005-05-10 13:00:00	QQQ	ETF	35.88	35.96	35.84	35.92	6344500.0
2005-05-10 14:00:00	QQQ	ETF	35.92	35.93	35.65	35.68	11369300.0
2005-05-10 15:00:00	QQQ	ETF	35.67	35.75	35.62	35.74	16041500.0
2005-05-10 08:00:00	IWM	ETF	59.74	59.74	59.54	59.54	43800.0
2005-05-10 09:00:00	IWM	ETF	59.56	59.65	59.33	59.41	3141400.0
2005-05-10 10:00:00	IWM	ETF	59.41	59.92	59.34	59.435	5664600.0
2005-05-10 11:00:00	IWM	ETF	59.435	59.525	59.17	59.245	2657000.0
2005-05-10 12:00:00	IWM	ETF	59.25	59.435	59.21	59.39	2468400.0
2005-05-10 13:00:00	IWM	ETF	59.38	59.605	59.345	59.465	2035800.0
2005-05-10 14:00:00	IWM	ETF	59.46	59.5	59.095	59.105	5000600.0
2005-05-10 15:00:00	IWM	ETF	59.105	59.195	59.015	59.175	6390400.0
2005-05-10 16:00:00	IWM	ETF	59.17	59.36	59.17	59.255	1984800.0
2005-05-10 17:00:00	IWM	ETF	59.225	59.225	59.15	59.15	10000.0
2005-05-10 18:00:00	IWM	ETF	59.22	59.22	59.22	59.22	400.0
2005-05-10 07:00:00	DIA	ETF	103.55	103.56	103.55	103.56	3600.0
2005-05-10 08:00:00	DIA	ETF	103.56	103.56	103.43	103.43	21100.0
2005-05-10 09:00:00	DIA	ETF	103.39	103.44	103.28	103.32	915100.0
2005-05-10 10:00:00	DIA	ETF	103.3	103.38	103.07	103.14	1010400.0
2005-05-10 11:00:00	DIA	ETF	103.13	103.28	102.94	103.01	361700.0
2005-05-10 12:00:00	DIA	ETF	103.02	103.33	102.98	103.23	523200.0
2005-05-10 13:00:00	DIA	ETF	103.25	103.49	103.13	103.36	469900.0
2005-05-10 14:00:00	DIA	ETF	103.37	103.43	102.69	102.71	1602900.0
2005-05-10 15:00:00	DIA	ETF	102.71	102.86	102.5	102.794	1905900.0
2005-05-10 16:00:00	DIA	ETF	102.8	103.82	102.76	102.83	66000.0
2005-05-10 17:00:00	DIA	ETF	102.73	102.73	102.55	102.55	1700.0
2005-05-10 18:00:00	DIA	ETF	102.57	102.7	102.57	102.7	600.0
2005-05-10 09:00:00	GLD	ETF	42.71	42.72	42.66	42.67	63600.0
2005-05-10 10:00:00	GLD	ETF	42.67	42.74	42.65	42.72	86400.0
2005-05-10 11:00:00	GLD	ETF	42.71	42.74	42.7	42.74	33300.0
2005-05-10 12:00:00	GLD	ETF	42.74	42.79	42.72	42.74	86200.0
2005-05-10 13:00:00	GLD	ETF	42.74	42.74	42.62	42.67	61800.0
2005-05-10 14:00:00	GLD	ETF	42.67	42.68	42.58	42.63	63900.0

> showing 50 of 874 rows — these rows as CSV

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