PREVIEW / etf_1hour / 2017-06-08

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-08.parquet
  size:    277 KB
  rows:    9,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
2017-06-08 04:00:00	SPY	ETF	243.7	243.81	243.68	243.76	12395.0
2017-06-08 05:00:00	SPY	ETF	243.81	243.92	243.81	243.83	11700.0
2017-06-08 06:00:00	SPY	ETF	243.87	244.08	243.83	244.03	115250.0
2017-06-08 07:00:00	SPY	ETF	244.03	244.07	243.85	243.87	301255.0
2017-06-08 08:00:00	SPY	ETF	243.95	244.07	243.74	243.76	278301.0
2017-06-08 09:00:00	SPY	ETF	243.79	244.02	243.3	243.57	4846169.0
2017-06-08 10:00:00	SPY	ETF	243.58	243.8	243.17	243.5746	7658482.0
2017-06-08 11:00:00	SPY	ETF	243.57	243.9	243.57	243.855	6734234.0
2017-06-08 12:00:00	SPY	ETF	243.85	244.33	243.84	244.17	7865141.0
2017-06-08 13:00:00	SPY	ETF	244.175	244.19	243.63	243.985	7150610.0
2017-06-08 14:00:00	SPY	ETF	243.985	244.02	243.19	243.33	10039994.0
2017-06-08 15:00:00	SPY	ETF	243.33	243.86	243.32	243.76	14418262.0
2017-06-08 16:00:00	SPY	ETF	243.77	243.88	243.6	243.88	4582997.0
2017-06-08 17:00:00	SPY	ETF	243.84	243.84	243.19	243.2	811478.0
2017-06-08 18:00:00	SPY	ETF	243.19	243.44	243.04	243.32	269071.0
2017-06-08 19:00:00	SPY	ETF	243.31	243.31	243.15	243.18	76846.0
2017-06-08 04:00:00	QQQ	ETF	143.5	143.5	143.5	143.5	100.0
2017-06-08 05:00:00	QQQ	ETF	143.57	143.57	143.57	143.57	100.0
2017-06-08 06:00:00	QQQ	ETF	143.59	143.74	143.59	143.72	1774.0
2017-06-08 07:00:00	QQQ	ETF	143.74	143.82	143.71	143.72	148547.0
2017-06-08 08:00:00	QQQ	ETF	143.74	143.83	143.7	143.74	79432.0
2017-06-08 09:00:00	QQQ	ETF	143.73	143.87	142.97	143.14	3456808.0
2017-06-08 10:00:00	QQQ	ETF	143.155	143.3	142.79	143.22	4507994.0
2017-06-08 11:00:00	QQQ	ETF	143.23	143.49	143.22	143.39	2456275.0
2017-06-08 12:00:00	QQQ	ETF	143.39	143.54	143.3	143.4	2163888.0
2017-06-08 13:00:00	QQQ	ETF	143.4	143.43	143.11	143.34	1668553.0
2017-06-08 14:00:00	QQQ	ETF	143.34	143.36	143.0	143.0965	2051024.0
2017-06-08 15:00:00	QQQ	ETF	143.099	143.64	143.091	143.58	3399985.0
2017-06-08 16:00:00	QQQ	ETF	143.57	143.71	143.49	143.71	1565496.0
2017-06-08 17:00:00	QQQ	ETF	143.65	143.65	143.3	143.39	95576.0
2017-06-08 18:00:00	QQQ	ETF	143.33	143.57	143.22	143.39	41018.0
2017-06-08 19:00:00	QQQ	ETF	143.39	143.39	143.27	143.29	10402.0
2017-06-08 04:00:00	IWM	ETF	139.0	139.0	139.0	139.0	200.0
2017-06-08 05:00:00	IWM	ETF	139.11	139.11	139.11	139.11	1000.0
2017-06-08 06:00:00	IWM	ETF	139.15	139.29	139.15	139.29	11400.0
2017-06-08 07:00:00	IWM	ETF	139.26	139.32	139.03	139.03	116134.0
2017-06-08 08:00:00	IWM	ETF	139.29	139.29	138.85	138.9	57104.0
2017-06-08 09:00:00	IWM	ETF	138.96	139.57	138.74	139.53	1783994.0
2017-06-08 10:00:00	IWM	ETF	139.54	139.96	139.42	139.93	3783758.0
2017-06-08 11:00:00	IWM	ETF	139.93	140.53	139.93	140.465	3754453.0
2017-06-08 12:00:00	IWM	ETF	140.46	141.08	140.445	141.055	4360350.0
2017-06-08 13:00:00	IWM	ETF	141.04	141.46	140.95	141.36	4005146.0
2017-06-08 14:00:00	IWM	ETF	141.355	141.4	140.66	140.87	2608871.0
2017-06-08 15:00:00	IWM	ETF	140.875	141.15	140.8	140.86	5270282.0
2017-06-08 16:00:00	IWM	ETF	140.88	140.9684	139.3999	140.92	1925682.0
2017-06-08 17:00:00	IWM	ETF	140.93	140.93	140.55	140.55	69108.0
2017-06-08 18:00:00	IWM	ETF	140.53	140.63	140.5	140.62	2350.0
2017-06-08 19:00:00	IWM	ETF	140.62	140.62	140.51	140.51	1800.0
2017-06-08 04:00:00	DIA	ETF	211.95	211.95	211.95	211.95	100.0
2017-06-08 07:00:00	DIA	ETF	212.0	212.0	211.9	211.9	1200.0

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

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