PREVIEW / etf_1hour / 2005-06-06

all etf 1-hour files

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

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-06-06 04:00:00	SPY	ETF	120.13	120.13	120.12	120.12	2300.0
2005-06-06 05:00:00	SPY	ETF	120.1	120.1	120.1	120.1	500.0
2005-06-06 06:00:00	SPY	ETF	120.08	120.08	120.08	120.08	5000.0
2005-06-06 07:00:00	SPY	ETF	120.08	120.1	120.05	120.09	41700.0
2005-06-06 08:00:00	SPY	ETF	120.07	120.07	119.92	119.94	169900.0
2005-06-06 09:00:00	SPY	ETF	119.94	120.05	119.86	119.92	5512600.0
2005-06-06 10:00:00	SPY	ETF	119.93	120.0	119.55	119.62	7172600.0
2005-06-06 11:00:00	SPY	ETF	119.62	119.75	119.57	119.66	5867900.0
2005-06-06 12:00:00	SPY	ETF	119.67	119.91	119.67	119.78	4127700.0
2005-06-06 13:00:00	SPY	ETF	119.77	120.02	119.69	119.95	3306500.0
2005-06-06 14:00:00	SPY	ETF	119.96	120.13	119.9	119.99	4459000.0
2005-06-06 15:00:00	SPY	ETF	119.99	120.2	119.87	120.14	4450500.0
2005-06-06 16:00:00	SPY	ETF	120.08	120.1	120.03	120.05	494300.0
2005-06-06 17:00:00	SPY	ETF	120.06	120.8	120.02	120.02	55600.0
2005-06-06 18:00:00	SPY	ETF	120.06	120.11	120.06	120.11	4100.0
2005-06-06 09:00:00	QQQ	ETF	38.13	38.18	38.06	38.1	7444100.0
2005-06-06 10:00:00	QQQ	ETF	38.1	38.16	37.98	37.99	9995400.0
2005-06-06 11:00:00	QQQ	ETF	37.99	38.04	37.96	38.0	6721600.0
2005-06-06 12:00:00	QQQ	ETF	38.0	38.11	38.0	38.05	4858800.0
2005-06-06 13:00:00	QQQ	ETF	38.04	38.17	38.04	38.15	4045800.0
2005-06-06 14:00:00	QQQ	ETF	38.15	38.19	38.11	38.12	6150300.0
2005-06-06 15:00:00	QQQ	ETF	38.12	38.15	38.05	38.1	9576100.0
2005-06-06 09:00:00	IWM	ETF	61.73	61.855	61.615	61.68	1046200.0
2005-06-06 10:00:00	IWM	ETF	61.68	61.75	61.525	61.53	2591400.0
2005-06-06 11:00:00	IWM	ETF	61.535	61.675	61.53	61.6	1431000.0
2005-06-06 12:00:00	IWM	ETF	61.6	61.79	61.6	61.72	2885600.0
2005-06-06 13:00:00	IWM	ETF	61.72	61.945	61.7	61.915	2114000.0
2005-06-06 14:00:00	IWM	ETF	61.92	62.05	61.87	61.95	3618600.0
2005-06-06 15:00:00	IWM	ETF	61.95	62.06	61.86	62.01	1979200.0
2005-06-06 16:00:00	IWM	ETF	61.98	61.99	61.94	61.985	2552600.0
2005-06-06 17:00:00	IWM	ETF	61.52	61.985	61.52	61.905	396000.0
2005-06-06 18:00:00	IWM	ETF	61.875	61.875	61.875	61.875	200.0
2005-06-06 08:00:00	DIA	ETF	104.62	104.62	104.57	104.6	8300.0
2005-06-06 09:00:00	DIA	ETF	104.65	104.99	104.5	104.59	221800.0
2005-06-06 10:00:00	DIA	ETF	104.57	104.62	104.25	104.29	554600.0
2005-06-06 11:00:00	DIA	ETF	104.27	104.44	104.27	104.4	287100.0
2005-06-06 12:00:00	DIA	ETF	104.42	104.6	104.4	104.46	404000.0
2005-06-06 13:00:00	DIA	ETF	104.45	104.65	104.42	104.56	269100.0
2005-06-06 14:00:00	DIA	ETF	104.54	104.72	104.53	104.58	404600.0
2005-06-06 15:00:00	DIA	ETF	104.53	104.76	104.47	104.63	465700.0
2005-06-06 16:00:00	DIA	ETF	104.62	104.66	104.61	104.62	109400.0
2005-06-06 17:00:00	DIA	ETF	104.63	104.63	104.63	104.63	1000000.0
2005-06-06 08:00:00	GLD	ETF	42.51	42.55	42.46	42.55	62200.0
2005-06-06 09:00:00	GLD	ETF	42.55	42.59	42.52	42.55	626000.0
2005-06-06 10:00:00	GLD	ETF	42.55	42.65	42.48	42.6	519800.0
2005-06-06 11:00:00	GLD	ETF	42.6	42.64	42.56	42.57	134500.0
2005-06-06 12:00:00	GLD	ETF	42.57	42.62	42.55	42.59	312200.0
2005-06-06 13:00:00	GLD	ETF	42.57	42.58	42.49	42.5	345800.0
2005-06-06 14:00:00	GLD	ETF	42.5	42.51	42.45	42.47	325000.0
2005-06-06 15:00:00	GLD	ETF	42.47	42.6	42.45	42.48	141700.0

> showing 50 of 868 rows — these rows as CSV

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