PREVIEW / etf_1hour / 2016-06-08

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-08.parquet
  size:    250 KB
  rows:    8,029

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-06-08 04:00:00	SPY	ETF	211.49	211.6	211.49	211.6	2343.0
2016-06-08 05:00:00	SPY	ETF	211.66	211.74	211.66	211.7	2380.0
2016-06-08 06:00:00	SPY	ETF	211.75	211.93	211.75	211.9	17843.0
2016-06-08 07:00:00	SPY	ETF	211.86	212.0	211.83	212.0	173068.0
2016-06-08 08:00:00	SPY	ETF	211.99	212.03	211.415	211.98	360562.0
2016-06-08 09:00:00	SPY	ETF	211.99	212.42	211.8	212.4	7762369.0
2016-06-08 10:00:00	SPY	ETF	212.39	212.42	211.76	211.94	10617778.0
2016-06-08 11:00:00	SPY	ETF	211.93	212.19	211.6899	212.09	7611559.0
2016-06-08 12:00:00	SPY	ETF	212.095	212.33	212.06	212.18	6220776.0
2016-06-08 13:00:00	SPY	ETF	212.19	212.25	211.98	212.1392	3714901.0
2016-06-08 14:00:00	SPY	ETF	212.14	212.52	212.03	212.41	7803224.0
2016-06-08 15:00:00	SPY	ETF	212.42	212.49	212.21	212.34	13238446.0
2016-06-08 16:00:00	SPY	ETF	212.34	212.39	212.1902	212.31	6931574.0
2016-06-08 17:00:00	SPY	ETF	212.3	212.36	212.27	212.33	99858.0
2016-06-08 18:00:00	SPY	ETF	212.33	212.38	212.27	212.31	58856.0
2016-06-08 19:00:00	SPY	ETF	212.31	212.31	212.24	212.27	37986.0
2016-06-08 05:00:00	QQQ	ETF	110.24	110.24	110.24	110.24	25000.0
2016-06-08 07:00:00	QQQ	ETF	110.31	110.42	110.28	110.42	19088.0
2016-06-08 08:00:00	QQQ	ETF	110.41	110.48	110.36	110.45	175053.0
2016-06-08 09:00:00	QQQ	ETF	110.46	110.6	110.31	110.5593	2132352.0
2016-06-08 10:00:00	QQQ	ETF	110.555	110.56	109.96	110.082	3334437.0
2016-06-08 11:00:00	QQQ	ETF	110.081	110.43	110.01	110.31	2217480.0
2016-06-08 12:00:00	QQQ	ETF	110.32	110.49	110.3	110.4101	788235.0
2016-06-08 13:00:00	QQQ	ETF	110.42	110.48	110.28	110.33	907020.0
2016-06-08 14:00:00	QQQ	ETF	110.33	110.53	110.25	110.46	1377660.0
2016-06-08 15:00:00	QQQ	ETF	110.46	110.509	110.3	110.36	2266835.0
2016-06-08 16:00:00	QQQ	ETF	110.34	110.39	110.3	110.31	278905.0
2016-06-08 17:00:00	QQQ	ETF	110.31	110.32	110.31	110.32	11080.0
2016-06-08 18:00:00	QQQ	ETF	110.33	110.33	110.32	110.32	2600.0
2016-06-08 19:00:00	QQQ	ETF	110.3	110.32	110.29	110.31	9740.0
2016-06-08 04:00:00	IWM	ETF	117.49	117.49	117.4	117.4	600.0
2016-06-08 06:00:00	IWM	ETF	117.64	117.64	117.64	117.64	200.0
2016-06-08 07:00:00	IWM	ETF	117.61	117.73	117.6	117.73	32150.0
2016-06-08 08:00:00	IWM	ETF	117.67	117.8	117.67	117.8	213165.0
2016-06-08 09:00:00	IWM	ETF	117.8	117.99	117.63	117.9785	1911069.0
2016-06-08 10:00:00	IWM	ETF	117.98	118.11	117.67	117.92	2946300.0
2016-06-08 11:00:00	IWM	ETF	117.92	118.23	117.65	118.2	2509872.0
2016-06-08 12:00:00	IWM	ETF	118.2	118.475	118.19	118.47	2960835.0
2016-06-08 13:00:00	IWM	ETF	118.47	118.57	118.27	118.32	2188897.0
2016-06-08 14:00:00	IWM	ETF	118.325	118.62	118.21	118.5601	2266202.0
2016-06-08 15:00:00	IWM	ETF	118.56	118.64	118.36	118.45	5299952.0
2016-06-08 16:00:00	IWM	ETF	118.44	118.49	118.33	118.4	912820.0
2016-06-08 17:00:00	IWM	ETF	118.35	118.36	118.31	118.31	519051.0
2016-06-08 18:00:00	IWM	ETF	118.37	118.37	118.36	118.36	900.0
2016-06-08 19:00:00	IWM	ETF	118.32	118.39	118.3	118.36	4600.0
2016-06-08 07:00:00	DIA	ETF	179.66	179.83	179.66	179.73	2778.0
2016-06-08 08:00:00	DIA	ETF	179.67	179.75	179.67	179.75	3193.0
2016-06-08 09:00:00	DIA	ETF	179.8	180.18	179.59	180.08	411291.0
2016-06-08 10:00:00	DIA	ETF	180.09	180.1	179.54	179.73	259976.0
2016-06-08 11:00:00	DIA	ETF	179.74	179.97	179.55	179.881	253834.0

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

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