PREVIEW / etf_1hour / 2006-12-01

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-12-01.parquet
  size:    58 KB
  rows:    1,789

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-01 06:00:00	SPY	ETF	140.62	140.62	140.62	140.62	5000.0
2006-12-01 07:00:00	SPY	ETF	140.59	140.73	140.55	140.72	83000.0
2006-12-01 08:00:00	SPY	ETF	140.71	140.73	140.47	140.51	1036500.0
2006-12-01 09:00:00	SPY	ETF	140.53	140.66	140.43	140.46	6577100.0
2006-12-01 10:00:00	SPY	ETF	140.47	140.48	139.32	139.59	31992700.0
2006-12-01 11:00:00	SPY	ETF	139.59	140.37	139.58	140.31	14853500.0
2006-12-01 12:00:00	SPY	ETF	140.3	140.35	139.85	139.95	5968700.0
2006-12-01 13:00:00	SPY	ETF	139.95	139.95	139.43	139.67	13296300.0
2006-12-01 14:00:00	SPY	ETF	139.66	139.71	138.97	139.26	23922900.0
2006-12-01 15:00:00	SPY	ETF	139.27	140.09	139.2	140.06	14408800.0
2006-12-01 16:00:00	SPY	ETF	140.05	140.4703	139.92	140.25	3474100.0
2006-12-01 17:00:00	SPY	ETF	140.25	140.39	140.21	140.39	206500.0
2006-12-01 18:00:00	SPY	ETF	140.34	140.41	140.28	140.35	16200.0
2006-12-01 19:00:00	SPY	ETF	140.35	140.35	140.35	140.35	700.0
2006-12-01 09:00:00	QQQ	ETF	44.01	44.2	43.86	43.88	9539500.0
2006-12-01 10:00:00	QQQ	ETF	43.88	43.9	43.34	43.53	45029200.0
2006-12-01 11:00:00	QQQ	ETF	43.53	43.75	43.49	43.7	18116200.0
2006-12-01 12:00:00	QQQ	ETF	43.7	43.74	43.54	43.58	9894300.0
2006-12-01 13:00:00	QQQ	ETF	43.57	43.58	43.35	43.44	16472100.0
2006-12-01 14:00:00	QQQ	ETF	43.44	44.35	31.36	43.37	18521800.0
2006-12-01 15:00:00	QQQ	ETF	43.37	43.66	43.34	43.66	19157000.0
2006-12-01 07:00:00	IWM	ETF	78.1	78.2	78.1	78.16	22000.0
2006-12-01 08:00:00	IWM	ETF	78.16	78.2	76.32	78.15	129500.0
2006-12-01 09:00:00	IWM	ETF	78.12	78.37	77.95	77.96	3925100.0
2006-12-01 10:00:00	IWM	ETF	77.96	77.98	77.06	77.31	17273300.0
2006-12-01 11:00:00	IWM	ETF	77.31	77.69	77.07	77.59	9827600.0
2006-12-01 12:00:00	IWM	ETF	77.6	77.68	77.44	77.48	3847700.0
2006-12-01 13:00:00	IWM	ETF	77.47	77.47	76.85	77.04	16163900.0
2006-12-01 14:00:00	IWM	ETF	77.04	77.31	76.86	77.05	23265100.0
2006-12-01 15:00:00	IWM	ETF	77.06	77.79	77.0	77.63	9747400.0
2006-12-01 16:00:00	IWM	ETF	77.62	77.95	77.62	77.8	1108400.0
2006-12-01 17:00:00	IWM	ETF	77.8	77.84	77.7	77.7	4100.0
2006-12-01 18:00:00	IWM	ETF	77.84	77.84	77.84	77.84	8500.0
2006-12-01 08:00:00	DIA	ETF	122.41	122.43	122.34	122.35	4600.0
2006-12-01 09:00:00	DIA	ETF	122.34	122.46	122.23	122.23	895300.0
2006-12-01 10:00:00	DIA	ETF	122.24	122.25	121.21	121.42	5126100.0
2006-12-01 11:00:00	DIA	ETF	121.42	122.13	121.41	122.04	2477400.0
2006-12-01 12:00:00	DIA	ETF	122.04	122.08	121.6	121.66	689000.0
2006-12-01 13:00:00	DIA	ETF	121.66	121.67	121.28	121.45	1056600.0
2006-12-01 14:00:00	DIA	ETF	121.47	121.52	120.9	121.09	1604300.0
2006-12-01 15:00:00	DIA	ETF	121.09	121.94	121.05	121.93	2192600.0
2006-12-01 16:00:00	DIA	ETF	121.93	122.04	121.86	122.02	316000.0
2006-12-01 17:00:00	DIA	ETF	122.05	122.1	122.0	122.1	23900.0
2006-12-01 19:00:00	DIA	ETF	122.03	122.03	122.03	122.03	100.0
2006-12-01 07:00:00	GLD	ETF	64.0	64.0	64.0	64.0	900.0
2006-12-01 08:00:00	GLD	ETF	64.01	64.1	63.92	64.05	34200.0
2006-12-01 09:00:00	GLD	ETF	64.1	64.23	64.08	64.14	1066500.0
2006-12-01 10:00:00	GLD	ETF	64.13	64.55	64.13	64.41	2131700.0
2006-12-01 11:00:00	GLD	ETF	64.42	64.43	64.14	64.14	983100.0
2006-12-01 12:00:00	GLD	ETF	64.13	64.22	64.02	64.21	507200.0

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

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