PREVIEW / etf_1hour / 2014-08-27

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-27.parquet
  size:    211 KB
  rows:    6,768

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
2014-08-27 04:00:00	SPY	ETF	200.4	200.51	200.4	200.49	2001.0
2014-08-27 05:00:00	SPY	ETF	200.53	200.6	200.53	200.6	1043.0
2014-08-27 06:00:00	SPY	ETF	200.54	200.55	200.49	200.49	1659.0
2014-08-27 07:00:00	SPY	ETF	200.52	200.6	200.45	200.45	120924.0
2014-08-27 08:00:00	SPY	ETF	200.47	200.57	200.28	200.34	188641.0
2014-08-27 09:00:00	SPY	ETF	200.34	200.57	200.14	200.19	7431254.0
2014-08-27 10:00:00	SPY	ETF	200.18	200.39	200.08	200.36	7864340.0
2014-08-27 11:00:00	SPY	ETF	200.35	200.5	200.28	200.38	3579404.0
2014-08-27 12:00:00	SPY	ETF	200.385	200.43	200.21	200.36	2534535.0
2014-08-27 13:00:00	SPY	ETF	200.36	200.38	200.3	200.3325	2342614.0
2014-08-27 14:00:00	SPY	ETF	200.34	200.38	200.0	200.0064	5967915.0
2014-08-27 15:00:00	SPY	ETF	200.015	200.34	199.94	200.27	10546151.0
2014-08-27 16:00:00	SPY	ETF	200.28	200.3621	200.25	200.29	4151552.0
2014-08-27 17:00:00	SPY	ETF	200.29	200.3518	200.22	200.23	1613757.0
2014-08-27 18:00:00	SPY	ETF	200.22	200.25	200.22	200.24	28389.0
2014-08-27 19:00:00	SPY	ETF	200.23	200.29	200.23	200.26	14438.0
2014-08-27 04:00:00	QQQ	ETF	99.5	99.5	99.5	99.5	1000.0
2014-08-27 05:00:00	QQQ	ETF	99.6	99.62	99.6	99.62	700.0
2014-08-27 06:00:00	QQQ	ETF	99.58	99.6	99.57	99.57	20350.0
2014-08-27 07:00:00	QQQ	ETF	99.57	99.6	99.55	99.55	16570.0
2014-08-27 08:00:00	QQQ	ETF	99.58	99.58	99.48	99.51	32047.0
2014-08-27 09:00:00	QQQ	ETF	99.52	99.59	99.315	99.34	2523249.0
2014-08-27 10:00:00	QQQ	ETF	99.33	99.55	99.31	99.5499	2100652.0
2014-08-27 11:00:00	QQQ	ETF	99.55	99.63	99.47	99.58	2114700.0
2014-08-27 12:00:00	QQQ	ETF	99.57	99.6	99.51	99.56	984626.0
2014-08-27 13:00:00	QQQ	ETF	99.56	99.61	99.53	99.575	1105724.0
2014-08-27 14:00:00	QQQ	ETF	99.58	99.64	99.43	99.4399	1344378.0
2014-08-27 15:00:00	QQQ	ETF	99.44	99.54	99.36	99.53	2990291.0
2014-08-27 16:00:00	QQQ	ETF	99.52	99.56	99.428	99.52	1530115.0
2014-08-27 17:00:00	QQQ	ETF	99.51	99.51	99.51	99.51	200.0
2014-08-27 18:00:00	QQQ	ETF	99.5	99.51	99.5	99.5	4600.0
2014-08-27 19:00:00	QQQ	ETF	99.5	99.52	99.49	99.52	6600.0
2014-08-27 04:00:00	IWM	ETF	117.0	117.0	117.0	117.0	100.0
2014-08-27 07:00:00	IWM	ETF	117.09	117.09	117.07	117.09	11500.0
2014-08-27 08:00:00	IWM	ETF	117.0	117.05	116.83	116.84	105314.0
2014-08-27 09:00:00	IWM	ETF	116.81	117.01	116.441	116.49	3020763.0
2014-08-27 10:00:00	IWM	ETF	116.49	116.825	116.45	116.81	3448698.0
2014-08-27 11:00:00	IWM	ETF	116.81	116.875	116.51	116.6199	1823361.0
2014-08-27 12:00:00	IWM	ETF	116.6201	116.66	116.51	116.57	1148433.0
2014-08-27 13:00:00	IWM	ETF	116.58	116.59	116.52	116.57	684860.0
2014-08-27 14:00:00	IWM	ETF	116.565	116.655	116.41	116.411	932274.0
2014-08-27 15:00:00	IWM	ETF	116.412	116.565	116.29	116.5	4218325.0
2014-08-27 16:00:00	IWM	ETF	116.5	116.57	116.5	116.52	2469911.0
2014-08-27 17:00:00	IWM	ETF	116.5	116.58	116.5	116.58	6637.0
2014-08-27 18:00:00	IWM	ETF	116.56	116.56	116.51	116.51	1600.0
2014-08-27 19:00:00	IWM	ETF	116.51	116.51	116.46	116.46	3271.0
2014-08-27 04:00:00	DIA	ETF	171.0	171.0	171.0	171.0	450.0
2014-08-27 09:00:00	DIA	ETF	171.13	171.21	170.82	170.87	474036.0
2014-08-27 10:00:00	DIA	ETF	170.85	171.02	170.75	170.99	486418.0
2014-08-27 11:00:00	DIA	ETF	171.0	171.14	170.94	171.04	233130.0

> showing 50 of 6,768 rows — these rows as CSV

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