PREVIEW / etf_1hour / 2005-03-15

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-15.parquet
  size:    30 KB
  rows:    847

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-15 08:00:00	SPY	ETF	121.2	121.38	121.2	121.35	94000.0
2005-03-15 09:00:00	SPY	ETF	121.36	121.52	121.27	121.36	4309000.0
2005-03-15 10:00:00	SPY	ETF	121.35	121.37	121.1	121.34	6355000.0
2005-03-15 11:00:00	SPY	ETF	121.34	121.36	120.68	120.72	13422000.0
2005-03-15 12:00:00	SPY	ETF	120.72	120.86	120.56	120.79	10977600.0
2005-03-15 13:00:00	SPY	ETF	120.79	120.83	120.36	120.56	6611800.0
2005-03-15 14:00:00	SPY	ETF	120.57	120.72	120.31	120.51	7808100.0
2005-03-15 15:00:00	SPY	ETF	120.54	120.61	120.13	120.17	7078200.0
2005-03-15 16:00:00	SPY	ETF	120.17	120.27	120.09	120.16	1618000.0
2005-03-15 17:00:00	SPY	ETF	120.16	120.16	120.09	120.09	17500.0
2005-03-15 18:00:00	SPY	ETF	120.09	120.18	120.09	120.18	25400.0
2005-03-15 19:00:00	SPY	ETF	120.13	120.14	120.13	120.14	3000.0
2005-03-15 09:00:00	QQQ	ETF	37.44	37.48	37.33	37.37	13029200.0
2005-03-15 10:00:00	QQQ	ETF	37.38	37.38	37.14	37.24	19283700.0
2005-03-15 11:00:00	QQQ	ETF	37.25	37.28	37.04	37.06	11471000.0
2005-03-15 12:00:00	QQQ	ETF	37.06	37.14	37.0	37.12	8634600.0
2005-03-15 13:00:00	QQQ	ETF	37.12	37.17	36.99	37.08	9419100.0
2005-03-15 14:00:00	QQQ	ETF	37.08	37.14	36.99	37.05	9259800.0
2005-03-15 15:00:00	QQQ	ETF	37.06	37.1	36.99	37.03	18139400.0
2005-03-15 08:00:00	IWM	ETF	63.155	63.155	63.155	63.155	200.0
2005-03-15 09:00:00	IWM	ETF	63.185	63.41	63.185	63.34	2764600.0
2005-03-15 10:00:00	IWM	ETF	63.335	63.335	63.08	63.295	2360200.0
2005-03-15 11:00:00	IWM	ETF	63.29	63.295	62.945	63.0	2025000.0
2005-03-15 12:00:00	IWM	ETF	62.99	63.07	62.88	62.985	974600.0
2005-03-15 13:00:00	IWM	ETF	62.985	63.035	62.61	62.685	1821400.0
2005-03-15 14:00:00	IWM	ETF	62.69	62.76	62.465	62.57	2812600.0
2005-03-15 15:00:00	IWM	ETF	62.575	62.68	62.45	62.52	4410400.0
2005-03-15 16:00:00	IWM	ETF	62.55	62.635	62.5	62.58	949600.0
2005-03-15 09:00:00	DIA	ETF	108.3	108.48	108.28	108.38	570300.0
2005-03-15 10:00:00	DIA	ETF	108.38	108.4	108.16	108.39	513600.0
2005-03-15 11:00:00	DIA	ETF	108.4	108.43	107.92	107.94	832200.0
2005-03-15 12:00:00	DIA	ETF	107.92	108.09	107.81	108.06	351800.0
2005-03-15 13:00:00	DIA	ETF	108.06	108.07	107.74	107.88	424900.0
2005-03-15 14:00:00	DIA	ETF	107.89	107.98	107.65	107.84	413800.0
2005-03-15 15:00:00	DIA	ETF	107.85	107.9	107.53	107.58	681600.0
2005-03-15 16:00:00	DIA	ETF	107.61	107.64	107.51	107.6	57900.0
2005-03-15 09:00:00	GLD	ETF	44.23	44.25	43.93	43.96	217000.0
2005-03-15 10:00:00	GLD	ETF	43.97	44.15	43.97	44.07	129900.0
2005-03-15 11:00:00	GLD	ETF	44.06	44.07	43.98	44.04	385300.0
2005-03-15 12:00:00	GLD	ETF	44.04	44.07	43.96	44.01	75600.0
2005-03-15 13:00:00	GLD	ETF	44.02	44.05	44.0	44.036	43000.0
2005-03-15 14:00:00	GLD	ETF	44.03	44.05	43.98	44.0	60600.0
2005-03-15 15:00:00	GLD	ETF	44.0	44.08	44.0	44.05	333500.0
2005-03-15 08:00:00	TLT	ETF	89.1	89.24	89.1	89.2	40000.0
2005-03-15 09:00:00	TLT	ETF	89.29	89.32	89.1	89.19	103800.0
2005-03-15 10:00:00	TLT	ETF	89.16	89.24	89.09	89.15	65900.0
2005-03-15 11:00:00	TLT	ETF	89.15	89.17	88.76	88.76	128100.0
2005-03-15 12:00:00	TLT	ETF	88.76	88.78	88.58	88.72	381800.0
2005-03-15 13:00:00	TLT	ETF	88.73	88.75	88.52	88.58	79900.0
2005-03-15 14:00:00	TLT	ETF	88.58	88.64	88.43	88.58	58400.0

> showing 50 of 847 rows — these rows as CSV

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