PREVIEW / etf_1hour / 2006-09-06

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-09-06.parquet
  size:    51 KB
  rows:    1,631

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-09-06 06:00:00	SPY	ETF	131.45	131.45	131.25	131.25	14400.0
2006-09-06 07:00:00	SPY	ETF	131.27	131.41	131.25	131.32	227400.0
2006-09-06 08:00:00	SPY	ETF	131.45	131.67	131.1	131.13	1927500.0
2006-09-06 09:00:00	SPY	ETF	131.13	131.67	130.94	130.99	7035100.0
2006-09-06 10:00:00	SPY	ETF	130.99	131.13	130.83	130.91	6753000.0
2006-09-06 11:00:00	SPY	ETF	130.92	131.03	130.75	130.76	6829600.0
2006-09-06 12:00:00	SPY	ETF	130.76	130.93	130.71	130.88	4687800.0
2006-09-06 13:00:00	SPY	ETF	130.88	131.03	130.78	130.93	2921200.0
2006-09-06 14:00:00	SPY	ETF	130.93	131.0	130.4	130.5	10153700.0
2006-09-06 15:00:00	SPY	ETF	130.48	130.57	130.33	130.42	11139300.0
2006-09-06 16:00:00	SPY	ETF	130.43	130.55	130.4	130.51	755700.0
2006-09-06 17:00:00	SPY	ETF	130.47	130.47	130.38	130.41	35800.0
2006-09-06 18:00:00	SPY	ETF	130.41	130.41	130.38	130.38	55000.0
2006-09-06 19:00:00	SPY	ETF	130.46	130.46	130.46	130.46	1500.0
2006-09-06 09:00:00	QQQ	ETF	39.09	39.17	39.02	39.11	10506500.0
2006-09-06 10:00:00	QQQ	ETF	39.1	39.19	38.99	39.06	14432800.0
2006-09-06 11:00:00	QQQ	ETF	39.06	39.12	38.89	38.89	12343700.0
2006-09-06 12:00:00	QQQ	ETF	38.89	38.99	38.86	38.95	8838800.0
2006-09-06 13:00:00	QQQ	ETF	38.95	39.03	38.91	38.99	5201500.0
2006-09-06 14:00:00	QQQ	ETF	38.98	39.02	38.71	38.74	13342900.0
2006-09-06 15:00:00	QQQ	ETF	38.75	38.77	38.61	38.68	20735400.0
2006-09-06 07:00:00	IWM	ETF	72.14	72.14	72.1	72.11	30400.0
2006-09-06 08:00:00	IWM	ETF	72.13	72.2	71.92	71.96	253200.0
2006-09-06 09:00:00	IWM	ETF	71.94	72.02	71.46	71.52	5257500.0
2006-09-06 10:00:00	IWM	ETF	71.52	71.72	71.27	71.37	4701500.0
2006-09-06 11:00:00	IWM	ETF	71.37	71.49	71.11	71.11	7435200.0
2006-09-06 12:00:00	IWM	ETF	71.12	71.3	71.07	71.23	3901400.0
2006-09-06 13:00:00	IWM	ETF	71.23	71.44	71.19	71.42	4615800.0
2006-09-06 14:00:00	IWM	ETF	71.42	71.45	71.01	71.06	3421400.0
2006-09-06 15:00:00	IWM	ETF	71.05	71.19	70.85	70.9	7007600.0
2006-09-06 16:00:00	IWM	ETF	70.91	70.93	70.83	70.84	635300.0
2006-09-06 17:00:00	IWM	ETF	70.84	70.89	70.84	70.89	18900.0
2006-09-06 07:00:00	DIA	ETF	114.45	114.45	114.42	114.42	1600.0
2006-09-06 08:00:00	DIA	ETF	114.42	114.45	114.3	114.32	13500.0
2006-09-06 09:00:00	DIA	ETF	114.29	114.38	114.19	114.27	726000.0
2006-09-06 10:00:00	DIA	ETF	114.27	114.38	114.15	114.23	705600.0
2006-09-06 11:00:00	DIA	ETF	114.23	114.34	114.17	114.18	459300.0
2006-09-06 12:00:00	DIA	ETF	114.19	114.34	114.11	114.32	349900.0
2006-09-06 13:00:00	DIA	ETF	114.3	114.44	114.23	114.36	222200.0
2006-09-06 14:00:00	DIA	ETF	114.35	114.4	114.02	114.06	564800.0
2006-09-06 15:00:00	DIA	ETF	114.05	114.14	113.97	114.1	1022200.0
2006-09-06 16:00:00	DIA	ETF	114.11	114.15	114.06	114.13	158300.0
2006-09-06 17:00:00	DIA	ETF	114.1	114.1	114.09	114.09	2700.0
2006-09-06 18:00:00	DIA	ETF	114.13	114.13	114.13	114.13	1000.0
2006-09-06 19:00:00	DIA	ETF	114.13	114.13	114.1	114.1	1000.0
2006-09-06 06:00:00	GLD	ETF	63.45	63.45	63.45	63.45	100.0
2006-09-06 08:00:00	GLD	ETF	63.21	63.33	63.0	63.26	147800.0
2006-09-06 09:00:00	GLD	ETF	63.29	63.33	63.12	63.18	512800.0
2006-09-06 10:00:00	GLD	ETF	63.17	63.52	63.12	63.34	814300.0
2006-09-06 11:00:00	GLD	ETF	63.37	63.39	63.15	63.15	406700.0

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

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