PREVIEW / etf_1hour / 2017-12-15

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-12-15.parquet
  size:    292 KB
  rows:    9,576

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
2017-12-15 04:00:00	SPY	ETF	264.95	264.95	264.68	264.71	14454.0
2017-12-15 05:00:00	SPY	ETF	264.74	264.8	264.64	264.76	27560.0
2017-12-15 06:00:00	SPY	ETF	264.74	264.84	264.7	264.79	8498.0
2017-12-15 07:00:00	SPY	ETF	264.85	265.12	264.79	265.03	413854.0
2017-12-15 08:00:00	SPY	ETF	264.94	265.66	264.85	265.12	693820.0
2017-12-15 09:00:00	SPY	ETF	265.12	265.68	264.93	265.51	9954563.0
2017-12-15 10:00:00	SPY	ETF	265.5	266.34	265.5	265.92	32335509.0
2017-12-15 11:00:00	SPY	ETF	265.93	266.625	265.92	266.501	12013861.0
2017-12-15 12:00:00	SPY	ETF	266.5	266.7	266.39	266.6105	9781465.0
2017-12-15 13:00:00	SPY	ETF	266.61	266.8	266.49	266.79	7532253.0
2017-12-15 14:00:00	SPY	ETF	266.795	267.01	266.71	266.81	17906926.0
2017-12-15 15:00:00	SPY	ETF	266.815	267.04	266.24	266.53	28829001.0
2017-12-15 16:00:00	SPY	ETF	266.52	267.06	266.4832	267.04	18718513.0
2017-12-15 17:00:00	SPY	ETF	267.03	267.15	264.2552	267.12	2896696.0
2017-12-15 18:00:00	SPY	ETF	267.06	267.26	266.97	267.23	1362948.0
2017-12-15 19:00:00	SPY	ETF	267.2	267.23	266.93	267.23	66425.0
2017-12-15 04:00:00	QQQ	ETF	156.19	156.19	156.14	156.14	9400.0
2017-12-15 05:00:00	QQQ	ETF	156.14	156.24	156.13	156.24	66892.0
2017-12-15 06:00:00	QQQ	ETF	156.25	156.27	156.18	156.22	37899.0
2017-12-15 07:00:00	QQQ	ETF	156.21	156.35	156.2	156.34	98019.0
2017-12-15 08:00:00	QQQ	ETF	156.2	156.36	155.88	156.28	1144011.0
2017-12-15 09:00:00	QQQ	ETF	156.28	156.56	156.15	156.37	3813729.0
2017-12-15 10:00:00	QQQ	ETF	156.37	156.8499	156.33	156.735	4325992.0
2017-12-15 11:00:00	QQQ	ETF	156.74	157.28	156.74	157.28	4000367.0
2017-12-15 12:00:00	QQQ	ETF	157.27	157.54	156.5008	157.461	2500050.0
2017-12-15 13:00:00	QQQ	ETF	157.46	157.63	157.38	157.571	2553079.0
2017-12-15 14:00:00	QQQ	ETF	157.58	157.68	156.5008	157.58	2835506.0
2017-12-15 15:00:00	QQQ	ETF	157.575	157.82	157.405	157.61	7120732.0
2017-12-15 16:00:00	QQQ	ETF	157.61	158.09	156.6436	158.03	4243504.0
2017-12-15 17:00:00	QQQ	ETF	158.03	158.1	157.65	158.0	1597347.0
2017-12-15 18:00:00	QQQ	ETF	158.03	158.14	157.99	158.05	330002.0
2017-12-15 19:00:00	QQQ	ETF	158.05	158.2	158.02	158.02	9335.0
2017-12-15 04:00:00	IWM	ETF	150.55	150.55	150.55	150.55	200.0
2017-12-15 05:00:00	IWM	ETF	150.49	150.64	150.47	150.62	7976.0
2017-12-15 06:00:00	IWM	ETF	150.68	150.72	150.62	150.67	3621.0
2017-12-15 07:00:00	IWM	ETF	150.74	150.9	150.72	150.86	24472.0
2017-12-15 08:00:00	IWM	ETF	150.7	151.02	150.7	150.87	101719.0
2017-12-15 09:00:00	IWM	ETF	150.89	151.29	150.58	151.215	2313420.0
2017-12-15 10:00:00	IWM	ETF	151.22	151.95	151.22	151.61	4175026.0
2017-12-15 11:00:00	IWM	ETF	151.61	152.46	151.59	152.12	3095112.0
2017-12-15 12:00:00	IWM	ETF	152.12	152.66	152.025	152.43	2834864.0
2017-12-15 13:00:00	IWM	ETF	152.43	152.73	152.25	152.64	2051311.0
2017-12-15 14:00:00	IWM	ETF	152.63	153.09	152.605	152.895	3672550.0
2017-12-15 15:00:00	IWM	ETF	152.9	153.2525	152.18	152.23	6540808.0
2017-12-15 16:00:00	IWM	ETF	152.23	152.76	152.18	152.68	2116448.0
2017-12-15 17:00:00	IWM	ETF	152.6	152.7	152.24	152.69	432958.0
2017-12-15 18:00:00	IWM	ETF	152.57	152.81	152.57	152.81	13018.0
2017-12-15 19:00:00	IWM	ETF	152.69	152.69	152.62	152.62	1200.0
2017-12-15 07:00:00	DIA	ETF	245.87	245.87	245.79	245.79	1600.0
2017-12-15 08:00:00	DIA	ETF	245.82	246.1	245.82	245.99	7910.0

> showing 50 of 9,576 rows — these rows as CSV

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