PREVIEW / etf_1hour / 2014-10-27

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-27.parquet
  size:    229 KB
  rows:    7,316

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-10-27 05:00:00	SPY	ETF	196.9	196.98	196.0	196.28	41246.0
2014-10-27 06:00:00	SPY	ETF	196.19	196.28	195.93	196.04	351161.0
2014-10-27 07:00:00	SPY	ETF	196.09	196.34	196.03	196.18	398295.0
2014-10-27 08:00:00	SPY	ETF	196.18	197.02	195.62	195.74	1439167.0
2014-10-27 09:00:00	SPY	ETF	195.75	195.84	195.14	195.39	13741425.0
2014-10-27 10:00:00	SPY	ETF	195.395	196.25	195.03	196.01	15292550.0
2014-10-27 11:00:00	SPY	ETF	196.01	196.45	195.48	195.605	10477684.0
2014-10-27 12:00:00	SPY	ETF	195.6	196.01	195.54	195.88	7930993.0
2014-10-27 13:00:00	SPY	ETF	195.88	196.34	195.8	195.93	8458055.0
2014-10-27 14:00:00	SPY	ETF	195.93	196.15	195.71	195.84	5794810.0
2014-10-27 15:00:00	SPY	ETF	195.84	196.28	195.8	196.11	13060536.0
2014-10-27 16:00:00	SPY	ETF	196.11	196.42	196.1	196.33	3631676.0
2014-10-27 17:00:00	SPY	ETF	196.34	196.39	196.3	196.37	61444.0
2014-10-27 18:00:00	SPY	ETF	196.37	196.46	196.3	196.3	140438.0
2014-10-27 19:00:00	SPY	ETF	196.3	196.4	196.26	196.38	54766.0
2014-10-27 04:00:00	QQQ	ETF	98.88	98.92	98.74	98.74	10900.0
2014-10-27 05:00:00	QQQ	ETF	98.64	98.71	98.47	98.6	10000.0
2014-10-27 06:00:00	QQQ	ETF	98.6	98.6	98.44	98.45	15100.0
2014-10-27 07:00:00	QQQ	ETF	98.49	98.63	98.47	98.57	43469.0
2014-10-27 08:00:00	QQQ	ETF	98.52	99.03	98.35	98.42	267129.0
2014-10-27 09:00:00	QQQ	ETF	98.41	98.62	98.14	98.1901	4685252.0
2014-10-27 10:00:00	QQQ	ETF	98.19	98.77	98.02	98.6	5802064.0
2014-10-27 11:00:00	QQQ	ETF	98.6	98.83	98.385	98.449	3127532.0
2014-10-27 12:00:00	QQQ	ETF	98.44	98.68	98.41	98.65	1880454.0
2014-10-27 13:00:00	QQQ	ETF	98.65	98.87	98.53	98.58	3292680.0
2014-10-27 14:00:00	QQQ	ETF	98.59	98.71	98.47	98.55	3307627.0
2014-10-27 15:00:00	QQQ	ETF	98.54	98.81	98.54	98.7	5059691.0
2014-10-27 16:00:00	QQQ	ETF	98.7	98.84	98.6267	98.79	1114152.0
2014-10-27 17:00:00	QQQ	ETF	98.78	98.79	98.71	98.71	8289.0
2014-10-27 18:00:00	QQQ	ETF	98.78	98.85	98.77	98.78	37360.0
2014-10-27 19:00:00	QQQ	ETF	98.76	98.78	98.74	98.78	8099.0
2014-10-27 05:00:00	IWM	ETF	111.0	111.0	111.0	111.0	300.0
2014-10-27 07:00:00	IWM	ETF	111.0	111.0	110.84	110.84	800.0
2014-10-27 08:00:00	IWM	ETF	110.81	110.91	110.38	110.46	596316.0
2014-10-27 09:00:00	IWM	ETF	110.45	110.49	109.58	109.79	6083172.0
2014-10-27 10:00:00	IWM	ETF	109.78	110.5	109.51	110.35	7087222.0
2014-10-27 11:00:00	IWM	ETF	110.34	110.74	110.16	110.2101	2922708.0
2014-10-27 12:00:00	IWM	ETF	110.2	110.79	110.19	110.71	1784606.0
2014-10-27 13:00:00	IWM	ETF	110.72	110.98	110.59	110.73	2460860.0
2014-10-27 14:00:00	IWM	ETF	110.73	110.8999	110.63	110.68	1231995.0
2014-10-27 15:00:00	IWM	ETF	110.68	111.09	110.67	111.01	4273356.0
2014-10-27 16:00:00	IWM	ETF	111.01	111.24	110.97	111.24	914899.0
2014-10-27 17:00:00	IWM	ETF	111.2	111.23	111.19	111.22	5068.0
2014-10-27 18:00:00	IWM	ETF	111.27	111.4	111.22	111.24	15700.0
2014-10-27 19:00:00	IWM	ETF	111.18	111.21	111.11	111.12	4874.0
2014-10-27 07:00:00	DIA	ETF	167.65	167.7	167.55	167.6	500.0
2014-10-27 08:00:00	DIA	ETF	167.61	167.61	167.21	167.35	4650.0
2014-10-27 09:00:00	DIA	ETF	167.15	167.38	166.97	167.17	1027997.0
2014-10-27 10:00:00	DIA	ETF	167.16	167.83	166.98	167.73	1195343.0
2014-10-27 11:00:00	DIA	ETF	167.73	168.06	167.35	167.42	683201.0

> showing 50 of 7,316 rows — these rows as CSV

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