PREVIEW / etf_1hour / 2006-09-11

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-09-11.parquet
  size:    52 KB
  rows:    1,615

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-09-11 06:00:00	SPY	ETF	129.69	129.76	129.67	129.67	800.0
2006-09-11 07:00:00	SPY	ETF	129.69	129.93	129.65	129.82	339700.0
2006-09-11 08:00:00	SPY	ETF	129.82	130.0	129.52	129.9	1351100.0
2006-09-11 09:00:00	SPY	ETF	129.9	130.0	129.7	129.84	5911700.0
2006-09-11 10:00:00	SPY	ETF	129.84	129.97	129.48	129.61	11942200.0
2006-09-11 11:00:00	SPY	ETF	129.61	129.89	129.52	129.77	7304100.0
2006-09-11 12:00:00	SPY	ETF	129.77	130.36	129.75	130.29	12912000.0
2006-09-11 13:00:00	SPY	ETF	130.29	130.69	130.28	130.47	11000100.0
2006-09-11 14:00:00	SPY	ETF	130.47	130.57	130.29	130.45	5190800.0
2006-09-11 15:00:00	SPY	ETF	130.44	130.46	130.11	130.37	8904100.0
2006-09-11 16:00:00	SPY	ETF	130.38	130.45	130.32	130.39	2102500.0
2006-09-11 17:00:00	SPY	ETF	130.39	130.39	130.34	130.34	115900.0
2006-09-11 18:00:00	SPY	ETF	130.32	130.36	130.31	130.36	3000.0
2006-09-11 19:00:00	SPY	ETF	130.3	130.3	130.3	130.3	2000.0
2006-09-11 09:00:00	QQQ	ETF	38.41	38.55	38.36	38.51	19923200.0
2006-09-11 10:00:00	QQQ	ETF	38.51	38.57	38.32	38.39	28558500.0
2006-09-11 11:00:00	QQQ	ETF	38.4	38.57	38.35	38.5	13387700.0
2006-09-11 12:00:00	QQQ	ETF	38.5	38.87	38.5	38.83	23291900.0
2006-09-11 13:00:00	QQQ	ETF	38.83	39.15	38.82	39.04	19355400.0
2006-09-11 14:00:00	QQQ	ETF	39.03	39.08	38.9	39.03	12760000.0
2006-09-11 15:00:00	QQQ	ETF	39.03	39.04	38.83	38.95	15974800.0
2006-09-11 06:00:00	IWM	ETF	70.11	70.11	70.11	70.11	400.0
2006-09-11 08:00:00	IWM	ETF	70.15	70.36	70.15	70.25	959500.0
2006-09-11 09:00:00	IWM	ETF	70.22	70.34	69.9	70.046	4076000.0
2006-09-11 10:00:00	IWM	ETF	70.05	70.16	69.65	69.87	8168800.0
2006-09-11 11:00:00	IWM	ETF	69.87	70.26	69.78	70.06	6587600.0
2006-09-11 12:00:00	IWM	ETF	70.06	70.62	70.05	70.5	9113100.0
2006-09-11 13:00:00	IWM	ETF	70.5	70.84	70.5	70.63	6646500.0
2006-09-11 14:00:00	IWM	ETF	70.63	70.74	70.47	70.65	3393900.0
2006-09-11 15:00:00	IWM	ETF	70.65	70.65	70.24	70.48	5286800.0
2006-09-11 16:00:00	IWM	ETF	70.52	70.56	70.43	70.47	119600.0
2006-09-11 17:00:00	IWM	ETF	70.47	70.47	70.42	70.42	9000.0
2006-09-11 19:00:00	IWM	ETF	70.45	70.45	70.45	70.45	400.0
2006-09-11 07:00:00	DIA	ETF	113.55	113.55	113.55	113.55	400.0
2006-09-11 08:00:00	DIA	ETF	113.59	113.75	113.58	113.7	34900.0
2006-09-11 09:00:00	DIA	ETF	113.64	113.78	113.59	113.74	568700.0
2006-09-11 10:00:00	DIA	ETF	113.75	113.83	113.44	113.48	1098100.0
2006-09-11 11:00:00	DIA	ETF	113.49	113.7	113.42	113.6	543200.0
2006-09-11 12:00:00	DIA	ETF	113.63	114.02	113.6	113.896	781400.0
2006-09-11 13:00:00	DIA	ETF	113.89	114.25	113.89	114.1	1060600.0
2006-09-11 14:00:00	DIA	ETF	114.1	114.18	113.95	114.1	435100.0
2006-09-11 15:00:00	DIA	ETF	114.1	114.11	113.81	113.97	1143900.0
2006-09-11 16:00:00	DIA	ETF	113.98	114.02	113.96	113.97	8500.0
2006-09-11 19:00:00	DIA	ETF	114.0	114.0	114.0	114.0	100.0
2006-09-11 04:00:00	GLD	ETF	60.31	60.31	60.31	60.31	400.0
2006-09-11 06:00:00	GLD	ETF	59.04	59.04	59.0	59.0	2800.0
2006-09-11 07:00:00	GLD	ETF	59.0	59.17	58.74	59.17	315400.0
2006-09-11 08:00:00	GLD	ETF	59.25	60.03	58.78	59.0	243400.0
2006-09-11 09:00:00	GLD	ETF	59.0	59.15	58.15	58.24	3631000.0
2006-09-11 10:00:00	GLD	ETF	58.24	58.48	58.05	58.17	1507400.0

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

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