PREVIEW / etf_1hour / 2006-12-22

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-12-22.parquet
  size:    57 KB
  rows:    1,799

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-12-22 04:00:00	SPY	ETF	141.7	141.7	141.7	141.7	2700.0
2006-12-22 05:00:00	SPY	ETF	141.69	141.69	141.69	141.69	1600.0
2006-12-22 07:00:00	SPY	ETF	141.76	141.76	141.76	141.76	2900.0
2006-12-22 08:00:00	SPY	ETF	141.67	141.82	141.55	141.74	1309100.0
2006-12-22 09:00:00	SPY	ETF	141.76	141.78	140.92	141.17	13937900.0
2006-12-22 10:00:00	SPY	ETF	141.17	141.5	141.01	141.25	11114200.0
2006-12-22 11:00:00	SPY	ETF	141.27	141.31	140.92	140.93	6660100.0
2006-12-22 12:00:00	SPY	ETF	140.93	141.29	140.78	140.98	10626300.0
2006-12-22 13:00:00	SPY	ETF	140.97	141.06	140.8	141.04	3066500.0
2006-12-22 14:00:00	SPY	ETF	141.04	141.11	140.94	141.06	2978800.0
2006-12-22 15:00:00	SPY	ETF	141.05	141.2	140.85	140.85	6925600.0
2006-12-22 16:00:00	SPY	ETF	140.83	140.9303	140.65	140.73	4146900.0
2006-12-22 17:00:00	SPY	ETF	140.71	140.71	140.68	140.7	15500.0
2006-12-22 18:00:00	SPY	ETF	140.67	140.7	140.67	140.7	4200.0
2006-12-22 19:00:00	SPY	ETF	140.68	140.74	140.68	140.74	900.0
2006-12-22 09:00:00	QQQ	ETF	43.38	43.41	43.04	43.21	20961100.0
2006-12-22 10:00:00	QQQ	ETF	43.19	43.39	43.14	43.16	19088600.0
2006-12-22 11:00:00	QQQ	ETF	43.16	43.22	43.05	43.05	12867600.0
2006-12-22 12:00:00	QQQ	ETF	43.05	43.1	42.95	43.06	12555500.0
2006-12-22 13:00:00	QQQ	ETF	43.06	43.11	42.99	43.07	5523100.0
2006-12-22 14:00:00	QQQ	ETF	43.07	43.13	43.0	43.08	5030700.0
2006-12-22 15:00:00	QQQ	ETF	43.08	43.98	42.95	42.95	10852400.0
2006-12-22 08:00:00	IWM	ETF	77.69	77.69	77.58	77.67	28300.0
2006-12-22 09:00:00	IWM	ETF	77.67	77.7	77.05	77.4	7034200.0
2006-12-22 10:00:00	IWM	ETF	77.4	77.75	77.28	77.49	7621300.0
2006-12-22 11:00:00	IWM	ETF	77.49	77.56	77.29	77.29	3800600.0
2006-12-22 12:00:00	IWM	ETF	77.28	77.49	77.24	77.35	3761900.0
2006-12-22 13:00:00	IWM	ETF	77.36	77.6104	77.28	77.44	3222200.0
2006-12-22 14:00:00	IWM	ETF	77.44	77.46	77.34	77.42	1380900.0
2006-12-22 15:00:00	IWM	ETF	77.41	77.55	77.35	77.38	3210000.0
2006-12-22 16:00:00	IWM	ETF	77.35	77.35	77.1	77.1	722500.0
2006-12-22 08:00:00	DIA	ETF	124.15	124.15	123.99	124.15	2500.0
2006-12-22 09:00:00	DIA	ETF	124.08	124.11	123.46	123.51	1157700.0
2006-12-22 10:00:00	DIA	ETF	123.48	124.24	123.34	123.58	1415400.0
2006-12-22 11:00:00	DIA	ETF	123.59	123.63	123.34	123.36	1014800.0
2006-12-22 12:00:00	DIA	ETF	123.36	123.55	123.22	123.45	1097100.0
2006-12-22 13:00:00	DIA	ETF	123.45	123.45	123.28	123.4	452600.0
2006-12-22 14:00:00	DIA	ETF	123.4	123.49	123.32	123.45	584300.0
2006-12-22 15:00:00	DIA	ETF	123.44	123.56	123.31	123.32	1023100.0
2006-12-22 16:00:00	DIA	ETF	123.32	123.32	123.18	123.18	16500.0
2006-12-22 17:00:00	DIA	ETF	123.18	123.18	123.12	123.15	500.0
2006-12-22 19:00:00	DIA	ETF	123.29	123.29	123.29	123.29	300.0
2006-12-22 08:00:00	GLD	ETF	61.47	61.58	61.4	61.42	80900.0
2006-12-22 09:00:00	GLD	ETF	61.45	61.49	61.38	61.3976	228400.0
2006-12-22 10:00:00	GLD	ETF	61.41	61.47	61.32	61.34	177900.0
2006-12-22 11:00:00	GLD	ETF	61.35	61.459	61.3412	61.44	174800.0
2006-12-22 12:00:00	GLD	ETF	61.44	61.52	61.4	61.45	181300.0
2006-12-22 13:00:00	GLD	ETF	61.48	61.69	61.45	61.57	176600.0
2006-12-22 14:00:00	GLD	ETF	61.59	61.8	61.5	61.59	119200.0
2006-12-22 15:00:00	GLD	ETF	61.542	61.78	61.42	61.66	224700.0

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

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