PREVIEW / etf_1hour / 2004-09-21

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-21.parquet
  size:    24 KB
  rows:    677

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-21 08:00:00	SPY	ETF	112.74	112.83	112.74	112.8	23900.0
2004-09-21 09:00:00	SPY	ETF	112.79	112.8	112.59	112.6	3568900.0
2004-09-21 10:00:00	SPY	ETF	112.61	112.75	112.54	112.71	3767900.0
2004-09-21 11:00:00	SPY	ETF	112.71	112.86	112.7	112.76	3408500.0
2004-09-21 12:00:00	SPY	ETF	112.78	112.87	112.73	112.85	1486300.0
2004-09-21 13:00:00	SPY	ETF	112.8215	112.96	112.8	112.94	2142800.0
2004-09-21 14:00:00	SPY	ETF	112.94	113.43	112.79	113.39	11877300.0
2004-09-21 15:00:00	SPY	ETF	113.39	113.47	113.16	113.24	9275800.0
2004-09-21 16:00:00	SPY	ETF	113.24	113.25	112.89	112.95	2059400.0
2004-09-21 17:00:00	SPY	ETF	112.95	112.96	112.92	112.93	19700.0
2004-09-21 18:00:00	SPY	ETF	112.96	112.96	112.88	112.88	18300.0
2004-09-21 08:00:00	QQQ	ETF	35.53	35.6	35.53	35.58	182400.0
2004-09-21 09:00:00	QQQ	ETF	35.58	35.602	35.45	35.52	12489200.0
2004-09-21 10:00:00	QQQ	ETF	35.517	35.564	35.44	35.53	11132800.0
2004-09-21 11:00:00	QQQ	ETF	35.53	35.61	35.52	35.55	5663200.0
2004-09-21 12:00:00	QQQ	ETF	35.54	35.59	35.52	35.58	3555000.0
2004-09-21 13:00:00	QQQ	ETF	35.58	35.68	35.57	35.65	3822400.0
2004-09-21 14:00:00	QQQ	ETF	35.65	35.81	35.53	35.806	24589400.0
2004-09-21 15:00:00	QQQ	ETF	35.809	35.84	35.66	35.67	21245100.0
2004-09-21 16:00:00	QQQ	ETF	35.67	35.71	35.543	35.57	9436700.0
2004-09-21 17:00:00	QQQ	ETF	35.57	35.58	35.56	35.58	38400.0
2004-09-21 18:00:00	QQQ	ETF	35.58	35.58	35.55	35.55	46500.0
2004-09-21 19:00:00	QQQ	ETF	35.56	35.57	35.55	35.55	8100.0
2004-09-21 08:00:00	IWM	ETF	57.175	57.175	57.175	57.175	1000.0
2004-09-21 09:00:00	IWM	ETF	57.215	57.265	57.105	57.25	918600.0
2004-09-21 10:00:00	IWM	ETF	57.25	57.25	57.14	57.18	717600.0
2004-09-21 11:00:00	IWM	ETF	57.19	57.31	57.18	57.22	789600.0
2004-09-21 12:00:00	IWM	ETF	57.215	57.275	57.215	57.265	118400.0
2004-09-21 13:00:00	IWM	ETF	57.265	57.46	57.25	57.455	581400.0
2004-09-21 14:00:00	IWM	ETF	57.45	57.675	57.24	57.655	1826600.0
2004-09-21 15:00:00	IWM	ETF	57.655	57.675	57.485	57.57	2668600.0
2004-09-21 16:00:00	IWM	ETF	57.54	57.57	57.355	57.355	634600.0
2004-09-21 17:00:00	IWM	ETF	57.35	57.35	57.35	57.35	1000.0
2004-09-21 18:00:00	IWM	ETF	57.38	57.39	57.38	57.39	3800.0
2004-09-21 08:00:00	DIA	ETF	102.44	102.5	102.42	102.46	5300.0
2004-09-21 09:00:00	DIA	ETF	102.43	102.48	102.18	102.2	584900.0
2004-09-21 10:00:00	DIA	ETF	102.21	102.29	102.14	102.23	591200.0
2004-09-21 11:00:00	DIA	ETF	102.23	102.35	102.22	102.3	481200.0
2004-09-21 12:00:00	DIA	ETF	102.31	102.34	102.22	102.3	123700.0
2004-09-21 13:00:00	DIA	ETF	102.3	102.36	102.24	102.36	532400.0
2004-09-21 14:00:00	DIA	ETF	102.36	102.78	102.23	102.76	1609400.0
2004-09-21 15:00:00	DIA	ETF	102.79	102.88	102.52	102.59	2261600.0
2004-09-21 16:00:00	DIA	ETF	102.58	102.6	102.31	102.31	124400.0
2004-09-21 17:00:00	DIA	ETF	102.4	102.43	102.35	102.35	900.0
2004-09-21 18:00:00	DIA	ETF	102.35	102.35	102.35	102.35	900.0
2004-09-21 08:00:00	TLT	ETF	88.24	88.24	88.24	88.24	2000.0
2004-09-21 09:00:00	TLT	ETF	88.27	88.39	88.27	88.33	43800.0
2004-09-21 10:00:00	TLT	ETF	88.31	88.37	88.29	88.37	69600.0
2004-09-21 11:00:00	TLT	ETF	88.35	88.46	88.34	88.41	72000.0
2004-09-21 12:00:00	TLT	ETF	88.4	88.4	88.33	88.38	30600.0

> showing 50 of 677 rows — these rows as CSV

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