PREVIEW / etf_1hour / 2005-06-08

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-06-08.parquet
  size:    30 KB
  rows:    852

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-08 07:00:00	SPY	ETF	120.52	120.64	120.52	120.55	144700.0
2005-06-08 08:00:00	SPY	ETF	120.53	120.55	120.47	120.49	82600.0
2005-06-08 09:00:00	SPY	ETF	120.49	120.5	120.25	120.44	4159800.0
2005-06-08 10:00:00	SPY	ETF	120.44	120.56	120.13	120.52	9272600.0
2005-06-08 11:00:00	SPY	ETF	120.51	120.54	120.31	120.52	3157100.0
2005-06-08 12:00:00	SPY	ETF	120.51	120.59	120.41	120.58	2767200.0
2005-06-08 13:00:00	SPY	ETF	120.47	120.58	119.99	120.12	4907300.0
2005-06-08 14:00:00	SPY	ETF	120.11	120.15	119.71	119.74	9010100.0
2005-06-08 15:00:00	SPY	ETF	119.73	120.0809	119.67	119.85	10280300.0
2005-06-08 16:00:00	SPY	ETF	119.9	120.0	119.87	119.9	591900.0
2005-06-08 17:00:00	SPY	ETF	119.91	119.95	119.91	119.91	3004500.0
2005-06-08 18:00:00	SPY	ETF	119.92	119.92	119.86	119.91	2200.0
2005-06-08 19:00:00	SPY	ETF	119.88	119.88	119.86	119.86	1200.0
2005-06-08 09:00:00	QQQ	ETF	37.88	37.95	37.8	37.88	11029000.0
2005-06-08 10:00:00	QQQ	ETF	37.88	37.92	37.71	37.86	14731600.0
2005-06-08 11:00:00	QQQ	ETF	37.86	37.93	37.77	37.91	6239200.0
2005-06-08 12:00:00	QQQ	ETF	37.9	37.95	37.87	37.92	6521800.0
2005-06-08 13:00:00	QQQ	ETF	37.92	37.93	37.71	37.75	6570500.0
2005-06-08 14:00:00	QQQ	ETF	37.76	37.76	37.55	37.64	20302500.0
2005-06-08 15:00:00	QQQ	ETF	37.64	37.75	37.61	37.71	10046900.0
2005-06-08 08:00:00	IWM	ETF	62.295	62.295	62.29	62.29	4200.0
2005-06-08 09:00:00	IWM	ETF	62.24	62.37	62.1	62.315	2795600.0
2005-06-08 10:00:00	IWM	ETF	62.315	62.335	62.055	62.275	2426800.0
2005-06-08 11:00:00	IWM	ETF	62.265	62.315	62.185	62.315	1320800.0
2005-06-08 12:00:00	IWM	ETF	62.305	62.335	62.225	62.25	1825000.0
2005-06-08 13:00:00	IWM	ETF	62.245	62.265	61.875	61.955	1537000.0
2005-06-08 14:00:00	IWM	ETF	61.965	61.965	61.646	61.66	4252600.0
2005-06-08 15:00:00	IWM	ETF	61.66	61.785	61.625	61.665	3643400.0
2005-06-08 16:00:00	IWM	ETF	61.675	61.735	61.675	61.715	210800.0
2005-06-08 07:00:00	DIA	ETF	105.26	105.26	105.26	105.26	500.0
2005-06-08 08:00:00	DIA	ETF	105.32	105.32	105.28	105.32	2200.0
2005-06-08 09:00:00	DIA	ETF	105.27	105.27	105.08	105.24	460200.0
2005-06-08 10:00:00	DIA	ETF	105.24	105.26	104.98	105.25	604300.0
2005-06-08 11:00:00	DIA	ETF	105.24	105.26	105.11	105.25	206100.0
2005-06-08 12:00:00	DIA	ETF	105.25	105.41	105.21	105.29	576400.0
2005-06-08 13:00:00	DIA	ETF	105.29	105.3	104.8	104.91	1107900.0
2005-06-08 14:00:00	DIA	ETF	104.92	104.92	104.63	104.68	1079900.0
2005-06-08 15:00:00	DIA	ETF	104.66	104.87	104.57	104.78	1932000.0
2005-06-08 16:00:00	DIA	ETF	104.78	104.86	104.78	104.86	30400.0
2005-06-08 08:00:00	GLD	ETF	42.47	42.47	42.47	42.47	6900.0
2005-06-08 09:00:00	GLD	ETF	42.45	42.45	42.4	42.41	120100.0
2005-06-08 10:00:00	GLD	ETF	42.41	42.45	42.35	42.45	131300.0
2005-06-08 11:00:00	GLD	ETF	42.47	42.56	42.43	42.5	140400.0
2005-06-08 12:00:00	GLD	ETF	42.49	42.5	42.44	42.46	23100.0
2005-06-08 13:00:00	GLD	ETF	42.47	42.47	42.34	42.35	87200.0
2005-06-08 14:00:00	GLD	ETF	42.35	42.35	42.24	42.27	49000.0
2005-06-08 15:00:00	GLD	ETF	42.3	42.31	42.25	42.31	126800.0
2005-06-08 16:00:00	GLD	ETF	42.27	42.27	42.26	42.26	600.0
2005-06-08 09:00:00	TLT	ETF	96.31	96.38	96.27	96.37	36000.0
2005-06-08 10:00:00	TLT	ETF	96.37	96.43	96.32	96.39	376800.0

> showing 50 of 852 rows — these rows as CSV

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