PREVIEW / etf_1hour / 2014-08-26

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-26.parquet
  size:    219 KB
  rows:    6,985

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-26 04:00:00	SPY	ETF	200.02	200.03	199.94	199.94	3984.0
2014-08-26 05:00:00	SPY	ETF	200.03	200.1	199.83	199.88	17627.0
2014-08-26 06:00:00	SPY	ETF	199.93	200.31	199.93	200.28	60179.0
2014-08-26 07:00:00	SPY	ETF	200.23	200.44	200.23	200.36	117863.0
2014-08-26 08:00:00	SPY	ETF	200.23	200.36	200.15	200.26	407838.0
2014-08-26 09:00:00	SPY	ETF	200.28	200.56	200.25	200.48	6047718.0
2014-08-26 10:00:00	SPY	ETF	200.485	200.76	200.3	200.749	7726400.0
2014-08-26 11:00:00	SPY	ETF	200.75	200.82	200.53	200.57	6356225.0
2014-08-26 12:00:00	SPY	ETF	200.57	200.64	200.41	200.44	5162792.0
2014-08-26 13:00:00	SPY	ETF	200.435	200.56	200.31	200.51	4069403.0
2014-08-26 14:00:00	SPY	ETF	200.505	200.57	200.43	200.535	2969648.0
2014-08-26 15:00:00	SPY	ETF	200.535	200.54	200.28	200.34	8093814.0
2014-08-26 16:00:00	SPY	ETF	200.35	200.45	200.3	200.44	5643403.0
2014-08-26 17:00:00	SPY	ETF	200.44	200.46	200.4	200.46	101798.0
2014-08-26 18:00:00	SPY	ETF	200.48	200.48	200.43	200.44	10735.0
2014-08-26 19:00:00	SPY	ETF	200.46	200.47	200.41	200.43	33012.0
2014-08-26 04:00:00	QQQ	ETF	99.3	99.3	99.3	99.3	234.0
2014-08-26 06:00:00	QQQ	ETF	99.46	99.49	99.44	99.46	39100.0
2014-08-26 07:00:00	QQQ	ETF	99.45	99.54	99.45	99.49	34420.0
2014-08-26 08:00:00	QQQ	ETF	99.51	99.52	99.4	99.47	66102.0
2014-08-26 09:00:00	QQQ	ETF	99.48	99.56	99.3	99.46	3388513.0
2014-08-26 10:00:00	QQQ	ETF	99.45	99.5	99.27	99.4872	3353383.0
2014-08-26 11:00:00	QQQ	ETF	99.49	99.57	99.47	99.49	1868626.0
2014-08-26 12:00:00	QQQ	ETF	99.49	99.5573	99.43	99.44	1480899.0
2014-08-26 13:00:00	QQQ	ETF	99.45	99.52	99.405	99.52	1378982.0
2014-08-26 14:00:00	QQQ	ETF	99.52	99.61	99.51	99.6	1676262.0
2014-08-26 15:00:00	QQQ	ETF	99.594	99.61	99.48	99.51	2947051.0
2014-08-26 16:00:00	QQQ	ETF	99.51	99.5758	99.3924	99.53	1799359.0
2014-08-26 17:00:00	QQQ	ETF	99.54	99.56	99.53	99.54	3572.0
2014-08-26 18:00:00	QQQ	ETF	99.54	99.56	99.54	99.55	6068.0
2014-08-26 19:00:00	QQQ	ETF	99.54	99.56	99.54	99.56	10100.0
2014-08-26 07:00:00	IWM	ETF	115.98	115.98	115.88	115.88	22050.0
2014-08-26 08:00:00	IWM	ETF	115.9	115.9	115.7	115.85	71443.0
2014-08-26 09:00:00	IWM	ETF	115.88	116.21	115.8	116.18	2714223.0
2014-08-26 10:00:00	IWM	ETF	116.17	116.49	115.99	116.47	4119273.0
2014-08-26 11:00:00	IWM	ETF	116.48	116.7	116.46	116.52	3987384.0
2014-08-26 12:00:00	IWM	ETF	116.52	116.66	116.48	116.59	1872676.0
2014-08-26 13:00:00	IWM	ETF	116.59	116.77	116.53	116.755	2359252.0
2014-08-26 14:00:00	IWM	ETF	116.75	116.92	116.75	116.88	2963320.0
2014-08-26 15:00:00	IWM	ETF	116.88	116.91	116.68	116.81	6143949.0
2014-08-26 16:00:00	IWM	ETF	116.8	116.9	116.75	116.9	6358930.0
2014-08-26 17:00:00	IWM	ETF	116.89	116.92	116.86	116.9	9452.0
2014-08-26 18:00:00	IWM	ETF	116.9	116.95	116.9	116.9	4558.0
2014-08-26 19:00:00	IWM	ETF	116.92	116.93	116.92	116.93	320.0
2014-08-26 08:00:00	DIA	ETF	170.8	170.8	170.8	170.8	300.0
2014-08-26 09:00:00	DIA	ETF	170.79	171.04	170.76	171.0299	468101.0
2014-08-26 10:00:00	DIA	ETF	170.99	171.29	170.93	171.2695	426212.0
2014-08-26 11:00:00	DIA	ETF	171.28	171.35	171.12	171.12	226667.0
2014-08-26 12:00:00	DIA	ETF	171.12	171.21	171.04	171.07	784296.0
2014-08-26 13:00:00	DIA	ETF	171.08	171.17	170.98	171.07	237640.0

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

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