PREVIEW / etf_1hour / 2014-03-28

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-28.parquet
  size:    213 KB
  rows:    6,765

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-03-28 04:00:00	SPY	ETF	184.96	185.2	184.91	185.16	11541.0
2014-03-28 05:00:00	SPY	ETF	185.12	185.24	185.12	185.24	15062.0
2014-03-28 06:00:00	SPY	ETF	185.2	185.26	185.04	185.08	39655.0
2014-03-28 07:00:00	SPY	ETF	185.08	185.16	184.89	185.15	277229.0
2014-03-28 08:00:00	SPY	ETF	185.09	185.28	184.9	185.06	726097.0
2014-03-28 09:00:00	SPY	ETF	185.04	186.04	184.97	185.99	15871270.0
2014-03-28 10:00:00	SPY	ETF	185.98	186.42	185.91	186.35	15969051.0
2014-03-28 11:00:00	SPY	ETF	186.36	186.39	185.83	186.12	11259666.0
2014-03-28 12:00:00	SPY	ETF	186.11	186.22	185.93	185.99	6467191.0
2014-03-28 13:00:00	SPY	ETF	185.99	186.02	185.57	185.67	9487964.0
2014-03-28 14:00:00	SPY	ETF	185.665	185.67	185.0	185.37	14289300.0
2014-03-28 15:00:00	SPY	ETF	185.365	185.5	185.09	185.48	16208233.0
2014-03-28 16:00:00	SPY	ETF	185.48	185.6	184.6576	185.52	8158110.0
2014-03-28 17:00:00	SPY	ETF	185.51	185.79	185.49	185.76	889515.0
2014-03-28 18:00:00	SPY	ETF	185.73	185.75	185.6	185.65	92222.0
2014-03-28 19:00:00	SPY	ETF	185.64	185.79	185.64	185.76	22672.0
2014-03-28 04:00:00	QQQ	ETF	87.13	87.15	87.13	87.15	7500.0
2014-03-28 05:00:00	QQQ	ETF	87.29	87.32	87.28	87.32	700.0
2014-03-28 06:00:00	QQQ	ETF	87.32	87.33	87.19	87.19	23400.0
2014-03-28 07:00:00	QQQ	ETF	87.23	87.26	87.12	87.26	54500.0
2014-03-28 08:00:00	QQQ	ETF	87.26	87.33	87.12	87.2	142483.0
2014-03-28 09:00:00	QQQ	ETF	87.2	87.82	87.0399	87.7	7552388.0
2014-03-28 10:00:00	QQQ	ETF	87.7	88.01	87.68	87.94	6948278.0
2014-03-28 11:00:00	QQQ	ETF	87.94	87.94	87.63	87.76	3037044.0
2014-03-28 12:00:00	QQQ	ETF	87.77	87.84	87.56	87.63	2998008.0
2014-03-28 13:00:00	QQQ	ETF	87.63	87.63	87.3299	87.36	3706423.0
2014-03-28 14:00:00	QQQ	ETF	87.36	87.36	86.81	87.01	6050324.0
2014-03-28 15:00:00	QQQ	ETF	87.02	87.13	86.88	87.07	5582436.0
2014-03-28 16:00:00	QQQ	ETF	87.06	87.2954	87.01	87.11	1286975.0
2014-03-28 17:00:00	QQQ	ETF	87.11	87.54	87.11	87.25	31473.0
2014-03-28 18:00:00	QQQ	ETF	87.22	87.38	87.22	87.26	9229.0
2014-03-28 19:00:00	QQQ	ETF	87.29	87.38	87.26	87.38	8300.0
2014-03-28 05:00:00	IWM	ETF	114.7	114.7	114.7	114.7	500.0
2014-03-28 06:00:00	IWM	ETF	114.7	114.7	114.7	114.7	1000.0
2014-03-28 07:00:00	IWM	ETF	114.65	114.74	114.55	114.74	42300.0
2014-03-28 08:00:00	IWM	ETF	114.75	114.81	114.42	114.52	207601.0
2014-03-28 09:00:00	IWM	ETF	114.51	115.18	114.39	115.09	6426796.0
2014-03-28 10:00:00	IWM	ETF	115.1	115.91	115.06	115.84	7688874.0
2014-03-28 11:00:00	IWM	ETF	115.83	116.0	115.16	115.37	4661587.0
2014-03-28 12:00:00	IWM	ETF	115.3799	115.46	115.01	115.08	2857172.0
2014-03-28 13:00:00	IWM	ETF	115.08	115.1	114.59	114.67	4989523.0
2014-03-28 14:00:00	IWM	ETF	114.67	114.71	113.98	114.26	7165589.0
2014-03-28 15:00:00	IWM	ETF	114.26	114.38	114.0	114.3	6827513.0
2014-03-28 16:00:00	IWM	ETF	114.3	115.5607	114.23	114.25	2157878.0
2014-03-28 17:00:00	IWM	ETF	114.27	114.5	114.24	114.49	36328.0
2014-03-28 18:00:00	IWM	ETF	114.48	114.57	114.48	114.5	13324.0
2014-03-28 19:00:00	IWM	ETF	114.46	114.53	114.4	114.53	2705.0
2014-03-28 08:00:00	DIA	ETF	162.52	162.57	162.52	162.57	2801.0
2014-03-28 09:00:00	DIA	ETF	162.49	163.57	162.49	163.55	755529.0
2014-03-28 10:00:00	DIA	ETF	163.56	163.82	163.36	163.73	794007.0

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

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