PREVIEW / etf_1hour / 2006-10-26

all etf 1-hour files

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

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-26 06:00:00	SPY	ETF	138.75	138.75	138.74	138.74	9200.0
2006-10-26 07:00:00	SPY	ETF	138.72	138.72	138.66	138.7	45300.0
2006-10-26 08:00:00	SPY	ETF	138.71	138.79	138.63	138.69	1133900.0
2006-10-26 09:00:00	SPY	ETF	138.69	138.75	138.5	138.57	5583100.0
2006-10-26 10:00:00	SPY	ETF	138.56	138.63	137.98	138.13	13086200.0
2006-10-26 11:00:00	SPY	ETF	138.12	138.29	138.0	138.26	5994600.0
2006-10-26 12:00:00	SPY	ETF	138.27	138.59	138.21	138.53	9203000.0
2006-10-26 13:00:00	SPY	ETF	138.53	138.75	138.45	138.65	6313100.0
2006-10-26 14:00:00	SPY	ETF	138.63	138.97	138.63	138.96	12936200.0
2006-10-26 15:00:00	SPY	ETF	138.95	139.0	138.7	138.86	9160200.0
2006-10-26 16:00:00	SPY	ETF	138.86	138.95	138.7	138.71	2441500.0
2006-10-26 17:00:00	SPY	ETF	138.74	138.84	138.74	138.82	106600.0
2006-10-26 18:00:00	SPY	ETF	138.81	138.81	138.79	138.79	4800.0
2006-10-26 19:00:00	SPY	ETF	138.79	138.79	138.75	138.75	400.0
2006-10-26 09:00:00	QQQ	ETF	42.57	42.58	42.41	42.47	9579200.0
2006-10-26 10:00:00	QQQ	ETF	42.48	42.56	42.22	42.31	22050300.0
2006-10-26 11:00:00	QQQ	ETF	42.32	42.49	42.25	42.47	10452600.0
2006-10-26 12:00:00	QQQ	ETF	42.47	42.63	42.43	42.59	13355800.0
2006-10-26 13:00:00	QQQ	ETF	42.59	42.74	42.55	42.71	11824800.0
2006-10-26 14:00:00	QQQ	ETF	42.73	42.92	42.7	42.88	21105700.0
2006-10-26 15:00:00	QQQ	ETF	42.89	42.91	42.76	42.82	16330300.0
2006-10-26 08:00:00	IWM	ETF	76.6	76.76	76.45	76.72	268700.0
2006-10-26 09:00:00	IWM	ETF	76.72	76.74	76.46	76.55	6558900.0
2006-10-26 10:00:00	IWM	ETF	76.55	76.67	75.87	76.1	9811900.0
2006-10-26 11:00:00	IWM	ETF	76.1	76.2794	75.95	76.26	4787100.0
2006-10-26 12:00:00	IWM	ETF	76.26	76.54	76.2	76.49	5363900.0
2006-10-26 13:00:00	IWM	ETF	76.49	76.59	76.42	76.52	4319300.0
2006-10-26 14:00:00	IWM	ETF	76.52	77.11	76.52	77.1	10841800.0
2006-10-26 15:00:00	IWM	ETF	77.1	77.13	76.86	77.09	6462500.0
2006-10-26 16:00:00	IWM	ETF	77.1	77.15	76.99	77.02	342800.0
2006-10-26 17:00:00	IWM	ETF	77.02	77.06	77.0	77.0	45400.0
2006-10-26 18:00:00	IWM	ETF	77.04	77.04	76.98	76.99	19100.0
2006-10-26 19:00:00	IWM	ETF	77.01	77.05	76.99	77.04	27000.0
2006-10-26 07:00:00	DIA	ETF	121.52	121.64	121.52	121.63	1400.0
2006-10-26 08:00:00	DIA	ETF	121.62	121.68	121.46	121.47	126300.0
2006-10-26 09:00:00	DIA	ETF	121.49	121.56	121.31	121.35	792200.0
2006-10-26 10:00:00	DIA	ETF	121.36	121.42	120.84	121.02	1140900.0
2006-10-26 11:00:00	DIA	ETF	121.0	121.09	120.87	121.07	526600.0
2006-10-26 12:00:00	DIA	ETF	121.07	121.33	121.03	121.28	613600.0
2006-10-26 13:00:00	DIA	ETF	121.28	121.46	121.2	121.36	538200.0
2006-10-26 14:00:00	DIA	ETF	121.35	121.52	121.33	121.47	1018600.0
2006-10-26 15:00:00	DIA	ETF	121.47	121.55	121.3	121.5	1329000.0
2006-10-26 16:00:00	DIA	ETF	121.48	121.48	121.26	121.43	472700.0
2006-10-26 17:00:00	DIA	ETF	121.44	121.44	121.44	121.44	500.0
2006-10-26 07:00:00	GLD	ETF	58.67	58.67	58.66	58.66	900.0
2006-10-26 08:00:00	GLD	ETF	58.7	59.14	58.66	59.07	84300.0
2006-10-26 09:00:00	GLD	ETF	59.11	59.23	58.98	59.22	665600.0
2006-10-26 10:00:00	GLD	ETF	59.22	59.45	59.04	59.1273	1345700.0
2006-10-26 11:00:00	GLD	ETF	59.13	59.24	58.99	59.13	795000.0
2006-10-26 12:00:00	GLD	ETF	59.12	59.4	59.07	59.15	401700.0

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

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