PREVIEW / etf_1hour / 2016-11-03

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-03.parquet
  size:    260 KB
  rows:    8,350

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-11-03 04:00:00	SPY	ETF	209.23	209.6	209.12	209.48	79727.0
2016-11-03 05:00:00	SPY	ETF	209.5	209.75	209.4	209.75	45649.0
2016-11-03 06:00:00	SPY	ETF	209.75	210.1	209.56	209.76	70114.0
2016-11-03 07:00:00	SPY	ETF	209.75	210.34	209.7	210.13	575722.0
2016-11-03 08:00:00	SPY	ETF	210.13	210.35	209.152	210.24	1162247.0
2016-11-03 09:00:00	SPY	ETF	210.24	210.24	209.8	209.86	9347405.0
2016-11-03 10:00:00	SPY	ETF	209.855	210.22	209.64	209.915	12431778.0
2016-11-03 11:00:00	SPY	ETF	209.92	210.11	209.76	209.84	6770689.0
2016-11-03 12:00:00	SPY	ETF	209.83	209.8707	209.04	209.29	9984252.0
2016-11-03 13:00:00	SPY	ETF	209.3	209.51	209.1	209.17	6453160.0
2016-11-03 14:00:00	SPY	ETF	209.18	209.485	209.01	209.29	9350422.0
2016-11-03 15:00:00	SPY	ETF	209.285	209.29	208.46	208.84	26309015.0
2016-11-03 16:00:00	SPY	ETF	208.82	209.15	208.68	208.8	4153545.0
2016-11-03 17:00:00	SPY	ETF	208.81	208.87	208.66	208.87	160967.0
2016-11-03 18:00:00	SPY	ETF	208.88	208.96	208.87	208.94	134751.0
2016-11-03 19:00:00	SPY	ETF	208.92	209.09	208.91	208.96	36677.0
2016-11-03 04:00:00	QQQ	ETF	114.67	114.7	114.55	114.7	4148.0
2016-11-03 05:00:00	QQQ	ETF	114.7	114.72	114.68	114.68	1223.0
2016-11-03 06:00:00	QQQ	ETF	114.96	114.96	114.71	114.76	11227.0
2016-11-03 07:00:00	QQQ	ETF	114.93	115.13	114.89	115.08	88867.0
2016-11-03 08:00:00	QQQ	ETF	115.09	115.21	115.02	115.16	119431.0
2016-11-03 09:00:00	QQQ	ETF	115.14	115.37	114.85	114.86	2467365.0
2016-11-03 10:00:00	QQQ	ETF	114.86	115.18	114.77	114.8855	4120624.0
2016-11-03 11:00:00	QQQ	ETF	114.89	115.06	114.7774	114.859	1348316.0
2016-11-03 12:00:00	QQQ	ETF	114.851	114.875	114.34	114.5	2237541.0
2016-11-03 13:00:00	QQQ	ETF	114.5	114.585	114.28	114.32	2441129.0
2016-11-03 14:00:00	QQQ	ETF	114.32	114.46	114.14	114.33	3097203.0
2016-11-03 15:00:00	QQQ	ETF	114.32	114.3201	113.92	114.06	4195630.0
2016-11-03 16:00:00	QQQ	ETF	114.04	114.07	113.89	113.94	416841.0
2016-11-03 17:00:00	QQQ	ETF	114.05	114.05	113.91	113.98	52546.0
2016-11-03 18:00:00	QQQ	ETF	113.99	114.04	113.95	114.0	29834.0
2016-11-03 19:00:00	QQQ	ETF	113.98	114.16	113.98	114.11	12838.0
2016-11-03 04:00:00	IWM	ETF	115.25	115.53	115.25	115.53	4213.0
2016-11-03 05:00:00	IWM	ETF	115.5	115.6	115.49	115.54	1950.0
2016-11-03 06:00:00	IWM	ETF	115.99	115.99	115.7	115.8	17495.0
2016-11-03 07:00:00	IWM	ETF	115.75	116.1	115.73	116.0	176273.0
2016-11-03 08:00:00	IWM	ETF	116.1	116.15	115.9181	116.09	161064.0
2016-11-03 09:00:00	IWM	ETF	116.1	116.24	115.82	115.9	2660294.0
2016-11-03 10:00:00	IWM	ETF	115.9	116.09	115.67	115.74	2585165.0
2016-11-03 11:00:00	IWM	ETF	115.73	116.0	115.67	115.78	1993903.0
2016-11-03 12:00:00	IWM	ETF	115.76	115.835	115.25	115.43	2689533.0
2016-11-03 13:00:00	IWM	ETF	115.43	115.635	115.32	115.595	2043590.0
2016-11-03 14:00:00	IWM	ETF	115.6	115.75	115.43	115.62	1922569.0
2016-11-03 15:00:00	IWM	ETF	115.615	115.615	114.88	115.0	5499783.0
2016-11-03 16:00:00	IWM	ETF	114.98	115.6126	114.88	115.1	816247.0
2016-11-03 17:00:00	IWM	ETF	115.0	115.1	115.0	115.05	108870.0
2016-11-03 18:00:00	IWM	ETF	115.14	115.14	115.12	115.12	200.0
2016-11-03 19:00:00	IWM	ETF	115.18	115.19	115.13	115.18	1705.0
2016-11-03 06:00:00	DIA	ETF	179.57	179.57	179.5	179.5	800.0
2016-11-03 07:00:00	DIA	ETF	179.82	179.97	179.82	179.97	500.0

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

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