PREVIEW / etf_1hour / 2016-03-22

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-22.parquet
  size:    250 KB
  rows:    7,963

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-22 04:00:00	SPY	ETF	204.0	204.17	203.36	203.87	112545.0
2016-03-22 05:00:00	SPY	ETF	204.0	204.5	203.92	204.26	74892.0
2016-03-22 06:00:00	SPY	ETF	204.24	204.39	203.75	204.0	203438.0
2016-03-22 07:00:00	SPY	ETF	204.02	204.32	203.82	203.91	222688.0
2016-03-22 08:00:00	SPY	ETF	203.93	204.585	203.75	204.01	665795.0
2016-03-22 09:00:00	SPY	ETF	204.01	204.23	203.57	204.18	10252655.0
2016-03-22 10:00:00	SPY	ETF	204.18	204.69	204.05	204.525	9720995.0
2016-03-22 11:00:00	SPY	ETF	204.53	204.78	204.28	204.35	8710238.0
2016-03-22 12:00:00	SPY	ETF	204.345	205.15	204.3424	205.1489	8807170.0
2016-03-22 13:00:00	SPY	ETF	205.14	205.23	204.93	205.01	7556941.0
2016-03-22 14:00:00	SPY	ETF	205.02	205.22	204.73	204.73	13977443.0
2016-03-22 15:00:00	SPY	ETF	204.7201	204.8	204.31	204.59	22372684.0
2016-03-22 16:00:00	SPY	ETF	204.59	204.79	204.51	204.79	9792643.0
2016-03-22 17:00:00	SPY	ETF	204.78	204.78	204.66	204.74	226864.0
2016-03-22 18:00:00	SPY	ETF	204.74	204.76	204.54	204.57	216546.0
2016-03-22 19:00:00	SPY	ETF	204.56	204.68	204.5	204.66	117943.0
2016-03-22 20:00:00	SPY	ETF	204.5301	204.5301	204.5301	204.5301	450000.0
2016-03-22 04:00:00	QQQ	ETF	107.32	107.32	107.0	107.18	6644.0
2016-03-22 05:00:00	QQQ	ETF	107.35	107.55	107.35	107.55	3798.0
2016-03-22 06:00:00	QQQ	ETF	107.43	107.43	107.22	107.25	9714.0
2016-03-22 07:00:00	QQQ	ETF	107.38	107.49	107.22	107.26	32858.0
2016-03-22 08:00:00	QQQ	ETF	107.3	107.37	107.19	107.3	71982.0
2016-03-22 09:00:00	QQQ	ETF	107.26	107.77	107.1	107.67	2237969.0
2016-03-22 10:00:00	QQQ	ETF	107.68	107.98	107.6	107.8782	2539646.0
2016-03-22 11:00:00	QQQ	ETF	107.88	108.06	107.78	107.81	1832425.0
2016-03-22 12:00:00	QQQ	ETF	107.81	108.26	107.7875	108.23	1906317.0
2016-03-22 13:00:00	QQQ	ETF	108.22	108.37	108.16	108.22	1679673.0
2016-03-22 14:00:00	QQQ	ETF	108.23	108.37	108.08	108.0801	1737383.0
2016-03-22 15:00:00	QQQ	ETF	108.08	108.155	107.9	108.09	4256958.0
2016-03-22 16:00:00	QQQ	ETF	108.07	108.29	108.07	108.24	235060.0
2016-03-22 17:00:00	QQQ	ETF	108.24	108.24	108.13	108.17	15942.0
2016-03-22 18:00:00	QQQ	ETF	108.18	108.2	108.12	108.12	34451.0
2016-03-22 19:00:00	QQQ	ETF	108.07	108.13	108.05	108.13	8102.0
2016-03-22 05:00:00	IWM	ETF	109.2	109.2	109.1	109.1	1700.0
2016-03-22 06:00:00	IWM	ETF	108.94	108.94	108.92	108.92	1000.0
2016-03-22 07:00:00	IWM	ETF	109.05	109.09	108.79	108.85	17866.0
2016-03-22 08:00:00	IWM	ETF	108.88	108.99	108.8	108.97	119506.0
2016-03-22 09:00:00	IWM	ETF	108.96	109.35	108.47	108.81	3826622.0
2016-03-22 10:00:00	IWM	ETF	108.82	109.3	108.73	109.21	2907303.0
2016-03-22 11:00:00	IWM	ETF	109.19	109.445	109.03	109.08	2362478.0
2016-03-22 12:00:00	IWM	ETF	109.09	109.63	109.06	109.56	2088595.0
2016-03-22 13:00:00	IWM	ETF	109.55	109.69	109.465	109.49	1550588.0
2016-03-22 14:00:00	IWM	ETF	109.49	109.66	109.325	109.35	2330662.0
2016-03-22 15:00:00	IWM	ETF	109.32	109.37	109.15	109.24	4657545.0
2016-03-22 16:00:00	IWM	ETF	109.25	109.33	109.11	109.22	1091821.0
2016-03-22 17:00:00	IWM	ETF	109.3	109.3	109.24	109.3	21946.0
2016-03-22 18:00:00	IWM	ETF	109.3	109.3	109.29	109.29	300.0
2016-03-22 19:00:00	IWM	ETF	109.22	109.25	109.2	109.25	2691.0
2016-03-22 07:00:00	DIA	ETF	175.71	175.76	175.26	175.48	11800.0
2016-03-22 08:00:00	DIA	ETF	175.61	175.63	175.39	175.62	13100.0

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

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