PREVIEW / etf_1hour / 2013-06-28

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-28.parquet
  size:    212 KB
  rows:    6,641

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-06-28 04:00:00	SPY	ETF	161.64	161.67	161.48	161.62	8840.0
2013-06-28 05:00:00	SPY	ETF	161.55	161.81	161.52	161.63	52300.0
2013-06-28 06:00:00	SPY	ETF	161.61	161.64	161.31	161.38	38476.0
2013-06-28 07:00:00	SPY	ETF	161.35	161.64	161.24	161.58	329064.0
2013-06-28 08:00:00	SPY	ETF	161.6	161.6	160.81	160.94	2124470.0
2013-06-28 09:00:00	SPY	ETF	160.94	160.95	159.981	160.021	19639769.0
2013-06-28 10:00:00	SPY	ETF	160.02	161.055	159.86	160.95	23563633.0
2013-06-28 11:00:00	SPY	ETF	160.955	161.39	160.82	161.13	17710036.0
2013-06-28 12:00:00	SPY	ETF	161.12	161.14	160.49	160.87	11853990.0
2013-06-28 13:00:00	SPY	ETF	160.86	161.28	160.75	161.22	9056423.0
2013-06-28 14:00:00	SPY	ETF	161.22	161.4	160.99	161.12	16119376.0
2013-06-28 15:00:00	SPY	ETF	161.12	161.37	160.07	160.2	36477174.0
2013-06-28 16:00:00	SPY	ETF	160.19	161.1168	159.94	160.16	15044554.0
2013-06-28 17:00:00	SPY	ETF	160.17	160.27	160.05	160.13	4415818.0
2013-06-28 18:00:00	SPY	ETF	160.13	160.25	160.13	160.19	27041.0
2013-06-28 19:00:00	SPY	ETF	160.17	160.28	159.99	160.2	217762.0
2013-06-28 04:00:00	QQQ	ETF	71.33	71.46	71.33	71.42	16000.0
2013-06-28 05:00:00	QQQ	ETF	71.4	71.44	71.38	71.38	7300.0
2013-06-28 06:00:00	QQQ	ETF	71.36	71.36	71.24	71.25	7200.0
2013-06-28 07:00:00	QQQ	ETF	71.24	71.38	71.22	71.38	22700.0
2013-06-28 08:00:00	QQQ	ETF	71.36	71.36	71.04	71.09	39869.0
2013-06-28 09:00:00	QQQ	ETF	71.08	71.1899	70.86	70.89	4367224.0
2013-06-28 10:00:00	QQQ	ETF	70.89	71.36	70.79	71.32	5446078.0
2013-06-28 11:00:00	QQQ	ETF	71.31	71.53	71.25	71.35	3513203.0
2013-06-28 12:00:00	QQQ	ETF	71.35	71.365	71.11	71.27	2086907.0
2013-06-28 13:00:00	QQQ	ETF	71.275	71.55	71.23	71.52	1701435.0
2013-06-28 14:00:00	QQQ	ETF	71.52	71.65	71.44	71.485	2779916.0
2013-06-28 15:00:00	QQQ	ETF	71.48	71.69	71.22	71.22	6332216.0
2013-06-28 16:00:00	QQQ	ETF	71.2	71.28	71.051	71.18	1882111.0
2013-06-28 17:00:00	QQQ	ETF	71.2	71.22	71.15	71.15	34200.0
2013-06-28 18:00:00	QQQ	ETF	71.25	71.25	71.13	71.16	4076.0
2013-06-28 19:00:00	QQQ	ETF	71.16	71.72	71.14	71.25	7240.0
2013-06-28 04:00:00	IWM	ETF	97.81	97.99	97.81	97.99	248.0
2013-06-28 06:00:00	IWM	ETF	97.87	97.88	97.87	97.88	3000.0
2013-06-28 07:00:00	IWM	ETF	97.86	98.01	97.8	97.98	87578.0
2013-06-28 08:00:00	IWM	ETF	97.96	97.99	97.53	97.61	258224.0
2013-06-28 09:00:00	IWM	ETF	97.62	97.63	97.1	97.12	5009356.0
2013-06-28 10:00:00	IWM	ETF	97.13	97.68	97.07	97.62	6194772.0
2013-06-28 11:00:00	IWM	ETF	97.62	97.9	97.551	97.66	3539801.0
2013-06-28 12:00:00	IWM	ETF	97.66	97.67	97.33	97.54	2277100.0
2013-06-28 13:00:00	IWM	ETF	97.54	97.88	97.46	97.83	2202681.0
2013-06-28 14:00:00	IWM	ETF	97.83	97.96	97.76	97.84	3080667.0
2013-06-28 15:00:00	IWM	ETF	97.83	97.92	96.85	97.0	15211530.0
2013-06-28 16:00:00	IWM	ETF	97.0	97.87	96.41	97.05	6364622.0
2013-06-28 17:00:00	IWM	ETF	97.05	97.07	96.96	96.99	57102.0
2013-06-28 18:00:00	IWM	ETF	96.99	97.05	96.99	97.04	1748.0
2013-06-28 19:00:00	IWM	ETF	97.0	97.08	96.99	97.08	4150.0
2013-06-28 07:00:00	DIA	ETF	149.99	150.1	149.99	150.1	1800.0
2013-06-28 08:00:00	DIA	ETF	150.14	150.14	149.5	149.5	9600.0
2013-06-28 09:00:00	DIA	ETF	149.4	149.48	148.68	148.69	839034.0

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

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