PREVIEW / etf_1hour / 2016-01-11

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-01-11.parquet
  size:    261 KB
  rows:    8,282

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-01-11 04:00:00	SPY	ETF	193.11	193.23	192.49	192.72	36151.0
2016-01-11 05:00:00	SPY	ETF	192.8	192.83	191.97	192.47	24253.0
2016-01-11 06:00:00	SPY	ETF	192.26	192.8	192.05	192.67	88718.0
2016-01-11 07:00:00	SPY	ETF	192.56	192.79	192.27	192.5	291040.0
2016-01-11 08:00:00	SPY	ETF	192.07	193.37	191.22	192.91	1418644.0
2016-01-11 09:00:00	SPY	ETF	192.95	193.41	191.925	192.095	18877777.0
2016-01-11 10:00:00	SPY	ETF	192.09	192.85	191.35	191.49	23066691.0
2016-01-11 11:00:00	SPY	ETF	191.5	192.4	191.06	192.11	21191161.0
2016-01-11 12:00:00	SPY	ETF	192.12	192.1799	191.07	191.32	15446847.0
2016-01-11 13:00:00	SPY	ETF	191.33	191.55	189.82	190.185	20328256.0
2016-01-11 14:00:00	SPY	ETF	190.18	191.57	189.99	190.97	22842387.0
2016-01-11 15:00:00	SPY	ETF	190.98	192.79	190.25	192.08	41752093.0
2016-01-11 16:00:00	SPY	ETF	192.08	192.38	191.67	191.84	5281117.0
2016-01-11 17:00:00	SPY	ETF	191.87	192.11	191.77	191.9	657217.0
2016-01-11 18:00:00	SPY	ETF	191.92	192.45	191.85	192.42	273473.0
2016-01-11 19:00:00	SPY	ETF	192.44	192.54	192.17	192.41	203109.0
2016-01-11 04:00:00	QQQ	ETF	104.39	104.52	104.37	104.42	6600.0
2016-01-11 05:00:00	QQQ	ETF	104.41	104.41	104.06	104.06	16613.0
2016-01-11 06:00:00	QQQ	ETF	104.21	104.54	104.13	104.44	9900.0
2016-01-11 07:00:00	QQQ	ETF	104.43	104.55	104.31	104.36	43602.0
2016-01-11 08:00:00	QQQ	ETF	104.42	104.8	104.37	104.69	233800.0
2016-01-11 09:00:00	QQQ	ETF	104.7	105.06	104.08	104.19	4881482.0
2016-01-11 10:00:00	QQQ	ETF	104.18	104.585	103.64	103.75	6304100.0
2016-01-11 11:00:00	QQQ	ETF	103.75	104.41	103.475	104.18	5308230.0
2016-01-11 12:00:00	QQQ	ETF	104.2	104.22	103.475	103.63	3958615.0
2016-01-11 13:00:00	QQQ	ETF	103.64	103.79	102.73	102.93	5042853.0
2016-01-11 14:00:00	QQQ	ETF	102.94	103.96	102.81	103.54	7191898.0
2016-01-11 15:00:00	QQQ	ETF	103.54	104.7444	103.04	104.355	11874010.0
2016-01-11 16:00:00	QQQ	ETF	104.35	104.39	103.7185	104.21	1096955.0
2016-01-11 17:00:00	QQQ	ETF	104.21	104.25	104.2	104.25	6786.0
2016-01-11 18:00:00	QQQ	ETF	104.29	104.53	104.23	104.52	45129.0
2016-01-11 19:00:00	QQQ	ETF	104.52	104.57	104.4	104.57	22422.0
2016-01-11 04:00:00	IWM	ETF	104.55	104.55	104.18	104.18	5086.0
2016-01-11 05:00:00	IWM	ETF	104.26	104.26	104.04	104.04	910.0
2016-01-11 06:00:00	IWM	ETF	104.28	104.42	104.28	104.3	330.0
2016-01-11 07:00:00	IWM	ETF	104.36	104.36	104.13	104.14	18700.0
2016-01-11 08:00:00	IWM	ETF	104.21	104.59	104.2	104.42	114662.0
2016-01-11 09:00:00	IWM	ETF	104.41	104.78	103.43	103.53	4604121.0
2016-01-11 10:00:00	IWM	ETF	103.54	104.08	103.27	103.35	6850728.0
2016-01-11 11:00:00	IWM	ETF	103.35	103.93	103.11	103.75	5909032.0
2016-01-11 12:00:00	IWM	ETF	103.76	103.79	103.04	103.11	3025056.0
2016-01-11 13:00:00	IWM	ETF	103.12	103.28	102.31	102.47	4793250.0
2016-01-11 14:00:00	IWM	ETF	102.47	103.15	102.39	102.845	5782169.0
2016-01-11 15:00:00	IWM	ETF	102.8401	103.86	102.53	103.46	9918575.0
2016-01-11 16:00:00	IWM	ETF	103.46	103.5	103.24	103.25	2950287.0
2016-01-11 17:00:00	IWM	ETF	103.29	103.32	103.24	103.32	5401.0
2016-01-11 18:00:00	IWM	ETF	103.43	103.61	103.43	103.61	12612.0
2016-01-11 19:00:00	IWM	ETF	103.61	103.64	103.55	103.64	2900.0
2016-01-11 04:00:00	DIA	ETF	163.57	163.91	163.57	163.91	37956.0
2016-01-11 05:00:00	DIA	ETF	163.91	163.93	163.56	163.56	3400.0

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

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