PREVIEW / etf_1hour / 2006-11-16

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-11-16.parquet
  size:    57 KB
  rows:    1,807

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-16 06:00:00	SPY	ETF	139.99	140.02	139.97	139.97	17400.0
2006-11-16 07:00:00	SPY	ETF	140.02	140.02	139.91	139.92	10200.0
2006-11-16 08:00:00	SPY	ETF	139.94	140.68	139.86	140.56	6965100.0
2006-11-16 09:00:00	SPY	ETF	140.55	140.6	140.19	140.39	8853100.0
2006-11-16 10:00:00	SPY	ETF	140.41	140.49	139.49	140.21	11585100.0
2006-11-16 11:00:00	SPY	ETF	140.2	140.39	140.15	140.3101	7260300.0
2006-11-16 12:00:00	SPY	ETF	140.31	140.5	140.25	140.32	6298200.0
2006-11-16 13:00:00	SPY	ETF	140.33	140.68	139.941	140.49	7794000.0
2006-11-16 14:00:00	SPY	ETF	140.49	140.66	140.25	140.37	7438100.0
2006-11-16 15:00:00	SPY	ETF	140.36	140.56	140.23	140.23	9917100.0
2006-11-16 16:00:00	SPY	ETF	140.23	140.41	140.2	140.25	2233100.0
2006-11-16 17:00:00	SPY	ETF	140.25	140.26	140.17	140.18	48100.0
2006-11-16 18:00:00	SPY	ETF	140.19	140.22	140.19	140.21	19900.0
2006-11-16 19:00:00	SPY	ETF	140.22	140.22	140.22	140.22	100.0
2006-11-16 09:00:00	QQQ	ETF	44.25	44.29	44.02	44.14	22717000.0
2006-11-16 10:00:00	QQQ	ETF	44.14	44.21	44.04	44.1	15802400.0
2006-11-16 11:00:00	QQQ	ETF	44.1	44.22	44.07	44.18	8013600.0
2006-11-16 12:00:00	QQQ	ETF	44.18	44.27	44.14	44.21	7063300.0
2006-11-16 13:00:00	QQQ	ETF	44.21	44.42	43.33	44.35	14757000.0
2006-11-16 14:00:00	QQQ	ETF	44.35	44.37	44.21	44.28	15084400.0
2006-11-16 15:00:00	QQQ	ETF	44.28	44.39	44.27	44.32	15434100.0
2006-11-16 07:00:00	IWM	ETF	78.7	78.7	78.62	78.63	31000.0
2006-11-16 08:00:00	IWM	ETF	78.64	79.25	78.6	79.2	2302000.0
2006-11-16 09:00:00	IWM	ETF	79.2	79.23	78.61	78.91	8689200.0
2006-11-16 10:00:00	IWM	ETF	78.91	78.92	78.45	78.49	7559900.0
2006-11-16 11:00:00	IWM	ETF	78.49	78.63	78.38	78.44	5954500.0
2006-11-16 12:00:00	IWM	ETF	78.44	78.76	78.41	78.55	4180900.0
2006-11-16 13:00:00	IWM	ETF	78.56	78.91	78.53	78.79	5965300.0
2006-11-16 14:00:00	IWM	ETF	78.79	78.79	78.48	78.51	3719300.0
2006-11-16 15:00:00	IWM	ETF	78.52	78.76	78.5	78.55	6698800.0
2006-11-16 16:00:00	IWM	ETF	78.56	78.64	78.45	78.54	2232000.0
2006-11-16 17:00:00	IWM	ETF	78.49	78.5	78.45	78.45	22000.0
2006-11-16 19:00:00	IWM	ETF	78.54	78.54	78.54	78.54	400.0
2006-11-16 08:00:00	DIA	ETF	122.67	123.26	122.65	123.15	111100.0
2006-11-16 09:00:00	DIA	ETF	123.1	123.13	122.89	123.06	1581500.0
2006-11-16 10:00:00	DIA	ETF	123.06	123.08	122.8	122.9	969100.0
2006-11-16 11:00:00	DIA	ETF	122.9	123.15	122.86	123.07	529900.0
2006-11-16 12:00:00	DIA	ETF	123.07	123.22	123.01	123.12	473200.0
2006-11-16 13:00:00	DIA	ETF	123.13	123.45	123.08	123.31	803100.0
2006-11-16 14:00:00	DIA	ETF	123.31	123.35	123.15	123.31	687100.0
2006-11-16 15:00:00	DIA	ETF	123.31	123.42	123.23	123.26	889300.0
2006-11-16 16:00:00	DIA	ETF	123.26	123.39	123.26	123.31	33500.0
2006-11-16 17:00:00	DIA	ETF	123.29	123.29	123.29	123.29	200.0
2006-11-16 07:00:00	GLD	ETF	62.18	62.18	62.18	62.18	800.0
2006-11-16 08:00:00	GLD	ETF	62.18	62.38	62.14	62.28	164500.0
2006-11-16 09:00:00	GLD	ETF	62.33	62.36	61.9	62.01	471600.0
2006-11-16 10:00:00	GLD	ETF	62.0	62.2988	61.81	61.8964	518500.0
2006-11-16 11:00:00	GLD	ETF	61.88	62.12	61.76	61.92	408200.0
2006-11-16 12:00:00	GLD	ETF	61.94	61.96	61.6	61.755	503700.0
2006-11-16 13:00:00	GLD	ETF	61.7588	61.85	61.44	61.68	687600.0

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

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