PREVIEW / etf_1hour / 2017-03-16

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-16.parquet
  size:    272 KB
  rows:    8,869

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
2017-03-16 04:00:00	SPY	ETF	239.44	239.75	239.25	239.3	22634.0
2017-03-16 05:00:00	SPY	ETF	239.3	239.45	239.27	239.35	9678.0
2017-03-16 06:00:00	SPY	ETF	239.4	239.44	239.27	239.41	94928.0
2017-03-16 07:00:00	SPY	ETF	239.37	239.42	239.25	239.27	242594.0
2017-03-16 08:00:00	SPY	ETF	239.26	239.41	239.02	239.19	455833.0
2017-03-16 09:00:00	SPY	ETF	239.18	239.26	238.89	239.005	11267783.0
2017-03-16 10:00:00	SPY	ETF	239.0027	239.19	238.525	238.695	12254775.0
2017-03-16 11:00:00	SPY	ETF	238.7	238.72	238.13	238.4796	12516515.0
2017-03-16 12:00:00	SPY	ETF	238.48	238.76	238.31	238.69	5665809.0
2017-03-16 13:00:00	SPY	ETF	238.68	238.72	238.39	238.585	6019682.0
2017-03-16 14:00:00	SPY	ETF	238.585	238.69	238.21	238.26	6484449.0
2017-03-16 15:00:00	SPY	ETF	238.255	238.575	238.1	238.52	15352648.0
2017-03-16 16:00:00	SPY	ETF	238.52	238.8	238.46	238.66	6080717.0
2017-03-16 17:00:00	SPY	ETF	238.69	238.69	238.48	238.69	480580.0
2017-03-16 18:00:00	SPY	ETF	238.68	238.68	238.48	238.66	309095.0
2017-03-16 19:00:00	SPY	ETF	238.64	238.65	238.53	238.6	23263.0
2017-03-16 04:00:00	QQQ	ETF	132.29	132.59	132.29	132.57	848.0
2017-03-16 05:00:00	QQQ	ETF	132.53	132.58	132.53	132.58	15099.0
2017-03-16 06:00:00	QQQ	ETF	132.54	132.57	132.5	132.5	20829.0
2017-03-16 07:00:00	QQQ	ETF	132.52	132.53	132.46	132.47	6589.0
2017-03-16 08:00:00	QQQ	ETF	132.49	132.54	132.3	132.38	104757.0
2017-03-16 09:00:00	QQQ	ETF	132.38	132.44	132.11	132.18	2128555.0
2017-03-16 10:00:00	QQQ	ETF	132.18	132.26	131.94	132.02	1922639.0
2017-03-16 11:00:00	QQQ	ETF	132.02	132.03	131.71	131.935	2133455.0
2017-03-16 12:00:00	QQQ	ETF	131.93	132.09	131.88	132.0253	930665.0
2017-03-16 13:00:00	QQQ	ETF	132.0201	132.0353	131.86	131.93	1438358.0
2017-03-16 14:00:00	QQQ	ETF	131.929	132.03	131.805	131.8301	1133084.0
2017-03-16 15:00:00	QQQ	ETF	131.829	132.04	131.76	132.03	2826979.0
2017-03-16 16:00:00	QQQ	ETF	132.03	132.11	131.78	132.08	460499.0
2017-03-16 17:00:00	QQQ	ETF	132.07	132.12	132.07	132.09	1541.0
2017-03-16 18:00:00	QQQ	ETF	132.09	132.16	132.07	132.07	17554.0
2017-03-16 19:00:00	QQQ	ETF	132.1	132.1	132.02	132.02	17450.0
2017-03-16 04:00:00	IWM	ETF	138.09	138.38	138.09	138.17	8623.0
2017-03-16 05:00:00	IWM	ETF	138.2	138.26	138.2	138.26	3400.0
2017-03-16 06:00:00	IWM	ETF	138.22	138.27	138.22	138.27	1230.0
2017-03-16 07:00:00	IWM	ETF	138.25	138.3	138.15	138.15	43149.0
2017-03-16 08:00:00	IWM	ETF	138.14	138.25	137.87	138.25	132804.0
2017-03-16 09:00:00	IWM	ETF	138.25	138.42	137.87	138.255	2816999.0
2017-03-16 10:00:00	IWM	ETF	138.27	138.51	137.87	138.039	3159944.0
2017-03-16 11:00:00	IWM	ETF	138.04	138.07	137.555	137.89	2430348.0
2017-03-16 12:00:00	IWM	ETF	137.89	138.14	137.81	138.0629	2234931.0
2017-03-16 13:00:00	IWM	ETF	138.06	138.11	137.82	137.97	1788955.0
2017-03-16 14:00:00	IWM	ETF	137.97	138.09	137.76	137.82	1748907.0
2017-03-16 15:00:00	IWM	ETF	137.825	138.03	137.68	137.95	4718329.0
2017-03-16 16:00:00	IWM	ETF	137.91	138.18	137.86	138.11	2533150.0
2017-03-16 17:00:00	IWM	ETF	138.11	138.14	138.03	138.03	19396.0
2017-03-16 18:00:00	IWM	ETF	138.08	138.08	138.08	138.08	900.0
2017-03-16 19:00:00	IWM	ETF	138.04	138.13	138.04	138.07	6872.0
2017-03-16 04:00:00	DIA	ETF	210.01	210.01	210.01	210.01	200.0
2017-03-16 07:00:00	DIA	ETF	210.2	210.2	210.2	210.2	500.0

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

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