PREVIEW / etf_1hour / 2006-07-11

all etf 1-hour files

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

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-11 04:00:00	SPY	ETF	126.63	126.63	126.63	126.63	500.0
2006-07-11 05:00:00	SPY	ETF	126.65	126.65	126.65	126.65	1000.0
2006-07-11 06:00:00	SPY	ETF	126.66	126.66	126.63	126.63	50000.0
2006-07-11 07:00:00	SPY	ETF	126.73	126.86	126.73	126.78	51000.0
2006-07-11 08:00:00	SPY	ETF	126.76	126.86	126.51	126.74	796800.0
2006-07-11 09:00:00	SPY	ETF	126.74	126.74	126.42	126.54	8063400.0
2006-07-11 10:00:00	SPY	ETF	126.52	126.58	125.94	126.04	19549400.0
2006-07-11 11:00:00	SPY	ETF	126.03	126.33	126.03	126.2	7008700.0
2006-07-11 12:00:00	SPY	ETF	126.2	126.42	126.12	126.12	3556500.0
2006-07-11 13:00:00	SPY	ETF	126.12	126.56	126.01	126.46	5523100.0
2006-07-11 14:00:00	SPY	ETF	126.45	126.89	126.39	126.68	10965000.0
2006-07-11 15:00:00	SPY	ETF	126.68	127.41	126.57	127.27	15945400.0
2006-07-11 16:00:00	SPY	ETF	127.27	127.41	127.25	127.4	982400.0
2006-07-11 17:00:00	SPY	ETF	127.4	127.48	127.38	127.48	70400.0
2006-07-11 18:00:00	SPY	ETF	127.47	127.49	127.38	127.4	3800.0
2006-07-11 09:00:00	QQQ	ETF	37.28	37.37	37.19	37.28	14152500.0
2006-07-11 10:00:00	QQQ	ETF	37.28	37.29	37.08	37.16	24901300.0
2006-07-11 11:00:00	QQQ	ETF	37.17	37.28	37.13	37.19	10235500.0
2006-07-11 12:00:00	QQQ	ETF	37.19	37.26	37.11	37.12	6164300.0
2006-07-11 13:00:00	QQQ	ETF	37.12	37.42	37.08	37.36	15438700.0
2006-07-11 14:00:00	QQQ	ETF	37.36	37.58	37.31	37.43	27772100.0
2006-07-11 15:00:00	QQQ	ETF	37.43	37.74	37.38	37.64	28484600.0
2006-07-11 08:00:00	IWM	ETF	70.15	70.34	70.15	70.25	203900.0
2006-07-11 09:00:00	IWM	ETF	70.24	70.24	69.96	70.03	7349600.0
2006-07-11 10:00:00	IWM	ETF	70.04	70.06	69.6	69.67	6796700.0
2006-07-11 11:00:00	IWM	ETF	69.69	69.84	69.65	69.74	8362700.0
2006-07-11 12:00:00	IWM	ETF	69.74	69.92	69.66	69.7	4276000.0
2006-07-11 13:00:00	IWM	ETF	69.69	70.16	69.63	70.1275	7713400.0
2006-07-11 14:00:00	IWM	ETF	70.12	70.55	70.07	70.3	12245700.0
2006-07-11 15:00:00	IWM	ETF	70.31	71.04	70.26	70.99	14001700.0
2006-07-11 16:00:00	IWM	ETF	71.0	71.19	70.92	71.19	971200.0
2006-07-11 17:00:00	IWM	ETF	71.01	71.2	71.01	71.15	910500.0
2006-07-11 18:00:00	IWM	ETF	71.12	71.12	71.12	71.12	500.0
2006-07-11 19:00:00	IWM	ETF	71.15	71.15	71.15	71.15	300.0
2006-07-11 08:00:00	DIA	ETF	111.05	111.05	111.0	111.05	2000.0
2006-07-11 09:00:00	DIA	ETF	111.01	111.01	110.72	110.8014	728900.0
2006-07-11 10:00:00	DIA	ETF	110.81	110.81	110.29	110.342	831100.0
2006-07-11 11:00:00	DIA	ETF	110.36	110.59	110.33	110.49	561100.0
2006-07-11 12:00:00	DIA	ETF	110.49	110.68	110.4	110.5	718400.0
2006-07-11 13:00:00	DIA	ETF	110.49	110.8	110.42	110.76	384900.0
2006-07-11 14:00:00	DIA	ETF	110.77	111.15	110.73	110.96	813900.0
2006-07-11 15:00:00	DIA	ETF	110.95	111.53	110.85	111.37	1000100.0
2006-07-11 16:00:00	DIA	ETF	111.35	111.5	111.34	111.49	93500.0
2006-07-11 17:00:00	DIA	ETF	111.5	111.5	111.46	111.46	1400.0
2006-07-11 19:00:00	DIA	ETF	111.47	111.47	111.47	111.47	400.0
2006-07-11 08:00:00	GLD	ETF	62.87	63.0	62.74	62.93	53700.0
2006-07-11 09:00:00	GLD	ETF	62.91	62.96	62.67	62.8	571500.0
2006-07-11 10:00:00	GLD	ETF	62.7808	63.08	62.7	63.02	1064000.0
2006-07-11 11:00:00	GLD	ETF	63.02	63.25	62.95	63.24	628000.0
2006-07-11 12:00:00	GLD	ETF	63.25	63.6	63.19	63.5	892200.0

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

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