PREVIEW / etf_1hour / 2013-06-11

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-11.parquet
  size:    210 KB
  rows:    6,613

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
2013-06-11 04:00:00	SPY	ETF	164.8	164.8	164.14	164.19	14870.0
2013-06-11 05:00:00	SPY	ETF	164.23	164.23	163.34	163.49	111843.0
2013-06-11 06:00:00	SPY	ETF	163.47	163.58	163.3	163.39	351825.0
2013-06-11 07:00:00	SPY	ETF	163.37	163.55	163.15	163.25	1003167.0
2013-06-11 08:00:00	SPY	ETF	163.32	163.51	163.09	163.38	3317522.0
2013-06-11 09:00:00	SPY	ETF	163.36	163.42	162.739	163.25	22773341.0
2013-06-11 10:00:00	SPY	ETF	163.25	163.94	163.0	163.7999	22037893.0
2013-06-11 11:00:00	SPY	ETF	163.8	164.54	163.64	164.23	19476044.0
2013-06-11 12:00:00	SPY	ETF	164.23	164.42	164.04	164.13	9764182.0
2013-06-11 13:00:00	SPY	ETF	164.135	164.23	163.22	163.24	18688534.0
2013-06-11 14:00:00	SPY	ETF	163.23	163.85	163.14	163.845	17169054.0
2013-06-11 15:00:00	SPY	ETF	163.84	163.95	163.045	163.12	28967168.0
2013-06-11 16:00:00	SPY	ETF	163.12	164.7631	163.0981	163.34	12050904.0
2013-06-11 17:00:00	SPY	ETF	163.35	163.41	163.3	163.32	195321.0
2013-06-11 18:00:00	SPY	ETF	163.33	163.39	163.21	163.26	87778.0
2013-06-11 19:00:00	SPY	ETF	163.26	163.4	163.26	163.38	37993.0
2013-06-11 04:00:00	QQQ	ETF	73.24	73.24	73.14	73.18	4400.0
2013-06-11 05:00:00	QQQ	ETF	73.16	73.16	72.74	72.76	11200.0
2013-06-11 06:00:00	QQQ	ETF	72.74	72.8	72.72	72.75	15138.0
2013-06-11 07:00:00	QQQ	ETF	72.75	72.79	72.64	72.72	167629.0
2013-06-11 08:00:00	QQQ	ETF	72.72	72.78	72.63	72.72	455102.0
2013-06-11 09:00:00	QQQ	ETF	72.69	72.8301	72.44	72.78	5125019.0
2013-06-11 10:00:00	QQQ	ETF	72.79	73.1	72.61	73.03	6324364.0
2013-06-11 11:00:00	QQQ	ETF	73.03	73.34	72.97	73.18	4752005.0
2013-06-11 12:00:00	QQQ	ETF	73.19	73.329	73.15	73.21	3691286.0
2013-06-11 13:00:00	QQQ	ETF	73.215	73.28	72.79	72.795	4402741.0
2013-06-11 14:00:00	QQQ	ETF	72.79	73.01	72.74	73.01	3936808.0
2013-06-11 15:00:00	QQQ	ETF	73.01	73.07	72.63	72.69	6076359.0
2013-06-11 16:00:00	QQQ	ETF	72.69	73.4047	72.6552	72.84	4603377.0
2013-06-11 17:00:00	QQQ	ETF	72.84	72.84	72.77	72.77	12044.0
2013-06-11 18:00:00	QQQ	ETF	72.8	72.83	72.79	72.8	2594.0
2013-06-11 19:00:00	QQQ	ETF	72.8	72.84	72.8	72.84	1050.0
2013-06-11 06:00:00	IWM	ETF	97.95	98.39	97.7	97.74	30675.0
2013-06-11 07:00:00	IWM	ETF	97.74	97.78	97.58	97.68	200713.0
2013-06-11 08:00:00	IWM	ETF	97.7	97.81	97.53	97.79	358211.0
2013-06-11 09:00:00	IWM	ETF	97.74	97.8	96.86	97.49	10488308.0
2013-06-11 10:00:00	IWM	ETF	97.49	98.22	97.27	98.06	7907343.0
2013-06-11 11:00:00	IWM	ETF	98.065	98.44	97.91	98.18	4857445.0
2013-06-11 12:00:00	IWM	ETF	98.19	98.44	98.17	98.33	2137190.0
2013-06-11 13:00:00	IWM	ETF	98.34	98.47	97.705	97.72	3587707.0
2013-06-11 14:00:00	IWM	ETF	97.73	98.02	97.59	98.02	5143591.0
2013-06-11 15:00:00	IWM	ETF	98.03	98.12	97.64	97.7	6694851.0
2013-06-11 16:00:00	IWM	ETF	97.7	97.82	97.7	97.76	605102.0
2013-06-11 17:00:00	IWM	ETF	97.76	97.82	97.76	97.77	4335.0
2013-06-11 18:00:00	IWM	ETF	97.77	97.83	97.75	97.75	4138.0
2013-06-11 19:00:00	IWM	ETF	97.75	97.79	97.75	97.79	1751.0
2013-06-11 06:00:00	DIA	ETF	151.27	151.27	151.27	151.27	100.0
2013-06-11 07:00:00	DIA	ETF	151.06	151.24	150.96	151.02	16380.0
2013-06-11 08:00:00	DIA	ETF	151.1	151.13	150.95	151.02	32370.0
2013-06-11 09:00:00	DIA	ETF	151.12	151.13	150.7	151.0	994823.0

> showing 50 of 6,613 rows — these rows as CSV

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