PREVIEW / etf_1hour / 2005-04-12

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-12.parquet
  size:    30 KB
  rows:    871

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-04-12 07:00:00	SPY	ETF	118.03	118.09	118.03	118.09	7900.0
2005-04-12 08:00:00	SPY	ETF	118.09	118.1	117.75	117.9	520100.0
2005-04-12 09:00:00	SPY	ETF	117.89	117.93	117.46	117.53	7048500.0
2005-04-12 10:00:00	SPY	ETF	117.54	117.62	117.13	117.25	11276800.0
2005-04-12 11:00:00	SPY	ETF	117.26	117.39	117.2	117.35	5768400.0
2005-04-12 12:00:00	SPY	ETF	117.36	117.43	117.26	117.33	3845700.0
2005-04-12 13:00:00	SPY	ETF	117.33	117.4	117.17	117.25	5117300.0
2005-04-12 14:00:00	SPY	ETF	117.25	118.85	117.07	118.73	34177600.0
2005-04-12 15:00:00	SPY	ETF	118.74	119.06	118.65	118.76	14829100.0
2005-04-12 16:00:00	SPY	ETF	118.75	118.78	118.64	118.7	1149400.0
2005-04-12 17:00:00	SPY	ETF	118.69	118.88	118.68	118.75	148200.0
2005-04-12 18:00:00	SPY	ETF	118.75	118.78	118.7	118.78	21600.0
2005-04-12 19:00:00	SPY	ETF	118.78	118.8	118.77	118.8	14600.0
2005-04-12 09:00:00	QQQ	ETF	36.42	36.44	36.17	36.21	13965300.0
2005-04-12 10:00:00	QQQ	ETF	36.21	36.29	36.14	36.17	20762300.0
2005-04-12 11:00:00	QQQ	ETF	36.18	36.23	36.16	36.21	7872600.0
2005-04-12 12:00:00	QQQ	ETF	36.21	36.22	36.17	36.18	5257900.0
2005-04-12 13:00:00	QQQ	ETF	36.18	36.18	36.01	36.06	13391100.0
2005-04-12 14:00:00	QQQ	ETF	36.06	36.91	35.91	36.6	50162100.0
2005-04-12 15:00:00	QQQ	ETF	36.6	36.74	36.09	36.68	22930000.0
2005-04-12 09:00:00	IWM	ETF	60.115	60.26	59.825	59.865	5586400.0
2005-04-12 10:00:00	IWM	ETF	59.865	60.015	59.685	59.775	5225400.0
2005-04-12 11:00:00	IWM	ETF	59.775	59.93	59.73	59.885	1638000.0
2005-04-12 12:00:00	IWM	ETF	59.885	59.94	59.82	59.835	1010000.0
2005-04-12 13:00:00	IWM	ETF	59.825	59.855	59.71	59.75	2299400.0
2005-04-12 14:00:00	IWM	ETF	59.745	60.93	59.65	60.875	10912000.0
2005-04-12 15:00:00	IWM	ETF	60.87	61.055	60.685	60.915	5111600.0
2005-04-12 16:00:00	IWM	ETF	60.885	60.94	60.85	60.925	397000.0
2005-04-12 17:00:00	IWM	ETF	60.96	60.9908	60.96	60.9908	10400.0
2005-04-12 18:00:00	IWM	ETF	60.955	60.975	60.955	60.975	4000.0
2005-04-12 08:00:00	DIA	ETF	104.2	104.2	104.14	104.2	1900.0
2005-04-12 09:00:00	DIA	ETF	104.19	104.28	103.95	104.04	1676300.0
2005-04-12 10:00:00	DIA	ETF	104.04	104.09	103.56	103.71	986000.0
2005-04-12 11:00:00	DIA	ETF	103.7	103.84	103.61	103.8	873100.0
2005-04-12 12:00:00	DIA	ETF	103.81	103.86	103.71	103.76	547800.0
2005-04-12 13:00:00	DIA	ETF	103.74	103.78	103.66	103.71	422100.0
2005-04-12 14:00:00	DIA	ETF	103.71	105.06	103.59	104.99	3137700.0
2005-04-12 15:00:00	DIA	ETF	104.96	105.3	104.96	105.08	1253500.0
2005-04-12 16:00:00	DIA	ETF	105.04	105.08	105.0	105.02	135900.0
2005-04-12 17:00:00	DIA	ETF	105.05	105.05	105.05	105.05	2400.0
2005-04-12 18:00:00	DIA	ETF	105.15	105.15	105.15	105.15	300.0
2005-04-12 08:00:00	GLD	ETF	43.03	43.03	42.87	42.87	4800.0
2005-04-12 09:00:00	GLD	ETF	42.78	42.78	42.67	42.73	665200.0
2005-04-12 10:00:00	GLD	ETF	42.73	42.73	42.66	42.71	155700.0
2005-04-12 11:00:00	GLD	ETF	42.71	42.71	42.61	42.64	93300.0
2005-04-12 12:00:00	GLD	ETF	42.642	42.7	42.62	42.7	383800.0
2005-04-12 13:00:00	GLD	ETF	42.71	42.72	42.68	42.69	105200.0
2005-04-12 14:00:00	GLD	ETF	42.68	42.79	42.68	42.77	368700.0
2005-04-12 15:00:00	GLD	ETF	42.78	42.84	42.75	42.81	69200.0
2005-04-12 16:00:00	GLD	ETF	42.85	42.85	42.85	42.85	800.0

> showing 50 of 871 rows — these rows as CSV

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