PREVIEW / etf_1hour / 2005-05-06

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-06.parquet
  size:    30 KB
  rows:    874

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-06 06:00:00	SPY	ETF	117.6	117.6	117.59	117.59	10800.0
2005-05-06 07:00:00	SPY	ETF	117.66	117.77	117.66	117.71	189200.0
2005-05-06 08:00:00	SPY	ETF	117.65	118.23	117.65	118.11	1967200.0
2005-05-06 09:00:00	SPY	ETF	118.12	118.14	117.62	117.84	10762300.0
2005-05-06 10:00:00	SPY	ETF	117.83	117.97	117.47	117.72	13454600.0
2005-05-06 11:00:00	SPY	ETF	117.74	117.8	117.37	117.43	5749700.0
2005-05-06 12:00:00	SPY	ETF	117.46	117.46	117.2	117.36	7652100.0
2005-05-06 13:00:00	SPY	ETF	117.37	117.65	117.33	117.46	5071300.0
2005-05-06 14:00:00	SPY	ETF	117.46	117.76	117.44	117.54	5794300.0
2005-05-06 15:00:00	SPY	ETF	117.54	117.62	117.12	117.2	8719600.0
2005-05-06 16:00:00	SPY	ETF	117.19	117.96	117.0	117.0	7607100.0
2005-05-06 17:00:00	SPY	ETF	117.01	117.12	116.95	116.95	15900.0
2005-05-06 18:00:00	SPY	ETF	116.98	117.06	116.93	117.06	4300.0
2005-05-06 19:00:00	SPY	ETF	117.03	117.08	117.03	117.08	800.0
2005-05-06 09:00:00	QQQ	ETF	35.97	36.02	35.88	35.93	13338000.0
2005-05-06 10:00:00	QQQ	ETF	35.93	35.99	35.83	35.9	17292100.0
2005-05-06 11:00:00	QQQ	ETF	35.9	35.92	35.79	35.83	6294400.0
2005-05-06 12:00:00	QQQ	ETF	35.82	35.83	35.72	35.77	6276500.0
2005-05-06 13:00:00	QQQ	ETF	35.78	35.86	35.77	35.82	4145900.0
2005-05-06 14:00:00	QQQ	ETF	35.82	35.93	35.82	35.89	10312900.0
2005-05-06 15:00:00	QQQ	ETF	35.89	35.93	35.81	35.85	10038700.0
2005-05-06 08:00:00	IWM	ETF	59.345	59.9	59.345	59.85	533400.0
2005-05-06 09:00:00	IWM	ETF	59.79	59.79	59.325	59.42	5969000.0
2005-05-06 10:00:00	IWM	ETF	59.425	59.57	59.225	59.415	5278600.0
2005-05-06 11:00:00	IWM	ETF	59.43	59.435	59.125	59.225	1245400.0
2005-05-06 12:00:00	IWM	ETF	59.21	59.255	59.08	59.22	1604800.0
2005-05-06 13:00:00	IWM	ETF	59.22	59.495	59.21	59.35	1588200.0
2005-05-06 14:00:00	IWM	ETF	59.345	59.545	59.34	59.43	2697800.0
2005-05-06 15:00:00	IWM	ETF	59.44	59.485	59.255	59.295	2978800.0
2005-05-06 16:00:00	IWM	ETF	59.285	59.36	59.15	59.15	981200.0
2005-05-06 08:00:00	DIA	ETF	103.68	104.08	103.68	104.05	70600.0
2005-05-06 09:00:00	DIA	ETF	103.99	104.0	103.76	103.95	629800.0
2005-05-06 10:00:00	DIA	ETF	103.96	103.98	103.64	103.89	1067400.0
2005-05-06 11:00:00	DIA	ETF	103.89	103.92	103.57	103.63	472700.0
2005-05-06 12:00:00	DIA	ETF	103.63	103.64	103.43	103.6	396300.0
2005-05-06 13:00:00	DIA	ETF	103.61	103.9	103.6	103.78	692600.0
2005-05-06 14:00:00	DIA	ETF	103.78	104.05	103.74	103.83	683900.0
2005-05-06 15:00:00	DIA	ETF	103.83	103.89	103.43	103.48	1147200.0
2005-05-06 16:00:00	DIA	ETF	103.49	103.5262	103.31	103.33	184300.0
2005-05-06 17:00:00	DIA	ETF	103.4	103.4	103.33	103.33	3500.0
2005-05-06 18:00:00	DIA	ETF	103.31	103.31	103.31	103.31	900.0
2005-05-06 19:00:00	DIA	ETF	103.31	103.31	103.31	103.31	100.0
2005-05-06 08:00:00	GLD	ETF	42.63	42.68	42.63	42.68	20400.0
2005-05-06 09:00:00	GLD	ETF	42.6	42.6	42.36	42.44	2386600.0
2005-05-06 10:00:00	GLD	ETF	42.44	42.56	42.44	42.48	285800.0
2005-05-06 11:00:00	GLD	ETF	42.47	42.48	42.34	42.37	281100.0
2005-05-06 12:00:00	GLD	ETF	42.37	42.48	42.36	42.46	261800.0
2005-05-06 13:00:00	GLD	ETF	42.47	42.63	42.45	42.57	223700.0
2005-05-06 14:00:00	GLD	ETF	42.57	42.62	42.53	42.57	43500.0
2005-05-06 15:00:00	GLD	ETF	42.55	42.58	42.51	42.53	182700.0

> showing 50 of 874 rows — these rows as CSV

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