PREVIEW / etf_1hour / 2016-06-03

all etf 1-hour files

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

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-03 04:00:00	SPY	ETF	210.86	210.96	210.75	210.92	17043.0
2016-06-03 05:00:00	SPY	ETF	210.93	210.93	210.85	210.85	10796.0
2016-06-03 06:00:00	SPY	ETF	210.92	210.95	210.9	210.91	8011.0
2016-06-03 07:00:00	SPY	ETF	210.93	211.11	210.93	211.11	40191.0
2016-06-03 08:00:00	SPY	ETF	211.08	211.1	209.66	210.04	4227317.0
2016-06-03 09:00:00	SPY	ETF	210.04	210.37	209.41	209.63	13626887.0
2016-06-03 10:00:00	SPY	ETF	209.63	209.73	208.86	209.68	22310223.0
2016-06-03 11:00:00	SPY	ETF	209.69	210.22	209.36	210.15	12467428.0
2016-06-03 12:00:00	SPY	ETF	210.155	210.23	209.73	209.76	7319674.0
2016-06-03 13:00:00	SPY	ETF	209.76	210.16	209.72	210.125	6597561.0
2016-06-03 14:00:00	SPY	ETF	210.13	210.69	209.94	210.4915	11365319.0
2016-06-03 15:00:00	SPY	ETF	210.495	210.6	210.18	210.3	17161758.0
2016-06-03 16:00:00	SPY	ETF	210.29	210.4	210.22	210.32	4672762.0
2016-06-03 17:00:00	SPY	ETF	210.29	210.31	210.16	210.23	189695.0
2016-06-03 18:00:00	SPY	ETF	210.25	210.27	210.18	210.22	27948.0
2016-06-03 19:00:00	SPY	ETF	210.23	210.25	210.2	210.22	21295.0
2016-06-03 04:00:00	QQQ	ETF	110.5	110.5	110.5	110.5	500.0
2016-06-03 05:00:00	QQQ	ETF	110.57	110.57	110.55	110.55	600.0
2016-06-03 07:00:00	QQQ	ETF	110.6	110.63	110.58	110.63	9860.0
2016-06-03 08:00:00	QQQ	ETF	110.61	110.64	110.04	110.19	498152.0
2016-06-03 09:00:00	QQQ	ETF	110.15	110.42	109.79	109.8695	3875195.0
2016-06-03 10:00:00	QQQ	ETF	109.86	109.95	109.34	109.87	4936249.0
2016-06-03 11:00:00	QQQ	ETF	109.88	110.12	109.69	110.09	2013343.0
2016-06-03 12:00:00	QQQ	ETF	110.09	110.15	109.84	109.84	1556411.0
2016-06-03 13:00:00	QQQ	ETF	109.84	110.08	109.83	110.02	1333841.0
2016-06-03 14:00:00	QQQ	ETF	110.02	110.3	109.87	110.2	1941401.0
2016-06-03 15:00:00	QQQ	ETF	110.19	110.22	110.03	110.06	2421513.0
2016-06-03 16:00:00	QQQ	ETF	110.06	110.09	110.01	110.06	541863.0
2016-06-03 17:00:00	QQQ	ETF	110.05	110.06	109.99	110.06	2670.0
2016-06-03 18:00:00	QQQ	ETF	110.03	110.03	110.03	110.03	1696.0
2016-06-03 19:00:00	QQQ	ETF	109.96	110.03	109.96	110.03	5039.0
2016-06-03 07:00:00	IWM	ETF	116.85	116.91	116.84	116.91	900.0
2016-06-03 08:00:00	IWM	ETF	116.84	116.89	116.08	116.21	738178.0
2016-06-03 09:00:00	IWM	ETF	116.17	116.47	115.41	115.56	4424876.0
2016-06-03 10:00:00	IWM	ETF	115.56	115.64	115.0	115.54	6037277.0
2016-06-03 11:00:00	IWM	ETF	115.54	115.775	115.125	115.73	3007804.0
2016-06-03 12:00:00	IWM	ETF	115.74	115.8505	115.46	115.51	2173884.0
2016-06-03 13:00:00	IWM	ETF	115.51	115.925	115.49	115.9	1456899.0
2016-06-03 14:00:00	IWM	ETF	115.9	116.24	115.74	116.12	2557083.0
2016-06-03 15:00:00	IWM	ETF	116.11	116.11	115.875	115.95	4138216.0
2016-06-03 16:00:00	IWM	ETF	115.96	115.99	115.79	115.81	1247567.0
2016-06-03 17:00:00	IWM	ETF	115.8	115.82	115.78	115.8	3203.0
2016-06-03 19:00:00	IWM	ETF	115.8	115.8	115.8	115.8	1500.0
2016-06-03 08:00:00	DIA	ETF	178.49	178.49	177.57	177.69	25360.0
2016-06-03 09:00:00	DIA	ETF	177.69	177.98	177.13	177.335	1055497.0
2016-06-03 10:00:00	DIA	ETF	177.3	177.65	176.835	177.61	784855.0
2016-06-03 11:00:00	DIA	ETF	177.61	178.1	177.31	178.0399	450703.0
2016-06-03 12:00:00	DIA	ETF	178.03	178.04	177.6	177.61	267651.0
2016-06-03 13:00:00	DIA	ETF	177.61	177.91	177.54	177.9	196724.0
2016-06-03 14:00:00	DIA	ETF	177.89	178.28	177.74	178.13	287483.0

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

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