PREVIEW / etf_1hour / 2015-11-06

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-11-06.parquet
  size:    247 KB
  rows:    7,921

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-06 04:00:00	SPY	ETF	210.0	210.02	209.95	209.97	760.0
2015-11-06 05:00:00	SPY	ETF	209.96	210.01	209.93	210.01	3510.0
2015-11-06 06:00:00	SPY	ETF	209.96	209.99	209.9	209.99	40088.0
2015-11-06 07:00:00	SPY	ETF	209.96	210.32	209.96	210.23	136349.0
2015-11-06 08:00:00	SPY	ETF	210.26	210.54	208.91	209.25	6557064.0
2015-11-06 09:00:00	SPY	ETF	209.27	210.32	209.03	209.14	16959953.0
2015-11-06 10:00:00	SPY	ETF	209.145	209.86	208.46	209.4301	24958468.0
2015-11-06 11:00:00	SPY	ETF	209.43	209.53	208.83	209.2	9189372.0
2015-11-06 12:00:00	SPY	ETF	209.19	209.45	208.74	209.111	6761233.0
2015-11-06 13:00:00	SPY	ETF	209.11	209.75	209.03	209.67	7772826.0
2015-11-06 14:00:00	SPY	ETF	209.675	210.07	209.16	209.49	12216050.0
2015-11-06 15:00:00	SPY	ETF	209.491	210.07	209.44	210.02	15593497.0
2015-11-06 16:00:00	SPY	ETF	210.02	210.07	209.91	210.01	8307872.0
2015-11-06 17:00:00	SPY	ETF	210.02	210.1	209.99	210.03	1173200.0
2015-11-06 18:00:00	SPY	ETF	210.08	210.12	210.05	210.1	28628.0
2015-11-06 19:00:00	SPY	ETF	210.06	210.12	210.05	210.11	33901.0
2015-11-06 04:00:00	QQQ	ETF	114.71	114.71	114.66	114.69	600.0
2015-11-06 06:00:00	QQQ	ETF	114.69	114.69	114.69	114.69	1226.0
2015-11-06 07:00:00	QQQ	ETF	114.66	114.79	114.66	114.79	7550.0
2015-11-06 08:00:00	QQQ	ETF	114.8265	114.95	114.1	114.26	584414.0
2015-11-06 09:00:00	QQQ	ETF	114.28	114.87	114.16	114.24	5027940.0
2015-11-06 10:00:00	QQQ	ETF	114.24	114.92	113.76	114.694	6158804.0
2015-11-06 11:00:00	QQQ	ETF	114.69	114.75	114.35	114.59	3543035.0
2015-11-06 12:00:00	QQQ	ETF	114.59	114.69	114.21	114.43	1743307.0
2015-11-06 13:00:00	QQQ	ETF	114.44	114.68	114.29	114.64	2068011.0
2015-11-06 14:00:00	QQQ	ETF	114.65	114.81	114.31	114.511	2812991.0
2015-11-06 15:00:00	QQQ	ETF	114.515	114.81	114.49	114.78	4132816.0
2015-11-06 16:00:00	QQQ	ETF	114.79	114.85	114.73	114.81	354726.0
2015-11-06 17:00:00	QQQ	ETF	114.78	114.82	114.77	114.77	690230.0
2015-11-06 18:00:00	QQQ	ETF	114.78	114.88	114.77	114.77	2476.0
2015-11-06 08:00:00	IWM	ETF	118.33	118.57	117.68	117.92	604564.0
2015-11-06 09:00:00	IWM	ETF	117.93	118.4192	117.72	117.85	3509616.0
2015-11-06 10:00:00	IWM	ETF	117.85	118.27	117.29	118.11	4519525.0
2015-11-06 11:00:00	IWM	ETF	118.11	118.72	117.83	118.6032	2989451.0
2015-11-06 12:00:00	IWM	ETF	118.61	118.8	118.41	118.73	2765474.0
2015-11-06 13:00:00	IWM	ETF	118.73	119.12	118.61	118.955	2992315.0
2015-11-06 14:00:00	IWM	ETF	118.95	119.16	118.68	118.92	2819857.0
2015-11-06 15:00:00	IWM	ETF	118.92	119.36	118.88	119.24	5155438.0
2015-11-06 16:00:00	IWM	ETF	119.23	119.45	119.1718	119.42	895356.0
2015-11-06 17:00:00	IWM	ETF	119.42	119.45	119.38	119.42	3600.0
2015-11-06 18:00:00	IWM	ETF	119.36	119.36	119.36	119.36	400.0
2015-11-06 19:00:00	IWM	ETF	119.42	119.42	119.42	119.42	450.0
2015-11-06 07:00:00	DIA	ETF	178.44	178.47	178.44	178.47	3583.0
2015-11-06 08:00:00	DIA	ETF	178.74	178.82	177.75	178.02	56125.0
2015-11-06 09:00:00	DIA	ETF	178.05	179.17	177.95	178.2	894741.0
2015-11-06 10:00:00	DIA	ETF	178.25	178.9	177.71	178.54	1508263.0
2015-11-06 11:00:00	DIA	ETF	178.53	178.6	177.98	178.32	880676.0
2015-11-06 12:00:00	DIA	ETF	178.33	178.53	177.98	178.27	387471.0
2015-11-06 13:00:00	DIA	ETF	178.25	178.86	178.22	178.81	388641.0
2015-11-06 14:00:00	DIA	ETF	178.85	179.12	178.4	178.67	908625.0

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

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