PREVIEW / etf_1hour / 2005-04-04

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-04.parquet
  size:    30 KB
  rows:    866

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-04 08:00:00	SPY	ETF	117.11	117.31	117.1	117.28	237300.0
2005-04-04 09:00:00	SPY	ETF	117.3	117.43	117.0	117.05	8542400.0
2005-04-04 10:00:00	SPY	ETF	117.06	117.15	116.74	117.09	14866300.0
2005-04-04 11:00:00	SPY	ETF	117.07	117.37	117.0	117.11	8126700.0
2005-04-04 12:00:00	SPY	ETF	117.1	117.17	116.85	117.05	4966000.0
2005-04-04 13:00:00	SPY	ETF	117.06	117.44	116.79	117.42	9972700.0
2005-04-04 14:00:00	SPY	ETF	117.42	117.75	117.35	117.67	8796600.0
2005-04-04 15:00:00	SPY	ETF	117.66	117.86	117.5	117.59	12691500.0
2005-04-04 16:00:00	SPY	ETF	117.58	117.77	117.54	117.77	1414700.0
2005-04-04 17:00:00	SPY	ETF	117.76	117.78	117.74	117.74	24300.0
2005-04-04 18:00:00	SPY	ETF	117.74	117.75	117.73	117.73	5500.0
2005-04-04 19:00:00	SPY	ETF	117.74	117.74	117.7	117.7	600.0
2005-04-04 09:00:00	QQQ	ETF	36.26	36.27	36.1	36.11	13620700.0
2005-04-04 10:00:00	QQQ	ETF	36.12	36.23	36.03	36.23	19539500.0
2005-04-04 11:00:00	QQQ	ETF	36.22	36.31	36.14	36.17	10848000.0
2005-04-04 12:00:00	QQQ	ETF	36.16	36.21	36.08	36.18	6070400.0
2005-04-04 13:00:00	QQQ	ETF	36.18	36.3	36.07	36.3	8899600.0
2005-04-04 14:00:00	QQQ	ETF	36.29	36.52	36.29	36.47	17418900.0
2005-04-04 15:00:00	QQQ	ETF	36.47	36.6	36.42	36.45	14679100.0
2005-04-04 08:00:00	IWM	ETF	60.665	60.735	60.665	60.675	36200.0
2005-04-04 09:00:00	IWM	ETF	60.725	60.825	60.55	60.583	3327200.0
2005-04-04 10:00:00	IWM	ETF	60.575	60.605	60.2	60.44	5280600.0
2005-04-04 11:00:00	IWM	ETF	60.44	60.585	60.355	60.4	2675600.0
2005-04-04 12:00:00	IWM	ETF	60.4	60.425	60.285	60.39	2239400.0
2005-04-04 13:00:00	IWM	ETF	60.39	60.63	60.265	60.625	2020000.0
2005-04-04 14:00:00	IWM	ETF	60.625	60.915	60.62	60.86	6204800.0
2005-04-04 15:00:00	IWM	ETF	60.86	61.19	60.825	61.02	7248600.0
2005-04-04 16:00:00	IWM	ETF	61.015	61.115	61.0	61.115	510000.0
2005-04-04 08:00:00	DIA	ETF	103.89	104.02	103.89	104.02	5600.0
2005-04-04 09:00:00	DIA	ETF	104.04	104.09	103.72	103.72	819300.0
2005-04-04 10:00:00	DIA	ETF	103.71	104.82	103.46	103.87	3812100.0
2005-04-04 11:00:00	DIA	ETF	103.86	104.09	103.74	103.9	1133500.0
2005-04-04 12:00:00	DIA	ETF	103.9	103.93	103.65	103.79	907200.0
2005-04-04 13:00:00	DIA	ETF	103.781	104.19	103.55	104.18	1782900.0
2005-04-04 14:00:00	DIA	ETF	104.18	104.39	104.08	104.32	1441100.0
2005-04-04 15:00:00	DIA	ETF	104.31	104.39	104.07	104.08	1543500.0
2005-04-04 16:00:00	DIA	ETF	104.07	104.25	104.07	104.25	35800.0
2005-04-04 17:00:00	DIA	ETF	104.26	104.27	104.25	104.27	700.0
2005-04-04 19:00:00	DIA	ETF	104.25	104.26	104.25	104.26	1100.0
2005-04-04 09:00:00	GLD	ETF	42.43	42.43	42.36	42.41	502700.0
2005-04-04 10:00:00	GLD	ETF	42.42	42.42	42.23	42.3	1002300.0
2005-04-04 11:00:00	GLD	ETF	42.29	42.34	42.27	42.34	78500.0
2005-04-04 12:00:00	GLD	ETF	42.33	42.38	42.31	42.33	110700.0
2005-04-04 13:00:00	GLD	ETF	42.35	42.36	42.31	42.33	36300.0
2005-04-04 14:00:00	GLD	ETF	42.33	42.38	42.31	42.37	23500.0
2005-04-04 15:00:00	GLD	ETF	42.35	42.41	42.35	42.4	120800.0
2005-04-04 16:00:00	GLD	ETF	42.35	42.35	42.35	42.35	1000.0
2005-04-04 09:00:00	TLT	ETF	89.28	89.31	89.17	89.29	127300.0
2005-04-04 10:00:00	TLT	ETF	89.3	89.53	89.25	89.44	275300.0
2005-04-04 11:00:00	TLT	ETF	89.38	89.52	89.34	89.5	59900.0

> showing 50 of 866 rows — these rows as CSV

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