PREVIEW / etf_1hour / 2013-07-03

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-03.parquet
  size:    132 KB
  rows:    3,952

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
2013-07-03 04:00:00	SPY	ETF	160.22	160.32	159.9	160.2	73190.0
2013-07-03 05:00:00	SPY	ETF	160.24	160.45	160.12	160.33	122659.0
2013-07-03 06:00:00	SPY	ETF	160.36	160.46	160.2	160.25	149650.0
2013-07-03 07:00:00	SPY	ETF	160.23	160.46	160.22	160.43	275362.0
2013-07-03 08:00:00	SPY	ETF	160.42	160.99	160.2	160.64	1906295.0
2013-07-03 09:00:00	SPY	ETF	160.66	161.16	160.22	160.6075	14171242.0
2013-07-03 10:00:00	SPY	ETF	160.61	160.93	160.3	160.71	17739910.0
2013-07-03 11:00:00	SPY	ETF	160.71	161.59	160.7084	161.59	14733348.0
2013-07-03 12:00:00	SPY	ETF	161.58	161.77	161.31	161.35	15484956.0
2013-07-03 13:00:00	SPY	ETF	161.34	161.54	161.263	161.5	8876172.0
2013-07-03 14:00:00	SPY	ETF	161.5	161.54	161.48	161.54	57307.0
2013-07-03 15:00:00	SPY	ETF	161.53	161.54	161.47	161.47	30484.0
2013-07-03 16:00:00	SPY	ETF	161.47	161.53	161.47	161.5	23935.0
2013-07-03 04:00:00	QQQ	ETF	71.16	71.29	71.16	71.24	31000.0
2013-07-03 05:00:00	QQQ	ETF	71.23	71.38	71.23	71.33	13400.0
2013-07-03 06:00:00	QQQ	ETF	71.35	71.36	71.26	71.3	10552.0
2013-07-03 07:00:00	QQQ	ETF	71.33	71.38	71.32	71.38	5088.0
2013-07-03 08:00:00	QQQ	ETF	71.35	71.65	71.28	71.6	124775.0
2013-07-03 09:00:00	QQQ	ETF	71.58	71.84	71.42	71.72	3101887.0
2013-07-03 10:00:00	QQQ	ETF	71.72	71.97	71.56	71.89	4420922.0
2013-07-03 11:00:00	QQQ	ETF	71.89	72.23	71.841	72.229	2305945.0
2013-07-03 12:00:00	QQQ	ETF	72.23	72.37	72.03	72.03	3685157.0
2013-07-03 13:00:00	QQQ	ETF	72.03	72.3	71.614	72.15	2949127.0
2013-07-03 14:00:00	QQQ	ETF	72.14	72.14	72.04	72.14	3404.0
2013-07-03 15:00:00	QQQ	ETF	72.1	72.19	72.1	72.15	6271.0
2013-07-03 16:00:00	QQQ	ETF	72.18	72.2	72.13	72.16	10100.0
2013-07-03 06:00:00	IWM	ETF	97.68	97.68	97.56	97.56	5500.0
2013-07-03 07:00:00	IWM	ETF	97.58	97.66	97.5	97.66	31263.0
2013-07-03 08:00:00	IWM	ETF	97.65	98.07	97.55	97.83	331147.0
2013-07-03 09:00:00	IWM	ETF	97.8	98.01	97.59	97.7	3276407.0
2013-07-03 10:00:00	IWM	ETF	97.72	98.07	97.6	97.88	3469137.0
2013-07-03 11:00:00	IWM	ETF	97.88	98.44	97.87	98.4299	2565292.0
2013-07-03 12:00:00	IWM	ETF	98.43	98.64	98.19	98.365	4680358.0
2013-07-03 13:00:00	IWM	ETF	98.36	98.51	98.26	98.49	342080.0
2013-07-03 14:00:00	IWM	ETF	98.45	98.59	98.44	98.46	16750.0
2013-07-03 15:00:00	IWM	ETF	98.47	98.47	98.44	98.44	2200.0
2013-07-03 16:00:00	IWM	ETF	98.4	98.5	98.4	98.45	1874.0
2013-07-03 04:00:00	DIA	ETF	148.03	148.03	148.03	148.03	100.0
2013-07-03 08:00:00	DIA	ETF	148.39	148.72	148.21	148.56	20200.0
2013-07-03 09:00:00	DIA	ETF	148.55	149.06	148.25	148.87	499198.0
2013-07-03 10:00:00	DIA	ETF	148.85	149.17	148.56	148.94	839500.0
2013-07-03 11:00:00	DIA	ETF	148.96	149.8	148.96	149.8	621248.0
2013-07-03 12:00:00	DIA	ETF	149.81	149.98	149.53	149.53	523160.0
2013-07-03 13:00:00	DIA	ETF	149.53	149.57	149.51	149.55	44493.0
2013-07-03 14:00:00	DIA	ETF	149.55	149.87	149.55	149.8	5950.0
2013-07-03 15:00:00	DIA	ETF	149.74	149.74	149.74	149.74	100.0
2013-07-03 04:00:00	GLD	ETF	120.06	120.7	120.06	120.5	20770.0
2013-07-03 05:00:00	GLD	ETF	120.48	120.48	120.48	120.48	2500.0
2013-07-03 06:00:00	GLD	ETF	120.48	120.48	120.48	120.48	2490.0
2013-07-03 07:00:00	GLD	ETF	120.64	121.67	120.51	121.25	35129.0

> showing 50 of 3,952 rows — these rows as CSV

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