PREVIEW / etf_1hour / 2013-11-15

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-15.parquet
  size:    210 KB
  rows:    6,657

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-15 04:00:00	SPY	ETF	179.4	179.5	179.15	179.48	33113.0
2013-11-15 05:00:00	SPY	ETF	179.49	179.69	179.49	179.64	16210.0
2013-11-15 06:00:00	SPY	ETF	179.62	179.78	179.61	179.69	121570.0
2013-11-15 07:00:00	SPY	ETF	179.7	179.78	179.61	179.71	264144.0
2013-11-15 08:00:00	SPY	ETF	179.69	179.73	179.58	179.64	791890.0
2013-11-15 09:00:00	SPY	ETF	179.65	179.7	179.33	179.5401	17374992.0
2013-11-15 10:00:00	SPY	ETF	179.54	179.67	179.38	179.6	15088491.0
2013-11-15 11:00:00	SPY	ETF	179.59	179.72	179.33	179.41	9783418.0
2013-11-15 12:00:00	SPY	ETF	179.4101	179.54	179.36	179.38	5796286.0
2013-11-15 13:00:00	SPY	ETF	179.389	179.69	179.38	179.5953	4998982.0
2013-11-15 14:00:00	SPY	ETF	179.59	179.79	179.59	179.735	5396879.0
2013-11-15 15:00:00	SPY	ETF	179.74	180.07	179.7	180.06	22886682.0
2013-11-15 16:00:00	SPY	ETF	180.06	180.12	179.3079	179.91	12672745.0
2013-11-15 17:00:00	SPY	ETF	179.9	179.94	179.89	179.92	206076.0
2013-11-15 18:00:00	SPY	ETF	179.92	179.92	179.82	179.9	40731.0
2013-11-15 19:00:00	SPY	ETF	179.87	179.9	179.87	179.9	20850.0
2013-11-15 04:00:00	QQQ	ETF	83.86	83.9	83.71	83.87	12600.0
2013-11-15 05:00:00	QQQ	ETF	83.89	83.93	83.89	83.93	4400.0
2013-11-15 06:00:00	QQQ	ETF	83.91	83.97	83.91	83.93	10710.0
2013-11-15 07:00:00	QQQ	ETF	83.95	83.95	83.83	83.87	26678.0
2013-11-15 08:00:00	QQQ	ETF	83.85	83.87	83.72	83.84	65980.0
2013-11-15 09:00:00	QQQ	ETF	83.84	83.86	83.61	83.75	3428877.0
2013-11-15 10:00:00	QQQ	ETF	83.75	83.85	83.69	83.75	4300138.0
2013-11-15 11:00:00	QQQ	ETF	83.75	83.86	83.64	83.68	1951637.0
2013-11-15 12:00:00	QQQ	ETF	83.69	83.77	83.65	83.6865	1093692.0
2013-11-15 13:00:00	QQQ	ETF	83.689	83.85	83.68	83.779	1605427.0
2013-11-15 14:00:00	QQQ	ETF	83.775	83.88	83.77	83.8399	1394172.0
2013-11-15 15:00:00	QQQ	ETF	83.8349	83.96	83.81	83.95	4482936.0
2013-11-15 16:00:00	QQQ	ETF	83.96	83.97	83.7234	83.88	956559.0
2013-11-15 17:00:00	QQQ	ETF	83.94	83.94	83.92	83.93	1300.0
2013-11-15 18:00:00	QQQ	ETF	83.93	83.94	83.93	83.94	3524.0
2013-11-15 07:00:00	IWM	ETF	110.63	110.72	110.59	110.7	190000.0
2013-11-15 08:00:00	IWM	ETF	110.68	110.69	110.6	110.66	39318.0
2013-11-15 09:00:00	IWM	ETF	110.65	110.72	110.18	110.28	3423994.0
2013-11-15 10:00:00	IWM	ETF	110.28	110.53	110.16	110.42	3345590.0
2013-11-15 11:00:00	IWM	ETF	110.42	110.71	110.41	110.5	3290228.0
2013-11-15 12:00:00	IWM	ETF	110.5	110.625	110.45	110.5	1638710.0
2013-11-15 13:00:00	IWM	ETF	110.499	110.69	110.499	110.59	1270222.0
2013-11-15 14:00:00	IWM	ETF	110.585	110.78	110.57	110.76	2159730.0
2013-11-15 15:00:00	IWM	ETF	110.77	110.99	110.7501	110.91	7116825.0
2013-11-15 16:00:00	IWM	ETF	110.92	110.98	110.2698	110.92	1094122.0
2013-11-15 17:00:00	IWM	ETF	110.9	110.9	110.88	110.88	19165.0
2013-11-15 18:00:00	IWM	ETF	110.93	110.93	110.93	110.93	100.0
2013-11-15 19:00:00	IWM	ETF	110.92	110.92	110.92	110.92	100.0
2013-11-15 07:00:00	DIA	ETF	158.75	158.77	158.75	158.77	880.0
2013-11-15 08:00:00	DIA	ETF	158.7	158.71	158.68	158.68	6101.0
2013-11-15 09:00:00	DIA	ETF	158.69	158.795	158.48	158.79	745765.0
2013-11-15 10:00:00	DIA	ETF	158.79	158.92	158.65	158.91	824748.0
2013-11-15 11:00:00	DIA	ETF	158.9101	158.98	158.75	158.82	745316.0
2013-11-15 12:00:00	DIA	ETF	158.82	158.92	158.76	158.79	671420.0

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

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