PREVIEW / etf_1hour / 2005-02-15

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-02-15.parquet
  size:    28 KB
  rows:    828

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-02-15 08:00:00	SPY	ETF	120.9	120.94	120.86	120.88	181200.0
2005-02-15 09:00:00	SPY	ETF	120.89	120.89	120.68	120.82	3739900.0
2005-02-15 10:00:00	SPY	ETF	120.83	121.36	120.72	121.32	10596300.0
2005-02-15 11:00:00	SPY	ETF	121.32	121.43	121.24	121.27	4483000.0
2005-02-15 12:00:00	SPY	ETF	121.28	121.35	121.21	121.25	2906000.0
2005-02-15 13:00:00	SPY	ETF	121.25	121.29	120.76	120.91	8102300.0
2005-02-15 14:00:00	SPY	ETF	120.9	121.08	120.8	121.03	5865000.0
2005-02-15 15:00:00	SPY	ETF	121.05	121.24	120.83	121.19	5717800.0
2005-02-15 16:00:00	SPY	ETF	121.19	121.28	120.7913	121.28	1325800.0
2005-02-15 17:00:00	SPY	ETF	121.28	121.29	121.13	121.28	412300.0
2005-02-15 18:00:00	SPY	ETF	121.24	121.24	121.19	121.19	16000.0
2005-02-15 19:00:00	SPY	ETF	121.21	121.21	121.19	121.19	200.0
2005-02-15 09:00:00	QQQ	ETF	37.91	37.97	37.82	37.93	9676800.0
2005-02-15 10:00:00	QQQ	ETF	37.94	38.5	37.86	38.41	32629900.0
2005-02-15 11:00:00	QQQ	ETF	38.4	38.48	38.35	38.37	16057900.0
2005-02-15 12:00:00	QQQ	ETF	38.36	38.38	38.27	38.29	7136100.0
2005-02-15 13:00:00	QQQ	ETF	38.28	38.3	37.88	38.0	23028900.0
2005-02-15 14:00:00	QQQ	ETF	38.01	38.13	37.93	38.12	10397600.0
2005-02-15 15:00:00	QQQ	ETF	38.12	38.18	38.07	38.14	12280800.0
2005-02-15 08:00:00	IWM	ETF	63.365	63.365	63.365	63.365	800.0
2005-02-15 09:00:00	IWM	ETF	63.375	63.395	63.245	63.365	1670200.0
2005-02-15 10:00:00	IWM	ETF	63.365	63.68	63.26	63.63	2387200.0
2005-02-15 11:00:00	IWM	ETF	63.635	63.675	63.555	63.605	1148800.0
2005-02-15 12:00:00	IWM	ETF	63.615	63.635	63.515	63.52	348600.0
2005-02-15 13:00:00	IWM	ETF	63.52	63.525	62.975	63.055	3545000.0
2005-02-15 14:00:00	IWM	ETF	63.05	63.195	62.915	63.165	2778600.0
2005-02-15 15:00:00	IWM	ETF	63.175	63.38	63.11	63.28	1867200.0
2005-02-15 16:00:00	IWM	ETF	63.28	63.35	63.27	63.305	460600.0
2005-02-15 17:00:00	IWM	ETF	63.335	63.335	63.335	63.335	800.0
2005-02-15 19:00:00	IWM	ETF	63.3	63.3	63.3	63.3	2000.0
2005-02-15 08:00:00	DIA	ETF	108.11	108.11	108.11	108.11	500.0
2005-02-15 09:00:00	DIA	ETF	108.06	108.13	107.92	108.07	381200.0
2005-02-15 10:00:00	DIA	ETF	108.02	108.6	107.97	108.59	1399900.0
2005-02-15 11:00:00	DIA	ETF	108.59	108.61	108.43	108.47	505900.0
2005-02-15 12:00:00	DIA	ETF	108.47	108.52	108.41	108.48	231900.0
2005-02-15 13:00:00	DIA	ETF	108.47	108.49	108.1	108.26	933900.0
2005-02-15 14:00:00	DIA	ETF	108.26	108.37	108.17	108.33	478100.0
2005-02-15 15:00:00	DIA	ETF	108.32	108.5	108.29	108.45	764000.0
2005-02-15 16:00:00	DIA	ETF	108.47	108.53	108.3	108.53	6600.0
2005-02-15 17:00:00	DIA	ETF	108.5	108.54	108.46	108.54	3400.0
2005-02-15 18:00:00	DIA	ETF	108.5	108.5	108.47	108.47	400.0
2005-02-15 09:00:00	GLD	ETF	42.4	42.44	42.37	42.41	165100.0
2005-02-15 10:00:00	GLD	ETF	42.42	42.45	42.34	42.43	198100.0
2005-02-15 11:00:00	GLD	ETF	42.44	42.57	42.4	42.53	239400.0
2005-02-15 12:00:00	GLD	ETF	42.52	42.55	42.46	42.54	165100.0
2005-02-15 13:00:00	GLD	ETF	42.55	42.6	42.51	42.56	546100.0
2005-02-15 14:00:00	GLD	ETF	42.56	42.57	42.53	42.57	102600.0
2005-02-15 15:00:00	GLD	ETF	42.55	42.59	42.52	42.58	143500.0
2005-02-15 08:00:00	TLT	ETF	92.82	92.86	92.71	92.71	9800.0
2005-02-15 09:00:00	TLT	ETF	92.62	92.73	92.6	92.7	210800.0

> showing 50 of 828 rows — these rows as CSV

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