PREVIEW / etf_1hour / 2015-08-27

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-08-27.parquet
  size:    261 KB
  rows:    8,359

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-08-27 04:00:00	SPY	ETF	196.32	197.11	196.07	197.11	265445.0
2015-08-27 05:00:00	SPY	ETF	197.18	197.18	196.46	196.63	208337.0
2015-08-27 06:00:00	SPY	ETF	196.79	197.07	196.42	196.42	275112.0
2015-08-27 07:00:00	SPY	ETF	196.45	196.56	196.0	196.04	1201343.0
2015-08-27 08:00:00	SPY	ETF	196.04	197.09	195.79	196.9	3426067.0
2015-08-27 09:00:00	SPY	ETF	196.9	197.64	196.54	196.8	30931474.0
2015-08-27 10:00:00	SPY	ETF	196.82	198.13	196.37	198.07	33693606.0
2015-08-27 11:00:00	SPY	ETF	198.06	198.5	197.58	198.11	25881518.0
2015-08-27 12:00:00	SPY	ETF	198.1099	199.24	198.06	199.19	18933529.0
2015-08-27 13:00:00	SPY	ETF	199.18	199.41	198.57	199.17	18989520.0
2015-08-27 14:00:00	SPY	ETF	199.17	199.18	196.06	196.185	41376120.0
2015-08-27 15:00:00	SPY	ETF	196.18	199.32	195.21	199.28	83056747.0
2015-08-27 16:00:00	SPY	ETF	199.3	199.77	197.035	199.63	13209583.0
2015-08-27 17:00:00	SPY	ETF	199.63	199.72	199.55	199.55	1279409.0
2015-08-27 18:00:00	SPY	ETF	199.57	199.61	197.6831	199.41	265876.0
2015-08-27 19:00:00	SPY	ETF	199.43	199.66	199.31	199.66	121484.0
2015-08-27 04:00:00	QQQ	ETF	104.0	104.49	103.85	104.49	24329.0
2015-08-27 05:00:00	QQQ	ETF	104.63	104.67	104.2	104.32	1970.0
2015-08-27 06:00:00	QQQ	ETF	104.41	104.62	104.24	104.24	31876.0
2015-08-27 07:00:00	QQQ	ETF	104.25	104.32	104.0	104.06	96989.0
2015-08-27 08:00:00	QQQ	ETF	104.04	104.49	103.87	104.37	469617.0
2015-08-27 09:00:00	QQQ	ETF	104.39	105.05	104.19	104.4	7508751.0
2015-08-27 10:00:00	QQQ	ETF	104.39	105.08	104.1001	105.04	7862130.0
2015-08-27 11:00:00	QQQ	ETF	105.045	105.35	104.67	104.96	7459626.0
2015-08-27 12:00:00	QQQ	ETF	104.97	105.67	104.925	105.61	4925368.0
2015-08-27 13:00:00	QQQ	ETF	105.62	105.71	105.045	105.4	3581520.0
2015-08-27 14:00:00	QQQ	ETF	105.4	105.43	103.8	103.8889	9373064.0
2015-08-27 15:00:00	QQQ	ETF	103.885	105.59	103.2799	105.59	17022377.0
2015-08-27 16:00:00	QQQ	ETF	105.6	105.79	105.57	105.69	2586056.0
2015-08-27 17:00:00	QQQ	ETF	105.67	105.75	105.63	105.68	90297.0
2015-08-27 18:00:00	QQQ	ETF	105.64	105.72	105.63	105.63	20514.0
2015-08-27 19:00:00	QQQ	ETF	105.69	105.69	105.6	105.65	50038.0
2015-08-27 04:00:00	IWM	ETF	113.23	113.23	113.23	113.23	105.0
2015-08-27 05:00:00	IWM	ETF	113.41	113.41	113.2	113.29	800.0
2015-08-27 06:00:00	IWM	ETF	113.34	113.34	113.23	113.34	600.0
2015-08-27 07:00:00	IWM	ETF	113.2	113.2	112.88	112.88	77380.0
2015-08-27 08:00:00	IWM	ETF	112.89	113.48	112.68	113.41	508133.0
2015-08-27 09:00:00	IWM	ETF	113.42	113.95	112.49	112.95	7051088.0
2015-08-27 10:00:00	IWM	ETF	112.945	114.08	112.36	114.02	8453314.0
2015-08-27 11:00:00	IWM	ETF	114.02	114.34	113.73	114.28	4029668.0
2015-08-27 12:00:00	IWM	ETF	114.28	114.99	114.24	114.86	3844155.0
2015-08-27 13:00:00	IWM	ETF	114.88	115.12	114.41	114.81	4176591.0
2015-08-27 14:00:00	IWM	ETF	114.8	114.8	113.37	113.5	5347961.0
2015-08-27 15:00:00	IWM	ETF	113.48	114.555	113.0	114.5	8601050.0
2015-08-27 16:00:00	IWM	ETF	114.51	114.93	114.4209	114.87	1129944.0
2015-08-27 17:00:00	IWM	ETF	114.89	114.89	114.83	114.83	10227.0
2015-08-27 19:00:00	IWM	ETF	114.61	114.62	114.61	114.61	4000.0
2015-08-27 04:00:00	DIA	ETF	164.52	164.52	164.52	164.52	150.0
2015-08-27 05:00:00	DIA	ETF	164.85	164.9	164.6	164.65	8000.0
2015-08-27 06:00:00	DIA	ETF	164.65	164.85	164.54	164.56	23200.0

> showing 50 of 8,359 rows — these rows as CSV

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