PREVIEW / etf_1hour / 2016-07-06

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-06.parquet
  size:    259 KB
  rows:    8,295

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-07-06 04:00:00	SPY	ETF	208.17	208.33	207.6	207.76	50464.0
2016-07-06 05:00:00	SPY	ETF	207.78	207.92	207.25	207.91	105317.0
2016-07-06 06:00:00	SPY	ETF	207.86	207.88	207.2	207.33	271400.0
2016-07-06 07:00:00	SPY	ETF	207.35	207.78	207.15	207.45	474360.0
2016-07-06 08:00:00	SPY	ETF	207.47	208.11	207.22	207.58	927118.0
2016-07-06 09:00:00	SPY	ETF	207.61	208.05	207.27	207.68	12253945.0
2016-07-06 10:00:00	SPY	ETF	207.69	208.32	207.06	208.1201	18916933.0
2016-07-06 11:00:00	SPY	ETF	208.13	208.78	208.13	208.72	14605251.0
2016-07-06 12:00:00	SPY	ETF	208.73	209.31	208.72	209.3	8356123.0
2016-07-06 13:00:00	SPY	ETF	209.3	209.45	208.93	209.07	6152877.0
2016-07-06 14:00:00	SPY	ETF	209.07	209.62	208.73	209.58	11509664.0
2016-07-06 15:00:00	SPY	ETF	209.5899	209.8	209.15	209.75	15850631.0
2016-07-06 16:00:00	SPY	ETF	209.74	209.88	208.5654	209.72	4779037.0
2016-07-06 17:00:00	SPY	ETF	209.73	209.78	209.66	209.72	642778.0
2016-07-06 18:00:00	SPY	ETF	209.72	209.72	209.33	209.45	165686.0
2016-07-06 19:00:00	SPY	ETF	209.49	209.7	209.42	209.67	40053.0
2016-07-06 04:00:00	QQQ	ETF	107.1	107.15	106.86	106.86	642.0
2016-07-06 05:00:00	QQQ	ETF	106.91	106.91	106.91	106.91	100.0
2016-07-06 06:00:00	QQQ	ETF	106.7	106.7	106.56	106.56	2245.0
2016-07-06 07:00:00	QQQ	ETF	106.61	106.8	106.61	106.69	167855.0
2016-07-06 08:00:00	QQQ	ETF	106.72	106.81	106.56	106.79	152088.0
2016-07-06 09:00:00	QQQ	ETF	106.82	107.09	106.57	107.03	2619323.0
2016-07-06 10:00:00	QQQ	ETF	107.03	107.57	106.809	107.57	4465820.0
2016-07-06 11:00:00	QQQ	ETF	107.579	107.98	107.56	107.85	3605830.0
2016-07-06 12:00:00	QQQ	ETF	107.85	108.22	107.85	108.18	4032107.0
2016-07-06 13:00:00	QQQ	ETF	108.185	108.27	107.92	107.94	1216911.0
2016-07-06 14:00:00	QQQ	ETF	107.945	108.2999	107.76	108.25	2215481.0
2016-07-06 15:00:00	QQQ	ETF	108.25	108.35	107.95	108.3	3915859.0
2016-07-06 16:00:00	QQQ	ETF	108.3	108.35	108.2	108.25	849695.0
2016-07-06 17:00:00	QQQ	ETF	108.33	108.35	108.29	108.29	20350.0
2016-07-06 18:00:00	QQQ	ETF	108.28	108.28	108.06	108.15	34987.0
2016-07-06 19:00:00	QQQ	ETF	108.14	108.24	108.11	108.22	7823.0
2016-07-06 04:00:00	IWM	ETF	113.0	113.09	112.44	112.44	600.0
2016-07-06 05:00:00	IWM	ETF	112.5	112.52	112.35	112.52	9179.0
2016-07-06 06:00:00	IWM	ETF	112.5	112.5	112.18	112.29	8816.0
2016-07-06 07:00:00	IWM	ETF	112.18	112.47	112.18	112.23	174757.0
2016-07-06 08:00:00	IWM	ETF	112.27	112.44	112.24	112.38	147756.0
2016-07-06 09:00:00	IWM	ETF	112.39	113.09	112.31	113.01	3396139.0
2016-07-06 10:00:00	IWM	ETF	113.02	113.4675	112.55	113.31	4028013.0
2016-07-06 11:00:00	IWM	ETF	113.31	113.8	113.13	113.34	2642545.0
2016-07-06 12:00:00	IWM	ETF	113.34	113.96	113.32	113.7997	2807231.0
2016-07-06 13:00:00	IWM	ETF	113.795	114.01	113.7	113.77	2158515.0
2016-07-06 14:00:00	IWM	ETF	113.7585	113.94	113.51	113.87	1540873.0
2016-07-06 15:00:00	IWM	ETF	113.885	114.01	113.61	113.96	3625653.0
2016-07-06 16:00:00	IWM	ETF	113.97	114.0	113.77	113.87	1100542.0
2016-07-06 17:00:00	IWM	ETF	113.87	113.89	113.8	113.8	3852.0
2016-07-06 18:00:00	IWM	ETF	113.72	113.72	113.71	113.71	600.0
2016-07-06 19:00:00	IWM	ETF	113.79	113.8	113.79	113.8	918.0
2016-07-06 05:00:00	DIA	ETF	177.74	177.74	177.64	177.64	5144.0
2016-07-06 06:00:00	DIA	ETF	177.46	177.46	177.4	177.4	12000.0

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

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