PREVIEW / etf_1hour / 2005-06-17

all etf 1-hour files

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

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-17 07:00:00	SPY	ETF	121.27	121.32	121.24	121.31	35900.0
2005-06-17 08:00:00	SPY	ETF	121.31	121.32	121.22	121.25	240500.0
2005-06-17 09:00:00	SPY	ETF	121.29	121.9	121.29	121.52	13002600.0
2005-06-17 10:00:00	SPY	ETF	121.53	121.86	121.26	121.46	9487700.0
2005-06-17 11:00:00	SPY	ETF	121.47	121.68	121.2	121.34	6951900.0
2005-06-17 12:00:00	SPY	ETF	121.35	121.45	121.27	121.4	3470300.0
2005-06-17 13:00:00	SPY	ETF	121.41	121.63	121.36	121.6	3209200.0
2005-06-17 14:00:00	SPY	ETF	121.6	121.74	121.39	121.46	6872300.0
2005-06-17 15:00:00	SPY	ETF	121.45	121.89	121.45	121.6	4882200.0
2005-06-17 16:00:00	SPY	ETF	121.59	121.61	121.36	121.44	1540400.0
2005-06-17 17:00:00	SPY	ETF	121.44	121.52	121.44	121.45	1082100.0
2005-06-17 18:00:00	SPY	ETF	121.45	121.46	121.44	121.44	7900.0
2005-06-17 19:00:00	SPY	ETF	121.44	121.44	121.44	121.44	17600.0
2005-06-17 09:00:00	QQQ	ETF	38.11	38.21	37.9	37.93	19876800.0
2005-06-17 10:00:00	QQQ	ETF	37.93	38.29	37.75	37.88	23880600.0
2005-06-17 11:00:00	QQQ	ETF	37.87	37.9	37.76	37.86	11684700.0
2005-06-17 12:00:00	QQQ	ETF	37.85	37.9	37.81	37.9	5125800.0
2005-06-17 13:00:00	QQQ	ETF	37.89	37.97	37.87	37.94	4356600.0
2005-06-17 14:00:00	QQQ	ETF	37.94	37.99	37.82	37.86	5649000.0
2005-06-17 15:00:00	QQQ	ETF	37.86	37.96	37.85	37.88	9589600.0
2005-06-17 07:00:00	IWM	ETF	64.1	64.1	64.1	64.1	100.0
2005-06-17 08:00:00	IWM	ETF	64.2	64.27	64.2	64.26	9100.0
2005-06-17 09:00:00	IWM	ETF	64.3	64.65	64.27	64.38	5057900.0
2005-06-17 10:00:00	IWM	ETF	64.38	64.4	64.07	64.14	4147500.0
2005-06-17 11:00:00	IWM	ETF	64.14	64.2	63.88	63.96	2670500.0
2005-06-17 12:00:00	IWM	ETF	63.96	64.14	63.92	64.1	940700.0
2005-06-17 13:00:00	IWM	ETF	64.1	64.3	64.05	64.22	2263200.0
2005-06-17 14:00:00	IWM	ETF	64.23	64.3	64.09	64.14	1962200.0
2005-06-17 15:00:00	IWM	ETF	64.14	64.36	64.11	64.11	2951600.0
2005-06-17 16:00:00	IWM	ETF	64.12	64.12	63.99	64.02	556900.0
2005-06-17 08:00:00	DIA	ETF	105.94	105.99	105.93	105.93	3900.0
2005-06-17 09:00:00	DIA	ETF	105.95	106.51	105.95	106.24	2549000.0
2005-06-17 10:00:00	DIA	ETF	106.22	106.35	106.0	106.21	1406600.0
2005-06-17 11:00:00	DIA	ETF	106.22	106.23	105.89	105.97	831900.0
2005-06-17 12:00:00	DIA	ETF	105.98	106.08	105.94	106.04	202900.0
2005-06-17 13:00:00	DIA	ETF	106.04	106.2	106.01	106.18	479600.0
2005-06-17 14:00:00	DIA	ETF	106.16	106.3	106.04	106.07	463400.0
2005-06-17 15:00:00	DIA	ETF	106.09	106.27	106.09	106.18	1143500.0
2005-06-17 16:00:00	DIA	ETF	106.13	106.16	106.0	106.06	78600.0
2005-06-17 17:00:00	DIA	ETF	106.15	106.15	106.15	106.15	162400.0
2005-06-17 09:00:00	GLD	ETF	43.81	43.85	43.62	43.64	229500.0
2005-06-17 10:00:00	GLD	ETF	43.63	43.8	43.61	43.72	216300.0
2005-06-17 11:00:00	GLD	ETF	43.72	43.76	43.71	43.72	618000.0
2005-06-17 12:00:00	GLD	ETF	43.74	43.79	43.71	43.78	196000.0
2005-06-17 13:00:00	GLD	ETF	43.79	43.79	43.7	43.72	50700.0
2005-06-17 14:00:00	GLD	ETF	43.72	43.72	43.68	43.69	354500.0
2005-06-17 15:00:00	GLD	ETF	43.68	43.7	43.64	43.68	132500.0
2005-06-17 16:00:00	GLD	ETF	43.66	43.66	43.66	43.66	3800.0
2005-06-17 09:00:00	TLT	ETF	94.1	94.22	94.02	94.07	106300.0
2005-06-17 10:00:00	TLT	ETF	94.08	94.35	94.07	94.32	112500.0

> showing 50 of 900 rows — these rows as CSV

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