PREVIEW / etf_1hour / 2016-02-25

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-25.parquet
  size:    246 KB
  rows:    7,821

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
2016-02-25 04:00:00	SPY	ETF	192.94	193.49	192.81	193.26	53819.0
2016-02-25 05:00:00	SPY	ETF	193.26	193.71	193.0	193.65	66567.0
2016-02-25 06:00:00	SPY	ETF	193.64	194.0	193.42	193.99	106752.0
2016-02-25 07:00:00	SPY	ETF	193.98	194.26	193.77	193.8	499377.0
2016-02-25 08:00:00	SPY	ETF	193.78	194.17	193.52	193.84	1472166.0
2016-02-25 09:00:00	SPY	ETF	193.8	194.26	193.255	193.37	11836073.0
2016-02-25 10:00:00	SPY	ETF	193.375	193.82	192.83	193.265	17979376.0
2016-02-25 11:00:00	SPY	ETF	193.26	193.9	193.02	193.8	9931059.0
2016-02-25 12:00:00	SPY	ETF	193.8	193.94	193.345	193.63	6202870.0
2016-02-25 13:00:00	SPY	ETF	193.63	194.68	193.57	194.635	14583839.0
2016-02-25 14:00:00	SPY	ETF	194.63	194.82	194.32	194.435	11346064.0
2016-02-25 15:00:00	SPY	ETF	194.434	195.54	194.39	195.53	27018414.0
2016-02-25 16:00:00	SPY	ETF	195.53	195.72	192.9162	195.56	5811238.0
2016-02-25 17:00:00	SPY	ETF	195.51	195.62	195.4	195.54	552327.0
2016-02-25 18:00:00	SPY	ETF	195.54	195.69	195.4	195.61	300567.0
2016-02-25 19:00:00	SPY	ETF	195.65	195.81	195.55	195.68	122179.0
2016-02-25 04:00:00	QQQ	ETF	102.48	102.62	102.38	102.43	8415.0
2016-02-25 05:00:00	QQQ	ETF	102.44	102.77	102.39	102.77	2600.0
2016-02-25 06:00:00	QQQ	ETF	102.72	102.91	102.62	102.86	4724.0
2016-02-25 07:00:00	QQQ	ETF	102.94	103.05	102.82	102.83	67022.0
2016-02-25 08:00:00	QQQ	ETF	102.81	102.88	102.55	102.82	332921.0
2016-02-25 09:00:00	QQQ	ETF	102.86	102.99	102.04	102.1	4187901.0
2016-02-25 10:00:00	QQQ	ETF	102.1	102.65	101.84	102.31	5242113.0
2016-02-25 11:00:00	QQQ	ETF	102.3	102.63	102.16	102.585	2251155.0
2016-02-25 12:00:00	QQQ	ETF	102.581	102.61	102.19	102.389	1546245.0
2016-02-25 13:00:00	QQQ	ETF	102.38	103.0	102.35	102.94	2914563.0
2016-02-25 14:00:00	QQQ	ETF	102.9499	103.0	102.62	102.77	2261267.0
2016-02-25 15:00:00	QQQ	ETF	102.76	103.55	102.74	103.54	7785829.0
2016-02-25 16:00:00	QQQ	ETF	103.54	103.72	103.52	103.63	725660.0
2016-02-25 17:00:00	QQQ	ETF	103.64	103.68	103.59	103.61	6357.0
2016-02-25 18:00:00	QQQ	ETF	103.61	103.67	103.57	103.67	17285.0
2016-02-25 19:00:00	QQQ	ETF	103.7	103.78	103.66	103.72	18491.0
2016-02-25 04:00:00	IWM	ETF	101.5	101.61	101.5	101.61	1298.0
2016-02-25 07:00:00	IWM	ETF	101.94	102.05	101.88	101.9	15446.0
2016-02-25 08:00:00	IWM	ETF	101.85	101.97	101.74	101.9	81376.0
2016-02-25 09:00:00	IWM	ETF	101.86	102.33	101.62	101.73	2671876.0
2016-02-25 10:00:00	IWM	ETF	101.73	101.945	101.39	101.53	3779935.0
2016-02-25 11:00:00	IWM	ETF	101.52	101.85	101.42	101.79	2529394.0
2016-02-25 12:00:00	IWM	ETF	101.78	101.82	101.48	101.66	1128509.0
2016-02-25 13:00:00	IWM	ETF	101.65	102.35	101.61	102.32	2584448.0
2016-02-25 14:00:00	IWM	ETF	102.31	102.53	102.18	102.28	2143679.0
2016-02-25 15:00:00	IWM	ETF	102.28	102.6	102.2338	102.53	4060571.0
2016-02-25 16:00:00	IWM	ETF	102.54	102.63	102.332	102.56	873423.0
2016-02-25 17:00:00	IWM	ETF	102.55	102.55	102.52	102.52	2396.0
2016-02-25 18:00:00	IWM	ETF	102.55	102.59	102.55	102.56	908.0
2016-02-25 19:00:00	IWM	ETF	102.56	102.59	102.5	102.58	2900.0
2016-02-25 07:00:00	DIA	ETF	165.37	165.4	165.37	165.4	3288.0
2016-02-25 08:00:00	DIA	ETF	164.73	165.09	164.73	164.88	3100.0
2016-02-25 09:00:00	DIA	ETF	165.1	165.465	164.72	164.78	383000.0
2016-02-25 10:00:00	DIA	ETF	164.77	165.13	164.4	164.7	552805.0

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

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