PREVIEW / etf_1hour / 2017-03-10

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-10.parquet
  size:    275 KB
  rows:    8,878

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-03-10 04:00:00	SPY	ETF	237.71	237.85	237.63	237.68	7170.0
2017-03-10 05:00:00	SPY	ETF	237.73	237.86	237.67	237.7	45390.0
2017-03-10 06:00:00	SPY	ETF	237.76	237.94	237.73	237.84	301106.0
2017-03-10 07:00:00	SPY	ETF	237.82	237.82	237.66	237.68	336064.0
2017-03-10 08:00:00	SPY	ETF	237.69	238.32	236.97	238.14	1783710.0
2017-03-10 09:00:00	SPY	ETF	238.1	238.11	237.42	237.94	9634044.0
2017-03-10 10:00:00	SPY	ETF	237.94	238.02	237.19	237.22	12287934.0
2017-03-10 11:00:00	SPY	ETF	237.21	237.52	236.98	237.31	7854472.0
2017-03-10 12:00:00	SPY	ETF	237.32	237.45	236.81	237.02	5151057.0
2017-03-10 13:00:00	SPY	ETF	237.03	237.14	236.59	237.11	6854929.0
2017-03-10 14:00:00	SPY	ETF	237.11	237.39	237.005	237.28	6023957.0
2017-03-10 15:00:00	SPY	ETF	237.28	237.68	237.28	237.64	17954722.0
2017-03-10 16:00:00	SPY	ETF	237.64	237.69	237.38	237.5	11780801.0
2017-03-10 17:00:00	SPY	ETF	237.5	237.61	237.47	237.6	171725.0
2017-03-10 18:00:00	SPY	ETF	237.6	237.8	237.6	237.75	133094.0
2017-03-10 19:00:00	SPY	ETF	237.74	237.78	237.73	237.78	41516.0
2017-03-10 04:00:00	QQQ	ETF	131.2	131.37	131.2	131.37	1027.0
2017-03-10 05:00:00	QQQ	ETF	131.26	131.26	131.23	131.23	277.0
2017-03-10 06:00:00	QQQ	ETF	131.32	131.39	131.32	131.34	64192.0
2017-03-10 07:00:00	QQQ	ETF	131.32	131.32	131.22	131.26	21424.0
2017-03-10 08:00:00	QQQ	ETF	131.24	131.49	131.23	131.43	256580.0
2017-03-10 09:00:00	QQQ	ETF	131.43	131.58	131.2	131.54	3087021.0
2017-03-10 10:00:00	QQQ	ETF	131.55	131.6	131.15	131.3	2678301.0
2017-03-10 11:00:00	QQQ	ETF	131.3	131.43	131.15	131.31	1709898.0
2017-03-10 12:00:00	QQQ	ETF	131.32	131.33	130.9	131.04	1626919.0
2017-03-10 13:00:00	QQQ	ETF	131.05	131.129	130.82	131.1058	1556873.0
2017-03-10 14:00:00	QQQ	ETF	131.105	131.27	131.0636	131.2	1619222.0
2017-03-10 15:00:00	QQQ	ETF	131.2	131.39	131.2	131.38	3682996.0
2017-03-10 16:00:00	QQQ	ETF	131.39	131.39	131.26	131.29	1437752.0
2017-03-10 17:00:00	QQQ	ETF	131.25	131.25	131.1	131.1	1068.0
2017-03-10 18:00:00	QQQ	ETF	131.3	131.36	131.23	131.36	22569.0
2017-03-10 19:00:00	QQQ	ETF	131.3	131.35	131.3	131.31	4270.0
2017-03-10 04:00:00	IWM	ETF	135.87	136.12	135.87	136.03	4020.0
2017-03-10 05:00:00	IWM	ETF	136.0	136.09	136.0	136.06	6400.0
2017-03-10 06:00:00	IWM	ETF	136.07	136.16	136.07	136.15	12317.0
2017-03-10 07:00:00	IWM	ETF	136.04	136.11	135.99	136.07	61869.0
2017-03-10 08:00:00	IWM	ETF	136.0	136.54	135.97	136.46	223172.0
2017-03-10 09:00:00	IWM	ETF	136.47	136.47	135.61	136.17	4386013.0
2017-03-10 10:00:00	IWM	ETF	136.17	136.29	135.34	135.43	5120067.0
2017-03-10 11:00:00	IWM	ETF	135.42	135.65	135.0	135.57	4356434.0
2017-03-10 12:00:00	IWM	ETF	135.56	135.61	135.06	135.26	2012986.0
2017-03-10 13:00:00	IWM	ETF	135.27	135.3799	134.84	135.34	3153012.0
2017-03-10 14:00:00	IWM	ETF	135.35	135.7	135.23	135.5	2202600.0
2017-03-10 15:00:00	IWM	ETF	135.49	136.03	135.49	135.92	5842798.0
2017-03-10 16:00:00	IWM	ETF	135.92	135.96	135.53	135.59	1683192.0
2017-03-10 17:00:00	IWM	ETF	135.6	135.63	135.53	135.53	24211.0
2017-03-10 18:00:00	IWM	ETF	135.64	135.96	135.63	135.65	4790.0
2017-03-10 19:00:00	IWM	ETF	135.848	135.848	135.65	135.7	328776.0
2017-03-10 04:00:00	DIA	ETF	209.1	209.28	209.1	209.28	205.0
2017-03-10 07:00:00	DIA	ETF	209.31	209.41	209.31	209.4	1100.0

> showing 50 of 8,878 rows — these rows as CSV

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