PREVIEW / etf_1hour / 2016-12-21

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-21.parquet
  size:    268 KB
  rows:    8,740

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-21 04:00:00	SPY	ETF	226.22	226.32	226.22	226.32	700.0
2016-12-21 05:00:00	SPY	ETF	226.27	226.33	226.25	226.25	6202.0
2016-12-21 06:00:00	SPY	ETF	226.23	226.24	226.1	226.1	2410.0
2016-12-21 07:00:00	SPY	ETF	226.1	226.2	226.02	226.19	141996.0
2016-12-21 08:00:00	SPY	ETF	226.07	226.27	226.05	226.22	148389.0
2016-12-21 09:00:00	SPY	ETF	226.21	226.45	226.07	226.14	4701974.0
2016-12-21 10:00:00	SPY	ETF	226.1467	226.24	225.99	225.995	10373375.0
2016-12-21 11:00:00	SPY	ETF	226.0	226.19	225.97	226.11	6570966.0
2016-12-21 12:00:00	SPY	ETF	226.12	226.25	226.1	226.16	7764651.0
2016-12-21 13:00:00	SPY	ETF	226.16	226.23	226.05	226.0799	3041442.0
2016-12-21 14:00:00	SPY	ETF	226.07	226.22	226.07	226.1894	7147897.0
2016-12-21 15:00:00	SPY	ETF	226.18	226.21	225.77	225.81	15927108.0
2016-12-21 16:00:00	SPY	ETF	225.82	225.88	225.55	225.58	11058493.0
2016-12-21 17:00:00	SPY	ETF	225.58	225.77	225.57	225.58	60161.0
2016-12-21 18:00:00	SPY	ETF	225.61	225.68	225.59	225.64	48032.0
2016-12-21 19:00:00	SPY	ETF	225.65	225.65	225.54	225.62	44143.0
2016-12-21 04:00:00	QQQ	ETF	120.65	120.65	120.65	120.65	300.0
2016-12-21 05:00:00	QQQ	ETF	120.61	120.61	120.61	120.61	700.0
2016-12-21 06:00:00	QQQ	ETF	120.52	120.54	120.49	120.54	3699.0
2016-12-21 07:00:00	QQQ	ETF	120.52	120.52	120.46	120.46	2250.0
2016-12-21 08:00:00	QQQ	ETF	120.53	120.6	120.53	120.6	14851.0
2016-12-21 09:00:00	QQQ	ETF	120.64	120.68	120.39	120.425	826164.0
2016-12-21 10:00:00	QQQ	ETF	120.425	120.53	120.19	120.21	1182249.0
2016-12-21 11:00:00	QQQ	ETF	120.22	120.43	120.2	120.4163	832855.0
2016-12-21 12:00:00	QQQ	ETF	120.42	120.52	120.4101	120.46	658127.0
2016-12-21 13:00:00	QQQ	ETF	120.46	120.56	120.4135	120.4942	490211.0
2016-12-21 14:00:00	QQQ	ETF	120.4999	120.61	120.49	120.58	473615.0
2016-12-21 15:00:00	QQQ	ETF	120.58	120.59	120.4	120.44	1691100.0
2016-12-21 16:00:00	QQQ	ETF	120.44	120.46	120.32	120.35	160902.0
2016-12-21 17:00:00	QQQ	ETF	120.42	120.42	120.42	120.42	3700.0
2016-12-21 18:00:00	QQQ	ETF	120.39	120.4	120.36	120.4	7300.0
2016-12-21 19:00:00	QQQ	ETF	120.42	120.42	120.35	120.39	3499.0
2016-12-21 07:00:00	IWM	ETF	137.6	137.65	137.55	137.65	31800.0
2016-12-21 08:00:00	IWM	ETF	137.67	137.68	137.6	137.65	26992.0
2016-12-21 09:00:00	IWM	ETF	137.72	138.15	137.47	137.62	2519993.0
2016-12-21 10:00:00	IWM	ETF	137.62	137.86	137.22	137.25	2523555.0
2016-12-21 11:00:00	IWM	ETF	137.25	137.6	137.16	137.32	2002005.0
2016-12-21 12:00:00	IWM	ETF	137.33	137.69	137.32	137.57	1329864.0
2016-12-21 13:00:00	IWM	ETF	137.565	137.71	137.55	137.555	1070534.0
2016-12-21 14:00:00	IWM	ETF	137.55	137.66	137.48	137.6	1266037.0
2016-12-21 15:00:00	IWM	ETF	137.59	137.67	137.01	137.04	3934040.0
2016-12-21 16:00:00	IWM	ETF	137.06	137.5158	136.79	136.87	1844641.0
2016-12-21 17:00:00	IWM	ETF	136.9	137.06	136.85	137.0	743308.0
2016-12-21 18:00:00	IWM	ETF	136.95	136.95	136.95	136.95	100.0
2016-12-21 07:00:00	DIA	ETF	199.4	199.4	199.4	199.4	1000.0
2016-12-21 08:00:00	DIA	ETF	199.24	199.45	199.24	199.42	1453.0
2016-12-21 09:00:00	DIA	ETF	199.47	199.61	199.28	199.34	373579.0
2016-12-21 10:00:00	DIA	ETF	199.33	199.43	199.2601	199.27	488140.0
2016-12-21 11:00:00	DIA	ETF	199.27	199.39	199.235	199.29	208141.0
2016-12-21 12:00:00	DIA	ETF	199.285	199.39	199.28	199.33	155834.0

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

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