PREVIEW / etf_1hour / 2015-04-24

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-24.parquet
  size:    238 KB
  rows:    7,627

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-04-24 04:00:00	SPY	ETF	211.25	211.8	211.25	211.72	94228.0
2015-04-24 05:00:00	SPY	ETF	211.74	211.74	211.34	211.37	43073.0
2015-04-24 06:00:00	SPY	ETF	211.35	211.49	211.04	211.44	32208.0
2015-04-24 07:00:00	SPY	ETF	211.41	211.6	211.29	211.45	126830.0
2015-04-24 08:00:00	SPY	ETF	211.5	211.65	211.24	211.6	921958.0
2015-04-24 09:00:00	SPY	ETF	211.59	211.78	211.12	211.54	9826653.0
2015-04-24 10:00:00	SPY	ETF	211.54	211.59	211.11	211.5	6697249.0
2015-04-24 11:00:00	SPY	ETF	211.5	211.79	211.42	211.635	6073626.0
2015-04-24 12:00:00	SPY	ETF	211.63	211.97	211.62	211.73	4875690.0
2015-04-24 13:00:00	SPY	ETF	211.73	211.87	211.59	211.74	3593045.0
2015-04-24 14:00:00	SPY	ETF	211.75	211.82	211.41	211.49	6655958.0
2015-04-24 15:00:00	SPY	ETF	211.49	211.71	211.43	211.65	12330212.0
2015-04-24 16:00:00	SPY	ETF	211.64	211.74	211.152	211.72	8068721.0
2015-04-24 17:00:00	SPY	ETF	211.72	211.78	211.62	211.67	1363821.0
2015-04-24 18:00:00	SPY	ETF	211.67	211.9	211.64	211.65	18495.0
2015-04-24 19:00:00	SPY	ETF	211.62	211.7	211.62	211.69	27707.0
2015-04-24 04:00:00	QQQ	ETF	109.83	110.11	109.83	110.11	2200.0
2015-04-24 05:00:00	QQQ	ETF	110.06	110.19	110.01	110.01	58500.0
2015-04-24 06:00:00	QQQ	ETF	109.96	110.08	109.91	110.02	202146.0
2015-04-24 07:00:00	QQQ	ETF	110.02	110.1	109.91	110.05	154605.0
2015-04-24 08:00:00	QQQ	ETF	110.05	110.15	109.97	110.12	276090.0
2015-04-24 09:00:00	QQQ	ETF	110.11	110.4	110.07	110.32	7285065.0
2015-04-24 10:00:00	QQQ	ETF	110.31	110.4	110.03	110.36	4117910.0
2015-04-24 11:00:00	QQQ	ETF	110.35	110.529	110.29	110.47	2383932.0
2015-04-24 12:00:00	QQQ	ETF	110.47	110.69	110.45	110.52	2520516.0
2015-04-24 13:00:00	QQQ	ETF	110.52	110.62	110.43	110.46	2143677.0
2015-04-24 14:00:00	QQQ	ETF	110.46	110.68	110.45	110.5201	2485602.0
2015-04-24 15:00:00	QQQ	ETF	110.52	110.615	110.445	110.51	5310461.0
2015-04-24 16:00:00	QQQ	ETF	110.51	110.56	110.46	110.54	1429216.0
2015-04-24 17:00:00	QQQ	ETF	110.55	110.57	110.55	110.57	33924.0
2015-04-24 18:00:00	QQQ	ETF	110.56	110.58	110.54	110.569	3107.0
2015-04-24 19:00:00	QQQ	ETF	110.55	110.57	110.55	110.56	4077.0
2015-04-24 07:00:00	IWM	ETF	126.35	126.35	126.23	126.3	44115.0
2015-04-24 08:00:00	IWM	ETF	126.289	126.4	126.19	126.38	50398.0
2015-04-24 09:00:00	IWM	ETF	126.36	126.46	126.04	126.26	2009714.0
2015-04-24 10:00:00	IWM	ETF	126.26	126.29	125.87	126.27	2149052.0
2015-04-24 11:00:00	IWM	ETF	126.27	126.34	126.075	126.095	1175954.0
2015-04-24 12:00:00	IWM	ETF	126.095	126.14	125.94	125.96	885212.0
2015-04-24 13:00:00	IWM	ETF	125.97	126.07	125.905	126.01	740499.0
2015-04-24 14:00:00	IWM	ETF	126.0199	126.07	125.775	125.79	1488937.0
2015-04-24 15:00:00	IWM	ETF	125.78	125.94	125.69	125.86	4239492.0
2015-04-24 16:00:00	IWM	ETF	125.85	126.3033	125.78	125.81	1241546.0
2015-04-24 17:00:00	IWM	ETF	125.81	125.84	125.81	125.84	4418.0
2015-04-24 07:00:00	DIA	ETF	180.46	180.46	180.35	180.35	1200.0
2015-04-24 08:00:00	DIA	ETF	180.41	180.55	180.34	180.55	9335.0
2015-04-24 09:00:00	DIA	ETF	180.57	180.63	179.7901	180.32	691434.0
2015-04-24 10:00:00	DIA	ETF	180.33	180.45	179.97	180.29	413172.0
2015-04-24 11:00:00	DIA	ETF	180.3	180.63	180.24	180.4172	312610.0
2015-04-24 12:00:00	DIA	ETF	180.44	180.82	180.44	180.59	335941.0
2015-04-24 13:00:00	DIA	ETF	180.59	180.71	180.48	180.64	209672.0

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

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