PREVIEW / etf_1hour / 2015-12-08

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-08.parquet
  size:    247 KB
  rows:    7,942

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-12-08 04:00:00	SPY	ETF	207.96	207.96	207.29	207.6	14527.0
2015-12-08 05:00:00	SPY	ETF	207.58	207.94	207.58	207.87	18011.0
2015-12-08 06:00:00	SPY	ETF	207.78	207.83	207.3	207.38	83602.0
2015-12-08 07:00:00	SPY	ETF	207.37	207.51	206.66	206.67	520149.0
2015-12-08 08:00:00	SPY	ETF	206.67	208.14	206.46	206.61	1205904.0
2015-12-08 09:00:00	SPY	ETF	206.6	206.94	205.89	206.26	16256162.0
2015-12-08 10:00:00	SPY	ETF	206.251	207.265	205.78	207.21	21348451.0
2015-12-08 11:00:00	SPY	ETF	207.215	208.289	206.78	207.175	16044348.0
2015-12-08 12:00:00	SPY	ETF	207.17	207.18	206.59	207.035	7168516.0
2015-12-08 13:00:00	SPY	ETF	207.045	207.165	206.48	207.0762	7123252.0
2015-12-08 14:00:00	SPY	ETF	207.07	207.675	207.05	207.1472	9647886.0
2015-12-08 15:00:00	SPY	ETF	207.14	208.289	206.58	206.96	17250592.0
2015-12-08 16:00:00	SPY	ETF	206.95	207.306	206.55	206.76	5317671.0
2015-12-08 17:00:00	SPY	ETF	206.77	208.289	206.65	206.69	565483.0
2015-12-08 18:00:00	SPY	ETF	206.69	207.04	206.6	207.03	119893.0
2015-12-08 19:00:00	SPY	ETF	207.0	207.25	206.93	207.2	152084.0
2015-12-08 04:00:00	QQQ	ETF	114.21	114.21	114.01	114.01	200.0
2015-12-08 05:00:00	QQQ	ETF	114.32	114.32	114.32	114.32	200.0
2015-12-08 06:00:00	QQQ	ETF	114.11	114.11	113.89	114.0	13764.0
2015-12-08 07:00:00	QQQ	ETF	113.99	113.99	113.6	113.6	64969.0
2015-12-08 08:00:00	QQQ	ETF	113.58	113.81	113.48	113.56	255806.0
2015-12-08 09:00:00	QQQ	ETF	113.54	114.02	113.38	113.62	4825870.0
2015-12-08 10:00:00	QQQ	ETF	113.63	114.42	113.4	114.36	6666172.0
2015-12-08 11:00:00	QQQ	ETF	114.35	114.92	114.32	114.59	5079874.0
2015-12-08 12:00:00	QQQ	ETF	114.58	114.59	114.239	114.56	1650678.0
2015-12-08 13:00:00	QQQ	ETF	114.57	114.67	114.27	114.62	1958589.0
2015-12-08 14:00:00	QQQ	ETF	114.62	114.995	114.605	114.77	3439003.0
2015-12-08 15:00:00	QQQ	ETF	114.76	114.88	114.43	114.65	4447884.0
2015-12-08 16:00:00	QQQ	ETF	114.64	114.7	114.44	114.6	1158622.0
2015-12-08 17:00:00	QQQ	ETF	114.55	114.62	114.49	114.49	2016.0
2015-12-08 18:00:00	QQQ	ETF	114.55	114.7	114.48	114.7	14672.0
2015-12-08 19:00:00	QQQ	ETF	114.69	114.78	114.64	114.75	13050.0
2015-12-08 04:00:00	IWM	ETF	115.6	115.6	115.14	115.31	3100.0
2015-12-08 06:00:00	IWM	ETF	115.29	115.29	115.29	115.29	200.0
2015-12-08 07:00:00	IWM	ETF	115.17	115.17	114.96	114.96	12793.0
2015-12-08 08:00:00	IWM	ETF	114.96	115.98	114.84	115.0	1170828.0
2015-12-08 09:00:00	IWM	ETF	114.88	115.41	114.61	114.89	4702594.0
2015-12-08 10:00:00	IWM	ETF	114.89	115.52	114.46	115.37	6101091.0
2015-12-08 11:00:00	IWM	ETF	115.37	116.005	115.24	115.57	4814429.0
2015-12-08 12:00:00	IWM	ETF	115.57	115.57	115.17	115.44	1740406.0
2015-12-08 13:00:00	IWM	ETF	115.45	115.55	115.02	115.49	1807707.0
2015-12-08 14:00:00	IWM	ETF	115.49	115.91	115.44	115.46	2738166.0
2015-12-08 15:00:00	IWM	ETF	115.46	115.59	115.25	115.42	4044212.0
2015-12-08 16:00:00	IWM	ETF	115.42	115.42	113.13	115.28	1715595.0
2015-12-08 17:00:00	IWM	ETF	115.26	115.26	115.21	115.21	13345.0
2015-12-08 18:00:00	IWM	ETF	115.3	115.3	115.18	115.18	299.0
2015-12-08 19:00:00	IWM	ETF	115.32	115.32	115.32	115.32	300.0
2015-12-08 07:00:00	DIA	ETF	176.51	176.51	176.0	176.0	900.0
2015-12-08 08:00:00	DIA	ETF	176.0	176.07	175.73	176.02	20864.0
2015-12-08 09:00:00	DIA	ETF	175.85	175.99	175.16	175.32	980380.0

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

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