PREVIEW / etf_1hour / 2016-04-01

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-01.parquet
  size:    254 KB
  rows:    8,073

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-01 04:00:00	SPY	ETF	205.04	205.37	204.75	205.17	25532.0
2016-04-01 05:00:00	SPY	ETF	205.27	205.35	204.82	204.91	74442.0
2016-04-01 06:00:00	SPY	ETF	204.89	205.08	204.57	204.8	73677.0
2016-04-01 07:00:00	SPY	ETF	204.84	204.97	204.61	204.75	410104.0
2016-04-01 08:00:00	SPY	ETF	204.75	205.56	204.29	204.4	2041266.0
2016-04-01 09:00:00	SPY	ETF	204.38	204.55	203.98	204.53	11405040.0
2016-04-01 10:00:00	SPY	ETF	204.53	205.87	204.43	205.8508	18955276.0
2016-04-01 11:00:00	SPY	ETF	205.85	206.16	205.68	205.81	10423960.0
2016-04-01 12:00:00	SPY	ETF	205.8162	205.94	205.5	205.8	6576096.0
2016-04-01 13:00:00	SPY	ETF	205.809	206.48	205.75	206.32	8577035.0
2016-04-01 14:00:00	SPY	ETF	206.32	206.71	206.24	206.56	9018006.0
2016-04-01 15:00:00	SPY	ETF	206.56	207.14	206.54	206.89	26043563.0
2016-04-01 16:00:00	SPY	ETF	206.88	207.0	206.4502	206.87	13320403.0
2016-04-01 17:00:00	SPY	ETF	206.87	206.88	206.75	206.8	1215635.0
2016-04-01 18:00:00	SPY	ETF	206.81	206.86	206.78	206.86	31950.0
2016-04-01 19:00:00	SPY	ETF	206.85	206.86	206.83	206.86	35259.0
2016-04-01 04:00:00	QQQ	ETF	108.81	108.9	108.7	108.9	10692.0
2016-04-01 05:00:00	QQQ	ETF	108.83	108.83	108.76	108.76	300.0
2016-04-01 06:00:00	QQQ	ETF	108.78	108.8	108.66	108.71	5155.0
2016-04-01 07:00:00	QQQ	ETF	108.69	108.81	108.67	108.74	27066.0
2016-04-01 08:00:00	QQQ	ETF	108.78	108.94	108.48	108.54	191635.0
2016-04-01 09:00:00	QQQ	ETF	108.5	108.9	108.39	108.87	3735034.0
2016-04-01 10:00:00	QQQ	ETF	108.87	109.72	108.82	109.71	4242706.0
2016-04-01 11:00:00	QQQ	ETF	109.7	109.96	109.64	109.74	3259878.0
2016-04-01 12:00:00	QQQ	ETF	109.75	109.83	109.53	109.7779	1704805.0
2016-04-01 13:00:00	QQQ	ETF	109.77	110.09	109.75	109.97	2053478.0
2016-04-01 14:00:00	QQQ	ETF	109.98	110.2136	109.93	110.11	2500354.0
2016-04-01 15:00:00	QQQ	ETF	110.12	110.4	110.085	110.35	4774712.0
2016-04-01 16:00:00	QQQ	ETF	110.34	110.5	110.33	110.48	665686.0
2016-04-01 17:00:00	QQQ	ETF	110.5	110.52	110.46	110.46	539218.0
2016-04-01 18:00:00	QQQ	ETF	110.46	110.46	110.44	110.45	790.0
2016-04-01 19:00:00	QQQ	ETF	110.45	110.5	110.44	110.45	8629.0
2016-04-01 04:00:00	IWM	ETF	110.03	110.19	110.03	110.19	200.0
2016-04-01 06:00:00	IWM	ETF	110.04	110.13	109.85	110.04	4198.0
2016-04-01 07:00:00	IWM	ETF	110.05	110.09	109.84	109.93	108297.0
2016-04-01 08:00:00	IWM	ETF	109.99	110.62	109.58	109.63	341116.0
2016-04-01 09:00:00	IWM	ETF	109.6	110.05	109.47	109.85	4633317.0
2016-04-01 10:00:00	IWM	ETF	109.85	110.52	109.68	110.49	6458267.0
2016-04-01 11:00:00	IWM	ETF	110.49	110.78	110.32	110.44	3026425.0
2016-04-01 12:00:00	IWM	ETF	110.44	110.56	110.26	110.46	1514362.0
2016-04-01 13:00:00	IWM	ETF	110.45	110.91	110.395	110.71	2352138.0
2016-04-01 14:00:00	IWM	ETF	110.715	111.09	110.69	110.915	2672384.0
2016-04-01 15:00:00	IWM	ETF	110.92	111.22	110.92	111.12	4371902.0
2016-04-01 16:00:00	IWM	ETF	111.12	111.19	111.01	111.13	776061.0
2016-04-01 17:00:00	IWM	ETF	111.14	111.14	111.02	111.02	96100.0
2016-04-01 19:00:00	IWM	ETF	111.07	111.14	111.07	111.14	1572.0
2016-04-01 07:00:00	DIA	ETF	175.95	176.06	175.95	176.06	200.0
2016-04-01 08:00:00	DIA	ETF	176.11	176.9	175.7	175.7	20920.0
2016-04-01 09:00:00	DIA	ETF	175.65	175.8	175.41	175.79	460963.0
2016-04-01 10:00:00	DIA	ETF	175.79	177.15	175.705	177.07	1189987.0

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

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