PREVIEW / etf_1hour / 2015-01-13

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-01-13.parquet
  size:    244 KB
  rows:    7,700

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-01-13 04:00:00	SPY	ETF	202.82	203.55	202.82	203.53	40670.0
2015-01-13 05:00:00	SPY	ETF	203.45	203.47	203.07	203.39	17460.0
2015-01-13 06:00:00	SPY	ETF	203.17	203.91	203.17	203.9	57671.0
2015-01-13 07:00:00	SPY	ETF	203.9	203.9	203.48	203.49	730984.0
2015-01-13 08:00:00	SPY	ETF	203.63	203.9	203.21	203.57	1630059.0
2015-01-13 09:00:00	SPY	ETF	203.57	205.42	203.56	205.34	24083395.0
2015-01-13 10:00:00	SPY	ETF	205.34	205.48	204.8899	205.16	18981291.0
2015-01-13 11:00:00	SPY	ETF	205.15	205.19	204.46	204.53	20208027.0
2015-01-13 12:00:00	SPY	ETF	204.52	204.62	203.45	203.84	17198697.0
2015-01-13 13:00:00	SPY	ETF	203.84	204.0	201.07	201.58	31501629.0
2015-01-13 14:00:00	SPY	ETF	201.585	201.82	200.51	200.89	43045623.0
2015-01-13 15:00:00	SPY	ETF	200.9	204.69	200.71	202.07	42447055.0
2015-01-13 16:00:00	SPY	ETF	202.07	202.32	201.83	202.23	13001485.0
2015-01-13 17:00:00	SPY	ETF	202.27	202.28	202.12	202.13	85697.0
2015-01-13 18:00:00	SPY	ETF	202.1	202.28	201.87	202.09	130776.0
2015-01-13 19:00:00	SPY	ETF	202.09	202.3	201.93	201.97	47714.0
2015-01-13 04:00:00	QQQ	ETF	101.73	101.73	101.73	101.73	5000.0
2015-01-13 05:00:00	QQQ	ETF	101.9	102.0	101.9	102.0	800.0
2015-01-13 06:00:00	QQQ	ETF	102.0	102.38	102.0	102.35	31950.0
2015-01-13 07:00:00	QQQ	ETF	102.31	102.34	102.19	102.2	24691.0
2015-01-13 08:00:00	QQQ	ETF	102.17	102.32	101.55	102.3	72113.0
2015-01-13 09:00:00	QQQ	ETF	102.32	103.52	102.32	103.48	6342791.0
2015-01-13 10:00:00	QQQ	ETF	103.49	103.62	103.35	103.49	4264783.0
2015-01-13 11:00:00	QQQ	ETF	103.49	103.51	103.18	103.229	3081746.0
2015-01-13 12:00:00	QQQ	ETF	103.24	103.27	102.57	102.75	3606448.0
2015-01-13 13:00:00	QQQ	ETF	102.75	102.87	101.17	101.42	7451884.0
2015-01-13 14:00:00	QQQ	ETF	101.41	101.6	100.7	100.99	8631209.0
2015-01-13 15:00:00	QQQ	ETF	100.99	101.9	100.84	101.5	13672134.0
2015-01-13 16:00:00	QQQ	ETF	101.51	103.264	101.4103	101.61	1162053.0
2015-01-13 17:00:00	QQQ	ETF	101.62	101.64	101.47	101.5	27787.0
2015-01-13 18:00:00	QQQ	ETF	101.5	101.57	101.41	101.55	6311.0
2015-01-13 19:00:00	QQQ	ETF	101.5	101.65	101.45	101.47	18325.0
2015-01-13 04:00:00	IWM	ETF	117.48	117.86	117.48	117.86	450.0
2015-01-13 06:00:00	IWM	ETF	118.07	118.07	118.07	118.07	10000.0
2015-01-13 07:00:00	IWM	ETF	118.09	118.25	117.88	117.88	23225.0
2015-01-13 08:00:00	IWM	ETF	117.97	117.97	117.17	117.87	181950.0
2015-01-13 09:00:00	IWM	ETF	117.88	119.23	117.88	119.21	6730219.0
2015-01-13 10:00:00	IWM	ETF	119.21	119.39	118.92	118.97	4932835.0
2015-01-13 11:00:00	IWM	ETF	118.97	119.0	118.05	118.18	5017175.0
2015-01-13 12:00:00	IWM	ETF	118.19	118.2578	117.41	117.765	5316115.0
2015-01-13 13:00:00	IWM	ETF	117.77	117.91	116.19	116.51	7146081.0
2015-01-13 14:00:00	IWM	ETF	116.52	116.71	115.82	116.16	5027257.0
2015-01-13 15:00:00	IWM	ETF	116.16	117.32	116.0	117.29	7510989.0
2015-01-13 16:00:00	IWM	ETF	117.3	117.48	116.9152	117.42	816016.0
2015-01-13 17:00:00	IWM	ETF	117.43	117.43	117.3	117.3	4816.0
2015-01-13 18:00:00	IWM	ETF	117.31	117.38	117.31	117.38	1041.0
2015-01-13 19:00:00	IWM	ETF	117.37	117.37	117.37	117.37	100.0
2015-01-13 08:00:00	DIA	ETF	177.0	177.22	177.0	177.22	3550.0
2015-01-13 09:00:00	DIA	ETF	177.35	179.03	177.35	178.9	1519315.0
2015-01-13 10:00:00	DIA	ETF	178.89	179.03	178.46	178.65	762770.0

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

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