PREVIEW / etf_1hour / 2016-04-26

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-26.parquet
  size:    247 KB
  rows:    7,943

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-04-26 04:00:00	SPY	ETF	209.29	209.43	209.16	209.18	123350.0
2016-04-26 05:00:00	SPY	ETF	209.05	209.34	209.03	209.06	13252.0
2016-04-26 06:00:00	SPY	ETF	209.01	209.1	208.9	208.9	72014.0
2016-04-26 07:00:00	SPY	ETF	208.95	209.2	208.93	209.16	139224.0
2016-04-26 08:00:00	SPY	ETF	209.18	209.27	208.95	209.12	452614.0
2016-04-26 09:00:00	SPY	ETF	209.12	209.46	208.81	209.4492	7139113.0
2016-04-26 10:00:00	SPY	ETF	209.46	209.52	208.465	208.5	13141256.0
2016-04-26 11:00:00	SPY	ETF	208.49	209.01	208.36	208.92	7886196.0
2016-04-26 12:00:00	SPY	ETF	208.91	209.14	208.76	208.8	6869525.0
2016-04-26 13:00:00	SPY	ETF	208.8	208.88	208.5	208.64	8039395.0
2016-04-26 14:00:00	SPY	ETF	208.65	208.93	208.5499	208.67	7101920.0
2016-04-26 15:00:00	SPY	ETF	208.67	209.0	208.39	208.97	14783028.0
2016-04-26 16:00:00	SPY	ETF	208.98	209.33	208.5767	208.83	6816362.0
2016-04-26 17:00:00	SPY	ETF	208.76	208.76	208.48	208.61	628986.0
2016-04-26 18:00:00	SPY	ETF	208.62	208.75	208.48	208.75	222295.0
2016-04-26 19:00:00	SPY	ETF	208.75	208.87	208.73	208.77	54048.0
2016-04-26 04:00:00	QQQ	ETF	109.36	109.36	109.36	109.36	420.0
2016-04-26 05:00:00	QQQ	ETF	109.33	109.33	109.33	109.33	200.0
2016-04-26 07:00:00	QQQ	ETF	109.14	109.26	109.1	109.25	9348.0
2016-04-26 08:00:00	QQQ	ETF	109.22	109.27	109.18	109.26	43193.0
2016-04-26 09:00:00	QQQ	ETF	109.24	109.39	108.97	109.315	2071063.0
2016-04-26 10:00:00	QQQ	ETF	109.32	109.38	108.41	108.47	2864631.0
2016-04-26 11:00:00	QQQ	ETF	108.47	108.7085	108.41	108.63	1550189.0
2016-04-26 12:00:00	QQQ	ETF	108.64	108.79	108.46	108.46	1420600.0
2016-04-26 13:00:00	QQQ	ETF	108.468	108.605	108.35	108.45	961599.0
2016-04-26 14:00:00	QQQ	ETF	108.45	108.5	108.23	108.28	1627246.0
2016-04-26 15:00:00	QQQ	ETF	108.28	108.48	108.12	108.47	3510026.0
2016-04-26 16:00:00	QQQ	ETF	108.47	108.69	107.55	107.57	2305165.0
2016-04-26 17:00:00	QQQ	ETF	107.56	107.65	107.36	107.39	232398.0
2016-04-26 18:00:00	QQQ	ETF	107.41	107.59	107.4	107.55	72252.0
2016-04-26 19:00:00	QQQ	ETF	107.55	107.65	107.54	107.54	66538.0
2016-04-26 04:00:00	IWM	ETF	113.77	113.77	113.73	113.73	500.0
2016-04-26 06:00:00	IWM	ETF	113.6	113.61	113.59	113.61	5000.0
2016-04-26 07:00:00	IWM	ETF	113.58	113.69	113.57	113.67	26741.0
2016-04-26 08:00:00	IWM	ETF	113.67	113.73	113.54	113.65	8313.0
2016-04-26 09:00:00	IWM	ETF	113.64	114.07	113.44	114.05	1914860.0
2016-04-26 10:00:00	IWM	ETF	114.06	114.21	113.28	113.29	3683253.0
2016-04-26 11:00:00	IWM	ETF	113.28	114.25	113.17	114.16	2535096.0
2016-04-26 12:00:00	IWM	ETF	114.16	114.49	114.14	114.21	2422139.0
2016-04-26 13:00:00	IWM	ETF	114.2	114.46	113.96	114.12	1583962.0
2016-04-26 14:00:00	IWM	ETF	114.13	114.46	114.01	114.29	2202234.0
2016-04-26 15:00:00	IWM	ETF	114.29	114.53	114.14	114.42	5594770.0
2016-04-26 16:00:00	IWM	ETF	114.42	114.65	114.32	114.5	3521538.0
2016-04-26 17:00:00	IWM	ETF	114.49	114.51	114.36	114.4	47285.0
2016-04-26 18:00:00	IWM	ETF	114.33	114.4	114.32	114.35	9967.0
2016-04-26 19:00:00	IWM	ETF	114.39	114.48	114.34	114.44	22224.0
2016-04-26 08:00:00	DIA	ETF	180.02	180.02	179.9	180.0	2900.0
2016-04-26 09:00:00	DIA	ETF	179.99	180.22	179.73	180.17	210757.0
2016-04-26 10:00:00	DIA	ETF	180.2	180.26	179.2	179.26	620372.0
2016-04-26 11:00:00	DIA	ETF	179.26	179.567	179.11	179.5475	400694.0

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

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