PREVIEW / etf_1hour / 2005-10-19

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-10-19.parquet
  size:    34 KB
  rows:    1,005

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-19 04:00:00	SPY	ETF	117.36	117.36	117.36	117.36	800.0
2005-10-19 06:00:00	SPY	ETF	117.51	117.52	117.4	117.4	26000.0
2005-10-19 07:00:00	SPY	ETF	117.38	117.38	117.14	117.28	132600.0
2005-10-19 08:00:00	SPY	ETF	117.33	117.47	117.11	117.39	1420500.0
2005-10-19 09:00:00	SPY	ETF	117.37	117.75	117.12	117.42	12872500.0
2005-10-19 10:00:00	SPY	ETF	117.43	118.08	117.28	117.82	29895500.0
2005-10-19 11:00:00	SPY	ETF	117.853	117.96	117.3	117.39	14004900.0
2005-10-19 12:00:00	SPY	ETF	117.4	117.96	117.37	117.75	9964300.0
2005-10-19 13:00:00	SPY	ETF	117.74	118.22	117.54	118.17	8476300.0
2005-10-19 14:00:00	SPY	ETF	118.18	119.02	118.1	118.92	15099400.0
2005-10-19 15:00:00	SPY	ETF	118.92	119.66	118.9	119.62	15609900.0
2005-10-19 16:00:00	SPY	ETF	119.61	119.79	119.6	119.65	4977700.0
2005-10-19 17:00:00	SPY	ETF	119.66	119.73	119.61	119.64	131100.0
2005-10-19 18:00:00	SPY	ETF	119.7	119.73	119.66	119.71	8400.0
2005-10-19 19:00:00	SPY	ETF	119.66	119.71	119.64	119.69	4900.0
2005-10-19 09:00:00	QQQ	ETF	37.75	37.79	37.61	37.76	14891600.0
2005-10-19 10:00:00	QQQ	ETF	37.76	38.05	37.68	37.86	30742600.0
2005-10-19 11:00:00	QQQ	ETF	37.86	37.9	37.72	37.75	11121300.0
2005-10-19 12:00:00	QQQ	ETF	37.76	38.01	37.74	37.91	12021700.0
2005-10-19 13:00:00	QQQ	ETF	37.91	38.03	37.81	38.03	9045900.0
2005-10-19 14:00:00	QQQ	ETF	38.03	38.44	37.98	38.39	27573800.0
2005-10-19 15:00:00	QQQ	ETF	38.38	38.67	38.38	38.67	18329700.0
2005-10-19 07:00:00	IWM	ETF	61.78	61.81	61.78	61.8	7900.0
2005-10-19 08:00:00	IWM	ETF	61.89	61.98	61.69	61.82	118400.0
2005-10-19 09:00:00	IWM	ETF	61.9	62.05	61.51	61.64	4555200.0
2005-10-19 10:00:00	IWM	ETF	61.62	62.06	61.38	61.81	10330900.0
2005-10-19 11:00:00	IWM	ETF	61.8	61.81	61.38	61.43	2811100.0
2005-10-19 12:00:00	IWM	ETF	61.43	61.95	61.43	61.78	5120200.0
2005-10-19 13:00:00	IWM	ETF	61.7812	62.39	61.65	62.35	4688100.0
2005-10-19 14:00:00	IWM	ETF	62.36	62.99	62.25	62.86	7280400.0
2005-10-19 15:00:00	IWM	ETF	62.86	63.49	62.86	63.43	7040500.0
2005-10-19 16:00:00	IWM	ETF	63.41	63.5	63.37	63.39	184300.0
2005-10-19 17:00:00	IWM	ETF	63.4	63.55	63.4	63.51	4000.0
2005-10-19 18:00:00	IWM	ETF	63.42	63.5	63.42	63.5	200.0
2005-10-19 19:00:00	IWM	ETF	63.47	63.47	63.47	63.47	4300.0
2005-10-19 07:00:00	DIA	ETF	102.44	102.45	102.31	102.31	2200.0
2005-10-19 08:00:00	DIA	ETF	102.34	102.66	102.34	102.52	22600.0
2005-10-19 09:00:00	DIA	ETF	102.57	102.68	102.36	102.64	1150400.0
2005-10-19 10:00:00	DIA	ETF	102.64	103.25	102.53	103.07	1950000.0
2005-10-19 11:00:00	DIA	ETF	103.07	103.14	102.6	102.67	1111600.0
2005-10-19 12:00:00	DIA	ETF	102.67	103.17	102.67	102.95	2877800.0
2005-10-19 13:00:00	DIA	ETF	102.95	103.23	102.77	103.18	1145600.0
2005-10-19 14:00:00	DIA	ETF	103.19	103.69	103.1	103.63	2075800.0
2005-10-19 15:00:00	DIA	ETF	103.63	104.14	103.61	104.11	1603200.0
2005-10-19 16:00:00	DIA	ETF	104.16	104.33	104.1	104.27	231300.0
2005-10-19 17:00:00	DIA	ETF	104.25	104.26	104.25	104.26	400.0
2005-10-19 18:00:00	DIA	ETF	104.29	104.3	104.25	104.25	900.0
2005-10-19 19:00:00	DIA	ETF	104.25	104.31	104.25	104.31	800.0
2005-10-19 07:00:00	GLD	ETF	46.82	46.82	46.82	46.82	200.0
2005-10-19 08:00:00	GLD	ETF	46.7	46.7	46.5	46.53	3300.0

> showing 50 of 1,005 rows — these rows as CSV

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