PREVIEW / etf_1hour / 2014-07-01

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-07-01.parquet
  size:    221 KB
  rows:    7,015

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
2014-07-01 04:00:00	SPY	ETF	196.08	196.17	196.05	196.17	29775.0
2014-07-01 05:00:00	SPY	ETF	196.14	196.16	196.05	196.13	3622.0
2014-07-01 06:00:00	SPY	ETF	196.13	196.25	196.13	196.15	11501.0
2014-07-01 07:00:00	SPY	ETF	196.16	196.25	196.12	196.15	187601.0
2014-07-01 08:00:00	SPY	ETF	196.15	196.31	196.01	196.26	753795.0
2014-07-01 09:00:00	SPY	ETF	196.24	196.62	195.72	196.56	11319375.0
2014-07-01 10:00:00	SPY	ETF	196.56	197.02	196.38	196.925	16687806.0
2014-07-01 11:00:00	SPY	ETF	196.93	197.23	196.9	197.07	10156715.0
2014-07-01 12:00:00	SPY	ETF	197.075	197.345	197.03	197.3	6777943.0
2014-07-01 13:00:00	SPY	ETF	197.295	197.63	197.282	197.465	10327222.0
2014-07-01 14:00:00	SPY	ETF	197.465	197.49	197.2	197.31	8842911.0
2014-07-01 15:00:00	SPY	ETF	197.305	197.4	197.03	197.06	18635978.0
2014-07-01 16:00:00	SPY	ETF	197.06	197.36	195.7785	197.07	4974317.0
2014-07-01 17:00:00	SPY	ETF	197.08	197.08	197.02	197.05	55500.0
2014-07-01 18:00:00	SPY	ETF	197.06	197.14	197.04	197.07	55356.0
2014-07-01 19:00:00	SPY	ETF	197.09	197.12	197.07	197.11	81820.0
2014-07-01 05:00:00	QQQ	ETF	94.14	94.14	94.14	94.14	100.0
2014-07-01 06:00:00	QQQ	ETF	94.15	94.16	94.15	94.16	10600.0
2014-07-01 07:00:00	QQQ	ETF	94.15	94.19	94.12	94.16	45448.0
2014-07-01 08:00:00	QQQ	ETF	94.16	94.22	94.13	94.2	166897.0
2014-07-01 09:00:00	QQQ	ETF	94.2	94.54	93.91	94.51	3868977.0
2014-07-01 10:00:00	QQQ	ETF	94.5	94.9	94.46	94.8499	5603767.0
2014-07-01 11:00:00	QQQ	ETF	94.845	95.0	94.81	94.92	4321406.0
2014-07-01 12:00:00	QQQ	ETF	94.92	95.07	94.89	95.055	2947540.0
2014-07-01 13:00:00	QQQ	ETF	95.055	95.19	95.05	95.1258	3235156.0
2014-07-01 14:00:00	QQQ	ETF	95.12	95.135	94.99	95.07	3306322.0
2014-07-01 15:00:00	QQQ	ETF	95.076	95.12	94.93	94.96	5628488.0
2014-07-01 16:00:00	QQQ	ETF	94.96	94.9943	94.625	94.97	1705773.0
2014-07-01 17:00:00	QQQ	ETF	94.97	94.98	94.93	94.98	5710.0
2014-07-01 18:00:00	QQQ	ETF	94.94	95.03	94.94	94.97	24033.0
2014-07-01 19:00:00	QQQ	ETF	94.98	95.0	94.98	94.99	9976.0
2014-07-01 06:00:00	IWM	ETF	119.2	119.35	119.2	119.33	1600.0
2014-07-01 07:00:00	IWM	ETF	119.16	119.35	119.16	119.32	13100.0
2014-07-01 08:00:00	IWM	ETF	119.34	119.44	118.81	119.35	292073.0
2014-07-01 09:00:00	IWM	ETF	119.35	120.09	118.81	120.05	6156480.0
2014-07-01 10:00:00	IWM	ETF	120.05	120.51	119.88	120.25	6138770.0
2014-07-01 11:00:00	IWM	ETF	120.26	120.53	120.2	120.28	3905437.0
2014-07-01 12:00:00	IWM	ETF	120.29	120.54	120.185	120.52	4787681.0
2014-07-01 13:00:00	IWM	ETF	120.52	120.97	120.5	120.735	7023258.0
2014-07-01 14:00:00	IWM	ETF	120.73	120.75	120.07	120.36	5969520.0
2014-07-01 15:00:00	IWM	ETF	120.36	120.46	120.02	120.08	10281091.0
2014-07-01 16:00:00	IWM	ETF	120.06	120.5028	118.8126	120.08	4956130.0
2014-07-01 17:00:00	IWM	ETF	120.08	120.11	120.07	120.11	37064.0
2014-07-01 19:00:00	IWM	ETF	120.1	120.1	120.1	120.1	1000.0
2014-07-01 08:00:00	DIA	ETF	168.19	168.38	168.19	168.36	8922.0
2014-07-01 09:00:00	DIA	ETF	168.34	169.03	167.89	168.89	1098104.0
2014-07-01 10:00:00	DIA	ETF	168.88	169.19	168.72	169.0999	819337.0
2014-07-01 11:00:00	DIA	ETF	169.11	169.33	169.07	169.19	757915.0
2014-07-01 12:00:00	DIA	ETF	169.19	169.41	169.17	169.33	306094.0
2014-07-01 13:00:00	DIA	ETF	169.33	169.64	169.33	169.52	537303.0

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

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