PREVIEW / etf_1hour / 2005-10-20

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-10-20.parquet
  size:    34 KB
  rows:    991

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-10-20 04:00:00	SPY	ETF	119.39	119.39	119.39	119.39	500.0
2005-10-20 06:00:00	SPY	ETF	119.54	119.54	119.54	119.54	1000.0
2005-10-20 07:00:00	SPY	ETF	119.56	119.61	119.46	119.58	54000.0
2005-10-20 08:00:00	SPY	ETF	119.5	119.6	119.4	119.5	2317800.0
2005-10-20 09:00:00	SPY	ETF	119.52	119.81	119.46	119.53	12206500.0
2005-10-20 10:00:00	SPY	ETF	119.53	119.63	119.28	119.47	12957700.0
2005-10-20 11:00:00	SPY	ETF	119.46	119.644	119.02	119.13	17723900.0
2005-10-20 12:00:00	SPY	ETF	119.14	119.29	118.85	119.01	11846600.0
2005-10-20 13:00:00	SPY	ETF	119.0	119.53	118.75	118.86	9480000.0
2005-10-20 14:00:00	SPY	ETF	118.86	118.92	118.35	118.5	14722800.0
2005-10-20 15:00:00	SPY	ETF	118.5	118.6	117.3	117.74	37374400.0
2005-10-20 16:00:00	SPY	ETF	117.71	118.01	117.47	117.52	4501200.0
2005-10-20 17:00:00	SPY	ETF	117.53	117.83	117.44	117.55	213300.0
2005-10-20 18:00:00	SPY	ETF	117.52	117.52	117.37	117.47	83100.0
2005-10-20 19:00:00	SPY	ETF	117.47	117.53	117.45	117.48	28500.0
2005-10-20 09:00:00	QQQ	ETF	38.67	38.85	38.63	38.69	23917200.0
2005-10-20 10:00:00	QQQ	ETF	38.69	38.75	38.58	38.66	19199800.0
2005-10-20 11:00:00	QQQ	ETF	38.66	38.7	38.52	38.63	11635800.0
2005-10-20 12:00:00	QQQ	ETF	38.63	38.7	38.51	38.63	10600100.0
2005-10-20 13:00:00	QQQ	ETF	38.63	38.72	38.55	38.6	10158000.0
2005-10-20 14:00:00	QQQ	ETF	38.6	38.61	38.43	38.47	12461800.0
2005-10-20 15:00:00	QQQ	ETF	38.47	38.5	38.1	38.31	34978500.0
2005-10-20 07:00:00	IWM	ETF	63.33	63.33	63.33	63.33	1900.0
2005-10-20 08:00:00	IWM	ETF	63.37	63.43	63.32	63.33	527100.0
2005-10-20 09:00:00	IWM	ETF	63.33	63.65	63.17	63.27	3883600.0
2005-10-20 10:00:00	IWM	ETF	63.27	63.41	62.98	63.28	6330900.0
2005-10-20 11:00:00	IWM	ETF	63.29	63.29	62.74	62.89	7595500.0
2005-10-20 12:00:00	IWM	ETF	62.88	62.99	62.58	62.81	3986200.0
2005-10-20 13:00:00	IWM	ETF	62.8	63.28	62.65	62.77	4479100.0
2005-10-20 14:00:00	IWM	ETF	62.77	62.82	62.25	62.34	4516500.0
2005-10-20 15:00:00	IWM	ETF	62.34	62.53	61.88	62.413	13687400.0
2005-10-20 16:00:00	IWM	ETF	62.43	62.52	62.28	62.28	225400.0
2005-10-20 17:00:00	IWM	ETF	62.34	62.34	62.33	62.33	1100.0
2005-10-20 18:00:00	IWM	ETF	62.28	62.28	62.23	62.25	5100.0
2005-10-20 08:00:00	DIA	ETF	104.15	104.2	104.07	104.12	4700.0
2005-10-20 09:00:00	DIA	ETF	104.12	104.32	104.03	104.18	1327200.0
2005-10-20 10:00:00	DIA	ETF	104.15	104.38	104.04	104.25	1640200.0
2005-10-20 11:00:00	DIA	ETF	104.251	104.3	103.93	104.02	627900.0
2005-10-20 12:00:00	DIA	ETF	104.02	104.25	103.79	103.82	1076900.0
2005-10-20 13:00:00	DIA	ETF	103.85	104.05	103.69	103.77	583900.0
2005-10-20 14:00:00	DIA	ETF	103.75	103.81	103.35	103.44	1402500.0
2005-10-20 15:00:00	DIA	ETF	103.43	103.52	102.49	102.8	3637300.0
2005-10-20 16:00:00	DIA	ETF	102.81	102.9	102.6	102.6	270500.0
2005-10-20 17:00:00	DIA	ETF	102.69	102.69	102.5	102.56	7500.0
2005-10-20 18:00:00	DIA	ETF	102.64	102.67	102.53	102.67	1500.0
2005-10-20 08:00:00	GLD	ETF	46.37	46.37	46.25	46.25	16600.0
2005-10-20 09:00:00	GLD	ETF	46.27	46.34	46.2495	46.32	119500.0
2005-10-20 10:00:00	GLD	ETF	46.32	46.33	46.05	46.07	146900.0
2005-10-20 11:00:00	GLD	ETF	46.07	46.1	45.83	45.84	414300.0
2005-10-20 12:00:00	GLD	ETF	45.86	45.94	45.85	45.94	502000.0

> showing 50 of 991 rows — these rows as CSV

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