PREVIEW / etf_1hour / 2017-06-09

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-09.parquet
  size:    283 KB
  rows:    9,165

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-06-09 04:00:00	SPY	ETF	243.84	244.08	243.8	244.08	11700.0
2017-06-09 05:00:00	SPY	ETF	244.09	244.13	243.99	244.04	11600.0
2017-06-09 06:00:00	SPY	ETF	244.03	244.05	243.84	243.84	40233.0
2017-06-09 07:00:00	SPY	ETF	243.87	244.12	243.8	244.07	149979.0
2017-06-09 08:00:00	SPY	ETF	244.06	244.13	243.8	243.97	229557.0
2017-06-09 09:00:00	SPY	ETF	243.97	244.6	243.91	244.47	7588779.0
2017-06-09 10:00:00	SPY	ETF	244.475	245.01	244.4	244.83	11187022.0
2017-06-09 11:00:00	SPY	ETF	244.835	244.99	244.68	244.69	9200735.0
2017-06-09 12:00:00	SPY	ETF	244.69	244.78	243.95	244.275	10241984.0
2017-06-09 13:00:00	SPY	ETF	244.27	244.39	243.28	243.285	15069101.0
2017-06-09 14:00:00	SPY	ETF	243.28	243.75	241.95	242.465	24070106.0
2017-06-09 15:00:00	SPY	ETF	242.46	243.63	242.43	243.45	37981187.0
2017-06-09 16:00:00	SPY	ETF	243.45	243.58	242.9522	243.48	14967258.0
2017-06-09 17:00:00	SPY	ETF	243.51	243.56	243.41	243.55	637722.0
2017-06-09 18:00:00	SPY	ETF	243.55	243.6	243.55	243.55	29078.0
2017-06-09 19:00:00	SPY	ETF	243.58	243.59	243.55	243.59	29528.0
2017-06-09 04:00:00	QQQ	ETF	143.5	143.78	143.46	143.78	4052.0
2017-06-09 05:00:00	QQQ	ETF	143.75	143.75	143.69	143.72	3700.0
2017-06-09 06:00:00	QQQ	ETF	143.69	143.7	143.6	143.62	23900.0
2017-06-09 07:00:00	QQQ	ETF	143.62	143.7	143.54	143.7	47962.0
2017-06-09 08:00:00	QQQ	ETF	143.69	143.7	143.57	143.65	57181.0
2017-06-09 09:00:00	QQQ	ETF	143.64	143.795	143.42	143.63	3026263.0
2017-06-09 10:00:00	QQQ	ETF	143.63	143.9	143.57	143.6401	4906672.0
2017-06-09 11:00:00	QQQ	ETF	143.64	143.69	143.02	143.02	5246927.0
2017-06-09 12:00:00	QQQ	ETF	143.03	143.03	141.78	142.05	12576993.0
2017-06-09 13:00:00	QQQ	ETF	142.05	142.1185	140.38	140.38	15885823.0
2017-06-09 14:00:00	QQQ	ETF	140.38	140.81	138.11	139.305	22196926.0
2017-06-09 15:00:00	QQQ	ETF	139.31	140.39	139.27	139.99	25164726.0
2017-06-09 16:00:00	QQQ	ETF	139.99	141.4023	139.1693	140.0	3525256.0
2017-06-09 17:00:00	QQQ	ETF	140.0	140.17	139.99	140.05	329868.0
2017-06-09 18:00:00	QQQ	ETF	140.06	140.13	140.06	140.1	8379.0
2017-06-09 19:00:00	QQQ	ETF	140.13	140.19	140.11	140.18	14606.0
2017-06-09 05:00:00	IWM	ETF	141.44	141.44	141.35	141.35	4420.0
2017-06-09 06:00:00	IWM	ETF	141.37	141.38	141.25	141.25	10636.0
2017-06-09 07:00:00	IWM	ETF	141.23	141.43	141.17	141.37	33003.0
2017-06-09 08:00:00	IWM	ETF	141.38	141.41	141.15	141.17	23912.0
2017-06-09 09:00:00	IWM	ETF	141.18	141.82	141.11	141.63	3979893.0
2017-06-09 10:00:00	IWM	ETF	141.62	142.51	141.43	142.49	5481019.0
2017-06-09 11:00:00	IWM	ETF	142.49	142.9	142.43	142.69	4474998.0
2017-06-09 12:00:00	IWM	ETF	142.68	142.86	142.23	142.61	5865079.0
2017-06-09 13:00:00	IWM	ETF	142.6066	142.78	141.76	141.79	6276011.0
2017-06-09 14:00:00	IWM	ETF	141.7799	142.01	140.7	141.07	8162904.0
2017-06-09 15:00:00	IWM	ETF	141.07	141.77	141.04	141.6	9047314.0
2017-06-09 16:00:00	IWM	ETF	141.61	142.4799	141.5	141.5	1979107.0
2017-06-09 17:00:00	IWM	ETF	141.55	141.7	141.51	141.69	107902.0
2017-06-09 18:00:00	IWM	ETF	141.74	141.77	141.72	141.72	770.0
2017-06-09 19:00:00	IWM	ETF	141.73	141.79	141.5452	141.79	304419.0
2017-06-09 04:00:00	DIA	ETF	211.81	212.1	211.81	212.1	800.0
2017-06-09 07:00:00	DIA	ETF	212.0	212.21	212.0	212.21	2000.0
2017-06-09 08:00:00	DIA	ETF	212.18	212.19	212.15	212.15	409.0

> showing 50 of 9,165 rows — these rows as CSV

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