PREVIEW / etf_1hour / 2017-03-28

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-28.parquet
  size:    275 KB
  rows:    8,838

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
2017-03-28 04:00:00	SPY	ETF	233.78	233.91	233.78	233.9	4286.0
2017-03-28 05:00:00	SPY	ETF	233.9	233.92	233.87	233.92	500.0
2017-03-28 06:00:00	SPY	ETF	233.88	233.88	233.78	233.79	1433.0
2017-03-28 07:00:00	SPY	ETF	233.76	233.76	233.3	233.42	159322.0
2017-03-28 08:00:00	SPY	ETF	233.42	233.76	233.24	233.32	381229.0
2017-03-28 09:00:00	SPY	ETF	233.32	233.76	233.14	233.3	7301343.0
2017-03-28 10:00:00	SPY	ETF	233.3	234.03	233.29	233.985	12940276.0
2017-03-28 11:00:00	SPY	ETF	233.995	234.91	233.97	234.75	11405491.0
2017-03-28 12:00:00	SPY	ETF	234.75	234.96	234.62	234.805	4975708.0
2017-03-28 13:00:00	SPY	ETF	234.81	235.5	234.8	235.4787	6978396.0
2017-03-28 14:00:00	SPY	ETF	235.48	235.81	235.35	235.46	11899591.0
2017-03-28 15:00:00	SPY	ETF	235.455	235.66	235.23	235.27	20657089.0
2017-03-28 16:00:00	SPY	ETF	235.27	235.45	233.5702	235.0	14478505.0
2017-03-28 17:00:00	SPY	ETF	235.0	235.06	234.95	235.05	78704.0
2017-03-28 18:00:00	SPY	ETF	235.06	235.11	234.98	235.09	59577.0
2017-03-28 19:00:00	SPY	ETF	235.09	235.13	235.02	235.12	35320.0
2017-03-28 04:00:00	QQQ	ETF	131.04	131.13	131.04	131.11	1410.0
2017-03-28 05:00:00	QQQ	ETF	131.09	131.14	131.07	131.14	32300.0
2017-03-28 06:00:00	QQQ	ETF	131.11	131.11	131.06	131.09	2700.0
2017-03-28 07:00:00	QQQ	ETF	131.06	131.06	130.85	130.87	15847.0
2017-03-28 08:00:00	QQQ	ETF	130.87	130.87	130.73	130.77	23688.0
2017-03-28 09:00:00	QQQ	ETF	130.78	131.07	130.55	130.67	1776818.0
2017-03-28 10:00:00	QQQ	ETF	130.6707	131.045	130.59	130.86	2913598.0
2017-03-28 11:00:00	QQQ	ETF	130.85	131.38	130.845	131.3	2365573.0
2017-03-28 12:00:00	QQQ	ETF	131.29	131.45	131.29	131.41	1100681.0
2017-03-28 13:00:00	QQQ	ETF	131.42	131.81	131.4	131.801	1489788.0
2017-03-28 14:00:00	QQQ	ETF	131.8	132.03	131.75	131.8475	3243483.0
2017-03-28 15:00:00	QQQ	ETF	131.85	131.93	131.62	131.65	5567055.0
2017-03-28 16:00:00	QQQ	ETF	131.65	131.8	131.53	131.63	2813632.0
2017-03-28 17:00:00	QQQ	ETF	131.62	131.67	131.58	131.64	2688.0
2017-03-28 18:00:00	QQQ	ETF	131.64	131.69	131.58	131.68	18588.0
2017-03-28 19:00:00	QQQ	ETF	131.66	131.71	131.66	131.71	5464.0
2017-03-28 04:00:00	IWM	ETF	134.81	134.81	134.75	134.75	1016.0
2017-03-28 06:00:00	IWM	ETF	134.78	134.78	134.78	134.78	3000.0
2017-03-28 07:00:00	IWM	ETF	134.63	134.66	134.35	134.45	71038.0
2017-03-28 08:00:00	IWM	ETF	134.44	134.45	134.27	134.35	72039.0
2017-03-28 09:00:00	IWM	ETF	134.36	134.9	134.14	134.19	3125386.0
2017-03-28 10:00:00	IWM	ETF	134.18	134.73	134.14	134.61	2943421.0
2017-03-28 11:00:00	IWM	ETF	134.61	135.23	134.58	135.125	3024148.0
2017-03-28 12:00:00	IWM	ETF	135.12	135.29	134.97	135.25	1085000.0
2017-03-28 13:00:00	IWM	ETF	135.2599	135.56	135.2599	135.53	2213721.0
2017-03-28 14:00:00	IWM	ETF	135.55	135.9	135.44	135.62	3182167.0
2017-03-28 15:00:00	IWM	ETF	135.615	135.87	135.42	135.77	4057863.0
2017-03-28 16:00:00	IWM	ETF	135.77	135.79	135.49	135.57	883291.0
2017-03-28 17:00:00	IWM	ETF	135.58	135.58	135.57	135.57	1217.0
2017-03-28 18:00:00	IWM	ETF	135.64	135.64	135.58	135.58	300.0
2017-03-28 19:00:00	IWM	ETF	135.62	135.68	135.62	135.68	1100.0
2017-03-28 07:00:00	DIA	ETF	205.3	205.3	205.0	205.0	800.0
2017-03-28 08:00:00	DIA	ETF	205.19	205.19	204.95	204.95	1150.0
2017-03-28 09:00:00	DIA	ETF	205.02	205.33	204.91	205.09	269287.0

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

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