PREVIEW / etf_1hour / 2006-06-28

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-06-28.parquet
  size:    47 KB
  rows:    1,475

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-06-28 06:00:00	SPY	ETF	124.22	124.22	124.13	124.13	25100.0
2006-06-28 07:00:00	SPY	ETF	124.13	124.2	124.12	124.2	66700.0
2006-06-28 08:00:00	SPY	ETF	124.2	124.37	124.15	124.28	1357000.0
2006-06-28 09:00:00	SPY	ETF	124.28	124.35	124.02	124.1	7748100.0
2006-06-28 10:00:00	SPY	ETF	124.1	124.33	123.87	123.97	9298800.0
2006-06-28 11:00:00	SPY	ETF	123.98	124.06	123.65	123.95	7722400.0
2006-06-28 12:00:00	SPY	ETF	123.95	124.28	123.9	124.07	5468400.0
2006-06-28 13:00:00	SPY	ETF	124.07	124.19	123.9	124.05	3929800.0
2006-06-28 14:00:00	SPY	ETF	124.05	124.71	123.97	124.45	14290600.0
2006-06-28 15:00:00	SPY	ETF	124.44	124.62	124.34	124.58	9418800.0
2006-06-28 16:00:00	SPY	ETF	124.59	124.83	124.59	124.75	838600.0
2006-06-28 17:00:00	SPY	ETF	124.75	124.78	124.71	124.78	162400.0
2006-06-28 19:00:00	SPY	ETF	124.76	124.78	124.72	124.78	3100.0
2006-06-28 09:00:00	QQQ	ETF	37.64	37.65	37.46	37.54	13919100.0
2006-06-28 10:00:00	QQQ	ETF	37.55	37.65	37.44	37.52	16019200.0
2006-06-28 11:00:00	QQQ	ETF	37.52	37.55	37.38	37.48	10234100.0
2006-06-28 12:00:00	QQQ	ETF	37.47	37.62	37.45	37.53	7230400.0
2006-06-28 13:00:00	QQQ	ETF	37.53	37.58	37.49	37.56	4124000.0
2006-06-28 14:00:00	QQQ	ETF	37.55	37.84	37.53	37.72	16784000.0
2006-06-28 15:00:00	QQQ	ETF	37.73	37.81	37.71	37.8	17143900.0
2006-06-28 07:00:00	IWM	ETF	68.45	68.45	68.45	68.45	100.0
2006-06-28 08:00:00	IWM	ETF	68.42	68.58	68.42	68.5	150500.0
2006-06-28 09:00:00	IWM	ETF	68.5	68.55	67.96	68.23	4945900.0
2006-06-28 10:00:00	IWM	ETF	68.23	68.42	67.88	67.93	6020200.0
2006-06-28 11:00:00	IWM	ETF	67.92	67.94	67.5	67.77	11730600.0
2006-06-28 12:00:00	IWM	ETF	67.78	68.02	67.72	67.83	3477500.0
2006-06-28 13:00:00	IWM	ETF	67.83	67.97	67.7	67.82	2534100.0
2006-06-28 14:00:00	IWM	ETF	67.82	68.5	67.8	68.26	8093700.0
2006-06-28 15:00:00	IWM	ETF	68.25	68.41	68.11	68.4	6038000.0
2006-06-28 16:00:00	IWM	ETF	68.41	68.72	68.4	68.59	303900.0
2006-06-28 17:00:00	IWM	ETF	68.61	68.61	68.0372	68.6	1748700.0
2006-06-28 18:00:00	IWM	ETF	68.63	68.64	68.56	68.56	13200.0
2006-06-28 06:00:00	DIA	ETF	109.39	109.39	109.39	109.39	300.0
2006-06-28 08:00:00	DIA	ETF	109.55	109.57	109.5	109.51	2900.0
2006-06-28 09:00:00	DIA	ETF	109.55	109.62	109.26	109.35	489400.0
2006-06-28 10:00:00	DIA	ETF	109.35	109.5	109.16	109.24	633800.0
2006-06-28 11:00:00	DIA	ETF	109.24	109.29	108.97	109.18	510900.0
2006-06-28 12:00:00	DIA	ETF	109.18	109.35	109.081	109.18	335100.0
2006-06-28 13:00:00	DIA	ETF	109.18	109.31	109.11	109.28	231400.0
2006-06-28 14:00:00	DIA	ETF	109.27	109.73	109.18	109.58	1020300.0
2006-06-28 15:00:00	DIA	ETF	109.59	109.7	109.49	109.7	522100.0
2006-06-28 16:00:00	DIA	ETF	109.72	109.87	109.71	109.82	153100.0
2006-06-28 17:00:00	DIA	ETF	109.82	109.82	109.82	109.82	100.0
2006-06-28 18:00:00	DIA	ETF	109.75	109.75	109.75	109.75	500.0
2006-06-28 07:00:00	GLD	ETF	58.02	58.02	58.02	58.02	200.0
2006-06-28 08:00:00	GLD	ETF	58.08	58.29	58.05	58.19	168500.0
2006-06-28 09:00:00	GLD	ETF	58.2	58.22	57.87	58.01	742700.0
2006-06-28 10:00:00	GLD	ETF	58.01	58.14	57.35	57.6	571800.0
2006-06-28 11:00:00	GLD	ETF	57.62	58.04	57.51	57.89	432800.0
2006-06-28 12:00:00	GLD	ETF	57.89	57.96	57.71	57.88	250000.0

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

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