PREVIEW / etf_1hour / 2006-10-17

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-10-17.parquet
  size:    56 KB
  rows:    1,758

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-10-17 06:00:00	SPY	ETF	136.54	136.54	136.52	136.52	3000.0
2006-10-17 07:00:00	SPY	ETF	136.54	136.6	136.49	136.53	41100.0
2006-10-17 08:00:00	SPY	ETF	136.57	136.6	136.26	136.46	5733800.0
2006-10-17 09:00:00	SPY	ETF	136.46	136.51	136.04	136.15	14115900.0
2006-10-17 10:00:00	SPY	ETF	136.16	136.21	135.94	136.07	9433800.0
2006-10-17 11:00:00	SPY	ETF	136.07	136.07	135.67	135.73	13745600.0
2006-10-17 12:00:00	SPY	ETF	135.7	136.1	135.69	136.07	6471600.0
2006-10-17 13:00:00	SPY	ETF	136.06	136.34	136.02	136.29	9213300.0
2006-10-17 14:00:00	SPY	ETF	136.29	136.41	136.06	136.36	9244500.0
2006-10-17 15:00:00	SPY	ETF	136.36	136.7	136.32	136.45	15650500.0
2006-10-17 16:00:00	SPY	ETF	136.45	136.58	136.35	136.43	1393200.0
2006-10-17 17:00:00	SPY	ETF	136.44	136.63	136.15	136.57	338100.0
2006-10-17 18:00:00	SPY	ETF	136.55	136.56	136.48	136.48	344000.0
2006-10-17 19:00:00	SPY	ETF	136.5	136.5	136.49	136.49	800.0
2006-10-17 09:00:00	QQQ	ETF	42.17	42.2	41.89	41.97	28612600.0
2006-10-17 10:00:00	QQQ	ETF	41.97	42.0	41.81	41.9	18762000.0
2006-10-17 11:00:00	QQQ	ETF	41.9	41.91	41.76	41.78	12857200.0
2006-10-17 12:00:00	QQQ	ETF	41.78	42.0	41.77	41.97	14919700.0
2006-10-17 13:00:00	QQQ	ETF	41.98	42.08	41.9	42.06	12298200.0
2006-10-17 14:00:00	QQQ	ETF	42.06	42.07	41.93	42.04	15306000.0
2006-10-17 15:00:00	QQQ	ETF	42.04	42.19	41.99	42.01	26069000.0
2006-10-17 07:00:00	IWM	ETF	76.43	76.43	76.05	76.05	3900.0
2006-10-17 08:00:00	IWM	ETF	76.09	76.35	75.85	75.96	1699000.0
2006-10-17 09:00:00	IWM	ETF	75.99	76.01	72.63	75.67	8173500.0
2006-10-17 10:00:00	IWM	ETF	75.67	75.75	75.44	75.55	7272500.0
2006-10-17 11:00:00	IWM	ETF	75.54	75.55	75.35	75.42	7235100.0
2006-10-17 12:00:00	IWM	ETF	75.43	75.69	75.41	75.66	5529000.0
2006-10-17 13:00:00	IWM	ETF	75.66	75.99	75.66	75.96	4712500.0
2006-10-17 14:00:00	IWM	ETF	75.96	76.15	75.79	76.06	5200900.0
2006-10-17 15:00:00	IWM	ETF	76.06	76.24	75.85	76.03	7733100.0
2006-10-17 16:00:00	IWM	ETF	76.02	76.1	75.78	76.01	274400.0
2006-10-17 17:00:00	IWM	ETF	76.01	76.07	76.0	76.07	9000.0
2006-10-17 18:00:00	IWM	ETF	76.05	76.05	76.04	76.05	1700.0
2006-10-17 19:00:00	IWM	ETF	76.01	76.01	76.01	76.01	800.0
2006-10-17 07:00:00	DIA	ETF	119.57	119.57	119.57	119.57	200.0
2006-10-17 08:00:00	DIA	ETF	119.55	119.63	119.43	119.49	388600.0
2006-10-17 09:00:00	DIA	ETF	119.56	119.62	119.25	119.31	916400.0
2006-10-17 10:00:00	DIA	ETF	119.31	119.34	119.15	119.17	1186600.0
2006-10-17 11:00:00	DIA	ETF	119.18	119.18	118.87	118.89	1339700.0
2006-10-17 12:00:00	DIA	ETF	118.89	119.17	118.88	119.15	1101300.0
2006-10-17 13:00:00	DIA	ETF	119.15	119.39	119.14	119.38	724100.0
2006-10-17 14:00:00	DIA	ETF	119.38	119.5	119.22	119.47	850600.0
2006-10-17 15:00:00	DIA	ETF	119.46	119.75	119.45	119.55	1136300.0
2006-10-17 16:00:00	DIA	ETF	119.55	119.8	119.51	119.73	1692000.0
2006-10-17 19:00:00	DIA	ETF	119.69	119.69	119.69	119.69	500.0
2006-10-17 08:00:00	GLD	ETF	59.18	59.18	58.86	58.87	24000.0
2006-10-17 09:00:00	GLD	ETF	58.88	59.1	58.52	58.52	530300.0
2006-10-17 10:00:00	GLD	ETF	58.55	58.59	58.12	58.3	558700.0
2006-10-17 11:00:00	GLD	ETF	58.29	58.52	58.22	58.34	491300.0
2006-10-17 12:00:00	GLD	ETF	58.35	58.39	58.25	58.34	158600.0

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

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