PREVIEW / etf_1hour / 2016-07-12

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-12.parquet
  size:    264 KB
  rows:    8,513

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-07-12 04:00:00	SPY	ETF	213.74	214.58	213.74	214.48	11453.0
2016-07-12 05:00:00	SPY	ETF	214.43	214.51	214.31	214.35	60006.0
2016-07-12 06:00:00	SPY	ETF	214.36	214.59	214.3	214.42	29167.0
2016-07-12 07:00:00	SPY	ETF	214.47	214.49	214.35	214.46	281636.0
2016-07-12 08:00:00	SPY	ETF	214.44	214.56	213.565	214.5	809885.0
2016-07-12 09:00:00	SPY	ETF	214.49	214.935	214.43	214.605	11033848.0
2016-07-12 10:00:00	SPY	ETF	214.62	214.71	214.25	214.6	13523190.0
2016-07-12 11:00:00	SPY	ETF	214.605	215.13	214.535	215.07	14704738.0
2016-07-12 12:00:00	SPY	ETF	215.07	215.28	215.01	215.09	9106106.0
2016-07-12 13:00:00	SPY	ETF	215.1	215.28	214.95	214.98	8935670.0
2016-07-12 14:00:00	SPY	ETF	214.98	215.3	214.96	215.0507	12883384.0
2016-07-12 15:00:00	SPY	ETF	215.058	215.18	214.84	214.94	17669305.0
2016-07-12 16:00:00	SPY	ETF	214.93	215.02	214.82	214.99	6315995.0
2016-07-12 17:00:00	SPY	ETF	214.98	215.05	214.93	214.97	198131.0
2016-07-12 18:00:00	SPY	ETF	214.95	215.01	214.84	214.91	108752.0
2016-07-12 19:00:00	SPY	ETF	214.91	214.99	214.91	214.95	21922.0
2016-07-12 04:00:00	QQQ	ETF	111.5	111.63	111.5	111.62	4625.0
2016-07-12 05:00:00	QQQ	ETF	111.59	111.61	111.59	111.61	1300.0
2016-07-12 06:00:00	QQQ	ETF	111.58	111.64	111.53	111.64	26115.0
2016-07-12 07:00:00	QQQ	ETF	111.55	111.6	111.53	111.6	105601.0
2016-07-12 08:00:00	QQQ	ETF	111.58	111.65	111.54	111.61	60362.0
2016-07-12 09:00:00	QQQ	ETF	111.64	111.79	111.54	111.59	2744376.0
2016-07-12 10:00:00	QQQ	ETF	111.595	111.66	111.34	111.5	3030962.0
2016-07-12 11:00:00	QQQ	ETF	111.5	111.705	111.445	111.6538	2910154.0
2016-07-12 12:00:00	QQQ	ETF	111.65	111.74	111.5434	111.57	1646828.0
2016-07-12 13:00:00	QQQ	ETF	111.565	111.7	111.38	111.4	1396219.0
2016-07-12 14:00:00	QQQ	ETF	111.4	111.64	111.4	111.465	1972030.0
2016-07-12 15:00:00	QQQ	ETF	111.47	111.62	111.4	111.51	3003453.0
2016-07-12 16:00:00	QQQ	ETF	111.5	111.53	111.42	111.5	1853699.0
2016-07-12 17:00:00	QQQ	ETF	111.51	111.51	111.46	111.5	10146.0
2016-07-12 18:00:00	QQQ	ETF	111.47	111.47	111.43	111.45	10991.0
2016-07-12 19:00:00	QQQ	ETF	111.46	111.5	111.45	111.45	8499.0
2016-07-12 04:00:00	IWM	ETF	118.45	119.02	118.45	119.02	3716.0
2016-07-12 05:00:00	IWM	ETF	119.02	119.05	118.96	119.02	11672.0
2016-07-12 06:00:00	IWM	ETF	118.99	119.14	118.99	119.0	1050.0
2016-07-12 07:00:00	IWM	ETF	118.96	118.98	118.88	118.97	206297.0
2016-07-12 08:00:00	IWM	ETF	118.97	119.0	118.86	118.95	126348.0
2016-07-12 09:00:00	IWM	ETF	118.93	119.5	118.93	119.19	3499871.0
2016-07-12 10:00:00	IWM	ETF	119.19	119.35	118.83	119.2961	4761878.0
2016-07-12 11:00:00	IWM	ETF	119.29	119.83	119.28	119.745	4566551.0
2016-07-12 12:00:00	IWM	ETF	119.74	120.085	119.69	119.93	3816191.0
2016-07-12 13:00:00	IWM	ETF	119.92	120.15	119.88	119.95	3502426.0
2016-07-12 14:00:00	IWM	ETF	119.96	120.42	119.96	120.175	4579413.0
2016-07-12 15:00:00	IWM	ETF	120.175	120.22	119.69	119.71	6323244.0
2016-07-12 16:00:00	IWM	ETF	119.71	119.73	119.3866	119.69	2823386.0
2016-07-12 17:00:00	IWM	ETF	119.69	119.79	119.69	119.7	2779.0
2016-07-12 18:00:00	IWM	ETF	119.7	119.79	119.7	119.79	1162.0
2016-07-12 19:00:00	IWM	ETF	119.75	119.77	119.75	119.77	2100.0
2016-07-12 04:00:00	DIA	ETF	182.84	182.84	182.84	182.84	121.0
2016-07-12 05:00:00	DIA	ETF	183.0	183.0	182.98	182.98	200.0

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

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