PREVIEW / etf_1hour / 2016-09-13

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-13.parquet
  size:    262 KB
  rows:    8,434

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-09-13 04:00:00	SPY	ETF	215.4	215.4	214.83	214.99	131069.0
2016-09-13 05:00:00	SPY	ETF	214.97	215.12	214.94	214.98	40549.0
2016-09-13 06:00:00	SPY	ETF	215.06	215.33	215.06	215.28	197821.0
2016-09-13 07:00:00	SPY	ETF	215.28	215.31	214.86	214.99	425437.0
2016-09-13 08:00:00	SPY	ETF	215.02	215.849	214.69	214.79	1601521.0
2016-09-13 09:00:00	SPY	ETF	214.79	215.1499	214.06	214.08	19298889.0
2016-09-13 10:00:00	SPY	ETF	214.08	214.235	213.44	213.52	27684602.0
2016-09-13 11:00:00	SPY	ETF	213.51	213.6	212.87	213.2348	20436278.0
2016-09-13 12:00:00	SPY	ETF	213.23	213.76	212.64	212.82	20367102.0
2016-09-13 13:00:00	SPY	ETF	212.8325	214.18	212.5	213.21	21457873.0
2016-09-13 14:00:00	SPY	ETF	213.21	213.4993	212.63	212.97	20083425.0
2016-09-13 15:00:00	SPY	ETF	212.97	214.67	212.63	213.23	35391748.0
2016-09-13 16:00:00	SPY	ETF	213.21	213.85	213.07	213.78	11315057.0
2016-09-13 17:00:00	SPY	ETF	213.77	213.8	213.23	213.71	693681.0
2016-09-13 18:00:00	SPY	ETF	213.71	213.75	213.2287	213.68	306934.0
2016-09-13 19:00:00	SPY	ETF	213.68	213.73	213.48	213.49	74826.0
2016-09-13 04:00:00	QQQ	ETF	115.72	115.72	115.53	115.62	94328.0
2016-09-13 05:00:00	QQQ	ETF	115.59	115.63	115.57	115.58	43196.0
2016-09-13 06:00:00	QQQ	ETF	115.69	115.78	115.69	115.78	7747.0
2016-09-13 07:00:00	QQQ	ETF	115.77	115.79	115.59	115.79	69008.0
2016-09-13 08:00:00	QQQ	ETF	115.79	115.83	115.59	115.69	208768.0
2016-09-13 09:00:00	QQQ	ETF	115.7	116.09	115.46	115.47	4401512.0
2016-09-13 10:00:00	QQQ	ETF	115.47	115.63	115.14	115.18	6791480.0
2016-09-13 11:00:00	QQQ	ETF	115.17	115.23	114.9	115.06	4373227.0
2016-09-13 12:00:00	QQQ	ETF	115.05	115.35	114.83	114.93	3931402.0
2016-09-13 13:00:00	QQQ	ETF	114.93	115.54	114.73	115.16	5338342.0
2016-09-13 14:00:00	QQQ	ETF	115.16	115.29	114.84	114.98	3054040.0
2016-09-13 15:00:00	QQQ	ETF	114.99	115.57	114.82	115.28	7043759.0
2016-09-13 16:00:00	QQQ	ETF	115.27	115.62	115.27	115.54	918634.0
2016-09-13 17:00:00	QQQ	ETF	115.54	115.6	115.29	115.55	12600.0
2016-09-13 18:00:00	QQQ	ETF	115.54	115.59	115.45	115.52	8099.0
2016-09-13 19:00:00	QQQ	ETF	115.52	115.52	115.2788	115.39	67377.0
2016-09-13 04:00:00	IWM	ETF	122.12	122.13	121.92	121.92	6303.0
2016-09-13 05:00:00	IWM	ETF	121.99	121.99	121.99	121.99	2400.0
2016-09-13 06:00:00	IWM	ETF	122.05	122.22	122.04	122.2	7694.0
2016-09-13 07:00:00	IWM	ETF	122.19	122.21	121.98	122.05	85157.0
2016-09-13 08:00:00	IWM	ETF	122.05	122.17	121.84	121.91	156180.0
2016-09-13 09:00:00	IWM	ETF	121.99	122.16	121.38	121.39	4365274.0
2016-09-13 10:00:00	IWM	ETF	121.39	121.54	120.93	120.97	5995102.0
2016-09-13 11:00:00	IWM	ETF	120.9752	121.04	120.2	120.43	5710169.0
2016-09-13 12:00:00	IWM	ETF	120.43	120.69	119.93	120.04	4371341.0
2016-09-13 13:00:00	IWM	ETF	120.04	121.11	119.8805	120.47	5586182.0
2016-09-13 14:00:00	IWM	ETF	120.45	120.715	120.11	120.41	3820123.0
2016-09-13 15:00:00	IWM	ETF	120.41	121.15	120.28	120.6	8510436.0
2016-09-13 16:00:00	IWM	ETF	120.59	120.94	120.56	120.88	1680271.0
2016-09-13 17:00:00	IWM	ETF	120.88	120.92	120.57	120.92	51815.0
2016-09-13 18:00:00	IWM	ETF	120.87	120.9	120.75	120.78	52802.0
2016-09-13 19:00:00	IWM	ETF	120.88	120.88	120.6151	120.8	82735.0
2016-09-13 04:00:00	DIA	ETF	182.01	182.01	181.99	181.99	6500.0
2016-09-13 08:00:00	DIA	ETF	182.23	182.23	181.9	181.91	24511.0

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

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