PREVIEW / etf_1hour / 2004-03-03

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-03.parquet
  size:    25 KB
  rows:    676

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-03-03 08:00:00	SPY	ETF	115.27	115.27	115.15	115.2	53400.0
2004-03-03 09:00:00	SPY	ETF	115.21	115.37	115.14	115.28	1926900.0
2004-03-03 10:00:00	SPY	ETF	115.27	115.47	114.92	115.09	6631400.0
2004-03-03 11:00:00	SPY	ETF	115.1	115.4	115.01	115.29	2077400.0
2004-03-03 12:00:00	SPY	ETF	115.29	115.32	115.07	115.22	1532900.0
2004-03-03 13:00:00	SPY	ETF	115.22	115.83	115.16	115.73	4551000.0
2004-03-03 14:00:00	SPY	ETF	115.7	115.87	115.59	115.64	3034000.0
2004-03-03 15:00:00	SPY	ETF	115.63	115.82	115.52	115.7	2921800.0
2004-03-03 16:00:00	SPY	ETF	115.7	115.87	115.57	115.63	1433000.0
2004-03-03 17:00:00	SPY	ETF	115.59	115.67	115.56	115.67	13500.0
2004-03-03 18:00:00	SPY	ETF	115.58	115.58	115.55	115.55	9000.0
2004-03-03 19:00:00	SPY	ETF	115.62	115.62	115.62	115.62	200.0
2004-03-03 08:00:00	QQQ	ETF	36.52	36.54	36.49	36.5	101400.0
2004-03-03 09:00:00	QQQ	ETF	36.5	36.57	36.35	36.45	6637300.0
2004-03-03 10:00:00	QQQ	ETF	36.45	36.55	36.21	36.33	15446500.0
2004-03-03 11:00:00	QQQ	ETF	36.332	36.45	36.28	36.4	5654600.0
2004-03-03 12:00:00	QQQ	ETF	36.39	36.432	36.31	36.35	5234400.0
2004-03-03 13:00:00	QQQ	ETF	36.35	36.63	36.34	36.55	12886900.0
2004-03-03 14:00:00	QQQ	ETF	36.55	36.62	36.43	36.46	10217200.0
2004-03-03 15:00:00	QQQ	ETF	36.46	36.57	36.43	36.48	7842200.0
2004-03-03 16:00:00	QQQ	ETF	36.5	36.5	36.36	36.381	1209200.0
2004-03-03 17:00:00	QQQ	ETF	36.4	36.42	36.38	36.411	51400.0
2004-03-03 18:00:00	QQQ	ETF	36.4	36.411	36.38	36.39	63000.0
2004-03-03 19:00:00	QQQ	ETF	36.39	36.42	36.39	36.42	10600.0
2004-03-03 09:00:00	IWM	ETF	58.69	58.755	58.325	58.43	1465000.0
2004-03-03 10:00:00	IWM	ETF	58.425	58.505	58.285	58.4	803200.0
2004-03-03 11:00:00	IWM	ETF	58.41	58.605	58.39	58.5935	495400.0
2004-03-03 12:00:00	IWM	ETF	58.6	58.615	58.482	58.525	239400.0
2004-03-03 13:00:00	IWM	ETF	58.525	59.06	58.525	59.025	1088200.0
2004-03-03 14:00:00	IWM	ETF	59.015	59.16	58.95	59.04	1021400.0
2004-03-03 15:00:00	IWM	ETF	59.045	59.1	58.845	58.975	690000.0
2004-03-03 16:00:00	IWM	ETF	58.96	58.975	58.815	58.865	180600.0
2004-03-03 18:00:00	IWM	ETF	58.86	58.86	58.86	58.86	200.0
2004-03-03 08:00:00	DIA	ETF	105.84	105.84	105.77	105.78	5300.0
2004-03-03 09:00:00	DIA	ETF	105.84	105.99	105.8	105.9	278800.0
2004-03-03 10:00:00	DIA	ETF	105.9	106.089	105.644	105.84	1187100.0
2004-03-03 11:00:00	DIA	ETF	105.82	105.97	105.75	105.9	328600.0
2004-03-03 12:00:00	DIA	ETF	105.89	105.94	105.73	105.8	371900.0
2004-03-03 13:00:00	DIA	ETF	105.82	106.26	105.81	106.16	746000.0
2004-03-03 14:00:00	DIA	ETF	106.168	106.25	106.07	106.1	355000.0
2004-03-03 15:00:00	DIA	ETF	106.11	106.23	105.99	106.11	263000.0
2004-03-03 16:00:00	DIA	ETF	106.13	106.14	106.027	106.06	73200.0
2004-03-03 17:00:00	DIA	ETF	106.03	106.03	106.03	106.03	200.0
2004-03-03 09:00:00	TLT	ETF	87.39	87.45	87.31	87.43	182700.0
2004-03-03 10:00:00	TLT	ETF	87.4	87.55	87.18	87.24	53100.0
2004-03-03 11:00:00	TLT	ETF	87.22	87.25	87.11	87.25	75500.0
2004-03-03 12:00:00	TLT	ETF	87.21	87.33	87.21	87.32	3000.0
2004-03-03 13:00:00	TLT	ETF	87.35	87.5	87.33	87.49	48500.0
2004-03-03 14:00:00	TLT	ETF	87.433	87.58	87.433	87.58	104400.0
2004-03-03 15:00:00	TLT	ETF	87.56	87.61	87.55	87.58	81800.0

> showing 50 of 676 rows — these rows as CSV

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