PREVIEW / etf_1hour / 2014-12-09

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-09.parquet
  size:    240 KB
  rows:    7,586

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-12-09 04:00:00	SPY	ETF	206.05	206.05	205.77	205.77	39448.0
2014-12-09 05:00:00	SPY	ETF	205.89	206.05	205.75	205.83	18279.0
2014-12-09 06:00:00	SPY	ETF	205.88	205.9	205.69	205.85	142765.0
2014-12-09 07:00:00	SPY	ETF	205.75	205.83	204.8	205.03	952591.0
2014-12-09 08:00:00	SPY	ETF	205.04	205.83	204.4	204.78	2306639.0
2014-12-09 09:00:00	SPY	ETF	204.79	205.05	204.1	205.04	20076051.0
2014-12-09 10:00:00	SPY	ETF	205.04	205.18	203.91	204.68	26643913.0
2014-12-09 11:00:00	SPY	ETF	204.685	205.12	204.45	204.86	12233778.0
2014-12-09 12:00:00	SPY	ETF	204.86	205.63	204.665	205.63	11295399.0
2014-12-09 13:00:00	SPY	ETF	205.62	206.32	205.46	205.99	12199850.0
2014-12-09 14:00:00	SPY	ETF	205.99	206.23	205.66	205.9899	9570171.0
2014-12-09 15:00:00	SPY	ETF	205.98	206.6	205.95	206.46	21807908.0
2014-12-09 16:00:00	SPY	ETF	206.47	206.49	205.0	206.37	4716369.0
2014-12-09 17:00:00	SPY	ETF	206.36	206.47	206.3	206.32	64351.0
2014-12-09 18:00:00	SPY	ETF	206.35	206.51	206.32	206.36	52073.0
2014-12-09 19:00:00	SPY	ETF	206.37	206.4	206.31	206.34	73270.0
2014-12-09 04:00:00	QQQ	ETF	104.2	104.3	104.19	104.19	3977.0
2014-12-09 05:00:00	QQQ	ETF	104.14	104.3	104.14	104.16	3138.0
2014-12-09 06:00:00	QQQ	ETF	104.2	104.2	104.12	104.2	15588.0
2014-12-09 07:00:00	QQQ	ETF	104.17	104.18	103.67	103.79	188943.0
2014-12-09 08:00:00	QQQ	ETF	103.79	104.01	103.44	103.63	607700.0
2014-12-09 09:00:00	QQQ	ETF	103.64	104.63	103.145	103.64	8260032.0
2014-12-09 10:00:00	QQQ	ETF	103.641	103.73	103.0401	103.58	8496125.0
2014-12-09 11:00:00	QQQ	ETF	103.58	104.03	103.45	103.91	4766242.0
2014-12-09 12:00:00	QQQ	ETF	103.915	104.48	103.81	104.48	3395352.0
2014-12-09 13:00:00	QQQ	ETF	104.47	104.92	104.42	104.79	5391456.0
2014-12-09 14:00:00	QQQ	ETF	104.79	104.89	104.5	104.66	3135704.0
2014-12-09 15:00:00	QQQ	ETF	104.66	105.04	104.66	104.98	5429750.0
2014-12-09 16:00:00	QQQ	ETF	104.98	105.0264	104.453	104.91	2011076.0
2014-12-09 17:00:00	QQQ	ETF	104.91	104.91	104.81	104.88	21561.0
2014-12-09 18:00:00	QQQ	ETF	104.88	104.88	104.84	104.88	8382.0
2014-12-09 19:00:00	QQQ	ETF	104.91	104.91	104.88	104.9	14800.0
2014-12-09 04:00:00	IWM	ETF	116.0	116.0	115.95	115.95	400.0
2014-12-09 06:00:00	IWM	ETF	115.8	115.8	115.75	115.75	3500.0
2014-12-09 07:00:00	IWM	ETF	115.65	115.69	115.16	115.19	32490.0
2014-12-09 08:00:00	IWM	ETF	115.25	115.41	114.93	115.1	277852.0
2014-12-09 09:00:00	IWM	ETF	115.1	115.57	114.74	115.55	6567612.0
2014-12-09 10:00:00	IWM	ETF	115.53	116.02	115.06	115.87	8583242.0
2014-12-09 11:00:00	IWM	ETF	115.87	116.36	115.68	116.24	4905846.0
2014-12-09 12:00:00	IWM	ETF	116.25	116.91	116.06	116.85	3588778.0
2014-12-09 13:00:00	IWM	ETF	116.85	117.91	116.751	117.7	6133454.0
2014-12-09 14:00:00	IWM	ETF	117.7	117.94	117.6	117.92	4168781.0
2014-12-09 15:00:00	IWM	ETF	117.92	118.27	117.82	118.2	6733714.0
2014-12-09 16:00:00	IWM	ETF	118.19	118.21	117.9	117.96	1582504.0
2014-12-09 17:00:00	IWM	ETF	117.93	117.93	117.85	117.9	8148.0
2014-12-09 18:00:00	IWM	ETF	117.92	117.92	117.91	117.91	622.0
2014-12-09 19:00:00	IWM	ETF	117.95	118.17	117.95	118.17	1379.0
2014-12-09 07:00:00	DIA	ETF	177.75	177.75	177.15	177.2	12100.0
2014-12-09 08:00:00	DIA	ETF	177.52	177.55	176.85	177.12	119099.0
2014-12-09 09:00:00	DIA	ETF	177.12	177.15	176.57	177.14	1417751.0

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

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