PREVIEW / etf_1hour / 2005-07-08

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-07-08.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-08 07:00:00	SPY	ETF	120.25	120.32	120.24	120.28	64500.0
2005-07-08 08:00:00	SPY	ETF	120.27	120.48	120.16	120.22	945200.0
2005-07-08 09:00:00	SPY	ETF	120.24	120.27	119.72	120.0	10272200.0
2005-07-08 10:00:00	SPY	ETF	120.01	120.53	119.93	120.4	12950500.0
2005-07-08 11:00:00	SPY	ETF	120.42	120.66	120.31	120.64	5936200.0
2005-07-08 12:00:00	SPY	ETF	120.64	121.1	120.6	120.98	8221400.0
2005-07-08 13:00:00	SPY	ETF	120.98	120.99	120.78	120.95	5030300.0
2005-07-08 14:00:00	SPY	ETF	120.94	121.14	120.93	121.1	5922300.0
2005-07-08 15:00:00	SPY	ETF	121.1	121.32	120.98	121.21	10490000.0
2005-07-08 16:00:00	SPY	ETF	121.22	121.33	121.2	121.28	1861000.0
2005-07-08 17:00:00	SPY	ETF	121.26	121.34	121.26	121.3	7800.0
2005-07-08 18:00:00	SPY	ETF	121.32	121.33	121.32	121.33	2300.0
2005-07-08 19:00:00	SPY	ETF	121.33	121.33	121.33	121.33	200.0
2005-07-08 09:00:00	QQQ	ETF	37.07	37.14	37.01	37.03	11488300.0
2005-07-08 10:00:00	QQQ	ETF	37.04	37.25	36.99	37.2	13086700.0
2005-07-08 11:00:00	QQQ	ETF	37.2	37.26	37.16	37.25	11437600.0
2005-07-08 12:00:00	QQQ	ETF	37.25	37.56	37.25	37.5	18711700.0
2005-07-08 13:00:00	QQQ	ETF	37.51	37.55	37.47	37.54	4500300.0
2005-07-08 14:00:00	QQQ	ETF	37.54	37.72	37.54	37.69	12227800.0
2005-07-08 15:00:00	QQQ	ETF	37.69	37.81	37.65	37.79	20560800.0
2005-07-08 08:00:00	IWM	ETF	64.75	64.92	64.73	64.76	84500.0
2005-07-08 09:00:00	IWM	ETF	64.76	64.84	64.55	64.65	2920600.0
2005-07-08 10:00:00	IWM	ETF	64.66	64.94	64.56	64.85	4213700.0
2005-07-08 11:00:00	IWM	ETF	64.85	65.05	64.71	65.05	2628000.0
2005-07-08 12:00:00	IWM	ETF	65.06	65.47	65.06	65.41	2918100.0
2005-07-08 13:00:00	IWM	ETF	65.41	65.5	65.34	65.45	1808700.0
2005-07-08 14:00:00	IWM	ETF	65.45	65.79	65.45	65.78	3345900.0
2005-07-08 15:00:00	IWM	ETF	65.79	66.02	65.77	65.86	6031500.0
2005-07-08 16:00:00	IWM	ETF	65.88	66.01	65.86	65.97	735800.0
2005-07-08 08:00:00	DIA	ETF	103.43	103.55	103.41	103.42	29400.0
2005-07-08 09:00:00	DIA	ETF	103.42	103.49	103.06	103.35	1572100.0
2005-07-08 10:00:00	DIA	ETF	103.33	103.8	103.22	103.74	1081400.0
2005-07-08 11:00:00	DIA	ETF	103.74	104.02	103.65	104.01	896000.0
2005-07-08 12:00:00	DIA	ETF	104.03	104.39	104.0	104.27	1323000.0
2005-07-08 13:00:00	DIA	ETF	104.27	104.3	104.17	104.28	931600.0
2005-07-08 14:00:00	DIA	ETF	104.28	104.54	104.28	104.44	1335800.0
2005-07-08 15:00:00	DIA	ETF	104.45	104.63	104.34	104.5	1632800.0
2005-07-08 16:00:00	DIA	ETF	104.49	104.59	104.49	104.56	32700.0
2005-07-08 17:00:00	DIA	ETF	104.54	104.62	104.54	104.56	600.0
2005-07-08 18:00:00	DIA	ETF	104.6	104.6	104.6	104.6	200.0
2005-07-08 19:00:00	DIA	ETF	104.58	104.58	104.58	104.58	100.0
2005-07-08 08:00:00	GLD	ETF	42.22	42.36	42.13	42.36	25200.0
2005-07-08 09:00:00	GLD	ETF	42.31	42.4	42.3	42.32	185100.0
2005-07-08 10:00:00	GLD	ETF	42.32	42.4	42.21	42.22	144900.0
2005-07-08 11:00:00	GLD	ETF	42.22	42.24	42.2	42.23	40000.0
2005-07-08 12:00:00	GLD	ETF	42.23	42.23	42.12	42.16	128400.0
2005-07-08 13:00:00	GLD	ETF	42.16	42.24	42.15	42.23	90500.0
2005-07-08 14:00:00	GLD	ETF	42.24	42.24	42.19	42.21	27900.0
2005-07-08 15:00:00	GLD	ETF	42.22	42.28	42.22	42.25	175000.0
2005-07-08 17:00:00	GLD	ETF	42.05	42.05	42.05	42.05	100.0

> showing 50 of 928 rows — these rows as CSV

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