PREVIEW / etf_1hour / 2016-10-12

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-10-12.parquet
  size:    253 KB
  rows:    8,206

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
2016-10-12 04:00:00	SPY	ETF	213.67	213.71	213.43	213.64	52366.0
2016-10-12 05:00:00	SPY	ETF	213.71	213.71	213.51	213.54	7264.0
2016-10-12 06:00:00	SPY	ETF	213.52	213.7	213.49	213.63	52007.0
2016-10-12 07:00:00	SPY	ETF	213.7	213.8	213.48	213.5	83050.0
2016-10-12 08:00:00	SPY	ETF	213.57	213.79	213.13	213.5	931415.0
2016-10-12 09:00:00	SPY	ETF	213.48	213.71	213.01	213.65	10662272.0
2016-10-12 10:00:00	SPY	ETF	213.645	214.06	213.32	213.41	13157089.0
2016-10-12 11:00:00	SPY	ETF	213.41	213.81	213.33	213.63	5933644.0
2016-10-12 12:00:00	SPY	ETF	213.64	214.1	213.63	213.95	5429551.0
2016-10-12 13:00:00	SPY	ETF	213.955	214.03	213.76	214.015	4360203.0
2016-10-12 14:00:00	SPY	ETF	214.005	214.32	213.67	213.805	11231066.0
2016-10-12 15:00:00	SPY	ETF	213.8	214.0	213.5	213.72	14804448.0
2016-10-12 16:00:00	SPY	ETF	213.71	213.8998	213.16	213.17	5296319.0
2016-10-12 17:00:00	SPY	ETF	213.2	213.71	213.11	213.15	252516.0
2016-10-12 18:00:00	SPY	ETF	213.17	213.28	213.11	213.27	365846.0
2016-10-12 19:00:00	SPY	ETF	213.26	213.41	213.26	213.32	67796.0
2016-10-12 04:00:00	QQQ	ETF	117.43	117.52	117.43	117.52	9653.0
2016-10-12 05:00:00	QQQ	ETF	117.47	117.47	117.47	117.47	7000.0
2016-10-12 06:00:00	QQQ	ETF	117.45	117.52	117.45	117.52	10200.0
2016-10-12 07:00:00	QQQ	ETF	117.58	117.6	117.52	117.52	14669.0
2016-10-12 08:00:00	QQQ	ETF	117.49	117.52	117.25	117.49	129467.0
2016-10-12 09:00:00	QQQ	ETF	117.48	117.63	117.06	117.44	2731131.0
2016-10-12 10:00:00	QQQ	ETF	117.444	117.59	117.21	117.245	2383823.0
2016-10-12 11:00:00	QQQ	ETF	117.25	117.59	117.23	117.49	1061966.0
2016-10-12 12:00:00	QQQ	ETF	117.5	117.65	117.44	117.57	965539.0
2016-10-12 13:00:00	QQQ	ETF	117.57	117.68	117.47	117.65	592608.0
2016-10-12 14:00:00	QQQ	ETF	117.66	117.82	117.46	117.5	2036475.0
2016-10-12 15:00:00	QQQ	ETF	117.5	117.57	117.24	117.42	2715720.0
2016-10-12 16:00:00	QQQ	ETF	117.42	117.46	117.25	117.25	371911.0
2016-10-12 17:00:00	QQQ	ETF	117.18	117.3	117.18	117.19	16044.0
2016-10-12 18:00:00	QQQ	ETF	117.25	117.3	117.18	117.25	20567.0
2016-10-12 19:00:00	QQQ	ETF	117.25	117.32	117.25	117.28	17670.0
2016-10-12 04:00:00	IWM	ETF	122.0	122.08	122.0	122.08	300.0
2016-10-12 07:00:00	IWM	ETF	122.13	122.16	122.0	122.0	20473.0
2016-10-12 08:00:00	IWM	ETF	122.0	122.05	121.75	122.05	227188.0
2016-10-12 09:00:00	IWM	ETF	122.05	122.31	121.5328	122.31	2709178.0
2016-10-12 10:00:00	IWM	ETF	122.3	122.44	121.7773	121.93	3362708.0
2016-10-12 11:00:00	IWM	ETF	121.94	122.61	121.91	122.24	2314788.0
2016-10-12 12:00:00	IWM	ETF	122.25	122.39	122.1901	122.22	1215632.0
2016-10-12 13:00:00	IWM	ETF	122.23	122.38	122.1	122.23	1584919.0
2016-10-12 14:00:00	IWM	ETF	122.22	122.5	122.005	122.05	2951044.0
2016-10-12 15:00:00	IWM	ETF	122.06	122.0995	121.765	121.91	3876776.0
2016-10-12 16:00:00	IWM	ETF	121.9	121.95	121.54	121.54	790164.0
2016-10-12 17:00:00	IWM	ETF	121.65	121.65	121.65	121.65	100.0
2016-10-12 18:00:00	IWM	ETF	121.65	121.65	121.52	121.52	5468.0
2016-10-12 19:00:00	IWM	ETF	121.53	121.62	121.53	121.61	300.0
2016-10-12 04:00:00	DIA	ETF	181.16	181.16	181.16	181.16	200.0
2016-10-12 07:00:00	DIA	ETF	181.2	181.2	181.2	181.2	500.0
2016-10-12 08:00:00	DIA	ETF	180.85	180.91	180.85	180.91	600.0
2016-10-12 09:00:00	DIA	ETF	181.16	181.18	180.66	181.16	349414.0

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

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