PREVIEW / etf_1hour / 2012-10-11

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-10-11.parquet
  size:    183 KB
  rows:    5,716

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
2012-10-11 04:00:00	SPY	ETF	143.3	143.72	143.3	143.62	3262.0
2012-10-11 05:00:00	SPY	ETF	143.6	143.7	143.6	143.7	33999.0
2012-10-11 06:00:00	SPY	ETF	143.7	143.83	143.65	143.8	110983.0
2012-10-11 07:00:00	SPY	ETF	143.78	143.83	143.6	143.6	335348.0
2012-10-11 08:00:00	SPY	ETF	143.61	144.11	143.42	143.95	2610905.0
2012-10-11 09:00:00	SPY	ETF	143.94	144.33	143.28	144.07	17683164.0
2012-10-11 10:00:00	SPY	ETF	144.08	144.49	143.99	144.39	15334783.0
2012-10-11 11:00:00	SPY	ETF	144.39	144.48	143.76	143.9	17878220.0
2012-10-11 12:00:00	SPY	ETF	143.9	144.06	143.79	143.935	8923237.0
2012-10-11 13:00:00	SPY	ETF	143.935	144.04	143.41	143.52	12265567.0
2012-10-11 14:00:00	SPY	ETF	143.52	143.7501	143.44	143.53	13186465.0
2012-10-11 15:00:00	SPY	ETF	143.53	143.76	143.36	143.4	21480612.0
2012-10-11 16:00:00	SPY	ETF	143.39	144.3262	143.29	143.56	10743385.0
2012-10-11 17:00:00	SPY	ETF	143.563	143.65	143.3508	143.63	757220.0
2012-10-11 18:00:00	SPY	ETF	143.63	143.64	143.56	143.56	21526.0
2012-10-11 19:00:00	SPY	ETF	143.59	143.64	143.54	143.64	40110.0
2012-10-11 04:00:00	QQQ	ETF	67.01	67.12	67.01	67.12	933.0
2012-10-11 05:00:00	QQQ	ETF	67.26	67.26	67.26	67.26	700.0
2012-10-11 06:00:00	QQQ	ETF	67.29	67.29	67.29	67.29	5000.0
2012-10-11 07:00:00	QQQ	ETF	67.24	67.29	67.18	67.18	71084.0
2012-10-11 08:00:00	QQQ	ETF	67.19	67.49	67.18	67.34	267918.0
2012-10-11 09:00:00	QQQ	ETF	67.36	67.48	67.25	67.33	3144887.0
2012-10-11 10:00:00	QQQ	ETF	67.33	67.47	67.29	67.34	4063505.0
2012-10-11 11:00:00	QQQ	ETF	67.34	67.36	66.87	66.98	5835138.0
2012-10-11 12:00:00	QQQ	ETF	66.97	67.1083	66.8808	66.96	1970224.0
2012-10-11 13:00:00	QQQ	ETF	66.96	67.03	66.67	66.71	3352405.0
2012-10-11 14:00:00	QQQ	ETF	66.71	66.87	66.71	66.79	3034797.0
2012-10-11 15:00:00	QQQ	ETF	66.785	66.96	66.7	66.7099	5260139.0
2012-10-11 16:00:00	QQQ	ETF	66.7	67.0146	66.67	66.76	1924034.0
2012-10-11 17:00:00	QQQ	ETF	66.74	66.77	66.73	66.73	53791.0
2012-10-11 18:00:00	QQQ	ETF	66.75	66.77	66.75	66.77	5220.0
2012-10-11 19:00:00	QQQ	ETF	66.77	66.79	66.74	66.78	7237.0
2012-10-11 05:00:00	IWM	ETF	82.8	82.85	82.8	82.8	1039.0
2012-10-11 06:00:00	IWM	ETF	82.87	82.92	82.87	82.92	2500.0
2012-10-11 07:00:00	IWM	ETF	82.9	82.9	82.73	82.73	74558.0
2012-10-11 08:00:00	IWM	ETF	82.8	83.93	82.71	83.01	556823.0
2012-10-11 09:00:00	IWM	ETF	82.98	83.22	82.47	83.02	5021496.0
2012-10-11 10:00:00	IWM	ETF	83.02	83.44	83.01	83.32	7317076.0
2012-10-11 11:00:00	IWM	ETF	83.33	83.35	82.8	82.91	5302993.0
2012-10-11 12:00:00	IWM	ETF	82.91	83.08	82.87	82.94	2043836.0
2012-10-11 13:00:00	IWM	ETF	82.93	82.985	82.6	82.665	3569837.0
2012-10-11 14:00:00	IWM	ETF	82.67	82.91	82.66	82.73	3378968.0
2012-10-11 15:00:00	IWM	ETF	82.73	82.96	82.685	82.75	4408844.0
2012-10-11 16:00:00	IWM	ETF	82.75	83.0487	82.72	82.83	1186704.0
2012-10-11 17:00:00	IWM	ETF	82.83	82.87	82.83	82.87	10600.0
2012-10-11 06:00:00	DIA	ETF	133.67	133.67	133.67	133.67	143.0
2012-10-11 07:00:00	DIA	ETF	133.45	133.45	133.45	133.45	200.0
2012-10-11 08:00:00	DIA	ETF	133.5	133.78	133.44	133.68	14238.0
2012-10-11 09:00:00	DIA	ETF	133.68	133.93	133.542	133.56	517483.0
2012-10-11 10:00:00	DIA	ETF	133.56	134.1	133.52	134.0	533223.0

> showing 50 of 5,716 rows — these rows as CSV

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