PREVIEW / etf_1hour / 2004-12-20

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-20.parquet
  size:    28 KB
  rows:    783

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-12-20 08:00:00	SPY	ETF	119.86	119.89	119.81	119.83	56800.0
2004-12-20 09:00:00	SPY	ETF	119.83	120.29	119.73	120.17	6558600.0
2004-12-20 10:00:00	SPY	ETF	120.17	120.21	119.89	120.04	7267500.0
2004-12-20 11:00:00	SPY	ETF	120.04	120.04	119.51	119.59	4563700.0
2004-12-20 12:00:00	SPY	ETF	119.59	119.63	119.35	119.53	6410200.0
2004-12-20 13:00:00	SPY	ETF	119.53	119.64	119.21	119.27	4280500.0
2004-12-20 14:00:00	SPY	ETF	119.27	119.51	119.17	119.36	5415800.0
2004-12-20 15:00:00	SPY	ETF	119.36	119.42	119.23	119.27	6164200.0
2004-12-20 16:00:00	SPY	ETF	119.27	119.52	119.27	119.32	4091200.0
2004-12-20 17:00:00	SPY	ETF	119.47	119.5	119.42	119.5	49700.0
2004-12-20 18:00:00	SPY	ETF	119.48	119.55	119.48	119.51	3900.0
2004-12-20 19:00:00	SPY	ETF	119.52	119.52	119.52	119.52	500.0
2004-12-20 08:00:00	QQQ	ETF	39.64	39.77	39.62	39.631	662038.0
2004-12-20 09:00:00	QQQ	ETF	39.62	39.771	39.55	39.717	15656185.0
2004-12-20 10:00:00	QQQ	ETF	39.717	39.77	39.55	39.585	15004411.0
2004-12-20 11:00:00	QQQ	ETF	39.59	39.59	39.3	39.34	14656449.0
2004-12-20 12:00:00	QQQ	ETF	39.34	39.35	39.22	39.29	12958452.0
2004-12-20 13:00:00	QQQ	ETF	39.29	39.37	39.1	39.13	13807500.0
2004-12-20 14:00:00	QQQ	ETF	39.13	39.295	39.09	39.201	12604376.0
2004-12-20 15:00:00	QQQ	ETF	39.201	39.25	39.14	39.21	10238352.0
2004-12-20 16:00:00	QQQ	ETF	39.2	39.34	39.15	39.29	6165452.0
2004-12-20 17:00:00	QQQ	ETF	39.3	39.32	39.2	39.22	261624.0
2004-12-20 18:00:00	QQQ	ETF	39.247	39.6881	39.22	39.3	244044.0
2004-12-20 09:00:00	IWM	ETF	64.075	64.47	64.03	64.39	1771000.0
2004-12-20 10:00:00	IWM	ETF	64.39	64.435	64.215	64.32	2179000.0
2004-12-20 11:00:00	IWM	ETF	64.32	64.32	63.845	63.895	1895000.0
2004-12-20 12:00:00	IWM	ETF	63.895	63.92	63.715	63.805	1329400.0
2004-12-20 13:00:00	IWM	ETF	63.805	63.91	63.52	63.57	701200.0
2004-12-20 14:00:00	IWM	ETF	63.57	63.79	63.51	63.695	1454800.0
2004-12-20 15:00:00	IWM	ETF	63.695	63.765	63.6	63.69	1998000.0
2004-12-20 16:00:00	IWM	ETF	63.68	63.87	63.68	63.87	232800.0
2004-12-20 08:00:00	DIA	ETF	106.87	106.9	106.83	106.87	13600.0
2004-12-20 09:00:00	DIA	ETF	106.83	107.15	106.76	107.11	986700.0
2004-12-20 10:00:00	DIA	ETF	107.12	107.13	106.84	106.95	1348900.0
2004-12-20 11:00:00	DIA	ETF	106.96	106.96	106.59	106.67	834400.0
2004-12-20 12:00:00	DIA	ETF	106.66	106.7	106.49	106.68	614600.0
2004-12-20 13:00:00	DIA	ETF	106.68	106.73	106.39	106.46	432200.0
2004-12-20 14:00:00	DIA	ETF	106.46	106.68	106.35	106.54	644600.0
2004-12-20 15:00:00	DIA	ETF	106.54	106.59	106.41	106.47	748700.0
2004-12-20 16:00:00	DIA	ETF	106.46	106.64	106.43	106.63	199200.0
2004-12-20 18:00:00	DIA	ETF	106.65	106.65	106.65	106.65	100.0
2004-12-20 09:00:00	GLD	ETF	44.33	44.35	44.28	44.29	214100.0
2004-12-20 10:00:00	GLD	ETF	44.3	44.33	44.2	44.33	127300.0
2004-12-20 11:00:00	GLD	ETF	44.33	44.37	44.3	44.33	166100.0
2004-12-20 12:00:00	GLD	ETF	44.33	44.34	44.13	44.18	161700.0
2004-12-20 13:00:00	GLD	ETF	44.19	44.27	44.17	44.25	48100.0
2004-12-20 14:00:00	GLD	ETF	44.25	44.3	44.23	44.3	742400.0
2004-12-20 15:00:00	GLD	ETF	44.29	44.35	44.28	44.35	480000.0
2004-12-20 16:00:00	GLD	ETF	44.36	44.36	44.34	44.34	1600.0
2004-12-20 08:00:00	TLT	ETF	88.91	88.91	88.9	88.9	2000.0

> showing 50 of 783 rows — these rows as CSV

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