PREVIEW / etf_1hour / 2005-07-06

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-07-06.parquet
  size:    30 KB
  rows:    913

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-06 07:00:00	SPY	ETF	120.55	120.6	120.54	120.59	61200.0
2005-07-06 08:00:00	SPY	ETF	120.54	120.54	120.43	120.46	125300.0
2005-07-06 09:00:00	SPY	ETF	120.46	120.59	120.35	120.51	4144300.0
2005-07-06 10:00:00	SPY	ETF	120.51	120.65	120.14	120.32	13253000.0
2005-07-06 11:00:00	SPY	ETF	120.32	120.39	120.18	120.33	4345600.0
2005-07-06 12:00:00	SPY	ETF	120.32	120.34	119.86	119.99	5512300.0
2005-07-06 13:00:00	SPY	ETF	119.99	120.28	119.98	120.19	3558000.0
2005-07-06 14:00:00	SPY	ETF	120.19	120.21	119.48	119.59	9483400.0
2005-07-06 15:00:00	SPY	ETF	119.59	119.79	119.45	119.49	10850400.0
2005-07-06 16:00:00	SPY	ETF	119.48	119.949	119.41	119.44	390000.0
2005-07-06 17:00:00	SPY	ETF	119.45	119.49	119.43	119.45	1363600.0
2005-07-06 18:00:00	SPY	ETF	119.47	119.48	119.46	119.47	5600.0
2005-07-06 19:00:00	SPY	ETF	119.45	119.45	119.43	119.43	1700.0
2005-07-06 09:00:00	QQQ	ETF	37.03	37.17	37.0	37.11	9688200.0
2005-07-06 10:00:00	QQQ	ETF	37.11	37.19	37.01	37.11	13063200.0
2005-07-06 11:00:00	QQQ	ETF	37.02	37.18	37.02	37.15	5265700.0
2005-07-06 12:00:00	QQQ	ETF	37.15	37.17	36.99	37.06	5570700.0
2005-07-06 13:00:00	QQQ	ETF	37.06	37.28	37.06	37.22	15078900.0
2005-07-06 14:00:00	QQQ	ETF	37.22	37.23	36.86	36.97	15479800.0
2005-07-06 15:00:00	QQQ	ETF	36.97	37.05	36.88	36.93	11209400.0
2005-07-06 08:00:00	IWM	ETF	64.99	65.03	64.99	64.99	11800.0
2005-07-06 09:00:00	IWM	ETF	65.01	65.06	64.86	65.03	1556500.0
2005-07-06 10:00:00	IWM	ETF	65.03	65.14	64.65	64.77	6050300.0
2005-07-06 11:00:00	IWM	ETF	64.76	64.89	64.65	64.85	3809800.0
2005-07-06 12:00:00	IWM	ETF	64.85	64.86	64.55	64.69	1335000.0
2005-07-06 13:00:00	IWM	ETF	64.69	64.88	64.69	64.85	1657500.0
2005-07-06 14:00:00	IWM	ETF	64.85	64.85	64.44	64.59	2870000.0
2005-07-06 15:00:00	IWM	ETF	64.59	64.66	64.38	64.45	3067800.0
2005-07-06 16:00:00	IWM	ETF	64.46	64.46	64.4	64.44	539200.0
2005-07-06 08:00:00	DIA	ETF	103.63	103.67	103.62	103.67	35800.0
2005-07-06 09:00:00	DIA	ETF	103.67	103.73	103.5	103.7	633700.0
2005-07-06 10:00:00	DIA	ETF	103.7	103.85	103.43	103.53	1117000.0
2005-07-06 11:00:00	DIA	ETF	103.54	103.6	103.41	103.52	1041700.0
2005-07-06 12:00:00	DIA	ETF	103.52	103.52	103.15	103.22	713100.0
2005-07-06 13:00:00	DIA	ETF	103.2	103.42	103.19	103.35	1707900.0
2005-07-06 14:00:00	DIA	ETF	103.32	103.32	102.73	102.83	1371900.0
2005-07-06 15:00:00	DIA	ETF	102.82	102.96	102.66	102.72	2196300.0
2005-07-06 16:00:00	DIA	ETF	102.71	102.83	102.63	102.65	22400.0
2005-07-06 17:00:00	DIA	ETF	102.68	102.68	102.62	102.62	500.0
2005-07-06 18:00:00	DIA	ETF	102.64	102.69	102.64	102.69	400.0
2005-07-06 19:00:00	DIA	ETF	102.7	102.7	102.7	102.7	200.0
2005-07-06 08:00:00	GLD	ETF	42.29	42.29	42.29	42.29	100.0
2005-07-06 09:00:00	GLD	ETF	42.36	42.38	42.27	42.3	227900.0
2005-07-06 10:00:00	GLD	ETF	42.3	42.32	42.26	42.3	212400.0
2005-07-06 11:00:00	GLD	ETF	42.33	42.34	42.28	42.31	382600.0
2005-07-06 12:00:00	GLD	ETF	42.31	42.36	42.29	42.35	145600.0
2005-07-06 13:00:00	GLD	ETF	42.34	42.34	42.24	42.29	125000.0
2005-07-06 14:00:00	GLD	ETF	42.29	42.29	42.26	42.28	32100.0
2005-07-06 15:00:00	GLD	ETF	42.28	42.28	42.24	42.27	125200.0
2005-07-06 08:00:00	TLT	ETF	94.57	94.62	94.57	94.62	11300.0

> showing 50 of 913 rows — these rows as CSV

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