PREVIEW / etf_1hour / 2013-12-12

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-12.parquet
  size:    214 KB
  rows:    6,708

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-12-12 04:00:00	SPY	ETF	178.8	178.9	178.77	178.84	38449.0
2013-12-12 05:00:00	SPY	ETF	178.84	178.85	178.4	178.54	31112.0
2013-12-12 06:00:00	SPY	ETF	178.49	178.5	178.31	178.37	89396.0
2013-12-12 07:00:00	SPY	ETF	178.37	178.56	178.36	178.55	1257165.0
2013-12-12 08:00:00	SPY	ETF	178.55	178.95	178.36	178.92	3820854.0
2013-12-12 09:00:00	SPY	ETF	178.93	178.93	178.29	178.45	15850178.0
2013-12-12 10:00:00	SPY	ETF	178.45	178.64	178.08	178.46	15630666.0
2013-12-12 11:00:00	SPY	ETF	178.46	178.7894	178.22	178.26	9992546.0
2013-12-12 12:00:00	SPY	ETF	178.26	178.35	177.76	178.028	13023705.0
2013-12-12 13:00:00	SPY	ETF	178.02	178.449	178.0	178.33	7453925.0
2013-12-12 14:00:00	SPY	ETF	178.33	178.84	178.32	178.7201	9787473.0
2013-12-12 15:00:00	SPY	ETF	178.73	178.745	178.03	178.18	25264759.0
2013-12-12 16:00:00	SPY	ETF	178.17	178.7816	177.93	177.94	8256584.0
2013-12-12 17:00:00	SPY	ETF	177.95	178.7816	177.88	177.94	2147561.0
2013-12-12 18:00:00	SPY	ETF	177.95	178.14	177.93	178.04	237033.0
2013-12-12 19:00:00	SPY	ETF	178.01	178.11	177.98	178.04	50403.0
2013-12-12 04:00:00	QQQ	ETF	85.32	85.32	85.25	85.26	12700.0
2013-12-12 05:00:00	QQQ	ETF	85.28	85.28	85.1	85.13	5800.0
2013-12-12 06:00:00	QQQ	ETF	85.16	85.16	85.1	85.11	27400.0
2013-12-12 07:00:00	QQQ	ETF	85.11	85.17	85.1	85.17	159655.0
2013-12-12 08:00:00	QQQ	ETF	85.17	85.37	85.11	85.32	1425290.0
2013-12-12 09:00:00	QQQ	ETF	85.33	85.4201	85.08	85.195	5559471.0
2013-12-12 10:00:00	QQQ	ETF	85.18	85.38	85.02	85.3	5197954.0
2013-12-12 11:00:00	QQQ	ETF	85.3	85.4	85.07	85.07	2429872.0
2013-12-12 12:00:00	QQQ	ETF	85.06	85.14	84.9	85.055	4122071.0
2013-12-12 13:00:00	QQQ	ETF	85.055	85.23	85.03	85.18	1919359.0
2013-12-12 14:00:00	QQQ	ETF	85.18	85.34	85.15	85.286	3056079.0
2013-12-12 15:00:00	QQQ	ETF	85.29	85.3	84.95	84.99	5245357.0
2013-12-12 16:00:00	QQQ	ETF	84.98	85.306	84.85	84.86	1244137.0
2013-12-12 17:00:00	QQQ	ETF	84.87	85.1845	84.86	84.92	604687.0
2013-12-12 18:00:00	QQQ	ETF	84.89	85.0	84.89	85.0	23712.0
2013-12-12 19:00:00	QQQ	ETF	84.95	84.99	84.95	84.96	7000.0
2013-12-12 06:00:00	IWM	ETF	109.64	109.64	109.46	109.46	2100.0
2013-12-12 07:00:00	IWM	ETF	109.49	109.67	109.49	109.61	17360.0
2013-12-12 08:00:00	IWM	ETF	109.64	109.88	109.38	109.88	292962.0
2013-12-12 09:00:00	IWM	ETF	109.86	109.87	109.4	109.53	5732608.0
2013-12-12 10:00:00	IWM	ETF	109.52	109.945	109.36	109.78	5858476.0
2013-12-12 11:00:00	IWM	ETF	109.78	110.08	109.74	109.91	3715896.0
2013-12-12 12:00:00	IWM	ETF	109.91	109.91	109.38	109.58	4392834.0
2013-12-12 13:00:00	IWM	ETF	109.575	109.9166	109.57	109.89	2477329.0
2013-12-12 14:00:00	IWM	ETF	109.9	110.2455	109.88	110.18	3535954.0
2013-12-12 15:00:00	IWM	ETF	110.19	110.225	109.62	109.8	6052520.0
2013-12-12 16:00:00	IWM	ETF	109.8	109.84	109.61	109.64	977052.0
2013-12-12 17:00:00	IWM	ETF	109.62	109.75	109.61	109.62	1500.0
2013-12-12 18:00:00	IWM	ETF	109.74	109.75	109.61	109.75	19485.0
2013-12-12 07:00:00	DIA	ETF	158.16	158.16	158.16	158.16	5000.0
2013-12-12 08:00:00	DIA	ETF	158.2	158.57	158.17	158.54	52712.0
2013-12-12 09:00:00	DIA	ETF	158.41	158.43	157.68	157.87	1231093.0
2013-12-12 10:00:00	DIA	ETF	157.85	157.95	157.48	157.738	1173440.0
2013-12-12 11:00:00	DIA	ETF	157.74	158.008	157.56	157.6	559694.0

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

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