PREVIEW / etf_1hour / 2004-11-03

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-03.parquet
  size:    27 KB
  rows:    786

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
2004-11-03 08:00:00	SPY	ETF	114.78	115.08	114.75	115.01	859300.0
2004-11-03 09:00:00	SPY	ETF	115.0	115.36	114.94	115.09	13614400.0
2004-11-03 10:00:00	SPY	ETF	115.09	115.3	114.7	114.93	15868600.0
2004-11-03 11:00:00	SPY	ETF	114.94	115.28	114.8	114.96	10085900.0
2004-11-03 12:00:00	SPY	ETF	114.96	115.08	114.8	114.94	4112500.0
2004-11-03 13:00:00	SPY	ETF	114.93	115.17	114.91	115.04	4016600.0
2004-11-03 14:00:00	SPY	ETF	115.03	115.05	114.62	114.74	8095500.0
2004-11-03 15:00:00	SPY	ETF	114.75	114.87	114.24	114.77	12552100.0
2004-11-03 16:00:00	SPY	ETF	114.77	115.04	114.6731	114.9	2865400.0
2004-11-03 17:00:00	SPY	ETF	114.89	114.94	114.87	114.87	84800.0
2004-11-03 18:00:00	SPY	ETF	114.9	114.97	114.89	114.96	5600.0
2004-11-03 19:00:00	SPY	ETF	114.91	114.91	114.91	114.91	200.0
2004-11-03 08:00:00	QQQ	ETF	37.72	37.85	37.71	37.79	1676900.0
2004-11-03 09:00:00	QQQ	ETF	37.79	37.9	37.59	37.69	25034700.0
2004-11-03 10:00:00	QQQ	ETF	37.69	37.751	37.45	37.59	29743800.0
2004-11-03 11:00:00	QQQ	ETF	37.59	37.78	37.514	37.52	18708000.0
2004-11-03 12:00:00	QQQ	ETF	37.525	37.554	37.42	37.478	11668200.0
2004-11-03 13:00:00	QQQ	ETF	37.479	37.62	37.45	37.51	9538400.0
2004-11-03 14:00:00	QQQ	ETF	37.51	37.51	37.24	37.35	17395700.0
2004-11-03 15:00:00	QQQ	ETF	37.35	37.42	37.15	37.34	19342100.0
2004-11-03 16:00:00	QQQ	ETF	37.35	37.45	37.26	37.326	5000400.0
2004-11-03 17:00:00	QQQ	ETF	37.33	37.34	37.31	37.31	94300.0
2004-11-03 18:00:00	QQQ	ETF	37.33	37.36	37.32	37.34	78000.0
2004-11-03 19:00:00	QQQ	ETF	37.35	37.37	37.35	37.37	8200.0
2004-11-03 08:00:00	IWM	ETF	59.05	59.215	59.05	59.215	36000.0
2004-11-03 09:00:00	IWM	ETF	59.2	59.51	59.125	59.3	3165000.0
2004-11-03 10:00:00	IWM	ETF	59.335	59.42	59.05	59.265	3886800.0
2004-11-03 11:00:00	IWM	ETF	59.29	59.55	59.235	59.345	2829600.0
2004-11-03 12:00:00	IWM	ETF	59.345	59.375	59.26	59.26	1805600.0
2004-11-03 13:00:00	IWM	ETF	59.265	59.395	59.265	59.315	1147000.0
2004-11-03 14:00:00	IWM	ETF	59.335	59.345	59.1	59.275	1305600.0
2004-11-03 15:00:00	IWM	ETF	59.27	59.34	58.86	59.25	2428800.0
2004-11-03 16:00:00	IWM	ETF	59.255	59.35	59.17	59.275	1096400.0
2004-11-03 17:00:00	IWM	ETF	59.33	59.33	59.33	59.33	400.0
2004-11-03 08:00:00	DIA	ETF	101.62	101.94	101.6	101.85	117700.0
2004-11-03 09:00:00	DIA	ETF	101.85	102.37	101.8	101.97	2867200.0
2004-11-03 10:00:00	DIA	ETF	101.96	102.25	101.62	101.94	1314000.0
2004-11-03 11:00:00	DIA	ETF	101.94	102.15	101.79	101.87	1416200.0
2004-11-03 12:00:00	DIA	ETF	101.87	101.92	101.7	101.8	498400.0
2004-11-03 13:00:00	DIA	ETF	101.79	101.98	101.76	101.84	575800.0
2004-11-03 14:00:00	DIA	ETF	101.84	101.86	101.5	101.58	1067400.0
2004-11-03 15:00:00	DIA	ETF	101.6	101.65	101.14	101.57	1620500.0
2004-11-03 16:00:00	DIA	ETF	101.57	101.75	101.57	101.66	213900.0
2004-11-03 17:00:00	DIA	ETF	101.61	101.61	101.61	101.61	100.0
2004-11-03 08:00:00	TLT	ETF	88.23	88.23	88.01	88.16	36000.0
2004-11-03 09:00:00	TLT	ETF	88.1	88.25	88.0	88.16	484100.0
2004-11-03 10:00:00	TLT	ETF	88.15	88.28	88.1	88.1585	163700.0
2004-11-03 11:00:00	TLT	ETF	88.15	88.27	88.08	88.26	82100.0
2004-11-03 12:00:00	TLT	ETF	88.25	88.46	88.22	88.44	59100.0
2004-11-03 13:00:00	TLT	ETF	88.44	88.5	88.37	88.5	70900.0

> showing 50 of 786 rows — these rows as CSV

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