PREVIEW / etf_1hour / 2017-10-11

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-11.parquet
  size:    278 KB
  rows:    9,078

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-11 04:00:00	SPY	ETF	254.28	254.36	254.28	254.28	5930.0
2017-10-11 05:00:00	SPY	ETF	254.33	254.33	254.24	254.33	4550.0
2017-10-11 06:00:00	SPY	ETF	254.36	254.46	254.36	254.43	6403.0
2017-10-11 07:00:00	SPY	ETF	254.38	254.41	254.15	254.22	133524.0
2017-10-11 08:00:00	SPY	ETF	254.23	254.6	254.15	254.38	170310.0
2017-10-11 09:00:00	SPY	ETF	254.39	254.6425	254.32	254.43	3200723.0
2017-10-11 10:00:00	SPY	ETF	254.44	254.65	254.385	254.56	3333224.0
2017-10-11 11:00:00	SPY	ETF	254.55	254.7	254.51	254.58	4970051.0
2017-10-11 12:00:00	SPY	ETF	254.59	254.79	254.58	254.705	2496319.0
2017-10-11 13:00:00	SPY	ETF	254.7	254.81	254.6299	254.645	3406448.0
2017-10-11 14:00:00	SPY	ETF	254.64	254.89	254.6	254.745	4354036.0
2017-10-11 15:00:00	SPY	ETF	254.745	255.02	254.73	255.0	12507622.0
2017-10-11 16:00:00	SPY	ETF	255.01	255.05	254.94	254.95	11525701.0
2017-10-11 17:00:00	SPY	ETF	254.96	255.02	254.95	254.96	260917.0
2017-10-11 18:00:00	SPY	ETF	254.95	254.97	254.89	254.92	103524.0
2017-10-11 19:00:00	SPY	ETF	254.92	254.92	254.88	254.88	34448.0
2017-10-11 04:00:00	QQQ	ETF	147.43	147.46	147.41	147.44	13920.0
2017-10-11 05:00:00	QQQ	ETF	147.41	147.41	147.4	147.4	800.0
2017-10-11 06:00:00	QQQ	ETF	147.46	147.56	147.46	147.54	16000.0
2017-10-11 07:00:00	QQQ	ETF	147.5	147.54	147.29	147.36	119742.0
2017-10-11 08:00:00	QQQ	ETF	147.34	147.48	147.31	147.46	95763.0
2017-10-11 09:00:00	QQQ	ETF	147.47	147.665	147.34	147.51	1868538.0
2017-10-11 10:00:00	QQQ	ETF	147.52	147.81	147.48	147.67	1484358.0
2017-10-11 11:00:00	QQQ	ETF	147.65	147.7885	147.55	147.67	777631.0
2017-10-11 12:00:00	QQQ	ETF	147.68	147.79	147.67	147.735	878518.0
2017-10-11 13:00:00	QQQ	ETF	147.735	147.835	147.67	147.7	637151.0
2017-10-11 14:00:00	QQQ	ETF	147.71	147.9	147.66	147.81	1622467.0
2017-10-11 15:00:00	QQQ	ETF	147.81	148.07	147.81	148.05	3370213.0
2017-10-11 16:00:00	QQQ	ETF	148.06	148.06	147.9	147.99	577354.0
2017-10-11 17:00:00	QQQ	ETF	147.75	148.0	147.75	147.98	14520.0
2017-10-11 18:00:00	QQQ	ETF	147.97	148.0	147.95	147.95	15636.0
2017-10-11 19:00:00	QQQ	ETF	147.97	147.97	147.96	147.96	17700.0
2017-10-11 04:00:00	IWM	ETF	149.68	149.68	149.66	149.66	503.0
2017-10-11 05:00:00	IWM	ETF	149.69	149.69	149.69	149.69	1000.0
2017-10-11 06:00:00	IWM	ETF	149.73	149.78	149.73	149.75	8981.0
2017-10-11 07:00:00	IWM	ETF	149.71	149.76	149.51	149.58	48569.0
2017-10-11 08:00:00	IWM	ETF	149.75	149.87	149.6	149.85	86136.0
2017-10-11 09:00:00	IWM	ETF	149.85	150.15	149.79	149.9	1344746.0
2017-10-11 10:00:00	IWM	ETF	149.9	150.09	149.7	149.94	1182351.0
2017-10-11 11:00:00	IWM	ETF	149.94	150.19	149.87	149.9	1295198.0
2017-10-11 12:00:00	IWM	ETF	149.89	150.11	149.735	149.76	908927.0
2017-10-11 13:00:00	IWM	ETF	149.76	149.9	149.635	149.67	828539.0
2017-10-11 14:00:00	IWM	ETF	149.67	149.78	149.46	149.6	1214754.0
2017-10-11 15:00:00	IWM	ETF	149.605	149.88	149.58	149.73	3468934.0
2017-10-11 16:00:00	IWM	ETF	149.74	149.79	149.63	149.73	518422.0
2017-10-11 17:00:00	IWM	ETF	149.73	149.75	149.73	149.75	900.0
2017-10-11 18:00:00	IWM	ETF	149.71	149.71	149.61	149.65	7725.0
2017-10-11 19:00:00	IWM	ETF	149.65	149.7	149.65	149.7	2100.0
2017-10-11 07:00:00	DIA	ETF	228.1	228.1	227.93	227.93	1104.0
2017-10-11 08:00:00	DIA	ETF	228.15	228.25	228.1	228.1	2177.0

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

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