PREVIEW / etf_1hour / 2016-12-06

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-06.parquet
  size:    271 KB
  rows:    8,728

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-12-06 04:00:00	SPY	ETF	220.97	221.05	220.93	221.05	9013.0
2016-12-06 05:00:00	SPY	ETF	221.12	221.22	220.97	220.97	13920.0
2016-12-06 06:00:00	SPY	ETF	221.04	221.16	221.02	221.1	9814.0
2016-12-06 07:00:00	SPY	ETF	221.11	221.26	221.02	221.22	79927.0
2016-12-06 08:00:00	SPY	ETF	221.07	221.47	221.07	221.32	347775.0
2016-12-06 09:00:00	SPY	ETF	221.32	221.39	220.72	220.81	5970345.0
2016-12-06 10:00:00	SPY	ETF	220.8	221.12	220.662	221.02	7622682.0
2016-12-06 11:00:00	SPY	ETF	221.03	221.12	220.85	221.09	7000372.0
2016-12-06 12:00:00	SPY	ETF	221.09	221.41	221.05	221.31	6781620.0
2016-12-06 13:00:00	SPY	ETF	221.31	221.44	221.2	221.4	5431033.0
2016-12-06 14:00:00	SPY	ETF	221.4	221.57	221.32	221.5566	5047486.0
2016-12-06 15:00:00	SPY	ETF	221.5588	221.7441	221.3	221.69	14552054.0
2016-12-06 16:00:00	SPY	ETF	221.69	221.74	221.3201	221.7	4523568.0
2016-12-06 17:00:00	SPY	ETF	221.7	221.76	221.62	221.72	370759.0
2016-12-06 18:00:00	SPY	ETF	221.73	221.74	221.61	221.66	176893.0
2016-12-06 19:00:00	SPY	ETF	221.63	221.74	221.59	221.72	50096.0
2016-12-06 04:00:00	QQQ	ETF	116.79	116.79	116.79	116.79	350.0
2016-12-06 05:00:00	QQQ	ETF	116.86	116.86	116.86	116.86	250.0
2016-12-06 06:00:00	QQQ	ETF	116.79	116.79	116.74	116.74	1000.0
2016-12-06 07:00:00	QQQ	ETF	116.71	116.94	116.71	116.93	14317.0
2016-12-06 08:00:00	QQQ	ETF	116.93	116.98	116.87	116.91	88497.0
2016-12-06 09:00:00	QQQ	ETF	116.93	116.95	116.39	116.905	2646088.0
2016-12-06 10:00:00	QQQ	ETF	116.895	117.08	116.522	116.75	2897675.0
2016-12-06 11:00:00	QQQ	ETF	116.75	116.79	116.39	116.59	1572582.0
2016-12-06 12:00:00	QQQ	ETF	116.59	116.73	116.5	116.53	1317245.0
2016-12-06 13:00:00	QQQ	ETF	116.53	116.73	116.505	116.696	896599.0
2016-12-06 14:00:00	QQQ	ETF	116.7	116.8699	116.65	116.85	1140775.0
2016-12-06 15:00:00	QQQ	ETF	116.85	116.91	116.63	116.87	3871624.0
2016-12-06 16:00:00	QQQ	ETF	116.88	116.94	116.81	116.94	476062.0
2016-12-06 17:00:00	QQQ	ETF	116.9	116.93	116.88	116.93	1768.0
2016-12-06 18:00:00	QQQ	ETF	116.92	116.94	116.88	116.89	3874.0
2016-12-06 19:00:00	QQQ	ETF	116.88	116.96	116.86	116.96	4145.0
2016-12-06 07:00:00	IWM	ETF	133.4	133.56	133.4	133.55	3876.0
2016-12-06 08:00:00	IWM	ETF	133.52	133.76	133.49	133.7	154116.0
2016-12-06 09:00:00	IWM	ETF	133.72	133.75	132.89	132.92	2468115.0
2016-12-06 10:00:00	IWM	ETF	132.925	133.23	132.77	133.18	2818087.0
2016-12-06 11:00:00	IWM	ETF	133.18	133.24	132.74	133.22	2508013.0
2016-12-06 12:00:00	IWM	ETF	133.23	133.76	133.19	133.7	2560648.0
2016-12-06 13:00:00	IWM	ETF	133.69	134.38	133.69	134.3211	2898993.0
2016-12-06 14:00:00	IWM	ETF	134.33	134.91	134.3099	134.8	3608301.0
2016-12-06 15:00:00	IWM	ETF	134.81	134.82	134.47	134.62	5548482.0
2016-12-06 16:00:00	IWM	ETF	134.62	134.6814	133.08	134.41	1006634.0
2016-12-06 17:00:00	IWM	ETF	134.41	134.49	134.38	134.46	7569.0
2016-12-06 18:00:00	IWM	ETF	134.48	134.59	134.43	134.45	58194.0
2016-12-06 19:00:00	IWM	ETF	134.43	134.49	134.4	134.49	4993.0
2016-12-06 08:00:00	DIA	ETF	192.3	192.39	192.3	192.3	3900.0
2016-12-06 09:00:00	DIA	ETF	192.39	192.39	191.88	191.9368	631889.0
2016-12-06 10:00:00	DIA	ETF	191.92	192.17	191.87	192.06	282916.0
2016-12-06 11:00:00	DIA	ETF	192.06	192.15	191.9378	192.08	192104.0
2016-12-06 12:00:00	DIA	ETF	192.0873	192.395	192.06	192.35	227996.0

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

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