PREVIEW / etf_1hour / 2006-07-05

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-07-05.parquet
  size:    49 KB
  rows:    1,555

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
2006-07-05 04:00:00	SPY	ETF	127.62	127.62	127.62	127.62	500.0
2006-07-05 07:00:00	SPY	ETF	127.55	127.57	127.37	127.43	9100.0
2006-07-05 08:00:00	SPY	ETF	127.44	127.8	127.35	127.38	1445600.0
2006-07-05 09:00:00	SPY	ETF	127.38	127.38	126.94	127.05	9109200.0
2006-07-05 10:00:00	SPY	ETF	127.04	127.07	126.55	126.63	17467300.0
2006-07-05 11:00:00	SPY	ETF	126.64	126.881	126.52	126.86	9186400.0
2006-07-05 12:00:00	SPY	ETF	126.86	126.98	126.79	126.89	2595500.0
2006-07-05 13:00:00	SPY	ETF	126.9	127.24	126.87	127.02	7564800.0
2006-07-05 14:00:00	SPY	ETF	127.02	127.45	126.96	127.3	7263000.0
2006-07-05 15:00:00	SPY	ETF	127.3	127.3025	126.82	127.03	8191700.0
2006-07-05 16:00:00	SPY	ETF	127.02	127.14	126.957	127.04	4033500.0
2006-07-05 17:00:00	SPY	ETF	127.05	127.07	127.02	127.02	311600.0
2006-07-05 18:00:00	SPY	ETF	127.05	127.08	127.05	127.08	300.0
2006-07-05 19:00:00	SPY	ETF	127.03	127.03	127.03	127.03	500.0
2006-07-05 09:00:00	QQQ	ETF	38.64	38.68	38.35	38.42	14072200.0
2006-07-05 10:00:00	QQQ	ETF	38.42	38.43	38.16	38.19	20286100.0
2006-07-05 11:00:00	QQQ	ETF	38.18	38.24	38.09	38.22	14079200.0
2006-07-05 12:00:00	QQQ	ETF	38.22	38.23	38.16	38.2	5151700.0
2006-07-05 13:00:00	QQQ	ETF	38.2	38.29	38.16	38.2	7228600.0
2006-07-05 14:00:00	QQQ	ETF	38.19	38.37	38.16	38.34	7582800.0
2006-07-05 15:00:00	QQQ	ETF	38.35	38.35	38.16	38.17	17808600.0
2006-07-05 08:00:00	IWM	ETF	72.29	72.35	72.01	72.02	326900.0
2006-07-05 09:00:00	IWM	ETF	72.01	72.59	71.27	71.38	8510300.0
2006-07-05 10:00:00	IWM	ETF	71.38	71.43	71.05	71.08	6523800.0
2006-07-05 11:00:00	IWM	ETF	71.09	71.42	70.99	71.34	6959500.0
2006-07-05 12:00:00	IWM	ETF	71.33	71.41	71.26	71.39	1181900.0
2006-07-05 13:00:00	IWM	ETF	71.39	71.61	71.35	71.391	3489900.0
2006-07-05 14:00:00	IWM	ETF	71.4	71.75	71.35	71.67	2958400.0
2006-07-05 15:00:00	IWM	ETF	71.68	71.73	71.25	71.4	7421500.0
2006-07-05 16:00:00	IWM	ETF	71.4	71.58	71.39	71.5	534500.0
2006-07-05 17:00:00	IWM	ETF	71.5	71.57	71.42	71.57	102000.0
2006-07-05 18:00:00	IWM	ETF	71.46	71.46	71.46	71.46	300.0
2006-07-05 08:00:00	DIA	ETF	111.83	112.06	111.78	111.83	8100.0
2006-07-05 09:00:00	DIA	ETF	111.78	111.82	111.47	111.54	552900.0
2006-07-05 10:00:00	DIA	ETF	111.52	111.56	111.18	111.24	638100.0
2006-07-05 11:00:00	DIA	ETF	111.25	111.4095	111.18	111.38	344500.0
2006-07-05 12:00:00	DIA	ETF	111.39	111.46	111.33	111.4291	300600.0
2006-07-05 13:00:00	DIA	ETF	111.43	111.64	111.37	111.5	398800.0
2006-07-05 14:00:00	DIA	ETF	111.5	111.85	111.46	111.76	223100.0
2006-07-05 15:00:00	DIA	ETF	111.75	111.77	111.27	111.49	567200.0
2006-07-05 16:00:00	DIA	ETF	111.49	111.53	111.4	111.42	318200.0
2006-07-05 17:00:00	DIA	ETF	111.4	111.47	111.4	111.47	78500.0
2006-07-05 07:00:00	GLD	ETF	62.7	62.7	62.43	62.57	8700.0
2006-07-05 08:00:00	GLD	ETF	62.56	62.7	62.14	62.3	410500.0
2006-07-05 09:00:00	GLD	ETF	62.3	62.63	62.05	62.11	1734300.0
2006-07-05 10:00:00	GLD	ETF	62.13	62.14	61.44	61.7	1623000.0
2006-07-05 11:00:00	GLD	ETF	61.7	62.12	61.64	62.1188	1150500.0
2006-07-05 12:00:00	GLD	ETF	62.1192	62.39	62.0	62.39	845800.0
2006-07-05 13:00:00	GLD	ETF	62.38	62.52	62.31	62.37	672800.0
2006-07-05 14:00:00	GLD	ETF	62.36	62.48	62.33	62.47	450000.0

> showing 50 of 1,555 rows — these rows as CSV

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