PREVIEW / etf_1hour / 2005-05-31

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-31.parquet
  size:    29 KB
  rows:    872

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-31 05:00:00	SPY	ETF	120.04	120.14	120.04	120.14	3000.0
2005-05-31 06:00:00	SPY	ETF	120.04	120.04	119.96	120.04	104500.0
2005-05-31 07:00:00	SPY	ETF	120.07	120.07	120.0	120.0	51800.0
2005-05-31 08:00:00	SPY	ETF	120.02	120.15	119.99	120.14	61500.0
2005-05-31 09:00:00	SPY	ETF	120.15	120.17	119.53	119.59	5151000.0
2005-05-31 10:00:00	SPY	ETF	119.59	119.86	119.54	119.6	9570400.0
2005-05-31 11:00:00	SPY	ETF	119.6	119.67	119.47	119.64	4282200.0
2005-05-31 12:00:00	SPY	ETF	119.63	120.02	119.55	119.63	1734800.0
2005-05-31 13:00:00	SPY	ETF	119.62	119.88	119.58	119.81	2710200.0
2005-05-31 14:00:00	SPY	ETF	119.81	120.0	119.71	119.91	3869700.0
2005-05-31 15:00:00	SPY	ETF	119.9	120.05	119.43	119.45	9506000.0
2005-05-31 16:00:00	SPY	ETF	119.46	119.6923	119.39	119.44	2132700.0
2005-05-31 17:00:00	SPY	ETF	119.45	119.49	119.4	119.42	1546400.0
2005-05-31 18:00:00	SPY	ETF	119.46	119.54	119.46	119.47	13500.0
2005-05-31 19:00:00	SPY	ETF	119.5	119.53	119.5	119.53	4200.0
2005-05-31 09:00:00	QQQ	ETF	38.2	38.23	38.05	38.06	9771800.0
2005-05-31 10:00:00	QQQ	ETF	38.06	38.24	38.05	38.05	17741600.0
2005-05-31 11:00:00	QQQ	ETF	38.06	38.06	37.92	38.02	11402800.0
2005-05-31 12:00:00	QQQ	ETF	38.01	38.07	37.97	38.04	4692700.0
2005-05-31 13:00:00	QQQ	ETF	38.04	38.16	38.03	38.13	4618800.0
2005-05-31 14:00:00	QQQ	ETF	38.13	38.19	38.09	38.17	6358700.0
2005-05-31 15:00:00	QQQ	ETF	38.17	38.22	38.05	38.09	15404300.0
2005-05-31 07:00:00	IWM	ETF	61.44	61.44	61.43	61.43	3000.0
2005-05-31 08:00:00	IWM	ETF	61.475	61.475	61.475	61.475	5000.0
2005-05-31 09:00:00	IWM	ETF	61.485	61.61	61.21	61.24	1943600.0
2005-05-31 10:00:00	IWM	ETF	61.24	61.53	61.24	61.34	3324800.0
2005-05-31 11:00:00	IWM	ETF	61.34	61.395	61.25	61.325	1578000.0
2005-05-31 12:00:00	IWM	ETF	61.325	61.45	61.285	61.415	865800.0
2005-05-31 13:00:00	IWM	ETF	61.41	61.58	61.39	61.55	1307200.0
2005-05-31 14:00:00	IWM	ETF	61.55	61.625	61.39	61.565	2646400.0
2005-05-31 15:00:00	IWM	ETF	61.56	61.705	61.345	61.35	3695400.0
2005-05-31 16:00:00	IWM	ETF	61.345	61.39	61.15	61.3	927000.0
2005-05-31 17:00:00	IWM	ETF	61.2	61.2	61.2	61.2	1141400.0
2005-05-31 07:00:00	DIA	ETF	105.2	105.26	105.2	105.26	1700.0
2005-05-31 09:00:00	DIA	ETF	105.34	105.35	104.85	104.86	713500.0
2005-05-31 10:00:00	DIA	ETF	104.87	105.02	104.76	104.85	1504600.0
2005-05-31 11:00:00	DIA	ETF	104.85	104.89	104.71	104.83	262400.0
2005-05-31 12:00:00	DIA	ETF	104.8301	104.92	104.74	104.77	283000.0
2005-05-31 13:00:00	DIA	ETF	104.78	105.01	104.73	104.95	323600.0
2005-05-31 14:00:00	DIA	ETF	104.95	105.08	104.86	104.99	582800.0
2005-05-31 15:00:00	DIA	ETF	105.0	105.17	104.57	104.57	1741600.0
2005-05-31 16:00:00	DIA	ETF	104.63	104.66	104.6	104.66	58700.0
2005-05-31 18:00:00	DIA	ETF	104.62	104.62	104.62	104.62	200.0
2005-05-31 08:00:00	GLD	ETF	41.66	41.66	41.66	41.66	200.0
2005-05-31 09:00:00	GLD	ETF	41.45	41.45	41.33	41.38	573700.0
2005-05-31 10:00:00	GLD	ETF	41.35	41.54	41.33	41.49	415500.0
2005-05-31 11:00:00	GLD	ETF	41.49	41.53	41.46	41.5	749800.0
2005-05-31 12:00:00	GLD	ETF	41.48	41.68	41.47	41.64	168100.0
2005-05-31 13:00:00	GLD	ETF	41.64	41.64	41.51	41.56	57300.0
2005-05-31 14:00:00	GLD	ETF	41.56	41.6	41.52	41.57	419500.0

> showing 50 of 872 rows — these rows as CSV

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