PREVIEW / etf_1hour / 2012-09-27

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-09-27.parquet
  size:    192 KB
  rows:    5,936

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-09-27 04:00:00	SPY	ETF	143.75	143.87	143.7	143.74	71275.0
2012-09-27 05:00:00	SPY	ETF	143.83	143.9	143.78	143.9	29100.0
2012-09-27 06:00:00	SPY	ETF	143.9	144.01	143.87	143.96	199250.0
2012-09-27 07:00:00	SPY	ETF	143.95	144.06	143.86	143.93	246152.0
2012-09-27 08:00:00	SPY	ETF	143.89	144.2	143.5	143.94	1752576.0
2012-09-27 09:00:00	SPY	ETF	143.94	143.96	143.61	143.7	12792390.0
2012-09-27 10:00:00	SPY	ETF	143.69	143.95	143.51	143.86	17252162.0
2012-09-27 11:00:00	SPY	ETF	143.85	144.22	143.58	144.17	15877233.0
2012-09-27 12:00:00	SPY	ETF	144.169	144.69	144.14	144.52	13945319.0
2012-09-27 13:00:00	SPY	ETF	144.53	144.96	144.48	144.77	8510024.0
2012-09-27 14:00:00	SPY	ETF	144.76	144.97	144.73	144.75	8583599.0
2012-09-27 15:00:00	SPY	ETF	144.76	144.86	144.55	144.69	20436411.0
2012-09-27 16:00:00	SPY	ETF	144.7	144.8023	144.55	144.7	6674784.0
2012-09-27 17:00:00	SPY	ETF	144.68	144.72	143.88	144.67	53317.0
2012-09-27 18:00:00	SPY	ETF	144.69	144.79	144.67	144.78	147323.0
2012-09-27 19:00:00	SPY	ETF	144.76	144.84	144.75	144.8	29928.0
2012-09-27 05:00:00	QQQ	ETF	68.35	68.36	68.35	68.36	3600.0
2012-09-27 06:00:00	QQQ	ETF	68.46	68.46	68.45	68.45	3000.0
2012-09-27 07:00:00	QQQ	ETF	68.45	68.5	68.42	68.42	72221.0
2012-09-27 08:00:00	QQQ	ETF	68.42	68.49	67.3	68.39	992210.0
2012-09-27 09:00:00	QQQ	ETF	68.39	68.4	68.2	68.35	2838294.0
2012-09-27 10:00:00	QQQ	ETF	68.34	68.62	68.25	68.56	3520845.0
2012-09-27 11:00:00	QQQ	ETF	68.56	68.7808	68.43	68.7799	2535818.0
2012-09-27 12:00:00	QQQ	ETF	68.78	69.1	68.7601	68.99	4055185.0
2012-09-27 13:00:00	QQQ	ETF	68.99	69.22	68.955	69.12	2525913.0
2012-09-27 14:00:00	QQQ	ETF	69.13	69.3	69.115	69.16	1761765.0
2012-09-27 15:00:00	QQQ	ETF	69.16	69.27	69.12	69.16	4481528.0
2012-09-27 16:00:00	QQQ	ETF	69.16	69.18	69.07	69.13	775185.0
2012-09-27 17:00:00	QQQ	ETF	69.14	69.15	69.12	69.15	31920.0
2012-09-27 18:00:00	QQQ	ETF	69.15	69.18	69.14	69.18	6200.0
2012-09-27 19:00:00	QQQ	ETF	69.18	69.18	69.15	69.18	9495.0
2012-09-27 04:00:00	IWM	ETF	83.32	83.4	83.28	83.33	1040.0
2012-09-27 05:00:00	IWM	ETF	83.3	83.37	83.3	83.37	300.0
2012-09-27 07:00:00	IWM	ETF	83.4	83.56	83.4	83.45	72597.0
2012-09-27 08:00:00	IWM	ETF	83.44	83.6	83.21	83.5	322250.0
2012-09-27 09:00:00	IWM	ETF	83.48	83.59	83.13	83.27	4432774.0
2012-09-27 10:00:00	IWM	ETF	83.24	83.5	83.07	83.43	4111436.0
2012-09-27 11:00:00	IWM	ETF	83.42	83.84	83.27	83.83	3487985.0
2012-09-27 12:00:00	IWM	ETF	83.83	84.0	83.77	83.94	4144062.0
2012-09-27 13:00:00	IWM	ETF	83.93	84.35	83.9	84.14	3584385.0
2012-09-27 14:00:00	IWM	ETF	84.14	84.285	84.06	84.14	2873066.0
2012-09-27 15:00:00	IWM	ETF	84.15	84.21	83.91	84.06	6626750.0
2012-09-27 16:00:00	IWM	ETF	84.06	84.1958	83.52	84.1	1162232.0
2012-09-27 17:00:00	IWM	ETF	84.13	84.2	84.12	84.2	1900.0
2012-09-27 04:00:00	DIA	ETF	134.26	134.26	134.25	134.25	343.0
2012-09-27 07:00:00	DIA	ETF	134.5	134.5	134.5	134.5	500.0
2012-09-27 08:00:00	DIA	ETF	134.42	134.53	134.35	134.47	3640.0
2012-09-27 09:00:00	DIA	ETF	134.53	134.53	134.0901	134.13	446958.0
2012-09-27 10:00:00	DIA	ETF	134.13	134.24	133.91	134.1095	464871.0
2012-09-27 11:00:00	DIA	ETF	134.09	134.32	133.85	134.29	397815.0

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

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