PREVIEW / etf_1hour / 2013-11-14

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-14.parquet
  size:    212 KB
  rows:    6,652

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
2013-11-14 04:00:00	SPY	ETF	178.78	179.0	178.78	178.94	9992.0
2013-11-14 05:00:00	SPY	ETF	178.93	178.93	178.83	178.9	9973.0
2013-11-14 06:00:00	SPY	ETF	178.85	178.85	178.61	178.65	63991.0
2013-11-14 07:00:00	SPY	ETF	178.67	178.73	178.56	178.67	382005.0
2013-11-14 08:00:00	SPY	ETF	178.67	178.9	178.59	178.61	1358040.0
2013-11-14 09:00:00	SPY	ETF	178.6	178.75	178.3	178.56	13403263.0
2013-11-14 10:00:00	SPY	ETF	178.57	179.08	178.25	178.89	21186502.0
2013-11-14 11:00:00	SPY	ETF	178.89	179.36	178.8	178.98	15288504.0
2013-11-14 12:00:00	SPY	ETF	178.985	179.17	178.93	178.98	9283975.0
2013-11-14 13:00:00	SPY	ETF	178.98	179.19	178.96	179.13	7305861.0
2013-11-14 14:00:00	SPY	ETF	179.14	179.3	179.04	179.151	10556408.0
2013-11-14 15:00:00	SPY	ETF	179.155	179.42	179.12	179.31	17025598.0
2013-11-14 16:00:00	SPY	ETF	179.31	179.3628	179.08	179.31	5581591.0
2013-11-14 17:00:00	SPY	ETF	179.32	179.32	179.23	179.28	296333.0
2013-11-14 18:00:00	SPY	ETF	179.29	179.29	179.18	179.26	130251.0
2013-11-14 19:00:00	SPY	ETF	179.22	179.27	179.21	179.25	114683.0
2013-11-14 04:00:00	QQQ	ETF	83.43	83.43	83.3	83.4	10900.0
2013-11-14 05:00:00	QQQ	ETF	83.36	83.36	83.35	83.35	1800.0
2013-11-14 06:00:00	QQQ	ETF	83.34	83.34	83.26	83.26	66100.0
2013-11-14 07:00:00	QQQ	ETF	83.26	83.32	83.24	83.32	232024.0
2013-11-14 08:00:00	QQQ	ETF	83.32	83.42	83.26	83.27	234223.0
2013-11-14 09:00:00	QQQ	ETF	83.26	83.47	83.14	83.455	6384037.0
2013-11-14 10:00:00	QQQ	ETF	83.45	83.64	83.23	83.52	6490966.0
2013-11-14 11:00:00	QQQ	ETF	83.52	83.75	83.48	83.53	3148563.0
2013-11-14 12:00:00	QQQ	ETF	83.54	83.6	83.4401	83.54	1676517.0
2013-11-14 13:00:00	QQQ	ETF	83.54	83.67	83.5299	83.66	1486225.0
2013-11-14 14:00:00	QQQ	ETF	83.67	83.75	83.625	83.69	2294083.0
2013-11-14 15:00:00	QQQ	ETF	83.7	83.86	83.68	83.76	5148147.0
2013-11-14 16:00:00	QQQ	ETF	83.75	83.8	83.326	83.74	890669.0
2013-11-14 17:00:00	QQQ	ETF	83.55	83.79	83.55	83.77	5531.0
2013-11-14 18:00:00	QQQ	ETF	83.77	83.77	83.7	83.73	42585.0
2013-11-14 19:00:00	QQQ	ETF	83.73	83.73	83.72	83.73	2008.0
2013-11-14 07:00:00	IWM	ETF	110.66	110.66	110.57	110.64	67834.0
2013-11-14 08:00:00	IWM	ETF	110.63	110.74	110.55	110.55	207344.0
2013-11-14 09:00:00	IWM	ETF	110.54	110.6	109.948	110.04	5925517.0
2013-11-14 10:00:00	IWM	ETF	110.04	110.4	109.74	110.2	7249600.0
2013-11-14 11:00:00	IWM	ETF	110.2	110.58	110.12	110.2101	4143443.0
2013-11-14 12:00:00	IWM	ETF	110.22	110.309	109.99	110.2	2917792.0
2013-11-14 13:00:00	IWM	ETF	110.21	110.39	110.18	110.365	1096265.0
2013-11-14 14:00:00	IWM	ETF	110.371	110.538	110.325	110.4	2759964.0
2013-11-14 15:00:00	IWM	ETF	110.405	110.565	110.36	110.42	4667861.0
2013-11-14 16:00:00	IWM	ETF	110.43	110.55	110.0629	110.42	1098264.0
2013-11-14 17:00:00	IWM	ETF	110.4	110.42	110.35	110.39	38336.0
2013-11-14 18:00:00	IWM	ETF	110.39	110.39	110.39	110.39	4200.0
2013-11-14 19:00:00	IWM	ETF	110.39	110.43	110.39	110.43	5150.0
2013-11-14 04:00:00	DIA	ETF	158.4	158.4	158.4	158.4	100.0
2013-11-14 07:00:00	DIA	ETF	158.1	158.11	158.09	158.1	30300.0
2013-11-14 08:00:00	DIA	ETF	158.18	158.2	158.12	158.13	25150.0
2013-11-14 09:00:00	DIA	ETF	158.1	158.368	157.99	158.14	861510.0
2013-11-14 10:00:00	DIA	ETF	158.16	158.56	157.9499	158.48	1331031.0

> showing 50 of 6,652 rows — these rows as CSV

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