PREVIEW / etf_1hour / 2005-04-14

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-14.parquet
  size:    32 KB
  rows:    912

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-14 07:00:00	SPY	ETF	117.43	117.45	117.33	117.41	153400.0
2005-04-14 08:00:00	SPY	ETF	117.36	117.47	117.35	117.46	49900.0
2005-04-14 09:00:00	SPY	ETF	117.45	117.5	117.17	117.38	7134300.0
2005-04-14 10:00:00	SPY	ETF	117.37	117.371	116.6	117.11	18733200.0
2005-04-14 11:00:00	SPY	ETF	117.11	117.35	116.95	117.0	8877500.0
2005-04-14 12:00:00	SPY	ETF	116.96	117.04	116.76	116.85	8782500.0
2005-04-14 13:00:00	SPY	ETF	116.86	117.0	116.24	116.6	19344600.0
2005-04-14 14:00:00	SPY	ETF	116.6	116.99	116.5	116.7	12308000.0
2005-04-14 15:00:00	SPY	ETF	116.69	116.78	116.13	116.2	13474100.0
2005-04-14 16:00:00	SPY	ETF	116.19	116.24	115.52	115.54	4635500.0
2005-04-14 17:00:00	SPY	ETF	115.54	115.78	115.38	115.55	1648800.0
2005-04-14 18:00:00	SPY	ETF	115.6	115.62	115.5	115.62	325400.0
2005-04-14 19:00:00	SPY	ETF	115.61	115.67	115.61	115.63	3400.0
2005-04-14 09:00:00	QQQ	ETF	36.06	36.08	35.92	36.02	16182700.0
2005-04-14 10:00:00	QQQ	ETF	36.02	36.03	35.66	35.83	41596600.0
2005-04-14 11:00:00	QQQ	ETF	35.83	35.93	35.75	35.75	12241900.0
2005-04-14 12:00:00	QQQ	ETF	35.75	35.82	35.7	35.74	10338800.0
2005-04-14 13:00:00	QQQ	ETF	35.75	35.9	35.5	35.66	24577500.0
2005-04-14 14:00:00	QQQ	ETF	35.67	35.79	35.63	35.71	18231600.0
2005-04-14 15:00:00	QQQ	ETF	35.71	36.55	35.5	35.56	20981400.0
2005-04-14 07:00:00	IWM	ETF	59.81	59.87	59.81	59.87	4800.0
2005-04-14 08:00:00	IWM	ETF	59.865	59.88	59.86	59.88	21600.0
2005-04-14 09:00:00	IWM	ETF	59.88	60.125	59.625	60.035	5715200.0
2005-04-14 10:00:00	IWM	ETF	60.015	60.02	59.44	59.615	8611000.0
2005-04-14 11:00:00	IWM	ETF	59.61	59.815	59.545	59.55	2977600.0
2005-04-14 12:00:00	IWM	ETF	59.545	59.63	59.34	59.395	1728800.0
2005-04-14 13:00:00	IWM	ETF	59.395	59.395	58.97	59.125	5364400.0
2005-04-14 14:00:00	IWM	ETF	59.1	59.365	59.085	59.145	4585600.0
2005-04-14 15:00:00	IWM	ETF	59.145	59.155	58.79	58.915	5574200.0
2005-04-14 16:00:00	IWM	ETF	58.91	58.925	58.415	58.545	2027400.0
2005-04-14 17:00:00	IWM	ETF	58.5	58.63	58.425	58.495	36000.0
2005-04-14 18:00:00	IWM	ETF	58.495	58.495	58.49	58.49	400.0
2005-04-14 08:00:00	DIA	ETF	104.08	104.08	104.07	104.08	16100.0
2005-04-14 09:00:00	DIA	ETF	104.11	104.17	103.82	104.03	826900.0
2005-04-14 10:00:00	DIA	ETF	104.01	104.01	103.37	103.66	2887800.0
2005-04-14 11:00:00	DIA	ETF	103.66	103.86	103.5	103.5	1110600.0
2005-04-14 12:00:00	DIA	ETF	103.48	103.54	103.26	103.36	1039900.0
2005-04-14 13:00:00	DIA	ETF	103.36	103.4	102.85	103.18	2540200.0
2005-04-14 14:00:00	DIA	ETF	103.16	103.46	103.06	103.27	778100.0
2005-04-14 15:00:00	DIA	ETF	103.26	103.27	102.73	102.87	1127600.0
2005-04-14 16:00:00	DIA	ETF	102.79	102.79	102.05	102.05	263100.0
2005-04-14 17:00:00	DIA	ETF	102.4	102.41	102.02	102.2	34200.0
2005-04-14 18:00:00	DIA	ETF	102.2	102.39	102.2	102.29	2700.0
2005-04-14 19:00:00	DIA	ETF	102.31	102.33	102.31	102.33	800.0
2005-04-14 08:00:00	GLD	ETF	42.66	42.66	42.52	42.52	3600.0
2005-04-14 09:00:00	GLD	ETF	42.45	42.48	42.16	42.25	1835900.0
2005-04-14 10:00:00	GLD	ETF	42.25	42.39	42.22	42.39	369500.0
2005-04-14 11:00:00	GLD	ETF	42.37	42.41	42.3	42.35	601400.0
2005-04-14 12:00:00	GLD	ETF	42.35	42.35	42.262	42.28	67900.0
2005-04-14 13:00:00	GLD	ETF	42.29	42.34	42.25	42.3	174300.0

> showing 50 of 912 rows — these rows as CSV

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