PREVIEW / etf_1hour / 2015-03-13

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-03-13.parquet
  size:    237 KB
  rows:    7,497

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
2015-03-13 04:00:00	SPY	ETF	207.16	207.3	207.16	207.2	4400.0
2015-03-13 05:00:00	SPY	ETF	207.12	207.19	207.12	207.19	400.0
2015-03-13 06:00:00	SPY	ETF	207.01	207.29	206.82	207.29	31297.0
2015-03-13 07:00:00	SPY	ETF	207.19	207.29	206.52	206.52	294149.0
2015-03-13 08:00:00	SPY	ETF	206.51	207.34	206.37	206.64	778461.0
2015-03-13 09:00:00	SPY	ETF	206.63	206.93	206.22	206.48	13280806.0
2015-03-13 10:00:00	SPY	ETF	206.48	206.59	205.12	205.123	21750771.0
2015-03-13 11:00:00	SPY	ETF	205.13	206.1649	204.58	205.07	26755865.0
2015-03-13 12:00:00	SPY	ETF	205.08	205.5	204.73	205.37	15696686.0
2015-03-13 13:00:00	SPY	ETF	205.37	205.4	204.76	205.07	16865037.0
2015-03-13 14:00:00	SPY	ETF	205.06	205.14	204.64	205.07	14170824.0
2015-03-13 15:00:00	SPY	ETF	205.07	206.13	204.93	205.84	32356774.0
2015-03-13 16:00:00	SPY	ETF	205.85	207.1144	205.46	205.74	17840123.0
2015-03-13 17:00:00	SPY	ETF	205.74	205.74	205.54	205.64	241527.0
2015-03-13 18:00:00	SPY	ETF	205.64	205.69	205.55	205.55	18052.0
2015-03-13 19:00:00	SPY	ETF	205.55	205.58	205.53	205.54	8623.0
2015-03-13 05:00:00	QQQ	ETF	105.91	105.93	105.9	105.93	11500.0
2015-03-13 06:00:00	QQQ	ETF	105.73	105.93	105.7	105.93	32660.0
2015-03-13 07:00:00	QQQ	ETF	105.88	105.88	105.6	105.6	54400.0
2015-03-13 08:00:00	QQQ	ETF	105.86	105.86	105.52	105.68	156429.0
2015-03-13 09:00:00	QQQ	ETF	105.61	106.12	105.52	105.87	6405582.0
2015-03-13 10:00:00	QQQ	ETF	105.86	105.9299	104.97	104.97	6841155.0
2015-03-13 11:00:00	QQQ	ETF	104.98	105.212	104.78	105.03	5367660.0
2015-03-13 12:00:00	QQQ	ETF	105.02	105.17	104.73	105.06	4103785.0
2015-03-13 13:00:00	QQQ	ETF	105.05	105.08	104.72	104.87	1817134.0
2015-03-13 14:00:00	QQQ	ETF	104.88	104.95	104.68	104.92	2364958.0
2015-03-13 15:00:00	QQQ	ETF	104.9165	105.4838	104.83	105.34	6925880.0
2015-03-13 16:00:00	QQQ	ETF	105.35	105.652	105.13	105.3	1313251.0
2015-03-13 17:00:00	QQQ	ETF	105.31	105.31	105.28	105.28	229.0
2015-03-13 18:00:00	QQQ	ETF	105.26	105.28	105.26	105.28	847.0
2015-03-13 19:00:00	QQQ	ETF	105.28	105.28	105.24	105.27	1939.0
2015-03-13 06:00:00	IWM	ETF	123.06	123.23	123.06	123.23	500.0
2015-03-13 07:00:00	IWM	ETF	123.14	123.14	122.91	122.91	108100.0
2015-03-13 08:00:00	IWM	ETF	122.88	123.04	122.8	123.04	191473.0
2015-03-13 09:00:00	IWM	ETF	122.89	123.19	122.62	122.86	2956668.0
2015-03-13 10:00:00	IWM	ETF	122.84	122.88	122.13	122.13	3772839.0
2015-03-13 11:00:00	IWM	ETF	122.13	122.4	121.21	121.55	4175058.0
2015-03-13 12:00:00	IWM	ETF	121.53	122.14	121.32	122.0199	2716502.0
2015-03-13 13:00:00	IWM	ETF	122.0	122.33	121.7	122.22	1725250.0
2015-03-13 14:00:00	IWM	ETF	122.23	122.37	122.03	122.32	2002553.0
2015-03-13 15:00:00	IWM	ETF	122.32	122.83	122.23	122.61	5072831.0
2015-03-13 16:00:00	IWM	ETF	122.61	122.69	122.5	122.66	805459.0
2015-03-13 17:00:00	IWM	ETF	122.63	122.63	122.63	122.63	1200.0
2015-03-13 18:00:00	IWM	ETF	122.55	122.55	122.55	122.55	240.0
2015-03-13 19:00:00	IWM	ETF	122.61	122.61	122.6	122.6	355.0
2015-03-13 05:00:00	DIA	ETF	178.83	178.83	178.83	178.83	200.0
2015-03-13 06:00:00	DIA	ETF	178.7	178.7	178.55	178.55	400.0
2015-03-13 07:00:00	DIA	ETF	178.75	178.9	178.36	178.36	4700.0
2015-03-13 08:00:00	DIA	ETF	178.35	178.44	178.2	178.28	4177.0
2015-03-13 09:00:00	DIA	ETF	178.28	178.5	178.0	178.08	891437.0

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

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