PREVIEW / etf_1hour / 2015-11-19

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-11-19.parquet
  size:    242 KB
  rows:    7,698

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
2015-11-19 04:00:00	SPY	ETF	209.04	209.4	209.04	209.4	13067.0
2015-11-19 05:00:00	SPY	ETF	209.42	209.46	209.32	209.4	21678.0
2015-11-19 06:00:00	SPY	ETF	209.37	209.6	209.35	209.37	78053.0
2015-11-19 07:00:00	SPY	ETF	209.36	209.46	209.04	209.11	307384.0
2015-11-19 08:00:00	SPY	ETF	209.08	209.42	208.79	208.85	866849.0
2015-11-19 09:00:00	SPY	ETF	208.85	209.05	208.39	208.88	14436961.0
2015-11-19 10:00:00	SPY	ETF	208.87	209.0499	208.31	208.59	17107113.0
2015-11-19 11:00:00	SPY	ETF	208.59	208.91	208.2	208.33	9737062.0
2015-11-19 12:00:00	SPY	ETF	208.33	208.91	208.3	208.87	7060604.0
2015-11-19 13:00:00	SPY	ETF	208.87	209.0	208.65	208.67	6622469.0
2015-11-19 14:00:00	SPY	ETF	208.67	208.77	208.4	208.62	5751483.0
2015-11-19 15:00:00	SPY	ETF	208.63	208.82	208.37	208.53	15438200.0
2015-11-19 16:00:00	SPY	ETF	208.53	208.69	208.4793	208.61	5016943.0
2015-11-19 17:00:00	SPY	ETF	208.61	208.63	208.5	208.5	4548020.0
2015-11-19 18:00:00	SPY	ETF	208.51	208.54	208.29	208.39	245952.0
2015-11-19 19:00:00	SPY	ETF	208.38	208.41	208.29	208.41	75570.0
2015-11-19 04:00:00	QQQ	ETF	113.8	114.04	113.8	114.04	13500.0
2015-11-19 05:00:00	QQQ	ETF	114.05	114.05	114.05	114.05	200.0
2015-11-19 06:00:00	QQQ	ETF	114.05	114.13	114.02	114.02	6000.0
2015-11-19 07:00:00	QQQ	ETF	114.03	114.07	113.97	113.98	29040.0
2015-11-19 08:00:00	QQQ	ETF	114.03	114.03	113.74	113.78	202646.0
2015-11-19 09:00:00	QQQ	ETF	113.78	113.92	113.49	113.8375	4028159.0
2015-11-19 10:00:00	QQQ	ETF	113.84	113.97	113.54	113.781	4593934.0
2015-11-19 11:00:00	QQQ	ETF	113.78	114.04	113.6288	113.77	3168675.0
2015-11-19 12:00:00	QQQ	ETF	113.77	114.135	113.76	114.12	2308346.0
2015-11-19 13:00:00	QQQ	ETF	114.12	114.23	113.96	113.98	2099768.0
2015-11-19 14:00:00	QQQ	ETF	113.98	113.9957	113.6288	113.77	2469122.0
2015-11-19 15:00:00	QQQ	ETF	113.78	113.94	113.62	113.68	3098787.0
2015-11-19 16:00:00	QQQ	ETF	113.68	113.86	113.68	113.81	562311.0
2015-11-19 17:00:00	QQQ	ETF	113.82	113.83	113.73	113.73	10800.0
2015-11-19 18:00:00	QQQ	ETF	113.75	113.75	113.64	113.71	19940.0
2015-11-19 19:00:00	QQQ	ETF	113.63	113.69	113.62	113.67	12396.0
2015-11-19 04:00:00	IWM	ETF	116.69	116.85	116.69	116.85	300.0
2015-11-19 06:00:00	IWM	ETF	116.95	116.97	116.89	116.89	1500.0
2015-11-19 07:00:00	IWM	ETF	116.84	116.85	116.68	116.71	64360.0
2015-11-19 08:00:00	IWM	ETF	116.7	116.77	116.47	116.47	55301.0
2015-11-19 09:00:00	IWM	ETF	116.5	116.65	116.08	116.36	2611497.0
2015-11-19 10:00:00	IWM	ETF	116.36	116.4	115.86	116.35	4694770.0
2015-11-19 11:00:00	IWM	ETF	116.34	116.48	115.81	115.95	2616000.0
2015-11-19 12:00:00	IWM	ETF	115.96	116.12	115.81	116.0872	2703064.0
2015-11-19 13:00:00	IWM	ETF	116.1	116.21	115.76	115.86	1796470.0
2015-11-19 14:00:00	IWM	ETF	115.86	116.05	115.74	115.87	1809093.0
2015-11-19 15:00:00	IWM	ETF	115.87	116.17	115.77	116.02	4127121.0
2015-11-19 16:00:00	IWM	ETF	116.03	116.09	115.93	115.95	2353975.0
2015-11-19 17:00:00	IWM	ETF	115.93	116.02	115.93	116.02	1500.0
2015-11-19 18:00:00	IWM	ETF	116.0	116.0	115.82	115.82	7624.0
2015-11-19 19:00:00	IWM	ETF	115.82	115.82	115.81	115.81	400.0
2015-11-19 06:00:00	DIA	ETF	178.25	178.25	178.06	178.06	200.0
2015-11-19 07:00:00	DIA	ETF	177.97	177.97	177.73	177.77	1800.0
2015-11-19 08:00:00	DIA	ETF	177.71	177.84	177.5	177.5	5338.0

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

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