PREVIEW / etf_1hour / 2005-03-29

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-29.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-03-29 08:00:00	SPY	ETF	117.04	117.12	116.98	117.1	131000.0
2005-03-29 09:00:00	SPY	ETF	117.1	117.48	117.06	117.24	6851600.0
2005-03-29 10:00:00	SPY	ETF	117.24	117.9	117.18	117.76	10780900.0
2005-03-29 11:00:00	SPY	ETF	117.76	117.81	117.54	117.66	5396200.0
2005-03-29 12:00:00	SPY	ETF	117.66	117.69	117.33	117.44	3072100.0
2005-03-29 13:00:00	SPY	ETF	117.44	117.48	116.91	117.04	10939100.0
2005-03-29 14:00:00	SPY	ETF	117.03	117.04	116.56	116.88	15578300.0
2005-03-29 15:00:00	SPY	ETF	116.88	116.92	116.25	116.4	13611600.0
2005-03-29 16:00:00	SPY	ETF	116.4	117.1	116.348	116.53	2526700.0
2005-03-29 17:00:00	SPY	ETF	116.53	116.61	116.53	116.61	76800.0
2005-03-29 18:00:00	SPY	ETF	116.6	116.61	116.58	116.61	5500.0
2005-03-29 19:00:00	SPY	ETF	116.64	116.64	116.62	116.64	4000.0
2005-03-29 09:00:00	QQQ	ETF	36.26	36.35	36.23	36.27	12191000.0
2005-03-29 10:00:00	QQQ	ETF	36.26	36.58	36.23	36.53	19513000.0
2005-03-29 11:00:00	QQQ	ETF	36.53	36.54	36.43	36.47	7841000.0
2005-03-29 12:00:00	QQQ	ETF	36.47	36.48	36.31	36.35	9055200.0
2005-03-29 13:00:00	QQQ	ETF	36.35	36.35	36.22	36.24	14414200.0
2005-03-29 14:00:00	QQQ	ETF	36.24	36.24	36.02	36.17	24294100.0
2005-03-29 15:00:00	QQQ	ETF	36.17	36.19	35.94	36.06	21263300.0
2005-03-29 08:00:00	IWM	ETF	60.96	61.01	60.96	61.01	13200.0
2005-03-29 09:00:00	IWM	ETF	61.025	61.1	60.91	61.02	1817000.0
2005-03-29 10:00:00	IWM	ETF	61.01	61.545	60.94	61.425	2771000.0
2005-03-29 11:00:00	IWM	ETF	61.42	61.435	61.195	61.27	1883800.0
2005-03-29 12:00:00	IWM	ETF	61.27	61.28	60.85	60.93	1395800.0
2005-03-29 13:00:00	IWM	ETF	60.93	60.935	60.525	60.615	2873400.0
2005-03-29 14:00:00	IWM	ETF	60.605	60.925	60.1	60.29	5269600.0
2005-03-29 15:00:00	IWM	ETF	60.285	60.63	59.925	60.12	5188400.0
2005-03-29 16:00:00	IWM	ETF	60.125	60.23	60.09	60.2	307400.0
2005-03-29 17:00:00	IWM	ETF	60.22	60.26	60.22	60.26	800.0
2005-03-29 18:00:00	IWM	ETF	60.24	60.24	60.22	60.22	2600.0
2005-03-29 08:00:00	DIA	ETF	104.5	104.51	104.48	104.48	1000.0
2005-03-29 09:00:00	DIA	ETF	104.58	104.86	104.51	104.6	1082100.0
2005-03-29 10:00:00	DIA	ETF	104.6	105.13	104.54	105.03	1240700.0
2005-03-29 11:00:00	DIA	ETF	105.04	105.07	104.86	104.93	306700.0
2005-03-29 12:00:00	DIA	ETF	104.94	104.95	104.77	104.82	207900.0
2005-03-29 13:00:00	DIA	ETF	104.84	104.84	104.3	104.39	739400.0
2005-03-29 14:00:00	DIA	ETF	104.39	104.74	103.97	104.29	2229900.0
2005-03-29 15:00:00	DIA	ETF	104.31	104.33	103.86	103.92	1520300.0
2005-03-29 16:00:00	DIA	ETF	103.94	104.1	103.92	104.04	35200.0
2005-03-29 17:00:00	DIA	ETF	104.1	104.1	104.1	104.1	2500.0
2005-03-29 19:00:00	DIA	ETF	104.15	104.15	104.15	104.15	100.0
2005-03-29 08:00:00	GLD	ETF	42.63	42.65	42.63	42.65	23000.0
2005-03-29 09:00:00	GLD	ETF	42.61	42.62	42.56	42.6	170800.0
2005-03-29 10:00:00	GLD	ETF	42.6	42.63	42.59	42.62	104700.0
2005-03-29 11:00:00	GLD	ETF	42.6	42.63	42.56	42.59	38300.0
2005-03-29 12:00:00	GLD	ETF	42.59	42.61	42.56	42.58	106700.0
2005-03-29 13:00:00	GLD	ETF	42.58	42.62	42.55	42.6	91200.0
2005-03-29 14:00:00	GLD	ETF	42.59	42.63	42.58	42.59	458300.0
2005-03-29 15:00:00	GLD	ETF	42.58	42.61	42.54	42.54	195100.0
2005-03-29 16:00:00	GLD	ETF	42.53	42.54	42.53	42.53	9500.0

> showing 50 of 874 rows — these rows as CSV

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