PREVIEW / etf_1hour / 2014-12-26

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-26.parquet
  size:    222 KB
  rows:    7,214

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-12-26 05:00:00	SPY	ETF	208.15	208.17	208.15	208.17	12400.0
2014-12-26 06:00:00	SPY	ETF	208.15	208.15	208.14	208.14	400.0
2014-12-26 07:00:00	SPY	ETF	208.13	208.21	208.02	208.2	43485.0
2014-12-26 08:00:00	SPY	ETF	208.18	208.3	208.16	208.28	160068.0
2014-12-26 09:00:00	SPY	ETF	208.27	208.73	208.24	208.66	6881475.0
2014-12-26 10:00:00	SPY	ETF	208.65	208.7463	208.48	208.64	7644346.0
2014-12-26 11:00:00	SPY	ETF	208.64	208.7	208.55	208.6	5603692.0
2014-12-26 12:00:00	SPY	ETF	208.605	208.63	208.43	208.61	3978362.0
2014-12-26 13:00:00	SPY	ETF	208.6199	208.77	208.59	208.73	4774121.0
2014-12-26 14:00:00	SPY	ETF	208.7386	208.85	208.69	208.8	5604944.0
2014-12-26 15:00:00	SPY	ETF	208.804	208.84	208.39	208.42	12264469.0
2014-12-26 16:00:00	SPY	ETF	208.41	208.6061	208.32	208.5	9452388.0
2014-12-26 17:00:00	SPY	ETF	208.5	208.5	208.41	208.48	37872.0
2014-12-26 18:00:00	SPY	ETF	208.49	208.54	208.49	208.5	107434.0
2014-12-26 19:00:00	SPY	ETF	208.52	208.58	208.52	208.58	6489.0
2014-12-26 05:00:00	QQQ	ETF	104.55	104.55	104.55	104.55	9100.0
2014-12-26 06:00:00	QQQ	ETF	104.55	104.55	104.55	104.55	800.0
2014-12-26 07:00:00	QQQ	ETF	104.55	104.58	104.53	104.58	6050.0
2014-12-26 08:00:00	QQQ	ETF	104.54	104.61	104.5	104.61	90699.0
2014-12-26 09:00:00	QQQ	ETF	104.61	104.85	104.54	104.76	2134129.0
2014-12-26 10:00:00	QQQ	ETF	104.76	104.87	104.73	104.85	1723254.0
2014-12-26 11:00:00	QQQ	ETF	104.8563	104.94	104.81	104.87	1172353.0
2014-12-26 12:00:00	QQQ	ETF	104.88	105.01	104.8	105.0002	984674.0
2014-12-26 13:00:00	QQQ	ETF	105.0	105.19	105.0	105.17	1579142.0
2014-12-26 14:00:00	QQQ	ETF	105.16	105.245	105.16	105.23	1310301.0
2014-12-26 15:00:00	QQQ	ETF	105.22	105.26	105.0	105.05	2957533.0
2014-12-26 16:00:00	QQQ	ETF	105.04	105.12	104.9286	105.05	898048.0
2014-12-26 17:00:00	QQQ	ETF	105.02	105.04	105.01	105.04	4994.0
2014-12-26 18:00:00	QQQ	ETF	105.05	105.08	105.05	105.08	7800.0
2014-12-26 04:00:00	IWM	ETF	119.81	119.81	119.81	119.81	3500.0
2014-12-26 07:00:00	IWM	ETF	120.03	120.19	120.03	120.14	11037.0
2014-12-26 08:00:00	IWM	ETF	120.14	120.2	119.93	120.11	69516.0
2014-12-26 09:00:00	IWM	ETF	120.08	120.55	120.07	120.447	2763843.0
2014-12-26 10:00:00	IWM	ETF	120.45	120.61	120.39	120.59	2070384.0
2014-12-26 11:00:00	IWM	ETF	120.59	120.68	120.57	120.615	1162135.0
2014-12-26 12:00:00	IWM	ETF	120.615	120.65	120.455	120.55	1888158.0
2014-12-26 13:00:00	IWM	ETF	120.55	120.78	120.47	120.76	1611848.0
2014-12-26 14:00:00	IWM	ETF	120.76	120.81	120.73	120.78	1429896.0
2014-12-26 15:00:00	IWM	ETF	120.77	120.83	120.43	120.53	3160901.0
2014-12-26 16:00:00	IWM	ETF	120.53	120.75	120.51	120.69	614370.0
2014-12-26 17:00:00	IWM	ETF	120.68	120.69	120.67	120.67	1800.0
2014-12-26 19:00:00	IWM	ETF	120.7	120.7	120.7	120.7	2600.0
2014-12-26 06:00:00	DIA	ETF	180.34	180.34	180.34	180.34	100.0
2014-12-26 08:00:00	DIA	ETF	180.38	180.49	180.36	180.49	1640.0
2014-12-26 09:00:00	DIA	ETF	180.49	180.67	180.31	180.6	268187.0
2014-12-26 10:00:00	DIA	ETF	180.62	180.71	180.43	180.56	207360.0
2014-12-26 11:00:00	DIA	ETF	180.56	180.59	180.35	180.42	167666.0
2014-12-26 12:00:00	DIA	ETF	180.42	180.47	180.3699	180.45	151587.0
2014-12-26 13:00:00	DIA	ETF	180.4446	180.58	180.4446	180.54	170305.0
2014-12-26 14:00:00	DIA	ETF	180.55	180.6499	180.48	180.56	142436.0

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

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