PREVIEW / etf_1hour / 2005-05-17

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-17.parquet
  size:    30 KB
  rows:    865

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-05-17 04:00:00	SPY	ETF	116.47	116.47	116.47	116.47	7100.0
2005-05-17 07:00:00	SPY	ETF	116.41	116.47	116.31	116.42	336900.0
2005-05-17 08:00:00	SPY	ETF	116.4	116.56	116.34	116.43	953200.0
2005-05-17 09:00:00	SPY	ETF	116.43	116.68	116.36	116.66	7902400.0
2005-05-17 10:00:00	SPY	ETF	116.66	116.73	116.16	116.32	10584400.0
2005-05-17 11:00:00	SPY	ETF	116.33	116.74	116.26	116.6	5491800.0
2005-05-17 12:00:00	SPY	ETF	116.6	116.64	116.33	116.35	3419500.0
2005-05-17 13:00:00	SPY	ETF	116.36	116.64	116.3	116.52	4052900.0
2005-05-17 14:00:00	SPY	ETF	116.53	117.44	116.43	117.3	14113200.0
2005-05-17 15:00:00	SPY	ETF	117.29	117.7	117.2	117.57	10879300.0
2005-05-17 16:00:00	SPY	ETF	117.55	117.66	117.53	117.57	1634700.0
2005-05-17 17:00:00	SPY	ETF	117.57	117.64	117.57	117.58	150200.0
2005-05-17 18:00:00	SPY	ETF	117.58	117.58	117.56	117.56	600.0
2005-05-17 19:00:00	SPY	ETF	117.6	117.6	117.55	117.55	4800.0
2005-05-17 09:00:00	QQQ	ETF	36.35	36.46	36.32	36.46	10841500.0
2005-05-17 10:00:00	QQQ	ETF	36.45	36.47	36.21	36.31	21583300.0
2005-05-17 11:00:00	QQQ	ETF	36.31	36.45	36.29	36.4	9998700.0
2005-05-17 12:00:00	QQQ	ETF	36.4	36.4	36.3	36.32	4029400.0
2005-05-17 13:00:00	QQQ	ETF	36.32	36.41	36.3	36.4	5684900.0
2005-05-17 14:00:00	QQQ	ETF	36.4	36.64	36.36	36.61	16664100.0
2005-05-17 15:00:00	QQQ	ETF	36.61	36.74	36.58	36.7	18501700.0
2005-05-17 07:00:00	IWM	ETF	58.74	58.74	58.725	58.725	28200.0
2005-05-17 08:00:00	IWM	ETF	58.73	58.825	58.7	58.78	130400.0
2005-05-17 09:00:00	IWM	ETF	58.77	58.895	58.615	58.86	1280800.0
2005-05-17 10:00:00	IWM	ETF	58.865	58.9	58.435	58.52	4040000.0
2005-05-17 11:00:00	IWM	ETF	58.51	58.8	58.42	58.74	2819000.0
2005-05-17 12:00:00	IWM	ETF	58.73	58.75	58.505	58.545	1005200.0
2005-05-17 13:00:00	IWM	ETF	58.55	58.79	58.515	58.71	1145000.0
2005-05-17 14:00:00	IWM	ETF	58.715	59.255	58.64	59.155	5702200.0
2005-05-17 15:00:00	IWM	ETF	59.15	59.335	59.09	59.275	5251800.0
2005-05-17 16:00:00	IWM	ETF	59.28	59.355	59.25	59.335	518400.0
2005-05-17 07:00:00	DIA	ETF	102.4	102.4	102.4	102.4	100.0
2005-05-17 08:00:00	DIA	ETF	102.38	102.45	102.33	102.42	26000.0
2005-05-17 09:00:00	DIA	ETF	102.39	102.61	102.34	102.59	504300.0
2005-05-17 10:00:00	DIA	ETF	102.57	102.65	102.28	102.39	948400.0
2005-05-17 11:00:00	DIA	ETF	102.39	102.7	102.36	102.59	455600.0
2005-05-17 12:00:00	DIA	ETF	102.59	102.61	102.34	102.36	413000.0
2005-05-17 13:00:00	DIA	ETF	102.36	102.56	102.3	102.47	410300.0
2005-05-17 14:00:00	DIA	ETF	102.44	103.28	102.37	103.19	1067600.0
2005-05-17 15:00:00	DIA	ETF	103.2	103.55	103.07	103.46	1512000.0
2005-05-17 16:00:00	DIA	ETF	103.42	103.5	103.42	103.47	44000.0
2005-05-17 17:00:00	DIA	ETF	103.48	103.48	103.48	103.48	300.0
2005-05-17 19:00:00	DIA	ETF	103.35	103.35	103.35	103.35	300.0
2005-05-17 08:00:00	GLD	ETF	41.82	41.91	41.82	41.91	6500.0
2005-05-17 09:00:00	GLD	ETF	41.95	42.0	41.93	42.0	168900.0
2005-05-17 10:00:00	GLD	ETF	41.97	42.01	41.91	42.01	166900.0
2005-05-17 11:00:00	GLD	ETF	42.02	42.05	41.96	42.026	109000.0
2005-05-17 12:00:00	GLD	ETF	42.04	42.05	42.01	42.05	78100.0
2005-05-17 13:00:00	GLD	ETF	42.008	42.02	41.86	41.87	45300.0
2005-05-17 14:00:00	GLD	ETF	41.89	41.93	41.88	41.92	111300.0

> showing 50 of 865 rows — these rows as CSV

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