PREVIEW / etf_1hour / 2014-11-19

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-11-19.parquet
  size:    230 KB
  rows:    7,299

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-11-19 04:00:00	SPY	ETF	205.07	205.15	205.07	205.15	3864.0
2014-11-19 05:00:00	SPY	ETF	205.15	205.23	205.15	205.18	15300.0
2014-11-19 06:00:00	SPY	ETF	205.15	205.32	205.15	205.25	25701.0
2014-11-19 07:00:00	SPY	ETF	205.23	205.44	205.15	205.18	133256.0
2014-11-19 08:00:00	SPY	ETF	205.19	205.55	205.04	205.14	578616.0
2014-11-19 09:00:00	SPY	ETF	205.16	205.32	204.71	204.89	12817429.0
2014-11-19 10:00:00	SPY	ETF	204.88	204.89	204.39	204.47	13556739.0
2014-11-19 11:00:00	SPY	ETF	204.47	204.96	204.3	204.86	8578332.0
2014-11-19 12:00:00	SPY	ETF	204.87	205.12	204.83	205.11	4898788.0
2014-11-19 13:00:00	SPY	ETF	205.1101	205.18	204.98	205.055	3886379.0
2014-11-19 14:00:00	SPY	ETF	205.05	205.55	204.68	204.94	14148110.0
2014-11-19 15:00:00	SPY	ETF	204.945	205.31	204.82	205.19	17729589.0
2014-11-19 16:00:00	SPY	ETF	205.2	205.37	205.1	205.23	3636777.0
2014-11-19 17:00:00	SPY	ETF	205.24	205.24	205.17	205.22	63488.0
2014-11-19 18:00:00	SPY	ETF	205.2	205.26	205.11	205.26	63069.0
2014-11-19 19:00:00	SPY	ETF	205.27	205.31	205.18	205.2	76826.0
2014-11-19 05:00:00	QQQ	ETF	103.54	103.54	103.54	103.54	300.0
2014-11-19 06:00:00	QQQ	ETF	103.54	103.57	103.54	103.57	1200.0
2014-11-19 07:00:00	QQQ	ETF	103.6	103.66	103.51	103.51	15100.0
2014-11-19 08:00:00	QQQ	ETF	103.53	103.68	103.47	103.51	64004.0
2014-11-19 09:00:00	QQQ	ETF	103.53	103.58	103.01	103.085	4012802.0
2014-11-19 10:00:00	QQQ	ETF	103.08	103.1001	102.83	102.85	4258570.0
2014-11-19 11:00:00	QQQ	ETF	102.86	103.13	102.73	103.08	2982589.0
2014-11-19 12:00:00	QQQ	ETF	103.09	103.3	103.09	103.291	1113892.0
2014-11-19 13:00:00	QQQ	ETF	103.3	103.3698	103.22	103.221	1068008.0
2014-11-19 14:00:00	QQQ	ETF	103.23	103.51	103.0	103.18	3984881.0
2014-11-19 15:00:00	QQQ	ETF	103.17	103.31	103.05	103.21	3381277.0
2014-11-19 16:00:00	QQQ	ETF	103.21	103.664	103.146	103.25	1904011.0
2014-11-19 17:00:00	QQQ	ETF	103.24	103.24	103.18	103.2	85915.0
2014-11-19 18:00:00	QQQ	ETF	103.2	103.28	103.18	103.27	6936.0
2014-11-19 19:00:00	QQQ	ETF	103.27	103.27	103.21	103.21	47366.0
2014-11-19 06:00:00	IWM	ETF	116.06	116.24	116.0	116.24	3050.0
2014-11-19 07:00:00	IWM	ETF	116.2	116.24	116.01	116.01	3050.0
2014-11-19 08:00:00	IWM	ETF	116.07	116.12	115.95	116.09	73579.0
2014-11-19 09:00:00	IWM	ETF	116.1	116.28	115.04	115.45	5820838.0
2014-11-19 10:00:00	IWM	ETF	115.45	115.52	114.59	114.59	7309653.0
2014-11-19 11:00:00	IWM	ETF	114.59	115.19	114.37	115.18	4834409.0
2014-11-19 12:00:00	IWM	ETF	115.18	115.69	115.18	115.68	2101531.0
2014-11-19 13:00:00	IWM	ETF	115.69	115.87	115.48	115.5799	1550630.0
2014-11-19 14:00:00	IWM	ETF	115.57	115.89	115.1	115.28	4629467.0
2014-11-19 15:00:00	IWM	ETF	115.29	115.47	114.975	115.16	4180413.0
2014-11-19 16:00:00	IWM	ETF	115.17	115.34	115.12	115.3	2205444.0
2014-11-19 17:00:00	IWM	ETF	115.35	115.35	115.27	115.31	36702.0
2014-11-19 18:00:00	IWM	ETF	115.27	115.27	115.22	115.22	1933.0
2014-11-19 19:00:00	IWM	ETF	115.32	115.32	115.16	115.16	1940.0
2014-11-19 09:00:00	DIA	ETF	176.8	176.88	176.44	176.63	778715.0
2014-11-19 10:00:00	DIA	ETF	176.64	176.65	176.29	176.42	645410.0
2014-11-19 11:00:00	DIA	ETF	176.41	176.8	176.31	176.78	354889.0
2014-11-19 12:00:00	DIA	ETF	176.79	176.9	176.73	176.9	233394.0
2014-11-19 13:00:00	DIA	ETF	176.9	176.9	176.7732	176.8	157797.0

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

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