PREVIEW / etf_1hour / 2016-11-11

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-11.parquet
  size:    275 KB
  rows:    8,771

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-11-11 04:00:00	SPY	ETF	216.86	216.99	216.48	216.56	51351.0
2016-11-11 05:00:00	SPY	ETF	216.54	216.54	215.56	216.0	101127.0
2016-11-11 06:00:00	SPY	ETF	216.0	216.14	215.8	216.05	104127.0
2016-11-11 07:00:00	SPY	ETF	216.09	216.52	216.09	216.45	521063.0
2016-11-11 08:00:00	SPY	ETF	216.45	216.6	216.0	216.39	2481794.0
2016-11-11 09:00:00	SPY	ETF	216.37	216.62	215.86	216.05	12569160.0
2016-11-11 10:00:00	SPY	ETF	216.06	216.57	215.49	215.68	17550582.0
2016-11-11 11:00:00	SPY	ETF	215.68	215.95	215.32	215.82	12742650.0
2016-11-11 12:00:00	SPY	ETF	215.82	216.585	215.8	216.1599	10916424.0
2016-11-11 13:00:00	SPY	ETF	216.16	216.55	216.09	216.1	6113112.0
2016-11-11 14:00:00	SPY	ETF	216.1	216.38	215.8	215.81	7070988.0
2016-11-11 15:00:00	SPY	ETF	215.805	216.7	215.78	216.46	18685437.0
2016-11-11 16:00:00	SPY	ETF	216.46	216.77	216.2651	216.42	9982161.0
2016-11-11 17:00:00	SPY	ETF	216.53	216.69	216.42	216.53	203944.0
2016-11-11 18:00:00	SPY	ETF	216.53	216.72	216.53	216.68	75213.0
2016-11-11 19:00:00	SPY	ETF	216.7	216.75	216.66	216.68	19895.0
2016-11-11 04:00:00	QQQ	ETF	115.75	115.75	114.64	114.64	15347.0
2016-11-11 05:00:00	QQQ	ETF	114.67	114.7	114.29	114.63	13165.0
2016-11-11 06:00:00	QQQ	ETF	114.63	114.69	114.45	114.6	88269.0
2016-11-11 07:00:00	QQQ	ETF	114.64	114.9	114.58	114.85	193947.0
2016-11-11 08:00:00	QQQ	ETF	114.84	115.18	114.81	115.09	400661.0
2016-11-11 09:00:00	QQQ	ETF	115.17	115.62	114.84	114.92	7087445.0
2016-11-11 10:00:00	QQQ	ETF	114.92	115.91	114.85	115.21	6583007.0
2016-11-11 11:00:00	QQQ	ETF	115.2	115.44	114.87	115.33	3766968.0
2016-11-11 12:00:00	QQQ	ETF	115.311	116.05	115.31	115.56	4099943.0
2016-11-11 13:00:00	QQQ	ETF	115.57	115.8693	115.47	115.47	2074771.0
2016-11-11 14:00:00	QQQ	ETF	115.47	115.68	115.2936	115.33	3474983.0
2016-11-11 15:00:00	QQQ	ETF	115.33	115.97	115.3299	115.83	4076743.0
2016-11-11 16:00:00	QQQ	ETF	115.82	116.11	115.4166	115.72	1157132.0
2016-11-11 17:00:00	QQQ	ETF	115.87	115.87	115.73	115.73	76611.0
2016-11-11 19:00:00	QQQ	ETF	115.89	115.97	115.85	115.96	7321.0
2016-11-11 04:00:00	IWM	ETF	125.2	125.31	125.15	125.15	3564.0
2016-11-11 05:00:00	IWM	ETF	125.02	125.14	124.61	124.69	18848.0
2016-11-11 06:00:00	IWM	ETF	124.72	124.86	124.7	124.86	4572.0
2016-11-11 07:00:00	IWM	ETF	124.87	125.12	124.81	125.03	200979.0
2016-11-11 08:00:00	IWM	ETF	125.04	125.47	124.95	125.4	345241.0
2016-11-11 09:00:00	IWM	ETF	125.42	125.56	124.55	125.0	9718325.0
2016-11-11 10:00:00	IWM	ETF	125.02	126.07	124.98	125.99	13508264.0
2016-11-11 11:00:00	IWM	ETF	125.98	126.735	125.3	126.61	10710353.0
2016-11-11 12:00:00	IWM	ETF	126.62	127.29	126.46	126.75	12149489.0
2016-11-11 13:00:00	IWM	ETF	126.75	127.62	126.68	127.39	9596195.0
2016-11-11 14:00:00	IWM	ETF	127.4	127.555	126.77	126.88	5272927.0
2016-11-11 15:00:00	IWM	ETF	126.88	127.72	126.88	127.41	10460213.0
2016-11-11 16:00:00	IWM	ETF	127.36	127.86	127.3	127.53	4712213.0
2016-11-11 17:00:00	IWM	ETF	127.51	127.69	127.36	127.64	70925.0
2016-11-11 18:00:00	IWM	ETF	127.65	127.65	127.65	127.65	614.0
2016-11-11 19:00:00	IWM	ETF	127.74	127.74	127.6	127.74	4570.0
2016-11-11 04:00:00	DIA	ETF	188.4	188.46	188.4	188.46	2820.0
2016-11-11 05:00:00	DIA	ETF	187.93	187.93	187.62	187.62	900.0
2016-11-11 06:00:00	DIA	ETF	187.76	187.79	187.65	187.73	10206.0

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

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