PREVIEW / etf_1hour / 2015-09-17

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-09-17.parquet
  size:    239 KB
  rows:    7,619

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
2015-09-17 04:00:00	SPY	ETF	200.15	200.32	199.85	200.1	32018.0
2015-09-17 05:00:00	SPY	ETF	200.12	200.27	199.89	199.99	35876.0
2015-09-17 06:00:00	SPY	ETF	200.01	200.38	200.0	200.24	36711.0
2015-09-17 07:00:00	SPY	ETF	200.22	200.3	199.91	199.96	206403.0
2015-09-17 08:00:00	SPY	ETF	199.94	200.27	199.8	200.0	580099.0
2015-09-17 09:00:00	SPY	ETF	200.0	200.28	199.34	200.135	12188593.0
2015-09-17 10:00:00	SPY	ETF	200.13	200.41	199.98	200.3062	18150435.0
2015-09-17 11:00:00	SPY	ETF	200.29	200.535	200.24	200.303	12935405.0
2015-09-17 12:00:00	SPY	ETF	200.31	200.76	200.2	200.645	19569716.0
2015-09-17 13:00:00	SPY	ETF	200.645	201.11	200.5	200.7892	16153331.0
2015-09-17 14:00:00	SPY	ETF	200.79	202.89	199.29	202.2	87631880.0
2015-09-17 15:00:00	SPY	ETF	202.19	202.44	199.28	199.76	75010111.0
2015-09-17 16:00:00	SPY	ETF	199.7	202.8507	198.99	199.4	27470063.0
2015-09-17 17:00:00	SPY	ETF	199.43	201.0	199.31	199.43	1970278.0
2015-09-17 18:00:00	SPY	ETF	199.43	199.67	199.24	199.64	250256.0
2015-09-17 19:00:00	SPY	ETF	199.61	199.61	199.37	199.4	108229.0
2015-09-17 06:00:00	QQQ	ETF	107.05	107.07	107.05	107.07	400.0
2015-09-17 07:00:00	QQQ	ETF	107.16	107.16	106.99	106.99	10300.0
2015-09-17 08:00:00	QQQ	ETF	107.13	107.17	106.92	107.03	100952.0
2015-09-17 09:00:00	QQQ	ETF	107.03	107.12	106.84	107.01	2752245.0
2015-09-17 10:00:00	QQQ	ETF	106.99	107.235	106.934	107.17	2268940.0
2015-09-17 11:00:00	QQQ	ETF	107.17	107.29	107.06	107.14	2480493.0
2015-09-17 12:00:00	QQQ	ETF	107.14	107.39	107.07	107.31	2174271.0
2015-09-17 13:00:00	QQQ	ETF	107.31	107.55	107.22	107.33	3048590.0
2015-09-17 14:00:00	QQQ	ETF	107.37	108.725	106.64	108.4	14419652.0
2015-09-17 15:00:00	QQQ	ETF	108.41	108.59	106.89	107.11	14683094.0
2015-09-17 16:00:00	QQQ	ETF	107.1	107.17	106.69	106.93	2075602.0
2015-09-17 17:00:00	QQQ	ETF	106.99	107.13	106.87	106.99	238020.0
2015-09-17 18:00:00	QQQ	ETF	106.94	107.11	106.88	107.1	34742.0
2015-09-17 19:00:00	QQQ	ETF	107.06	107.06	106.95	107.0	6439.0
2015-09-17 04:00:00	IWM	ETF	117.06	117.06	117.06	117.06	100.0
2015-09-17 07:00:00	IWM	ETF	116.93	117.0	116.9	116.9	18100.0
2015-09-17 08:00:00	IWM	ETF	116.9	116.99	116.81	116.88	51197.0
2015-09-17 09:00:00	IWM	ETF	116.91	117.05	116.68	116.94	2508260.0
2015-09-17 10:00:00	IWM	ETF	116.93	117.54	116.84	117.43	3420469.0
2015-09-17 11:00:00	IWM	ETF	117.43	117.71	117.42	117.54	2438392.0
2015-09-17 12:00:00	IWM	ETF	117.55	118.01	117.39	117.975	2047684.0
2015-09-17 13:00:00	IWM	ETF	117.9799	118.31	117.61	117.6997	3841293.0
2015-09-17 14:00:00	IWM	ETF	117.7	118.89	116.97	118.57	11941090.0
2015-09-17 15:00:00	IWM	ETF	118.58	118.73	116.9	117.39	11055634.0
2015-09-17 16:00:00	IWM	ETF	117.38	117.39	116.89	117.27	2969114.0
2015-09-17 17:00:00	IWM	ETF	117.34	117.34	117.23	117.28	166691.0
2015-09-17 18:00:00	IWM	ETF	117.23	117.23	117.23	117.23	118.0
2015-09-17 06:00:00	DIA	ETF	167.49	167.52	167.49	167.52	200.0
2015-09-17 08:00:00	DIA	ETF	167.26	167.32	167.26	167.32	200.0
2015-09-17 09:00:00	DIA	ETF	167.29	167.53	167.09	167.38	634327.0
2015-09-17 10:00:00	DIA	ETF	167.35	167.59	167.25	167.535	652836.0
2015-09-17 11:00:00	DIA	ETF	167.53	167.75	167.485	167.55	503133.0
2015-09-17 12:00:00	DIA	ETF	167.57	167.82	167.46	167.75	517144.0
2015-09-17 13:00:00	DIA	ETF	167.73	168.14	167.61	167.63	708968.0

> showing 50 of 7,619 rows — these rows as CSV

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