PREVIEW / etf_1hour / 2006-11-13

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-11-13.parquet
  size:    56 KB
  rows:    1,774

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
2006-11-13 06:00:00	SPY	ETF	138.31	138.32	138.31	138.32	20000.0
2006-11-13 07:00:00	SPY	ETF	138.23	138.23	138.16	138.22	15000.0
2006-11-13 08:00:00	SPY	ETF	138.22	138.28	138.11	138.14	427600.0
2006-11-13 09:00:00	SPY	ETF	138.14	138.73	138.07	138.71	9529200.0
2006-11-13 10:00:00	SPY	ETF	138.71	139.04	138.68	138.87	12773600.0
2006-11-13 11:00:00	SPY	ETF	138.87	138.97	138.7	138.83	8071700.0
2006-11-13 12:00:00	SPY	ETF	138.83	138.94	138.56	138.58	4616300.0
2006-11-13 13:00:00	SPY	ETF	138.58	138.83	138.52	138.72	3972300.0
2006-11-13 14:00:00	SPY	ETF	138.72	138.91	138.65	138.86	5134600.0
2006-11-13 15:00:00	SPY	ETF	138.85	138.85	138.64	138.7	5629300.0
2006-11-13 16:00:00	SPY	ETF	138.7	138.7	138.56	138.56	1659300.0
2006-11-13 17:00:00	SPY	ETF	138.6	138.61	138.6	138.61	700.0
2006-11-13 18:00:00	SPY	ETF	138.61	138.63	138.55	138.63	15600.0
2006-11-13 19:00:00	SPY	ETF	138.65	138.65	138.62	138.62	800.0
2006-11-13 09:00:00	QQQ	ETF	43.05	43.41	43.0	43.39	14803000.0
2006-11-13 10:00:00	QQQ	ETF	43.39	43.54	42.42	43.41	20676400.0
2006-11-13 11:00:00	QQQ	ETF	43.4	43.47	43.3	43.4	8765000.0
2006-11-13 12:00:00	QQQ	ETF	43.4	43.46	43.3	43.3	6734700.0
2006-11-13 13:00:00	QQQ	ETF	43.3	43.41	43.28	43.37	6860300.0
2006-11-13 14:00:00	QQQ	ETF	43.37	43.47	43.32	43.44	5113200.0
2006-11-13 15:00:00	QQQ	ETF	43.45	43.5	43.35	43.47	13797000.0
2006-11-13 07:00:00	IWM	ETF	76.5	76.5	76.5	76.5	100.0
2006-11-13 08:00:00	IWM	ETF	76.45	76.5	76.35	76.4	13200.0
2006-11-13 09:00:00	IWM	ETF	76.39	76.81	76.2	76.77	3843600.0
2006-11-13 10:00:00	IWM	ETF	76.78	76.99	76.71	76.77	8376800.0
2006-11-13 11:00:00	IWM	ETF	76.77	76.9	76.47	76.64	7933400.0
2006-11-13 12:00:00	IWM	ETF	76.63	76.85	76.48	76.49	4589400.0
2006-11-13 13:00:00	IWM	ETF	76.49	76.78	76.43	76.69	2539600.0
2006-11-13 14:00:00	IWM	ETF	76.7	76.9	76.64	76.79	3995100.0
2006-11-13 15:00:00	IWM	ETF	76.78	76.88	76.58	76.77	6536400.0
2006-11-13 16:00:00	IWM	ETF	76.79	76.79	76.57	76.65	667900.0
2006-11-13 17:00:00	IWM	ETF	76.64	76.64	76.64	76.64	200.0
2006-11-13 08:00:00	DIA	ETF	121.1	121.15	121.1	121.12	5600.0
2006-11-13 09:00:00	DIA	ETF	121.13	121.47	120.98	121.46	800800.0
2006-11-13 10:00:00	DIA	ETF	121.46	121.78	121.44	121.69	1463100.0
2006-11-13 11:00:00	DIA	ETF	121.69	121.82	121.55	121.65	818000.0
2006-11-13 12:00:00	DIA	ETF	121.64	121.73	121.43	121.43	447400.0
2006-11-13 13:00:00	DIA	ETF	121.43	121.63	121.39	121.54	655700.0
2006-11-13 14:00:00	DIA	ETF	121.55	121.65	121.4	121.59	500900.0
2006-11-13 15:00:00	DIA	ETF	121.59	121.59	121.43	121.46	731000.0
2006-11-13 16:00:00	DIA	ETF	121.46	121.47	121.35	121.35	44000.0
2006-11-13 17:00:00	DIA	ETF	121.44	121.44	121.44	121.44	500.0
2006-11-13 19:00:00	DIA	ETF	121.43	121.43	121.43	121.43	100.0
2006-11-13 07:00:00	GLD	ETF	62.0	62.0	61.75	61.8	27300.0
2006-11-13 08:00:00	GLD	ETF	61.75	62.07	61.6	61.9	107800.0
2006-11-13 09:00:00	GLD	ETF	61.97	62.0	61.77	61.9	945500.0
2006-11-13 10:00:00	GLD	ETF	61.9	62.19	61.84	61.99	803500.0
2006-11-13 11:00:00	GLD	ETF	62.0	62.2	61.8	62.13	582300.0
2006-11-13 12:00:00	GLD	ETF	62.1374	62.14	61.96	62.06	259900.0
2006-11-13 13:00:00	GLD	ETF	62.06	62.08	61.96	62.04	227900.0

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

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