PREVIEW / etf_1hour / 2017-10-05

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-05.parquet
  size:    282 KB
  rows:    9,193

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-05 04:00:00	SPY	ETF	253.26	253.34	253.26	253.32	15030.0
2017-10-05 05:00:00	SPY	ETF	253.29	253.31	253.24	253.24	10950.0
2017-10-05 06:00:00	SPY	ETF	253.31	253.31	253.29	253.31	2000.0
2017-10-05 07:00:00	SPY	ETF	253.33	253.44	253.32	253.42	58922.0
2017-10-05 08:00:00	SPY	ETF	253.35	253.64	253.35	253.46	329595.0
2017-10-05 09:00:00	SPY	ETF	253.51	253.8	253.4	253.6	5615061.0
2017-10-05 10:00:00	SPY	ETF	253.6	253.86	253.59	253.765	4965107.0
2017-10-05 11:00:00	SPY	ETF	253.765	254.26	253.74	254.245	7450351.0
2017-10-05 12:00:00	SPY	ETF	254.24	254.61	254.23	254.41	6988584.0
2017-10-05 13:00:00	SPY	ETF	254.4	254.61	254.4	254.515	6363107.0
2017-10-05 14:00:00	SPY	ETF	254.51	254.59	254.4	254.56	7203219.0
2017-10-05 15:00:00	SPY	ETF	254.56	254.68	254.46	254.64	15578067.0
2017-10-05 16:00:00	SPY	ETF	254.64	254.75	254.1843	254.59	6679819.0
2017-10-05 17:00:00	SPY	ETF	254.64	254.66	254.6	254.63	56568.0
2017-10-05 18:00:00	SPY	ETF	254.61	254.62	254.54	254.59	94311.0
2017-10-05 19:00:00	SPY	ETF	254.58	254.624	254.55	254.58	270510.0
2017-10-05 04:00:00	QQQ	ETF	146.11	146.16	146.11	146.14	10300.0
2017-10-05 05:00:00	QQQ	ETF	146.11	146.11	146.08	146.08	40151.0
2017-10-05 06:00:00	QQQ	ETF	146.17	146.18	146.17	146.18	900.0
2017-10-05 07:00:00	QQQ	ETF	146.17	146.39	146.17	146.38	17720.0
2017-10-05 08:00:00	QQQ	ETF	146.39	146.67	146.16	146.55	104303.0
2017-10-05 09:00:00	QQQ	ETF	146.59	146.94	146.45	146.495	3885831.0
2017-10-05 10:00:00	QQQ	ETF	146.5	146.74	146.4063	146.49	1901789.0
2017-10-05 11:00:00	QQQ	ETF	146.4901	146.84	146.43	146.747	2007216.0
2017-10-05 12:00:00	QQQ	ETF	146.74	147.16	146.72	147.05	2805192.0
2017-10-05 13:00:00	QQQ	ETF	147.05	147.24	147.0234	147.2	1385891.0
2017-10-05 14:00:00	QQQ	ETF	147.195	147.41	147.09	147.38	2597431.0
2017-10-05 15:00:00	QQQ	ETF	147.39	147.54	147.31	147.46	7922468.0
2017-10-05 16:00:00	QQQ	ETF	147.45	147.61	147.4	147.49	1889571.0
2017-10-05 17:00:00	QQQ	ETF	147.52	147.52	147.4	147.46	43696.0
2017-10-05 18:00:00	QQQ	ETF	147.44	147.51	147.44	147.51	9898.0
2017-10-05 19:00:00	QQQ	ETF	147.5	147.52	147.47	147.52	6615.0
2017-10-05 04:00:00	IWM	ETF	150.02	150.06	150.01	150.06	10139.0
2017-10-05 05:00:00	IWM	ETF	150.07	150.07	150.01	150.03	6810.0
2017-10-05 06:00:00	IWM	ETF	150.06	150.08	150.05	150.05	6199.0
2017-10-05 07:00:00	IWM	ETF	150.01	150.17	149.99	150.11	31086.0
2017-10-05 08:00:00	IWM	ETF	147.86	150.36	147.86	150.17	82928.0
2017-10-05 09:00:00	IWM	ETF	150.19	150.36	149.87	149.91	3040313.0
2017-10-05 10:00:00	IWM	ETF	149.92	150.34	149.89	150.2	2455993.0
2017-10-05 11:00:00	IWM	ETF	150.21	150.53	150.14	150.41	1988214.0
2017-10-05 12:00:00	IWM	ETF	150.41	150.63	150.14	150.31	2008077.0
2017-10-05 13:00:00	IWM	ETF	150.31	150.4	150.2	150.3	907231.0
2017-10-05 14:00:00	IWM	ETF	150.3	150.32	150.11	150.27	1606419.0
2017-10-05 15:00:00	IWM	ETF	150.28	150.37	150.1	150.24	2995099.0
2017-10-05 16:00:00	IWM	ETF	150.23	150.44	150.22	150.3	644641.0
2017-10-05 17:00:00	IWM	ETF	150.26	150.35	150.26	150.35	3123.0
2017-10-05 18:00:00	IWM	ETF	150.3	150.3	150.25	150.3	5105.0
2017-10-05 19:00:00	IWM	ETF	150.28	150.31	150.27	150.29	3746.0
2017-10-05 08:00:00	DIA	ETF	226.67	226.67	226.58	226.58	1455.0
2017-10-05 09:00:00	DIA	ETF	226.71	226.87	226.4472	226.71	268846.0

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

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