PREVIEW / etf_1hour / 2005-03-10

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-10.parquet
  size:    30 KB
  rows:    867

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-10 08:00:00	SPY	ETF	120.88	121.09	120.77	121.05	159900.0
2005-03-10 09:00:00	SPY	ETF	121.04	121.42	121.04	121.34	7826900.0
2005-03-10 10:00:00	SPY	ETF	121.34	121.42	120.86	120.87	11669100.0
2005-03-10 11:00:00	SPY	ETF	120.87	120.97	120.4	120.83	13072500.0
2005-03-10 12:00:00	SPY	ETF	120.84	121.0	120.7	121.0	3832700.0
2005-03-10 13:00:00	SPY	ETF	120.99	121.5	120.89	121.42	12707000.0
2005-03-10 14:00:00	SPY	ETF	121.42	121.43	121.13	121.25	5404800.0
2005-03-10 15:00:00	SPY	ETF	121.26	121.26	120.97	121.2	6029700.0
2005-03-10 16:00:00	SPY	ETF	121.21	121.95	121.16	121.48	2821000.0
2005-03-10 17:00:00	SPY	ETF	121.51	121.51	121.37	121.38	33800.0
2005-03-10 18:00:00	SPY	ETF	121.38	121.38	121.35	121.37	135300.0
2005-03-10 19:00:00	SPY	ETF	121.43	121.43	121.38	121.38	1000.0
2005-03-10 09:00:00	QQQ	ETF	37.6	37.67	37.44	37.57	10686900.0
2005-03-10 10:00:00	QQQ	ETF	37.57	37.61	37.28	37.28	17567900.0
2005-03-10 11:00:00	QQQ	ETF	37.29	37.3	36.95	37.24	18853100.0
2005-03-10 12:00:00	QQQ	ETF	37.25	37.41	37.18	37.39	7864900.0
2005-03-10 13:00:00	QQQ	ETF	37.39	37.59	37.33	37.54	15709500.0
2005-03-10 14:00:00	QQQ	ETF	37.55	37.55	37.41	37.48	7669000.0
2005-03-10 15:00:00	QQQ	ETF	37.48	37.54	37.37	37.53	11416700.0
2005-03-10 08:00:00	IWM	ETF	62.785	62.855	62.745	62.855	17000.0
2005-03-10 09:00:00	IWM	ETF	62.81	63.345	62.7	62.865	2163600.0
2005-03-10 10:00:00	IWM	ETF	62.865	62.96	62.565	62.565	4678400.0
2005-03-10 11:00:00	IWM	ETF	62.575	62.575	62.23	62.395	3705000.0
2005-03-10 12:00:00	IWM	ETF	62.395	62.55	62.275	62.53	1697200.0
2005-03-10 13:00:00	IWM	ETF	62.54	63.065	62.53	62.905	5280200.0
2005-03-10 14:00:00	IWM	ETF	62.905	62.905	62.575	62.725	2467000.0
2005-03-10 15:00:00	IWM	ETF	62.715	62.745	62.35	62.535	2662800.0
2005-03-10 16:00:00	IWM	ETF	62.545	62.865	62.535	62.75	124000.0
2005-03-10 17:00:00	IWM	ETF	62.75	62.78	62.75	62.78	3400.0
2005-03-10 18:00:00	IWM	ETF	62.725	62.8	62.725	62.725	98400.0
2005-03-10 08:00:00	DIA	ETF	107.95	108.12	107.95	108.12	4900.0
2005-03-10 09:00:00	DIA	ETF	108.13	108.4	108.13	108.39	369000.0
2005-03-10 10:00:00	DIA	ETF	108.38	108.44	107.74	108.12	1116200.0
2005-03-10 11:00:00	DIA	ETF	108.13	108.15	107.78	108.05	1570200.0
2005-03-10 12:00:00	DIA	ETF	108.05	108.19	107.96	108.19	214100.0
2005-03-10 13:00:00	DIA	ETF	108.22	108.73	108.14	108.67	934300.0
2005-03-10 14:00:00	DIA	ETF	108.67	108.67	108.4	108.45	296400.0
2005-03-10 15:00:00	DIA	ETF	108.45	108.47	108.23	108.45	684200.0
2005-03-10 16:00:00	DIA	ETF	108.43	108.72	108.43	108.71	9900.0
2005-03-10 09:00:00	GLD	ETF	44.12	44.19	44.03	44.09	295400.0
2005-03-10 10:00:00	GLD	ETF	44.09	44.09	44.0	44.05	547400.0
2005-03-10 11:00:00	GLD	ETF	44.04	44.25	44.02	44.21	317900.0
2005-03-10 12:00:00	GLD	ETF	44.2	44.21	44.12	44.1403	354400.0
2005-03-10 13:00:00	GLD	ETF	44.15	44.25	44.14	44.19	253000.0
2005-03-10 14:00:00	GLD	ETF	44.19	44.23	44.16	44.21	177500.0
2005-03-10 15:00:00	GLD	ETF	44.2	44.2	44.15	44.16	100000.0
2005-03-10 16:00:00	GLD	ETF	44.11	44.11	44.11	44.11	500.0
2005-03-10 08:00:00	TLT	ETF	88.27	88.39	88.27	88.39	16100.0
2005-03-10 09:00:00	TLT	ETF	88.57	88.97	88.57	88.9	319300.0
2005-03-10 10:00:00	TLT	ETF	88.9	88.95	88.64	88.67	101400.0

> showing 50 of 867 rows — these rows as CSV

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