PREVIEW / etf_1hour / 2006-09-01

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-09-01.parquet
  size:    50 KB
  rows:    1,608

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-01 07:00:00	SPY	ETF	130.86	130.86	130.84	130.84	69000.0
2006-09-01 08:00:00	SPY	ETF	130.87	131.17	130.75	131.03	3123900.0
2006-09-01 09:00:00	SPY	ETF	131.0	131.3	130.99	131.24	6554600.0
2006-09-01 10:00:00	SPY	ETF	131.23	131.29	130.84	131.17	11662700.0
2006-09-01 11:00:00	SPY	ETF	131.17	131.35	131.08	131.32	3998000.0
2006-09-01 12:00:00	SPY	ETF	131.32	131.57	131.23	131.53	6294100.0
2006-09-01 13:00:00	SPY	ETF	131.51	131.58	131.44	131.47	4350000.0
2006-09-01 14:00:00	SPY	ETF	131.46	131.52	131.26	131.4	4324700.0
2006-09-01 15:00:00	SPY	ETF	131.41	131.5	131.34	131.46	4569000.0
2006-09-01 16:00:00	SPY	ETF	131.46	131.49	131.41	131.49	2864200.0
2006-09-01 17:00:00	SPY	ETF	131.49	131.5	131.46	131.5	3100.0
2006-09-01 18:00:00	SPY	ETF	131.49	131.5	131.41	131.41	6100.0
2006-09-01 19:00:00	SPY	ETF	131.44	131.44	131.44	131.44	700.0
2006-09-01 20:00:00	SPY	ETF	131.41	131.41	131.41	131.41	200.0
2006-09-01 09:00:00	QQQ	ETF	39.07	39.21	39.03	39.11	12624000.0
2006-09-01 10:00:00	QQQ	ETF	39.12	39.12	38.9	39.06	18083100.0
2006-09-01 11:00:00	QQQ	ETF	39.06	39.13	39.0	39.11	6807800.0
2006-09-01 12:00:00	QQQ	ETF	39.11	39.17	39.08	39.16	5464900.0
2006-09-01 13:00:00	QQQ	ETF	39.16	39.2	39.08	39.13	5846600.0
2006-09-01 14:00:00	QQQ	ETF	39.14	39.15	39.03	39.08	6210100.0
2006-09-01 15:00:00	QQQ	ETF	39.08	39.13	39.05	39.08	8089400.0
2006-09-01 07:00:00	IWM	ETF	71.89	71.89	71.89	71.89	100.0
2006-09-01 08:00:00	IWM	ETF	71.77	72.18	71.77	72.04	1441200.0
2006-09-01 09:00:00	IWM	ETF	72.04	72.17	71.79	71.94	3751800.0
2006-09-01 10:00:00	IWM	ETF	71.93	71.94	71.46	71.71	5132100.0
2006-09-01 11:00:00	IWM	ETF	71.71	71.97	71.64	71.97	3258200.0
2006-09-01 12:00:00	IWM	ETF	71.96	72.14	71.88	72.11	3058400.0
2006-09-01 13:00:00	IWM	ETF	72.1	72.2	71.96	72.02	1730800.0
2006-09-01 14:00:00	IWM	ETF	72.02	72.02	71.77	71.85	2332100.0
2006-09-01 15:00:00	IWM	ETF	71.85	71.99	71.77	71.78	2453000.0
2006-09-01 16:00:00	IWM	ETF	71.78	72.3	71.77	71.99	514900.0
2006-09-01 17:00:00	IWM	ETF	72.01	72.01	71.99	71.99	500.0
2006-09-01 18:00:00	IWM	ETF	71.96	71.96	71.96	71.96	2800.0
2006-09-01 08:00:00	DIA	ETF	114.0	114.16	113.85	114.05	55600.0
2006-09-01 09:00:00	DIA	ETF	114.06	114.27	114.06	114.27	976200.0
2006-09-01 10:00:00	DIA	ETF	114.27	114.28	113.95	114.21	590600.0
2006-09-01 11:00:00	DIA	ETF	114.22	114.43	114.22	114.4	681700.0
2006-09-01 12:00:00	DIA	ETF	114.41	114.64	114.32	114.6	464400.0
2006-09-01 13:00:00	DIA	ETF	114.6	114.77	114.6	114.72	582200.0
2006-09-01 14:00:00	DIA	ETF	114.71	114.71	114.54	114.66	346700.0
2006-09-01 15:00:00	DIA	ETF	114.66	114.7	114.53	114.65	730000.0
2006-09-01 16:00:00	DIA	ETF	114.63	114.7	114.59	114.7	44400.0
2006-09-01 18:00:00	DIA	ETF	114.7	114.7	114.7	114.7	100.0
2006-09-01 07:00:00	GLD	ETF	62.08	62.08	62.04	62.04	1000.0
2006-09-01 08:00:00	GLD	ETF	62.08	62.12	61.79	61.88	80000.0
2006-09-01 09:00:00	GLD	ETF	61.91	61.96	61.48	61.7	966400.0
2006-09-01 10:00:00	GLD	ETF	61.7	61.91	61.64	61.88	400700.0
2006-09-01 11:00:00	GLD	ETF	61.85	62.1	61.8	62.06	277700.0
2006-09-01 12:00:00	GLD	ETF	62.07	62.23	61.99	62.13	515300.0
2006-09-01 13:00:00	GLD	ETF	62.14	62.15	62.0	62.09	376400.0

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

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