PREVIEW / etf_1hour / 2017-10-10

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-10.parquet
  size:    280 KB
  rows:    9,170

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
2017-10-10 04:00:00	SPY	ETF	254.25	254.25	254.15	254.23	1006.0
2017-10-10 05:00:00	SPY	ETF	254.22	254.42	254.22	254.42	2663.0
2017-10-10 06:00:00	SPY	ETF	254.39	254.5	254.39	254.45	30337.0
2017-10-10 07:00:00	SPY	ETF	254.46	254.48	254.36	254.48	65729.0
2017-10-10 08:00:00	SPY	ETF	254.45	254.59	254.45	254.58	145633.0
2017-10-10 09:00:00	SPY	ETF	254.58	255.05	254.52	254.73	6134317.0
2017-10-10 10:00:00	SPY	ETF	254.7201	254.74	254.03	254.36	5477051.0
2017-10-10 11:00:00	SPY	ETF	254.36	254.41	254.09	254.16	5618130.0
2017-10-10 12:00:00	SPY	ETF	254.16	254.41	253.98	254.32	3535443.0
2017-10-10 13:00:00	SPY	ETF	254.325	254.55	254.27	254.34	2637144.0
2017-10-10 14:00:00	SPY	ETF	254.34	254.4475	254.24	254.32	2387903.0
2017-10-10 15:00:00	SPY	ETF	254.32	254.6	254.31	254.6	9286351.0
2017-10-10 16:00:00	SPY	ETF	254.59	254.63	254.52	254.61	4559307.0
2017-10-10 17:00:00	SPY	ETF	254.6	254.61	254.51	254.52	161706.0
2017-10-10 18:00:00	SPY	ETF	254.53	254.55	254.48	254.53	98057.0
2017-10-10 19:00:00	SPY	ETF	254.53	254.6	254.48	254.55	53223.0
2017-10-10 04:00:00	QQQ	ETF	147.73	147.75	147.64	147.71	16597.0
2017-10-10 05:00:00	QQQ	ETF	147.7	147.79	147.7	147.79	4600.0
2017-10-10 06:00:00	QQQ	ETF	147.76	147.76	147.76	147.76	900.0
2017-10-10 07:00:00	QQQ	ETF	147.76	147.83	147.75	147.83	10098.0
2017-10-10 08:00:00	QQQ	ETF	147.76	147.94	147.76	147.93	113561.0
2017-10-10 09:00:00	QQQ	ETF	147.92	148.14	147.69	147.73	2289574.0
2017-10-10 10:00:00	QQQ	ETF	147.74	147.74	147.2001	147.55	3213910.0
2017-10-10 11:00:00	QQQ	ETF	147.545	147.57	147.09	147.22	1677966.0
2017-10-10 12:00:00	QQQ	ETF	147.21	147.4	146.95	147.33	3122066.0
2017-10-10 13:00:00	QQQ	ETF	147.33	147.53	147.31	147.32	1313829.0
2017-10-10 14:00:00	QQQ	ETF	147.32	147.44	147.26	147.42	816389.0
2017-10-10 15:00:00	QQQ	ETF	147.425	147.62	147.42	147.61	2447377.0
2017-10-10 16:00:00	QQQ	ETF	147.62	147.65	147.52	147.58	395989.0
2017-10-10 17:00:00	QQQ	ETF	147.59	147.59	147.55	147.57	17561.0
2017-10-10 18:00:00	QQQ	ETF	147.55	147.56	147.53	147.56	18906.0
2017-10-10 19:00:00	QQQ	ETF	147.56	147.6	147.55	147.58	31954.0
2017-10-10 04:00:00	IWM	ETF	149.83	149.83	149.65	149.65	15140.0
2017-10-10 05:00:00	IWM	ETF	149.89	149.91	149.89	149.9	8000.0
2017-10-10 06:00:00	IWM	ETF	149.91	150.0	149.9	149.94	11270.0
2017-10-10 07:00:00	IWM	ETF	149.95	149.96	149.87	149.89	20107.0
2017-10-10 08:00:00	IWM	ETF	149.43	149.98	149.43	149.97	121063.0
2017-10-10 09:00:00	IWM	ETF	149.98	150.29	149.86	149.9867	2907079.0
2017-10-10 10:00:00	IWM	ETF	149.99	150.0	149.7	149.9073	2890897.0
2017-10-10 11:00:00	IWM	ETF	149.9	150.09	149.665	149.72	1415738.0
2017-10-10 12:00:00	IWM	ETF	149.71	149.73	149.47	149.541	1392750.0
2017-10-10 13:00:00	IWM	ETF	149.52	149.695	149.45	149.56	652788.0
2017-10-10 14:00:00	IWM	ETF	149.56	149.62	149.41	149.53	807285.0
2017-10-10 15:00:00	IWM	ETF	149.54	149.93	149.54	149.85	2418360.0
2017-10-10 16:00:00	IWM	ETF	149.85	149.96	149.8071	149.85	987734.0
2017-10-10 17:00:00	IWM	ETF	150.0116	150.0116	149.73	149.76	40060.0
2017-10-10 18:00:00	IWM	ETF	149.86	149.86	149.8	149.8	759088.0
2017-10-10 19:00:00	IWM	ETF	149.84	149.86	149.82	149.82	3732.0
2017-10-10 08:00:00	DIA	ETF	227.97	228.07	227.96	228.06	1152.0
2017-10-10 09:00:00	DIA	ETF	228.01	228.43	227.95	228.36	221794.0

> showing 50 of 9,170 rows — these rows as CSV

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