PREVIEW / etf_1hour / 2005-07-01

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-07-01.parquet
  size:    29 KB
  rows:    895

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-01 07:00:00	SPY	ETF	119.56	119.59	119.54	119.54	30500.0
2005-07-01 08:00:00	SPY	ETF	119.49	119.5	119.37	119.42	102400.0
2005-07-01 09:00:00	SPY	ETF	119.42	119.53	119.35	119.5	6083300.0
2005-07-01 10:00:00	SPY	ETF	119.45	119.8	119.33	119.55	15535300.0
2005-07-01 11:00:00	SPY	ETF	119.57	119.66	119.27	119.33	6606500.0
2005-07-01 12:00:00	SPY	ETF	119.34	119.45	119.29	119.4	3327300.0
2005-07-01 13:00:00	SPY	ETF	119.41	119.53	119.29	119.4	4153400.0
2005-07-01 14:00:00	SPY	ETF	119.4	119.54	119.3	119.35	3974900.0
2005-07-01 15:00:00	SPY	ETF	119.35	119.54	119.21	119.5	6537600.0
2005-07-01 16:00:00	SPY	ETF	119.51	119.61	119.43	119.6	2355100.0
2005-07-01 17:00:00	SPY	ETF	119.61	119.61	119.43	119.43	14900.0
2005-07-01 18:00:00	SPY	ETF	119.45	119.53	119.45	119.53	8900.0
2005-07-01 09:00:00	QQQ	ETF	36.87	36.94	36.82	36.86	8458600.0
2005-07-01 10:00:00	QQQ	ETF	36.87	37.0	36.84	36.89	11477300.0
2005-07-01 11:00:00	QQQ	ETF	36.89	36.93	36.79	36.8	6218400.0
2005-07-01 12:00:00	QQQ	ETF	36.79	36.86	36.76	36.79	5884800.0
2005-07-01 13:00:00	QQQ	ETF	36.79	36.86	36.74	36.82	4718800.0
2005-07-01 14:00:00	QQQ	ETF	36.82	36.87	36.77	36.77	3515100.0
2005-07-01 15:00:00	QQQ	ETF	36.77	36.79	36.68	36.72	10452000.0
2005-07-01 08:00:00	IWM	ETF	63.79	63.79	63.72	63.72	1000.0
2005-07-01 09:00:00	IWM	ETF	63.8	63.8	63.53	63.65	2555800.0
2005-07-01 10:00:00	IWM	ETF	63.65	63.9	63.63	63.74	3289700.0
2005-07-01 11:00:00	IWM	ETF	63.74	63.79	63.45	63.47	1716100.0
2005-07-01 12:00:00	IWM	ETF	63.48	63.57	63.44	63.51	948100.0
2005-07-01 13:00:00	IWM	ETF	63.52	63.65	63.47	63.64	950000.0
2005-07-01 14:00:00	IWM	ETF	63.62	63.76	63.56	63.72	1168900.0
2005-07-01 15:00:00	IWM	ETF	63.71	63.89	63.6	63.88	3428800.0
2005-07-01 16:00:00	IWM	ETF	63.9	64.02	63.9	63.95	411600.0
2005-07-01 17:00:00	IWM	ETF	63.9	63.95	63.8	63.86	1700.0
2005-07-01 07:00:00	DIA	ETF	103.13	103.13	103.13	103.13	100.0
2005-07-01 08:00:00	DIA	ETF	103.06	103.07	103.01	103.03	73300.0
2005-07-01 09:00:00	DIA	ETF	103.01	103.19	102.98	103.11	1680100.0
2005-07-01 10:00:00	DIA	ETF	103.12	103.45	103.09	103.17	2557300.0
2005-07-01 11:00:00	DIA	ETF	103.17	103.18	102.89	103.0	645300.0
2005-07-01 12:00:00	DIA	ETF	103.02	103.1	102.96	103.05	375400.0
2005-07-01 13:00:00	DIA	ETF	103.02	103.15	102.94	103.05	204900.0
2005-07-01 14:00:00	DIA	ETF	103.05	103.12	102.92	102.98	234700.0
2005-07-01 15:00:00	DIA	ETF	102.98	103.07	102.83	103.03	513800.0
2005-07-01 16:00:00	DIA	ETF	103.06	103.12	103.05	103.12	15800.0
2005-07-01 17:00:00	DIA	ETF	103.05	103.05	103.05	103.05	1000.0
2005-07-01 18:00:00	DIA	ETF	103.08	103.09	103.08	103.09	1500.0
2005-07-01 08:00:00	GLD	ETF	43.5	43.5	43.5	43.5	1000.0
2005-07-01 09:00:00	GLD	ETF	43.4	43.4	43.25	43.25	223600.0
2005-07-01 10:00:00	GLD	ETF	43.25	43.27	42.98	43.0	223800.0
2005-07-01 11:00:00	GLD	ETF	43.01	43.02	42.59	42.64	710600.0
2005-07-01 12:00:00	GLD	ETF	42.64	42.72	42.62	42.68	276500.0
2005-07-01 13:00:00	GLD	ETF	42.66	42.7	42.66	42.68	86000.0
2005-07-01 14:00:00	GLD	ETF	42.68	42.74	42.67	42.72	67000.0
2005-07-01 15:00:00	GLD	ETF	42.71	42.75	42.68	42.71	157500.0
2005-07-01 16:00:00	GLD	ETF	42.74	42.74	42.7	42.7	900.0

> showing 50 of 895 rows — these rows as CSV

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