PREVIEW / etf_1hour / 2017-07-14

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-07-14.parquet
  size:    276 KB
  rows:    9,112

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-07-14 04:00:00	SPY	ETF	244.31	244.31	244.17	244.2	4756.0
2017-07-14 05:00:00	SPY	ETF	244.16	244.19	244.13	244.13	1505.0
2017-07-14 06:00:00	SPY	ETF	244.21	244.35	244.2	244.33	14771.0
2017-07-14 07:00:00	SPY	ETF	244.35	244.37	244.3	244.37	50925.0
2017-07-14 08:00:00	SPY	ETF	244.35	244.76	244.26	244.76	680276.0
2017-07-14 09:00:00	SPY	ETF	244.72	244.87	244.31	244.72	5552989.0
2017-07-14 10:00:00	SPY	ETF	244.725	244.89	244.58	244.84	3862464.0
2017-07-14 11:00:00	SPY	ETF	244.84	244.9	244.665	244.875	4046268.0
2017-07-14 12:00:00	SPY	ETF	244.875	245.29	244.8	245.195	4340209.0
2017-07-14 13:00:00	SPY	ETF	245.19	245.52	245.16	245.495	5278736.0
2017-07-14 14:00:00	SPY	ETF	245.5	245.655	245.475	245.515	4273552.0
2017-07-14 15:00:00	SPY	ETF	245.52	245.97	245.4	245.54	19344220.0
2017-07-14 16:00:00	SPY	ETF	245.53	245.63	245.4	245.61	11281146.0
2017-07-14 17:00:00	SPY	ETF	245.57	245.64	245.52	245.57	45739.0
2017-07-14 18:00:00	SPY	ETF	245.55	245.59	245.51	245.59	16897.0
2017-07-14 19:00:00	SPY	ETF	245.55	245.64	245.5284	245.6	1098308.0
2017-07-14 04:00:00	QQQ	ETF	141.02	141.02	140.96	141.02	13838.0
2017-07-14 05:00:00	QQQ	ETF	140.96	141.01	140.93	140.93	2900.0
2017-07-14 06:00:00	QQQ	ETF	141.06	141.08	141.06	141.08	5968.0
2017-07-14 07:00:00	QQQ	ETF	141.08	141.17	141.04	141.16	20436.0
2017-07-14 08:00:00	QQQ	ETF	141.16	141.76	141.07	141.76	706969.0
2017-07-14 09:00:00	QQQ	ETF	141.77	141.88	141.38	141.4	5216486.0
2017-07-14 10:00:00	QQQ	ETF	141.395	141.52	141.19	141.48	3899239.0
2017-07-14 11:00:00	QQQ	ETF	141.48	141.61	141.375	141.58	2245550.0
2017-07-14 12:00:00	QQQ	ETF	141.58	141.8674	141.535	141.8	2134607.0
2017-07-14 13:00:00	QQQ	ETF	141.8	142.08	141.76	142.04	2567231.0
2017-07-14 14:00:00	QQQ	ETF	142.04	142.18	142.02	142.02	1949705.0
2017-07-14 15:00:00	QQQ	ETF	142.03	142.3	142.02	142.13	6722626.0
2017-07-14 16:00:00	QQQ	ETF	142.13	142.27	141.7829	142.27	2256676.0
2017-07-14 17:00:00	QQQ	ETF	142.18	142.26	142.12	142.2	69162.0
2017-07-14 18:00:00	QQQ	ETF	142.2	142.23	142.18	142.2	1804.0
2017-07-14 19:00:00	QQQ	ETF	142.23	142.24	142.18	142.18	6930.0
2017-07-14 04:00:00	IWM	ETF	141.2	141.2	141.2	141.2	300.0
2017-07-14 05:00:00	IWM	ETF	141.32	141.32	141.32	141.32	100.0
2017-07-14 06:00:00	IWM	ETF	141.46	141.46	141.46	141.46	260.0
2017-07-14 07:00:00	IWM	ETF	141.44	141.44	141.44	141.44	100.0
2017-07-14 08:00:00	IWM	ETF	141.43	141.57	141.35	141.5	32961.0
2017-07-14 09:00:00	IWM	ETF	141.53	141.75	141.07	141.66	1785540.0
2017-07-14 10:00:00	IWM	ETF	141.66	141.7	141.37	141.67	1747814.0
2017-07-14 11:00:00	IWM	ETF	141.66	141.88	141.54	141.8	1920305.0
2017-07-14 12:00:00	IWM	ETF	141.81	141.87	141.54	141.78	1105686.0
2017-07-14 13:00:00	IWM	ETF	141.78	142.07	141.74	141.99	1661681.0
2017-07-14 14:00:00	IWM	ETF	141.99	142.2	141.96	142.04	1796795.0
2017-07-14 15:00:00	IWM	ETF	142.05	142.3	141.68	141.73	3673998.0
2017-07-14 16:00:00	IWM	ETF	141.73	141.9	141.71	141.87	769662.0
2017-07-14 17:00:00	IWM	ETF	141.85	141.85	141.73	141.73	2490.0
2017-07-14 18:00:00	IWM	ETF	141.74	141.74	141.73	141.73	5000.0
2017-07-14 19:00:00	IWM	ETF	141.8	141.8	141.74	141.74	7275.0
2017-07-14 05:00:00	DIA	ETF	215.4	215.4	215.4	215.4	100.0
2017-07-14 08:00:00	DIA	ETF	215.46	215.49	215.4	215.4	2050.0

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

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