PREVIEW / etf_1hour / 2005-07-22

all etf 1-hour files

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

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-22 05:00:00	SPY	ETF	122.8	122.8	122.8	122.8	1000.0
2005-07-22 06:00:00	SPY	ETF	122.6	122.6	122.6	122.6	1000.0
2005-07-22 07:00:00	SPY	ETF	122.63	122.75	122.63	122.75	2600.0
2005-07-22 08:00:00	SPY	ETF	122.75	123.01	122.73	122.95	549600.0
2005-07-22 09:00:00	SPY	ETF	122.95	123.21	122.83	123.09	6926900.0
2005-07-22 10:00:00	SPY	ETF	123.1	123.14	122.63	122.76	9487100.0
2005-07-22 11:00:00	SPY	ETF	122.74	123.02	122.74	122.87	4818800.0
2005-07-22 12:00:00	SPY	ETF	122.88	123.02	122.68	122.73	3695200.0
2005-07-22 13:00:00	SPY	ETF	122.73	122.99	122.69	122.93	2546700.0
2005-07-22 14:00:00	SPY	ETF	122.94	123.45	122.79	123.35	9962500.0
2005-07-22 15:00:00	SPY	ETF	123.36	123.51	123.26	123.43	8944800.0
2005-07-22 16:00:00	SPY	ETF	123.45	123.65	123.41	123.65	3664300.0
2005-07-22 17:00:00	SPY	ETF	123.65	123.65	123.58	123.6	5200.0
2005-07-22 18:00:00	SPY	ETF	123.58	123.6	123.58	123.58	6600.0
2005-07-22 19:00:00	SPY	ETF	123.54	123.56	123.54	123.56	1700.0
2005-07-22 09:00:00	QQQ	ETF	39.46	39.59	39.45	39.52	9856100.0
2005-07-22 10:00:00	QQQ	ETF	39.52	39.55	39.25	39.3	16250700.0
2005-07-22 11:00:00	QQQ	ETF	39.3	39.38	39.3	39.34	7742600.0
2005-07-22 12:00:00	QQQ	ETF	39.34	39.39	39.24	39.27	6450100.0
2005-07-22 13:00:00	QQQ	ETF	39.28	39.39	39.28	39.39	3149100.0
2005-07-22 14:00:00	QQQ	ETF	39.39	39.47	39.22	39.42	11309200.0
2005-07-22 15:00:00	QQQ	ETF	39.43	39.49	39.35	39.42	8331500.0
2005-07-22 07:00:00	IWM	ETF	66.35	66.35	66.35	66.35	2000.0
2005-07-22 08:00:00	IWM	ETF	66.32	66.44	66.32	66.44	12100.0
2005-07-22 09:00:00	IWM	ETF	66.47	66.91	66.39	66.87	3848000.0
2005-07-22 10:00:00	IWM	ETF	66.87	66.94	66.37	66.41	4570200.0
2005-07-22 11:00:00	IWM	ETF	66.41	66.63	66.39	66.54	1524600.0
2005-07-22 12:00:00	IWM	ETF	66.54	66.76	66.31	66.33	1937200.0
2005-07-22 13:00:00	IWM	ETF	66.34	66.67	66.31	66.6	2497900.0
2005-07-22 14:00:00	IWM	ETF	66.61	67.07	66.5	67.05	5061800.0
2005-07-22 15:00:00	IWM	ETF	67.04	67.39	66.97	67.37	7616800.0
2005-07-22 16:00:00	IWM	ETF	67.4	67.43	67.31	67.32	614300.0
2005-07-22 17:00:00	IWM	ETF	67.29	67.29	67.27	67.28	800.0
2005-07-22 09:00:00	DIA	ETF	106.32	106.4	106.2	106.36	623600.0
2005-07-22 10:00:00	DIA	ETF	106.34	106.38	105.88	105.97	1150100.0
2005-07-22 11:00:00	DIA	ETF	106.0	106.2	105.97	106.02	447900.0
2005-07-22 12:00:00	DIA	ETF	106.01	106.16	105.82	105.88	1048700.0
2005-07-22 13:00:00	DIA	ETF	105.89	106.06	105.88	106.01	762700.0
2005-07-22 14:00:00	DIA	ETF	106.02	106.45	105.88	106.37	861600.0
2005-07-22 15:00:00	DIA	ETF	106.39	106.55	106.29	106.48	897400.0
2005-07-22 16:00:00	DIA	ETF	106.46	106.6	106.46	106.59	11700.0
2005-07-22 19:00:00	DIA	ETF	106.5	106.5	106.5	106.5	500.0
2005-07-22 08:00:00	GLD	ETF	42.45	42.45	42.4	42.4	10000.0
2005-07-22 09:00:00	GLD	ETF	42.44	42.45	42.35	42.37	143200.0
2005-07-22 10:00:00	GLD	ETF	42.39	42.45	42.35	42.37	73100.0
2005-07-22 11:00:00	GLD	ETF	42.37	42.48	42.34	42.38	67900.0
2005-07-22 12:00:00	GLD	ETF	42.36	42.4	42.35	42.39	61900.0
2005-07-22 13:00:00	GLD	ETF	42.39	42.42	42.38	42.42	38200.0
2005-07-22 14:00:00	GLD	ETF	42.41	42.43	42.38	42.42	80300.0
2005-07-22 15:00:00	GLD	ETF	42.42	42.47	42.4	42.46	131600.0

> showing 50 of 931 rows — these rows as CSV

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