PREVIEW / etf_1hour / 2016-08-01

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-01.parquet
  size:    256 KB
  rows:    8,269

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-08-01 04:00:00	SPY	ETF	217.59	217.86	217.54	217.54	12898.0
2016-08-01 05:00:00	SPY	ETF	217.54	217.62	217.36	217.39	30523.0
2016-08-01 06:00:00	SPY	ETF	217.29	217.4	217.29	217.37	25864.0
2016-08-01 07:00:00	SPY	ETF	217.35	217.52	217.31	217.5	228697.0
2016-08-01 08:00:00	SPY	ETF	217.44	217.991	217.2	217.24	424541.0
2016-08-01 09:00:00	SPY	ETF	217.24	217.41	216.62	216.95	7651793.0
2016-08-01 10:00:00	SPY	ETF	216.95	217.38	216.8	217.35	9639129.0
2016-08-01 11:00:00	SPY	ETF	217.34	217.65	217.09	217.09	7349140.0
2016-08-01 12:00:00	SPY	ETF	217.081	217.1	216.405	216.66	10290682.0
2016-08-01 13:00:00	SPY	ETF	216.66	216.99	216.53	216.94	5135517.0
2016-08-01 14:00:00	SPY	ETF	216.94	217.07	216.67	216.9	8285759.0
2016-08-01 15:00:00	SPY	ETF	216.89	216.95	216.46	216.89	16438209.0
2016-08-01 16:00:00	SPY	ETF	216.91	216.98	216.6891	216.98	6498535.0
2016-08-01 17:00:00	SPY	ETF	216.98	217.06	216.95	217.02	139714.0
2016-08-01 18:00:00	SPY	ETF	217.02	217.04	216.89	216.96	119582.0
2016-08-01 19:00:00	SPY	ETF	216.95	217.02	216.91	216.98	27495.0
2016-08-01 04:00:00	QQQ	ETF	115.32	115.57	115.32	115.48	2698.0
2016-08-01 05:00:00	QQQ	ETF	115.43	115.47	115.4	115.47	300.0
2016-08-01 06:00:00	QQQ	ETF	115.35	115.35	115.32	115.32	1701.0
2016-08-01 07:00:00	QQQ	ETF	115.34	115.43	115.33	115.43	39267.0
2016-08-01 08:00:00	QQQ	ETF	115.44	115.46	115.31	115.31	43973.0
2016-08-01 09:00:00	QQQ	ETF	115.34	115.5	115.17	115.49	1587625.0
2016-08-01 10:00:00	QQQ	ETF	115.48	115.95	115.43	115.92	2233930.0
2016-08-01 11:00:00	QQQ	ETF	115.91	116.13	115.84	115.892	2371264.0
2016-08-01 12:00:00	QQQ	ETF	115.89	115.89	115.46	115.62	1978639.0
2016-08-01 13:00:00	QQQ	ETF	115.62	115.85	115.57	115.82	1084454.0
2016-08-01 14:00:00	QQQ	ETF	115.82	115.9	115.66	115.86	1420778.0
2016-08-01 15:00:00	QQQ	ETF	115.85	115.87	115.6	115.83	2485855.0
2016-08-01 16:00:00	QQQ	ETF	115.81	115.85	115.72	115.81	410152.0
2016-08-01 17:00:00	QQQ	ETF	115.82	115.82	115.77	115.8	9221.0
2016-08-01 18:00:00	QQQ	ETF	115.83	115.83	115.76	115.82	21369.0
2016-08-01 19:00:00	QQQ	ETF	115.82	115.85	115.78	115.84	17568.0
2016-08-01 04:00:00	IWM	ETF	121.55	121.55	121.55	121.55	100.0
2016-08-01 05:00:00	IWM	ETF	121.41	121.41	121.41	121.41	1400.0
2016-08-01 07:00:00	IWM	ETF	121.38	121.47	121.29	121.47	94755.0
2016-08-01 08:00:00	IWM	ETF	121.47	121.47	121.23	121.23	54750.0
2016-08-01 09:00:00	IWM	ETF	121.24	121.35	120.44	120.9	2579279.0
2016-08-01 10:00:00	IWM	ETF	120.87	121.46	120.77	121.37	3795156.0
2016-08-01 11:00:00	IWM	ETF	121.37	121.7	121.235	121.27	3086191.0
2016-08-01 12:00:00	IWM	ETF	121.27	121.35	120.645	120.91	2524462.0
2016-08-01 13:00:00	IWM	ETF	120.91	121.23	120.79	121.21	1693818.0
2016-08-01 14:00:00	IWM	ETF	121.21	121.295	121.03	121.13	3381343.0
2016-08-01 15:00:00	IWM	ETF	121.12	121.19	120.76	121.15	7164704.0
2016-08-01 16:00:00	IWM	ETF	121.16	121.43	121.0917	121.27	6627222.0
2016-08-01 17:00:00	IWM	ETF	121.28	121.35	121.27	121.35	53125.0
2016-08-01 19:00:00	IWM	ETF	121.3	121.31	121.23	121.26	7883.0
2016-08-01 08:00:00	DIA	ETF	184.55	184.55	184.36	184.36	1100.0
2016-08-01 09:00:00	DIA	ETF	184.4	184.4	183.72	183.94	443886.0
2016-08-01 10:00:00	DIA	ETF	183.91	184.22	183.81	184.17	406786.0
2016-08-01 11:00:00	DIA	ETF	184.15	184.52	183.99	183.99	413992.0

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

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