PREVIEW / etf_1hour / 2005-08-12

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-12.parquet
  size:    31 KB
  rows:    943

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-08-12 07:00:00	SPY	ETF	123.7	123.7	123.69	123.69	5500.0
2005-08-12 08:00:00	SPY	ETF	123.7	123.7	123.47	123.6	290000.0
2005-08-12 09:00:00	SPY	ETF	123.56	123.67	123.25	123.37	6176100.0
2005-08-12 10:00:00	SPY	ETF	123.37	123.53	123.25	123.45	5440000.0
2005-08-12 11:00:00	SPY	ETF	123.45	123.61	122.89	123.0	12398600.0
2005-08-12 12:00:00	SPY	ETF	123.0	123.03	122.75	122.9	7084700.0
2005-08-12 13:00:00	SPY	ETF	122.9	123.02	122.83	122.89	3239600.0
2005-08-12 14:00:00	SPY	ETF	122.88	123.2	122.87	123.1	5032200.0
2005-08-12 15:00:00	SPY	ETF	123.1	123.69	123.05	123.24	11240100.0
2005-08-12 16:00:00	SPY	ETF	123.23	123.4	123.06	123.13	1645200.0
2005-08-12 17:00:00	SPY	ETF	123.1	123.14	123.0	123.14	6900.0
2005-08-12 18:00:00	SPY	ETF	123.11	123.11	123.11	123.11	600.0
2005-08-12 09:00:00	QQQ	ETF	39.12	39.18	39.05	39.08	10489500.0
2005-08-12 10:00:00	QQQ	ETF	39.08	39.15	39.01	39.13	9559200.0
2005-08-12 11:00:00	QQQ	ETF	39.13	39.17	39.01	39.06	13027900.0
2005-08-12 12:00:00	QQQ	ETF	39.06	39.08	38.97	39.05	9975300.0
2005-08-12 13:00:00	QQQ	ETF	39.04	39.1	39.01	39.01	6788300.0
2005-08-12 14:00:00	QQQ	ETF	39.01	39.16	38.98	39.1	11697900.0
2005-08-12 15:00:00	QQQ	ETF	39.1	39.32	39.07	39.19	17108000.0
2005-08-12 08:00:00	IWM	ETF	66.14	66.15	66.04	66.04	15100.0
2005-08-12 09:00:00	IWM	ETF	66.08	66.09	65.4	65.47	3419900.0
2005-08-12 10:00:00	IWM	ETF	65.48	65.68	65.44	65.61	2400800.0
2005-08-12 11:00:00	IWM	ETF	65.64	65.72	65.16	65.24	5869900.0
2005-08-12 12:00:00	IWM	ETF	65.24	65.34	65.13	65.27	2555800.0
2005-08-12 13:00:00	IWM	ETF	65.27	65.33	65.21	65.29	1620900.0
2005-08-12 14:00:00	IWM	ETF	65.29	65.57	65.29	65.49	2119400.0
2005-08-12 15:00:00	IWM	ETF	65.49	66.07	65.43	65.65	6076500.0
2005-08-12 16:00:00	IWM	ETF	65.66	65.71	65.21	65.21	200000.0
2005-08-12 18:00:00	IWM	ETF	65.55	65.55	65.55	65.55	900.0
2005-08-12 07:00:00	DIA	ETF	106.77	106.77	106.76	106.76	1500.0
2005-08-12 08:00:00	DIA	ETF	106.79	106.8	106.7	106.72	5700.0
2005-08-12 09:00:00	DIA	ETF	106.7	106.71	106.37	106.49	567900.0
2005-08-12 10:00:00	DIA	ETF	106.48	106.54	106.27	106.41	522200.0
2005-08-12 11:00:00	DIA	ETF	106.42	106.56	105.91	106.02	1862500.0
2005-08-12 12:00:00	DIA	ETF	106.02	106.04	105.8	105.93	549300.0
2005-08-12 13:00:00	DIA	ETF	105.93	106.02	105.85	105.87	420000.0
2005-08-12 14:00:00	DIA	ETF	105.88	106.16	105.88	106.09	419300.0
2005-08-12 15:00:00	DIA	ETF	106.08	106.52	106.05	106.13	945500.0
2005-08-12 16:00:00	DIA	ETF	106.15	106.15	106.0	106.03	3300.0
2005-08-12 17:00:00	DIA	ETF	106.09	106.09	106.0	106.0	1100.0
2005-08-12 18:00:00	DIA	ETF	106.05	106.2	106.05	106.2	500.0
2005-08-12 08:00:00	GLD	ETF	44.61	44.67	44.33	44.33	4600.0
2005-08-12 09:00:00	GLD	ETF	44.35	44.7	44.28	44.7	972000.0
2005-08-12 10:00:00	GLD	ETF	44.69	44.72	44.44	44.55	568000.0
2005-08-12 11:00:00	GLD	ETF	44.55	44.58	44.45	44.47	214300.0
2005-08-12 12:00:00	GLD	ETF	44.48	44.55	44.48	44.53	151400.0
2005-08-12 13:00:00	GLD	ETF	44.53	44.55	44.47	44.55	118600.0
2005-08-12 14:00:00	GLD	ETF	44.55	44.55	44.51	44.53	49900.0
2005-08-12 15:00:00	GLD	ETF	44.53	44.54	44.43	44.5	349000.0
2005-08-12 16:00:00	GLD	ETF	44.49	44.49	44.49	44.49	100.0

> showing 50 of 943 rows — these rows as CSV

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