PREVIEW / etf_1hour / 2004-09-14

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-14.parquet
  size:    24 KB
  rows:    679

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-09-14 08:00:00	SPY	ETF	113.42	113.42	113.32	113.35	288800.0
2004-09-14 09:00:00	SPY	ETF	113.35	113.44	113.19	113.33	5222200.0
2004-09-14 10:00:00	SPY	ETF	113.33	113.38	113.19	113.23	4068300.0
2004-09-14 11:00:00	SPY	ETF	113.23	113.38	113.21	113.35	1938000.0
2004-09-14 12:00:00	SPY	ETF	113.34	113.65	113.32	113.62	3866100.0
2004-09-14 13:00:00	SPY	ETF	113.62	113.69	113.31	113.43	2654100.0
2004-09-14 14:00:00	SPY	ETF	113.42	113.59	113.34	113.54	2211600.0
2004-09-14 15:00:00	SPY	ETF	113.54	113.68	113.44	113.61	5318900.0
2004-09-14 16:00:00	SPY	ETF	113.61	113.69	113.54	113.59	1619000.0
2004-09-14 17:00:00	SPY	ETF	113.58	113.62	113.55	113.6	14700.0
2004-09-14 18:00:00	SPY	ETF	113.58	113.58	113.49	113.55	5900.0
2004-09-14 19:00:00	SPY	ETF	113.56	113.57	113.56	113.56	500.0
2004-09-14 08:00:00	QQQ	ETF	35.47	35.55	35.4	35.49	112800.0
2004-09-14 09:00:00	QQQ	ETF	35.49	35.54	35.39	35.45	11365600.0
2004-09-14 10:00:00	QQQ	ETF	35.45	35.56	35.36	35.464	11902300.0
2004-09-14 11:00:00	QQQ	ETF	35.46	35.58	35.46	35.55	6486900.0
2004-09-14 12:00:00	QQQ	ETF	35.55	35.68	35.53	35.66	11455300.0
2004-09-14 13:00:00	QQQ	ETF	35.66	35.72	35.539	35.599	7849600.0
2004-09-14 14:00:00	QQQ	ETF	35.599	35.63	35.5	35.59	6849400.0
2004-09-14 15:00:00	QQQ	ETF	35.58	35.7	35.57	35.65	15188600.0
2004-09-14 16:00:00	QQQ	ETF	35.65	35.7	35.52	35.579	1748200.0
2004-09-14 17:00:00	QQQ	ETF	35.58	35.6	35.429	35.58	450700.0
2004-09-14 18:00:00	QQQ	ETF	35.57	35.57	35.526	35.55	46400.0
2004-09-14 19:00:00	QQQ	ETF	35.55	35.56	35.54	35.55	8100.0
2004-09-14 08:00:00	IWM	ETF	57.08	57.1	57.08	57.09	5800.0
2004-09-14 09:00:00	IWM	ETF	57.03	57.18	56.78	56.84	1763400.0
2004-09-14 10:00:00	IWM	ETF	56.805	56.825	56.58	56.66	1744800.0
2004-09-14 11:00:00	IWM	ETF	56.665	56.825	56.655	56.81	552800.0
2004-09-14 12:00:00	IWM	ETF	56.805	57.075	56.795	57.04	958400.0
2004-09-14 13:00:00	IWM	ETF	57.05	57.09	56.86	56.935	642400.0
2004-09-14 14:00:00	IWM	ETF	56.935	56.98	56.72	56.835	1048800.0
2004-09-14 15:00:00	IWM	ETF	56.84	57.02	56.8	57.015	1613000.0
2004-09-14 16:00:00	IWM	ETF	57.01	57.055	56.85	57.025	178800.0
2004-09-14 17:00:00	IWM	ETF	56.97	56.97	56.3	56.3	22800.0
2004-09-14 08:00:00	DIA	ETF	103.45	103.45	103.39	103.39	1400.0
2004-09-14 09:00:00	DIA	ETF	103.39	103.49	103.26	103.34	910900.0
2004-09-14 10:00:00	DIA	ETF	103.34	103.4	103.25	103.31	514800.0
2004-09-14 11:00:00	DIA	ETF	103.3	103.4	103.26	103.37	274900.0
2004-09-14 12:00:00	DIA	ETF	103.36	103.6	103.35	103.59	449800.0
2004-09-14 13:00:00	DIA	ETF	103.59	103.62	103.31	103.38	265500.0
2004-09-14 14:00:00	DIA	ETF	103.39	103.49	103.29	103.44	361000.0
2004-09-14 15:00:00	DIA	ETF	103.46	103.56	103.36	103.45	578900.0
2004-09-14 16:00:00	DIA	ETF	103.48	103.54	103.44	103.45	24100.0
2004-09-14 17:00:00	DIA	ETF	103.49	103.54	103.49	103.53	1200.0
2004-09-14 18:00:00	DIA	ETF	103.49	103.49	103.49	103.49	200.0
2004-09-14 19:00:00	DIA	ETF	103.4	103.4	103.4	103.4	400.0
2004-09-14 08:00:00	TLT	ETF	87.58	87.58	87.58	87.58	500.0
2004-09-14 09:00:00	TLT	ETF	87.4	87.4	87.18	87.31	126900.0
2004-09-14 10:00:00	TLT	ETF	87.31	87.45	87.25	87.41	202900.0
2004-09-14 11:00:00	TLT	ETF	87.45	87.59	87.41	87.52	12800.0

> showing 50 of 679 rows — these rows as CSV

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