PREVIEW / etf_1hour / 2017-06-19

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-19.parquet
  size:    277 KB
  rows:    9,046

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-19 04:00:00	SPY	ETF	243.2	243.42	243.2	243.35	7620.0
2017-06-19 05:00:00	SPY	ETF	243.35	243.46	243.31	243.33	5002.0
2017-06-19 06:00:00	SPY	ETF	243.33	243.35	243.3	243.35	3960.0
2017-06-19 07:00:00	SPY	ETF	243.4	243.52	243.39	243.47	171239.0
2017-06-19 08:00:00	SPY	ETF	243.49	243.56	243.36	243.49	344838.0
2017-06-19 09:00:00	SPY	ETF	243.48	243.9	243.44	243.89	6372541.0
2017-06-19 10:00:00	SPY	ETF	243.89	244.58	243.86	244.19	9003654.0
2017-06-19 11:00:00	SPY	ETF	244.19	244.34	244.07	244.29	5203174.0
2017-06-19 12:00:00	SPY	ETF	244.29	244.47	244.28	244.42	3159752.0
2017-06-19 13:00:00	SPY	ETF	244.42	244.67	244.42	244.43	7559476.0
2017-06-19 14:00:00	SPY	ETF	244.425	244.47	244.15	244.2375	6724931.0
2017-06-19 15:00:00	SPY	ETF	244.24	244.73	244.23	244.64	12421732.0
2017-06-19 16:00:00	SPY	ETF	244.64	244.7	244.293	244.38	12485702.0
2017-06-19 17:00:00	SPY	ETF	244.38	244.41	244.37	244.39	181288.0
2017-06-19 18:00:00	SPY	ETF	244.39	244.5	244.39	244.5	232614.0
2017-06-19 19:00:00	SPY	ETF	244.48	244.55	244.42	244.52	41118.0
2017-06-19 04:00:00	QQQ	ETF	138.87	139.15	138.87	139.06	13088.0
2017-06-19 05:00:00	QQQ	ETF	139.13	139.28	139.04	139.07	6518.0
2017-06-19 06:00:00	QQQ	ETF	139.05	139.1	139.02	139.1	2147.0
2017-06-19 07:00:00	QQQ	ETF	139.1	139.27	139.08	139.26	132670.0
2017-06-19 08:00:00	QQQ	ETF	139.26	139.49	139.18	139.39	563337.0
2017-06-19 09:00:00	QQQ	ETF	139.38	139.91	139.28	139.82	5978932.0
2017-06-19 10:00:00	QQQ	ETF	139.82	140.38	139.82	140.15	6799787.0
2017-06-19 11:00:00	QQQ	ETF	140.1439	140.24	140.08	140.11	2142776.0
2017-06-19 12:00:00	QQQ	ETF	140.11	140.23	140.0	140.19	1947117.0
2017-06-19 13:00:00	QQQ	ETF	140.2	140.59	140.17	140.3501	2161422.0
2017-06-19 14:00:00	QQQ	ETF	140.35	140.4093	140.03	140.125	2927195.0
2017-06-19 15:00:00	QQQ	ETF	140.12	140.59	140.08	140.46	7847623.0
2017-06-19 16:00:00	QQQ	ETF	140.45	140.4814	140.15	140.29	2000536.0
2017-06-19 17:00:00	QQQ	ETF	140.25	140.44	140.25	140.3	1731707.0
2017-06-19 18:00:00	QQQ	ETF	140.26	140.43	140.25	140.41	51205.0
2017-06-19 19:00:00	QQQ	ETF	140.41	140.49	140.37	140.46	32923.0
2017-06-19 04:00:00	IWM	ETF	140.67	140.79	140.56	140.56	6663.0
2017-06-19 05:00:00	IWM	ETF	140.61	140.61	140.47	140.47	3509.0
2017-06-19 06:00:00	IWM	ETF	140.57	140.57	140.52	140.52	4100.0
2017-06-19 07:00:00	IWM	ETF	140.64	140.75	140.64	140.71	42912.0
2017-06-19 08:00:00	IWM	ETF	140.7	140.79	136.24	140.58	211278.0
2017-06-19 09:00:00	IWM	ETF	140.52	141.14	140.52	140.95	3290399.0
2017-06-19 10:00:00	IWM	ETF	140.94	141.23	140.67	140.89	3371467.0
2017-06-19 11:00:00	IWM	ETF	140.89	141.12	140.51	140.82	2642904.0
2017-06-19 12:00:00	IWM	ETF	140.83	141.34	140.8	141.29	1485128.0
2017-06-19 13:00:00	IWM	ETF	141.29	141.58	141.28	141.29	1884770.0
2017-06-19 14:00:00	IWM	ETF	141.28	141.34	140.89	141.01	1618742.0
2017-06-19 15:00:00	IWM	ETF	141.01	141.33	140.87	141.22	3270277.0
2017-06-19 16:00:00	IWM	ETF	141.21	141.38	140.1745	141.1268	2339906.0
2017-06-19 17:00:00	IWM	ETF	141.14	141.14	141.14	141.14	100.0
2017-06-19 18:00:00	IWM	ETF	141.16	141.24	141.16	141.24	3350.0
2017-06-19 19:00:00	IWM	ETF	141.23	141.25	141.22	141.25	2854.0
2017-06-19 04:00:00	DIA	ETF	214.3	214.3	214.19	214.19	300.0
2017-06-19 05:00:00	DIA	ETF	214.24	214.24	214.24	214.24	100.0

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

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