PREVIEW / etf_1hour / 2005-03-23

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-23.parquet
  size:    30 KB
  rows:    876

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-03-23 08:00:00	SPY	ETF	117.13	117.14	116.49	116.85	1617600.0
2005-03-23 09:00:00	SPY	ETF	116.79	117.1	116.79	116.87	10639700.0
2005-03-23 10:00:00	SPY	ETF	116.87	117.26	116.75	117.13	18812200.0
2005-03-23 11:00:00	SPY	ETF	117.13	117.37	117.01	117.12	9754100.0
2005-03-23 12:00:00	SPY	ETF	117.12	117.47	117.1	117.31	7851700.0
2005-03-23 13:00:00	SPY	ETF	117.32	117.51	117.18	117.44	4315200.0
2005-03-23 14:00:00	SPY	ETF	117.45	117.59	117.22	117.27	6677200.0
2005-03-23 15:00:00	SPY	ETF	117.27	117.72	117.06	117.06	7634100.0
2005-03-23 16:00:00	SPY	ETF	117.07	117.11	117.0	117.08	1969200.0
2005-03-23 17:00:00	SPY	ETF	117.05	117.08	117.0	117.0	21900.0
2005-03-23 18:00:00	SPY	ETF	117.07	117.17	117.01	117.07	961800.0
2005-03-23 19:00:00	SPY	ETF	117.15	117.16	117.13	117.15	1700.0
2005-03-23 09:00:00	QQQ	ETF	36.09	36.26	36.07	36.2	17073400.0
2005-03-23 10:00:00	QQQ	ETF	36.19	36.41	36.19	36.33	22001400.0
2005-03-23 11:00:00	QQQ	ETF	36.33	36.4	36.23	36.29	8535100.0
2005-03-23 12:00:00	QQQ	ETF	36.29	36.46	36.29	36.39	8923100.0
2005-03-23 13:00:00	QQQ	ETF	36.38	36.47	36.3	36.43	7313500.0
2005-03-23 14:00:00	QQQ	ETF	36.43	36.49	36.34	36.36	7923600.0
2005-03-23 15:00:00	QQQ	ETF	36.36	36.45	36.25	36.26	13230900.0
2005-03-23 08:00:00	IWM	ETF	61.675	61.675	61.335	61.335	7000.0
2005-03-23 09:00:00	IWM	ETF	61.5	61.5	61.26	61.32	2766200.0
2005-03-23 10:00:00	IWM	ETF	61.32	61.515	61.13	61.345	4764200.0
2005-03-23 11:00:00	IWM	ETF	61.35	61.41	61.21	61.26	2517800.0
2005-03-23 12:00:00	IWM	ETF	61.265	61.4	61.235	61.315	1063600.0
2005-03-23 13:00:00	IWM	ETF	61.32	61.41	61.255	61.365	1450600.0
2005-03-23 14:00:00	IWM	ETF	61.365	61.475	61.175	61.19	2378000.0
2005-03-23 15:00:00	IWM	ETF	61.19	61.26	61.005	61.1	4731800.0
2005-03-23 16:00:00	IWM	ETF	61.115	61.17	61.035	61.035	663200.0
2005-03-23 17:00:00	IWM	ETF	61.11	61.11	61.11	61.11	6000.0
2005-03-23 18:00:00	IWM	ETF	61.07	61.07	61.07	61.07	200.0
2005-03-23 08:00:00	DIA	ETF	104.73	104.75	104.27	104.5	52800.0
2005-03-23 09:00:00	DIA	ETF	104.45	105.55	104.4	104.41	1165200.0
2005-03-23 10:00:00	DIA	ETF	104.41	104.7	104.21	104.5	1529400.0
2005-03-23 11:00:00	DIA	ETF	104.51	104.69	104.38	104.46	798000.0
2005-03-23 12:00:00	DIA	ETF	104.46	104.75	104.45	104.62	777900.0
2005-03-23 13:00:00	DIA	ETF	104.62	104.81	104.53	104.79	958700.0
2005-03-23 14:00:00	DIA	ETF	104.8	104.89	104.56	104.63	824800.0
2005-03-23 15:00:00	DIA	ETF	104.64	104.74	104.41	104.44	989400.0
2005-03-23 16:00:00	DIA	ETF	104.38	104.45	104.37	104.4	75200.0
2005-03-23 18:00:00	DIA	ETF	104.44	104.47	104.44	104.47	150000.0
2005-03-23 19:00:00	DIA	ETF	104.54	104.54	104.54	104.54	300.0
2005-03-23 08:00:00	GLD	ETF	42.4	42.6	42.4	42.6	56500.0
2005-03-23 09:00:00	GLD	ETF	42.75	42.79	42.59	42.61	347800.0
2005-03-23 10:00:00	GLD	ETF	42.6	42.6	42.51	42.52	278000.0
2005-03-23 11:00:00	GLD	ETF	42.53	42.57	42.5	42.52	214500.0
2005-03-23 12:00:00	GLD	ETF	42.53	42.54	42.47	42.51	429100.0
2005-03-23 13:00:00	GLD	ETF	42.5008	42.54	42.42	42.44	310000.0
2005-03-23 14:00:00	GLD	ETF	42.44	42.47	42.39	42.41	397700.0
2005-03-23 15:00:00	GLD	ETF	42.41	42.45	42.35	42.39	331700.0
2005-03-23 16:00:00	GLD	ETF	42.39	42.39	42.39	42.39	100.0

> showing 50 of 876 rows — these rows as CSV

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