PREVIEW / etf_1hour / 2007-05-03

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-05-03.parquet
  size:    70 KB
  rows:    2,276

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
2007-05-03 04:00:00	SPY	ETF	149.47	149.47	149.47	149.47	900.0
2007-05-03 06:00:00	SPY	ETF	149.37	149.48	149.37	149.48	48500.0
2007-05-03 07:00:00	SPY	ETF	149.52	149.75	149.49	149.64	207700.0
2007-05-03 08:00:00	SPY	ETF	149.66	150.25	149.56	150.18	6823300.0
2007-05-03 09:00:00	SPY	ETF	150.18	150.2	149.38	149.95	10324438.0
2007-05-03 10:00:00	SPY	ETF	149.96	150.37	149.05	150.34	21888953.0
2007-05-03 11:00:00	SPY	ETF	150.34	150.37	150.09	150.24	10765598.0
2007-05-03 12:00:00	SPY	ETF	150.25	150.31	149.92	150.12	6654845.0
2007-05-03 13:00:00	SPY	ETF	150.13	150.26	149.96	150.16	6490857.0
2007-05-03 14:00:00	SPY	ETF	150.17	150.35	149.647	150.35	8376195.0
2007-05-03 15:00:00	SPY	ETF	150.35	150.4	150.14	150.26	12822358.0
2007-05-03 16:00:00	SPY	ETF	150.26	150.38	150.19	150.23	1287300.0
2007-05-03 17:00:00	SPY	ETF	150.24	150.29	150.22	150.22	773100.0
2007-05-03 18:00:00	SPY	ETF	150.24	150.27	150.22	150.27	1200.0
2007-05-03 19:00:00	SPY	ETF	150.28	150.28	150.24	150.24	20900.0
2007-05-03 04:00:00	QQQ	ETF	46.43	46.43	46.43	46.43	14000.0
2007-05-03 07:00:00	QQQ	ETF	46.46	46.54	46.44	46.48	464616.0
2007-05-03 08:00:00	QQQ	ETF	46.48	46.64	46.43	46.62	2560909.0
2007-05-03 09:00:00	QQQ	ETF	46.61	46.62	46.43	46.53	14776608.0
2007-05-03 10:00:00	QQQ	ETF	46.53	46.71	46.48	46.7	33079812.0
2007-05-03 11:00:00	QQQ	ETF	46.7	46.72	46.57	46.628	10529209.0
2007-05-03 12:00:00	QQQ	ETF	46.63	46.64	46.53	46.6	5951100.0
2007-05-03 13:00:00	QQQ	ETF	46.59	46.62	46.51	46.57	8736845.0
2007-05-03 14:00:00	QQQ	ETF	46.58	46.64	46.55	46.63	4178762.0
2007-05-03 15:00:00	QQQ	ETF	46.6388	46.66	46.53	46.6	12063135.0
2007-05-03 16:00:00	QQQ	ETF	46.6	46.63	46.56	46.57	4393463.0
2007-05-03 17:00:00	QQQ	ETF	46.57	46.6	46.55	46.6	312138.0
2007-05-03 18:00:00	QQQ	ETF	46.57	46.58	46.56	46.58	5810.0
2007-05-03 19:00:00	QQQ	ETF	46.58	46.59	46.58	46.59	5519.0
2007-05-03 08:00:00	IWM	ETF	82.14	82.46	82.09	82.45	1699700.0
2007-05-03 09:00:00	IWM	ETF	82.4	82.41	82.0	82.06	6444800.0
2007-05-03 10:00:00	IWM	ETF	82.06	82.57	81.97	82.52	10512226.0
2007-05-03 11:00:00	IWM	ETF	82.52	82.53	82.27	82.41	6532000.0
2007-05-03 12:00:00	IWM	ETF	82.41	82.46	82.18	82.32	2717225.0
2007-05-03 13:00:00	IWM	ETF	82.33	82.46	82.2	82.35	2428594.0
2007-05-03 14:00:00	IWM	ETF	82.35	82.54	82.32	82.53	2518200.0
2007-05-03 15:00:00	IWM	ETF	82.53	82.55	82.2	82.2	8073150.0
2007-05-03 16:00:00	IWM	ETF	82.21	82.32	82.19	82.25	916400.0
2007-05-03 17:00:00	IWM	ETF	82.22	82.22	82.17	82.17	275400.0
2007-05-03 08:00:00	DIA	ETF	132.1	132.46	132.09	132.45	43100.0
2007-05-03 09:00:00	DIA	ETF	132.43	132.43	132.02	132.16	719855.0
2007-05-03 10:00:00	DIA	ETF	132.16	132.35	131.9	132.34	2448601.0
2007-05-03 11:00:00	DIA	ETF	132.35	132.43	132.19	132.31	732200.0
2007-05-03 12:00:00	DIA	ETF	132.31	132.36	132.0	132.16	583000.0
2007-05-03 13:00:00	DIA	ETF	132.16	132.26	132.01	132.19	528500.0
2007-05-03 14:00:00	DIA	ETF	132.2	132.38	132.13	132.38	489000.0
2007-05-03 15:00:00	DIA	ETF	132.39	132.42	132.23	132.39	2362050.0
2007-05-03 16:00:00	DIA	ETF	132.4	132.43	132.32	132.34	1134800.0
2007-05-03 17:00:00	DIA	ETF	132.34	132.34	132.34	132.34	500.0
2007-05-03 04:00:00	GLD	ETF	66.87	66.87	66.87	66.87	100.0

> showing 50 of 2,276 rows — these rows as CSV

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