PREVIEW / etf_1hour / 2004-09-16

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-16.parquet
  size:    25 KB
  rows:    683

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-16 08:00:00	SPY	ETF	112.8	112.9	112.76	112.85	90000.0
2004-09-16 09:00:00	SPY	ETF	112.85	113.11	112.8	113.11	3082700.0
2004-09-16 10:00:00	SPY	ETF	113.11	113.37	113.07	113.26	4460300.0
2004-09-16 11:00:00	SPY	ETF	113.26	113.3	113.13	113.16	1849600.0
2004-09-16 12:00:00	SPY	ETF	113.17	113.28	112.99	113.17	3693600.0
2004-09-16 13:00:00	SPY	ETF	113.17	113.27	113.11	113.23	1750200.0
2004-09-16 14:00:00	SPY	ETF	113.2316	113.33	113.17	113.19	2186600.0
2004-09-16 15:00:00	SPY	ETF	113.18	113.2	112.92	113.1	4249500.0
2004-09-16 16:00:00	SPY	ETF	113.1	113.22	113.06	113.17	1360300.0
2004-09-16 17:00:00	SPY	ETF	113.14	113.15	113.1	113.12	109200.0
2004-09-16 18:00:00	SPY	ETF	113.12	113.13	113.12	113.12	5100.0
2004-09-16 19:00:00	SPY	ETF	113.12	113.12	113.11	113.11	1300.0
2004-09-16 08:00:00	QQQ	ETF	35.26	35.29	35.21	35.29	133500.0
2004-09-16 09:00:00	QQQ	ETF	35.28	35.42	35.25	35.41	9700600.0
2004-09-16 10:00:00	QQQ	ETF	35.41	35.57	35.4	35.51	12362100.0
2004-09-16 11:00:00	QQQ	ETF	35.51	35.52	35.36	35.39	7518800.0
2004-09-16 12:00:00	QQQ	ETF	35.39	35.43	35.29	35.37	9503400.0
2004-09-16 13:00:00	QQQ	ETF	35.371	35.401	35.31	35.38	3836700.0
2004-09-16 14:00:00	QQQ	ETF	35.38	35.44	35.26	35.287	6918100.0
2004-09-16 15:00:00	QQQ	ETF	35.288	35.3	35.13	35.241	14376800.0
2004-09-16 16:00:00	QQQ	ETF	35.246	35.34	35.24	35.3	2208800.0
2004-09-16 17:00:00	QQQ	ETF	35.29	35.34	35.285	35.34	131300.0
2004-09-16 18:00:00	QQQ	ETF	35.34	35.34	35.32	35.33	20900.0
2004-09-16 19:00:00	QQQ	ETF	35.32	35.32	35.31	35.32	24400.0
2004-09-16 09:00:00	IWM	ETF	56.78	57.125	56.78	57.1	1345400.0
2004-09-16 10:00:00	IWM	ETF	57.115	57.415	57.11	57.36	1955200.0
2004-09-16 11:00:00	IWM	ETF	57.355	57.4	57.21	57.23	790600.0
2004-09-16 12:00:00	IWM	ETF	57.23	57.265	57.115	57.265	1772400.0
2004-09-16 13:00:00	IWM	ETF	57.27	57.32	57.23	57.28	420200.0
2004-09-16 14:00:00	IWM	ETF	57.3	57.395	57.215	57.29	1274600.0
2004-09-16 15:00:00	IWM	ETF	57.3	57.3	57.025	57.21	1399800.0
2004-09-16 16:00:00	IWM	ETF	57.24	57.345	57.22	57.23	256400.0
2004-09-16 08:00:00	DIA	ETF	102.62	102.65	102.62	102.65	200.0
2004-09-16 09:00:00	DIA	ETF	102.67	102.81	102.67	102.78	613300.0
2004-09-16 10:00:00	DIA	ETF	102.77	103.1	102.74	102.98	1332600.0
2004-09-16 11:00:00	DIA	ETF	102.98	103.01	102.9	102.91	384800.0
2004-09-16 12:00:00	DIA	ETF	102.93	102.97	102.77	102.91	410200.0
2004-09-16 13:00:00	DIA	ETF	102.92	102.94	102.87	102.91	185000.0
2004-09-16 14:00:00	DIA	ETF	102.91	102.99	102.76	102.8	521000.0
2004-09-16 15:00:00	DIA	ETF	102.8	102.84	102.58	102.67	1719600.0
2004-09-16 16:00:00	DIA	ETF	102.67	102.8	102.67	102.75	158500.0
2004-09-16 17:00:00	DIA	ETF	102.77	102.77	102.77	102.77	500.0
2004-09-16 08:00:00	TLT	ETF	87.53	87.53	87.28	87.35	2200.0
2004-09-16 09:00:00	TLT	ETF	87.56	87.64	87.5	87.63	16800.0
2004-09-16 10:00:00	TLT	ETF	87.65	87.76	87.59	87.74	158400.0
2004-09-16 11:00:00	TLT	ETF	87.75	87.79	87.74	87.76	9800.0
2004-09-16 12:00:00	TLT	ETF	87.78	88.14	87.78	88.14	238000.0
2004-09-16 13:00:00	TLT	ETF	88.1	88.37	88.08	88.33	109800.0
2004-09-16 14:00:00	TLT	ETF	88.3	88.48	88.3	88.32	271900.0
2004-09-16 15:00:00	TLT	ETF	88.32	88.35	88.23	88.28	146500.0

> showing 50 of 683 rows — these rows as CSV

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