PREVIEW / etf_1hour / 2005-04-26

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-26.parquet
  size:    29 KB
  rows:    847

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
2005-04-26 06:00:00	SPY	ETF	115.81	115.82	115.78	115.82	20200.0
2005-04-26 07:00:00	SPY	ETF	115.87	116.03	115.85	116.0	201000.0
2005-04-26 08:00:00	SPY	ETF	115.99	116.06	115.91	115.93	77900.0
2005-04-26 09:00:00	SPY	ETF	115.94	116.11	115.81	115.84	5424100.0
2005-04-26 10:00:00	SPY	ETF	115.85	116.77	115.7	116.65	15678500.0
2005-04-26 11:00:00	SPY	ETF	116.65	116.65	116.11	116.27	6279900.0
2005-04-26 12:00:00	SPY	ETF	116.27	116.28	116.05	116.1	3544200.0
2005-04-26 13:00:00	SPY	ETF	116.1	116.14	115.73	116.06	8745400.0
2005-04-26 14:00:00	SPY	ETF	116.05	116.09	115.44	115.48	13165600.0
2005-04-26 15:00:00	SPY	ETF	115.47	115.87	115.22	115.22	15744100.0
2005-04-26 16:00:00	SPY	ETF	115.21	115.64	115.13	115.18	2684000.0
2005-04-26 17:00:00	SPY	ETF	115.18	115.21	115.15	115.21	225800.0
2005-04-26 18:00:00	SPY	ETF	115.2	115.2	115.1	115.15	13800.0
2005-04-26 19:00:00	SPY	ETF	115.15	115.15	115.15	115.15	100.0
2005-04-26 09:00:00	QQQ	ETF	35.29	35.36	35.25	35.29	9603600.0
2005-04-26 10:00:00	QQQ	ETF	35.3	35.67	35.18	35.65	22812400.0
2005-04-26 11:00:00	QQQ	ETF	35.66	35.7	35.46	35.5	9414300.0
2005-04-26 12:00:00	QQQ	ETF	35.51	35.52	35.37	35.42	5591700.0
2005-04-26 13:00:00	QQQ	ETF	35.42	35.42	35.18	35.29	12157000.0
2005-04-26 14:00:00	QQQ	ETF	35.29	35.3	35.06	35.08	17003500.0
2005-04-26 15:00:00	QQQ	ETF	35.08	35.22	35.04	35.05	15787600.0
2005-04-26 08:00:00	IWM	ETF	59.05	59.05	58.95	58.95	8200.0
2005-04-26 09:00:00	IWM	ETF	58.975	59.08	58.83	58.905	1405400.0
2005-04-26 10:00:00	IWM	ETF	58.9	59.555	58.69	59.555	6619000.0
2005-04-26 11:00:00	IWM	ETF	59.55	59.565	58.975	59.08	3584000.0
2005-04-26 12:00:00	IWM	ETF	59.07	59.145	58.025	58.9	2286400.0
2005-04-26 13:00:00	IWM	ETF	58.89	58.915	58.595	58.87	4299200.0
2005-04-26 14:00:00	IWM	ETF	58.855	58.86	58.36	58.395	4166000.0
2005-04-26 15:00:00	IWM	ETF	58.39	58.63	58.345	58.415	6805400.0
2005-04-26 16:00:00	IWM	ETF	58.38	58.44	58.315	58.375	597400.0
2005-04-26 07:00:00	DIA	ETF	102.11	102.12	102.11	102.12	8100.0
2005-04-26 08:00:00	DIA	ETF	102.14	102.16	102.05	102.05	2600.0
2005-04-26 09:00:00	DIA	ETF	102.04	102.24	101.99	102.0	583900.0
2005-04-26 10:00:00	DIA	ETF	102.01	102.58	101.89	102.54	1254200.0
2005-04-26 11:00:00	DIA	ETF	102.56	102.62	102.25	102.28	829500.0
2005-04-26 12:00:00	DIA	ETF	102.28	102.31	102.14	102.21	447400.0
2005-04-26 13:00:00	DIA	ETF	102.21	102.25	101.85	102.19	643800.0
2005-04-26 14:00:00	DIA	ETF	102.15	102.18	101.54	101.58	893900.0
2005-04-26 15:00:00	DIA	ETF	101.59	101.96	101.48	101.48	1086200.0
2005-04-26 16:00:00	DIA	ETF	101.49	101.52	101.43	101.46	115000.0
2005-04-26 18:00:00	DIA	ETF	101.45	101.45	101.35	101.35	2700.0
2005-04-26 19:00:00	DIA	ETF	101.45	101.45	101.45	101.45	500.0
2005-04-26 08:00:00	GLD	ETF	43.67	43.67	43.67	43.67	100.0
2005-04-26 09:00:00	GLD	ETF	43.69	43.7	43.64	43.68	140400.0
2005-04-26 10:00:00	GLD	ETF	43.69	43.69	43.51	43.52	463900.0
2005-04-26 11:00:00	GLD	ETF	43.5	43.56	43.5	43.54	82200.0
2005-04-26 12:00:00	GLD	ETF	43.53	43.62	43.53	43.59	114600.0
2005-04-26 13:00:00	GLD	ETF	43.6	43.68	43.6	43.64	533600.0
2005-04-26 14:00:00	GLD	ETF	43.64	43.65	43.61	43.64	93400.0
2005-04-26 15:00:00	GLD	ETF	43.65	43.67	43.63	43.63	103000.0

> showing 50 of 847 rows — these rows as CSV

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