PREVIEW / etf_1hour / 2015-02-10

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-02-10.parquet
  size:    237 KB
  rows:    7,537

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
2015-02-10 04:00:00	SPY	ETF	204.77	204.84	204.59	204.84	3900.0
2015-02-10 05:00:00	SPY	ETF	204.9	205.14	204.84	204.87	21364.0
2015-02-10 06:00:00	SPY	ETF	204.84	205.17	204.84	205.1	152724.0
2015-02-10 07:00:00	SPY	ETF	205.12	206.36	205.12	205.69	1038435.0
2015-02-10 08:00:00	SPY	ETF	205.65	206.24	204.63	205.99	840888.0
2015-02-10 09:00:00	SPY	ETF	205.98	206.11	205.225	205.33	11829202.0
2015-02-10 10:00:00	SPY	ETF	205.31	205.72	204.82	205.23	13343487.0
2015-02-10 11:00:00	SPY	ETF	205.24	205.79	205.1	205.76	15464736.0
2015-02-10 12:00:00	SPY	ETF	205.76	206.24	205.54	206.05	8918989.0
2015-02-10 13:00:00	SPY	ETF	206.05	206.2	205.77	205.86	9513200.0
2015-02-10 14:00:00	SPY	ETF	205.86	206.89	205.845	206.885	10731244.0
2015-02-10 15:00:00	SPY	ETF	206.89	207.12	206.68	206.81	18657546.0
2015-02-10 16:00:00	SPY	ETF	206.81	206.95	205.6522	206.78	4354123.0
2015-02-10 17:00:00	SPY	ETF	206.77	206.78	206.72	206.73	200457.0
2015-02-10 18:00:00	SPY	ETF	206.76	206.84	206.71	206.76	86154.0
2015-02-10 19:00:00	SPY	ETF	206.75	206.78	206.69	206.75	42401.0
2015-02-10 06:00:00	QQQ	ETF	103.1	103.11	103.05	103.08	17519.0
2015-02-10 07:00:00	QQQ	ETF	103.19	103.69	103.19	103.4	90754.0
2015-02-10 08:00:00	QQQ	ETF	103.56	103.57	102.8	103.43	119560.0
2015-02-10 09:00:00	QQQ	ETF	103.43	103.63	103.24	103.45	2895923.0
2015-02-10 10:00:00	QQQ	ETF	103.45	103.6	103.21	103.47	3000111.0
2015-02-10 11:00:00	QQQ	ETF	103.46	103.86	103.38	103.84	2767395.0
2015-02-10 12:00:00	QQQ	ETF	103.84	104.06	103.72	104.02	2488503.0
2015-02-10 13:00:00	QQQ	ETF	104.02	104.1	103.87	103.94	2031849.0
2015-02-10 14:00:00	QQQ	ETF	103.95	104.42	103.94	104.42	2607240.0
2015-02-10 15:00:00	QQQ	ETF	104.415	104.54	104.3101	104.4	4680489.0
2015-02-10 16:00:00	QQQ	ETF	104.4	104.42	103.7981	104.41	551687.0
2015-02-10 17:00:00	QQQ	ETF	104.4	104.41	104.34	104.38	34971.0
2015-02-10 18:00:00	QQQ	ETF	104.39	104.42	104.39	104.41	22200.0
2015-02-10 19:00:00	QQQ	ETF	104.41	104.43	104.38	104.42	8250.0
2015-02-10 05:00:00	IWM	ETF	119.14	119.14	119.14	119.14	300.0
2015-02-10 07:00:00	IWM	ETF	119.37	119.93	119.37	119.55	75674.0
2015-02-10 08:00:00	IWM	ETF	119.54	119.79	119.54	119.69	76082.0
2015-02-10 09:00:00	IWM	ETF	119.66	119.77	118.7	118.77	3085659.0
2015-02-10 10:00:00	IWM	ETF	118.78	118.839	118.1	118.4599	7595186.0
2015-02-10 11:00:00	IWM	ETF	118.455	119.03	118.33	119.0	3342772.0
2015-02-10 12:00:00	IWM	ETF	118.985	119.35	118.855	119.04	1464815.0
2015-02-10 13:00:00	IWM	ETF	119.04	119.22	118.92	119.04	1250386.0
2015-02-10 14:00:00	IWM	ETF	119.04	119.6299	119.04	119.61	1969583.0
2015-02-10 15:00:00	IWM	ETF	119.62	119.84	119.39	119.59	4961894.0
2015-02-10 16:00:00	IWM	ETF	119.58	119.62	119.42	119.46	1448263.0
2015-02-10 17:00:00	IWM	ETF	119.48	119.48	119.4	119.4	40125.0
2015-02-10 19:00:00	IWM	ETF	119.4	119.49	119.4	119.49	1125.0
2015-02-10 07:00:00	DIA	ETF	178.0	178.7	178.0	178.7	871.0
2015-02-10 08:00:00	DIA	ETF	178.12	178.39	178.1	178.26	5438.0
2015-02-10 09:00:00	DIA	ETF	178.27	178.31	177.65	177.7102	699271.0
2015-02-10 10:00:00	DIA	ETF	177.73	178.01	177.14	177.4579	693130.0
2015-02-10 11:00:00	DIA	ETF	177.46	178.01	177.34	177.88	388147.0
2015-02-10 12:00:00	DIA	ETF	177.87	178.25	177.71	178.05	410379.0
2015-02-10 13:00:00	DIA	ETF	178.09	178.13	177.78	177.81	231165.0

> showing 50 of 7,537 rows — these rows as CSV

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