PREVIEW / etf_1hour / 2005-07-07

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-07-07.parquet
  size:    31 KB
  rows:    928

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-07-07 04:00:00	SPY	ETF	119.2	119.39	119.03	119.03	22200.0
2005-07-07 05:00:00	SPY	ETF	118.73	118.91	117.44	117.44	68300.0
2005-07-07 06:00:00	SPY	ETF	117.3	117.61	116.83	117.22	397600.0
2005-07-07 07:00:00	SPY	ETF	117.21	118.06	117.21	117.85	1269500.0
2005-07-07 08:00:00	SPY	ETF	117.9	118.11	117.06	118.1	2179100.0
2005-07-07 09:00:00	SPY	ETF	118.09	118.9	118.07	118.49	19972100.0
2005-07-07 10:00:00	SPY	ETF	118.49	118.87	118.4	118.5	19459700.0
2005-07-07 11:00:00	SPY	ETF	118.5	119.12	118.28	119.1	11569300.0
2005-07-07 12:00:00	SPY	ETF	119.1	119.45	118.98	119.1	13848700.0
2005-07-07 13:00:00	SPY	ETF	119.11	119.54	119.07	119.36	6117600.0
2005-07-07 14:00:00	SPY	ETF	119.36	119.38	119.07	119.34	6643800.0
2005-07-07 15:00:00	SPY	ETF	119.34	119.89	119.11	119.77	13576600.0
2005-07-07 16:00:00	SPY	ETF	119.76	120.4	119.61	119.96	1181400.0
2005-07-07 17:00:00	SPY	ETF	119.96	120.0	119.95	119.95	75600.0
2005-07-07 18:00:00	SPY	ETF	119.97	120.0	119.93	119.98	13500.0
2005-07-07 19:00:00	SPY	ETF	119.96	120.13	119.96	120.13	6500.0
2005-07-07 09:00:00	QQQ	ETF	36.58	36.82	36.55	36.62	27732300.0
2005-07-07 10:00:00	QQQ	ETF	36.62	36.75	36.6	36.6	18912700.0
2005-07-07 11:00:00	QQQ	ETF	36.6	37.73	36.55	36.84	14733100.0
2005-07-07 12:00:00	QQQ	ETF	36.84	37.0	35.96	36.87	15017900.0
2005-07-07 13:00:00	QQQ	ETF	36.87	37.08	36.86	36.99	8950800.0
2005-07-07 14:00:00	QQQ	ETF	36.99	37.0	36.87	36.96	8065100.0
2005-07-07 15:00:00	QQQ	ETF	36.96	37.09	36.95	37.05	14304600.0
2005-07-07 07:00:00	IWM	ETF	62.99	63.29	62.99	63.19	37800.0
2005-07-07 08:00:00	IWM	ETF	63.19	63.38	63.11	63.38	148000.0
2005-07-07 09:00:00	IWM	ETF	63.38	64.1	63.38	63.71	7860100.0
2005-07-07 10:00:00	IWM	ETF	63.71	63.97	63.59	63.6	6805100.0
2005-07-07 11:00:00	IWM	ETF	63.6	63.92	63.47	63.91	4676900.0
2005-07-07 12:00:00	IWM	ETF	63.93	64.27	63.89	64.15	2515000.0
2005-07-07 13:00:00	IWM	ETF	64.15	64.69	64.14	64.51	4383500.0
2005-07-07 14:00:00	IWM	ETF	64.52	64.55	64.26	64.37	2164200.0
2005-07-07 15:00:00	IWM	ETF	64.35	64.6	64.33	64.55	3345900.0
2005-07-07 16:00:00	IWM	ETF	64.49	64.63	64.48	64.63	238300.0
2005-07-07 17:00:00	IWM	ETF	64.63	64.63	64.58	64.62	1002300.0
2005-07-07 07:00:00	DIA	ETF	100.9	101.79	100.9	101.33	56500.0
2005-07-07 08:00:00	DIA	ETF	101.35	101.51	101.26	101.48	63100.0
2005-07-07 09:00:00	DIA	ETF	101.51	102.32	101.51	101.97	2471000.0
2005-07-07 10:00:00	DIA	ETF	101.95	102.24	101.81	101.92	2564100.0
2005-07-07 11:00:00	DIA	ETF	101.9	102.41	101.82	102.39	973000.0
2005-07-07 12:00:00	DIA	ETF	102.38	102.7	102.37	102.45	2484100.0
2005-07-07 13:00:00	DIA	ETF	102.46	102.84	102.44	102.7	1145300.0
2005-07-07 14:00:00	DIA	ETF	102.69	102.71	102.43	102.68	625800.0
2005-07-07 15:00:00	DIA	ETF	102.68	103.12	102.68	103.03	2535000.0
2005-07-07 16:00:00	DIA	ETF	103.01	103.2	102.9	103.2	198700.0
2005-07-07 17:00:00	DIA	ETF	103.04	103.14	103.04	103.14	400.0
2005-07-07 19:00:00	DIA	ETF	103.1	103.2	103.1	103.2	500.0
2005-07-07 07:00:00	GLD	ETF	42.62	42.62	42.61	42.61	3000.0
2005-07-07 08:00:00	GLD	ETF	42.59	42.6	42.38	42.47	16500.0
2005-07-07 09:00:00	GLD	ETF	42.51	42.51	42.35	42.47	801000.0
2005-07-07 10:00:00	GLD	ETF	42.45	42.52	42.38	42.52	714700.0

> showing 50 of 928 rows — these rows as CSV

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