PREVIEW / etf_1hour / 2016-12-13

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-13.parquet
  size:    280 KB
  rows:    8,981

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-12-13 04:00:00	SPY	ETF	226.62	226.74	226.62	226.74	9620.0
2016-12-13 05:00:00	SPY	ETF	226.75	226.77	226.68	226.77	1203.0
2016-12-13 06:00:00	SPY	ETF	226.77	226.89	226.69	226.77	58446.0
2016-12-13 07:00:00	SPY	ETF	226.7	227.01	226.66	226.97	142326.0
2016-12-13 08:00:00	SPY	ETF	226.95	226.95	226.7	226.9	508594.0
2016-12-13 09:00:00	SPY	ETF	226.91	227.84	226.86	227.55	14551647.0
2016-12-13 10:00:00	SPY	ETF	227.56	227.6	227.02	227.36	18684715.0
2016-12-13 11:00:00	SPY	ETF	227.36	227.7125	227.21	227.655	12930167.0
2016-12-13 12:00:00	SPY	ETF	227.655	227.95	227.64	227.7838	9369846.0
2016-12-13 13:00:00	SPY	ETF	227.783	228.34	227.77	228.05	11348612.0
2016-12-13 14:00:00	SPY	ETF	228.05	228.07	227.62	227.78	11009175.0
2016-12-13 15:00:00	SPY	ETF	227.79	228.06	227.61	227.71	18990690.0
2016-12-13 16:00:00	SPY	ETF	227.69	227.9232	227.64	227.84	10979332.0
2016-12-13 17:00:00	SPY	ETF	227.85	227.88	227.76	227.83	236059.0
2016-12-13 18:00:00	SPY	ETF	227.83	227.83	227.75	227.76	89683.0
2016-12-13 19:00:00	SPY	ETF	227.76	227.77	227.68	227.68	60119.0
2016-12-13 04:00:00	QQQ	ETF	119.12	119.28	119.12	119.23	4659.0
2016-12-13 05:00:00	QQQ	ETF	119.27	119.29	119.23	119.27	18094.0
2016-12-13 06:00:00	QQQ	ETF	119.3	119.3	119.23	119.25	3873.0
2016-12-13 07:00:00	QQQ	ETF	119.21	119.35	119.2	119.33	21525.0
2016-12-13 08:00:00	QQQ	ETF	119.34	119.36	119.21	119.33	130119.0
2016-12-13 09:00:00	QQQ	ETF	119.32	120.6	119.26	120.44	6562721.0
2016-12-13 10:00:00	QQQ	ETF	120.45	120.83	120.21	120.7148	7656066.0
2016-12-13 11:00:00	QQQ	ETF	120.72	121.07	120.61	121.019	6120400.0
2016-12-13 12:00:00	QQQ	ETF	121.015	121.11	120.75	120.755	3600900.0
2016-12-13 13:00:00	QQQ	ETF	120.76	121.11	120.735	120.97	3182841.0
2016-12-13 14:00:00	QQQ	ETF	120.971	121.005	120.62	120.75	4751963.0
2016-12-13 15:00:00	QQQ	ETF	120.75	120.84	120.38	120.47	5194473.0
2016-12-13 16:00:00	QQQ	ETF	120.47	120.61	120.43	120.58	1943251.0
2016-12-13 17:00:00	QQQ	ETF	120.61	120.61	120.57	120.6	11100.0
2016-12-13 18:00:00	QQQ	ETF	120.6	120.6	120.54	120.57	21213.0
2016-12-13 19:00:00	QQQ	ETF	120.59	120.59	120.52	120.52	6081.0
2016-12-13 04:00:00	IWM	ETF	137.42	137.43	137.42	137.43	966.0
2016-12-13 05:00:00	IWM	ETF	137.44	137.44	137.44	137.44	1000.0
2016-12-13 06:00:00	IWM	ETF	137.47	137.5	137.37	137.42	16400.0
2016-12-13 07:00:00	IWM	ETF	137.32	137.62	137.32	137.62	35810.0
2016-12-13 08:00:00	IWM	ETF	137.58	137.59	137.38	137.53	141683.0
2016-12-13 09:00:00	IWM	ETF	137.51	138.05	137.37	137.41	4129098.0
2016-12-13 10:00:00	IWM	ETF	137.41	137.49	136.2417	136.84	7274625.0
2016-12-13 11:00:00	IWM	ETF	136.84	137.05	136.415	136.637	4007724.0
2016-12-13 12:00:00	IWM	ETF	136.65	137.345	136.64	137.28	2684646.0
2016-12-13 13:00:00	IWM	ETF	137.27	137.48	137.03	137.1401	2217798.0
2016-12-13 14:00:00	IWM	ETF	137.15	137.15	136.6	136.835	2021173.0
2016-12-13 15:00:00	IWM	ETF	136.835	136.94	136.66	136.85	3660553.0
2016-12-13 16:00:00	IWM	ETF	136.86	137.02	136.8099	137.02	522628.0
2016-12-13 17:00:00	IWM	ETF	136.92	136.94	136.92	136.94	503.0
2016-12-13 18:00:00	IWM	ETF	136.87	136.87	136.87	136.87	100.0
2016-12-13 19:00:00	IWM	ETF	136.91	136.99	136.88	136.89	2774.0
2016-12-13 04:00:00	DIA	ETF	198.21	198.52	198.21	198.52	1400.0
2016-12-13 05:00:00	DIA	ETF	198.65	198.65	198.54	198.54	1300.0

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

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