PREVIEW / etf_1hour / 2005-06-09

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-06-09.parquet
  size:    30 KB
  rows:    882

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
2005-06-09 07:00:00	SPY	ETF	119.68	119.88	119.68	119.85	3600.0
2005-06-09 08:00:00	SPY	ETF	119.83	119.96	119.8	119.8	105500.0
2005-06-09 09:00:00	SPY	ETF	119.8	119.8	119.54	119.69	5656500.0
2005-06-09 10:00:00	SPY	ETF	119.71	120.0	119.44	119.78	16555700.0
2005-06-09 11:00:00	SPY	ETF	119.75	120.25	119.62	120.15	10584400.0
2005-06-09 12:00:00	SPY	ETF	120.16	120.58	120.15	120.42	6684200.0
2005-06-09 13:00:00	SPY	ETF	120.42	120.46	120.07	120.29	4959500.0
2005-06-09 14:00:00	SPY	ETF	120.28	120.37	119.99	120.32	4628600.0
2005-06-09 15:00:00	SPY	ETF	120.32	120.52	120.26	120.49	5139100.0
2005-06-09 16:00:00	SPY	ETF	120.49	120.5	120.31	120.4	1528300.0
2005-06-09 17:00:00	SPY	ETF	120.4	120.47	120.4	120.47	203600.0
2005-06-09 18:00:00	SPY	ETF	120.45	120.48	120.42	120.45	4300.0
2005-06-09 19:00:00	SPY	ETF	120.42	120.42	120.4	120.42	4500.0
2005-06-09 09:00:00	QQQ	ETF	37.66	37.7	37.61	37.65	7775500.0
2005-06-09 10:00:00	QQQ	ETF	37.65	37.72	37.5	37.62	22251600.0
2005-06-09 11:00:00	QQQ	ETF	37.62	37.74	37.55	37.74	10581300.0
2005-06-09 12:00:00	QQQ	ETF	37.74	38.06	37.73	37.98	21479000.0
2005-06-09 13:00:00	QQQ	ETF	37.97	37.97	37.81	37.9	9265400.0
2005-06-09 14:00:00	QQQ	ETF	37.9	37.94	37.55	37.88	8351400.0
2005-06-09 15:00:00	QQQ	ETF	37.88	37.98	37.86	37.96	10155000.0
2005-06-09 08:00:00	IWM	ETF	61.77	61.77	61.72	61.72	26500.0
2005-06-09 09:00:00	IWM	ETF	61.7	61.7	61.41	61.49	1554400.0
2005-06-09 10:00:00	IWM	ETF	61.49	61.71	61.36	61.62	4125900.0
2005-06-09 11:00:00	IWM	ETF	61.62	61.9	61.55	61.86	3521600.0
2005-06-09 12:00:00	IWM	ETF	61.87	62.27	61.87	62.22	4070600.0
2005-06-09 13:00:00	IWM	ETF	62.22	62.23	61.99	62.15	1522800.0
2005-06-09 14:00:00	IWM	ETF	62.15	62.24	61.95	62.2	1580700.0
2005-06-09 15:00:00	IWM	ETF	62.2	62.4	62.18	62.39	3923500.0
2005-06-09 16:00:00	IWM	ETF	62.38	62.42	62.18	62.27	694100.0
2005-06-09 17:00:00	IWM	ETF	62.29	62.29	62.27	62.27	400200.0
2005-06-09 07:00:00	DIA	ETF	104.68	104.81	104.68	104.81	600.0
2005-06-09 08:00:00	DIA	ETF	104.77	104.86	104.71	104.71	2500.0
2005-06-09 09:00:00	DIA	ETF	104.68	104.73	104.5	104.59	323700.0
2005-06-09 10:00:00	DIA	ETF	104.58	104.82	104.38	104.6	1362400.0
2005-06-09 11:00:00	DIA	ETF	104.61	104.98	104.5	104.92	495800.0
2005-06-09 12:00:00	DIA	ETF	104.93	105.24	104.92	105.12	600800.0
2005-06-09 13:00:00	DIA	ETF	105.13	105.13	104.77	104.972	313900.0
2005-06-09 14:00:00	DIA	ETF	104.96	104.99	104.67	104.92	415100.0
2005-06-09 15:00:00	DIA	ETF	104.91	105.07	104.88	105.02	521100.0
2005-06-09 16:00:00	DIA	ETF	105.01	105.03	104.6	105.03	11000.0
2005-06-09 17:00:00	DIA	ETF	104.98	104.98	104.98	104.98	100.0
2005-06-09 08:00:00	GLD	ETF	42.32	42.38	42.25	42.25	78900.0
2005-06-09 09:00:00	GLD	ETF	42.24	42.27	42.21	42.23	38000.0
2005-06-09 10:00:00	GLD	ETF	42.21	42.24	42.03	42.11	210900.0
2005-06-09 11:00:00	GLD	ETF	42.1	42.3	42.1	42.3	113400.0
2005-06-09 12:00:00	GLD	ETF	42.28	42.4	42.26	42.38	94400.0
2005-06-09 13:00:00	GLD	ETF	42.39	42.39	42.26	42.27	50100.0
2005-06-09 14:00:00	GLD	ETF	42.27	42.3	42.26	42.27	17000.0
2005-06-09 15:00:00	GLD	ETF	42.27	42.28	42.23	42.27	71700.0
2005-06-09 16:00:00	GLD	ETF	42.25	42.28	42.21	42.25	13200.0

> showing 50 of 882 rows — these rows as CSV

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