PREVIEW / etf_1hour / 2016-03-21

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-21.parquet
  size:    248 KB
  rows:    7,994

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-03-21 04:00:00	SPY	ETF	203.84	204.2	203.56	204.05	9560.0
2016-03-21 05:00:00	SPY	ETF	204.0	204.9	204.0	204.57	45483.0
2016-03-21 06:00:00	SPY	ETF	204.66	204.72	204.44	204.5	37909.0
2016-03-21 07:00:00	SPY	ETF	204.39	204.53	204.26	204.45	44735.0
2016-03-21 08:00:00	SPY	ETF	204.46	204.48	203.87	204.07	533534.0
2016-03-21 09:00:00	SPY	ETF	204.09	204.66	204.0	204.52	7326834.0
2016-03-21 10:00:00	SPY	ETF	204.52	204.65	203.8	203.93	11658136.0
2016-03-21 11:00:00	SPY	ETF	203.925	204.63	203.92	204.39	6804958.0
2016-03-21 12:00:00	SPY	ETF	204.38	204.49	204.16	204.37	6220811.0
2016-03-21 13:00:00	SPY	ETF	204.38	204.8	204.31	204.685	6309519.0
2016-03-21 14:00:00	SPY	ETF	204.6825	204.94	204.56	204.865	9833837.0
2016-03-21 15:00:00	SPY	ETF	204.865	204.88	204.47	204.68	17242232.0
2016-03-21 16:00:00	SPY	ETF	204.67	204.88	204.6	204.83	4002518.0
2016-03-21 17:00:00	SPY	ETF	204.8	204.85	204.67	204.83	1053764.0
2016-03-21 18:00:00	SPY	ETF	204.81	204.87	204.73	204.75	98514.0
2016-03-21 19:00:00	SPY	ETF	204.74	204.74	204.55	204.74	103624.0
2016-03-21 04:00:00	QQQ	ETF	106.9	107.2	106.9	107.2	220.0
2016-03-21 05:00:00	QQQ	ETF	107.66	107.66	107.58	107.58	1500.0
2016-03-21 06:00:00	QQQ	ETF	107.5	107.52	107.41	107.41	1399.0
2016-03-21 07:00:00	QQQ	ETF	107.3	107.38	107.3	107.38	12297.0
2016-03-21 08:00:00	QQQ	ETF	107.36	107.39	107.08	107.17	64046.0
2016-03-21 09:00:00	QQQ	ETF	107.17	107.68	107.15	107.58	2247733.0
2016-03-21 10:00:00	QQQ	ETF	107.58	107.67	107.12	107.2199	3015361.0
2016-03-21 11:00:00	QQQ	ETF	107.22	107.64	107.2	107.5539	1987040.0
2016-03-21 12:00:00	QQQ	ETF	107.56	107.5656	107.37	107.51	1289698.0
2016-03-21 13:00:00	QQQ	ETF	107.51	107.79	107.45	107.641	1420789.0
2016-03-21 14:00:00	QQQ	ETF	107.67	107.89	107.55	107.83	1527918.0
2016-03-21 15:00:00	QQQ	ETF	107.83	107.8364	107.53	107.78	2291563.0
2016-03-21 16:00:00	QQQ	ETF	107.8	107.81	107.71	107.8	2287656.0
2016-03-21 17:00:00	QQQ	ETF	107.8	107.8	107.75	107.75	850.0
2016-03-21 18:00:00	QQQ	ETF	107.77	107.79	107.74	107.74	11631.0
2016-03-21 19:00:00	QQQ	ETF	107.74	107.74	107.69	107.74	6613.0
2016-03-21 04:00:00	IWM	ETF	109.63	109.63	109.63	109.63	1000.0
2016-03-21 05:00:00	IWM	ETF	109.64	109.98	109.64	109.98	1002.0
2016-03-21 06:00:00	IWM	ETF	109.73	109.73	109.73	109.73	2500.0
2016-03-21 07:00:00	IWM	ETF	109.61	109.71	109.61	109.71	740.0
2016-03-21 08:00:00	IWM	ETF	109.69	109.72	109.42	109.43	52757.0
2016-03-21 09:00:00	IWM	ETF	109.46	109.94	109.36	109.77	2507781.0
2016-03-21 10:00:00	IWM	ETF	109.77	109.855	109.11	109.14	3729899.0
2016-03-21 11:00:00	IWM	ETF	109.135	109.735	109.12	109.44	2489396.0
2016-03-21 12:00:00	IWM	ETF	109.44	109.45	109.08	109.255	1922604.0
2016-03-21 13:00:00	IWM	ETF	109.2441	109.58	109.2441	109.43	2095989.0
2016-03-21 14:00:00	IWM	ETF	109.43	109.77	109.345	109.555	2923888.0
2016-03-21 15:00:00	IWM	ETF	109.55	109.55	109.3	109.34	5542796.0
2016-03-21 16:00:00	IWM	ETF	109.35	109.8033	109.28	109.45	4315820.0
2016-03-21 17:00:00	IWM	ETF	109.45	109.45	109.43	109.43	2664.0
2016-03-21 19:00:00	IWM	ETF	109.43	109.44	109.4	109.42	10800.0
2016-03-21 04:00:00	DIA	ETF	175.55	175.55	175.41	175.45	13000.0
2016-03-21 05:00:00	DIA	ETF	175.81	176.19	175.81	176.13	83000.0
2016-03-21 06:00:00	DIA	ETF	175.95	175.95	175.85	175.85	6000.0

> showing 50 of 7,994 rows — these rows as CSV

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