PREVIEW / etf_1hour / 2015-12-21

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-21.parquet
  size:    250 KB
  rows:    8,013

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
2015-12-21 04:00:00	SPY	ETF	201.5	201.75	201.38	201.48	38124.0
2015-12-21 05:00:00	SPY	ETF	201.5	201.83	201.5	201.59	41255.0
2015-12-21 06:00:00	SPY	ETF	201.54	201.66	201.36	201.41	262527.0
2015-12-21 07:00:00	SPY	ETF	201.43	201.47	201.09	201.27	434772.0
2015-12-21 08:00:00	SPY	ETF	201.25	201.45	201.08	201.28	1187876.0
2015-12-21 09:00:00	SPY	ETF	201.3	201.88	201.045	201.17	15455391.0
2015-12-21 10:00:00	SPY	ETF	201.17	201.83	201.065	201.26	14457058.0
2015-12-21 11:00:00	SPY	ETF	201.26	201.38	200.09	200.55	13234586.0
2015-12-21 12:00:00	SPY	ETF	200.55	200.93	200.265	200.83	7000906.0
2015-12-21 13:00:00	SPY	ETF	200.83	201.32	200.825	201.03	6645309.0
2015-12-21 14:00:00	SPY	ETF	201.04	201.16	200.51	200.67	8233978.0
2015-12-21 15:00:00	SPY	ETF	200.66	201.69	200.25	201.65	22914719.0
2015-12-21 16:00:00	SPY	ETF	201.65	202.38	201.45	202.27	7489529.0
2015-12-21 17:00:00	SPY	ETF	202.27	202.29	202.17	202.19	95734.0
2015-12-21 18:00:00	SPY	ETF	202.2	202.24	202.12	202.24	63815.0
2015-12-21 19:00:00	SPY	ETF	202.24	202.44	202.09	202.43	231239.0
2015-12-21 04:00:00	QQQ	ETF	110.75	111.02	110.75	110.91	4954.0
2015-12-21 05:00:00	QQQ	ETF	110.95	111.07	110.95	111.0	3200.0
2015-12-21 06:00:00	QQQ	ETF	110.93	110.93	110.87	110.87	20685.0
2015-12-21 07:00:00	QQQ	ETF	110.85	110.85	110.65	110.69	267710.0
2015-12-21 08:00:00	QQQ	ETF	110.73	110.85	110.67	110.7899	360923.0
2015-12-21 09:00:00	QQQ	ETF	110.78	111.04	110.5	110.54	5455987.0
2015-12-21 10:00:00	QQQ	ETF	110.55	111.0	110.53	110.68	3452397.0
2015-12-21 11:00:00	QQQ	ETF	110.67	110.7369	110.05	110.39	3798116.0
2015-12-21 12:00:00	QQQ	ETF	110.38	110.71	110.35	110.66	1759727.0
2015-12-21 13:00:00	QQQ	ETF	110.66	110.8833	110.65	110.75	1711425.0
2015-12-21 14:00:00	QQQ	ETF	110.755	110.835	110.35	110.43	2063845.0
2015-12-21 15:00:00	QQQ	ETF	110.42	111.07	110.22	111.05	4038792.0
2015-12-21 16:00:00	QQQ	ETF	111.07	111.5	111.02	111.5	775707.0
2015-12-21 17:00:00	QQQ	ETF	111.45	111.45	111.44	111.45	6104.0
2015-12-21 18:00:00	QQQ	ETF	111.45	111.52	111.42	111.52	101547.0
2015-12-21 19:00:00	QQQ	ETF	111.52	111.63	111.41	111.54	131299.0
2015-12-21 04:00:00	IWM	ETF	112.26	112.27	112.26	112.27	500.0
2015-12-21 05:00:00	IWM	ETF	112.34	112.34	112.34	112.34	100.0
2015-12-21 06:00:00	IWM	ETF	112.3	112.3	112.19	112.21	1600.0
2015-12-21 07:00:00	IWM	ETF	112.21	112.22	111.97	111.98	57920.0
2015-12-21 08:00:00	IWM	ETF	112.02	112.14	112.02	112.14	388611.0
2015-12-21 09:00:00	IWM	ETF	112.13	112.4	111.835	111.99	2714037.0
2015-12-21 10:00:00	IWM	ETF	111.99	112.63	111.9778	112.22	4392635.0
2015-12-21 11:00:00	IWM	ETF	112.225	112.265	111.5	111.79	3126818.0
2015-12-21 12:00:00	IWM	ETF	111.7968	111.96	111.59	111.9	2011121.0
2015-12-21 13:00:00	IWM	ETF	111.9	112.16	111.89	111.95	1441801.0
2015-12-21 14:00:00	IWM	ETF	111.95	112.07	111.64	111.71	2558844.0
2015-12-21 15:00:00	IWM	ETF	111.7	112.35	111.57	112.34	4417009.0
2015-12-21 16:00:00	IWM	ETF	112.33	112.59	112.22	112.52	1539119.0
2015-12-21 17:00:00	IWM	ETF	112.51	112.52	112.44	112.5	12648.0
2015-12-21 18:00:00	IWM	ETF	112.5	112.51	112.5	112.51	300.0
2015-12-21 19:00:00	IWM	ETF	112.51	112.6	112.46	112.59	3000.0
2015-12-21 04:00:00	DIA	ETF	171.84	171.84	171.84	171.84	200.0
2015-12-21 07:00:00	DIA	ETF	171.98	172.16	171.84	171.84	1457.0

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

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