PREVIEW / etf_1hour / 2013-07-05

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-05.parquet
  size:    202 KB
  rows:    6,375

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-07-05 04:00:00	SPY	ETF	162.85	163.0	161.99	162.84	43461.0
2013-07-05 05:00:00	SPY	ETF	162.85	162.89	162.79	162.84	10200.0
2013-07-05 06:00:00	SPY	ETF	162.79	162.9	162.74	162.82	82352.0
2013-07-05 07:00:00	SPY	ETF	162.75	162.79	162.5	162.62	397915.0
2013-07-05 08:00:00	SPY	ETF	162.59	163.53	161.28	162.81	6826950.0
2013-07-05 09:00:00	SPY	ETF	162.8	162.8	162.08	162.12	22273867.0
2013-07-05 10:00:00	SPY	ETF	162.115	162.34	161.3	161.8901	21597132.0
2013-07-05 11:00:00	SPY	ETF	161.9	162.33	161.55	162.3	10579655.0
2013-07-05 12:00:00	SPY	ETF	162.29	162.53	162.26	162.4	9627796.0
2013-07-05 13:00:00	SPY	ETF	162.41	162.56	162.17	162.37	7971385.0
2013-07-05 14:00:00	SPY	ETF	162.38	162.92	162.38	162.7	11356777.0
2013-07-05 15:00:00	SPY	ETF	162.7	163.08	162.22	163.0	20005080.0
2013-07-05 16:00:00	SPY	ETF	163.0	163.36	161.3907	163.33	9661106.0
2013-07-05 17:00:00	SPY	ETF	163.34	163.37	163.23	163.32	680260.0
2013-07-05 18:00:00	SPY	ETF	163.32	163.32	163.2	163.27	51059.0
2013-07-05 19:00:00	SPY	ETF	163.24	163.4	163.24	163.37	15521.0
2013-07-05 04:00:00	QQQ	ETF	72.7	72.83	72.7	72.76	27819.0
2013-07-05 05:00:00	QQQ	ETF	72.74	72.74	72.72	72.74	1784.0
2013-07-05 06:00:00	QQQ	ETF	72.73	72.81	72.73	72.74	6739.0
2013-07-05 07:00:00	QQQ	ETF	72.73	72.73	72.65	72.67	116530.0
2013-07-05 08:00:00	QQQ	ETF	72.65	72.89	72.56	72.62	1106608.0
2013-07-05 09:00:00	QQQ	ETF	72.62	72.62	72.28	72.31	4829873.0
2013-07-05 10:00:00	QQQ	ETF	72.3	72.36	71.86	72.23	5979985.0
2013-07-05 11:00:00	QQQ	ETF	72.22	72.39	72.08	72.38	3252175.0
2013-07-05 12:00:00	QQQ	ETF	72.38	72.5	72.355	72.375	2618574.0
2013-07-05 13:00:00	QQQ	ETF	72.38	72.41	72.24	72.36	1655303.0
2013-07-05 14:00:00	QQQ	ETF	72.37	72.58	72.37	72.49	2704474.0
2013-07-05 15:00:00	QQQ	ETF	72.49	72.61	72.3	72.565	4547318.0
2013-07-05 16:00:00	QQQ	ETF	72.56	72.72	72.0947	72.68	1680300.0
2013-07-05 17:00:00	QQQ	ETF	72.68	72.71	72.67	72.67	7311.0
2013-07-05 18:00:00	QQQ	ETF	72.67	72.67	72.67	72.67	400.0
2013-07-05 19:00:00	QQQ	ETF	72.74	72.74	72.74	72.74	100.0
2013-07-05 04:00:00	IWM	ETF	99.26	99.41	99.26	99.41	350.0
2013-07-05 06:00:00	IWM	ETF	99.47	99.48	99.43	99.44	16600.0
2013-07-05 07:00:00	IWM	ETF	99.4	99.4	99.25	99.34	55179.0
2013-07-05 08:00:00	IWM	ETF	99.32	99.85	99.22	99.5	509846.0
2013-07-05 09:00:00	IWM	ETF	99.46	99.46	98.78	98.9	4375212.0
2013-07-05 10:00:00	IWM	ETF	98.9	99.06	98.31	98.82	5379773.0
2013-07-05 11:00:00	IWM	ETF	98.82	98.99	98.59	98.98	2421171.0
2013-07-05 12:00:00	IWM	ETF	98.97	99.08	98.92	99.07	1965228.0
2013-07-05 13:00:00	IWM	ETF	99.08	99.23	98.97	99.18	2455613.0
2013-07-05 14:00:00	IWM	ETF	99.18	99.42	99.14	99.27	2589398.0
2013-07-05 15:00:00	IWM	ETF	99.26	99.75	99.06	99.69	6010194.0
2013-07-05 16:00:00	IWM	ETF	99.69	99.85	99.65	99.72	1679004.0
2013-07-05 17:00:00	IWM	ETF	99.8	99.8	99.75	99.78	850.0
2013-07-05 18:00:00	IWM	ETF	99.78	99.78	99.78	99.78	400.0
2013-07-05 19:00:00	IWM	ETF	99.71	99.78	99.68	99.78	1628.0
2013-07-05 04:00:00	DIA	ETF	150.85	150.85	150.85	150.85	100.0
2013-07-05 05:00:00	DIA	ETF	150.95	150.95	150.95	150.95	100.0
2013-07-05 08:00:00	DIA	ETF	150.75	151.35	150.74	151.03	68018.0

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

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