PREVIEW / etf_1hour / 2005-03-14

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-14.parquet
  size:    29 KB
  rows:    857

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-14 08:00:00	SPY	ETF	120.5	120.74	120.48	120.72	210800.0
2005-03-14 09:00:00	SPY	ETF	120.73	120.75	120.52	120.533	4182200.0
2005-03-14 10:00:00	SPY	ETF	120.53	120.86	120.48	120.68	6470000.0
2005-03-14 11:00:00	SPY	ETF	120.72	120.84	120.57	120.7	3509800.0
2005-03-14 12:00:00	SPY	ETF	120.7	120.82	120.55	120.6	3371000.0
2005-03-14 13:00:00	SPY	ETF	120.6	120.79	120.28	120.47	4628100.0
2005-03-14 14:00:00	SPY	ETF	120.48	120.59	120.32	120.53	3020800.0
2005-03-14 15:00:00	SPY	ETF	120.51	121.06	120.51	121.05	8640800.0
2005-03-14 16:00:00	SPY	ETF	121.05	121.16	121.0	121.14	748900.0
2005-03-14 17:00:00	SPY	ETF	121.14	121.21	121.13	121.18	8500.0
2005-03-14 18:00:00	SPY	ETF	121.22	121.22	121.18	121.2	1500.0
2005-03-14 19:00:00	SPY	ETF	121.15	121.15	121.15	121.15	400.0
2005-03-14 09:00:00	QQQ	ETF	37.23	37.3	37.17	37.21	7910700.0
2005-03-14 10:00:00	QQQ	ETF	37.2	37.35	37.16	37.27	10352300.0
2005-03-14 11:00:00	QQQ	ETF	37.27	37.31	37.08	37.14	8314800.0
2005-03-14 12:00:00	QQQ	ETF	37.14	37.23	37.13	37.14	5156500.0
2005-03-14 13:00:00	QQQ	ETF	37.14	37.18	37.03	37.09	7169600.0
2005-03-14 14:00:00	QQQ	ETF	37.1	37.16	37.08	37.14	6268700.0
2005-03-14 15:00:00	QQQ	ETF	37.14	37.36	37.13	37.33	12960400.0
2005-03-14 09:00:00	IWM	ETF	62.7	62.835	62.59	62.595	2361000.0
2005-03-14 10:00:00	IWM	ETF	62.595	62.89	62.555	62.825	3177200.0
2005-03-14 11:00:00	IWM	ETF	62.825	62.9	62.61	62.695	1399200.0
2005-03-14 12:00:00	IWM	ETF	62.7	62.815	62.605	62.67	1454800.0
2005-03-14 13:00:00	IWM	ETF	62.66	62.725	62.435	62.45	1706800.0
2005-03-14 14:00:00	IWM	ETF	62.465	62.62	62.465	62.545	1206000.0
2005-03-14 15:00:00	IWM	ETF	62.545	62.915	62.54	62.845	2929000.0
2005-03-14 16:00:00	IWM	ETF	62.865	63.01	62.855	63.005	443600.0
2005-03-14 17:00:00	IWM	ETF	63.075	63.075	62.7073	62.7073	201000.0
2005-03-14 08:00:00	DIA	ETF	108.03	108.04	108.03	108.04	700.0
2005-03-14 09:00:00	DIA	ETF	108.07	108.08	107.88	107.9	331000.0
2005-03-14 10:00:00	DIA	ETF	107.88	108.06	107.8	107.9	722400.0
2005-03-14 11:00:00	DIA	ETF	107.92	108.04	107.86	107.98	447100.0
2005-03-14 12:00:00	DIA	ETF	107.99	108.09	107.87	107.89	326400.0
2005-03-14 13:00:00	DIA	ETF	107.89	107.93	107.58	107.75	317800.0
2005-03-14 14:00:00	DIA	ETF	107.74	107.83	107.62	107.74	157000.0
2005-03-14 15:00:00	DIA	ETF	107.75	108.14	107.69	108.13	1158400.0
2005-03-14 16:00:00	DIA	ETF	108.08	108.15	108.08	108.15	5600.0
2005-03-14 09:00:00	GLD	ETF	44.26	44.26	44.08	44.12	239000.0
2005-03-14 10:00:00	GLD	ETF	44.14	44.19	44.093	44.11	121900.0
2005-03-14 11:00:00	GLD	ETF	44.11	44.15	44.01	44.05	148100.0
2005-03-14 12:00:00	GLD	ETF	44.05	44.11	43.95	44.05	196800.0
2005-03-14 13:00:00	GLD	ETF	44.05	44.08	44.0	44.04	59800.0
2005-03-14 14:00:00	GLD	ETF	44.06	44.08	44.04	44.06	36100.0
2005-03-14 15:00:00	GLD	ETF	44.07	44.08	44.01	44.01	64800.0
2005-03-14 18:00:00	GLD	ETF	44.0	44.0	44.0	44.0	500.0
2005-03-14 08:00:00	TLT	ETF	88.58	88.58	88.58	88.58	100.0
2005-03-14 09:00:00	TLT	ETF	88.42	88.57	88.3	88.57	180700.0
2005-03-14 10:00:00	TLT	ETF	88.53	88.67	88.5	88.53	93600.0
2005-03-14 11:00:00	TLT	ETF	88.59	88.67	88.54	88.6	50000.0
2005-03-14 12:00:00	TLT	ETF	88.59	88.61	88.51	88.58	90900.0

> showing 50 of 857 rows — these rows as CSV

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